coocorrencia

coocorrencia.txt

mysql> SELECT category_id, categories.name, count(*) as count FROM article_categories LEFT JOIN categories ON categories.id = category_id WHERE article_id in (select article_id from article_categories where category_id = 2179) AND category_id <> 2179 GROUP BY category_id ORDER BY count DESC LIMIT 100;
+-------------+------------------------+-------+
| category_id | name                   | count |
+-------------+------------------------+-------+
|         334 | olympics               |  2806 |
|      280214 | olympícs               |  2243 |
|      123916 | commentid=sports       |   754 |
|        8023 | mlb                    |   530 |
|          36 | news                   |   435 |
|      199103 | london-olympics        |   344 |
|        1050 | london                 |   341 |
|      155381 | world-news             |   287 |
|       15008 | london 2012            |   225 |
|      155395 | commentid=world-news   |   217 |
|        5474 | soccer                 |   207 |
|      283579 | eyes-on-london         |   201 |
|        5482 | golf                   |   189 |
|        7114 | nfl                    |   187 |
|         298 | tennis                 |   179 |
|        3837 | us-news                |   172 |
|      236384 | swm                    |   171 |
|      198681 | london-games           |   170 |
|         206 | us                     |   169 |
|         235 | video                  |   159 |
|      133310 | ath                    |   155 |
|        5091 | basketball             |   149 |
|       89260 | london olympics        |   144 |
|        1583 | women                  |   144 |
|       77754 | sports news            |   138 |
|      261521 | michael-phelps         |   136 |
|        3741 | men                    |   134 |
|          16 | vídeo                  |   132 |
|        7375 | cycling                |   130 |
|       75394 | vidéo                  |   129 |
|       17429 | en                     |   124 |
|      196745 | united-states          |   123 |
|       77741 | news &amp; gossip      |   117 |
|         771 | tv                     |   111 |
|        3838 | commentid=us-news      |   111 |
|       76822 | swimming               |   108 |
|         279 | videos                 |   107 |
|       74179 | boxing                 |   103 |
|         167 | television             |   102 |
|        5775 | vídeos                 |   102 |
|         417 | vidéos                 |   102 |
|        1321 | football               |   100 |
|      123911 | british-open           |    95 |
|      261598 | usain-bolt             |    94 |
|        8352 | televisión             |    94 |
|      167071 | sebastian-coe          |    89 |
|       38475 | open                   |    87 |
|        2934 | uk                     |    84 |
|      330450 | olympic-park           |    83 |
|      103383 | gym                    |    81 |
|        5493 | nba                    |    80 |
|       14905 | nascar                 |    80 |
|      263622 | télevision             |    79 |
|       14542 | olympics 2012          |    79 |
|         609 | uncategorized          |    79 |
|        4516 | website                |    79 |
|        3684 | nbc                    |    78 |
|      140901 | therecord              |    78 |
|        3343 | entertainment          |    75 |
|      142444 | south-korea            |    72 |
|         163 | twitter                |    70 |
|          65 | games                  |    70 |
|      301728 | wtl                    |    69 |
|       27955 | doping                 |    66 |
|      123691 | bradley-wiggins        |    64 |
|       85686 | michael phelps         |    64 |
|      146906 | row                    |    64 |
|       30522 | olympic                |    63 |
|        3439 | history                |    62 |
|      123914 | college-football       |    61 |
|      276021 | jud                    |    60 |
|      193440 | auto-racing            |    59 |
|          94 | technology             |    58 |
|        2134 | no                     |    57 |
|       39743 | nó                     |    56 |
|       67523 | advertising & branding |    55 |
|        7864 | gymnastics             |    54 |
|      331638 | kerri-walsh-jennings   |    52 |
|        7586 | 2012 olympics          |    51 |
|      341316 | misty-may-treanor      |    49 |
|      189518 | associated-press       |    49 |
|       67926 | penn-state             |    49 |
|         610 | photos                 |    49 |
|      338817 | queen-elizabeth-ii     |    47 |
|        8565 | smh                    |    46 |
|      338142 | sho                    |    46 |
|      340618 | andy-roddick           |    45 |
|      202223 | north-korea            |    45 |
|        1061 | social media           |    44 |
|        2158 | cars                   |    44 |
|          34 | lifestyle              |    44 |
|      335744 | rdp                    |    44 |
|      385407 | gabby-douglas          |    43 |
|       77742 | pure craziness         |    43 |
|       77745 | you can't be serious!  |    42 |
|         306 | usa                    |    42 |
|        2136 | normal article         |    42 |
|         801 | can                    |    41 |
|        5444 | baseball               |    41 |
|       65092 | eyes                   |    41 |
+-------------+------------------------+-------+
100 rows in set (9.20 sec)