| 0.0232 |
SELECT * FROM (`Projects`) INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID` WHERE `Projects`.`ProjectID` > 0 AND `Projects`.`ProjectID` > 0 AND `ProjectTags`.`Tag` = 'Kofax Internal' ORDER BY `Projects`.`Date` desc, `Projects`.`Date` desc
|
| 0.0274 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '79'
|
| 0.0239 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '79'
|
| 0.0215 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '75'
|
| 0.0259 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '75'
|
| 0.0207 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '11'
|
| 0.0226 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '11'
|
| 0.0228 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '25'
|
| 0.0187 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '25'
|
| 0.0135 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '72'
|
| 0.0113 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '72'
|
| 0.0133 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '71'
|
| 0.0172 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '71'
|
| 0.0153 |
SELECT Tag, COUNT(1) AS cnt FROM (ProjectTags) WHERE `Tag` != 'Private' GROUP BY Tag HAVING COUNT(1) >1
|