| 0.0061 |
SELECT * FROM (`Projects`) INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID` WHERE `Projects`.`ProjectID` > 0 AND `Projects`.`ProjectID` > 0 AND `ProjectTags`.`Tag` = 'KTM' ORDER BY `Projects`.`Date` desc, `Projects`.`Date` desc
|
| 0.0007 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '78'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '78'
|
| 0.0006 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '74'
|
| 0.0009 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '74'
|
| 0.0005 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '36'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '36'
|
| 0.0058 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '22'
|
| 0.0048 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '22'
|
| 0.0050 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '69'
|
| 0.0068 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '69'
|
| 0.0040 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '19'
|
| 0.0051 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '19'
|
| 0.0048 |
SELECT Tag, COUNT(1) AS cnt FROM (ProjectTags) WHERE `Tag` != 'Private' GROUP BY Tag HAVING COUNT(1) >1
|