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

CLWYD-POWYS ARCHAEOLOGICAL TRUST

HISTORIC ENVIRONMENT RECORD

ENQUIRY REPORT - EVENT RECORDS

Enquiry reference number: {enq_no}

Prepared by: {wat_staff}, Clwyd-Powys Archaeological Trust

Produced for: {name}, {organisation}

The following information has been provided under the terms and conditions of access as detailed on the CPAT HER Enquiry form and in the Welsh Archaeological Trusts Access and Charging Policy.  Copyright is reserved on all data supplied by the CPAT HER. All output resulting from the use of the data must acknowledge the source as follows:- Copyright CPAT HER partnership, 2020 (and in part Crown, 2020).

If you wish to use information derived from material held by the CPAT HER for publication in printed or multimedia form or to compile resources for commercial use, 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.eventbyo,'-') as evo,
ifnull(her_event.eventbyp,'-') as evp,
 ifnull(her_event.summary,'-') as s1,

ifnull(her_event.desc_1,'-') as d1,
ifnull(her_event.comments,'None') as com1,
ngr,

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

 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,

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

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

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_artefact on her_artefact.watprn=her_event.watprn

LEFT JOIN her_source3 on her_source3.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 ceil(her_event.prn);
title:   [b]PRN[/b] ,  prn, [b]NAME[/b] ,  name ,[br][br],
   [b]NGR[/b] ,  ngr, [b]COMMUNITY[/b] ,  community ,[br][br],

   [b]TYPE[/b] , event_type, [b]YEAR[/b] , eyear ,[br][br]  

   [b]ORGANISATION person[/b] , evo, [b]  [/b] , evp, [br][br],

   [b]SUMMARY[/b] , s1,[br][br],

   [b]DESCRIPTION[/b] ,  d1, [br][br],

   [b]COMMENTS[/b]  , com1, [br][br],

   [b]CROSS REFERENCES[/b] ,core, [br][br],

   [b]SOURCES[/b][br], bib, [br] , sources [br][br],

   [b]ARCHWILIO URL  [/b][br], url, [br] , }

AM - {date("m.d.y (H:m)")} - HTML file produced from CPAT HER, CPAT file number {rowid}. 
Clwyd-Powys Archaeological Trust, The Offices, Coed y Dinas, Welshpool, SY21 8RP. 
tel (01938) 553670, fax (01938) 552179, email her@cpat.org.uk, website www.cpat.org.uk

Archaeological data, from the Regional Historic Environment Record, supplied by The Clwyd-Powys Archaeological Trust in partnership with Local Authorities, Cadw and the partners of ENDEX CPAT, 2020.