Gebruker:Erwin/Wantedpages

SELECT CONCAT('# [[', pl_title, ']] - ', COUNT(*), ' [[Special:Whatlinkshere/', pl_title, '|links]]') FROM pagelinks LEFT JOIN page AS p1 ON pl_namespace = p1.page_namespace AND pl_title = p1.page_title LEFT JOIN page AS p2 ON pl_from = p2.page_id WHERE p1.page_namespace IS NULL AND pl_namespace NOT IN (2,3) AND p2.page_namespace = 0 GROUP BY pl_title HAVING COUNT(*) > 10 ORDER BY COUNT(*) DESC;

1. 1945 - 45 links
2. 1990 - 41 links
3. 1370-1379 - 37 links
4. 1991 - 36 links
5. 1360-1369 - 35 links
6. 1960 - 35 links
7. 1992 - 33 links
8. 1350-1359 - 32 links
9. 1944 - 30 links
10. 1969 - 30 links
11. 1948 - 29 links
12. 1971 - 29 links
13. 1946 - 29 links
14. 1995 - 28 links
15. 1993 - 27 links
16. Hollaans_(dialekt) - 27 links
17. 1918 - 26 links
18. Kleifries - 26 links
19. 1994 - 26 links
20. 1975 - 25 links
21. Sovjet-Unie - 25 links
22. Braobans - 24 links
23. Schiermonnikoogs - 24 links
24. Hindeloopers - 24 links
25. 1968 - 24 links
26. Westers_(Terschelling) - 24 links
27. Zuudwesthoeks - 24 links
28. Noordhoeks - 24 links
29. Aasters - 24 links
30. Oost-Vlaams - 24 links
31. 1977 - 23 links
32. Indo-Europees - 23 links
33. Australië - 23 links
34. 1973 - 23 links
35. 1967 - 23 links
36. Londen - 23 links
37. 1949 - 23 links
38. 1963 - 22 links
39. 1981 - 22 links
40. 1340-1349 - 22 links
41. 1980 - 22 links
42. 1986 - 22 links
43. 1982 - 22 links
44. 1976 - 22 links
45. Klanenbeek - 21 links
46. 1989 - 21 links
47. 1942 - 21 links
48. 1940 - 21 links
49. 1947 - 21 links
50. 1962 - 21 links
51. Toerisme - 20 links
52. 1961 - 20 links
53. 1941 - 20 links
54. 1939 - 20 links
55. 1953 - 20 links
56. 1985 - 20 links
57. 1955 - 20 links
58. Grunnegs_T - 19 links
59. Grunnegs_K - 19 links
60. Grunnegs_U - 19 links
61. 1938 - 19 links
62. Grunnegs_L - 19 links
63. Grunnegs_V - 19 links
64. 1974 - 19 links
65. Israël - 19 links
66. Grunnegs_M - 19 links
67. Grunnegs_W - 19 links
68. Blaojen - 19 links
69. 1815 - 19 links
70. Grunnegs_N - 19 links
71. Grunnegs_Z - 19 links
72. Grunnegs_O - 19 links
73. 1929 - 19 links
74. Grunnegs_P - 19 links
75. 1964 - 19 links
76. Grunnegs_R - 19 links
77. Nijmegen - 19 links
78. Iezer - 18 links
79. 1952 - 18 links
80. 1972 - 18 links
81. Argentinië - 18 links
82. Paries - 18 links
83. Iran - 18 links
84. Rome_(stad) - 17 links
85. 1920 - 17 links
86. Vruch - 17 links
87. 1956 - 17 links
88. Wilhelmina_van_Nederlaand - 17 links
89. 1959 - 17 links
90. 1925 - 16 links
91. 1919 - 16 links
92. 1935 - 16 links
93. 1951 - 16 links
94. 1937 - 16 links
95. Euro - 16 links
96. Andorra - 16 links
97. 1934 - 16 links
98. 1943 - 15 links
99. 1917 - 15 links
100. 1950 - 15 links
101. Rien - 15 links
102. 1978 - 15 links
103. 1965 - 15 links
104. Jeanne_d'Arc - 15 links
105. Westerveld - 15 links
106. De_Wolden - 15 links
107. 1966 - 14 links
108. 1933 - 14 links
109. Midden-Drenthe - 14 links
110. Noord-Amerika - 14 links
111. Eerste_Wereldoorlog - 14 links
112. Stadsrechten - 14 links
113. Berlien - 14 links
114. Libië - 13 links
115. Kroatië - 13 links
116. Marokko - 13 links
117. 1922 - 13 links
118. Beilen - 13 links
119. Bosnië-Herzegovina - 13 links
120. Benelux - 13 links
121. 1890 - 13 links
122. Georgië - 13 links
123. NAVO - 13 links
124. Bangladesh - 13 links
125. Hoogduuts - 13 links
126. Bisschop - 13 links
127. 1830 - 13 links
128. Thailaand - 13 links
129. 1936 - 13 links
130. Noordenveld - 13 links
131. 1926 - 13 links
132. 1979 - 13 links
133. 1912 - 13 links
134. 1970-1979 - 13 links
135. 1900 - 13 links
136. Afghanistan - 12 links
137. 1330-1339 - 12 links
138. 1888 - 12 links
139. 1879 - 12 links
140. Keizer - 12 links
141. 1957 - 12 links
142. 1990-1999 - 12 links
143. Dierenriem - 12 links
144. Ethiopië - 12 links
145. 2000-2009 - 12 links
146. 1932 - 12 links
147. Albanië - 12 links
148. 2009 - 12 links
149. Suriname - 12 links
150. 1983 - 12 links
151. Lan_Xang - 12 links
152. 1800 - 12 links
153. 1846 - 12 links
154. Germanen - 12 links
155. 1914 - 12 links
156. Börger-Oring - 12 links
157. Irak - 12 links
158. 1889 - 12 links
159. 1987 - 12 links
160. 1931 - 12 links
161. 1883 - 12 links
162. 1980-1989 - 11 links
163. Koning - 11 links
164. Peru - 11 links
165. Syrië - 11 links
166. 1840 - 11 links
167. 2010-2019 - 11 links
168. Boeddhisme - 11 links
169. Boom - 11 links
170. 2020-2029 - 11 links
171. Brussel_(stad) - 11 links
172. Staotsbosbeheer - 11 links
173. Máxima_Zorreguieta - 11 links
174. 1867 - 11 links
175. Germoans - 11 links
176. Vet - 11 links
177. 1600 - 11 links
178. 1988 - 11 links
179. Zuud-Amerika - 11 links