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 13296, 12
버픽 백과사전
식물 (14,239)
튤립 '아르마' Tulipahybrid 'Arma'
튤립 '아티스트' Tulipahybrid 'Artist'
튤립 '아틸라' Tulipahybrid 'Attila'
튤립 '아비뇽' Tulipahybrid 'Avignon'
튤립 '발라드 드림' Tulipahybrid 'Ballade Dream'
튤립 '발레리나' Tulipahybrid 'Ballerina'
튤립 '반자 루카' Tulipahybrid 'Banja Luka'
튤립 '바르셀로나' Tulipahybrid 'Barcelona'
튤립 '바스토뉴' Tulipahybrid 'Bastogne'
튤립 '뷰티 오브 아펠도른' Tulipahybrid 'Beauty of Apeldoorn'