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

{subtable:
SELECT her_core.prn as id,

ggat_projects.value as value, ggat_projects.rarity as rarity, ggat_projects.group_association as g_ass, ggat_projects.group_association as h_ass,ggat_projects.effect as effect, ggat_projects.confidence as con,
ifnull(her_core.name,' ') as name,

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

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

  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(ifnull(her_condition.condition,''),' Year: ',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

FROM her_core

JOIN her_project_link on her_core.watprn=her_project_link.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 ggat_projects on ggat_projects.watprn=her_core.watprn

WHERE her_project_link.fileno=[rowid] 

group by her_core.prn;
title: [b]ID[/b] , [i],id,[/i] ,                                                           [b]Name[/b] , [i],name,[/i] , ,[br][br], [b]Type [/b] , [i],t1,[/i],                         [b]NGR[/b] , [i],ngr,[/i],[br][br], [b]Description[/b] ,[i][p align = 'justify'],d1,[/p][/i][br][br], [b]Condition[/b] , [i],c1,[/i][br][br], [b]Status[/b] ,[i], status1,[/i] [br][br], [b]Rarity[/b] ,[i],rarity,[/i] ,                          [b]Group Association[/b] ,[i],g_ass,[/i],                    [b]Historical Association[/b] ,[i],h_ass,[/i][br][br], [b]Confidence[/b] ,[i],con,[/i] ,                     [b]Value[/b] ,[i],value,[/i],                                           [b]Effect[/b] ,[i],effect,[/i]}