0.0017 |
SELECT * FROM `Projects` INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID` WHERE `Projects`.`ProjectID` >0 AND `Projects`.`ProjectID` >0 AND `ProjectTags`.`Tag` = 'Gaming' ORDER BY `Projects`.`Date` DESC, `Projects`.`Date` DESC
|
0.0004 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '95'
|
0.0005 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '95'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '90'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '90'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '67'
|
0.0005 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '67'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '5'
|
0.0005 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '5'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '4'
|
0.0005 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '4'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '43'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '43'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '65'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '65'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '38'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '38'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '33'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '33'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '29'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '29'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '34'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '34'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '59'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '59'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '64'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '64'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '49'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '49'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '32'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '32'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '62'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '62'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '30'
|
0.0005 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '30'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '51'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '51'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '28'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '28'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '20'
|
0.0006 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '20'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '27'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '27'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '26'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '26'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '42'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '42'
|
0.0010 |
SELECT Tag, COUNT(1) AS cnt FROM `ProjectTags` WHERE `Tag` != 'Private' GROUP BY `Tag` HAVING COUNT(1) > 1
|