stats_orders_per_company

SELECT  a.entry_company co_name, count(p.products_quantity) f1num, sum(p.products_quantity * p.final_price) f1amt
FROM    zen_address_book as a
        LEFT 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-03-31'
GROUP BY co_name

stats_products_per_company

SELECT  p.products_name prod_name, count(p.products_quantity) f1num, sum(p.products_quantity * p.final_price) f1amt
FROM    zen_orders_products as p
        INNER JOIN zen_orders as o ON p.orders_id = o.orders_id
        INNER JOIN zen_address_book as a ON o.customers_id = a.customers_id
WHERE   o.date_purchased BETWEEN '$year-01-01' AND '$year-03-31'
        AND entry_company = '$co'
GROUP BY prod_name