fireflymantis

stats_orders_per_company 2 quartersSELECT  a.entry_company AS co_name,        SUM(CASE WHEN o.date_purchased BETWEEN '$year-01-01' AND '$year-03-31' THEN 1 ELSE 0 END) AS  f1num,        SUM(CASE WHEN o.date_purchased BETWEEN '$year-01-01' AND '$year-03-31' THEN p.products_quantity * p.final_price ELSE 0 END) AS  f1amt,        SUM(CASE WHEN o.date_purchased BETWEEN '$year-04-01' AND '$year-06-30' THEN 1 ELSE 0 END) AS  f2num,        SUM(CASE WHEN o.date_purchased BETWEEN '$year-04-01' AND '$year-06-30' THEN p.products_quantity * p.final_price ELSE 0 END) AS  f2amtFROM    zen_address_book AS a        INNER JOIN zen_orders as o ON a.customers_id = o.customers_id        LEFT JOIN zen_orders_products as p ON o.orders_id = p.orders_idWHERE   o.date_purchased BETWEEN '$year-01-01' AND '$year-12-31'GROUP BY co_name