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 = '25' OR CONCAT('|', c.extra_parents, '|') LIKE '%|25|%')
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