fireflymantis

stats_orders_per_companySELECT  a.entry_company co_name, count(p.products_quantity) f1num, sum(p.products_quantity * p.final_price) f1amtFROM    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_idWHERE   o.date_purchased BETWEEN        '$year-01-01' AND '$year-03-31'GROUP BY co_namestats_products_per_companySELECT  p.products_name prod_name, count(p.products_quantity) f1num, sum(p.products_quantity * p.final_price) f1amtFROM    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_idWHERE   o.date_purchased BETWEEN '$year-01-01' AND '$year-03-31'        AND entry_company = '$co'GROUP BY prod_name