Unknown column 'a.type_id' in 'on clause'
SELECT a.id 'articleid', at.id 'transid', at.title 'transtitle', at.language_id 'translang', l.label 'langlabel', l.value 'langicon', IF(at.language_id = 112, 1, 0) 'preflang', IF(c.Content_Id IS NULL, 0, 1) 'hascontent', c.Content_Html, IF(LENGTH(c.Content_Image) < 1, i.Content_Image, c.Content_Image) 'Image', UNIX_TIMESTAMP(IF(a.pubdate_start, a.pubdate_start, IF(at.modified, at.modified, at.created))) 'updated', pa.page_id AS 'pagetemplate', oc.priority 'objprio', obj.id 'objid', obj.name1 'objname', otyp.id 'objtypeid', otyp.plural 'objtypelabel', g.id 'agroupid', g.label 'agroupname' FROM ws_articles a, ws_articles_translations at LEFT JOIN ws_articles_groups ag ON ag.article_translation_id = at.id LEFT JOIN ws_content c ON (c.Group_Id = ag.group_id AND c.Lead = '1') LEFT JOIN ws_lists l ON l.id = at.language_id LEFT JOIN ws_content i ON (i.Group_Id = c.Group_Id AND LENGTH(i.Content_Image)>0) LEFT JOIN ws_pages_articles pa ON pa.article_type_id = a.type_id AND pa.site_id = 1 LEFT JOIN ws_objects_content oc ON oc.article_id = at.article_id LEFT JOIN ws_objects obj ON obj.id = oc.object_id LEFT JOIN ws_objects_types otyp ON otyp.id = obj.type_id LEFT JOIN ws_lists g ON g.id = a.type_id WHERE at.article_id = a.id AND (a.id = 22065 OR a.id = 21617 OR a.id = 22115 OR a.id = 21735 OR a.id = 21731 OR a.id = 21730 OR a.id = 21704 OR a.id = 21703 OR a.id = 21702 OR a.id = 21696 OR a.id = 21683 OR a.id = 21672 OR a.id = 21616 OR a.id = 21615 OR a.id = 21614 OR a.id = 21613 OR a.id = 21612 OR a.id = 21611) GROUP BY a.id, at.id, oc.object_id ORDER BY a.id ASC, hascontent DESC, preflang DESC | |
);)