Select count(products.products_id) as count, products.products_id, products_description.products_name from boardsto_osc.orders_products left join boardsto_osc.orders using (orders_id) left join boardsto_osc.products on orders_products.products_id = products.products_id left join boardsto_osc.products_description on products.products_id = products_description.products_id WHERE products.products_status = 1 AND products.products_ordered > 0 AND orders.date_purchased > '1969-11-30 18:59:59' AND orders.date_purchased < '2024-05-09 00:00:00' GROUP BY products.products_id ORDER BY count DESC LIMIT 7