SELECT SUM(main_table.total_revenue_amount) AS `revenue`, SUM(main_table.total_tax_amount_actual) AS `tax`, SUM(main_table.total_shipping_amount_actual) AS `shipping`, SUM(orders_count) AS `quantity` FROM `sales_order_aggregated_created` AS `main_table` WHERE (`period` >= '2018-01-01 00:00:00' AND `period` <= '2019-11-22 23:59:59') AND (`store_id` = '1') AND (main_table.order_status NOT IN('Zrušená objednávka'))