/* Count samples in which charred plant remains occur, in phases A1-G2 */

SELECT     COUNT(DISTINCT sample.id) AS 'sample count'
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');