SELECT site.SiteID,
       site.notes,
       site.place,
       site.parish,
       site.county,
       site.grid,
       easting(site.grid) AS easting,
       northing(site.grid) AS northing,
       a.SNumberofObjects AS Cores,
       b.SNumberofObjects AS Scrapers,
       c.SNumberofObjects AS Adzes,
       d.SNumberofObjects AS Picks,
       e.SNumberofObjects AS PMH,
       f.SNumberofObjects AS AdzeSF,
       g.SNumberofObjects AS Blades,
       h.SNumberofObjects AS Gravers,
       i.SNumberofObjects AS Others,
       j.SNumberofObjects AS Microburins,
       k.SNumberofObjects AS Microliths,
       l.SNumberofObjects AS Bone,
       m.SNumberOfObjects AS Wood,
       n.SNumberOfObjects AS Antler
  INTO WymerGIS
FROM
(
(
(
(
(
(
(
(
(
(
(
(
(
site

LEFT JOIN [SELECT core.SiteID, SUM(core.NumberOfObjects) as SNumberOfObjects
FROM object AS   core
WHERE   core.ObjectType LIKE 'Core*' AND isNumeric(core.NumberOfObjects)
GROUP BY core.SiteID ]. AS a ON site.SiteID = a.SiteID
)

LEFT JOIN [SELECT scraper.SiteID,  SUM(scraper.NumberOfObjects)  as SNumberOfObjects
FROM object AS scraper
WHERE scraper.ObjectType LIKE 'Sc*' AND isNumeric(scraper.NumberOfObjects)
GROUP BY scraper.SiteID ]. AS b ON site.SiteID = b.SiteID
)

LEFT JOIN [SELECT adze.SiteID,  SUM(adze.NumberOfObjects)  as SNumberOfObjects
FROM object AS adze
WHERE adze.ObjectType = 'Tr.Ax' AND isNumeric(adze.NumberOfObjects)
GROUP BY adze.SiteID ]. AS c ON site.SiteID = c.SiteID
)

LEFT JOIN [SELECT pick.SiteID,  SUM(pick.NumberOfObjects)  as SNumberOfObjects
FROM object AS pick
WHERE pick.ObjectType = 'Pk' AND isNumeric(pick.NumberOfObjects)
GROUP BY pick.SiteID ]. AS d ON site.SiteID = d.SiteID
)

LEFT JOIN [SELECT PebbleMH.SiteID,  SUM(PebbleMH.NumberOfObjects)  as SNumberOfObjects
FROM object AS PebbleMH
WHERE PebbleMH.ObjectType = 'PMH' AND isNumeric(pebblemh.NumberOfObjects)
GROUP BY PebbleMH.SiteID ]. AS e ON site.SiteID = e.SiteID
)

LEFT JOIN [SELECT adzesf.SiteID, SUM(adzesf.NumberOfObjects)  as SNumberOfObjects
FROM object AS adzesf
WHERE adzesf.ObjectType LIKE 'Tr.Ax.SF*' AND isNumeric(Adzesf.NumberOfObjects)
GROUP BY adzesf.SiteID ]. AS f ON site.SiteID = f.SiteID
)

LEFT JOIN [SELECT BlFl.SiteID,  SUM(BlFl.NumberOfObjects)  as SNumberOfObjects
FROM object AS BlFl
WHERE BlFl.ObjectType = 'Bl/Fl' AND isNumeric(BLFl.NumberOfObjects)
GROUP BY BlFl.SiteID ]. AS g ON site.SiteID = g.SiteID
)

LEFT JOIN [SELECT Graver.SiteID,  SUM(Graver.NumberOfObjects)  as SNumberOfObjects
FROM object AS Graver
WHERE Graver.ObjectType = 'Gr' AND isNumeric(Graver.NumberOfObjects)
GROUP BY Graver.SiteID ]. AS h ON site.SiteID = h.SiteID
)

LEFT JOIN [SELECT Others.SiteID,  SUM(Others.NumberOfObjects)  as SNumberOfObjects
FROM object AS Others
WHERE Others.ObjectType = 'O' AND isNumeric(Others.NumberOfObjects)
GROUP BY Others.SiteID ]. AS i ON site.SiteID = i.SiteID
)

LEFT JOIN [SELECT MBurins.SiteID,  SUM(MBurins.NumberOfObjects)  as SNumberOfObjects
FROM object AS MBurins
WHERE MBurins.ObjectType = 'M-b' AND isNumeric(Mburins.NumberOfObjects)
GROUP BY MBurins.SiteID ]. AS j ON site.SiteID = j.SiteID
)

LEFT JOIN [SELECT Microlith.SiteID,  SUM(Microlith.NumberOfObjects)  as SNumberOfObjects
FROM object AS Microlith
WHERE Microlith.ObjectType  =  'M' AND isNumeric(microlith.NumberOfObjects)
GROUP BY Microlith.SiteID ]. AS k ON site.SiteID = k.SiteID
)

LEFT JOIN [SELECT bone.SiteID,  SUM(bone.NumberOfObjects)  as SNumberOfObjects
FROM object AS bone
WHERE bone.ObjectType LIKE '*bone*' AND isNumeric(bone.NumberOfObjects)
GROUP BY bone.SiteID ]. AS l ON site.SiteID = l.SiteID
)

LEFT JOIN [SELECT wood.SiteID,  SUM(wood.NumberOfObjects)  as SNumberOfObjects
FROM object AS wood
WHERE wood.ObjectType LIKE '*wood*' AND isNumeric(wood.NumberOfObjects)
GROUP BY wood.SiteID ]. AS m ON site.SiteID = m.SiteID
)

LEFT JOIN [SELECT antler.SiteID,  SUM(antler.NumberOfObjects)  as SNumberOfObjects
FROM object AS antler
WHERE antler.ObjectType LIKE '*antler*' AND isNumeric(antler.NumberOfObjects)
GROUP BY antler.SiteID ].  AS n ON site.SiteID = n.SiteID
;