| 0.0190 |
SELECT * FROM (`Projects`) WHERE `Projects`.`ProjectID` > 0 ORDER BY `Projects`.`Date` desc
|
| 0.0099 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '79'
|
| 0.0081 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '79'
|
| 0.0011 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '78'
|
| 0.0009 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '78'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '77'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '77'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '76'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '76'
|
| 0.0007 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '75'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '75'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '74'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '74'
|
| 0.0038 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '73'
|
| 0.0041 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '73'
|
| 0.0156 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '67'
|
| 0.0017 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '67'
|
| 0.0007 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '1'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '1'
|
| 0.0003 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '2'
|
| 0.0006 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '2'
|
| 0.0011 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '36'
|
| 0.0033 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '36'
|
| 0.0011 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '22'
|
| 0.0098 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '22'
|
| 0.0015 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '69'
|
| 0.0023 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '69'
|
| 0.0046 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '68'
|
| 0.0056 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '68'
|
| 0.0041 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '21'
|
| 0.0028 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '21'
|
| 0.0015 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '19'
|
| 0.0031 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '19'
|
| 0.0046 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '17'
|
| 0.0023 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '17'
|
| 0.0031 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '14'
|
| 0.0016 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '14'
|
| 0.0016 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '10'
|
| 0.0018 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '10'
|
| 0.0024 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '8'
|
| 0.0036 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '8'
|
| 0.0025 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '60'
|
| 0.0021 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '60'
|
| 0.0026 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '16'
|
| 0.0018 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '16'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '23'
|
| 0.0009 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '23'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '15'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '15'
|
| 0.0011 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '12'
|
| 0.0023 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '12'
|
| 0.0021 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '11'
|
| 0.0014 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '11'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '24'
|
| 0.0016 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '24'
|
| 0.0018 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '25'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '25'
|
| 0.0006 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '9'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '9'
|
| 0.0010 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '70'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '70'
|
| 0.0007 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '7'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '7'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '5'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '5'
|
| 0.0009 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '35'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '35'
|
| 0.0010 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '72'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '72'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '6'
|
| 0.0016 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '6'
|
| 0.0088 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '71'
|
| 0.0012 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '71'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '4'
|
| 0.0013 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '4'
|
| 0.0052 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '45'
|
| 0.0015 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '45'
|
| 0.0013 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '39'
|
| 0.0016 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '39'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '43'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '43'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '18'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '18'
|
| 0.0011 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '13'
|
| 0.0019 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '13'
|
| 0.0010 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '3'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '3'
|
| 0.0007 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '65'
|
| 0.0006 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '65'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '38'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '38'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '33'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '33'
|
| 0.0011 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '47'
|
| 0.0013 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '47'
|
| 0.0007 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '29'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '29'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '34'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '34'
|
| 0.0013 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '37'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '37'
|
| 0.0013 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '58'
|
| 0.0006 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '58'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '46'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '46'
|
| 0.0021 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '59'
|
| 0.0015 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '59'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '57'
|
| 0.0023 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '57'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '63'
|
| 0.0018 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '63'
|
| 0.0016 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '31'
|
| 0.0016 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '31'
|
| 0.0013 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '64'
|
| 0.0013 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '64'
|
| 0.0011 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '48'
|
| 0.0013 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '48'
|
| 0.0011 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '44'
|
| 0.0013 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '44'
|
| 0.0067 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '49'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '49'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '32'
|
| 0.0016 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '32'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '62'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '62'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '30'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '30'
|
| 0.0007 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '51'
|
| 0.0010 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '51'
|
| 0.0012 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '28'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '28'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '55'
|
| 0.0013 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '55'
|
| 0.0011 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '20'
|
| 0.0013 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '20'
|
| 0.0007 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '56'
|
| 0.0015 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '56'
|
| 0.0016 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '54'
|
| 0.0016 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '54'
|
| 0.0011 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '61'
|
| 0.0023 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '61'
|
| 0.0010 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '53'
|
| 0.0013 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '53'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '40'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '40'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '41'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '41'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '52'
|
| 0.0008 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '52'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '27'
|
| 0.0006 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '27'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '26'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '26'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '50'
|
| 0.0006 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '50'
|
| 0.0008 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '42'
|
| 0.0011 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '42'
|
| 0.0007 |
SELECT Tag, COUNT(1) AS cnt FROM (ProjectTags) WHERE `Tag` != 'Private' GROUP BY Tag HAVING COUNT(1) >1
|