1055 - Expression #18 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'kanhadb.c.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select p.*,c.title as cat_title,GROUP_CONCAT(pi.id) as img_id,pi.is_main ,(select type from region where p.Region = region.id) as regiontype, (select regionname from region where p.Region = region.id) as regionname from package as p join package_image as pi on p.id = pi.package_id join package_cat as pc on p.id = pc.package_id join category as c on pc.cat_id = c.id where p.id='8' group by pi.package_id
