Page MenuHomePhabricator

quentinv57-tools/tools/globalcontribs.php generates slow/complex SQL queries which impact server performance
Closed, ResolvedPublic

Description

Lately, wikireplicas haven't been able to keep up with replication due to high load.

Event Timeline

jcrespo created this task.May 10 2018, 7:00 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 10 2018, 7:00 AM

Change 432344 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] wikireplicas: Disable binary log, increase transaction log and buffer

https://gerrit.wikimedia.org/r/432344

Change 432344 merged by Jcrespo:
[operations/puppet@production] wikireplicas: Disable binary log, increase transaction log and buffer

https://gerrit.wikimedia.org/r/432344

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

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.

Change 432556 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Revert parallel replication on labsdb

https://gerrit.wikimedia.org/r/432556

Change 432556 merged by Jcrespo:
[operations/puppet@production] mariadb: Revert parallel replication on labsdb

https://gerrit.wikimedia.org/r/432556

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).

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:

https://grafana.wikimedia.org/dashboard/db/mysql?orgId=1&from=1526047976432&to=1526050699228&var-dc=eqiad%20prometheus%2Fops&var-server=labsdb1010&var-port=9104&panelId=2&fullscreen

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

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).

I found the issue, user s51559 was running multiple concurrent runs of (the query didn't fit in my buffer):

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/.

bd808 renamed this task from Issues with load on wikireplicas to quentinv57-tools/tools/globalcontribs.php generates slow/complex SQL queries which impact server performance.May 11 2018, 4:08 PM

@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.

So I guess this falls under Toolforge-standards-committee now

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.

Mentioned in SAL (#wikimedia-cloud) [2018-05-12T10:09:05Z] <Hauskatze> tools.quentinv57-tools@tools-bastion-02:~$ webservice stop | T194343

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.

Considering T194343#4200608, does it seem like a good idea to redirect globalcontribs.php to guc?

MarcoAurelio added a comment.EditedMay 13 2018, 10:01 AM

@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?

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 :)

Vvjjkkii renamed this task from quentinv57-tools/tools/globalcontribs.php generates slow/complex SQL queries which impact server performance to w8caaaaaaa.Jul 1 2018, 1:10 AM
Vvjjkkii triaged this task as High priority.
Vvjjkkii updated the task description. (Show Details)
Richard0612 renamed this task from w8caaaaaaa to quentinv57-tools/tools/globalcontribs.php generates slow/complex SQL queries which impact server performance.Jul 1 2018, 12:33 PM
Richard0612 raised the priority of this task from High to Needs Triage.
Richard0612 updated the task description. (Show Details)
Marostegui closed this task as Resolved.Dec 20 2018, 12:37 PM
Marostegui assigned this task to jcrespo.

As per that ticket, looks like it is an abandoned tool so I am going to close this task.
Thanks @MarcoAurelio