0.0015 |
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.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '1'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '1'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '2'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '2'
|
0.0004 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '21'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '21'
|
0.0004 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '9'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '9'
|
0.0006 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '45'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '45'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '3'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '3'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '46'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '46'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '57'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '57'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '55'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '55'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '56'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '56'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '54'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '54'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '53'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '53'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '52'
|
0.0005 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '52'
|
0.0008 |
SELECT Tag, COUNT(1) AS cnt FROM `ProjectTags` WHERE `Tag` != 'Private' GROUP BY `Tag` HAVING COUNT(1) > 1
|