SELECT plant_id, first_name_kr, middle_name_kr, first_name_en, middle_name_en, last_name_kr, last_name_en, is_brand, photo_id, scientific_name, kpni FROM plant LEFT JOIN (select content_id, MIN(photo_id) photo_id from photo where photo_type='PLANT_DT' AND is_deleted=0 group by content_id) photo ON plant_id=content_id WHERE plant.is_deleted=0 AND is_public=1 ORDER BY first_name_en, middle_name_en, last_name_en LIMIT 13440, 12
버픽 백과사전
식물 (14,239)
튤립 '패롯 킹' Tulipahybrid 'Parrot King'
튤립 '패셔널' Tulipahybrid 'Passionale'
튤립 '피치 블로썸' Tulipahybrid 'Peach Blossom'
튤립 '핑크 다이아몬드' Tulipahybrid 'Pink Diamond'
튤립 '핑크 임프레션' Tulipahybrid 'Pink Impression'
튤립 '피노키오' Tulipahybrid 'Pinocchio'
튤립 '프리티 우먼' Tulipahybrid 'Pretty Woman'
튤립 '프린세스 아이린' Tulipahybrid 'Princess Irene'
튤립 '프린스 윌리엄 알렉산더' Tulipahybrid 'Prins Willem Alexander'