0.0101 |
SELECT * FROM `Projects` INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID` WHERE `Projects`.`ProjectID` >0 AND `Projects`.`ProjectID` >0 AND `ProjectTags`.`Tag` = 'Kofax' ORDER BY `Projects`.`Date` DESC, `Projects`.`Date` DESC
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '94'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '94'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '92'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '92'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '93'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '93'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '91'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '91'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '86'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '86'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '81'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '81'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '79'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '79'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '78'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '78'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '77'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '77'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '76'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '76'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '75'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '75'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '74'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '74'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '73'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '73'
|
0.0004 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '36'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '36'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '22'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '22'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '69'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '69'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '68'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '68'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '19'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '19'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '8'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '8'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '60'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '60'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '16'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '16'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '23'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '23'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '15'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '15'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '11'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '11'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '12'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '12'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '25'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '25'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '7'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '7'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '72'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '72'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '6'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '6'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '71'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '71'
|
0.0014 |
SELECT Tag, COUNT(1) AS cnt FROM `ProjectTags` WHERE `Tag` != 'Private' GROUP BY `Tag` HAVING COUNT(1) > 1
|