| 0.0062 |
SELECT *
FROM (`Projects`)
INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID`
WHERE `Projects`.`ProjectID` > 0
AND `Projects`.`ProjectID` > 0
AND `ProjectTags`.`Tag` = 'CSS'
ORDER BY `Projects`.`Date` desc, `Projects`.`Date` desc
|
| 0.0019 |
SELECT *
FROM (`ProjectTags`)
WHERE `ProjectID` = '1'
|
| 0.0012 |
SELECT *
FROM (`ProjectResources`)
WHERE `ProjectID` = '1'
|
| 0.0013 |
SELECT *
FROM (`ProjectTags`)
WHERE `ProjectID` = '43'
|
| 0.0031 |
SELECT *
FROM (`ProjectResources`)
WHERE `ProjectID` = '43'
|
| 0.0024 |
SELECT Tag, COUNT(1) AS cnt
FROM (ProjectTags)
WHERE `Tag` != 'Private'
GROUP BY Tag
HAVING COUNT(1) >1
|
