0.0018 |
SELECT * FROM `Projects` WHERE `Projects`.`ProjectID` >0 ORDER BY `Projects`.`Date` DESC
|
0.0005 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '96'
|
0.0007 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '96'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '95'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '95'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '94'
|
0.0003 |
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.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '93'
|
0.0004 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '91'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '91'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '90'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '90'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '88'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '88'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '89'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '89'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '87'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '87'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '86'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '86'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '83'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '83'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '84'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '84'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '85'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '85'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '81'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '81'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '82'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '82'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '80'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '80'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '79'
|
0.0004 |
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.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '74'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '73'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '73'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '67'
|
0.0006 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '67'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '1'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '1'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '2'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '2'
|
0.0003 |
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.0004 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '68'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '68'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '21'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '21'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '19'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '19'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '17'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '17'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '14'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '14'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '10'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '10'
|
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.0004 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '12'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '12'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '11'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '11'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '24'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '24'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '25'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '25'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '9'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '9'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '70'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '70'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '7'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '7'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '5'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '5'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '35'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '35'
|
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.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '4'
|
0.0005 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '4'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '45'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '45'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '39'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '39'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '43'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '43'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '18'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '18'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '13'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '13'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '3'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '3'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '65'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '65'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '38'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '38'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '33'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '33'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '47'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '47'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '29'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '29'
|
0.0004 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '34'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '34'
|
0.0004 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '37'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '37'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '58'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '58'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '46'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '46'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '59'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '59'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '57'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '57'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '63'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '63'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '31'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '31'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '64'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '64'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '48'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '48'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '44'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '44'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '49'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '49'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '32'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '32'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '62'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '62'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '30'
|
0.0005 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '30'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '51'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '51'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '28'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '28'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '55'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '55'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '20'
|
0.0005 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '20'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '56'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '56'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '54'
|
0.0004 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '54'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '61'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '61'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '53'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '53'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '40'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '40'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '41'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '41'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '52'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '52'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '27'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '27'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '26'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '26'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '50'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '50'
|
0.0003 |
SELECT * FROM `ProjectTags` WHERE `ProjectID` = '42'
|
0.0003 |
SELECT * FROM `ProjectResources` WHERE `ProjectID` = '42'
|
0.0010 |
SELECT Tag, COUNT(1) AS cnt FROM `ProjectTags` WHERE `Tag` != 'Private' GROUP BY `Tag` HAVING COUNT(1) > 1
|