Stats for extensions
Describe the task
For an analysis of the extension updates, I would need some data about the supported TYPO3 versions of the Extensions in the Extension Manager.
I need the information about "works with TYPO3" (https://extensions.typo3.org/ ) from
- 22.03.2021 (3 month after 11.0 Release)
- 21.07.2020 (3 month after 10LTS Release)
- 23.11.2019 (3 month after 10.0 Release)
- 02.01.2019 (3 month after 9LTS Release)
Further details
I wanted to know, when people are updating their extensions.
What does success look like, and how can we measure that?
Information about the numbers of extensions for Version 7,8,9,10 and 11
Links / references
SELECT DISTINCT e.ext_key
FROM tx_terfe2_domain_model_extension AS e
JOIN tx_terfe2_domain_model_version AS v ON v.extension = e.uid
JOIN tx_terfe2_domain_model_relation AS r ON r.version = v.uid
WHERE r.relation_key = "typo3" AND r.maximum_version >= 10004000 AND v.upload_date <= UNIX_TIMESTAMP("2020-07-21")
ORDER BY e.ext_key