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

https://extensions.typo3.org/

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