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

CLWYD-POWYS ARCHAEOLOGICAL TRUST

HISTORIC ENVIRONMENT RECORD

ENQUIRY REPORT - CORE 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 from 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_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,'-'),' Date of entry:
',ifnull(her_condition.compiledon,'')) 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 ifnull(geo_locations.ngr,'-')SEPARATOR ', '),' ') as ngr,
ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_source1.author,' '),' ',ifnull(her_source1.year,' '),' ',ifnull(her_source1.title,' '),' ',ifnull(her_source1.refno,' '),' ',ifnull(her_source1.journal,' '),' ',ifnull(her_source1.volume,' '),' ',ifnull(her_source1.sertitle,' '),' ',ifnull(her_source1.serno,' ')) SEPARATOR '[br]' ),'') as bib,
ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_artefact.quantity,' '),' ',ifnull(her_artefact.fmaterial,' '),' ',ifnull(her_artefact.ftype,' '),' ',ifnull(her_artefact.ftypematq,' '),' ',ifnull(her_artefact.fnotes,' '),' ',ifnull(her_artefact.flocation,' ')) SEPARATOR '[br]'),' ') as artefacts,
ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_c14.labnumber,' '),' ',ifnull(her_c14.material,' '),' ',ifnull(her_c14.date,' '),' ',ifnull(her_c14.datequal,' '),' ',ifnull(her_c14.devqual,' '),' ',ifnull(her_c14.deviation,' '),' ',ifnull(her_c14.comment,' ')) SEPARATOR '[br]'),' ') as c14,
ifnull(GROUP_CONCAT(DISTINCT ifnull(her_photo_link.photonum,'-') SEPARATOR ', '),', ') as photo,
ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_xrefs.relationship,'-'),' ',ifnull(her_xrefs.xref_uid,'-')) SEPARATOR ', '),', ') as xref,
ifnull(GROUP_CONCAT(DISTINCT 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_xrefs on her_xrefs.watprn=her_core.watprn

LEFT JOIN her_artefact on her_artefact.watprn=her_core.watprn

LEFT JOIN her_c14 on her_c14.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

LEFT JOIN her_photo_link on her_photo_link.watprn=her_core.watprn

WHERE her_enquiry_link_core.fileno=[rowid]

group by her_core_site_type.period, her_core_site_type.type,her_core.name limit 10000;
title: [b]PRN[/b] ,  prn ,  [b]NAME[/b] ,  name,   [br][br],  [b]NGR[/b] ,  ngr,  [b]COMMUNITY[/b] ,  community,  [br][br], [b]TYPE [/b] ,   t1,  ,[br][br], [b]SUMMARY[/b]  ,  s1,  [br][br], [b]DESCRIPTION[/b] ,  d1, [br][br], [b]CONDITION[/b] , c1, [br][br], [b]STATUS[/b] , status1, [br][br], [b]CROSS REFERENCES[/b] , xref, event, [br][br], [b]SOURCES[/b][br], bib, [br][br]  [b]ARTEFACTS [/b][br], artefacts, [br] [br],  [b]C14 DATES[/b][br], c14, [br][br] , [b]PHOTOS[/b][br], photo, [br][br] , [b]ARCHWILIO URL [/b][br], url, [br] ,  }

{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

Please note that the sites listed above are only the sites of which we are aware at the current time and there may be others that have yet to be discovered.

While the Regional Historic Environment Record contains information on all of the following, we do not hold the definitive data for Listed Buildings, Scheduled Ancient Monuments, Registered Parks and Gardens or Registered Historic Landscapes, and it is recommended that you contact Cadw to ensure you have the most up to date data for these monuments - particularly if you require digital polygons showing the full extents of Registered or Scheduled areas. Similarly, there may also be additional sites in the area in the National Monuments Record of Wales, held by the Royal Commission on the Ancient and Historical Monuments of Wales, and again you are advised to contact them directly to obtain such information.

If your enquiry relates to a commercial development, and if you haven't already done so, please contact Mr Mark Walters (markwalters@cpat.org.uk), the Development Control Archaeologist for Clwyd and Powys who will provide further advice regarding best practice in mitigating against damage to any archaeological or historical remains which might exist within the area of the proposed works.

Enquirers are required to provide a copy (paper or digital) of any document or published report that makes use of information obtained from the HER for incorporation into the record.

Enquirers are required to include the following acknowledgement in any document or published report that makes use of information obtained from the HER: - Information obtained from the Regional Historic Environment Record curated by the Clwyd-Powys Archaeological Trust and the HER Enquiry Number.