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

GGAT Project Gazeteer Event {title}

{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.desc_1,'-') as d1,
ngr,

 ifnull(GROUP_CONCAT(DISTINCT concat('TYPE: ',ifnull(her_artefact.ftype,'None recorded'),' MATERIAL: ',ifnull(her_artefact.fmaterial,'-'),' PERIOD: ',ifnull(her_artefact.period1,'-'),' DESCRIPTION: ',ifnull(her_artefact.fnotes,'-')) SEPARATOR '[br]'),' ') as art,
 ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_xrefs.xref_uid,'-')) SEPARATOR ', '),', ') as xref

FROM her_event
JOIN her_project_link on her_event.watprn=her_project_link.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_project_link.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] ,  [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] [br],[b]DESCRIPTION[/b] ,[i],d1,[/i][br][br],[b]ARTEFACTS[/b][br],[i],art,[/i][br][br],[b]CROSS REFERENCES[/b], [i],xref,[/i] }