Executed Query -> select sp.*,sh.shopurl,sh.shopname,sh.items,
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: 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"