| 0.0046 |
SELECT * FROM (`Projects`) INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID` WHERE `Projects`.`ProjectID` > 0 AND `Projects`.`ProjectID` > 0 AND `ProjectTags`.`Tag` = 'VB6' ORDER BY `Projects`.`Date` desc, `Projects`.`Date` desc
|
| 0.0006 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '6'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '6'
|
| 0.0006 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '39'
|
| 0.0024 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '39'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '18'
|
| 0.0013 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '18'
|
| 0.0075 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '13'
|
| 0.0018 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '13'
|
| 0.0033 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '65'
|
| 0.0021 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '65'
|
| 0.0006 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '33'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '33'
|
| 0.0051 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '37'
|
| 0.0028 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '37'
|
| 0.0005 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '58'
|
| 0.0009 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '58'
|
| 0.0028 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '63'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '63'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '31'
|
| 0.0017 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '31'
|
| 0.0015 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '64'
|
| 0.0013 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '64'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '61'
|
| 0.0009 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '61'
|
| 0.0053 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '40'
|
| 0.0014 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '40'
|
| 0.0035 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '41'
|
| 0.0013 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '41'
|
| 0.0011 |
SELECT Tag, COUNT(1) AS cnt FROM (ProjectTags) WHERE `Tag` != 'Private' GROUP BY Tag HAVING COUNT(1) >1
|