/* Get coordinates of sites with charred plant remains, in phases A1-G2 */

SELECT     site.id as 'siteID',site.eastings,site.northings
FROM       sample
INNER JOIN plantRecord       ON plantRecord.sampleID            = sample.id
INNER JOIN plantPreservation ON plantRecord.plantPreservationID = plantPreservation.id
INNER JOIN `context`         ON sample.contextID                = `context`.id
INNER JOIN sitePhase         ON `context`.sitePhaseID             = sitePhase.id
INNER JOIN site              ON `context`.siteID                  = site.id
WHERE      sample.id              > 0
AND        plantPreservation.`name` = 'charred'
AND        sitePhase.fsPhaseSpan  NOT IN ('A0','H')
GROUP BY   site.id;