SELECT T1.id, T1.name, T1.detail, T1.group_name, T1.zip, T1.address_2, (CONCAT(coalesce(T1.address_2, ''), coalesce(T1.address_3, ''), coalesce(T1.address_4, ''))) as address, T1.tel, T1.fax, T1.email, T1.hp_url, 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