| 0.0076 |
SELECT * FROM (`Projects`) INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID` WHERE `Projects`.`ProjectID` > 0 AND `Projects`.`ProjectID` > 0 AND `ProjectTags`.`Tag` = 'Family' ORDER BY `Projects`.`Date` desc, `Projects`.`Date` desc
|
| 0.0054 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '3'
|
| 0.0041 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '3'
|
| 0.0053 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '47'
|
| 0.0054 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '47'
|
| 0.0053 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '46'
|
| 0.0063 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '46'
|
| 0.0050 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '48'
|
| 0.0048 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '48'
|
| 0.0035 |
SELECT * FROM (`ProjectTags`) WHERE `ProjectID` = '53'
|
| 0.0056 |
SELECT * FROM (`ProjectResources`) WHERE `ProjectID` = '53'
|
| 0.0037 |
SELECT Tag, COUNT(1) AS cnt FROM (ProjectTags) WHERE `Tag` != 'Private' GROUP BY Tag HAVING COUNT(1) >1
|