+------------------------------------+----------+------------+------------------------------------------------------------+-------------------------------------------------------------+--------------------------------------------------------------+---------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------+ | commerce_order_created_granularity | order_id | order_id_1 | field_data_commerce_order_total_commerce_order_entity_type | field_data_commerce_order_total_commerce_order_total_amount | field_data_commerce_order_total_commerce_order_total_currenc | field_data_commerce_order_total_commerce_order_total_amount_1 | field_data_commerce_order_total_commerce_order_total_currenc_1 | view_name | +------------------------------------+----------+------------+------------------------------------------------------------+-------------------------------------------------------------+--------------------------------------------------------------+---------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------+ | 1317517890 | 9944 | 1342074 | commerce_order | 5809093 | 0 | 584.1807 | 0 | commerce_reports_sales:chart_year | | 1320130871 | 10977 | 1352116 | commerce_order | 8125329 | 0 | 740.2140 | 0 | commerce_reports_sales:chart_year | | 1322723018 | 14370 | 1363261 | commerce_order | 7661760 | 0 | 533.1775 | 0 | commerce_reports_sales:chart_year | | 1325401495 | 13745 | 1378089 | commerce_order | 8068177 | 0 | 586.9900 | 0 | commerce_reports_sales:chart_year | | 1328079926 | 14684 | 1391936 | commerce_order | 8825674 | 0 | 601.0402 | 0 | commerce_reports_sales:chart_year | | 1330585634 | 13092 | 1406765 | commerce_order | 7896846 | 0 | 603.1810 | 0 | commerce_reports_sales:chart_year | | 1333263645 | 12080 | 1420751 | commerce_order | 8298952 | 0 | 686.9993 | 0 | commerce_reports_sales:chart_year | | 1335856138 | 11032 | 1433160 | commerce_order | 9046479 | 0 | 820.0217 | 0 | commerce_reports_sales:chart_year | | 1338534057 | 7791 | 1445173 | commerce_order | 5203896 | 0 | 667.9369 | 0 | commerce_reports_sales:chart_year | | 1341126039 | 13044 | 1453176 | commerce_order | 10335130 | 0 | 792.3283 | 0 | commerce_reports_sales:chart_year | | 1343805453 | 11022 | 1466393 | commerce_order | 9121265 | 0 | 827.5508 | 0 | commerce_reports_sales:chart_year | | 1346482807 | 6307 | 1477647 | commerce_order | 5153487 | 0 | 817.1059 | 0 | commerce_reports_sales:chart_year | +------------------------------------+----------+------------+------------------------------------------------------------+-------------------------------------------------------------+--------------------------------------------------------------+---------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------+ 12 rows in set, 65535 warnings (1.68 sec)