| 0.0073 |
SELECT * FROM (`Projects`) INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID` WHERE `Projects`.`ProjectID` > 0 AND `Projects`.`ProjectID` > 0 AND `ProjectTags`.`Tag` = 'Game Mod' ORDER BY `Projects`.`Date` desc, `Projects`.`Date` desc
|
| 0.0029 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '33'
|
| 0.0021 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '33'
|
| 0.0023 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '29'
|
| 0.0022 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '29'
|
| 0.0028 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '34'
|
| 0.0031 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '34'
|
| 0.0028 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '59'
|
| 0.0038 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '59'
|
| 0.0026 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '30'
|
| 0.0036 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '30'
|
| 0.0034 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '51'
|
| 0.0026 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '51'
|
| 0.0040 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '28'
|
| 0.0045 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '28'
|
| 0.0040 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '20'
|
| 0.0054 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '20'
|
| 0.0027 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '27'
|
| 0.0018 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '27'
|
| 0.0023 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '26'
|
| 0.0021 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '26'
|
| 0.0026 |
SELECT Tag, COUNT(1) AS cnt FROM (ProjectTags) WHERE `Tag` != 'Private' GROUP BY Tag HAVING COUNT(1) >1
|