Home › Abi

Unknown column 'p.manufacturer_id' in 'on clause'
SELECT p.product_id,MIN( IF(s.sale='Y', s.sale_price_calculated, s.price_calculated )) as min_sort_price,MAX( IF(s.sale='Y', s.sale_price_calculated, s.price_calculated )) as max_sort_price,p.title as sort_title FROM products p, products_to_categories, categories LEFT JOIN manufacturers m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN products s ON (p.product_id = s.parent_product_id) LEFT JOIN product_to_attributes pta ON (s.product_id = pta.product_id) WHERE p.product_id = products_to_categories.product_id AND products_to_categories.category_id = categories.category_id AND p.parent_product_id = 0 AND p.deleted = 'N' AND p.active = 'Y' AND s.deleted = 'N' AND s.active = 'Y' AND categories.active = 'Y' AND categories.deleted = 'N' AND (s.price > 0 || p.price > 0) AND (s.stock > 0 OR s.stock = -1) AND p.manufacturer_id = 3 GROUP BY p.product_id ORDER BY sort_title ASC, min_sort_price ASC,max_sort_price ASC