| 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 '-7, 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 = 27 AND tx_amsmedialibrary_episodes.hidden=0 AND (tx_amsmedialibrary_episodes.starttime<=1686417780) AND (tx_amsmedialibrary_episodes.endtime=0 OR tx_amsmedialibrary_episodes.endtime>1686417780) 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) <= 1686417836
AND IF (IFNULL(tx_amsmedialibrary_shows.tx_amsbroadcast_vod_end_time, 0) > 0,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_end_time,
1686418836) > 1686417836
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 <= 1686417836
AND IF (tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_end_time > 0,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_end_time,
1686418836) > 1686417836 ORDER BY 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)) DESC, tx_amsmedialibrary_episodes.crdate, tx_amsmedialibrary_episodes.uid LIMIT -7, 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_6e5c13c33080959f0441c5fe8336886d823dcc5b->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_33e913cf6a3e5ad5257c151e5d997092427c8acd->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
|
|
