stats_orders_per_company 2 quarters

SELECT  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  f2amt
FROM    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_id
WHERE   o.date_purchased BETWEEN '$year-01-01' AND '$year-12-31'
GROUP BY co_name