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