1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wwwohmib_osc.s.specials_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT rp.products_id, s.specials_id, p.products_id, p.products_price, p.products_image, p.products_quantity, p.products_type, p.products_trans, p.products_model, pd.products_name, s.specials_new_products_price, if (s.status, s.specials_new_products_price, p.products_price) as final_price FROM recommended_prods rp INNER JOIN products p ON (rp.products_id=p.products_id) LEFT JOIN specials s ON (p.products_id=s.products_id), products_description pd WHERE p.products_id=pd.products_id AND p.products_status='1' AND p.products_quantity>0 AND pd.language_id=2 GROUP BY p.products_id

[TEP STOP]