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 = 7107 OR a.id = 7106 OR a.id = 7090 OR a.id = 6983 OR a.id = 6973 OR a.id = 6957 OR a.id = 6935 OR a.id = 6934 OR a.id = 6933 OR a.id = 6932 OR a.id = 6931 OR a.id = 6930 OR a.id = 6929 OR a.id = 6882 OR a.id = 6863 OR a.id = 6853 OR a.id = 6831 OR a.id = 6699 OR a.id = 6557 OR a.id = 6543) GROUP BY a.id, at.id, oc.object_id ORDER BY a.id ASC, hascontent DESC, preflang DESC | |
);)