#Intro1#
A Biological Collection Access Service for Europe

#Intro1#

SELECT body.body_id, body.body_type_fk, bodytype.body_type, bodyname.bodyname, address.town, isocountry.iso_country_id, isocountry.full_country_name FROM address, isocountry, bodytype, body, bodyname WHERE address_id = address_fk AND iso_country_fk = iso_country_id AND body_type_fk = body_type_id AND bodyname.body_fk = body.body_id AND address.town is not null AND address.iso_country_fk is not null AND body.body_type_fk > 0 AND isocountry.iso_country_id > 0 AND body.body_type_fk > 0 AND isocountry.iso_country_id = '#Country#' AND body.body_type_fk > 0 AND body.freetext_search ILIKE '%#Freetext#%' AND body.body_type_fk > 0 AND isocountry.iso_country_id = '#Country#' AND body.freetext_search ILIKE '%#Freetext#%' ORDER BY isocountry.full_country_name, address.town, bodyname.bodyname ORDER BY address.town, isocountry.full_country_name, bodyname.bodyname insert into webspy (web_spy_id, country, town, free_text, ip_address) Values ((select max(web_spy_id)+1 from webspy), #country#, '#city#', '#form.freetext#', '#CLIENT_ADDRESS#')

Sorry, no hits. #freetext#

Name Type Town Country
#bodyname# #body_type# #town# #full_country_name#

New Query...

This simple interface searches the indexed collection metadata database CORM, which caches the entire collection data published by more than 30 BioCASE National Nodes.

SELECT DISTINCT isocountry.full_country_name, isocountry.iso_country_id FROM address, body, isocountry WHERE address.address_id = body.address_fk AND address.iso_country_fk = isocountry.iso_country_id AND body.body_type_fk > 0 ORDER BY isocountry.full_country_name;
Country

HI !

Free text
 
SELECT DISTINCT isocountry.full_country_name, isocountry.iso_country_id FROM address, body, isocountry WHERE address.address_id = body.address_fk AND address.iso_country_fk = isocountry.iso_country_id AND body.body_type_fk > 0 ORDER BY isocountry.full_country_name;
Country
Free text
 
SELECT COUNT(body_id) AS Num FROM body WHERE body_type_fk = 1; SELECT COUNT(body_id) AS Num FROM body WHERE body_type_fk = 2; SELECT COUNT(body_id) AS Num FROM body WHERE body_type_fk = 3;
Total records available: networks (#GetRecordNumberNet.Num#), organisations (#GetRecordNumberOrg.Num#), collections (#GetRecordNumberCol.Num#)