{sql:select * from her_enquiry
 WHERE her_enquiry.rowid = @File number@
}

HENEB: GLAMORGAN-GWENT ARCHAEOLOGY

HISTORIC ENVIRONMENT RECORD

ENQUIRY REPORT - CORE RECORDS

Enquiry reference number: {enq_no}

Prepared by: {wat_staff}, Heneb: Glamorgan-Gwent Archaeology

Produced for: {name}, {organisation}

The following information has been provided under the terms and conditions of access as detailed on the GGAT HER Enquiry and Copyright Declaration forms.  Copyright is reserved on all data supplied by the GGAT HER Charitable Trust. All output resulting from the use of the data must acknowledge the source as follows:-
Derived from information held by the GGAT HER Charitable Trust copyright.

If you wish to use information derived from material held by the GGAT HER Charitable Trust for publication in printed or multimedia form or to compile resources for commercial use (with the exception of grey literature reports), prior permission must be obtained in writing.

Search criteria
 

{criteria}

{subtable:
SELECT her_core.prn,
ifnull(her_core.name,' ') as name,

 her_core.form,

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

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

 ifnull(geo_locations.community,'-')community,

 ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_core_site_type.period,''),', ',ifnull(her_core_site_type.type,''),', RANK: ',ifnull(her_core_site_type.rank,'-')) SEPARATOR '[br]'),'') as t1,

ifnull(GROUP_CONCAT(DISTINCT concat('CONDITION: ',ifnull(her_condition.condition,''),' DESCRIPTION: ',ifnull(her_condition.condesc,'-'),' RELATED EVENT: ' ,ifnull(her_condition.eventprn,'-'),' RECORDED: ',ifnull(her_condition.year,'')) SEPARATOR '[Br]'),'') as c1,

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

 ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(geo_locations.ngr,'-')) SEPARATOR ', '),' ') as ngr,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_source1.srcetype,' '),' ',ifnull(her_source1.author,' '),' ',ifnull(her_source1.year,' '),' ',ifnull(her_source1.title,' '),' ',ifnull(her_source1.refno,' ')) SEPARATOR '[br]' ),'') as bib,

 ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_source3.sources,'')) SEPARATOR '[br]'),' ') as sources,

 ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_xrefs.relationship,'-'),' ',ifnull(her_xrefs.xref_uid,'-')) SEPARATOR ', '),', ') as xref,
 ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_core_event_link.EWATPRN,'')) SEPARATOR ', '),', ') as event,

ifnull(GROUP_CONCAT(DISTINCT ifnull(geo_locations.url,'') SEPARATOR ', '),', ') as url

FROM her_core

JOIN her_enquiry_link_core on her_core.watprn=her_enquiry_link_core.watprn
LEFT JOIN geo_locations on geo_locations.watprn=her_core.watprn
LEFT 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

LEFT JOIN her_core_event_link on her_core_event_link.watprn=her_core.watprn

LEFT JOIN her_source3 on her_source3.watprn=her_core.watprn

LEFT JOIN her_xrefs on her_xrefs.watprn=her_core.watprn

LEFT JOIN her_source1_link on her_source1_link.watprn=her_core.watprn
LEFT JOIN her_source1 on her_source1.rowid=her_source1_link.source_id

WHERE her_enquiry_link_core.fileno=[rowid] 

group by her_core.prn;
title: [b]PRN[/b] , [i],prn,[/i] , [b]NAME[/b] , [i],name,[/i] ,  [b]NGR[/b] , [i],ngr,[/i] , [b]COMMUNITY[/b] , [i],community,[/i],[br], [b]TYPE [/b] , [i],t1,[/i],[br], [b]SUMMARY[/b] ,[i],s1,[/i][br][br], [b]DESCRIPTION[/b] ,[i],d1,[/i][br][br],  [b]CONDITION[/b][br], [i],c1,[/i][br][br], [b]STATUS[/b] ,[i], status1,[/i] [br], [b]CROSS REFERENCES[/b] ,[i], xref,[/i], [i],event,[/i][br][br], [b]SOURCES[/b][br], [i],bib,[/i][br] ,[i],sources,[/i], [b]ARCHWILIO URL [/b][br], url, [br] ,}

AM - {date("m.d.y (H:m)")} - HTML file produced from Heneb HER, Heneb file number {rowid}. 
Heneb: Glamorgan-Gwent Archaeology, SA12 Business Centre, Seaway Parade Industrial Estate, Baglan, Port Talbot, SA12 7BR
tel (01792) 655208 , fax (01792) 474696, email her@ggat.org.uk , website www.ggat.org.uk 

Archaeological data, from the Regional Historic Environment Record, supplied by Heneb: Glamorgan-Gwent Archaeology in partnership with Local Authorities, Cadw and the partners of ENDEX GGAT, 2010.