Difference between revisions of "User: Bgrenon/2"
| Line 37: | Line 37: | ||
tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId | ||
|join on=ComponentRN._ID=DepId._rowID,DepId._rowID=CompId._rowID | |join on=ComponentRN._ID=DepId._rowID,DepId._rowID=CompId._rowID | ||
| − | |fields=CompId._value=ComponentId | + | |fields=CompId._value=ComponentId,ComponentRN.ReleaseDate |
|group by=ComponentRN.ComponentId | |group by=ComponentRN.ComponentId | ||
<!--|format=template | <!--|format=template | ||
Revision as of 15:06, April 29, 2022
Query: SELECT `cargo__ComponentRN`.`ComponentId` AS `ComponentId` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) WHERE ReleaseDate IS NOT NULL AND `cargo__ComponentRN`.`_pageNamespace`="0" AND DATEDIFF(ReleaseDate,NOW()) >= -7 GROUP BY `cargo__ComponentRN`.`ComponentId` ORDER BY `cargo__Component`.`Name` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS `cargo__Component`.`Id`)) WHERE ReleaseDate IS NOT NULL AND `cargo__Comp' at line 1 (127.0.0.1)
Query: SELECT `cargo__ComponentRN`.`ComponentId` AS `ComponentId` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) WHERE ReleaseDate IS NOT NULL AND `cargo__ComponentRN`.`_pageNamespace`="0" AND DATEDIFF(ReleaseDate,NOW()) >= -30 GROUP BY `cargo__ComponentRN`.`ComponentId` ORDER BY `cargo__Component`.`Name` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS `cargo__Component`.`Id`)) WHERE ReleaseDate IS NOT NULL AND `cargo__Comp' at line 1 (127.0.0.1)
| ComponentId | ReleaseDate |
|---|---|
| 2021-06-18 | |
| 2021-07-07 | |
| 2021-07-08 | |
| 2022-03-29 | |
| 2022-04-26 | |
| 2022-05-27 | |
| 2022-08-25 | |
| 2022-08-25 | |
| 2022-08-25 | |
| 2022-08-25 | |
| 2022-08-25 | |
| 2022-08-25 | |
| 2022-09-21 | |
| 2022-09-21 | |
| 2023-04-19 | |
| 074d8cb2-e6a5-4df8-97d2-d1044727c558 | 2021-03-31 |
| 074d8cb2-e6a5-4df8-97d2-d1044727c558 | 2021-03-31 |
| 074d8cb2-e6a5-4df8-97d2-d1044727c558 | 2021-11-12 |
| 0ed06171-d761-4c0c-855b-af391b57e8a5 | 2021-07-22 |
| 3422613a-aedc-4c60-8382-2568e9d0c983 | 2021-10-26 |
| 3422613a-aedc-4c60-8382-2568e9d0c983 | 2022-04-27 |
| 35daaa1d-708e-48b8-af6c-cf258cbd4e0a | 2021-07-09 |
| 38f7f170-d83e-483b-a2ca-4dd424a28fde | 2021-03-31 |
| 38f7f170-d83e-483b-a2ca-4dd424a28fde | 2022-02-16 |
| 3be11e5d-6a28-4409-95d5-9b1af2b66417 | 2021-07-15 |
| 3be11e5d-6a28-4409-95d5-9b1af2b66417 | 2021-09-15 |
| 3be11e5d-6a28-4409-95d5-9b1af2b66417 | 2021-10-14 |
| 4c32d167-fb8a-4157-a204-8dbb1342a9f8 | 2021-03-31 |
| 6e3d490b-bb6c-4e5d-8a61-313290c6d632 | 2022-03-10 |
| 7802d66f-e043-41e3-8ef9-fa8f01a5d482 | 2021-03-31 |
| 9d93d57b-8e44-4ecb-97a7-ece81aa8fae8 | 2021-03-31 |
| 9d93d57b-8e44-4ecb-97a7-ece81aa8fae8 | 2022-04-04 |
| acaca529-aedd-4820-8557-4966ab8490db | 2021-09-22 |
| b9e5e9d4-37a0-4fa2-87a3-957773249c9b | 2021-05-13 |
| b9e5e9d4-37a0-4fa2-87a3-957773249c9b | 2022-07-11 |
| bdc82b52-150e-4825-9a98-3c45bca3c72d | 2022-02-01 |
| c6d90412-17a5-4d3b-b822-060c75731775 | 2021-09-17 |
| dc95d354-6dba-4291-98d9-f11343c12f7b | 2022-01-26 |
| e17cb0c3-b6d6-41c2-8dfc-40ee83f99d56 | 2022-01-04 |
| e17cb0c3-b6d6-41c2-8dfc-40ee83f99d56 | 2022-01-26 |
| e17cb0c3-b6d6-41c2-8dfc-40ee83f99d56 | 2022-05-24 |
| edfa30cc-f909-4114-b72e-0934810e3cd4 | 2021-03-31 |
| edfa30cc-f909-4114-b72e-0934810e3cd4 | 2021-03-31 |
| edfa30cc-f909-4114-b72e-0934810e3cd4 | 2022-03-22 |
| f1190ccf-1166-4200-9105-524d0f613a35 | 2022-07-08 |
| fd8aff3a-6766-4eb1-9281-c5c235de3426 | 2022-07-11 |