SELECT sc.geolocation,e.id,e.show_id,e.title,e.descr,e.short_descr,e.caption,p.start,p.rerun,p.has_e,e.show_id,s.social_urls,
CONCAT('color_',el.cat_caption) as color_class,
CONCAT('https://media.skaitv.gr/images/','1170/0/',e.image) as img,
CONCAT('https://media.skaitv.gr/images/','630/1200/',e.image) as img2,
CONCAT('https://media.skaitv.gr/images/','250/0/',mi.thumb) as mi_img,
CASE
WHEN emi.media_type=2 THEN CONCAT('https://media.skaitv.gr/images/','250/0/',mi.thumb)
ELSE CONCAT('https://media.skaitv.gr/images/','250/0/',e.image)
END thumb,
emi.media_item_id,
emi.media_type,
mi.title as media_item_title,
mi.description as media_item_description,
mi.show_descr as media_item_show_descr,
mi.filepath as media_item_file,
mi.media_type_id,
mi.nodate,
mi.caption AS mi_caption,
mil.link link2,
mi.drm,
mi.drm2,
mi.subs,
mi.drmflag,
CASE
WHEN mil.link = NULL THEN el.link
ELSE mil.link
END link,
CONCAT('/show/',sc2.caption,'/',sc.caption,'/',s.caption) cat_link,
e.episode_number,
SUBSTRING_INDEX(REPLACE(mi.title, ' | ',' - '),' - ',1) AS title1,
SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(mi.title, ' | ',' - '),' - ',2),' - ',-1) AS title2,
SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(mi.title, ' | ',' - '),' - ',-2),' - ',1) AS title3,
e.meta_title,e.meta_description,e.meta_keywords,
CONCAT('/{{@}}/shows/',sc2.caption,'{{@}}/show/',sc2.caption,'/',sc.caption,'/',s.caption,'{{@}}' , el.link) breadcrumb_links,
CONCAT('Αρχική{{@}}',sc2.title,'{{@}}',s.title,'{{@}}' , e.title) breadcrumb_titles,s.tv_only,cc.caption AS cccaption
FROM program_tv p
INNER JOIN episode e ON e.id=p.episode_id AND site_id=2
INNER JOIN `show` s ON s.id=e.show_id
INNER JOIN show_category sc ON sc.id=s.show_category_id AND sc.caption = 'tote-vs-tora'
INNER JOIN show_category sc2 ON sc2.id=sc.parent_id
INNER JOIN episode_links el ON el.id = e.id AND el.site_id = e.site_id
INNER JOIN episode_media_item emi ON emi.episode_id=e.id
INNER JOIN media_item mi ON mi.id=emi.media_item_id AND mi.deleted=0 AND mi.file_exists=1
LEFT JOIN clip_categories cc ON cc.id=mi.clip_category_id
INNER JOIN media_item_links mil ON mi.id=mil.id AND mil.site_id = e.site_id
WHERE p.episode_id=e.id AND p.rerun=0 AND DATE_FORMAT(p.start,'%Y-%m-%d-%H') = '2026-02-25-21' AND ( p.start < '2026-07-22 15:12:03' OR emi.media_type = 3 )
GROUP BY mi.id
ORDER BY emi.media_type,emi.sort_order
Τότε και Τώρα | Κηδεία
Τότε και Τώρα | Κηδεία - 25/02/2026
Τότε και Τώρα | Κηδεία | Τα bloopers του επεισοδίου
