버픽 백과사전

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

식물 (14,239)

튤립 '마리에트'

튤립 '마리에트'
Tulipa hybrid 'Mariette'

튤립 '마릴린'

튤립 '마릴린'
Tulipa hybrid 'Marilyn'

튤립 '마리트'

튤립 '마리트'
Tulipa hybrid 'Marit'

튤립 '모린'

튤립 '모린'
Tulipa hybrid 'Maureen'

튤립 '메이타임'

튤립 '메이타임'
Tulipa hybrid 'Maytime'

튤립 '멜로즈'

튤립 '멜로즈'
Tulipa hybrid 'Melrose'

튤립 '멘톤'

튤립 '멘톤'
Tulipa hybrid 'Menton'

튤립 '메를로'

튤립 '메를로'
Tulipa hybrid 'Merlot'

튤립 '미란다'

튤립 '미란다'
Tulipa hybrid 'Miranda'

튤립 '미스트리스'

튤립 '미스트리스'
Tulipa hybrid 'Mistress'

튤립 '모나리자'

튤립 '모나리자'
Tulipa hybrid 'Mona Lisa'

튤립 '몬디얼'

튤립 '몬디얼'
Tulipa hybrid 'Mondial'