Gebruiker:Bdijkstra/dump/Gevraagde artikelen: verschil tussen versies
< Gebruiker:Bdijkstra | dump
Verwijderde inhoud Toegevoegde inhoud
k update lijst |
k update lijst |
||
Regel 45: | Regel 45: | ||
|- |
|- |
||
| [[:Belgisch strandvoetbalteam (vrouwen)]] |
| [[:Belgisch strandvoetbalteam (vrouwen)]] |
||
| style="text-align:right" | |
| style="text-align:right" | 686 |
||
⚫ | |||
⚫ | |||
⚫ | |||
|- |
|- |
||
| [[:Belgisch voetbalelftal onder 15]] |
| [[:Belgisch voetbalelftal onder 15]] |
||
| style="text-align:right" | |
| style="text-align:right" | 683 |
||
⚫ | |||
⚫ | |||
⚫ | |||
|- |
|- |
||
| [[:Belgisch vrouwenvoetbalelftal onder 15]] |
| [[:Belgisch vrouwenvoetbalelftal onder 15]] |
||
| style="text-align:right" | |
| style="text-align:right" | 662 |
||
|- |
|- |
||
| [[:Belgisch vrouwenvoetbalelftal onder 16]] |
| [[:Belgisch vrouwenvoetbalelftal onder 16]] |
||
| style="text-align:right" | |
| style="text-align:right" | 657 |
||
|- |
|- |
||
| [[:Biographical Directory of the United States Congress]] |
| [[:Biographical Directory of the United States Congress]] |
||
| style="text-align:right" | |
| style="text-align:right" | 557 |
||
|- |
|- |
||
| [[:Monostilifera]] |
| [[:Monostilifera]] |
||
| style="text-align:right" | 550 |
| style="text-align:right" | 550 |
||
|- |
|- |
||
| [[: |
| [[:ISO 3166-1 alpha-2]] |
||
| style="text-align:right" | |
| style="text-align:right" | 514 |
||
|- |
|- |
||
| [[:Art Gallery of South Australia]] |
| [[:Art Gallery of South Australia]] |
||
Regel 73: | Regel 73: | ||
| [[:Neuroleontina]] |
| [[:Neuroleontina]] |
||
| style="text-align:right" | 499 |
| style="text-align:right" | 499 |
||
⚫ | |||
⚫ | |||
⚫ | |||
|- |
|- |
||
| [[:Auckland Art Gallery Toi o Tāmaki]] |
| [[:Auckland Art Gallery Toi o Tāmaki]] |
||
Regel 81: | Regel 78: | ||
|- |
|- |
||
| [[:Myxosporea]] |
| [[:Myxosporea]] |
||
| style="text-align:right" | |
| style="text-align:right" | 474 |
||
|- |
|- |
||
| [[:Kebumen (regentschap)]] |
| [[:Kebumen (regentschap)]] |
||
| style="text-align:right" | |
| style="text-align:right" | 469 |
||
⚫ | |||
| [[:SV De Braak]] |
|||
⚫ | |||
|- |
|- |
||
| [[:ZZC '20]] |
| [[:ZZC '20]] |
||
| style="text-align:right" | |
| style="text-align:right" | 455 |
||
|- |
|- |
||
| [[:Ogan Komering Ulu]] |
| [[:Ogan Komering Ulu]] |
||
| style="text-align:right" | 435 |
| style="text-align:right" | 435 |
||
|- |
|- |
||
| [[: |
| [[:US Open 2021 (tennis, vrouwendubbel)]] |
||
| style="text-align:right" | |
| style="text-align:right" | 424 |
||
|- |
|- |
||
| [[:Braunton]] |
| [[:Braunton]] |
||
Regel 107: | Regel 107: | ||
| style="text-align:right" | 409 |
| style="text-align:right" | 409 |
||
|- |
|- |
||
| [[: |
| [[:Bridestowe and Sourton Common]] |
||
| style="text-align:right" | 408 |
| style="text-align:right" | 408 |
||
|- |
|- |
||
Regel 113: | Regel 113: | ||
| style="text-align:right" | 408 |
| style="text-align:right" | 408 |
||
|- |
|- |
||
| [[: |
| [[:Frogmore and Sherford]] |
||
| style="text-align:right" | 408 |
| style="text-align:right" | 408 |
||
|- |
|- |
||
| [[: |
| [[:Denbury and Torbryan]] |
||
| style="text-align:right" | 408 |
| style="text-align:right" | 408 |
||
|- |
|- |
||
| [[: |
| [[:East and West Buckland]] |
||
| style="text-align:right" | 408 |
| style="text-align:right" | 408 |
||
|- |
|- |
||
| [[: |
| [[:Satterleigh and Warkleigh]] |
||
| style="text-align:right" | 408 |
| style="text-align:right" | 408 |
||
|- |
|- |
||
| [[: |
| [[:Combpyne Rousdon]] |
||
| style="text-align:right" | 408 |
| style="text-align:right" | 408 |
||
|- |
|- |
||
| [[: |
| [[:Pilton West]] |
||
| style="text-align:right" | 408 |
| style="text-align:right" | 408 |
||
|- |
|- |
||
⚫ | |||
| [[:Bridestowe and Sourton Common]] |
|||
| style="text-align:right" | 408 |
| style="text-align:right" | 408 |
||
|- |
|- |
||
| [[: |
| [[:Lynton and Lynmouth]] |
||
| style="text-align:right" | 408 |
| style="text-align:right" | 408 |
||
|- |
|- |
||
| [[: |
| [[:West Buckfastleigh]] |
||
| style="text-align:right" | 408 |
| style="text-align:right" | 408 |
||
|- |
|- |
||
Regel 157: | Regel 157: | ||
| [[:Kiso Ultraviolet Galaxy Catalogue]] |
| [[:Kiso Ultraviolet Galaxy Catalogue]] |
||
| style="text-align:right" | 392 |
| style="text-align:right" | 392 |
||
⚫ | |||
⚫ | |||
⚫ | |||
|- |
|- |
||
| [[:Naaldsteenvliegen]] |
| [[:Naaldsteenvliegen]] |
||
| style="text-align:right" | 373 |
| style="text-align:right" | 373 |
||
|- |
|- |
||
⚫ | |||
⚫ | |||
| style="text-align:right" | 370 |
| style="text-align:right" | 370 |
||
⚫ | |||
| [[:Roland Garros 1989 (mannendubbel)]] |
|||
⚫ | |||
|- |
|- |
||
| [[:Atlas and Catalogue of interacting galaxies]] |
| [[:Atlas and Catalogue of interacting galaxies]] |
||
| style="text-align:right" | 369 |
| style="text-align:right" | 369 |
||
⚫ | |||
| [[:Italië op de Olympische Zomerspelen 1992]] |
|||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
|- |
|- |
||
| [[:Spanje op de Olympische Zomerspelen 1992]] |
| [[:Spanje op de Olympische Zomerspelen 1992]] |
||
| style="text-align:right" | |
| style="text-align:right" | 369 |
||
|- |
|- |
||
| [[: |
| [[:Roland Garros 1988 (mannendubbel)]] |
||
⚫ | |||
⚫ | |||
| [[:US Open 1988 (tennis, mannendubbel)]] |
|||
| style="text-align:right" | 357 |
| style="text-align:right" | 357 |
||
|- |
|- |
||
| [[: |
| [[:Wimbledon 1988 (mannendubbel)]] |
||
| style="text-align:right" | |
| style="text-align:right" | 356 |
||
|- |
|- |
||
| [[: |
| [[:Pasuruan (regentschap)]] |
||
| style="text-align:right" | 351 |
| style="text-align:right" | 351 |
||
|- |
|- |
||
| [[: |
| [[:Paul G. Comba]] |
||
| style="text-align:right" | 351 |
| style="text-align:right" | 351 |
||
|- |
|- |
||
| [[: |
| [[:Scalpellomorpha]] |
||
| style="text-align:right" | |
| style="text-align:right" | 349 |
||
⚫ | |||
| [[:Kediri (regentschap)]] |
|||
⚫ | |||
|} |
|} |
||
{{Gebruiker:Bdijkstra/Sjabloon:Einde lijst uit dump}} |
{{Gebruiker:Bdijkstra/Sjabloon:Einde lijst uit dump}} |
Huidige versie van 14 sep 2021 om 12:23
Variant op speciaal:GevraagdePagina's met wat tweaks:
- Alleen links van de hoofdnaamruimte naar de hoofdnaamruimte.
- Uitgesloten: titels van één woord die eindigen op -ida, -idae, -idea, -inae, -inea of -ini.
Query:
SELECT wikilink(0, pl_title),aantal
FROM (
SELECT pl_namespace,pl_title,COUNT(pl_from) AS aantal
FROM pagelinks
WHERE pl_from_namespace=0
GROUP BY pl_namespace,pl_title
ORDER BY COUNT(pl_from) DESC
LIMIT 50000
) pl1
WHERE
pl_namespace=0 AND
pl_title NOT REGEXP '^[A-Z][a-z]+(ida|idae|idea|inae|inea|ini)$' AND
NOT EXISTS (SELECT * FROM page WHERE page_namespace=0 AND pl_title=page_title)
LIMIT 50
Deze lijst wordt regelmatig bijgewerkt door een bot. Handmatige wijzigingen aan de lijst worden bij de volgende update verwijderd.