future asset date1:2025-05-12 22:00:00 date2:2025-05-19 23:59:59 sql1 SELECT start_time FROM wpaptn_asset_schedule WHERE series_id LIKE '378064%' AND channel IN ('HD','NORTH') order by start_time LIMIT 0,1 sql SELECT t1.*,t2.languagefullname FROM wpaptn_asset_schedule AS t1 INNER JOIN
wpaptn_mam_language as t2 ON t1.language=t2.code
WHERE t1.start_time >= '2025-05-12 22:00:00' AND t1.start_time<='2025-05-19 23:59:59' AND
SUBSTRING_INDEX(t1.series_id,'-',1)=378064 AND t1.channel IN ('HD','NORTH') order by t1.start_time 1
