Unknown column 'bc.EpisodeTitle' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS
`bc`.`BroadcastID`,
`bc`.`NextBroadcastID`,
CASE WHEN `ebc`.`Title` > '' THEN `ebc`.`Title` ELSE `bc`.`Title` END AS `Title`,
CASE WHEN `ebc`.`Pic` > '' THEN `ebc`.`Pic` ELSE
CASE
WHEN `bc`.`Pic` IS NOT NULL THEN `bc`.`Pic`
ELSE NULL
END
END AS `Pic`,
CASE WHEN `ebc`.`ShortText` > '' THEN `ebc`.`ShortText` ELSE `bc`.`ShortText` END AS `ShortText`,
`bc`.`Episode`,
`bc`.`EpisodeTitle`,
`bc`.`Valuation`,
`bc`.`Director`,
`bc`.`Tip`,
`bc`.`IsStereo`,
`bc`.`IsDolby`,
`bc`.`IsVideotextSub`,
`bc`.`IsLive`,
`bc`.`IsWideScreen`,
`bc`.`IsBlackAndWhite`,
`bc`.`IsDolbyDig`,
`bc`.`IsDualChannel`,
`bc`.`IsAudioComment`,
`bc`.`IsHDTV`,
`bc`.`IsRebroadcast`,
`bc`.`isSeries`,
`bc`.`isNew`,
`bc`.`isNewEpisode`,
`bc`.`isNewSeason`,
`bc`.`Fsk`,
CASE
WHEN (`bc`.`StartDate` < NOW() AND `bc`.`EndDate` > NOW())
THEN TRUE
ELSE FALSE
END AS `isRunning`,
CASE
WHEN (`bc`.`StartDate` < NOW() AND `bc`.`EndDate` > NOW())
THEN TIMESTAMPDIFF(SECOND, TIMESTAMP(`bc`.`StartDate`), CURRENT_TIMESTAMP()) * 100.0 / (`bc`.`Duration` * 60.0)
ELSE 0
END AS `progress`,
CASE
WHEN (`bc`.`StartDate` < NOW() AND `bc`.`EndDate` > NOW())
THEN TIMESTAMPDIFF(MINUTE, TIMESTAMP(`bc`.`StartDate`), CURRENT_TIMESTAMP())
ELSE 0
END AS `progressMinutes`,
DATE_FORMAT(`bc`.`StartDate`, '%d.%m.') AS `date`,
DATE_FORMAT(`bc`.`StartDate`, '%H:%i') AS `startTime`,
UNIX_TIMESTAMP(`bc`.`StartDate`) AS `timestamp`,
DATE_FORMAT(`bc`.`EndDate`, '%H:%i') AS `endTime`,
`bc`.`Year`,
`bc`.`Country`,
`s`.`StationName`,
`s`.`StationShortname`,
`bc`.`StationID`,
`s`.`IconName`,
`bc`.`SubTitle` AS `genre`,
`bck`.`Rating`
FROM `epg`.`epg_broadcast` `bc`
INNER JOIN `epg`.`epg_station` `s` ON `s`.`StationID`=`bc`.`StationID`
INNER JOIN `epg`.`epg_station_type` `st` ON `st`.`StationTypeID` = `s`.`StationTypeID`
LEFT JOIN `epg`.`epg_bridge_broadcast_printcategory` `bbpc` ON `bc`.`BroadcastID` = `bbpc`.`BroadcastID` AND `bbpc`.`RulePrefixID` = 3
LEFT JOIN `epg`.`epg_print_category` `pc` ON `bbpc`.`CategoryID` = `pc`.`PrintCategoryID`
LEFT JOIN `epg`.`epg_broadcast_tvdirekt` `bck` ON `bck`.`BroadCastID` = `bc`.`BroadcastID`
LEFT JOIN `epg`.`epg_editorial_broadcast` AS `ebc` ON `ebc`.`BroadcastID` = `bc`.`BroadcastID` WHERE 1 AND `bc`.`StartDate` <= CONCAT('2024-05-11 ', DATE_FORMAT(NOW(),'%H:%i:%s')) AND `bc`.`EndDate` > CONCAT('2024-05-11 ', DATE_FORMAT(NOW(),'%H:%i:%s')) AND `s`.`StationTypeID`=3 ORDER BY `st`.`SortOrder`, `s`.`SortOrder`, `bc`.`StartDate` LIMIT 0, 20
Es wurden keine passenden Sendungen im gewählten Zeitraum (Jetzt) gefunden.