Z Wikipedie, otevřené encyklopedie
MariaDB [cswiki_p]> select page_id, page_namespace, page_title, page_len from categorylinks join page on cl_from=page_id where page_namespace=0 and cl_to in ('Muži', 'Ženy') and cl_from not in (select tl_from from templatelinks join linktarget on lt_id=tl_target_id where lt_namespace=10 and lt_title in ('Infobox', 'Infobox_začátek')) order by page_len desc limit 30;
+---------+----------------+---------------------------------------------+----------+
| page_id | page_namespace | page_title | page_len |
+---------+----------------+---------------------------------------------+----------+
| 1592968 | 0 | Oswald_Machanek | 35938 |
| 456440 | 0 | Indy | 29177 |
| 1716956 | 0 | Lucius_Artorius_Castus | 23022 |
| 1702828 | 0 | Patrik_Kincl | 22589 |
| 1480673 | 0 | Epos_257 | 18862 |
| 346414 | 0 | Khudždžuttará | 18838 |
| 1693375 | 0 | Pjér_la_Šé'z | 17768 |
| 1637762 | 0 | Wang_Č’_(pirát) | 16528 |
| 1595320 | 0 | Nicolas_Perrot | 15715 |
| 1809923 | 0 | Jan_Žďárek | 15203 |
| 1678279 | 0 | Uzi_(hráč) | 14147 |
| 1461893 | 0 | Roman_Častoral | 12986 |
| 1335644 | 0 | I_Sang-hjok | 12702 |
| 1282946 | 0 | Tomáš_Šťastný_(profesionální_hráč) | 12216 |
| 1228382 | 0 | Turkanský_chlapec | 11607 |
| 1617191 | 0 | Žena_z_Isdalu | 11594 |
| 1708248 | 0 | Martin_Vohánka | 11446 |
| 1691873 | 0 | Theoris_z_Lemnu | 11238 |
| 1755000 | 0 | Martin_Chladni | 11236 |
| 12074 | 0 | Jonáš_(prorok) | 11211 |
| 1680682 | 0 | Nikki_Glaser | 11025 |
| 1494643 | 0 | Jiří_Popelka | 10376 |
| 1456440 | 0 | Rudolf_Schwarz_(architekt) | 10032 |
| 1794418 | 0 | Greenbrierský_duch | 9818 |
| 1280243 | 0 | Oleksandr_Kostyliev | 9802 |
| 1720944 | 0 | Antonín_Jedlička_(kněz) | 9779 |
| 1613999 | 0 | Marie_Tefrová | 9513 |
| 1110414 | 0 | Rúpa_Gósvámí | 9301 |
| 1117069 | 0 | Džíva_Gósvámí | 9252 |
| 1738947 | 0 | Amalia_Flemingová | 8777 |
+---------+----------------+---------------------------------------------+----------+
30 rows in set (0.280 sec)
MariaDB [cswiki_p]>
