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 '-6, 9' at line 17
lastBuiltQuery SELECT DISTINCT SQL_CALC_FOUND_ROWS tx_amsmedialibrary_episodes.uid 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 WHERE tx_amsmedialibrary_episodes.fk_channel = 4 AND tx_amsmedialibrary_episodes.hidden=0 AND (tx_amsmedialibrary_episodes.starttime<=1634407860) AND (tx_amsmedialibrary_episodes.endtime=0 OR tx_amsmedialibrary_episodes.endtime>1634407860) 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) <= 1634407868
AND IF (IFNULL(tx_amsmedialibrary_shows.tx_amsbroadcast_vod_end_time, 0) > 0,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_end_time,
1634408868) > 1634407868
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 <= 1634407868
AND IF (tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_end_time > 0,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_end_time,
1634408868) > 1634407868 ORDER BY tx_amsmedialibrary_episodes.avg_rating DESC, tx_amsmedialibrary_episodes.crdate, tx_amsmedialibrary_episodes.uid LIMIT -6, 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_f2ea2ee05098591ae1f4cc89d2c0a099004ef75c->section_718a7e8a582e982e452dd5700addba4ffc1cf40d#222 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->initializeArgumentsAndRender#42 // 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#2093 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#305
Episodes: Hope Channel | Christian Television