exec_SELECTquery
caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
ERROR You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-880, 9' at line 22
lastBuiltQuery SELECT DISTINCT SQL_CALC_FOUND_ROWS tx_amsmedialibrary_episodes.uid, tx_amsmedialibrary_episodes.plays/
((UNIX_TIMESTAMP() - IF(tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_start_time > 0, tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_start_time, IF(tx_amsmedialibrary_episodes.tx_amsbroadcast_first_air_date > 0, tx_amsmedialibrary_episodes.tx_amsbroadcast_first_air_date, tx_amsmedialibrary_episodes.crdate)))/60/60/24)
AS plays_per_day FROM tx_amsmedialibrary_episodes
JOIN tx_amsmedialibrary_media_links
ON tx_amsmedialibrary_media_links.irre_uid = tx_amsmedialibrary_episodes.uid
AND tx_amsmedialibrary_media_links.irre_table = 'tx_amsmedialibrary_episodes' AND tx_amsmedialibrary_media_links.hidden=0 AND tx_amsmedialibrary_media_links.deleted=0
LEFT JOIN tx_amsmedialibrary_shows
ON tx_amsmedialibrary_episodes.fk_show = tx_amsmedialibrary_shows.uid AND tx_amsmedialibrary_shows.hidden=0 AND tx_amsmedialibrary_shows.deleted=0
JOIN tx_amsmedialibrary_seasons
ON tx_amsmedialibrary_seasons.irre_uid = tx_amsmedialibrary_shows.uid
AND tx_amsmedialibrary_seasons.uid = tx_amsmedialibrary_episodes.fk_season AND tx_amsmedialibrary_seasons.hidden=0 AND tx_amsmedialibrary_seasons.deleted=0 WHERE tx_amsmedialibrary_episodes.fk_channel = 4 AND tx_amsmedialibrary_episodes.hidden=0 AND (tx_amsmedialibrary_episodes.starttime<=1627355760) AND (tx_amsmedialibrary_episodes.endtime=0 OR tx_amsmedialibrary_episodes.endtime>1627355760) AND tx_amsmedialibrary_episodes.deleted=0
AND IFNULL(tx_amsmedialibrary_shows.tx_amsbroadcast_vod_hidden, 0) = 0
AND IFNULL(tx_amsmedialibrary_shows.tx_amsbroadcast_vod_start_time, 0) <= 1627355788
AND IF (IFNULL(tx_amsmedialibrary_shows.tx_amsbroadcast_vod_end_time, 0) > 0,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_end_time,
1627356788) > 1627355788
AND tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_hidden = 0
AND tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_web_hidden = 0
AND tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_start_time <= 1627355788
AND IF (tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_end_time > 0,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_end_time,
1627356788) > 1627355788 AND tx_amsmedialibrary_shows.uid IN (8) AND tx_amsmedialibrary_episodes.fk_season IN (130) AND tx_amsmedialibrary_episodes.plays > 0 ORDER BY plays_per_day DESC, tx_amsmedialibrary_episodes.crdate, tx_amsmedialibrary_episodes.uid LIMIT -880, 9
debug_backtrace require(/typo3/sysext/cms/tslib/index_ts.php),/index.php#28 // TYPO3\CMS\Frontend\Page\PageGenerator::renderContent#212 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#215 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#697 // TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->renderFluidView#78 // TYPO3\CMS\Fluid\View\AbstractTemplateView->render#269 // FluidCache_Standalone_layout_Default_43d927edf00b6bc7917d3401ef9072b9ad855d52->render#182 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->initializeArgumentsAndRender#152 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->callRenderMethod#230 // call_user_func_array#248 // TYPO3\CMS\Fluid\ViewHelpers\RenderViewHelper->render# // TYPO3\CMS\Fluid\View\AbstractTemplateView->renderSection#90 // FluidCache_Standalone_template_source_7fde5cfc95d4753cf39f81a42dcd8e308e5c1c5c->section_718a7e8a582e982e452dd5700addba4ffc1cf40d#222 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->initializeArgumentsAndRender#122 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->callRenderMethod#230 // call_user_func_array#248 // TYPO3\CMS\Fluid\ViewHelpers\RenderViewHelper->render# // TYPO3\CMS\Fluid\View\AbstractTemplateView->renderPartial#88 // FluidCache_Standalone_partial_Content_ce7ae4e5ae0ce283f20cbd2085fe8f2d6d192cf4->render#279 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->initializeArgumentsAndRender#36 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->callRenderMethod#230 // call_user_func_array#248 // TYPO3\CMS\Fluid\ViewHelpers\CObjectViewHelper->render# // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#117 // TYPO3\CMS\Frontend\ContentObject\ContentContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#107 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#734 // TYPO3\CMS\Frontend\ContentObject\CaseContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#45 // TYPO3\CMS\Frontend\ContentObject\ContentObjectArrayContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#40 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#697 // TYPO3\CMS\Frontend\ContentObject\CaseContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#45 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#734 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#41 // call_user_func_array#6663 // DeStimmeDerHoffnung\AmsMedialibrary\Plugins\Plugin1->main# // DeStimmeDerHoffnung\AmsMedialibrary\Plugins\Views\EpisodesList->render#122 // DeStimmeDerHoffnung\AmsMedialibrary\Domain\Database\DataAccess->getEpisodes#128 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#2081 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#305
Episodes: Hope Channel | Christian Television