First asksql bug:
From shell:
mysql> select a.cur_id,b.cur_id
from cur as a, cur as b limit 5
-> ;
+--------+--------+
| cur_id | cur_id |
+--------+--------+
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
+--------+--------+
5 rows in set (0.02 sec)
From asksql:
cur_id cur_id
1 1
1 1
1 1
1 1
1 1
Now the problem:
select a.cur_title,a.cur_id,b.cur_id from cur as a, cur as b where
a.cur_namespace=0 and b.cur_namespace=0 and a.cur_title=b.cur_title and a.cur_id >
b.cur_id;
That is - select all articles which have duplicated titles:
+------------------------------------------------+--------+--------+
| cur_title | cur_id | cur_id |
+------------------------------------------------+--------+--------+
| 1936 | 8302 | 7278 |
| 1937 | 8303 | 7279 |
| 1941 | 8304 | 7282 |
| 1949 | 8305 | 7291 |
| 1961 | 8306 | 7304 |
| 1978 | 8307 | 7320 |
| 1996 | 8308 | 7336 |
| Afganistan | 8309 | 155 |
| Afryka | 8310 | 250 |
| Alexander_Hamilton | 8311 | 135 |
| Ameby | 8312 | 456 |
| Ameryka_�aci�ska | 8313 | 187 |
| Aminokwas | 8314 | 9 |
| Anders_Angstrom | 8315 | 272 |
| Anglia | 8316 | 388 |
| Archeany | 8317 | 454 |
| Bakterie | 8318 | 736 |
| Beniamin_Franklin | 8319 | 543 |
| Bia�ko | 8320 | 466 |
| Bia�oru� | 8321 | 499 |
| Bia�ystok | 8322 | 465 |
| Biochemia | 8324 | 482 |
| Biologia | 8325 | 470 |
| Boles�aw_II_�mia�y | 8327 | 604 |
| Boles�aw_I_Chrobry | 8328 | 531 |
| Botanika | 8329 | 520 |
| Celtowie | 8330 | 844 |
| Chromosom | 8332 | 843 |
| Cytoplazma | 8333 | 802 |
| Czes�aw_Ta�ski | 8334 | 1060 |
| Drezno | 8335 | 1235 |
| Drzewo_Życia | 8336 | 1129 |
| Edwin_Aldrin | 8337 | 1419 |
| Egipt | 8338 | 1405 |
| Erytrocyt | 8339 | 1442 |
| Europa | 8340 | 1368 |
| Francja | 8341 | 1539 |
| Gen | 8342 | 1717 |
| Genom | 8343 | 1719 |
| Gwara | 8344 | 1813 |
| I_Wojna_�wiatowa | 8345 | 2435 |
| Intron | 8347 | 2311 |
| Irlandia | 8348 | 2319 |
| Izrael | 8349 | 2323 |
| Jaros�aw | 8351 | 2472 |
| Jezioro_Żarnowieckie | 8352 | 2731 |
| Joannici | 8353 | 2638 |
| John_Kennedy | 8354 | 2527 |
| K2 | 8355 | 3083 |
| Kana�_Panamski | 8356 | 3197 |
| Karol_Darwin | 8357 | 2846 |
| Kazimierz_III_Wielki | 8358 | 3245 |
| Komórka | 8359 | 2839 |
| Kongres_Wiede�ski | 8360 | 2974 |
| Konstytucja_3_Maja | 8361 | 3056 |
| Kraków | 8363 | 2968 |
| Litwa | 8364 | 3296 |
| Ludwik_Zamenhof | 8365 | 3347 |
| Marek_Kota�ski | 8366 | 3812 |
| Miasto | 8368 | 3721 |
| Michael_Faraday | 8369 | 3787 |
| Miko�aj_Kopernik | 8370 | 3813 |
| Mit | 8371 | 3728 |
| Mitochondrium | 8372 | 3599 |
| Mors | 8373 | 3575 |
| My_Pierwsza_Brygada | 8374 | 3827 |
| NATO | 8375 | 4060 |
| Neil_Armstrong | 8376 | 4113 |
| Niemcy | 8377 | 4027 |
| Nizina_Podlaska | 8378 | 4107 |
| Organellum | 8379 | 4227 |
| Owady | 8380 | 4415 |
| Palestyna | 8381 | 4558 |
| Peklenc | 8382 | 4811 |
| Politechnika_Warszawska | 8383 | 4524 |
| Polska | 8384 | 4455 |
| Polskie_Transatlantyckie_Towarzystwo_Okr�towe | 8385 | 4980 |
| Prawos�awie | 8386 | 4695 |
| Przemys� | 8387 | 4706 |
| Puszcza_Knyszy�ska | 8388 | 4825 |
| Rodezja_Po�udniowa | 8389 | 5366 |
| Rosja | 8390 | 5170 |
| Rozmnażanie | 8391 | 5241 |
| Ro�iny | 8392 | 5417 |
| Rybosom | 8393 | 5173 |
| Rybozym | 8394 | 5186 |
| Ssaki | 8397 | 5670 |
| Stanis�aw_August_Poniatowski | 8398 | 5788 |
| Stanis�aw_Kasznica | 8399 | 5949 |
| Stawonogi | 8400 | 5545 |
| Systematyka | 8402 | 5535 |
| Szimon_Peres | 8403 | 5993 |
| S�owianie | 8404 | 5777 |
| Tatry_Niżne | 8405 | 6132 |
| Tkanka | 8406 | 6356 |
| Uk�ad_SI | 8407 | 6424 |
| Uk�ad_Warszawski | 8409 | 6446 |
| Uniwersytet_Jagiello�ski | 8410 | 6482 |
| Uniwersytet_Wroc�awski | 8411 | 6458 |
| Vision | 8412 | 6543 |
| Volkssturm | 8413 | 6518 |
| Wielkie_Ksi�stwo_Litewskie | 8414 | 7000 |
| Wilno | 8416 | 6733 |
| Wirusy | 8417 | 6705 |
| Wroc�aw | 8418 | 6755 |
| Wszech�iat | 8419 | 6798 |
| W�adys�aw_II_Jagie��o | 8420 | 6888 |
| W�ochy | 8421 | 6648 |
| ZSRR | 8422 | 7106 |
| Zwierz�ta | 8423 | 7082 |
| Zygmunt_I_Stary | 8424 | 7146 |
| �limaki | 8425 | 7362 |
| �l�sk | 8426 | 8292 |
| Meksyk | 9574 | 8367 |
+------------------------------------------------+--------+--------+
114 rows in set (1.27 sec)
Why is it so ?