Executed Query -> select ad.id,ad.catid,ad.subcatid,ad.title,ad.description,ad.adprice,ad.price_per_type,adimg.imagename, ad.enlargeimg,ad.boldtitle,ad.keywords,toa.value as ad_type_const,toa.type as ad_type from tbl_ads as ad right join tbl_ads_images as adimg on ad.id = adimg.adsid left join tbl_typeof_ad as toa on ad.ad_type_id = toa.id where 0=0 and ad.status='a' and ad.markasfeaturedad = 'y' and ad.ad_status = 'a' and ad.ad_availability = 'a' and ad.status_by_user = 'a' group by adimg.adsid order by ad.id desc limit 0,8
ERROR:"SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'campusad_DB.adimg.imageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: 308"