SELECT disease_pest_id, first_name_kr, middle_name_kr, first_name_en, middle_name_en, photo_id FROM disease_pest LEFT JOIN (select content_id, MIN(photo_id) photo_id from photo where photo_type='DNP_DT' AND is_deleted=0 group by content_id) photo ON disease_pest_id=content_id WHERE disease_pest.is_deleted=0 AND is_public=1 AND disease_pest_type='DISEASE' ORDER BY first_name_en, middle_name_en LIMIT 108, 12
버픽 백과사전
