mysql:wikiadmin@db63 [enwiki]> SELECT ar_rev_id, ar_namespace, ar_title, ar_timestamp, ar_user_text, user_name FROM archive, user WHERE ar_user_text <> user_name AND ar_user = user_id AND user_id > 0 LIMIT 50; +-----------+--------------+------------------------------------------+----------------+--------------+---------------------------------+ | ar_rev_id | ar_namespace | ar_title | ar_timestamp | ar_user_text | user_name | +-----------+--------------+------------------------------------------+----------------+--------------+---------------------------------+ | NULL | 0 | The_Many_Adventures_of_Tintin | 20040608114516 | ContiE | Conti | | NULL | 0 | The_Living_End | 20040609091525 | Ambi | Vanished user 5zariu3jisj0j4irj | | NULL | 0 | Dick_Cavett | 20040530071852 | AndyL | Formeruser-81 | | NULL | 14 | Subculture | 20040609215929 | ContiE | Conti | | NULL | 14 | Subculture | 20040609215524 | ContiE | Conti | | NULL | 0 | Alexey_Kosygin | 20040420052718 | AndyL | Formeruser-81 | | NULL | 0 | Alexey_Kosygin | 20040420053438 | AndyL | Formeruser-81 | | NULL | 0 | Alexey_Kosygin | 20040420052743 | AndyL | Formeruser-81 | | NULL | 0 | Brian_Alkire | 20040604015238 | Joy Stovall | Joyous! | | NULL | 0 | List_of_bohemians | 20040403182635 | Jeandré | Jeandré du Toit | | NULL | 3 | GrazingshipIV | 20040507083642 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040507082134 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040507074857 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040507072600 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040505080553 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040504222304 | Snowspinner | Phil Sandifer | | NULL | 3 | GrazingshipIV | 20040501084545 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040430232716 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040424174621 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040424173705 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040424050136 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040423043522 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040423043503 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040423021824 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040421160551 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040420184002 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040420183809 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040414025603 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040413211114 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040413211037 | AndyL | Formeruser-81 | | NULL | 3 | GrazingshipIV | 20040402120708 | Wikiwizzy | Wizzy | | NULL | 3 | GrazingshipIV | 20040401204935 | Wikiwizzy | Wizzy | | NULL | 3 | GrazingshipIV | 20040401084345 | Wikiwizzy | Wizzy | | NULL | 0 | Personal_income | 20040615050819 | Joy Stovall | Joyous! | | NULL | 0 | The_Philadelphia_Experiment_(movie)/Temp | 20040614151430 | ContiE | Conti | | NULL | 0 | Nuevo_Rico | 20040611042426 | Joy Stovall | Joyous! | | NULL | 0 | A._E._van_Vogt | 20040619043436 | Ambi | Vanished user 5zariu3jisj0j4irj | | NULL | 0 | N.C._Wyeth | 20040619052622 | Ambi | Vanished user 5zariu3jisj0j4irj | | NULL | 0 | Mantrap | 20040609221407 | Joy Stovall | Joyous! | | NULL | 1 | UTD | 20040326015209 | Cluster | PhilipMW | | NULL | 0 | Seminal_work | 20040419161934 | Snowspinner | Phil Sandifer | | NULL | 0 | Syntax_diagram | 20040622050222 | Cluster | PhilipMW | | NULL | 0 | Greeny | 20040622051418 | Cluster | PhilipMW | | NULL | 0 | Herbert_Murray | 20040320041141 | Andylehrer | Formeruser-83 | | NULL | 0 | Maritime_Rights | 20040327171754 | Andylehrer | Formeruser-83 | | NULL | 0 | Lynda_Haverstock | 20040413213028 | AndyL | Formeruser-81 | | NULL | 0 | Zionist_Congress | 20040414035610 | AndyL | Formeruser-81 | | NULL | 0 | Bubnov | 20040415121106 | AndyL | Formeruser-81 | | NULL | 0 | Sokolnikov | 20040415121222 | AndyL | Formeruser-81 | | NULL | 0 | Moshe_Hess | 20040416055326 | AndyL | Formeruser-81 | +-----------+--------------+------------------------------------------+----------------+--------------+---------------------------------+ 50 rows in set (0.02 sec)