{sql:select * from her_woodland
JOIN her_project on her_project.rowid=her_woodland.fileno
WHERE her_project.rowid = @File Number@
}

GAZETTEER OF SITES
MARION PAGE - HISTORIC ENVIRONMENT RECORD MANAGER


Changes in the condition of a monument, or in the interpretation of it's function (site type) are recorded through the use of multiple 'child' records in the database tables. Each entry will appear in the gazetteer, with multiple entries separated by a forward slash
e.g. 'CONDITION - Good / Near Intact'

{subtable:
SELECT her_core.prn,

ifnull(her_core.name,' ') as name,

ifnull(her_core.summary,' ') as s1,

ifnull(her_core.desc_1,' ') as d1,

ngr,

community,

unitary,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_core_site_type.type,' ')) SEPARATOR ', '),' ') as t1,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_condition.condition,' ')) SEPARATOR '/ '),' ') as c1,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_condition.evidence,' ')) SEPARATOR '/ '),' ') as e1,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_condition.condesc,'None recorded ')) SEPARATOR '/ '),' ') as cd1,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_status.status,'None recorded '),' ',ifnull(her_status.reference,' '),' ',ifnull(her_status.grade,' ')) SEPARATOR ', '),' ') as status1

FROM her_woodland
JOIN her_project_link on her_project_link.fileno=her_woodland.fileno
JOIN her_core on her_core.watprn=her_project_link.watprn
JOIN geo_locations on geo_locations.watprn=her_core.watprn
JOIN her_core_site_type on her_core_site_type.watprn=her_core.watprn

LEFT JOIN her_condition on her_condition.watprn=her_core.watprn
LEFT JOIN her_status on her_status.watprn=her_core.watprn

WHERE her_project_link.fileno=[rowid] and isnull(her_core.flag)

group by her_core.prn;
title:[b]PRN -[/b] ,prn,  [b]NAME -[/b] , name,  [b]TYPE -[/b] ,t1, [br][br][b]CONDITION -[/b] ,c1,   [br][br][b]EVIDENCE[/b] ,e1,  [br][br][b]STATUS -[/b] ,status1, [br][br][b]NGR -[/b] ,ngr, [b]COMMUNITY -[/b] ,community, [br][br][b]COUNTY -[/b] , unitary, [br][br][b]SITE DESCRIPTION[/b][br],s1 , [br][br],d1 ,[br][br] }