[mysql]
not = not        
and = and
or = or
isnull = is null
isnotnull = is not null
equals = =
notequals = <>
like = LIKE
lessthan = <
lessthanorequals = <=
greaterthan = >
greaterthanorequals = >=
in = IN

[escape]    
'= '
* = %


[select]
country= SELECT DISTINCT isocountry.full_country_name,count(body_id) as total
town= SELECT DISTINCT town, count(body_id) as total
metadata= SELECT DISTINCT body_type_fk, body_type ,count(body_id) as total
region= SELECT DISTINCT region, count(body_id) as total
bodyIDs=SELECT DISTINCT body_id
people= SELECT DISTINCT family_name
peopleRole=SELECT DISTINCT person_role,count(person_fk)
peopleCountry=SELECT DISTINCT isocountry.full_country_name,count(body_id)
peopleMetadata=SELECT DISTINCT body_type_fk, body_type ,count(body_id) as total
network=SELECT DISTINCT body.body_id,bodyname.bodyname 
institution=SELECT DISTINCT body.body_id,bodyname.bodyname
collection=SELECT DISTINCT body.body_id,bodyname.bodyname
institutionCategory=SELECT DISTINCT schema_term,count(body_id)
collectionCategory=SELECT DISTINCT schema_term,count(body_id)
objectCategory=SELECT DISTINCT schema_term,count(body_id)


[from]
country= address
metadata= body
town= address
region= address
bodyIDs=body
people=person
peopleRole=personrole
peopleCountry=personinbody
peopleMetadata=body
network=body
collection=body
institution=body
institutionCategory=body
collectionCategory=body
objectCategory=body

[join]
metadata= JOIN bodytype ON body_type_id=body_type_fk 
country=JOIN body ON  address.address_id = body.address_fk JOIN isocountry ON address.iso_country_fk = isocountry.iso_country_id
town=JOIN body ON  address.address_id = body.address_fk JOIN isocountry ON address.iso_country_fk = isocountry.iso_country_id
region=JOIN body ON  address.address_id = body.address_fk JOIN isocountry ON address.iso_country_fk = isocountry.iso_country_id
address=JOIN address ON  address.address_id = body.address_fk JOIN isocountry ON address.iso_country_fk = isocountry.iso_country_id
bodyIDs= JOIN bodytype ON body_type_id=body_type_fk
people=""
peopleRole=JOIN personinbody ON  person_role_id = person_role_fk
peopleCountry=JOIN body ON  body_fk=body_id JOIN address ON  address.address_id = body.address_fk JOIN isocountry ON address.iso_country_fk = isocountry.iso_country_id
peopleMetadata=JOIN bodytype ON body_type_id=body_type_fk JOIN personinbody ON body_fk=body_id
network=JOIN bodytype ON body_type_id=body_type_fk JOIN bodyname ON bodyname.body_fk = body.body_id
collection=JOIN bodytype ON body_type_id=body_type_fk JOIN bodyname ON bodyname.body_fk = body.body_id
institution=JOIN bodytype ON body_type_id=body_type_fk JOIN bodyname ON bodyname.body_fk = body.body_id
institutionCategory=JOIN bodykeyword ON body_id=bodykeyword.body_fk JOIN keyword ON keyword_fk=keyword_id
collectionCategory=JOIN bodykeyword ON body_id=bodykeyword.body_fk JOIN keyword ON keyword_fk=keyword_id 
objectCategory=JOIN bodykeyword ON body_id=bodykeyword.body_fk JOIN keyword ON keyword_fk=keyword_id

personInBody=JOIN personinbody ON person_fk = person_id
personRole= JOIN personrole ON person_role_fk=person_role_id 
body=JOIN body ON body_fk=body_id
bodyType=JOIN bodytype ON body_type_fk = body_type_id
address=JOIN address ON body.address_fk=address_id
address_country=JOIN address ON body.address_fk=address_id JOIN isocountry ON iso_country_fk=iso_country_id 
isoCountry=JOIN isocountry ON iso_country_fk=iso_country_id
person=JOIN person ON person_fk = person_id
personInBody_body=JOIN personinbody ON body_fk=body_id JOIN person ON person_fk = person_id
bodyKeyword=JOIN bodykeyword ON body_id=bodykeyword.body_fk JOIN keyword ON keyword_fk=keyword_id
bodyName=JOIN bodyname ON bodyname.body_fk=body_id


[where]
country= isocountry.full_country_name
metadata=body_type_id
town=town
region=region
people=family_name
peopleRole=person_role
peopleCountry=isocountry.full_country_name
peopleABC=(substr(family_name,1,1) between '%s' and '%s')
isnetwork=body_type_fk =1
iscollection=body_type_fk =3
isinstitution=body_type_fk =2
network=body_id
collection=body_id
institution=body_id
collectionABC=(substr(bodyname,1,1) between '%s' and '%s')
institutionABC=(substr(bodyname,1,1) between '%s' and '%s')
institutionCategory=schema_term
isCollectionCategory=keyword_type_fk = 1 
collectionCategory=schema_term
isObjectCategory=keyword_type_fk = 2
isCategory=keyword_type_fk IN (1,2)
objectCategory= schema_term


[groupBy]
country=GROUP BY isocountry.full_country_name
town=GROUP BY town
region=GROUP BY region
metadata=GROUP BY body_type_fk, body_type
bodyIDs=
people=
peopleRole=GROUP BY person_role
peopleCountry=GROUP BY isocountry.full_country_name
peopleMetadata=GROUP BY body_type_fk, body_type 
network=
collection=
institution=
institutionCategory=GROUP BY schema_term
collectionCategory=GROUP BY schema_term
objectCategory=GROUP BY schema_term