exec_SELECTquery
caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
ERROR Unknown column 'tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_web_hidden' in 'where clause'
lastBuiltQuery SELECT
tx_amsmedialibrary_episodes.uid episodeUid,
tx_amsmedialibrary_episodes.pid episodePid,
tx_amsmedialibrary_episodes.hidden episodeHidden,
tx_amsmedialibrary_episodes.tstamp episodeTstamp,
tx_amsmedialibrary_episodes.crdate episodeCrdate,
tx_amsmedialibrary_episodes.starttime episodeStartTime,
tx_amsmedialibrary_episodes.endtime episodeEndTime,
tx_amsmedialibrary_episodes.title episodeTitle,
tx_amsmedialibrary_episodes.fk_channel episodeChannelUid,
tx_amsmedialibrary_episodes.fk_show episodeShowUid,
tx_amsmedialibrary_episodes.fk_language episodeLanguageUid,
tx_amsmedialibrary_episodes.short_description episodeShortDescription,
tx_amsmedialibrary_episodes.long_description episodeLongDescription,
tx_amsmedialibrary_episodes.videos_title episodeVideosTitle,
tx_amsmedialibrary_episodes.featured episodeFeatured,
tx_amsmedialibrary_episodes.downloadable episodeDownloadable,
tx_amsmedialibrary_episodes.avg_rating episodeAverageRating,
tx_amsmedialibrary_episodes.plays episodePlays,
tx_amsmedialibrary_channels.uid channelUid,
tx_amsmedialibrary_channels.pid channelPid,
tx_amsmedialibrary_channels.title channelTitle,
tx_amsmedialibrary_channels.media_type channelMediaType,
tx_amsmedialibrary_channels.globally_available channelGloballyAvailable,
tx_amsmedialibrary_channels.logo channelLogo,
tx_amsmedialibrary_channels.short_description channelShortDescription,
tx_amsmedialibrary_channels.long_description channelLongDescription,
tx_amsmedialibrary_channels.support_email channelSupportEmail,
tx_amsmedialibrary_channels.website channelWebsite,
tx_amsmedialibrary_channels.show_url channelShowUrl,
tx_amsmedialibrary_channels.episode_url channelEpisodeUrl,
tx_amsmedialibrary_channels.fk_default_language channelDefaultLanguageUid,
tx_amsmedialibrary_shows.uid showUid,
tx_amsmedialibrary_shows.pid showPid,
tx_amsmedialibrary_shows.hidden showHidden,
tx_amsmedialibrary_shows.crdate showCrdate,
tx_amsmedialibrary_shows.title showTitle,
tx_amsmedialibrary_shows.fk_channel showChannelUid,
tx_amsmedialibrary_shows.media_type showMediaType,
tx_amsmedialibrary_shows.fk_language showLanguageUid,
tx_amsmedialibrary_shows.anchor_show_published showAnchorShowPublished,
tx_amsmedialibrary_shows.featured showFeatured,
tx_amsmedialibrary_shows.episodes_downloadable showEpisodesDownloadable,
tx_amsmedialibrary_shows.short_description showShortDescription,
tx_amsmedialibrary_shows.long_description showLongDescription,
tx_amsmedialibrary_shows.videos_title showVideosTitle,
tx_amsmedialibrary_shows.contact_email showContactEmail,
tx_amsmedialibrary_shows.dominant_image_color showDominantImageColor,
tx_amsmedialibrary_shows.image_folder showImageFolder,
tx_amsmedialibrary_shows.document_folder showDocumentFolder,
tx_amsmedialibrary_shows.fk_anchor_show_pid showAnchorShowPid,
tx_amsmedialibrary_shows.fk_episodes_list_pid showEpisodesListPid,
tx_amsmedialibrary_shows.fk_episode_detail_pid showEpisodeDetailPid,
tx_amsmedialibrary_shows.fk_video_detail_pid showVideoDetailPid,
tx_amsmedialibrary_shows.fk_host_detail_pid showHostDetailPid,
tx_amsmedialibrary_shows.fk_guest_detail_pid showGuestDetailPid,
tx_amsmedialibrary_shows.rss_categories rssCategories,
tx_amsmedialibrary_shows.rss_subcategories rssSubcategories,
tx_amsmedialibrary_shows.season_numbers_rss seasonNumbersRss,
hosts.uid hostUid,
hosts.gender hostGender,
hosts.prefix hostPrefix,
hosts.first_name hostFirstName,
hosts.middle_name hostMiddleName,
hosts.last_name hostLastName,
hosts.suffix hostSuffix,
hosts.thumbnail hostThumbnail,
hosts.image hostImage,
hosts.description hostDescription,
hosts.email hostEmail,
guests.uid guestUid,
guests.gender guestGender,
guests.prefix guestPrefix,
guests.first_name guestFirstName,
guests.middle_name guestMiddleName,
guests.last_name guestLastName,
guests.suffix guestSuffix,
guests.thumbnail guestThumbnail,
guests.image guestImage,
guests.description guestDescription,
guests.email guestEmail,
tx_amsmedialibrary_links.uid linkUid,
tx_amsmedialibrary_links.link_type linkLinkType,
tx_amsmedialibrary_links.link linkLink,
tx_amsmedialibrary_links.title linkTitle,
seasonLinks.uid seasonLinkUid,
seasonLinks.link_type seasonLinkLinkType,
seasonLinks.link seasonLinkLink,
seasonLinks.title seasonLinkTitle,
showLinks.uid showLinkUid,
showLinks.link_type showLinkLinkType,
showLinks.link showLinkLink,
showLinks.title showLinkTitle,
tx_amsmedialibrary_videos.uid videoUid,
tx_amsmedialibrary_videos.pid videoPid,
tx_amsmedialibrary_videos.crdate videoCrdate,
tx_amsmedialibrary_videos.irre_table videoParentTable,
tx_amsmedialibrary_videos.irre_uid videoParentUid,
tx_amsmedialibrary_videos.sorting videoSorting,
tx_amsmedialibrary_videos.title videoTitle,
tx_amsmedialibrary_videos.short_description videoShortDescription,
tx_amsmedialibrary_videos.long_description videoLongDescription,
tx_amsmedialibrary_videos.fk_media_format videoMediaFormatUid,
tx_amsmedialibrary_videos.fk_import_source videoImportSourceUid,
tx_amsmedialibrary_videos.link videoLink,
tx_amsmedialibrary_video_categories.uid videoCategoryUid,
tx_amsmedialibrary_video_categories.irre_uid videoCategoryShowUid,
tx_amsmedialibrary_video_categories.title videoCategoryTitle,
tx_amsmedialibrary_import_ids.uid importIdUid,
tx_amsmedialibrary_import_ids.hidden importIdHidden,
tx_amsmedialibrary_import_ids.irre_uid importIdEpisodeUid,
tx_amsmedialibrary_import_ids.fk_channel importIdChannelUid,
tx_amsmedialibrary_import_ids.fk_import_source importIdImportSourceUid,
tx_amsmedialibrary_import_ids.import_id importIdImportId,
tx_amsmedialibrary_media_links.uid mediaLinkUid,
tx_amsmedialibrary_media_links.link mediaLinkLink,
tx_amsmedialibrary_media_links.fk_media_format mediaLinkMediaFormatUid,
tx_amsmedialibrary_media_links.fk_import_source mediaLinkImportSourceUid,
tx_amsmedialibrary_media_links.aspect_ratio mediaLinkAspectRatio,
tx_amsmedialibrary_media_links.file_size mediaLinkFileSize,
tx_amsmedialibrary_media_links.duration mediaLinkDuration,
tx_amsmedialibrary_media_formats.uid mediaFormatUid,
tx_amsmedialibrary_media_formats.title mediaFormatTitle,
tx_amsmedialibrary_media_formats.media_type mediaFormatMediaType,
tx_amsmedialibrary_media_formats.file_size_service mediaFormatFileSizeService,
tx_amsmedialibrary_media_formats.duration_service mediaFormatDurationService,
tx_amsmedialibrary_import_sources.uid importSourceUid,
tx_amsmedialibrary_import_sources.title importSourceTitle,
tx_amsmedialibrary_import_sources.media_link_generation importSourceMediaLinkGeneration,
tx_amsmedialibrary_import_sources.api_key importSourceApiKey,
tx_amsmedialibrary_import_sources.api_secret importSourceApiSecret,
tx_amsmedialibrary_import_sources.account_id importSourceAccountId,
tx_amsmedialibrary_import_sources.player_id importSourcePlayerId,
tx_amsmedialibrary_import_sources.policy_key importSourcePolicyKey,
tx_amsmedialibrary_seasons.uid seasonUid,
tx_amsmedialibrary_seasons.number seasonNumber,
tx_amsmedialibrary_seasons.title seasonTitle,
tx_amsmedialibrary_seasons.description seasonDescription,
tx_amsmedialibrary_seasons.group_name seasonGroupName,episodeImage_reference.uid episodeImageUid,episodeImage_reference.uid_local episodeImageFileUid,
if (episodeImage_reference.title <> '', episodeImage_reference.title, episodeImage_file.title) episodeImageTitle,
if (episodeImage_reference.alternative <> '', episodeImage_reference.alternative, episodeImage_file.alternative) episodeImageAlternative,
if (episodeImage_reference.description <> '', episodeImage_reference.description, episodeImage_file.description) episodeImageDescription,
episodeImage_reference.link episodeImageLink,episodeDocuments_reference.uid episodeDocumentsUid,episodeDocuments_reference.uid_local episodeDocumentsFileUid,
if (episodeDocuments_reference.title <> '', episodeDocuments_reference.title, episodeDocuments_file.title) episodeDocumentsTitle,
if (episodeDocuments_reference.alternative <> '', episodeDocuments_reference.alternative, episodeDocuments_file.alternative) episodeDocumentsAlternative,
if (episodeDocuments_reference.description <> '', episodeDocuments_reference.description, episodeDocuments_file.description) episodeDocumentsDescription,
episodeDocuments_reference.link episodeDocumentsLink,seasonDocuments_reference.uid seasonDocumentsUid,seasonDocuments_reference.uid_local seasonDocumentsFileUid,
if (seasonDocuments_reference.title <> '', seasonDocuments_reference.title, seasonDocuments_file.title) seasonDocumentsTitle,
if (seasonDocuments_reference.alternative <> '', seasonDocuments_reference.alternative, seasonDocuments_file.alternative) seasonDocumentsAlternative,
if (seasonDocuments_reference.description <> '', seasonDocuments_reference.description, seasonDocuments_file.description) seasonDocumentsDescription,
seasonDocuments_reference.link seasonDocumentsLink,showDocuments_reference.uid showDocumentsUid,showDocuments_reference.uid_local showDocumentsFileUid,
if (showDocuments_reference.title <> '', showDocuments_reference.title, showDocuments_file.title) showDocumentsTitle,
if (showDocuments_reference.alternative <> '', showDocuments_reference.alternative, showDocuments_file.alternative) showDocumentsAlternative,
if (showDocuments_reference.description <> '', showDocuments_reference.description, showDocuments_file.description) showDocumentsDescription,
showDocuments_reference.link showDocumentsLink,hostThumbnail_reference.uid hostThumbnailUid,hostThumbnail_reference.uid_local hostThumbnailFileUid,
if (hostThumbnail_reference.title <> '', hostThumbnail_reference.title, hostThumbnail_file.title) hostThumbnailTitle,
if (hostThumbnail_reference.alternative <> '', hostThumbnail_reference.alternative, hostThumbnail_file.alternative) hostThumbnailAlternative,
if (hostThumbnail_reference.description <> '', hostThumbnail_reference.description, hostThumbnail_file.description) hostThumbnailDescription,
hostThumbnail_reference.link hostThumbnailLink,hostImage_reference.uid hostImageUid,hostImage_reference.uid_local hostImageFileUid,
if (hostImage_reference.title <> '', hostImage_reference.title, hostImage_file.title) hostImageTitle,
if (hostImage_reference.alternative <> '', hostImage_reference.alternative, hostImage_file.alternative) hostImageAlternative,
if (hostImage_reference.description <> '', hostImage_reference.description, hostImage_file.description) hostImageDescription,
hostImage_reference.link hostImageLink,guestThumbnail_reference.uid guestThumbnailUid,guestThumbnail_reference.uid_local guestThumbnailFileUid,
if (guestThumbnail_reference.title <> '', guestThumbnail_reference.title, guestThumbnail_file.title) guestThumbnailTitle,
if (guestThumbnail_reference.alternative <> '', guestThumbnail_reference.alternative, guestThumbnail_file.alternative) guestThumbnailAlternative,
if (guestThumbnail_reference.description <> '', guestThumbnail_reference.description, guestThumbnail_file.description) guestThumbnailDescription,
guestThumbnail_reference.link guestThumbnailLink,guestImage_reference.uid guestImageUid,guestImage_reference.uid_local guestImageFileUid,
if (guestImage_reference.title <> '', guestImage_reference.title, guestImage_file.title) guestImageTitle,
if (guestImage_reference.alternative <> '', guestImage_reference.alternative, guestImage_file.alternative) guestImageAlternative,
if (guestImage_reference.description <> '', guestImage_reference.description, guestImage_file.description) guestImageDescription,
guestImage_reference.link guestImageLink,showImage_reference.uid showImageUid,showImage_reference.uid_local showImageFileUid,
if (showImage_reference.title <> '', showImage_reference.title, showImage_file.title) showImageTitle,
if (showImage_reference.alternative <> '', showImage_reference.alternative, showImage_file.alternative) showImageAlternative,
if (showImage_reference.description <> '', showImage_reference.description, showImage_file.description) showImageDescription,
showImage_reference.link showImageLink,videoImage_reference.uid videoImageUid,videoImage_reference.uid_local videoImageFileUid,
if (videoImage_reference.title <> '', videoImage_reference.title, videoImage_file.title) videoImageTitle,
if (videoImage_reference.alternative <> '', videoImage_reference.alternative, videoImage_file.alternative) videoImageAlternative,
if (videoImage_reference.description <> '', videoImage_reference.description, videoImage_file.description) videoImageDescription,
videoImage_reference.link videoImageLink,
tx_amslanguages_languages.uid languageUid,
tx_amslanguages_languages.title languageTitle,
tx_amslanguages_languages.isooftitle languageIsoOfName,
tx_amslanguages_languages.ietfoftitle languageIetfOfName,
tx_amstags_categories.uid categoryUid,
tx_amstags_categories.l10n_parent parentCategoryUid,
tx_amstags_categories.title categoryTitle,
tx_amstags_categories.description categoryDescription,
tx_amstags_tags.uid tagUid,
tx_amstags_tags.title tagTitle,
tx_amstags_tags.fk_group tagGroupUid,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_start_time showVodStartTime,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_end_time showVodEndTime,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_hidden showVodHidden,
tx_amsmedialibrary_episodes.tx_amsbroadcast_first_air_date episodeFirstAirDate,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_start_time episodeVodStartTime,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_end_time episodeVodEndTime,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_hidden episodeVodHidden FROM tx_amsmedialibrary_episodes
JOIN tx_amsmedialibrary_channels
ON tx_amsmedialibrary_channels.uid = tx_amsmedialibrary_episodes.fk_channel AND tx_amsmedialibrary_channels.hidden=0 AND tx_amsmedialibrary_channels.deleted=0
LEFT JOIN tx_amsmedialibrary_shows
ON tx_amsmedialibrary_shows.uid = tx_amsmedialibrary_episodes.fk_show AND tx_amsmedialibrary_shows.hidden=0 AND tx_amsmedialibrary_shows.deleted=0
LEFT JOIN tx_amsmedialibrary_video_categories
ON tx_amsmedialibrary_video_categories.irre_uid = tx_amsmedialibrary_shows.uid
AND tx_amsmedialibrary_video_categories.irre_table = 'tx_amsmedialibrary_shows' AND tx_amsmedialibrary_video_categories.hidden=0 AND tx_amsmedialibrary_video_categories.deleted=0
LEFT JOIN tx_amsmedialibrary_links showLinks
ON showLinks.irre_uid = tx_amsmedialibrary_shows.uid
AND showLinks.irre_table = 'tx_amsmedialibrary_shows' AND showLinks.hidden=0 AND showLinks.deleted=0
LEFT JOIN tx_amsmedialibrary_videos
ON tx_amsmedialibrary_videos.irre_uid = tx_amsmedialibrary_episodes.uid
AND tx_amsmedialibrary_videos.irre_table = 'tx_amsmedialibrary_episodes' AND tx_amsmedialibrary_videos.hidden=0 AND tx_amsmedialibrary_videos.deleted=0
LEFT JOIN tx_amsmedialibrary_seasons
ON tx_amsmedialibrary_seasons.uid = tx_amsmedialibrary_episodes.fk_season AND tx_amsmedialibrary_seasons.hidden=0 AND tx_amsmedialibrary_seasons.deleted=0
LEFT JOIN tx_amsmedialibrary_links seasonLinks
ON seasonLinks.irre_uid = tx_amsmedialibrary_seasons.uid
AND seasonLinks.irre_table = 'tx_amsmedialibrary_seasons' AND seasonLinks.hidden=0 AND seasonLinks.deleted=0
LEFT JOIN tx_amsmedialibrary_episodes_fk_hosts_mm
ON tx_amsmedialibrary_episodes_fk_hosts_mm.uid_local = tx_amsmedialibrary_episodes.uid
LEFT JOIN tx_amsmedialibrary_persons hosts
ON hosts.uid = tx_amsmedialibrary_episodes_fk_hosts_mm.uid_foreign AND hosts.hidden=0 AND hosts.deleted=0 LEFT JOIN sys_file_reference hostThumbnail_reference ON hostThumbnail_reference.uid_foreign = hosts.uid
AND hostThumbnail_reference.tablenames = 'tx_amsmedialibrary_persons'
AND hostThumbnail_reference.fieldname = 'thumbnail' AND hostThumbnail_reference.hidden=0 AND hostThumbnail_reference.deleted=0 LEFT JOIN sys_file_metadata hostThumbnail_file ON hostThumbnail_reference.uid_local = hostThumbnail_file.file LEFT JOIN sys_file_reference hostImage_reference ON hostImage_reference.uid_foreign = hosts.uid
AND hostImage_reference.tablenames = 'tx_amsmedialibrary_persons'
AND hostImage_reference.fieldname = 'image' AND hostImage_reference.hidden=0 AND hostImage_reference.deleted=0 LEFT JOIN sys_file_metadata hostImage_file ON hostImage_reference.uid_local = hostImage_file.file
LEFT JOIN tx_amsmedialibrary_episodes_fk_guests_mm
ON tx_amsmedialibrary_episodes_fk_guests_mm.uid_local = tx_amsmedialibrary_episodes.uid
LEFT JOIN tx_amsmedialibrary_persons guests
ON guests.uid = tx_amsmedialibrary_episodes_fk_guests_mm.uid_foreign AND guests.hidden=0 AND guests.deleted=0 LEFT JOIN sys_file_reference guestThumbnail_reference ON guestThumbnail_reference.uid_foreign = guests.uid
AND guestThumbnail_reference.tablenames = 'tx_amsmedialibrary_persons'
AND guestThumbnail_reference.fieldname = 'thumbnail' AND guestThumbnail_reference.hidden=0 AND guestThumbnail_reference.deleted=0 LEFT JOIN sys_file_metadata guestThumbnail_file ON guestThumbnail_reference.uid_local = guestThumbnail_file.file LEFT JOIN sys_file_reference guestImage_reference ON guestImage_reference.uid_foreign = guests.uid
AND guestImage_reference.tablenames = 'tx_amsmedialibrary_persons'
AND guestImage_reference.fieldname = 'image' AND guestImage_reference.hidden=0 AND guestImage_reference.deleted=0 LEFT JOIN sys_file_metadata guestImage_file ON guestImage_reference.uid_local = guestImage_file.file
LEFT JOIN tx_amsmedialibrary_links
ON tx_amsmedialibrary_links.irre_uid = tx_amsmedialibrary_episodes.uid
AND tx_amsmedialibrary_links.irre_table = 'tx_amsmedialibrary_episodes' AND tx_amsmedialibrary_links.hidden=0 AND tx_amsmedialibrary_links.deleted=0
LEFT JOIN tx_amslanguages_languages
ON tx_amslanguages_languages.uid = tx_amsmedialibrary_episodes.fk_language AND tx_amslanguages_languages.hidden=0 AND tx_amslanguages_languages.deleted=0 LEFT JOIN sys_file_reference episodeImage_reference ON episodeImage_reference.uid_foreign = tx_amsmedialibrary_episodes.uid
AND episodeImage_reference.tablenames = 'tx_amsmedialibrary_episodes'
AND episodeImage_reference.fieldname = 'image' AND episodeImage_reference.hidden=0 AND episodeImage_reference.deleted=0 LEFT JOIN sys_file_metadata episodeImage_file ON episodeImage_reference.uid_local = episodeImage_file.file LEFT JOIN sys_file_reference showImage_reference ON showImage_reference.uid_foreign = tx_amsmedialibrary_shows.uid
AND showImage_reference.tablenames = 'tx_amsmedialibrary_shows'
AND showImage_reference.fieldname = 'image' AND showImage_reference.hidden=0 AND showImage_reference.deleted=0 LEFT JOIN sys_file_metadata showImage_file ON showImage_reference.uid_local = showImage_file.file LEFT JOIN sys_file_reference episodeDocuments_reference ON episodeDocuments_reference.uid_foreign = tx_amsmedialibrary_episodes.uid
AND episodeDocuments_reference.tablenames = 'tx_amsmedialibrary_episodes'
AND episodeDocuments_reference.fieldname = 'documents' AND episodeDocuments_reference.hidden=0 AND episodeDocuments_reference.deleted=0 LEFT JOIN sys_file_metadata episodeDocuments_file ON episodeDocuments_reference.uid_local = episodeDocuments_file.file LEFT JOIN sys_file_reference seasonDocuments_reference ON seasonDocuments_reference.uid_foreign = tx_amsmedialibrary_seasons.uid
AND seasonDocuments_reference.tablenames = 'tx_amsmedialibrary_seasons'
AND seasonDocuments_reference.fieldname = 'documents' AND seasonDocuments_reference.hidden=0 AND seasonDocuments_reference.deleted=0 LEFT JOIN sys_file_metadata seasonDocuments_file ON seasonDocuments_reference.uid_local = seasonDocuments_file.file LEFT JOIN sys_file_reference videoImage_reference ON videoImage_reference.uid_foreign = tx_amsmedialibrary_videos.uid
AND videoImage_reference.tablenames = 'tx_amsmedialibrary_videos'
AND videoImage_reference.fieldname = 'image' AND videoImage_reference.hidden=0 AND videoImage_reference.deleted=0 LEFT JOIN sys_file_metadata videoImage_file ON videoImage_reference.uid_local = videoImage_file.file LEFT JOIN sys_file_reference showDocuments_reference ON showDocuments_reference.uid_foreign = tx_amsmedialibrary_shows.uid
AND showDocuments_reference.tablenames = 'tx_amsmedialibrary_shows'
AND showDocuments_reference.fieldname = 'documents' AND showDocuments_reference.hidden=0 AND showDocuments_reference.deleted=0 LEFT JOIN sys_file_metadata showDocuments_file ON showDocuments_reference.uid_local = showDocuments_file.file
LEFT JOIN tx_amsmedialibrary_import_ids
ON tx_amsmedialibrary_import_ids.irre_uid = tx_amsmedialibrary_episodes.uid
AND tx_amsmedialibrary_import_ids.irre_table = 'tx_amsmedialibrary_episodes' AND tx_amsmedialibrary_import_ids.hidden=0 AND tx_amsmedialibrary_import_ids.deleted=0
LEFT JOIN tx_amsmedialibrary_import_sources
ON tx_amsmedialibrary_import_sources.uid = tx_amsmedialibrary_import_ids.fk_import_source AND tx_amsmedialibrary_import_sources.hidden=0 AND tx_amsmedialibrary_import_sources.deleted=0
LEFT 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_media_formats
ON tx_amsmedialibrary_media_formats.uid = tx_amsmedialibrary_media_links.fk_media_format AND tx_amsmedialibrary_media_formats.hidden=0 AND tx_amsmedialibrary_media_formats.deleted=0
LEFT JOIN tx_amstags_categories_mm
ON tx_amstags_categories_mm.uid_local = tx_amsmedialibrary_episodes.uid
AND tx_amstags_categories_mm.tablename = 'tx_amsmedialibrary_episodes'
LEFT JOIN tx_amstags_categories
ON tx_amstags_categories.uid = tx_amstags_categories_mm.uid_foreign AND tx_amstags_categories.hidden=0 AND tx_amstags_categories.deleted=0
LEFT JOIN tx_amstags_tags_mm
ON tx_amstags_tags_mm.uid_local = tx_amsmedialibrary_episodes.uid
AND tx_amstags_tags_mm.tablename = 'tx_amsmedialibrary_episodes'
LEFT JOIN tx_amstags_tags
ON tx_amstags_tags.uid = tx_amstags_tags_mm.uid_foreign AND tx_amstags_tags.hidden=0 AND tx_amstags_tags.deleted=0 WHERE tx_amsmedialibrary_episodes.uid = 4 AND tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_web_hidden = 0 AND tx_amsmedialibrary_episodes.hidden=0 AND (tx_amsmedialibrary_episodes.starttime<=1606405260) AND (tx_amsmedialibrary_episodes.endtime=0 OR tx_amsmedialibrary_episodes.endtime>1606405260) AND tx_amsmedialibrary_episodes.deleted=0 ORDER BY tx_amsmedialibrary_episodes_fk_hosts_mm.sorting,
tx_amsmedialibrary_episodes_fk_guests_mm.sorting,
episodeDocuments_reference.sorting DESC,
seasonDocuments_reference.sorting DESC,
showDocuments_reference.sorting DESC,
seasonLinks.sorting,
showLinks.sorting,
tx_amsmedialibrary_links.sorting,
tx_amsmedialibrary_videos.sorting,
tx_amsmedialibrary_video_categories.sorting,
tx_amsmedialibrary_media_links.sorting,
tx_amstags_categories_mm.sorting,
tx_amstags_tags_mm.sorting
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_34a515001ce7fa4507b223bafbe0fabd8e16da23->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_496b28e95217c4a71586ada825b29e587a3fcae5->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\EpisodeDetail->render#122 // DeStimmeDerHoffnung\AmsMedialibrary\Domain\Database\DataAccess->getEpisode#85 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#1677 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#305
exec_SELECTquery
caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
ERROR Unknown column 'tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_web_hidden' in 'where clause'
lastBuiltQuery SELECT
tx_amsmedialibrary_episodes.uid episodeUid,
tx_amsmedialibrary_episodes.pid episodePid,
tx_amsmedialibrary_episodes.hidden episodeHidden,
tx_amsmedialibrary_episodes.tstamp episodeTstamp,
tx_amsmedialibrary_episodes.crdate episodeCrdate,
tx_amsmedialibrary_episodes.starttime episodeStartTime,
tx_amsmedialibrary_episodes.endtime episodeEndTime,
tx_amsmedialibrary_episodes.title episodeTitle,
tx_amsmedialibrary_episodes.fk_channel episodeChannelUid,
tx_amsmedialibrary_episodes.fk_show episodeShowUid,
tx_amsmedialibrary_episodes.fk_language episodeLanguageUid,
tx_amsmedialibrary_episodes.short_description episodeShortDescription,
tx_amsmedialibrary_episodes.long_description episodeLongDescription,
tx_amsmedialibrary_episodes.videos_title episodeVideosTitle,
tx_amsmedialibrary_episodes.featured episodeFeatured,
tx_amsmedialibrary_episodes.downloadable episodeDownloadable,
tx_amsmedialibrary_episodes.avg_rating episodeAverageRating,
tx_amsmedialibrary_episodes.plays episodePlays,
tx_amsmedialibrary_channels.uid channelUid,
tx_amsmedialibrary_channels.pid channelPid,
tx_amsmedialibrary_channels.title channelTitle,
tx_amsmedialibrary_channels.media_type channelMediaType,
tx_amsmedialibrary_channels.globally_available channelGloballyAvailable,
tx_amsmedialibrary_channels.logo channelLogo,
tx_amsmedialibrary_channels.short_description channelShortDescription,
tx_amsmedialibrary_channels.long_description channelLongDescription,
tx_amsmedialibrary_channels.support_email channelSupportEmail,
tx_amsmedialibrary_channels.website channelWebsite,
tx_amsmedialibrary_channels.show_url channelShowUrl,
tx_amsmedialibrary_channels.episode_url channelEpisodeUrl,
tx_amsmedialibrary_channels.fk_default_language channelDefaultLanguageUid,
tx_amsmedialibrary_shows.uid showUid,
tx_amsmedialibrary_shows.pid showPid,
tx_amsmedialibrary_shows.hidden showHidden,
tx_amsmedialibrary_shows.crdate showCrdate,
tx_amsmedialibrary_shows.title showTitle,
tx_amsmedialibrary_shows.fk_channel showChannelUid,
tx_amsmedialibrary_shows.media_type showMediaType,
tx_amsmedialibrary_shows.fk_language showLanguageUid,
tx_amsmedialibrary_shows.anchor_show_published showAnchorShowPublished,
tx_amsmedialibrary_shows.featured showFeatured,
tx_amsmedialibrary_shows.episodes_downloadable showEpisodesDownloadable,
tx_amsmedialibrary_shows.short_description showShortDescription,
tx_amsmedialibrary_shows.long_description showLongDescription,
tx_amsmedialibrary_shows.videos_title showVideosTitle,
tx_amsmedialibrary_shows.contact_email showContactEmail,
tx_amsmedialibrary_shows.dominant_image_color showDominantImageColor,
tx_amsmedialibrary_shows.image_folder showImageFolder,
tx_amsmedialibrary_shows.document_folder showDocumentFolder,
tx_amsmedialibrary_shows.fk_anchor_show_pid showAnchorShowPid,
tx_amsmedialibrary_shows.fk_episodes_list_pid showEpisodesListPid,
tx_amsmedialibrary_shows.fk_episode_detail_pid showEpisodeDetailPid,
tx_amsmedialibrary_shows.fk_video_detail_pid showVideoDetailPid,
tx_amsmedialibrary_shows.fk_host_detail_pid showHostDetailPid,
tx_amsmedialibrary_shows.fk_guest_detail_pid showGuestDetailPid,
tx_amsmedialibrary_shows.rss_categories rssCategories,
tx_amsmedialibrary_shows.rss_subcategories rssSubcategories,
tx_amsmedialibrary_shows.season_numbers_rss seasonNumbersRss,
hosts.uid hostUid,
hosts.gender hostGender,
hosts.prefix hostPrefix,
hosts.first_name hostFirstName,
hosts.middle_name hostMiddleName,
hosts.last_name hostLastName,
hosts.suffix hostSuffix,
hosts.thumbnail hostThumbnail,
hosts.image hostImage,
hosts.description hostDescription,
hosts.email hostEmail,
guests.uid guestUid,
guests.gender guestGender,
guests.prefix guestPrefix,
guests.first_name guestFirstName,
guests.middle_name guestMiddleName,
guests.last_name guestLastName,
guests.suffix guestSuffix,
guests.thumbnail guestThumbnail,
guests.image guestImage,
guests.description guestDescription,
guests.email guestEmail,
tx_amsmedialibrary_links.uid linkUid,
tx_amsmedialibrary_links.link_type linkLinkType,
tx_amsmedialibrary_links.link linkLink,
tx_amsmedialibrary_links.title linkTitle,
seasonLinks.uid seasonLinkUid,
seasonLinks.link_type seasonLinkLinkType,
seasonLinks.link seasonLinkLink,
seasonLinks.title seasonLinkTitle,
showLinks.uid showLinkUid,
showLinks.link_type showLinkLinkType,
showLinks.link showLinkLink,
showLinks.title showLinkTitle,
tx_amsmedialibrary_videos.uid videoUid,
tx_amsmedialibrary_videos.pid videoPid,
tx_amsmedialibrary_videos.crdate videoCrdate,
tx_amsmedialibrary_videos.irre_table videoParentTable,
tx_amsmedialibrary_videos.irre_uid videoParentUid,
tx_amsmedialibrary_videos.sorting videoSorting,
tx_amsmedialibrary_videos.title videoTitle,
tx_amsmedialibrary_videos.short_description videoShortDescription,
tx_amsmedialibrary_videos.long_description videoLongDescription,
tx_amsmedialibrary_videos.fk_media_format videoMediaFormatUid,
tx_amsmedialibrary_videos.fk_import_source videoImportSourceUid,
tx_amsmedialibrary_videos.link videoLink,
tx_amsmedialibrary_video_categories.uid videoCategoryUid,
tx_amsmedialibrary_video_categories.irre_uid videoCategoryShowUid,
tx_amsmedialibrary_video_categories.title videoCategoryTitle,
tx_amsmedialibrary_import_ids.uid importIdUid,
tx_amsmedialibrary_import_ids.hidden importIdHidden,
tx_amsmedialibrary_import_ids.irre_uid importIdEpisodeUid,
tx_amsmedialibrary_import_ids.fk_channel importIdChannelUid,
tx_amsmedialibrary_import_ids.fk_import_source importIdImportSourceUid,
tx_amsmedialibrary_import_ids.import_id importIdImportId,
tx_amsmedialibrary_media_links.uid mediaLinkUid,
tx_amsmedialibrary_media_links.link mediaLinkLink,
tx_amsmedialibrary_media_links.fk_media_format mediaLinkMediaFormatUid,
tx_amsmedialibrary_media_links.fk_import_source mediaLinkImportSourceUid,
tx_amsmedialibrary_media_links.aspect_ratio mediaLinkAspectRatio,
tx_amsmedialibrary_media_links.file_size mediaLinkFileSize,
tx_amsmedialibrary_media_links.duration mediaLinkDuration,
tx_amsmedialibrary_media_formats.uid mediaFormatUid,
tx_amsmedialibrary_media_formats.title mediaFormatTitle,
tx_amsmedialibrary_media_formats.media_type mediaFormatMediaType,
tx_amsmedialibrary_media_formats.file_size_service mediaFormatFileSizeService,
tx_amsmedialibrary_media_formats.duration_service mediaFormatDurationService,
tx_amsmedialibrary_import_sources.uid importSourceUid,
tx_amsmedialibrary_import_sources.title importSourceTitle,
tx_amsmedialibrary_import_sources.media_link_generation importSourceMediaLinkGeneration,
tx_amsmedialibrary_import_sources.api_key importSourceApiKey,
tx_amsmedialibrary_import_sources.api_secret importSourceApiSecret,
tx_amsmedialibrary_import_sources.account_id importSourceAccountId,
tx_amsmedialibrary_import_sources.player_id importSourcePlayerId,
tx_amsmedialibrary_import_sources.policy_key importSourcePolicyKey,
tx_amsmedialibrary_seasons.uid seasonUid,
tx_amsmedialibrary_seasons.number seasonNumber,
tx_amsmedialibrary_seasons.title seasonTitle,
tx_amsmedialibrary_seasons.description seasonDescription,
tx_amsmedialibrary_seasons.group_name seasonGroupName,episodeImage_reference.uid episodeImageUid,episodeImage_reference.uid_local episodeImageFileUid,
if (episodeImage_reference.title <> '', episodeImage_reference.title, episodeImage_file.title) episodeImageTitle,
if (episodeImage_reference.alternative <> '', episodeImage_reference.alternative, episodeImage_file.alternative) episodeImageAlternative,
if (episodeImage_reference.description <> '', episodeImage_reference.description, episodeImage_file.description) episodeImageDescription,
episodeImage_reference.link episodeImageLink,episodeDocuments_reference.uid episodeDocumentsUid,episodeDocuments_reference.uid_local episodeDocumentsFileUid,
if (episodeDocuments_reference.title <> '', episodeDocuments_reference.title, episodeDocuments_file.title) episodeDocumentsTitle,
if (episodeDocuments_reference.alternative <> '', episodeDocuments_reference.alternative, episodeDocuments_file.alternative) episodeDocumentsAlternative,
if (episodeDocuments_reference.description <> '', episodeDocuments_reference.description, episodeDocuments_file.description) episodeDocumentsDescription,
episodeDocuments_reference.link episodeDocumentsLink,seasonDocuments_reference.uid seasonDocumentsUid,seasonDocuments_reference.uid_local seasonDocumentsFileUid,
if (seasonDocuments_reference.title <> '', seasonDocuments_reference.title, seasonDocuments_file.title) seasonDocumentsTitle,
if (seasonDocuments_reference.alternative <> '', seasonDocuments_reference.alternative, seasonDocuments_file.alternative) seasonDocumentsAlternative,
if (seasonDocuments_reference.description <> '', seasonDocuments_reference.description, seasonDocuments_file.description) seasonDocumentsDescription,
seasonDocuments_reference.link seasonDocumentsLink,showDocuments_reference.uid showDocumentsUid,showDocuments_reference.uid_local showDocumentsFileUid,
if (showDocuments_reference.title <> '', showDocuments_reference.title, showDocuments_file.title) showDocumentsTitle,
if (showDocuments_reference.alternative <> '', showDocuments_reference.alternative, showDocuments_file.alternative) showDocumentsAlternative,
if (showDocuments_reference.description <> '', showDocuments_reference.description, showDocuments_file.description) showDocumentsDescription,
showDocuments_reference.link showDocumentsLink,hostThumbnail_reference.uid hostThumbnailUid,hostThumbnail_reference.uid_local hostThumbnailFileUid,
if (hostThumbnail_reference.title <> '', hostThumbnail_reference.title, hostThumbnail_file.title) hostThumbnailTitle,
if (hostThumbnail_reference.alternative <> '', hostThumbnail_reference.alternative, hostThumbnail_file.alternative) hostThumbnailAlternative,
if (hostThumbnail_reference.description <> '', hostThumbnail_reference.description, hostThumbnail_file.description) hostThumbnailDescription,
hostThumbnail_reference.link hostThumbnailLink,hostImage_reference.uid hostImageUid,hostImage_reference.uid_local hostImageFileUid,
if (hostImage_reference.title <> '', hostImage_reference.title, hostImage_file.title) hostImageTitle,
if (hostImage_reference.alternative <> '', hostImage_reference.alternative, hostImage_file.alternative) hostImageAlternative,
if (hostImage_reference.description <> '', hostImage_reference.description, hostImage_file.description) hostImageDescription,
hostImage_reference.link hostImageLink,guestThumbnail_reference.uid guestThumbnailUid,guestThumbnail_reference.uid_local guestThumbnailFileUid,
if (guestThumbnail_reference.title <> '', guestThumbnail_reference.title, guestThumbnail_file.title) guestThumbnailTitle,
if (guestThumbnail_reference.alternative <> '', guestThumbnail_reference.alternative, guestThumbnail_file.alternative) guestThumbnailAlternative,
if (guestThumbnail_reference.description <> '', guestThumbnail_reference.description, guestThumbnail_file.description) guestThumbnailDescription,
guestThumbnail_reference.link guestThumbnailLink,guestImage_reference.uid guestImageUid,guestImage_reference.uid_local guestImageFileUid,
if (guestImage_reference.title <> '', guestImage_reference.title, guestImage_file.title) guestImageTitle,
if (guestImage_reference.alternative <> '', guestImage_reference.alternative, guestImage_file.alternative) guestImageAlternative,
if (guestImage_reference.description <> '', guestImage_reference.description, guestImage_file.description) guestImageDescription,
guestImage_reference.link guestImageLink,showImage_reference.uid showImageUid,showImage_reference.uid_local showImageFileUid,
if (showImage_reference.title <> '', showImage_reference.title, showImage_file.title) showImageTitle,
if (showImage_reference.alternative <> '', showImage_reference.alternative, showImage_file.alternative) showImageAlternative,
if (showImage_reference.description <> '', showImage_reference.description, showImage_file.description) showImageDescription,
showImage_reference.link showImageLink,videoImage_reference.uid videoImageUid,videoImage_reference.uid_local videoImageFileUid,
if (videoImage_reference.title <> '', videoImage_reference.title, videoImage_file.title) videoImageTitle,
if (videoImage_reference.alternative <> '', videoImage_reference.alternative, videoImage_file.alternative) videoImageAlternative,
if (videoImage_reference.description <> '', videoImage_reference.description, videoImage_file.description) videoImageDescription,
videoImage_reference.link videoImageLink,
tx_amslanguages_languages.uid languageUid,
tx_amslanguages_languages.title languageTitle,
tx_amslanguages_languages.isooftitle languageIsoOfName,
tx_amslanguages_languages.ietfoftitle languageIetfOfName,
tx_amstags_categories.uid categoryUid,
tx_amstags_categories.l10n_parent parentCategoryUid,
tx_amstags_categories.title categoryTitle,
tx_amstags_categories.description categoryDescription,
tx_amstags_tags.uid tagUid,
tx_amstags_tags.title tagTitle,
tx_amstags_tags.fk_group tagGroupUid,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_start_time showVodStartTime,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_end_time showVodEndTime,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_hidden showVodHidden,
tx_amsmedialibrary_episodes.tx_amsbroadcast_first_air_date episodeFirstAirDate,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_start_time episodeVodStartTime,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_end_time episodeVodEndTime,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_hidden episodeVodHidden FROM tx_amsmedialibrary_episodes
JOIN tx_amsmedialibrary_channels
ON tx_amsmedialibrary_channels.uid = tx_amsmedialibrary_episodes.fk_channel AND tx_amsmedialibrary_channels.hidden=0 AND tx_amsmedialibrary_channels.deleted=0
LEFT JOIN tx_amsmedialibrary_shows
ON tx_amsmedialibrary_shows.uid = tx_amsmedialibrary_episodes.fk_show AND tx_amsmedialibrary_shows.hidden=0 AND tx_amsmedialibrary_shows.deleted=0
LEFT JOIN tx_amsmedialibrary_video_categories
ON tx_amsmedialibrary_video_categories.irre_uid = tx_amsmedialibrary_shows.uid
AND tx_amsmedialibrary_video_categories.irre_table = 'tx_amsmedialibrary_shows' AND tx_amsmedialibrary_video_categories.hidden=0 AND tx_amsmedialibrary_video_categories.deleted=0
LEFT JOIN tx_amsmedialibrary_links showLinks
ON showLinks.irre_uid = tx_amsmedialibrary_shows.uid
AND showLinks.irre_table = 'tx_amsmedialibrary_shows' AND showLinks.hidden=0 AND showLinks.deleted=0
LEFT JOIN tx_amsmedialibrary_videos
ON tx_amsmedialibrary_videos.irre_uid = tx_amsmedialibrary_episodes.uid
AND tx_amsmedialibrary_videos.irre_table = 'tx_amsmedialibrary_episodes' AND tx_amsmedialibrary_videos.hidden=0 AND tx_amsmedialibrary_videos.deleted=0
LEFT JOIN tx_amsmedialibrary_seasons
ON tx_amsmedialibrary_seasons.uid = tx_amsmedialibrary_episodes.fk_season AND tx_amsmedialibrary_seasons.hidden=0 AND tx_amsmedialibrary_seasons.deleted=0
LEFT JOIN tx_amsmedialibrary_links seasonLinks
ON seasonLinks.irre_uid = tx_amsmedialibrary_seasons.uid
AND seasonLinks.irre_table = 'tx_amsmedialibrary_seasons' AND seasonLinks.hidden=0 AND seasonLinks.deleted=0
LEFT JOIN tx_amsmedialibrary_episodes_fk_hosts_mm
ON tx_amsmedialibrary_episodes_fk_hosts_mm.uid_local = tx_amsmedialibrary_episodes.uid
LEFT JOIN tx_amsmedialibrary_persons hosts
ON hosts.uid = tx_amsmedialibrary_episodes_fk_hosts_mm.uid_foreign AND hosts.hidden=0 AND hosts.deleted=0 LEFT JOIN sys_file_reference hostThumbnail_reference ON hostThumbnail_reference.uid_foreign = hosts.uid
AND hostThumbnail_reference.tablenames = 'tx_amsmedialibrary_persons'
AND hostThumbnail_reference.fieldname = 'thumbnail' AND hostThumbnail_reference.hidden=0 AND hostThumbnail_reference.deleted=0 LEFT JOIN sys_file_metadata hostThumbnail_file ON hostThumbnail_reference.uid_local = hostThumbnail_file.file LEFT JOIN sys_file_reference hostImage_reference ON hostImage_reference.uid_foreign = hosts.uid
AND hostImage_reference.tablenames = 'tx_amsmedialibrary_persons'
AND hostImage_reference.fieldname = 'image' AND hostImage_reference.hidden=0 AND hostImage_reference.deleted=0 LEFT JOIN sys_file_metadata hostImage_file ON hostImage_reference.uid_local = hostImage_file.file
LEFT JOIN tx_amsmedialibrary_episodes_fk_guests_mm
ON tx_amsmedialibrary_episodes_fk_guests_mm.uid_local = tx_amsmedialibrary_episodes.uid
LEFT JOIN tx_amsmedialibrary_persons guests
ON guests.uid = tx_amsmedialibrary_episodes_fk_guests_mm.uid_foreign AND guests.hidden=0 AND guests.deleted=0 LEFT JOIN sys_file_reference guestThumbnail_reference ON guestThumbnail_reference.uid_foreign = guests.uid
AND guestThumbnail_reference.tablenames = 'tx_amsmedialibrary_persons'
AND guestThumbnail_reference.fieldname = 'thumbnail' AND guestThumbnail_reference.hidden=0 AND guestThumbnail_reference.deleted=0 LEFT JOIN sys_file_metadata guestThumbnail_file ON guestThumbnail_reference.uid_local = guestThumbnail_file.file LEFT JOIN sys_file_reference guestImage_reference ON guestImage_reference.uid_foreign = guests.uid
AND guestImage_reference.tablenames = 'tx_amsmedialibrary_persons'
AND guestImage_reference.fieldname = 'image' AND guestImage_reference.hidden=0 AND guestImage_reference.deleted=0 LEFT JOIN sys_file_metadata guestImage_file ON guestImage_reference.uid_local = guestImage_file.file
LEFT JOIN tx_amsmedialibrary_links
ON tx_amsmedialibrary_links.irre_uid = tx_amsmedialibrary_episodes.uid
AND tx_amsmedialibrary_links.irre_table = 'tx_amsmedialibrary_episodes' AND tx_amsmedialibrary_links.hidden=0 AND tx_amsmedialibrary_links.deleted=0
LEFT JOIN tx_amslanguages_languages
ON tx_amslanguages_languages.uid = tx_amsmedialibrary_episodes.fk_language AND tx_amslanguages_languages.hidden=0 AND tx_amslanguages_languages.deleted=0 LEFT JOIN sys_file_reference episodeImage_reference ON episodeImage_reference.uid_foreign = tx_amsmedialibrary_episodes.uid
AND episodeImage_reference.tablenames = 'tx_amsmedialibrary_episodes'
AND episodeImage_reference.fieldname = 'image' AND episodeImage_reference.hidden=0 AND episodeImage_reference.deleted=0 LEFT JOIN sys_file_metadata episodeImage_file ON episodeImage_reference.uid_local = episodeImage_file.file LEFT JOIN sys_file_reference showImage_reference ON showImage_reference.uid_foreign = tx_amsmedialibrary_shows.uid
AND showImage_reference.tablenames = 'tx_amsmedialibrary_shows'
AND showImage_reference.fieldname = 'image' AND showImage_reference.hidden=0 AND showImage_reference.deleted=0 LEFT JOIN sys_file_metadata showImage_file ON showImage_reference.uid_local = showImage_file.file LEFT JOIN sys_file_reference episodeDocuments_reference ON episodeDocuments_reference.uid_foreign = tx_amsmedialibrary_episodes.uid
AND episodeDocuments_reference.tablenames = 'tx_amsmedialibrary_episodes'
AND episodeDocuments_reference.fieldname = 'documents' AND episodeDocuments_reference.hidden=0 AND episodeDocuments_reference.deleted=0 LEFT JOIN sys_file_metadata episodeDocuments_file ON episodeDocuments_reference.uid_local = episodeDocuments_file.file LEFT JOIN sys_file_reference seasonDocuments_reference ON seasonDocuments_reference.uid_foreign = tx_amsmedialibrary_seasons.uid
AND seasonDocuments_reference.tablenames = 'tx_amsmedialibrary_seasons'
AND seasonDocuments_reference.fieldname = 'documents' AND seasonDocuments_reference.hidden=0 AND seasonDocuments_reference.deleted=0 LEFT JOIN sys_file_metadata seasonDocuments_file ON seasonDocuments_reference.uid_local = seasonDocuments_file.file LEFT JOIN sys_file_reference videoImage_reference ON videoImage_reference.uid_foreign = tx_amsmedialibrary_videos.uid
AND videoImage_reference.tablenames = 'tx_amsmedialibrary_videos'
AND videoImage_reference.fieldname = 'image' AND videoImage_reference.hidden=0 AND videoImage_reference.deleted=0 LEFT JOIN sys_file_metadata videoImage_file ON videoImage_reference.uid_local = videoImage_file.file LEFT JOIN sys_file_reference showDocuments_reference ON showDocuments_reference.uid_foreign = tx_amsmedialibrary_shows.uid
AND showDocuments_reference.tablenames = 'tx_amsmedialibrary_shows'
AND showDocuments_reference.fieldname = 'documents' AND showDocuments_reference.hidden=0 AND showDocuments_reference.deleted=0 LEFT JOIN sys_file_metadata showDocuments_file ON showDocuments_reference.uid_local = showDocuments_file.file
LEFT JOIN tx_amsmedialibrary_import_ids
ON tx_amsmedialibrary_import_ids.irre_uid = tx_amsmedialibrary_episodes.uid
AND tx_amsmedialibrary_import_ids.irre_table = 'tx_amsmedialibrary_episodes' AND tx_amsmedialibrary_import_ids.hidden=0 AND tx_amsmedialibrary_import_ids.deleted=0
LEFT JOIN tx_amsmedialibrary_import_sources
ON tx_amsmedialibrary_import_sources.uid = tx_amsmedialibrary_import_ids.fk_import_source AND tx_amsmedialibrary_import_sources.hidden=0 AND tx_amsmedialibrary_import_sources.deleted=0
LEFT 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_media_formats
ON tx_amsmedialibrary_media_formats.uid = tx_amsmedialibrary_media_links.fk_media_format AND tx_amsmedialibrary_media_formats.hidden=0 AND tx_amsmedialibrary_media_formats.deleted=0
LEFT JOIN tx_amstags_categories_mm
ON tx_amstags_categories_mm.uid_local = tx_amsmedialibrary_episodes.uid
AND tx_amstags_categories_mm.tablename = 'tx_amsmedialibrary_episodes'
LEFT JOIN tx_amstags_categories
ON tx_amstags_categories.uid = tx_amstags_categories_mm.uid_foreign AND tx_amstags_categories.hidden=0 AND tx_amstags_categories.deleted=0
LEFT JOIN tx_amstags_tags_mm
ON tx_amstags_tags_mm.uid_local = tx_amsmedialibrary_episodes.uid
AND tx_amstags_tags_mm.tablename = 'tx_amsmedialibrary_episodes'
LEFT JOIN tx_amstags_tags
ON tx_amstags_tags.uid = tx_amstags_tags_mm.uid_foreign AND tx_amstags_tags.hidden=0 AND tx_amstags_tags.deleted=0 WHERE tx_amsmedialibrary_episodes.uid = 4 AND tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_web_hidden = 0 AND tx_amsmedialibrary_episodes.hidden=0 AND (tx_amsmedialibrary_episodes.starttime<=1606405260) AND (tx_amsmedialibrary_episodes.endtime=0 OR tx_amsmedialibrary_episodes.endtime>1606405260) AND tx_amsmedialibrary_episodes.deleted=0 ORDER BY tx_amsmedialibrary_episodes_fk_hosts_mm.sorting,
tx_amsmedialibrary_episodes_fk_guests_mm.sorting,
episodeDocuments_reference.sorting DESC,
seasonDocuments_reference.sorting DESC,
showDocuments_reference.sorting DESC,
seasonLinks.sorting,
showLinks.sorting,
tx_amsmedialibrary_links.sorting,
tx_amsmedialibrary_videos.sorting,
tx_amsmedialibrary_video_categories.sorting,
tx_amsmedialibrary_media_links.sorting,
tx_amstags_categories_mm.sorting,
tx_amstags_tags_mm.sorting
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_34a515001ce7fa4507b223bafbe0fabd8e16da23->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#148 // 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_Sidebar_f1fcabf4cafb3d9922995e88ee0589484ddd880f->render#279 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->initializeArgumentsAndRender#59 // 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\EpisodeDetail->render#122 // DeStimmeDerHoffnung\AmsMedialibrary\Domain\Database\DataAccess->getEpisode#85 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#1677 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#305
exec_SELECTquery
caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
ERROR Unknown column 'tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_web_hidden' in 'where clause'
lastBuiltQuery SELECT
tx_amsmedialibrary_episodes.uid episodeUid,
tx_amsmedialibrary_episodes.pid episodePid,
tx_amsmedialibrary_episodes.hidden episodeHidden,
tx_amsmedialibrary_episodes.tstamp episodeTstamp,
tx_amsmedialibrary_episodes.crdate episodeCrdate,
tx_amsmedialibrary_episodes.starttime episodeStartTime,
tx_amsmedialibrary_episodes.endtime episodeEndTime,
tx_amsmedialibrary_episodes.title episodeTitle,
tx_amsmedialibrary_episodes.fk_channel episodeChannelUid,
tx_amsmedialibrary_episodes.fk_show episodeShowUid,
tx_amsmedialibrary_episodes.fk_language episodeLanguageUid,
tx_amsmedialibrary_episodes.short_description episodeShortDescription,
tx_amsmedialibrary_episodes.long_description episodeLongDescription,
tx_amsmedialibrary_episodes.videos_title episodeVideosTitle,
tx_amsmedialibrary_episodes.featured episodeFeatured,
tx_amsmedialibrary_episodes.downloadable episodeDownloadable,
tx_amsmedialibrary_episodes.avg_rating episodeAverageRating,
tx_amsmedialibrary_episodes.plays episodePlays,
tx_amsmedialibrary_channels.uid channelUid,
tx_amsmedialibrary_channels.pid channelPid,
tx_amsmedialibrary_channels.title channelTitle,
tx_amsmedialibrary_channels.media_type channelMediaType,
tx_amsmedialibrary_channels.globally_available channelGloballyAvailable,
tx_amsmedialibrary_channels.logo channelLogo,
tx_amsmedialibrary_channels.short_description channelShortDescription,
tx_amsmedialibrary_channels.long_description channelLongDescription,
tx_amsmedialibrary_channels.support_email channelSupportEmail,
tx_amsmedialibrary_channels.website channelWebsite,
tx_amsmedialibrary_channels.show_url channelShowUrl,
tx_amsmedialibrary_channels.episode_url channelEpisodeUrl,
tx_amsmedialibrary_channels.fk_default_language channelDefaultLanguageUid,
tx_amsmedialibrary_shows.uid showUid,
tx_amsmedialibrary_shows.pid showPid,
tx_amsmedialibrary_shows.hidden showHidden,
tx_amsmedialibrary_shows.crdate showCrdate,
tx_amsmedialibrary_shows.title showTitle,
tx_amsmedialibrary_shows.fk_channel showChannelUid,
tx_amsmedialibrary_shows.media_type showMediaType,
tx_amsmedialibrary_shows.fk_language showLanguageUid,
tx_amsmedialibrary_shows.anchor_show_published showAnchorShowPublished,
tx_amsmedialibrary_shows.featured showFeatured,
tx_amsmedialibrary_shows.episodes_downloadable showEpisodesDownloadable,
tx_amsmedialibrary_shows.short_description showShortDescription,
tx_amsmedialibrary_shows.long_description showLongDescription,
tx_amsmedialibrary_shows.videos_title showVideosTitle,
tx_amsmedialibrary_shows.contact_email showContactEmail,
tx_amsmedialibrary_shows.dominant_image_color showDominantImageColor,
tx_amsmedialibrary_shows.image_folder showImageFolder,
tx_amsmedialibrary_shows.document_folder showDocumentFolder,
tx_amsmedialibrary_shows.fk_anchor_show_pid showAnchorShowPid,
tx_amsmedialibrary_shows.fk_episodes_list_pid showEpisodesListPid,
tx_amsmedialibrary_shows.fk_episode_detail_pid showEpisodeDetailPid,
tx_amsmedialibrary_shows.fk_video_detail_pid showVideoDetailPid,
tx_amsmedialibrary_shows.fk_host_detail_pid showHostDetailPid,
tx_amsmedialibrary_shows.fk_guest_detail_pid showGuestDetailPid,
tx_amsmedialibrary_shows.rss_categories rssCategories,
tx_amsmedialibrary_shows.rss_subcategories rssSubcategories,
tx_amsmedialibrary_shows.season_numbers_rss seasonNumbersRss,
hosts.uid hostUid,
hosts.gender hostGender,
hosts.prefix hostPrefix,
hosts.first_name hostFirstName,
hosts.middle_name hostMiddleName,
hosts.last_name hostLastName,
hosts.suffix hostSuffix,
hosts.thumbnail hostThumbnail,
hosts.image hostImage,
hosts.description hostDescription,
hosts.email hostEmail,
guests.uid guestUid,
guests.gender guestGender,
guests.prefix guestPrefix,
guests.first_name guestFirstName,
guests.middle_name guestMiddleName,
guests.last_name guestLastName,
guests.suffix guestSuffix,
guests.thumbnail guestThumbnail,
guests.image guestImage,
guests.description guestDescription,
guests.email guestEmail,
tx_amsmedialibrary_links.uid linkUid,
tx_amsmedialibrary_links.link_type linkLinkType,
tx_amsmedialibrary_links.link linkLink,
tx_amsmedialibrary_links.title linkTitle,
seasonLinks.uid seasonLinkUid,
seasonLinks.link_type seasonLinkLinkType,
seasonLinks.link seasonLinkLink,
seasonLinks.title seasonLinkTitle,
showLinks.uid showLinkUid,
showLinks.link_type showLinkLinkType,
showLinks.link showLinkLink,
showLinks.title showLinkTitle,
tx_amsmedialibrary_videos.uid videoUid,
tx_amsmedialibrary_videos.pid videoPid,
tx_amsmedialibrary_videos.crdate videoCrdate,
tx_amsmedialibrary_videos.irre_table videoParentTable,
tx_amsmedialibrary_videos.irre_uid videoParentUid,
tx_amsmedialibrary_videos.sorting videoSorting,
tx_amsmedialibrary_videos.title videoTitle,
tx_amsmedialibrary_videos.short_description videoShortDescription,
tx_amsmedialibrary_videos.long_description videoLongDescription,
tx_amsmedialibrary_videos.fk_media_format videoMediaFormatUid,
tx_amsmedialibrary_videos.fk_import_source videoImportSourceUid,
tx_amsmedialibrary_videos.link videoLink,
tx_amsmedialibrary_video_categories.uid videoCategoryUid,
tx_amsmedialibrary_video_categories.irre_uid videoCategoryShowUid,
tx_amsmedialibrary_video_categories.title videoCategoryTitle,
tx_amsmedialibrary_import_ids.uid importIdUid,
tx_amsmedialibrary_import_ids.hidden importIdHidden,
tx_amsmedialibrary_import_ids.irre_uid importIdEpisodeUid,
tx_amsmedialibrary_import_ids.fk_channel importIdChannelUid,
tx_amsmedialibrary_import_ids.fk_import_source importIdImportSourceUid,
tx_amsmedialibrary_import_ids.import_id importIdImportId,
tx_amsmedialibrary_media_links.uid mediaLinkUid,
tx_amsmedialibrary_media_links.link mediaLinkLink,
tx_amsmedialibrary_media_links.fk_media_format mediaLinkMediaFormatUid,
tx_amsmedialibrary_media_links.fk_import_source mediaLinkImportSourceUid,
tx_amsmedialibrary_media_links.aspect_ratio mediaLinkAspectRatio,
tx_amsmedialibrary_media_links.file_size mediaLinkFileSize,
tx_amsmedialibrary_media_links.duration mediaLinkDuration,
tx_amsmedialibrary_media_formats.uid mediaFormatUid,
tx_amsmedialibrary_media_formats.title mediaFormatTitle,
tx_amsmedialibrary_media_formats.media_type mediaFormatMediaType,
tx_amsmedialibrary_media_formats.file_size_service mediaFormatFileSizeService,
tx_amsmedialibrary_media_formats.duration_service mediaFormatDurationService,
tx_amsmedialibrary_import_sources.uid importSourceUid,
tx_amsmedialibrary_import_sources.title importSourceTitle,
tx_amsmedialibrary_import_sources.media_link_generation importSourceMediaLinkGeneration,
tx_amsmedialibrary_import_sources.api_key importSourceApiKey,
tx_amsmedialibrary_import_sources.api_secret importSourceApiSecret,
tx_amsmedialibrary_import_sources.account_id importSourceAccountId,
tx_amsmedialibrary_import_sources.player_id importSourcePlayerId,
tx_amsmedialibrary_import_sources.policy_key importSourcePolicyKey,
tx_amsmedialibrary_seasons.uid seasonUid,
tx_amsmedialibrary_seasons.number seasonNumber,
tx_amsmedialibrary_seasons.title seasonTitle,
tx_amsmedialibrary_seasons.description seasonDescription,
tx_amsmedialibrary_seasons.group_name seasonGroupName,episodeImage_reference.uid episodeImageUid,episodeImage_reference.uid_local episodeImageFileUid,
if (episodeImage_reference.title <> '', episodeImage_reference.title, episodeImage_file.title) episodeImageTitle,
if (episodeImage_reference.alternative <> '', episodeImage_reference.alternative, episodeImage_file.alternative) episodeImageAlternative,
if (episodeImage_reference.description <> '', episodeImage_reference.description, episodeImage_file.description) episodeImageDescription,
episodeImage_reference.link episodeImageLink,episodeDocuments_reference.uid episodeDocumentsUid,episodeDocuments_reference.uid_local episodeDocumentsFileUid,
if (episodeDocuments_reference.title <> '', episodeDocuments_reference.title, episodeDocuments_file.title) episodeDocumentsTitle,
if (episodeDocuments_reference.alternative <> '', episodeDocuments_reference.alternative, episodeDocuments_file.alternative) episodeDocumentsAlternative,
if (episodeDocuments_reference.description <> '', episodeDocuments_reference.description, episodeDocuments_file.description) episodeDocumentsDescription,
episodeDocuments_reference.link episodeDocumentsLink,seasonDocuments_reference.uid seasonDocumentsUid,seasonDocuments_reference.uid_local seasonDocumentsFileUid,
if (seasonDocuments_reference.title <> '', seasonDocuments_reference.title, seasonDocuments_file.title) seasonDocumentsTitle,
if (seasonDocuments_reference.alternative <> '', seasonDocuments_reference.alternative, seasonDocuments_file.alternative) seasonDocumentsAlternative,
if (seasonDocuments_reference.description <> '', seasonDocuments_reference.description, seasonDocuments_file.description) seasonDocumentsDescription,
seasonDocuments_reference.link seasonDocumentsLink,showDocuments_reference.uid showDocumentsUid,showDocuments_reference.uid_local showDocumentsFileUid,
if (showDocuments_reference.title <> '', showDocuments_reference.title, showDocuments_file.title) showDocumentsTitle,
if (showDocuments_reference.alternative <> '', showDocuments_reference.alternative, showDocuments_file.alternative) showDocumentsAlternative,
if (showDocuments_reference.description <> '', showDocuments_reference.description, showDocuments_file.description) showDocumentsDescription,
showDocuments_reference.link showDocumentsLink,hostThumbnail_reference.uid hostThumbnailUid,hostThumbnail_reference.uid_local hostThumbnailFileUid,
if (hostThumbnail_reference.title <> '', hostThumbnail_reference.title, hostThumbnail_file.title) hostThumbnailTitle,
if (hostThumbnail_reference.alternative <> '', hostThumbnail_reference.alternative, hostThumbnail_file.alternative) hostThumbnailAlternative,
if (hostThumbnail_reference.description <> '', hostThumbnail_reference.description, hostThumbnail_file.description) hostThumbnailDescription,
hostThumbnail_reference.link hostThumbnailLink,hostImage_reference.uid hostImageUid,hostImage_reference.uid_local hostImageFileUid,
if (hostImage_reference.title <> '', hostImage_reference.title, hostImage_file.title) hostImageTitle,
if (hostImage_reference.alternative <> '', hostImage_reference.alternative, hostImage_file.alternative) hostImageAlternative,
if (hostImage_reference.description <> '', hostImage_reference.description, hostImage_file.description) hostImageDescription,
hostImage_reference.link hostImageLink,guestThumbnail_reference.uid guestThumbnailUid,guestThumbnail_reference.uid_local guestThumbnailFileUid,
if (guestThumbnail_reference.title <> '', guestThumbnail_reference.title, guestThumbnail_file.title) guestThumbnailTitle,
if (guestThumbnail_reference.alternative <> '', guestThumbnail_reference.alternative, guestThumbnail_file.alternative) guestThumbnailAlternative,
if (guestThumbnail_reference.description <> '', guestThumbnail_reference.description, guestThumbnail_file.description) guestThumbnailDescription,
guestThumbnail_reference.link guestThumbnailLink,guestImage_reference.uid guestImageUid,guestImage_reference.uid_local guestImageFileUid,
if (guestImage_reference.title <> '', guestImage_reference.title, guestImage_file.title) guestImageTitle,
if (guestImage_reference.alternative <> '', guestImage_reference.alternative, guestImage_file.alternative) guestImageAlternative,
if (guestImage_reference.description <> '', guestImage_reference.description, guestImage_file.description) guestImageDescription,
guestImage_reference.link guestImageLink,showImage_reference.uid showImageUid,showImage_reference.uid_local showImageFileUid,
if (showImage_reference.title <> '', showImage_reference.title, showImage_file.title) showImageTitle,
if (showImage_reference.alternative <> '', showImage_reference.alternative, showImage_file.alternative) showImageAlternative,
if (showImage_reference.description <> '', showImage_reference.description, showImage_file.description) showImageDescription,
showImage_reference.link showImageLink,videoImage_reference.uid videoImageUid,videoImage_reference.uid_local videoImageFileUid,
if (videoImage_reference.title <> '', videoImage_reference.title, videoImage_file.title) videoImageTitle,
if (videoImage_reference.alternative <> '', videoImage_reference.alternative, videoImage_file.alternative) videoImageAlternative,
if (videoImage_reference.description <> '', videoImage_reference.description, videoImage_file.description) videoImageDescription,
videoImage_reference.link videoImageLink,
tx_amslanguages_languages.uid languageUid,
tx_amslanguages_languages.title languageTitle,
tx_amslanguages_languages.isooftitle languageIsoOfName,
tx_amslanguages_languages.ietfoftitle languageIetfOfName,
tx_amstags_categories.uid categoryUid,
tx_amstags_categories.l10n_parent parentCategoryUid,
tx_amstags_categories.title categoryTitle,
tx_amstags_categories.description categoryDescription,
tx_amstags_tags.uid tagUid,
tx_amstags_tags.title tagTitle,
tx_amstags_tags.fk_group tagGroupUid,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_start_time showVodStartTime,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_end_time showVodEndTime,
tx_amsmedialibrary_shows.tx_amsbroadcast_vod_hidden showVodHidden,
tx_amsmedialibrary_episodes.tx_amsbroadcast_first_air_date episodeFirstAirDate,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_start_time episodeVodStartTime,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_end_time episodeVodEndTime,
tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_hidden episodeVodHidden FROM tx_amsmedialibrary_episodes
JOIN tx_amsmedialibrary_channels
ON tx_amsmedialibrary_channels.uid = tx_amsmedialibrary_episodes.fk_channel AND tx_amsmedialibrary_channels.hidden=0 AND tx_amsmedialibrary_channels.deleted=0
LEFT JOIN tx_amsmedialibrary_shows
ON tx_amsmedialibrary_shows.uid = tx_amsmedialibrary_episodes.fk_show AND tx_amsmedialibrary_shows.hidden=0 AND tx_amsmedialibrary_shows.deleted=0
LEFT JOIN tx_amsmedialibrary_video_categories
ON tx_amsmedialibrary_video_categories.irre_uid = tx_amsmedialibrary_shows.uid
AND tx_amsmedialibrary_video_categories.irre_table = 'tx_amsmedialibrary_shows' AND tx_amsmedialibrary_video_categories.hidden=0 AND tx_amsmedialibrary_video_categories.deleted=0
LEFT JOIN tx_amsmedialibrary_links showLinks
ON showLinks.irre_uid = tx_amsmedialibrary_shows.uid
AND showLinks.irre_table = 'tx_amsmedialibrary_shows' AND showLinks.hidden=0 AND showLinks.deleted=0
LEFT JOIN tx_amsmedialibrary_videos
ON tx_amsmedialibrary_videos.irre_uid = tx_amsmedialibrary_episodes.uid
AND tx_amsmedialibrary_videos.irre_table = 'tx_amsmedialibrary_episodes' AND tx_amsmedialibrary_videos.hidden=0 AND tx_amsmedialibrary_videos.deleted=0
LEFT JOIN tx_amsmedialibrary_seasons
ON tx_amsmedialibrary_seasons.uid = tx_amsmedialibrary_episodes.fk_season AND tx_amsmedialibrary_seasons.hidden=0 AND tx_amsmedialibrary_seasons.deleted=0
LEFT JOIN tx_amsmedialibrary_links seasonLinks
ON seasonLinks.irre_uid = tx_amsmedialibrary_seasons.uid
AND seasonLinks.irre_table = 'tx_amsmedialibrary_seasons' AND seasonLinks.hidden=0 AND seasonLinks.deleted=0
LEFT JOIN tx_amsmedialibrary_episodes_fk_hosts_mm
ON tx_amsmedialibrary_episodes_fk_hosts_mm.uid_local = tx_amsmedialibrary_episodes.uid
LEFT JOIN tx_amsmedialibrary_persons hosts
ON hosts.uid = tx_amsmedialibrary_episodes_fk_hosts_mm.uid_foreign AND hosts.hidden=0 AND hosts.deleted=0 LEFT JOIN sys_file_reference hostThumbnail_reference ON hostThumbnail_reference.uid_foreign = hosts.uid
AND hostThumbnail_reference.tablenames = 'tx_amsmedialibrary_persons'
AND hostThumbnail_reference.fieldname = 'thumbnail' AND hostThumbnail_reference.hidden=0 AND hostThumbnail_reference.deleted=0 LEFT JOIN sys_file_metadata hostThumbnail_file ON hostThumbnail_reference.uid_local = hostThumbnail_file.file LEFT JOIN sys_file_reference hostImage_reference ON hostImage_reference.uid_foreign = hosts.uid
AND hostImage_reference.tablenames = 'tx_amsmedialibrary_persons'
AND hostImage_reference.fieldname = 'image' AND hostImage_reference.hidden=0 AND hostImage_reference.deleted=0 LEFT JOIN sys_file_metadata hostImage_file ON hostImage_reference.uid_local = hostImage_file.file
LEFT JOIN tx_amsmedialibrary_episodes_fk_guests_mm
ON tx_amsmedialibrary_episodes_fk_guests_mm.uid_local = tx_amsmedialibrary_episodes.uid
LEFT JOIN tx_amsmedialibrary_persons guests
ON guests.uid = tx_amsmedialibrary_episodes_fk_guests_mm.uid_foreign AND guests.hidden=0 AND guests.deleted=0 LEFT JOIN sys_file_reference guestThumbnail_reference ON guestThumbnail_reference.uid_foreign = guests.uid
AND guestThumbnail_reference.tablenames = 'tx_amsmedialibrary_persons'
AND guestThumbnail_reference.fieldname = 'thumbnail' AND guestThumbnail_reference.hidden=0 AND guestThumbnail_reference.deleted=0 LEFT JOIN sys_file_metadata guestThumbnail_file ON guestThumbnail_reference.uid_local = guestThumbnail_file.file LEFT JOIN sys_file_reference guestImage_reference ON guestImage_reference.uid_foreign = guests.uid
AND guestImage_reference.tablenames = 'tx_amsmedialibrary_persons'
AND guestImage_reference.fieldname = 'image' AND guestImage_reference.hidden=0 AND guestImage_reference.deleted=0 LEFT JOIN sys_file_metadata guestImage_file ON guestImage_reference.uid_local = guestImage_file.file
LEFT JOIN tx_amsmedialibrary_links
ON tx_amsmedialibrary_links.irre_uid = tx_amsmedialibrary_episodes.uid
AND tx_amsmedialibrary_links.irre_table = 'tx_amsmedialibrary_episodes' AND tx_amsmedialibrary_links.hidden=0 AND tx_amsmedialibrary_links.deleted=0
LEFT JOIN tx_amslanguages_languages
ON tx_amslanguages_languages.uid = tx_amsmedialibrary_episodes.fk_language AND tx_amslanguages_languages.hidden=0 AND tx_amslanguages_languages.deleted=0 LEFT JOIN sys_file_reference episodeImage_reference ON episodeImage_reference.uid_foreign = tx_amsmedialibrary_episodes.uid
AND episodeImage_reference.tablenames = 'tx_amsmedialibrary_episodes'
AND episodeImage_reference.fieldname = 'image' AND episodeImage_reference.hidden=0 AND episodeImage_reference.deleted=0 LEFT JOIN sys_file_metadata episodeImage_file ON episodeImage_reference.uid_local = episodeImage_file.file LEFT JOIN sys_file_reference showImage_reference ON showImage_reference.uid_foreign = tx_amsmedialibrary_shows.uid
AND showImage_reference.tablenames = 'tx_amsmedialibrary_shows'
AND showImage_reference.fieldname = 'image' AND showImage_reference.hidden=0 AND showImage_reference.deleted=0 LEFT JOIN sys_file_metadata showImage_file ON showImage_reference.uid_local = showImage_file.file LEFT JOIN sys_file_reference episodeDocuments_reference ON episodeDocuments_reference.uid_foreign = tx_amsmedialibrary_episodes.uid
AND episodeDocuments_reference.tablenames = 'tx_amsmedialibrary_episodes'
AND episodeDocuments_reference.fieldname = 'documents' AND episodeDocuments_reference.hidden=0 AND episodeDocuments_reference.deleted=0 LEFT JOIN sys_file_metadata episodeDocuments_file ON episodeDocuments_reference.uid_local = episodeDocuments_file.file LEFT JOIN sys_file_reference seasonDocuments_reference ON seasonDocuments_reference.uid_foreign = tx_amsmedialibrary_seasons.uid
AND seasonDocuments_reference.tablenames = 'tx_amsmedialibrary_seasons'
AND seasonDocuments_reference.fieldname = 'documents' AND seasonDocuments_reference.hidden=0 AND seasonDocuments_reference.deleted=0 LEFT JOIN sys_file_metadata seasonDocuments_file ON seasonDocuments_reference.uid_local = seasonDocuments_file.file LEFT JOIN sys_file_reference videoImage_reference ON videoImage_reference.uid_foreign = tx_amsmedialibrary_videos.uid
AND videoImage_reference.tablenames = 'tx_amsmedialibrary_videos'
AND videoImage_reference.fieldname = 'image' AND videoImage_reference.hidden=0 AND videoImage_reference.deleted=0 LEFT JOIN sys_file_metadata videoImage_file ON videoImage_reference.uid_local = videoImage_file.file LEFT JOIN sys_file_reference showDocuments_reference ON showDocuments_reference.uid_foreign = tx_amsmedialibrary_shows.uid
AND showDocuments_reference.tablenames = 'tx_amsmedialibrary_shows'
AND showDocuments_reference.fieldname = 'documents' AND showDocuments_reference.hidden=0 AND showDocuments_reference.deleted=0 LEFT JOIN sys_file_metadata showDocuments_file ON showDocuments_reference.uid_local = showDocuments_file.file
LEFT JOIN tx_amsmedialibrary_import_ids
ON tx_amsmedialibrary_import_ids.irre_uid = tx_amsmedialibrary_episodes.uid
AND tx_amsmedialibrary_import_ids.irre_table = 'tx_amsmedialibrary_episodes' AND tx_amsmedialibrary_import_ids.hidden=0 AND tx_amsmedialibrary_import_ids.deleted=0
LEFT JOIN tx_amsmedialibrary_import_sources
ON tx_amsmedialibrary_import_sources.uid = tx_amsmedialibrary_import_ids.fk_import_source AND tx_amsmedialibrary_import_sources.hidden=0 AND tx_amsmedialibrary_import_sources.deleted=0
LEFT 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_media_formats
ON tx_amsmedialibrary_media_formats.uid = tx_amsmedialibrary_media_links.fk_media_format AND tx_amsmedialibrary_media_formats.hidden=0 AND tx_amsmedialibrary_media_formats.deleted=0
LEFT JOIN tx_amstags_categories_mm
ON tx_amstags_categories_mm.uid_local = tx_amsmedialibrary_episodes.uid
AND tx_amstags_categories_mm.tablename = 'tx_amsmedialibrary_episodes'
LEFT JOIN tx_amstags_categories
ON tx_amstags_categories.uid = tx_amstags_categories_mm.uid_foreign AND tx_amstags_categories.hidden=0 AND tx_amstags_categories.deleted=0
LEFT JOIN tx_amstags_tags_mm
ON tx_amstags_tags_mm.uid_local = tx_amsmedialibrary_episodes.uid
AND tx_amstags_tags_mm.tablename = 'tx_amsmedialibrary_episodes'
LEFT JOIN tx_amstags_tags
ON tx_amstags_tags.uid = tx_amstags_tags_mm.uid_foreign AND tx_amstags_tags.hidden=0 AND tx_amstags_tags.deleted=0 WHERE tx_amsmedialibrary_episodes.uid = 4 AND tx_amsmedialibrary_episodes.tx_amsbroadcast_vod_web_hidden = 0 AND tx_amsmedialibrary_episodes.hidden=0 AND (tx_amsmedialibrary_episodes.starttime<=1606405260) AND (tx_amsmedialibrary_episodes.endtime=0 OR tx_amsmedialibrary_episodes.endtime>1606405260) AND tx_amsmedialibrary_episodes.deleted=0 ORDER BY tx_amsmedialibrary_episodes_fk_hosts_mm.sorting,
tx_amsmedialibrary_episodes_fk_guests_mm.sorting,
episodeDocuments_reference.sorting DESC,
seasonDocuments_reference.sorting DESC,
showDocuments_reference.sorting DESC,
seasonLinks.sorting,
showLinks.sorting,
tx_amsmedialibrary_links.sorting,
tx_amsmedialibrary_videos.sorting,
tx_amsmedialibrary_video_categories.sorting,
tx_amsmedialibrary_media_links.sorting,
tx_amstags_categories_mm.sorting,
tx_amstags_tags_mm.sorting
debug_backtrace require(/typo3/sysext/cms/tslib/index_ts.php),/index.php#28 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript#232 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->recursivelyReplaceIntPlaceholdersInContent#3646 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript_process#3679 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->USER#3731 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#862 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#41 // call_user_func_array#6663 // DeStimmeDerHoffnung\AmsMedialibrary\Plugins\Plugin1->main# // DeStimmeDerHoffnung\AmsMedialibrary\Plugins\Views\EpisodesTeaser->render#122 // DeStimmeDerHoffnung\AmsMedialibrary\Plugins\Views\EpisodesTeaser->getRelatedEpisodes#109 // DeStimmeDerHoffnung\AmsMedialibrary\Domain\Database\DataAccess->getEpisode#452 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#1677 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#305
Episode: Hope TV Deutsch | Podcasts | Fernkurse | Hörbücher

Episode