SELECT `i`.`id`, `i`.`taxonomy_id`, `i`.`code`, `il`.`name`, `il`.`summary`, GROUP_CONCAT(`ic`.`category_id`) AS `category_id`, `ii`.`image_url` FROM `items` AS `i` INNER JOIN `item_lang` AS `il` ON `i`.`id`=`il`.`item_id` INNER JOIN `item_category` AS `ic` ON `i`.`id`=`ic`.`item_id` LEFT JOIN `item_images` AS `ii` ON `ii`.`item_id`=`i`.`id` WHERE (`lang`='vi') AND (deleted=0 AND display>0) AND (item_type IN (1,3)) AND (ic.category_id IN(23)) GROUP BY i.id LIMIT 9