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#')
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#)