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

GWYNEDD ARCHAEOLOGICAL TRUST

HISTORIC ENVIRONMENT RECORD

ENQUIRY REPORT - EVENT RECORDS

Enquiry reference number: {enq_no}

Prepared by: {wat_staff}, Gwynedd Archaeological Trust

Produced for: {name}, {organisation}

The following information has been provided under the terms and conditions of access as detailed on the GAT HER Enquiry and Conditions of Access form and/or the GAT HER data licence agreement produced for this enquiry.

Copyright is reserved on all data supplied by the GAT HER. All output resulting from the use of the data must acknowledge the source as follows: Derived from information held by the GAT HER Copyright.

If you wish to use information derived from material held by the GAT HER 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_event.prn,
ifnull(her_event.name,' ') as name,
her_event.eyear,
her_event.event_type,
ifnull(her_event.rep_desc,'None') as repno,
ifnull(her_event.eventbyo,'-') as evo,
ifnull(her_event.eventbyp,'-') as evp,
ifnull(her_event.summary,'-') as s1,
ifnull(her_event.desc_1,'-') as d1,
ifnull(geo_locations.ngr,'-')ngr,
ifnull(geo_locations.community,'-')community,
ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_xrefs.xref_uid,'-')) SEPARATOR ', '),', ') as xref,
ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_core_event_link.watprn,'')) SEPARATOR ', '),' ') as core,
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
FROM her_event
JOIN her_enquiry_link_event on her_event.watprn=her_enquiry_link_event.watprn
LEFT JOIN geo_locations on geo_locations.watprn=her_event.watprn
LEFT JOIN her_core_event_link on her_core_event_link.ewatprn=her_event.watprn
LEFT JOIN her_xrefs on her_xrefs.watprn=her_event.watprn
LEFT JOIN her_source1_link on her_source1_link.watprn=her_event.watprn
LEFT JOIN her_source1 on her_source1.rowid=her_source1_link.source_id
WHERE her_enquiry_link_event.fileno=[rowid]
group by her_event.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],event_type,[/i], [b]YEAR[/b] , [i],eyear,[/i] ,[b]ORGANISATION[/b] , [i],evo,[/i] ,[b]PERSON[/b] , [i],evp,[/i] ,[br],[b]SUMMARY[/b] ,[i],s1,[/i][br][br],[b]DESCRIPTION[/b] ,[i],d1,[/i][br][br],[/i][br],[b]CROSS REFERENCES[/b], [i],xref,[/i], [i],core,[/i][br][br], [b]SOURCES[/b][br],[i],bib,[/i] [br] ,[b]REPORT[/b] , [i],repno,[/i],}

Key to Abbreviations and Terms
GAT: Gwynedd Archaeological Trust; HER: Historic Environment Record; PRN : Primary Reference Number, each site and event is given a unique PRN; NAME: The name of the event; NGR: Ordnance Survey National Grid Reference; COMMUNITY: The community council in which the event took place; TYPE: Describes the event type e.g. EXCAVATION; YEAR: The year in which the event took place; ORGANISATION: The name of the organisation who carried out the event; PERSON: The name of the individual/s who carried out the event; SUMMARY: A short, unreferenced summary of the event written by HER staff; DESCRIPTION: Detailed description of the event; CROSS REFERENCES: Any core and/or event PRNs relating to the event; SOURCES: The bibliographic references relating to the event; REPORT: The reference number of the unpublished report relating to the event (not all event types will produce reports).

AM - {date("m.d.y (H:m)")} - HTML file produced from GAT HER, GAT file number {rowid}.
Gwynedd Archaeological Trust, Craig Beuno, Ffordd Garth, Bangor LL57 2RT.
tel (01248) 352535, fax (01248) 370925, email her@heneb.co.uk, website www.heneb.co.uk
Archaeological data, from the Gwynedd Historic Environment Record, supplied by Gwynedd Archaeological Trust in partnership with Local Authorities, Cadw and the partners of the HEDS group Wales, GAT, 2016.