SELECT DISTINCT p.products_id, p.products_ordered, pd.products_name, pd.products_seo_url
FROM products p
LEFT JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = '1'
RIGHT JOIN products_to_categories ptc ON ptc.products_id = p.products_id
RIGHT JOIN categories c ON c.categories_id = ptc.categories_id AND c.categories_status = '1'
RIGHT JOIN orders_products op ON op.products_id = p.products_id
RIGHT JOIN orders o ON o.orders_id = op.orders_id AND o.date_purchased > '2020-09-04 02:40:43'
WHERE p.products_status = '1' and p.listing_status = '0' AND p.products_ordered > 0 and ( (p.customers_group_id = '0' or p.customers_group_id = '' ) ) ORDER BY p.products_ordered DESC LIMIT 200
