버픽 백과사전

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 13308, 12 버픽 백과사전

식물 (14,239)

튤립 '벨 뒤 몽드'

튤립 '벨 뒤 몽드'
Tulipa hybrid 'Belle du Monde'

튤립 '빅 치프'

튤립 '빅 치프'
Tulipa hybrid 'Big Chief'

튤립 '빅 스마일'

튤립 '빅 스마일'
Tulipa hybrid 'Big Smile'

튤립 '블랙 히어로'

튤립 '블랙 히어로'
Tulipa hybrid 'Black Hero'

튤립 '블루 뷰티'

튤립 '블루 뷰티'
Tulipa hybrid 'Blue Beauty'

튤립 '블루 다이아몬드'

튤립 '블루 다이아몬드'
Tulipa hybrid 'Blue Diamond'

튤립 '블루 헤론'

튤립 '블루 헤론'
Tulipa hybrid 'Blue Heron'

튤립 '블루 패롯'

튤립 '블루 패롯'
Tulipa hybrid 'Blue Parrot'

튤립 '블루 리본'

튤립 '블루 리본'
Tulipa hybrid 'Blue Ribbon'

튤립 '블루 스펙타클'

튤립 '블루 스펙타클'
Tulipa hybrid 'Blue Spectacle'

튤립 '블러싱 뷰티'

튤립 '블러싱 뷰티'
Tulipa hybrid 'Blushing Beauty'

튤립 '블러싱 레이디'

튤립 '블러싱 레이디'
Tulipa hybrid 'Blushing Lady'