SELECT * from tbl_order where (date_ordered BETWEEN '2019-04-01 00:00:00' AND '2025-12-10 04:11:19') AND orders_status IN('Order Closed' ,'Confirmed') order by orders_id desc