/* Count sites at which quantified charred plant remains occur, in phases A1-G2 */

SELECT     COUNT(DISTINCT tempSample.siteID) AS 'site count'
FROM       tempRecord
INNER JOIN tempSample        ON tempRecord.sampleID  = tempSample.sampleID
WHERE      tempSample.totalStandardQuantity > 0
AND        tempRecord.preservation = 'charred'
AND        tempSample.fsPhaseSpan NOT IN ('A0','H');