SELECT t1.`id`,t1.`date`,t1.`show_date`,t1.`publisher`,t1.`vol`,t1.`no`,t1.`pp`,t1.`filename`,t1.`file_lang`,t1.`type`,t1.`source`,t2.`title`,t2.`lead`,t3.`name_en` AS p_name,t3.`comment_en` AS p_comment,t3.`homepage` AS p_homepage,t5.`name_en` AS lang,"reviews" AS dir,GROUP_CONCAT( CONCAT(t7.`firstname`,"|||",t7.`lastname`,"|||",t7.`nationality`,"|||",t7.`text_en`,"|||",t7.`homepage`) ORDER BY t7.`lastname` ASC SEPARATOR "[][]" ) AS authors FROM cl_reviews AS t1 LEFT JOIN cl_reviews_details AS t2 ON t1.`id`=t2.`id` AND t2.`lang`="en" LEFT JOIN cl_publishers AS t3 ON t1.`publisher`=t3.`id` LEFT JOIN cl_reviews_authors AS t6 ON t1.`id`=t6.`r_id` LEFT JOIN cl_authors AS t7 ON t6.`a_id`=t7.`id` LEFT JOIN cl_file_langs AS t5 ON t1.`file_lang`=t5.`code` WHERE t1.`book`=9 GROUP BY t1.`id` ORDER BY t1.`date` DESC Unknown column 't1.type' in 'field list'