Error: Unknown column 'c.extra_parents' in 'where clause'
Error No: 1054
SELECT MAX(c.category_id) id, MAX(cd.name) value, MAX(c.image) image, COUNT(*) total FROM `oc_category` c LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id) LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id) LEFT JOIN `oc_product_to_category`p2c ON (c.category_id = p2c.category_id) LEFT JOIN `oc_product` p ON (p.product_id = p2c.product_id) LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id) LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND (c.parent_id = '18' OR CONCAT('|', c.extra_parents, '|') LIKE '%|18|%') GROUP BY c.category_id HAVING COUNT(*) > 0 ORDER BY c.sort_order, LCASE(cd.name) ASC : in /var/www/vhosts/tetepoulidis.gr/syllektiko.gr/system/library/db/mysqli.php on line 76