AbanteCart – join orders with order_products

SELECT *
FROM example_orders
JOIN example_order_products ON example_orders.order_id = example_order_products.order_id
WHERE DATE_FORMAT(example_orders.date_added, '%Y-%m') = '2024-01';

 

(replace example_ with your db_)