Species pages for the European Aroids.

This can be achieved using :

select DescriptionBase.titleCache, IF(count(DescriptionElementBase_LanguageString.DescriptionElementBase_id) > 0,'yes','no') as hasContent from DescriptionBase join DescriptionElementBase as distribution on (DescriptionBase.id = distribution.inDescription_id and distribution.DTYPE = 'Distribution') left join DescriptionElementBase as text on (DescriptionBase.id = text.inDescription_id and text.DTYPE = 'TextData') left join DescriptionElementBase_LanguageString on (text.id = DescriptionElementBase_LanguageString.DescriptionElementBase_id) where distribution.area_id in (select country.id from DefinedTermBase as country join DefinedTermBase as region on (country.partof_id = region.id) join DefinedTermBase as continent on (region.partof_id = continent.id) where continent.id = 1304)  group by DescriptionBase.titleCache order by DescriptionBase.titleCache;