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 `Tag`HAVING COUNT(1) > 1
Array ( )