Expression #41 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'craft13_CHDB.yp_product_history.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by : select * from yp_product inner join yp_product_history on yp_product.product_id = yp_product_history.product_id where yp_product_history.user_ip ='34.236.216.93' and yp_product.product_status='Active' and yp_product.product_id !='1196' group by yp_product_history.product_id order by user_date desc limit 0,8