Notice: Error: Unknown column 'p2cc.language_id' in 'where clause'
Error No: 1054
SELECT p.product_id, p.image, pd.description,, p.sort_order, (SELECT sort_order FROM category WHERE category_id = (SELECT c.parent_id FROM category c LEFT JOIN product_to_category p2cc ON (c.category_id = p2cc.category_id) WHERE p2cc.language_id = '2' AND p2cc.product_id = p.product_id AND c.type = 'main' AND c.parent_id > '0' ORDER BY c.sort_order DESC) ) AS category, (SELECT sort_order FROM category WHERE category_id = (SELECT parent_id FROM category WHERE category_id = (SELECT parent_id FROM category WHERE type = 'category' AND category_id IN(SELECT category_id FROM product_to_category WHERE product_id = p.product_id)) LIMIT 1) ) AS parent, GROUP_CONCAT(DISTINCT CONCAT(i.interesting_id, ':', id.title, ':', i.icon) SEPARATOR '|') AS interesting, MAX(p2c.category_id) AS category_id FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_interesting p2i ON (p2i.product_id = p.product_id) LEFT JOIN interesting i ON (i.interesting_id = p2i.interesting_id) LEFT JOIN interesting_description id ON (id.interesting_id = i.interesting_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p2c.category_id = '347' GROUP BY p.product_id ORDER BY parent, category, p.sort_order in /home/la2tera/ on line 49