SELECT `l`.*, GROUP_CONCAT(ft.type_name ORDER BY ft.type_name SEPARATOR ', ') as type_name
FROM `skcwihblr_locations` `l`
LEFT JOIN `skcwihblr_food_types` `ft` ON `FIND_IN_SET`(ft.id, l.veg_type) AND `ft`.`status` = 1
WHERE `l`.`location_status` = 1
AND `l`.`is_restaurant` = 1
GROUP BY `l`.`location_id`
ORDER BY `l`.`location_id` DESC