SELECT T1.id, T1.name, T1.detail, T1.group_name, T1.hp_code, (SELECT CONCAT ('/', file_path, '/', file_name) FROM producer_images WHERE image_type = 1 AND producer_id = T1.id ORDER BY id DESC LIMIT 1) AS image FROM producers T1 WHERE T1.id = AND T1.sanpin_flg = 1 AND T1.active = 1