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 >= '2026-06-01 00:00:00' AND t1.start_time<='2026-06-07 23:59:59' AND
SUBSTRING_INDEX(t1.series_id,'-',1)=378015 AND t1.channel IN ('HD','NORTH') order by t1.start_time
result: 0
future asset date1: date2:2026-06-10 23:59:59
sql1 SELECT start_time FROM wpaptn_asset_schedule WHERE series_id LIKE '378015%' AND channel IN ('HD','NORTH') AND start_time >= '2026-06-01 00:00:00' AND start_time<='2026-06-07 23:59:59' order by start_time LIMIT 0,1