Fisher and Paykel

1052 - Column 'products_model' in field list is ambiguous

select p.products_id,products_name,products_quantity,products_model,products_image,products_price,products_price1,products_price2,products_price3,products_price4,products_price5,products_price6,products_price7,products_price8,products_price1_qty,products_price2_qty,products_price3_qty,products_price4_qty,products_price5_qty,products_price6_qty,products_price7_qty,products_price8_qty,products_qty_blocks,products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from `osc_products` `p` INNER JOIN `osc_products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 1 LEFT OUTER JOIN `osc_specials` `s` on `p`.`products_id` = `s`.`products_id` WHERE `p`.`products_status` = 1 AND `p`.`manufacturers_id` = 12 order by p.sort_order, pd.products_name ASC

[TEP STOP]