Resource id #3<br/>SELECT (select name from core.page where id = description_page_id)  as page_name, collection.id::integer as collection_id, 
	
	
	
	'<div style="float:left;margin:3px;margin-right:5px;margin-bottom:0px;" title="view collection on map"><a href="../../?' 
	|| (select name from core.page where id = description_page_id)::text 	
	|| '" ><img height="27" border="0" hspace=0 vspace=0 width="27" src="../../image/icons/mouse.png" title="go to description page"></a></div>'
	|| '<h3>' 
	|| (select upper(name) from core.page where id = description_page_id)::text 
	|| '</h3> ' 
	
	|| location_country::text 
	|| ', ' || array_to_string ( 
		ARRAY[location_administration_1::text, location_administration_2::text , location_administration_3::text, location_administration_4::text  ],
		', ' )::text	
	|| '<br/><font color=#99d>' 
	|| btrim( array_to_string ( 
		ARRAY[ 
			''::text, 
			date_collected_text::text,  
			collector_name::text || ' ' || collector_collection_code::text    
		], ', ' )::text ,
	', ' )::text || '</font>'
as collection_title, 
	'../../?' || (select name from core.page where id = description_page_id) as collection_url,

	'../../image/uploaded/' 
	|| BTRIM( 
		split_part( split_part( cd.description_images, 'image/uploaded/' , 2 ) , '"' , 1 )  
	)
	as collection_file_url, 
BTRIM(location_longitude) as longitude, 
BTRIM(location_latitude) as latitude, 
500 as width, 
375 as height, 
date_collected_text as upload_date, 
collector_collection_code as collector_id, 
collector_name, 
'' as collector_url 
FROM collection 
join clade_description cd
	on (collection.ref_key = cd.description_id)
WHERE location_longitude::text != '' AND  location_latitude::text != '' 
 AND lower(clade_subfamily::text) = 'limacelloideae'::text 

ORDER by clade_genus, clade_species, clade_subspecies, clade_variety, clade_form

ERROR:  column "clade_subfamily" does not exist
LINE 44:  AND lower(clade_subfamily::text) = 'limacelloideae'::text 
                    ^