Lately, wikireplicas haven't been able to keep up with replication due to high load.
Description
Description
Details
Details
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | LSobanski | T119601 Certain tools users create multiple long running queries that take all memory and/or CPU from labsdb hosts, slowing it down and potentially crashing (tracking) | |||
| Resolved | jcrespo | T194343 quentinv57-tools/tools/globalcontribs.php generates slow/complex SQL queries which impact server performance | |||
| Declined | None | T198320 The SUL Info tool doesn't work |
Event Timeline
Comment Actions
Change 432344 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] wikireplicas: Disable binary log, increase transaction log and buffer
Comment Actions
Change 432344 merged by Jcrespo:
[operations/puppet@production] wikireplicas: Disable binary log, increase transaction log and buffer
Comment Actions
For what is worth. There was a heavy alter table running on Commons.logging for the last 24-36h which is a pretty big table so that might have contributed to maximize the issue
Comment Actions
Also, I have been deleting rows from logging tables in large wikis and changing values in wb_terms of wikidatawiki. This might contribute to the load but they will go away really soon.
Comment Actions
Change 432556 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Revert parallel replication on labsdb
Comment Actions
Change 432556 merged by Jcrespo:
[operations/puppet@production] mariadb: Revert parallel replication on labsdb
Comment Actions
The changes I made (I also optimized some tables) multiplied by 2x-3x the number of writes the hosts can do, but we do not know yet what is the root cause. The issues doesn't seem to happen on the web replica, so I think it is an increase in CPU usage due to user reads (it started around 3 days ago).
Comment Actions
I found the issue, user s51559 was running multiple concurrent runs of (the query didn't fit in my buffer):
ev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nlwikimedia_p`.`revision_userindex` LEFT JOIN `nlwikimedia_p`.`page` ON `nlwikimedia_p`.`page`.`page_id`=`nlwikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nlwikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nlwikiquote_p`.`revision_userindex` LEFT JOIN `nlwikiquote_p`.`page` ON `nlwikiquote_p`.`page`.`page_id`=`nlwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nlwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nnwikiquote_p`.`revision_userindex` LEFT JOIN `nnwikiquote_p`.`page` ON `nnwikiquote_p`.`page`.`page_id`=`nnwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nnwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nowikibooks_p`.`revision_userindex` LEFT JOIN `nowikibooks_p`.`page` ON `nowikibooks_p`.`page`.`page_id`=`nowikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nowikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nowikimedia_p`.`revision_userindex` LEFT JOIN `nowikimedia_p`.`page` ON `nowikimedia_p`.`page`.`page_id`=`nowikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nowikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nowikiquote_p`.`revision_userindex` LEFT JOIN `nowikiquote_p`.`page` ON `nowikiquote_p`.`page`.`page_id`=`nowikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nowikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ocwikibooks_p`.`revision_userindex` LEFT JOIN `ocwikibooks_p`.`page` ON `ocwikibooks_p`.`page`.`page_id`=`ocwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ocwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `pawikibooks_p`.`revision_userindex` LEFT JOIN `pawikibooks_p`.`page` ON `pawikibooks_p`.`page`.`page_id`=`pawikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='pawikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `plwikibooks_p`.`revision_userindex` LEFT JOIN `plwikibooks_p`.`page` ON `plwikibooks_p`.`page`.`page_id`=`plwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='plwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `plwikimedia_p`.`revision_userindex` LEFT JOIN `plwikimedia_p`.`page` ON `plwikimedia_p`.`page`.`page_id`=`plwikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='plwikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `plwikiquote_p`.`revision_userindex` LEFT JOIN `plwikiquote_p`.`page` ON `plwikiquote_p`.`page`.`page_id`=`plwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='plwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ptwikibooks_p`.`revision_userindex` LEFT JOIN `ptwikibooks_p`.`page` ON `ptwikibooks_p`.`page`.`page_id`=`ptwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ptwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ptwikimedia_p`.`revision_userindex` LEFT JOIN `ptwikimedia_p`.`page` ON `ptwikimedia_p`.`page`.`page_id`=`ptwikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ptwikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ptwikiquote_p`.`revision_userindex` LEFT JOIN `ptwikiquote_p`.`page` ON `ptwikiquote_p`.`page`.`page_id`=`ptwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ptwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `roa_rupwiki_p`.`revision_userindex` LEFT JOIN `roa_rupwiki_p`.`page` ON `roa_rupwiki_p`.`page`.`page_id`=`roa_rupwiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='roa_rupwiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `rowikibooks_p`.`revision_userindex` LEFT JOIN `rowikibooks_p`.`page` ON `rowikibooks_p`.`page`.`page_id`=`rowikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='rowikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `rowikiquote_p`.`revision_userindex` LEFT JOIN `rowikiquote_p`.`page` ON `rowikiquote_p`.`page`.`page_id`=`rowikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='rowikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `rswikimedia_p`.`revision_userindex` LEFT JOIN `rswikimedia_p`.`page` ON `rswikimedia_p`.`page`.`page_id`=`rswikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='rswikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ruwikibooks_p`.`revision_userindex` LEFT JOIN `ruwikibooks_p`.`page` ON `ruwikibooks_p`.`page`.`page_id`=`ruwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ruwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ruwikimedia_p`.`revision_userindex` LEFT JOIN `ruwikimedia_p`.`page` ON `ruwikimedia_p`.`page`.`page_id`=`ruwikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ruwikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ruwikiquote_p`.`revision_userindex` LEFT JOIN `ruwikiquote_p`.`page` ON `ruwikiquote_p`.`page`.`page_id`=`ruwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ruwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sawikibooks_p`.`revision_userindex` LEFT JOIN `sawikibooks_p`.`page` ON `sawikibooks_p`.`page`.`page_id`=`sawikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sawikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sawikiquote_p`.`revision_userindex` LEFT JOIN `sawikiquote_p`.`page` ON `sawikiquote_p`.`page`.`page_id`=`sawikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sawikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sewikimedia_p`.`revision_userindex` LEFT JOIN `sewikimedia_p`.`page` ON `sewikimedia_p`.`page`.`page_id`=`sewikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sewikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `siwikibooks_p`.`revision_userindex` LEFT JOIN `siwikibooks_p`.`page` ON `siwikibooks_p`.`page`.`page_id`=`siwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='siwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `skwikibooks_p`.`revision_userindex` LEFT JOIN `skwikibooks_p`.`page` ON `skwikibooks_p`.`page`.`page_id`=`skwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='skwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `skwikiquote_p`.`revision_userindex` LEFT JOIN `skwikiquote_p`.`page` ON `skwikiquote_p`.`page`.`page_id`=`skwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='skwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `slwikibooks_p`.`revision_userindex` LEFT JOIN `slwikibooks_p`.`page` ON `slwikibooks_p`.`page`.`page_id`=`slwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='slwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `slwikiquote_p`.`revision_userindex` LEFT JOIN `slwikiquote_p`.`page` ON `slwikiquote_p`.`page`.`page_id`=`slwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='slwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sourceswiki_p`.`revision_userindex` LEFT JOIN `sourceswiki_p`.`page` ON `sourceswiki_p`.`page`.`page_id`=`sourceswiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sourceswiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `specieswiki_p`.`revision_userindex` LEFT JOIN `specieswiki_p`.`page` ON `specieswiki_p`.`page`.`page_id`=`specieswiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='specieswiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sqwikibooks_p`.`revision_userindex` LEFT JOIN `sqwikibooks_p`.`page` ON `sqwikibooks_p`.`page`.`page_id`=`sqwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sqwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sqwikiquote_p`.`revision_userindex` LEFT JOIN `sqwikiquote_p`.`page` ON `sqwikiquote_p`.`page`.`page_id`=`sqwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sqwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `srwikibooks_p`.`revision_userindex` LEFT JOIN `srwikibooks_p`.`page` ON `srwikibooks_p`.`page`.`page_id`=`srwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='srwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `srwikiquote_p`.`revision_userindex` LEFT JOIN `srwikiquote_p`.`page` ON `srwikiquote_p`.`page`.`page_id`=`srwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='srwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `suwikiquote_p`.`revision_userindex` LEFT JOIN `suwikiquote_p`.`page` ON `suwikiquote_p`.`page`.`page_id`=`suwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='suwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `svwikibooks_p`.`revision_userindex` LEFT JOIN `svwikibooks_p`.`page` ON `svwikibooks_p`.`page`.`page_id`=`svwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='svwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `svwikiquote_p`.`revision_userindex` LEFT JOIN `svwikiquote_p`.`page` ON `svwikiquote_p`.`page`.`page_id`=`svwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='svwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tawikibooks_p`.`revision_userindex` LEFT JOIN `tawikibooks_p`.`page` ON `tawikibooks_p`.`page`.`page_id`=`tawikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tawikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tawikiquote_p`.`revision_userindex` LEFT JOIN `tawikiquote_p`.`page` ON `tawikiquote_p`.`page`.`page_id`=`tawikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tawikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tewikibooks_p`.`revision_userindex` LEFT JOIN `tewikibooks_p`.`page` ON `tewikibooks_p`.`page`.`page_id`=`tewikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tewikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tewikiquote_p`.`revision_userindex` LEFT JOIN `tewikiquote_p`.`page` ON `tewikiquote_p`.`page`.`page_id`=`tewikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tewikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tgwikibooks_p`.`revision_userindex` LEFT JOIN `tgwikibooks_p`.`page` ON `tgwikibooks_p`.`page`.`page_id`=`tgwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tgwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `thwikibooks_p`.`revision_userindex` LEFT JOIN `thwikibooks_p`.`page` ON `thwikibooks_p`.`page`.`page_id`=`thwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='thwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `thwikiquote_p`.`revision_userindex` LEFT JOIN `thwikiquote_p`.`page` ON `thwikiquote_p`.`page`.`page_id`=`thwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='thwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tlwikibooks_p`.`revision_userindex` LEFT JOIN `tlwikibooks_p`.`page` ON `tlwikibooks_p`.`page`.`page_id`=`tlwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tlwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `trwikibooks_p`.`revision_userindex` LEFT JOIN `trwikibooks_p`.`page` ON `trwikibooks_p`.`page`.`page_id`=`trwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='trwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `trwikimedia_p`.`revision_userindex` LEFT JOIN `trwikimedia_p`.`page` ON `trwikimedia_p`.`page`.`page_id`=`trwikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='trwikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `trwikiquote_p`.`revision_userindex` LEFT JOIN `trwikiquote_p`.`page` ON `trwikiquote_p`.`page`.`page_id`=`trwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='trwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ttwikibooks_p`.`revision_userindex` LEFT JOIN `ttwikibooks_p`.`page` ON `ttwikibooks_p`.`page`.`page_id`=`ttwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ttwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `uawikimedia_p`.`revision_userindex` LEFT JOIN `uawikimedia_p`.`page` ON `uawikimedia_p`.`page`.`page_id`=`uawikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='uawikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ukwikibooks_p`.`revision_userindex` LEFT JOIN `ukwikibooks_p`.`page` ON `ukwikibooks_p`.`page`.`page_id`=`ukwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ukwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ukwikiquote_p`.`revision_userindex` LEFT JOIN `ukwikiquote_p`.`page` ON `ukwikiquote_p`.`page`.`page_id`=`ukwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ukwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `urwikibooks_p`.`revision_userindex` LEFT JOIN `urwikibooks_p`.`page` ON `urwikibooks_p`.`page`.`page_id`=`urwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='urwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `urwikiquote_p`.`revision_userindex` LEFT JOIN `urwikiquote_p`.`page` ON `urwikiquote_p`.`page`.`page_id`=`urwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='urwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `uzwikiquote_p`.`revision_userindex` LEFT JOIN `uzwikiquote_p`.`page` ON `uzwikiquote_p`.`page`.`page_id`=`uzwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='uzwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `viwikibooks_p`.`revision_userindex` LEFT JOIN `viwikibooks_p`.`page` ON `viwikibooks_p`.`page`.`page_id`=`viwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='viwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `viwikiquote_p`.`revision_userindex` LEFT JOIN `viwikiquote_p`.`page` ON `viwikiquote_p`.`page`.`page_id`=`viwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='viwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `wbwikimedia_p`.`revision_userindex` LEFT JOIN `wbwikimedia_p`.`page` ON `wbwikimedia_p`.`page`.`page_id`=`wbwikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='wbwikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `wowikiquote_p`.`revision_userindex` LEFT JOIN `wowikiquote_p`.`page` ON `wowikiquote_p`.`page`.`page_id`=`wowikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='wowikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `zhwikibooks_p`.`revision_userindex` LEFT JOIN `zhwikibooks_p`.`page` ON `zhwikibooks_p`.`page`.`page_id`=`zhwikibooks_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='zhwikibooks' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `zhwikiquote_p`.`revision_userindex` LEFT JOIN `zhwikiquote_p`.`page` ON `zhwikiquote_p`.`page`.`page_id`=`zhwikiquote_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='zhwikiquote' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `afwiktionary_p`.`revision_userindex` LEFT JOIN `afwiktionary_p`.`page` ON `afwiktionary_p`.`page`.`page_id`=`afwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='afwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `amwiktionary_p`.`revision_userindex` LEFT JOIN `amwiktionary_p`.`page` ON `amwiktionary_p`.`page`.`page_id`=`amwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='amwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `anwiktionary_p`.`revision_userindex` LEFT JOIN `anwiktionary_p`.`page` ON `anwiktionary_p`.`page`.`page_id`=`anwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='anwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `arwikisource_p`.`revision_userindex` LEFT JOIN `arwikisource_p`.`page` ON `arwikisource_p`.`page`.`page_id`=`arwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='arwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `arwiktionary_p`.`revision_userindex` LEFT JOIN `arwiktionary_p`.`page` ON `arwiktionary_p`.`page`.`page_id`=`arwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='arwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `aswikisource_p`.`revision_userindex` LEFT JOIN `aswikisource_p`.`page` ON `aswikisource_p`.`page`.`page_id`=`aswikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='aswikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `aywiktionary_p`.`revision_userindex` LEFT JOIN `aywiktionary_p`.`page` ON `aywiktionary_p`.`page`.`page_id`=`aywiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='aywiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `azwikisource_p`.`revision_userindex` LEFT JOIN `azwikisource_p`.`page` ON `azwikisource_p`.`page`.`page_id`=`azwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='azwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `azwiktionary_p`.`revision_userindex` LEFT JOIN `azwiktionary_p`.`page` ON `azwiktionary_p`.`page`.`page_id`=`azwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='azwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `be_x_oldwiki_p`.`revision_userindex` LEFT JOIN `be_x_oldwiki_p`.`page` ON `be_x_oldwiki_p`.`page`.`page_id`=`be_x_oldwiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='be_x_oldwiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `bewikisource_p`.`revision_userindex` LEFT JOIN `bewikisource_p`.`page` ON `bewikisource_p`.`page`.`page_id`=`bewikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='bewikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `bewiktionary_p`.`revision_userindex` LEFT JOIN `bewiktionary_p`.`page` ON `bewiktionary_p`.`page`.`page_id`=`bewiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='bewiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `bgwikisource_p`.`revision_userindex` LEFT JOIN `bgwikisource_p`.`page` ON `bgwikisource_p`.`page`.`page_id`=`bgwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='bgwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `bnwikisource_p`.`revision_userindex` LEFT JOIN `bnwikisource_p`.`page` ON `bnwikisource_p`.`page`.`page_id`=`bnwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='bnwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `bnwiktionary_p`.`revision_userindex` LEFT JOIN `bnwiktionary_p`.`page` ON `bnwiktionary_p`.`page`.`page_id`=`bnwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='bnwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `brwikisource_p`.`revision_userindex` LEFT JOIN `brwikisource_p`.`page` ON `brwikisource_p`.`page`.`page_id`=`brwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='brwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `brwiktionary_p`.`revision_userindex` LEFT JOIN `brwiktionary_p`.`page` ON `brwiktionary_p`.`page`.`page_id`=`brwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='brwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `bswikisource_p`.`revision_userindex` LEFT JOIN `bswikisource_p`.`page` ON `bswikisource_p`.`page`.`page_id`=`bswikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='bswikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `bswiktionary_p`.`revision_userindex` LEFT JOIN `bswiktionary_p`.`page` ON `bswiktionary_p`.`page`.`page_id`=`bswiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='bswiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `cawikisource_p`.`revision_userindex` LEFT JOIN `cawikisource_p`.`page` ON `cawikisource_p`.`page`.`page_id`=`cawikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='cawikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `cawiktionary_p`.`revision_userindex` LEFT JOIN `cawiktionary_p`.`page` ON `cawiktionary_p`.`page`.`page_id`=`cawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='cawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `cowiktionary_p`.`revision_userindex` LEFT JOIN `cowiktionary_p`.`page` ON `cowiktionary_p`.`page`.`page_id`=`cowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='cowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `cswikisource_p`.`revision_userindex` LEFT JOIN `cswikisource_p`.`page` ON `cswikisource_p`.`page`.`page_id`=`cswikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='cswikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `cswiktionary_p`.`revision_userindex` LEFT JOIN `cswiktionary_p`.`page` ON `cswiktionary_p`.`page`.`page_id`=`cswiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='cswiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `cywikisource_p`.`revision_userindex` LEFT JOIN `cywikisource_p`.`page` ON `cywikisource_p`.`page`.`page_id`=`cywikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='cywikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `cywiktionary_p`.`revision_userindex` LEFT JOIN `cywiktionary_p`.`page` ON `cywiktionary_p`.`page`.`page_id`=`cywiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='cywiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `dawikisource_p`.`revision_userindex` LEFT JOIN `dawikisource_p`.`page` ON `dawikisource_p`.`page`.`page_id`=`dawikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='dawikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `dawiktionary_p`.`revision_userindex` LEFT JOIN `dawiktionary_p`.`page` ON `dawiktionary_p`.`page`.`page_id`=`dawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='dawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `dewikisource_p`.`revision_userindex` LEFT JOIN `dewikisource_p`.`page` ON `dewikisource_p`.`page`.`page_id`=`dewikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='dewikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `dewikivoyage_p`.`revision_userindex` LEFT JOIN `dewikivoyage_p`.`page` ON `dewikivoyage_p`.`page`.`page_id`=`dewikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='dewikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `dewiktionary_p`.`revision_userindex` LEFT JOIN `dewiktionary_p`.`page` ON `dewiktionary_p`.`page`.`page_id`=`dewiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='dewiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `dvwiktionary_p`.`revision_userindex` LEFT JOIN `dvwiktionary_p`.`page` ON `dvwiktionary_p`.`page`.`page_id`=`dvwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='dvwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `elwikisource_p`.`revision_userindex` LEFT JOIN `elwikisource_p`.`page` ON `elwikisource_p`.`page`.`page_id`=`elwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='elwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `elwikivoyage_p`.`revision_userindex` LEFT JOIN `elwikivoyage_p`.`page` ON `elwikivoyage_p`.`page`.`page_id`=`elwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='elwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `elwiktionary_p`.`revision_userindex` LEFT JOIN `elwiktionary_p`.`page` ON `elwiktionary_p`.`page`.`page_id`=`elwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='elwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `enwikisource_p`.`revision_userindex` LEFT JOIN `enwikisource_p`.`page` ON `enwikisource_p`.`page`.`page_id`=`enwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='enwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `enwikivoyage_p`.`revision_userindex` LEFT JOIN `enwikivoyage_p`.`page` ON `enwikivoyage_p`.`page`.`page_id`=`enwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='enwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `eowikisource_p`.`revision_userindex` LEFT JOIN `eowikisource_p`.`page` ON `eowikisource_p`.`page`.`page_id`=`eowikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='eowikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `eowiktionary_p`.`revision_userindex` LEFT JOIN `eowiktionary_p`.`page` ON `eowiktionary_p`.`page`.`page_id`=`eowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='eowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `eswikisource_p`.`revision_userindex` LEFT JOIN `eswikisource_p`.`page` ON `eswikisource_p`.`page`.`page_id`=`eswikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='eswikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `eswikivoyage_p`.`revision_userindex` LEFT JOIN `eswikivoyage_p`.`page` ON `eswikivoyage_p`.`page`.`page_id`=`eswikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='eswikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `eswiktionary_p`.`revision_userindex` LEFT JOIN `eswiktionary_p`.`page` ON `eswiktionary_p`.`page`.`page_id`=`eswiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='eswiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `etwikisource_p`.`revision_userindex` LEFT JOIN `etwikisource_p`.`page` ON `etwikisource_p`.`page`.`page_id`=`etwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='etwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `etwiktionary_p`.`revision_userindex` LEFT JOIN `etwiktionary_p`.`page` ON `etwiktionary_p`.`page`.`page_id`=`etwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='etwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `euwikisource_p`.`revision_userindex` LEFT JOIN `euwikisource_p`.`page` ON `euwikisource_p`.`page`.`page_id`=`euwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='euwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `euwiktionary_p`.`revision_userindex` LEFT JOIN `euwiktionary_p`.`page` ON `euwiktionary_p`.`page`.`page_id`=`euwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='euwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `fawikisource_p`.`revision_userindex` LEFT JOIN `fawikisource_p`.`page` ON `fawikisource_p`.`page`.`page_id`=`fawikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='fawikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `fawikivoyage_p`.`revision_userindex` LEFT JOIN `fawikivoyage_p`.`page` ON `fawikivoyage_p`.`page`.`page_id`=`fawikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='fawikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `fawiktionary_p`.`revision_userindex` LEFT JOIN `fawiktionary_p`.`page` ON `fawiktionary_p`.`page`.`page_id`=`fawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='fawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `fiwikisource_p`.`revision_userindex` LEFT JOIN `fiwikisource_p`.`page` ON `fiwikisource_p`.`page`.`page_id`=`fiwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='fiwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `fiwikivoyage_p`.`revision_userindex` LEFT JOIN `fiwikivoyage_p`.`page` ON `fiwikivoyage_p`.`page`.`page_id`=`fiwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='fiwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `fiwiktionary_p`.`revision_userindex` LEFT JOIN `fiwiktionary_p`.`page` ON `fiwiktionary_p`.`page`.`page_id`=`fiwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='fiwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `fjwiktionary_p`.`revision_userindex` LEFT JOIN `fjwiktionary_p`.`page` ON `fjwiktionary_p`.`page`.`page_id`=`fjwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='fjwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `fowikisource_p`.`revision_userindex` LEFT JOIN `fowikisource_p`.`page` ON `fowikisource_p`.`page`.`page_id`=`fowikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='fowikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `fowiktionary_p`.`revision_userindex` LEFT JOIN `fowiktionary_p`.`page` ON `fowiktionary_p`.`page`.`page_id`=`fowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='fowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `frwikisource_p`.`revision_userindex` LEFT JOIN `frwikisource_p`.`page` ON `frwikisource_p`.`page`.`page_id`=`frwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='frwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `frwikivoyage_p`.`revision_userindex` LEFT JOIN `frwikivoyage_p`.`page` ON `frwikivoyage_p`.`page`.`page_id`=`frwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='frwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `fywiktionary_p`.`revision_userindex` LEFT JOIN `fywiktionary_p`.`page` ON `fywiktionary_p`.`page`.`page_id`=`fywiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='fywiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `gawiktionary_p`.`revision_userindex` LEFT JOIN `gawiktionary_p`.`page` ON `gawiktionary_p`.`page`.`page_id`=`gawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='gawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `gdwiktionary_p`.`revision_userindex` LEFT JOIN `gdwiktionary_p`.`page` ON `gdwiktionary_p`.`page`.`page_id`=`gdwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='gdwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `glwikisource_p`.`revision_userindex` LEFT JOIN `glwikisource_p`.`page` ON `glwikisource_p`.`page`.`page_id`=`glwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='glwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `glwiktionary_p`.`revision_userindex` LEFT JOIN `glwiktionary_p`.`page` ON `glwiktionary_p`.`page`.`page_id`=`glwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='glwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `gnwiktionary_p`.`revision_userindex` LEFT JOIN `gnwiktionary_p`.`page` ON `gnwiktionary_p`.`page`.`page_id`=`gnwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='gnwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `guwikisource_p`.`revision_userindex` LEFT JOIN `guwikisource_p`.`page` ON `guwikisource_p`.`page`.`page_id`=`guwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='guwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `guwiktionary_p`.`revision_userindex` LEFT JOIN `guwiktionary_p`.`page` ON `guwiktionary_p`.`page`.`page_id`=`guwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='guwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `gvwiktionary_p`.`revision_userindex` LEFT JOIN `gvwiktionary_p`.`page` ON `gvwiktionary_p`.`page`.`page_id`=`gvwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='gvwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hawiktionary_p`.`revision_userindex` LEFT JOIN `hawiktionary_p`.`page` ON `hawiktionary_p`.`page`.`page_id`=`hawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hewikisource_p`.`revision_userindex` LEFT JOIN `hewikisource_p`.`page` ON `hewikisource_p`.`page`.`page_id`=`hewikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hewikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hewikivoyage_p`.`revision_userindex` LEFT JOIN `hewikivoyage_p`.`page` ON `hewikivoyage_p`.`page`.`page_id`=`hewikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hewikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hewiktionary_p`.`revision_userindex` LEFT JOIN `hewiktionary_p`.`page` ON `hewiktionary_p`.`page`.`page_id`=`hewiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hewiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hiwikivoyage_p`.`revision_userindex` LEFT JOIN `hiwikivoyage_p`.`page` ON `hiwikivoyage_p`.`page`.`page_id`=`hiwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hiwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hiwiktionary_p`.`revision_userindex` LEFT JOIN `hiwiktionary_p`.`page` ON `hiwiktionary_p`.`page`.`page_id`=`hiwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hiwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hrwikisource_p`.`revision_userindex` LEFT JOIN `hrwikisource_p`.`page` ON `hrwikisource_p`.`page`.`page_id`=`hrwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hrwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hrwiktionary_p`.`revision_userindex` LEFT JOIN `hrwiktionary_p`.`page` ON `hrwiktionary_p`.`page`.`page_id`=`hrwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hrwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `huwikisource_p`.`revision_userindex` LEFT JOIN `huwikisource_p`.`page` ON `huwikisource_p`.`page`.`page_id`=`huwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='huwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `huwiktionary_p`.`revision_userindex` LEFT JOIN `huwiktionary_p`.`page` ON `huwiktionary_p`.`page`.`page_id`=`huwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='huwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hywikisource_p`.`revision_userindex` LEFT JOIN `hywikisource_p`.`page` ON `hywikisource_p`.`page`.`page_id`=`hywikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hywikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hywiktionary_p`.`revision_userindex` LEFT JOIN `hywiktionary_p`.`page` ON `hywiktionary_p`.`page`.`page_id`=`hywiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hywiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `iawiktionary_p`.`revision_userindex` LEFT JOIN `iawiktionary_p`.`page` ON `iawiktionary_p`.`page`.`page_id`=`iawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='iawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `idwikisource_p`.`revision_userindex` LEFT JOIN `idwikisource_p`.`page` ON `idwikisource_p`.`page`.`page_id`=`idwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='idwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `idwiktionary_p`.`revision_userindex` LEFT JOIN `idwiktionary_p`.`page` ON `idwiktionary_p`.`page`.`page_id`=`idwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='idwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `iewiktionary_p`.`revision_userindex` LEFT JOIN `iewiktionary_p`.`page` ON `iewiktionary_p`.`page`.`page_id`=`iewiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='iewiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `iowiktionary_p`.`revision_userindex` LEFT JOIN `iowiktionary_p`.`page` ON `iowiktionary_p`.`page`.`page_id`=`iowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='iowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `iswikisource_p`.`revision_userindex` LEFT JOIN `iswikisource_p`.`page` ON `iswikisource_p`.`page`.`page_id`=`iswikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='iswikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `iswiktionary_p`.`revision_userindex` LEFT JOIN `iswiktionary_p`.`page` ON `iswiktionary_p`.`page`.`page_id`=`iswiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='iswiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `itwikisource_p`.`revision_userindex` LEFT JOIN `itwikisource_p`.`page` ON `itwikisource_p`.`page`.`page_id`=`itwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='itwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `itwikivoyage_p`.`revision_userindex` LEFT JOIN `itwikivoyage_p`.`page` ON `itwikivoyage_p`.`page`.`page_id`=`itwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='itwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `itwiktionary_p`.`revision_userindex` LEFT JOIN `itwiktionary_p`.`page` ON `itwiktionary_p`.`page`.`page_id`=`itwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='itwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `iuwiktionary_p`.`revision_userindex` LEFT JOIN `iuwiktionary_p`.`page` ON `iuwiktionary_p`.`page`.`page_id`=`iuwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='iuwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `jawikisource_p`.`revision_userindex` LEFT JOIN `jawikisource_p`.`page` ON `jawikisource_p`.`page`.`page_id`=`jawikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='jawikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `jawiktionary_p`.`revision_userindex` LEFT JOIN `jawiktionary_p`.`page` ON `jawiktionary_p`.`page`.`page_id`=`jawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='jawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `jvwiktionary_p`.`revision_userindex` LEFT JOIN `jvwiktionary_p`.`page` ON `jvwiktionary_p`.`page`.`page_id`=`jvwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='jvwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `kawiktionary_p`.`revision_userindex` LEFT JOIN `kawiktionary_p`.`page` ON `kawiktionary_p`.`page`.`page_id`=`kawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='kawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `kkwiktionary_p`.`revision_userindex` LEFT JOIN `kkwiktionary_p`.`page` ON `kkwiktionary_p`.`page`.`page_id`=`kkwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='kkwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `klwiktionary_p`.`revision_userindex` LEFT JOIN `klwiktionary_p`.`page` ON `klwiktionary_p`.`page`.`page_id`=`klwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='klwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `kmwiktionary_p`.`revision_userindex` LEFT JOIN `kmwiktionary_p`.`page` ON `kmwiktionary_p`.`page`.`page_id`=`kmwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='kmwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `knwikisource_p`.`revision_userindex` LEFT JOIN `knwikisource_p`.`page` ON `knwikisource_p`.`page`.`page_id`=`knwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='knwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `knwiktionary_p`.`revision_userindex` LEFT JOIN `knwiktionary_p`.`page` ON `knwiktionary_p`.`page`.`page_id`=`knwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='knwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `kowikisource_p`.`revision_userindex` LEFT JOIN `kowikisource_p`.`page` ON `kowikisource_p`.`page`.`page_id`=`kowikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='kowikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `kowiktionary_p`.`revision_userindex` LEFT JOIN `kowiktionary_p`.`page` ON `kowiktionary_p`.`page`.`page_id`=`kowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='kowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `kswiktionary_p`.`revision_userindex` LEFT JOIN `kswiktionary_p`.`page` ON `kswiktionary_p`.`page`.`page_id`=`kswiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='kswiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `kuwiktionary_p`.`revision_userindex` LEFT JOIN `kuwiktionary_p`.`page` ON `kuwiktionary_p`.`page`.`page_id`=`kuwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='kuwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `kwwiktionary_p`.`revision_userindex` LEFT JOIN `kwwiktionary_p`.`page` ON `kwwiktionary_p`.`page`.`page_id`=`kwwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='kwwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `kywiktionary_p`.`revision_userindex` LEFT JOIN `kywiktionary_p`.`page` ON `kywiktionary_p`.`page`.`page_id`=`kywiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='kywiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `lawikisource_p`.`revision_userindex` LEFT JOIN `lawikisource_p`.`page` ON `lawikisource_p`.`page`.`page_id`=`lawikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='lawikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `lawiktionary_p`.`revision_userindex` LEFT JOIN `lawiktionary_p`.`page` ON `lawiktionary_p`.`page`.`page_id`=`lawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='lawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `lbwiktionary_p`.`revision_userindex` LEFT JOIN `lbwiktionary_p`.`page` ON `lbwiktionary_p`.`page`.`page_id`=`lbwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='lbwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `liwikisource_p`.`revision_userindex` LEFT JOIN `liwikisource_p`.`page` ON `liwikisource_p`.`page`.`page_id`=`liwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='liwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `liwiktionary_p`.`revision_userindex` LEFT JOIN `liwiktionary_p`.`page` ON `liwiktionary_p`.`page`.`page_id`=`liwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='liwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `lnwiktionary_p`.`revision_userindex` LEFT JOIN `lnwiktionary_p`.`page` ON `lnwiktionary_p`.`page`.`page_id`=`lnwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='lnwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `lowiktionary_p`.`revision_userindex` LEFT JOIN `lowiktionary_p`.`page` ON `lowiktionary_p`.`page`.`page_id`=`lowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='lowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ltwikisource_p`.`revision_userindex` LEFT JOIN `ltwikisource_p`.`page` ON `ltwikisource_p`.`page`.`page_id`=`ltwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ltwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ltwiktionary_p`.`revision_userindex` LEFT JOIN `ltwiktionary_p`.`page` ON `ltwiktionary_p`.`page`.`page_id`=`ltwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ltwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `lvwiktionary_p`.`revision_userindex` LEFT JOIN `lvwiktionary_p`.`page` ON `lvwiktionary_p`.`page`.`page_id`=`lvwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='lvwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `maiwikimedia_p`.`revision_userindex` LEFT JOIN `maiwikimedia_p`.`page` ON `maiwikimedia_p`.`page`.`page_id`=`maiwikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='maiwikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mgwiktionary_p`.`revision_userindex` LEFT JOIN `mgwiktionary_p`.`page` ON `mgwiktionary_p`.`page`.`page_id`=`mgwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mgwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `miwiktionary_p`.`revision_userindex` LEFT JOIN `miwiktionary_p`.`page` ON `miwiktionary_p`.`page`.`page_id`=`miwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='miwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mkwikisource_p`.`revision_userindex` LEFT JOIN `mkwikisource_p`.`page` ON `mkwikisource_p`.`page`.`page_id`=`mkwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mkwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mkwiktionary_p`.`revision_userindex` LEFT JOIN `mkwiktionary_p`.`page` ON `mkwiktionary_p`.`page`.`page_id`=`mkwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mkwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mlwikisource_p`.`revision_userindex` LEFT JOIN `mlwikisource_p`.`page` ON `mlwikisource_p`.`page`.`page_id`=`mlwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mlwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mlwiktionary_p`.`revision_userindex` LEFT JOIN `mlwiktionary_p`.`page` ON `mlwiktionary_p`.`page`.`page_id`=`mlwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mlwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mnwiktionary_p`.`revision_userindex` LEFT JOIN `mnwiktionary_p`.`page` ON `mnwiktionary_p`.`page`.`page_id`=`mnwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mnwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mrwikisource_p`.`revision_userindex` LEFT JOIN `mrwikisource_p`.`page` ON `mrwikisource_p`.`page`.`page_id`=`mrwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mrwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mrwiktionary_p`.`revision_userindex` LEFT JOIN `mrwiktionary_p`.`page` ON `mrwiktionary_p`.`page`.`page_id`=`mrwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mrwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mswiktionary_p`.`revision_userindex` LEFT JOIN `mswiktionary_p`.`page` ON `mswiktionary_p`.`page`.`page_id`=`mswiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mswiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mtwiktionary_p`.`revision_userindex` LEFT JOIN `mtwiktionary_p`.`page` ON `mtwiktionary_p`.`page`.`page_id`=`mtwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mtwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mywiktionary_p`.`revision_userindex` LEFT JOIN `mywiktionary_p`.`page` ON `mywiktionary_p`.`page`.`page_id`=`mywiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mywiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nawiktionary_p`.`revision_userindex` LEFT JOIN `nawiktionary_p`.`page` ON `nawiktionary_p`.`page`.`page_id`=`nawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `newiktionary_p`.`revision_userindex` LEFT JOIN `newiktionary_p`.`page` ON `newiktionary_p`.`page`.`page_id`=`newiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='newiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nlwikisource_p`.`revision_userindex` LEFT JOIN `nlwikisource_p`.`page` ON `nlwikisource_p`.`page`.`page_id`=`nlwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nlwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nlwikivoyage_p`.`revision_userindex` LEFT JOIN `nlwikivoyage_p`.`page` ON `nlwikivoyage_p`.`page`.`page_id`=`nlwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nlwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nlwiktionary_p`.`revision_userindex` LEFT JOIN `nlwiktionary_p`.`page` ON `nlwiktionary_p`.`page`.`page_id`=`nlwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nlwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nnwiktionary_p`.`revision_userindex` LEFT JOIN `nnwiktionary_p`.`page` ON `nnwiktionary_p`.`page`.`page_id`=`nnwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nnwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nowikisource_p`.`revision_userindex` LEFT JOIN `nowikisource_p`.`page` ON `nowikisource_p`.`page`.`page_id`=`nowikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nowikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nowiktionary_p`.`revision_userindex` LEFT JOIN `nowiktionary_p`.`page` ON `nowiktionary_p`.`page`.`page_id`=`nowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nycwikimedia_p`.`revision_userindex` LEFT JOIN `nycwikimedia_p`.`page` ON `nycwikimedia_p`.`page`.`page_id`=`nycwikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nycwikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ocwiktionary_p`.`revision_userindex` LEFT JOIN `ocwiktionary_p`.`page` ON `ocwiktionary_p`.`page`.`page_id`=`ocwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ocwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `omwiktionary_p`.`revision_userindex` LEFT JOIN `omwiktionary_p`.`page` ON `omwiktionary_p`.`page`.`page_id`=`omwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='omwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `orwikisource_p`.`revision_userindex` LEFT JOIN `orwikisource_p`.`page` ON `orwikisource_p`.`page`.`page_id`=`orwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='orwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `orwiktionary_p`.`revision_userindex` LEFT JOIN `orwiktionary_p`.`page` ON `orwiktionary_p`.`page`.`page_id`=`orwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='orwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `outreachwiki_p`.`revision_userindex` LEFT JOIN `outreachwiki_p`.`page` ON `outreachwiki_p`.`page`.`page_id`=`outreachwiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='outreachwiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `pawikisource_p`.`revision_userindex` LEFT JOIN `pawikisource_p`.`page` ON `pawikisource_p`.`page`.`page_id`=`pawikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='pawikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `pawiktionary_p`.`revision_userindex` LEFT JOIN `pawiktionary_p`.`page` ON `pawiktionary_p`.`page`.`page_id`=`pawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='pawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `plwikisource_p`.`revision_userindex` LEFT JOIN `plwikisource_p`.`page` ON `plwikisource_p`.`page`.`page_id`=`plwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='plwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `plwikivoyage_p`.`revision_userindex` LEFT JOIN `plwikivoyage_p`.`page` ON `plwikivoyage_p`.`page`.`page_id`=`plwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='plwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `plwiktionary_p`.`revision_userindex` LEFT JOIN `plwiktionary_p`.`page` ON `plwiktionary_p`.`page`.`page_id`=`plwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='plwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `pswiktionary_p`.`revision_userindex` LEFT JOIN `pswiktionary_p`.`page` ON `pswiktionary_p`.`page`.`page_id`=`pswiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='pswiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ptwikisource_p`.`revision_userindex` LEFT JOIN `ptwikisource_p`.`page` ON `ptwikisource_p`.`page`.`page_id`=`ptwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ptwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ptwikivoyage_p`.`revision_userindex` LEFT JOIN `ptwikivoyage_p`.`page` ON `ptwikivoyage_p`.`page`.`page_id`=`ptwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ptwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ptwiktionary_p`.`revision_userindex` LEFT JOIN `ptwiktionary_p`.`page` ON `ptwiktionary_p`.`page`.`page_id`=`ptwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ptwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `quwiktionary_p`.`revision_userindex` LEFT JOIN `quwiktionary_p`.`page` ON `quwiktionary_p`.`page`.`page_id`=`quwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='quwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `roa_tarawiki_p`.`revision_userindex` LEFT JOIN `roa_tarawiki_p`.`page` ON `roa_tarawiki_p`.`page`.`page_id`=`roa_tarawiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='roa_tarawiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `rowikisource_p`.`revision_userindex` LEFT JOIN `rowikisource_p`.`page` ON `rowikisource_p`.`page`.`page_id`=`rowikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='rowikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `rowikivoyage_p`.`revision_userindex` LEFT JOIN `rowikivoyage_p`.`page` ON `rowikivoyage_p`.`page`.`page_id`=`rowikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='rowikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `rowiktionary_p`.`revision_userindex` LEFT JOIN `rowiktionary_p`.`page` ON `rowiktionary_p`.`page`.`page_id`=`rowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='rowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ruwikisource_p`.`revision_userindex` LEFT JOIN `ruwikisource_p`.`page` ON `ruwikisource_p`.`page`.`page_id`=`ruwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ruwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ruwikivoyage_p`.`revision_userindex` LEFT JOIN `ruwikivoyage_p`.`page` ON `ruwikivoyage_p`.`page`.`page_id`=`ruwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ruwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ruwiktionary_p`.`revision_userindex` LEFT JOIN `ruwiktionary_p`.`page` ON `ruwiktionary_p`.`page`.`page_id`=`ruwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ruwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `rwwiktionary_p`.`revision_userindex` LEFT JOIN `rwwiktionary_p`.`page` ON `rwwiktionary_p`.`page`.`page_id`=`rwwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='rwwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sawikisource_p`.`revision_userindex` LEFT JOIN `sawikisource_p`.`page` ON `sawikisource_p`.`page`.`page_id`=`sawikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sawikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sawiktionary_p`.`revision_userindex` LEFT JOIN `sawiktionary_p`.`page` ON `sawiktionary_p`.`page`.`page_id`=`sawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sdwiktionary_p`.`revision_userindex` LEFT JOIN `sdwiktionary_p`.`page` ON `sdwiktionary_p`.`page`.`page_id`=`sdwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sdwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sgwiktionary_p`.`revision_userindex` LEFT JOIN `sgwiktionary_p`.`page` ON `sgwiktionary_p`.`page`.`page_id`=`sgwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sgwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `shwiktionary_p`.`revision_userindex` LEFT JOIN `shwiktionary_p`.`page` ON `shwiktionary_p`.`page`.`page_id`=`shwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='shwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `siwiktionary_p`.`revision_userindex` LEFT JOIN `siwiktionary_p`.`page` ON `siwiktionary_p`.`page`.`page_id`=`siwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='siwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `skwikisource_p`.`revision_userindex` LEFT JOIN `skwikisource_p`.`page` ON `skwikisource_p`.`page`.`page_id`=`skwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='skwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `skwiktionary_p`.`revision_userindex` LEFT JOIN `skwiktionary_p`.`page` ON `skwiktionary_p`.`page`.`page_id`=`skwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='skwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `slwikisource_p`.`revision_userindex` LEFT JOIN `slwikisource_p`.`page` ON `slwikisource_p`.`page`.`page_id`=`slwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='slwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `slwiktionary_p`.`revision_userindex` LEFT JOIN `slwiktionary_p`.`page` ON `slwiktionary_p`.`page`.`page_id`=`slwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='slwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `smwiktionary_p`.`revision_userindex` LEFT JOIN `smwiktionary_p`.`page` ON `smwiktionary_p`.`page`.`page_id`=`smwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='smwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sowiktionary_p`.`revision_userindex` LEFT JOIN `sowiktionary_p`.`page` ON `sowiktionary_p`.`page`.`page_id`=`sowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sqwiktionary_p`.`revision_userindex` LEFT JOIN `sqwiktionary_p`.`page` ON `sqwiktionary_p`.`page`.`page_id`=`sqwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sqwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `srwikisource_p`.`revision_userindex` LEFT JOIN `srwikisource_p`.`page` ON `srwikisource_p`.`page`.`page_id`=`srwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='srwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `srwiktionary_p`.`revision_userindex` LEFT JOIN `srwiktionary_p`.`page` ON `srwiktionary_p`.`page`.`page_id`=`srwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='srwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sswiktionary_p`.`revision_userindex` LEFT JOIN `sswiktionary_p`.`page` ON `sswiktionary_p`.`page`.`page_id`=`sswiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sswiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `stwiktionary_p`.`revision_userindex` LEFT JOIN `stwiktionary_p`.`page` ON `stwiktionary_p`.`page`.`page_id`=`stwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='stwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `suwiktionary_p`.`revision_userindex` LEFT JOIN `suwiktionary_p`.`page` ON `suwiktionary_p`.`page`.`page_id`=`suwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='suwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `svwikisource_p`.`revision_userindex` LEFT JOIN `svwikisource_p`.`page` ON `svwikisource_p`.`page`.`page_id`=`svwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='svwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `svwikivoyage_p`.`revision_userindex` LEFT JOIN `svwikivoyage_p`.`page` ON `svwikivoyage_p`.`page`.`page_id`=`svwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='svwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `svwiktionary_p`.`revision_userindex` LEFT JOIN `svwiktionary_p`.`page` ON `svwiktionary_p`.`page`.`page_id`=`svwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='svwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `swwiktionary_p`.`revision_userindex` LEFT JOIN `swwiktionary_p`.`page` ON `swwiktionary_p`.`page`.`page_id`=`swwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='swwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tawikisource_p`.`revision_userindex` LEFT JOIN `tawikisource_p`.`page` ON `tawikisource_p`.`page`.`page_id`=`tawikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tawikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tawiktionary_p`.`revision_userindex` LEFT JOIN `tawiktionary_p`.`page` ON `tawiktionary_p`.`page`.`page_id`=`tawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tewikisource_p`.`revision_userindex` LEFT JOIN `tewikisource_p`.`page` ON `tewikisource_p`.`page`.`page_id`=`tewikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tewikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tewiktionary_p`.`revision_userindex` LEFT JOIN `tewiktionary_p`.`page` ON `tewiktionary_p`.`page`.`page_id`=`tewiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tewiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tgwiktionary_p`.`revision_userindex` LEFT JOIN `tgwiktionary_p`.`page` ON `tgwiktionary_p`.`page`.`page_id`=`tgwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tgwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `thwikisource_p`.`revision_userindex` LEFT JOIN `thwikisource_p`.`page` ON `thwikisource_p`.`page`.`page_id`=`thwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='thwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `thwiktionary_p`.`revision_userindex` LEFT JOIN `thwiktionary_p`.`page` ON `thwiktionary_p`.`page`.`page_id`=`thwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='thwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tiwiktionary_p`.`revision_userindex` LEFT JOIN `tiwiktionary_p`.`page` ON `tiwiktionary_p`.`page`.`page_id`=`tiwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tiwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tkwiktionary_p`.`revision_userindex` LEFT JOIN `tkwiktionary_p`.`page` ON `tkwiktionary_p`.`page`.`page_id`=`tkwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tkwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tlwiktionary_p`.`revision_userindex` LEFT JOIN `tlwiktionary_p`.`page` ON `tlwiktionary_p`.`page`.`page_id`=`tlwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tlwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tnwiktionary_p`.`revision_userindex` LEFT JOIN `tnwiktionary_p`.`page` ON `tnwiktionary_p`.`page`.`page_id`=`tnwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tnwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `trwikisource_p`.`revision_userindex` LEFT JOIN `trwikisource_p`.`page` ON `trwikisource_p`.`page`.`page_id`=`trwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='trwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `trwiktionary_p`.`revision_userindex` LEFT JOIN `trwiktionary_p`.`page` ON `trwiktionary_p`.`page`.`page_id`=`trwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='trwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tswiktionary_p`.`revision_userindex` LEFT JOIN `tswiktionary_p`.`page` ON `tswiktionary_p`.`page`.`page_id`=`tswiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tswiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ttwiktionary_p`.`revision_userindex` LEFT JOIN `ttwiktionary_p`.`page` ON `ttwiktionary_p`.`page`.`page_id`=`ttwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ttwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ugwiktionary_p`.`revision_userindex` LEFT JOIN `ugwiktionary_p`.`page` ON `ugwiktionary_p`.`page`.`page_id`=`ugwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ugwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ukwikisource_p`.`revision_userindex` LEFT JOIN `ukwikisource_p`.`page` ON `ukwikisource_p`.`page`.`page_id`=`ukwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ukwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ukwikivoyage_p`.`revision_userindex` LEFT JOIN `ukwikivoyage_p`.`page` ON `ukwikivoyage_p`.`page`.`page_id`=`ukwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ukwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ukwiktionary_p`.`revision_userindex` LEFT JOIN `ukwiktionary_p`.`page` ON `ukwiktionary_p`.`page`.`page_id`=`ukwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ukwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `urwiktionary_p`.`revision_userindex` LEFT JOIN `urwiktionary_p`.`page` ON `urwiktionary_p`.`page`.`page_id`=`urwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='urwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `uzwiktionary_p`.`revision_userindex` LEFT JOIN `uzwiktionary_p`.`page` ON `uzwiktionary_p`.`page`.`page_id`=`uzwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='uzwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `viwikisource_p`.`revision_userindex` LEFT JOIN `viwikisource_p`.`page` ON `viwikisource_p`.`page`.`page_id`=`viwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='viwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `viwikivoyage_p`.`revision_userindex` LEFT JOIN `viwikivoyage_p`.`page` ON `viwikivoyage_p`.`page`.`page_id`=`viwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='viwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `viwiktionary_p`.`revision_userindex` LEFT JOIN `viwiktionary_p`.`page` ON `viwiktionary_p`.`page`.`page_id`=`viwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='viwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `vowiktionary_p`.`revision_userindex` LEFT JOIN `vowiktionary_p`.`page` ON `vowiktionary_p`.`page`.`page_id`=`vowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='vowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `wawiktionary_p`.`revision_userindex` LEFT JOIN `wawiktionary_p`.`page` ON `wawiktionary_p`.`page`.`page_id`=`wawiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='wawiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `wowiktionary_p`.`revision_userindex` LEFT JOIN `wowiktionary_p`.`page` ON `wowiktionary_p`.`page`.`page_id`=`wowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='wowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `yiwikisource_p`.`revision_userindex` LEFT JOIN `yiwikisource_p`.`page` ON `yiwikisource_p`.`page`.`page_id`=`yiwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='yiwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `yiwiktionary_p`.`revision_userindex` LEFT JOIN `yiwiktionary_p`.`page` ON `yiwiktionary_p`.`page`.`page_id`=`yiwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='yiwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `zhwikisource_p`.`revision_userindex` LEFT JOIN `zhwikisource_p`.`page` ON `zhwikisource_p`.`page`.`page_id`=`zhwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='zhwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `zhwikivoyage_p`.`revision_userindex` LEFT JOIN `zhwikivoyage_p`.`page` ON `zhwikivoyage_p`.`page`.`page_id`=`zhwikivoyage_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='zhwikivoyage' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `zhwiktionary_p`.`revision_userindex` LEFT JOIN `zhwiktionary_p`.`page` ON `zhwiktionary_p`.`page`.`page_id`=`zhwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='zhwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `zuwiktionary_p`.`revision_userindex` LEFT JOIN `zuwiktionary_p`.`page` ON `zuwiktionary_p`.`page`.`page_id`=`zuwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='zuwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `angwiktionary_p`.`revision_userindex` LEFT JOIN `angwiktionary_p`.`page` ON `angwiktionary_p`.`page`.`page_id`=`angwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='angwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `arwikiversity_p`.`revision_userindex` LEFT JOIN `arwikiversity_p`.`page` ON `arwikiversity_p`.`page`.`page_id`=`arwikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='arwikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `astwiktionary_p`.`revision_userindex` LEFT JOIN `astwiktionary_p`.`page` ON `astwiktionary_p`.`page`.`page_id`=`astwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='astwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `chrwiktionary_p`.`revision_userindex` LEFT JOIN `chrwiktionary_p`.`page` ON `chrwiktionary_p`.`page`.`page_id`=`chrwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='chrwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `csbwiktionary_p`.`revision_userindex` LEFT JOIN `csbwiktionary_p`.`page` ON `csbwiktionary_p`.`page`.`page_id`=`csbwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='csbwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `cswikiversity_p`.`revision_userindex` LEFT JOIN `cswikiversity_p`.`page` ON `cswikiversity_p`.`page`.`page_id`=`cswikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='cswikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `dewikiversity_p`.`revision_userindex` LEFT JOIN `dewikiversity_p`.`page` ON `dewikiversity_p`.`page`.`page_id`=`dewikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='dewikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `elwikiversity_p`.`revision_userindex` LEFT JOIN `elwikiversity_p`.`page` ON `elwikiversity_p`.`page`.`page_id`=`elwikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='elwikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `enwikiversity_p`.`revision_userindex` LEFT JOIN `enwikiversity_p`.`page` ON `enwikiversity_p`.`page`.`page_id`=`enwikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='enwikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `eswikiversity_p`.`revision_userindex` LEFT JOIN `eswikiversity_p`.`page` ON `eswikiversity_p`.`page`.`page_id`=`eswikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='eswikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `fiwikiversity_p`.`revision_userindex` LEFT JOIN `fiwikiversity_p`.`page` ON `fiwikiversity_p`.`page`.`page_id`=`fiwikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='fiwikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `frwikiversity_p`.`revision_userindex` LEFT JOIN `frwikiversity_p`.`page` ON `frwikiversity_p`.`page`.`page_id`=`frwikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='frwikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hifwiktionary_p`.`revision_userindex` LEFT JOIN `hifwiktionary_p`.`page` ON `hifwiktionary_p`.`page`.`page_id`=`hifwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hifwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hiwikiversity_p`.`revision_userindex` LEFT JOIN `hiwikiversity_p`.`page` ON `hiwikiversity_p`.`page`.`page_id`=`hiwikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hiwikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `hsbwiktionary_p`.`revision_userindex` LEFT JOIN `hsbwiktionary_p`.`page` ON `hsbwiktionary_p`.`page`.`page_id`=`hsbwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='hsbwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `incubatorwiki_p`.`revision_userindex` LEFT JOIN `incubatorwiki_p`.`page` ON `incubatorwiki_p`.`page`.`page_id`=`incubatorwiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='incubatorwiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `itwikiversity_p`.`revision_userindex` LEFT JOIN `itwikiversity_p`.`page` ON `itwikiversity_p`.`page`.`page_id`=`itwikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='itwikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `jawikiversity_p`.`revision_userindex` LEFT JOIN `jawikiversity_p`.`page` ON `jawikiversity_p`.`page`.`page_id`=`jawikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='jawikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `jbowiktionary_p`.`revision_userindex` LEFT JOIN `jbowiktionary_p`.`page` ON `jbowiktionary_p`.`page`.`page_id`=`jbowiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='jbowiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `kowikiversity_p`.`revision_userindex` LEFT JOIN `kowikiversity_p`.`page` ON `kowikiversity_p`.`page`.`page_id`=`kowikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='kowikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `mediawikiwiki_p`.`revision_userindex` LEFT JOIN `mediawikiwiki_p`.`page` ON `mediawikiwiki_p`.`page`.`page_id`=`mediawikiwiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='mediawikiwiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nahwiktionary_p`.`revision_userindex` LEFT JOIN `nahwiktionary_p`.`page` ON `nahwiktionary_p`.`page`.`page_id`=`nahwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nahwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ndswiktionary_p`.`revision_userindex` LEFT JOIN `ndswiktionary_p`.`page` ON `ndswiktionary_p`.`page`.`page_id`=`ndswiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ndswiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `nostalgiawiki_p`.`revision_userindex` LEFT JOIN `nostalgiawiki_p`.`page` ON `nostalgiawiki_p`.`page`.`page_id`=`nostalgiawiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='nostalgiawiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `pnbwiktionary_p`.`revision_userindex` LEFT JOIN `pnbwiktionary_p`.`page` ON `pnbwiktionary_p`.`page`.`page_id`=`pnbwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='pnbwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ptwikiversity_p`.`revision_userindex` LEFT JOIN `ptwikiversity_p`.`page` ON `ptwikiversity_p`.`page`.`page_id`=`ptwikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ptwikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `romdwikimedia_p`.`revision_userindex` LEFT JOIN `romdwikimedia_p`.`page` ON `romdwikimedia_p`.`page`.`page_id`=`romdwikimedia_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='romdwikimedia' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `ruwikiversity_p`.`revision_userindex` LEFT JOIN `ruwikiversity_p`.`page` ON `ruwikiversity_p`.`page`.`page_id`=`ruwikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='ruwikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `sahwikisource_p`.`revision_userindex` LEFT JOIN `sahwikisource_p`.`page` ON `sahwikisource_p`.`page`.`page_id`=`sahwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='sahwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `scnwiktionary_p`.`revision_userindex` LEFT JOIN `scnwiktionary_p`.`page` ON `scnwiktionary_p`.`page`.`page_id`=`scnwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='scnwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `slwikiversity_p`.`revision_userindex` LEFT JOIN `slwikiversity_p`.`page` ON `slwikiversity_p`.`page`.`page_id`=`slwikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='slwikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `svwikiversity_p`.`revision_userindex` LEFT JOIN `svwikiversity_p`.`page` ON `svwikiversity_p`.`page`.`page_id`=`svwikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='svwikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `tpiwiktionary_p`.`revision_userindex` LEFT JOIN `tpiwiktionary_p`.`page` ON `tpiwiktionary_p`.`page`.`page_id`=`tpiwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='tpiwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `vecwikisource_p`.`revision_userindex` LEFT JOIN `vecwikisource_p`.`page` ON `vecwikisource_p`.`page`.`page_id`=`vecwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='vecwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `vecwiktionary_p`.`revision_userindex` LEFT JOIN `vecwiktionary_p`.`page` ON `vecwiktionary_p`.`page`.`page_id`=`vecwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='vecwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `foundationwiki_p`.`revision_userindex` LEFT JOIN `foundationwiki_p`.`page` ON `foundationwiki_p`.`page`.`page_id`=`foundationwiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='foundationwiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `zh_min_nanwiki_p`.`revision_userindex` LEFT JOIN `zh_min_nanwiki_p`.`page` ON `zh_min_nanwiki_p`.`page`.`page_id`=`zh_min_nanwiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='zh_min_nanwiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `betawikiversity_p`.`revision_userindex` LEFT JOIN `betawikiversity_p`.`page` ON `betawikiversity_p`.`page`.`page_id`=`betawikiversity_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='betawikiversity' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `simplewiktionary_p`.`revision_userindex` LEFT JOIN `simplewiktionary_p`.`page` ON `simplewiktionary_p`.`page`.`page_id`=`simplewiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='simplewiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `testwikidatawiki_p`.`revision_userindex` LEFT JOIN `testwikidatawiki_p`.`page` ON `testwikidatawiki_p`.`page`.`page_id`=`testwikidatawiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='testwikidatawiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `zh_classicalwiki_p`.`revision_userindex` LEFT JOIN `zh_classicalwiki_p`.`page` ON `zh_classicalwiki_p`.`page`.`page_id`=`zh_classicalwiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='zh_classicalwiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `roa_rupwiktionary_p`.`revision_userindex` LEFT JOIN `roa_rupwiktionary_p`.`page` ON `roa_rupwiktionary_p`.`page`.`page_id`=`roa_rupwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='roa_rupwiktionary' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `wikimania2018wiki_p`.`revision_userindex` LEFT JOIN `wikimania2018wiki_p`.`page` ON `wikimania2018wiki_p`.`page`.`page_id`=`wikimania2018wiki_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='wikimania2018wiki' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `zh_min_nanwikisource_p`.`revision_userindex` LEFT JOIN `zh_min_nanwikisource_p`.`page` ON `zh_min_nanwikisource_p`.`page`.`page_id`=`zh_min_nanwikisource_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='zh_min_nanwikisource' WHERE `rev_user_text`='109.91.38.140') UNION (SELECT `dbname`, `rev_comment`,`rev_timestamp`,`rev_minor_edit`,`page_title`,`page_namespace`,`page_is_new`,(`rev_id`=`page_latest`) as page_is_last FROM `zh_min_nanwiktionary_p`.`revision_userindex` LEFT JOIN `zh_min_nanwiktionary_p`.`page` ON `zh_min_nanwiktionary_p`.`page`.`page_id`=`zh_min_nanwiktionary_p`.`revision_userindex`.`rev_page` LEFT JOIN `meta_p`.`wiki` ON `meta_p`.`wiki`.`dbname`='zh_min_nanwiktionary' WHERE `rev_user_text`='109.91.38.140')
Overloading the CPU. This is the difference between the query being run and not:
The valley is when the query is running, reducing writes and reads to 20x less.
I have blocked the user because only 1 query like that can bring down the server to its knees, but I am tempted to suggest a permanent ban, as I think this looks to me similar to a DOS attack by exhausting CPU resources, plus given the disruption caused to the other users (1 week of lagging and other users unable to query properly the servers. CC @bd808 @Cyberpower678 @Jempcorp @MarcoAurelio
Comment Actions
After the ban the servers now have a healty throughput in both user QPS and replication QPS, plus reasonable CPU usage (75% in average, vs 100% on 16 cores).
Comment Actions
That giant query looks like it comes from https://tools.wmflabs.org/quentinv57-tools/tools/globalcontribs.php which is yet another global contribution lookup tool. I'm not sure if this particular variation on this theme offers any features that are not available in https://tools.wmflabs.org/guc/.
Comment Actions
@jcrespo I am not responsible in any way on this issue. I have access to the resource for legacy reasons but I do not nor have ever maintained Quentinv57 tools, which has retired from the wikis some years ago for what is worth.
I think you also wanted to mention @-jem-. @Jemcorp is another user unrelated.
Thank you.
Comment Actions
I think @Cyberpower678 has access to the GitHub repo where the code of this (all?) tools is hosted. I can't quite remember, sorry. As a temporary measure, if the tools are in a bad shape and are causing issues, and absent an active maintenance, we can webservice stop them so nobody can use them in the meanwhile? Thanks.
Comment Actions
Mentioned in SAL (#wikimedia-cloud) [2018-05-12T10:09:05Z] <Hauskatze> tools.quentinv57-tools@tools-bastion-02:~$ webservice stop | T194343
Comment Actions
If anyone wants to take on the tools, I will be more than happy to turn them over to someone with more time than I do.
Comment Actions
Considering T194343#4200608, does it seem like a good idea to redirect globalcontribs.php to guc?
Comment Actions
@zhuyifei1999 Before shutting down the webservice of the tools I did test with them a bit and they all returned fatals, etc. I doubt any of his tools are usable at this point?
Comment Actions
Fatal because of the block (T194343#4200496)? or is the code broken anyhow?
In any case, I would recommend having a redirect to a working tool if the non-working tool is abandoned. Users won't run into 404s if they followed an old link :)
Comment Actions
As per that ticket, looks like it is an abandoned tool so I am going to close this task.
Thanks @MarcoAurelio