MySQL Error has occured
Unknown column 'archives.title' in 'field list'
Tuesday, March 28, 2023 at 4:57:50 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,
`its`.`title` as `title`,
`its`.`description` as `description`,
`its`.`infobox` as `infobox`,
`seos`.*
 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 `its` ON `shows`.`id_show` = `its`.`id_show` AND `its`.id_lang='it'
LEFT JOIN `seos` ON `shows`.`id_seo`=`seos`.`id_seo` AND `seos`.id_lang='it'
 WHERE
`shows`.`is_show`='1' 
 AND
archives.is_active=1 AND ( `shows`.`d_publishfrom` <= '2023-03-28 04:57:50' 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