| 0.0227 |
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.0053 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '79'
|
| 0.0046 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '79'
|
| 0.0038 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '78'
|
| 0.0031 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '78'
|
| 0.0031 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '77'
|
| 0.0033 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '77'
|
| 0.0061 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '76'
|
| 0.0066 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '76'
|
| 0.0081 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '75'
|
| 0.0068 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '75'
|
| 0.0073 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '74'
|
| 0.0062 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '74'
|
| 0.0058 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '73'
|
| 0.0053 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '73'
|
| 0.0040 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '36'
|
| 0.0053 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '36'
|
| 0.0048 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '22'
|
| 0.0048 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '22'
|
| 0.0068 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '69'
|
| 0.0066 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '69'
|
| 0.0070 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '68'
|
| 0.0081 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '68'
|
| 0.0068 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '19'
|
| 0.0061 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '19'
|
| 0.0078 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '8'
|
| 0.0096 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '8'
|
| 0.0073 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '60'
|
| 0.0073 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '60'
|
| 0.0078 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '16'
|
| 0.0081 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '16'
|
| 0.0059 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '23'
|
| 0.0060 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '23'
|
| 0.0071 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '15'
|
| 0.0066 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '15'
|
| 0.0081 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '12'
|
| 0.0094 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '12'
|
| 0.0076 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '11'
|
| 0.0083 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '11'
|
| 0.0083 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '25'
|
| 0.0070 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '25'
|
| 0.0063 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '7'
|
| 0.0081 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '7'
|
| 0.0070 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '72'
|
| 0.0093 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '72'
|
| 0.0091 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '6'
|
| 0.0112 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '6'
|
| 0.0095 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '71'
|
| 0.0116 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '71'
|
| 0.0125 |
SELECT Tag, COUNT(1) AS cnt FROM (ProjectTags) WHERE `Tag` != 'Private' GROUP BY Tag HAVING COUNT(1) >1
|