How to view popular TYPO3 extensions without restrictions

Русская версия статьи / Russian version

Valery Romanchev (TYPO3 Laboratory) show the way to view all popular TYPO3 extensions without accessing to typo3.org and without restrictions on amount of viewed extensions on same page.

After you update extension list from repository, You can perform following SQL request to TYPO3 database:

1
2
3
4
5
6
7

SELECT `extkey`, `alldownloadcounter`, `title`, `description`,
`state`, `authorname`,` authoremail`, `ownerusername`,
FROM_UNIXTIME(MAX(`lastuploaddate`)) AS last_upload 
FROM `cache_extensions` 
WHERE lastuploaddate > UNIX_TIMESTAMP('2007-01-01')
GROUP BY `extkey`  
ORDER BY `alldownloadcounter` DESC

Happy extensions exploring!

Original post on typo3.biz forum

P.S.: Dear, Readers, if you interested in English versions of articles about TYPO3 and TYPO3 snippets please let me know. Leave comments in my blog.