select DATE_FORMAT(a.active_start_time, "%Y%m%d") preorder_date ,CONCAT(DATE_FORMAT(a.active_start_time, "%m"),"/",DATE_FORMAT(a.active_start_time, "%d")) str_date, a.*,b.products_name,b.preorder_description2,c.products_image,c.products_thumbnail from wdb_products_set_active_price a, wdb_products_description b, wdb_products c where a.status = 1 and a.active_type = 1 and a.site_id = "3" and a.currency_code = "USD" and (a.active_start_time <= "2026-08-10 20:38:20" and a.active_end_time >= "2026-08-10 20:38:20" or a.active_start_time > "2026-08-10 20:38:20") and a.products_id = b.products_id and b.products_id = c.products_id and b.site_id = "3" and b.languages_id = "1" and b.is_enabled = 1 and c.is_enabled = 1 order by preorder_date asc, a.sort desc,a.active_start_time asc,a.active_end_time asc