1054 - Unknown column 'p2c.categories_id' in 'where clause'
-- includes/modules/k24_default.inc (Listing-Query grouped) SELECT * FROM ( SELECT p.products_shippingtime, p.products_model, p.products_variant_id, pd.products_name, pd.products_name_1, p.products_jtltype, p.products_image, p.products_id, p.products_sort, p.products_ordered, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_date_added FROM (products_description pd, products p ) LEFT JOIN manufacturers AS m on p.manufacturers_id = m.manufacturers_id WHERE p.products_status = '1' AND p.manufacturers_id = m.manufacturers_id AND m.manufacturers_id = '75' AND p2c.categories_id = '314307' AND pd.products_id = p.products_id AND pd.language_id = '1' group by p.products_id ORDER BY p.products_sort ASC ) AS T GROUP BY products_variant_id ORDER BY T.products_sort ASC, T.products_date_added DESC
[SQL Error]