| 0.0219 |
SELECT * FROM (`Projects`) INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID` WHERE `Projects`.`ProjectID` > 0 AND `Projects`.`ProjectID` > 0 AND `ProjectTags`.`Tag` = 'PHP' ORDER BY `Projects`.`Date` desc, `Projects`.`Date` desc
|
| 0.0319 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '1'
|
| 0.0367 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '1'
|
| 0.0378 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '2'
|
| 0.0280 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '2'
|
| 0.0333 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '21'
|
| 0.0234 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '21'
|
| 0.0232 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '43'
|
| 0.0223 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '43'
|
| 0.0245 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '3'
|
| 0.0191 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '3'
|
| 0.0159 |
SELECT Tag, COUNT(1) AS cnt FROM (ProjectTags) WHERE `Tag` != 'Private' GROUP BY Tag HAVING COUNT(1) >1
|