| 0.0114 |
SELECT * FROM (`Projects`) INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID` WHERE `Projects`.`ProjectID` > 0 AND `Projects`.`ProjectID` > 0 AND `ProjectTags`.`Tag` = 'web' ORDER BY `Projects`.`Date` desc, `Projects`.`Date` desc
|
| 0.0038 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '1'
|
| 0.0038 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '1'
|
| 0.0031 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '2'
|
| 0.0055 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '2'
|
| 0.0043 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '21'
|
| 0.0061 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '21'
|
| 0.0051 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '9'
|
| 0.0058 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '9'
|
| 0.0048 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '45'
|
| 0.0046 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '45'
|
| 0.0055 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '3'
|
| 0.0033 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '3'
|
| 0.0015 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '46'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '46'
|
| 0.0011 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '57'
|
| 0.0093 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '57'
|
| 0.0045 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '55'
|
| 0.0103 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '55'
|
| 0.0086 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '56'
|
| 0.0074 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '56'
|
| 0.0160 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '54'
|
| 0.0058 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '54'
|
| 0.0100 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '53'
|
| 0.0407 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '53'
|
| 0.0093 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '52'
|
| 0.0064 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '52'
|
| 0.0051 |
SELECT Tag, COUNT(1) AS cnt FROM (ProjectTags) WHERE `Tag` != 'Private' GROUP BY Tag HAVING COUNT(1) >1
|