MySQL Error has occured
Unknown column 'archives.title' in 'field list'
Tuesday, March 28, 2023 at 5:13:08 AM
SELECT
`shows`.`id_show`,
`shows`.`id_work`,
`shows`.`id_showtype`,
`shows`.`id_archive`,
`shows`.`director`,
`shows`.`d_publishfrom`,
`shows`.`url_ticket`,
`shows`.`is_show`,
`shows`.`id_seo`,
archives.title AS archive,
works.author,
COALESCE(NULLIF(ens.title, ''), its.title) AS title,
COALESCE(NULLIF(ens.description, ''), its.description) AS description,
COALESCE(NULLIF(ens.infobox, ''), its.infobox) AS infobox,
COALESCE(NULLIF(seo_act.permalink,''), seo_def.permalink) AS permalink,
COALESCE(NULLIF(seo_act.seo_title,''), seo_def.seo_title) AS seo_title,
COALESCE(NULLIF(seo_act.seo_description,''), seo_def.seo_description) AS seo_description,
COALESCE(NULLIF(seo_act.seo_keywords,''), seo_def.seo_keywords) AS seo_keywords
 FROM shows
Left Join `archives` USING(id_archive)
Left Join `works` USING(id_work)
Left Join `shows_dates` ON shows_dates.id_show=shows.id_show
LEFT JOIN `shows_langs` AS `ens` ON `shows`.`id_show` = `ens`.`id_show` AND `ens`.id_lang='en'
LEFT JOIN `shows_langs` AS `its` ON `shows`.`id_show` = `its`.`id_show` AND `its`.id_lang='it'
LEFT JOIN `seos` AS seo_act ON `shows`.`id_seo`=`seo_act`.`id_seo` AND `seo_act`.id_lang='en'
LEFT JOIN `seos` AS seo_def ON `shows`.`id_seo`=`seo_def`.`id_seo` AND `seo_def`.id_lang='it'
 WHERE
`shows`.`is_show`='1' 
 AND
archives.is_active=1 AND ( `shows`.`d_publishfrom` <= '2023-03-28 05:13:08' OR d_publishfrom='0000-00-00 00:00:00')
 GROUP BY shows.id_show
ORDER BY `shows`.`id_archive` ASC, 
shows_dates.dt_date ASC

/web/htdocs/www.teatroverdi-trieste.com/home/index.php at line 221
/web/htdocs/www.teatroverdi-trieste.com/home/controller/super_controller.php at line 479
/web/htdocs/www.teatroverdi-trieste.com/home/library/classes/extra/cursor.php at line 23
/web/htdocs/www.teatroverdi-trieste.com/home/library/classes/extra/cursor.php at line 56
/web/htdocs/www.teatroverdi-trieste.com/home/library/classes/db.php at line 438
/web/htdocs/www.teatroverdi-trieste.com/home/library/classes/db.php at line 420