Executed Query -> select sp.*,sh.shopurl,sh.shopname,sh.items, sh.followers,sh.logo,shd.newfee from shops_products sp inner join shops sh on sh.shopid=sp.shopid left outer join shops_discounts shd on shd.pinid=sp.pinid and shd.date_to > now() where sp.status=1 and parentid=0 and sp.featured =1 group by sp.pinid order by sp.pinid desc limit 30
ERROR:"SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #28 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fpadmin_mainsite.shd.newfee' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: 311"