Error: Unknown column 'p2c.category_id' in 'where clause'
Error No: 1054
SELECT vdc.name AS vdc_name, pd.name, pd.description, p2s.price AS price, p2s.quantity AS quantity, p2s.minimum AS minimum, p.product_id,p.best_seller,p.is_promise, p.is_handpicked, p.is_new_and_popular, p.new_arrival,p.readytoship,p.time_to_ship, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM product p INNER JOIN product_description pd ON (p.product_id = pd.product_id) INNER JOIN product_to_store_alter p2s ON (p.product_id = p2s.product_id) INNER JOIN product_variation pvc ON (p.product_id = pvc.product_id) INNER JOIN variation vc ON (vc.variation_id = pvc.variation_id) INNER JOIN variation_description vdc ON (vc.variation_id = vdc.variation_id) WHERE p.status = '1' AND p2s.store_id = '0' AND p2s.quantity > '0' AND p2s.active = '1' AND vc.variation_group_id = '18' AND p2c.category_id = '124' GROUP BY p.product_id ORDER BY p.viewed DESC LIMIT 0,40