SELECT *FROM (`Projects`)INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID`WHERE `Projects`.`ProjectID` > 0AND `Projects`.`ProjectID` > 0AND `ProjectTags`.`Tag` = 'School'ORDER BY `Projects`.`Date` desc, `Projects`.`Date` desc
SELECT *FROM (`ProjectTags`)WHERE `ProjectID` = '37'
SELECT *FROM (`ProjectResources`)WHERE `ProjectID` = '37'
SELECT *FROM (`ProjectTags`)WHERE `ProjectID` = '56'
SELECT *FROM (`ProjectResources`)WHERE `ProjectID` = '56'
SELECT Tag, COUNT(1) AS cntFROM (ProjectTags)WHERE `Tag` != 'Private'GROUP BY TagHAVING COUNT(1) >1