Topul articolelor dupa numarul de comentarii

Friday, 16 September, Year 3 d.Tr. | Author: Mircea Popescu

Daca tot ne-a inspirat Nede, sa ducem inspiratia ceea pina la capat :

SELECT `post_title` , `post_name` , `comment_count`
FROM `tril_posts`
WHERE `comment_count` >99
ORDER BY `tril_posts`.`comment_count` DESC
LIMIT 0 , 300

Asta ar cere numele, urleele si numarul de comentarii pentru toate articolele care au peste 99 de comentarii (deci practic de la 100 in sus, doar ca am economisit doua caractere, >=100 e din cinci, >99 e din trei - haha!) ordonate descrescator dupa numarul de comentarii.

Si rezultatele, cum se zice in blogosfera, nu au intirziat sa apara!

Sa fiti vorbiti!

Category: Oda Superbiei
Comments feed : RSS 2.0. Leave your own comment below, or send a trackback.

3 Responses

  1. Recitind, constat ca am comentat muuuuuult pre mult.

  2. Mircea Popescu`s avatar
    2
    Mircea Popescu 
    Sunday, 18 September 2011

    Shit happens.

  3. Acum realizez cate chestii interesante mai am de citit.... am apucat sa-mi arunc un ochi decat peste cateva

Add your cents! »
    If this is your first comment, it will wait to be approved. This usually takes a few hours. Subsequent comments are not delayed.