| 0.0122 |
SELECT * FROM (`Projects`) INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID` WHERE `Projects`.`ProjectID` > 0 AND `Projects`.`ProjectID` > 0 AND `ProjectTags`.`Tag` = 'Miscellaneous Utility' ORDER BY `Projects`.`Date` desc, `Projects`.`Date` desc
|
| 0.0110 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '76'
|
| 0.0113 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '76'
|
| 0.0127 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '68'
|
| 0.0123 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '68'
|
| 0.0105 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '17'
|
| 0.0115 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '17'
|
| 0.0087 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '14'
|
| 0.0072 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '14'
|
| 0.0090 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '10'
|
| 0.0076 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '10'
|
| 0.0081 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '24'
|
| 0.0068 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '24'
|
| 0.0076 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '13'
|
| 0.0073 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '13'
|
| 0.0088 |
SELECT Tag, COUNT(1) AS cnt FROM (ProjectTags) WHERE `Tag` != 'Private' GROUP BY Tag HAVING COUNT(1) >1
|