Error: Unknown column 'pt.category_id' in 'field list'
Error No: 1054
SELECT COUNT(*) AS total FROM cart_category p LEFT JOIN cart_category_description pd ON (p.category_id = pd.category_id) LEFT JOIN cart_category_to_store p2s ON (p.category_id = p2s.category_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2s.store_id = '0' AND (LCASE(pd.name) LIKE '%%') AND p.category_id IN (SELECT pt.category_id FROM cart_product_tag pt WHERE pt.language_id = '1' AND pt.tag LIKE '%978-1-61244-057-6%')