Alle openbare logboeken
Scoutpedia.nl, dé Scouting wiki
Dit is het gecombineerde logboek. De pagina toont een overzicht van alle uploads, verwijderde items, beveiligde pagina's, geblokkeerde gebruikers en de gewijzigde status van gebruikers. Je kunt ook kiezen voor bepaalde logboeken en filteren op gebruiker en titel van een pagina.
- 6 jun 2019 23:44 Gebruikersaccount Xenjew overleg bijdragen is aangemaakt
Debug data:
[objectcache] MainWANObjectCache using store RedisBagOStuff
Start request GET /Speciaal:Logboeken/Xenjew
IP: 3.22.51.241
HTTP HEADERS:
X-VARNISH: 582105908
ACCEPT-ENCODING: gzip
X-FORWARDED-FOR: 3.22.51.241, 127.0.0.1, 127.0.0.1
USER-AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
ACCEPT: */*
HOST: nl.scoutwiki.org
HTTPS: on
X-FORWARDED-PORT: 443
X-FORWARDED-PROTO: https
X-REAL-IP: 3.22.51.241
CONTENT-LENGTH:
CONTENT-TYPE:
(end headers)[session] SessionManager using store RedisBagOStuff
[localisation] LocalisationCache using store LCStoreCDB
[objectcache] MainObjectStash using store RedisBagOStuff
[session] SessionBackend "n9uujnqv4kj3v1rg60vg386quk94di6p" is unsaved, marking dirty in constructor
[session] SessionBackend "n9uujnqv4kj3v1rg60vg386quk94di6p" save: dataDirty=1 metaDirty=1 forcePersist=0
[cookie] already deleted setcookie: "ss0-scoutwiki_nl_session", "", "1683305088", "/", "", "1", "1", ""
[cookie] already deleted setcookie: "scoutwiki_nl_session", "", "1683305088", "/", "", "1", "1", "None"
[cookie] already deleted setcookie: "scoutwiki_nlss0-UserID", "", "1683305088", "/", "", "1", "1", ""
[cookie] already deleted setcookie: "scoutwiki_nlUserID", "", "1683305088", "/", "", "1", "1", "None"
[cookie] already deleted setcookie: "scoutwiki_nlss0-Token", "", "1683305088", "/", "", "1", "1", ""
[cookie] already deleted setcookie: "scoutwiki_nlToken", "", "1683305088", "/", "", "1", "1", "None"
[cookie] already deleted setcookie: "ss0-forceHTTPS", "", "1683305088", "/", ".scoutwiki.org", "", "1", ""
[cookie] already deleted setcookie: "forceHTTPS", "", "1683305088", "/", ".scoutwiki.org", "", "1", "None"
[cookie] already deleted setcookie: "ss0-forceHTTPS", "", "1683305088", "/", "", "", "1", ""
[cookie] already deleted setcookie: "forceHTTPS", "", "1683305088", "/", "", "", "1", "None"
[cookie] already deleted setcookie: "centralauth_ss0-User", "", "1683305088", "/", ".scoutwiki.org", "1", "1", ""
[cookie] already deleted setcookie: "centralauth_User", "", "1683305088", "/", ".scoutwiki.org", "1", "1", "None"
[cookie] already deleted setcookie: "centralauth_ss0-Token", "", "1683305088", "/", ".scoutwiki.org", "1", "1", ""
[cookie] already deleted setcookie: "centralauth_Token", "", "1683305088", "/", ".scoutwiki.org", "1", "1", "None"
[cookie] already deleted setcookie: "ss0-centralauth_Session", "", "1683305088", "/", ".scoutwiki.org", "1", "1", ""
[cookie] already deleted setcookie: "centralauth_Session", "", "1683305088", "/", ".scoutwiki.org", "1", "1", "None"
[session] SessionBackend "n9uujnqv4kj3v1rg60vg386quk94di6p" data dirty due to dirty(): MediaWiki\Session\SessionManager->getSessionForRequest/MediaWiki\Session\SessionManager->getInitialSession/MediaWiki\Session\Session->getToken/MediaWiki\Session\Session->set/MediaWiki\Session\SessionBackend->dirty
[session] SessionBackend "n9uujnqv4kj3v1rg60vg386quk94di6p" save: dataDirty=1 metaDirty=0 forcePersist=0
[MessageCache] MessageCache using store RedisBagOStuff
[objectcache] RedisBagOStuff debug: get(WANCache:scoutwiki_nl:messages:nl:hash:v1|#|v,WANCache:scoutwiki_nl:messages:nl|#|t) on 127.0.0.1:6379: success
[MessageCache] MessageCache::loadUnguarded: Loading nl... got from local cache
[objectcache] RedisBagOStuff debug: get(WANCache:scoutwiki_nl:messages:en:hash:v1|#|v,WANCache:scoutwiki_nl:messages:en|#|t) on 127.0.0.1:6379: success
[MessageCache] MessageCache::loadUnguarded: Loading en... got from local cache
ParserFactory: using default preprocessor
Unstubbing $wgPageFormsFormPrinter on call of $wgPageFormsFormPrinter::registerInputType from MediaWiki\HookContainer\HookContainer->callLegacyHook
[error] [0846ba6a62e2ee2143d3c2e1] /Speciaal:Logboeken/Xenjew PHP Deprecated: Wikibase\DataModel\Entity\ItemId implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)
[error] [0846ba6a62e2ee2143d3c2e1] /Speciaal:Logboeken/Xenjew PHP Deprecated: Wikibase\DataModel\Entity\NumericPropertyId implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)
[error] [0846ba6a62e2ee2143d3c2e1] /Speciaal:Logboeken/Xenjew PHP Deprecated: DataValues\StringValue implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)
[error] [0846ba6a62e2ee2143d3c2e1] /Speciaal:Logboeken/Xenjew PHP Deprecated: DataValues\UnknownValue implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)
[error] [0846ba6a62e2ee2143d3c2e1] /Speciaal:Logboeken/Xenjew PHP Deprecated: DataValues\Geo\Values\GlobeCoordinateValue implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)
[error] [0846ba6a62e2ee2143d3c2e1] /Speciaal:Logboeken/Xenjew PHP Deprecated: DataValues\MonolingualTextValue implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)
[error] [0846ba6a62e2ee2143d3c2e1] /Speciaal:Logboeken/Xenjew PHP Deprecated: DataValues\UnboundedQuantityValue implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)
[error] [0846ba6a62e2ee2143d3c2e1] /Speciaal:Logboeken/Xenjew PHP Deprecated: DataValues\QuantityValue implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)
[error] [0846ba6a62e2ee2143d3c2e1] /Speciaal:Logboeken/Xenjew PHP Deprecated: DataValues\TimeValue implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary)
[objectcache] RedisBagOStuff debug: get(WANCache:global:centralauth-user:3b17232c2f988c7c2da2c0847f9115c5|#|v) on 127.0.0.1:6379: success
[CentralAuth] Loading CentralAuthUser for user 3.22.51.241 from cache object
[CentralAuth] Loading attached wiki list for global user 3.22.51.241 from DB
[objectcache] RedisBagOStuff debug: get(WANCache:global:rdbms-server-readonly:localhost:scoutwiki_nl:|#|v) on 127.0.0.1:6379: success
[objectcache] RedisBagOStuff debug: get(WANCache:global:rdbms-server-readonly:localhost:scoutwiki_common:|#|v) on 127.0.0.1:6379: success
[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::open [0s] localhost: SET group_concat_max_len = 262144, `sql_mode` = ''
[DBReplication] Wikimedia\Rdbms\LBFactory::getChronologyProtector: request info {
"IPAddress": "3.22.51.241",
"UserAgent": "Mozilla\/5.0 AppleWebKit\/537.36 (KHTML, like Gecko; compatible; ClaudeBot\/1.0; +claudebot@anthropic.com)",
"ChronologyProtection": false,
"ChronologyPositionIndex": 0,
"ChronologyClientId": false
}[DBReplication] ChronologyProtector using store RedisBagOStuff
[DBReplication] ChronologyProtector fetching positions for 8398b3a64e85ea00492208ce6be0e5f9
[objectcache] RedisBagOStuff debug: get(global:Wikimedia\Rdbms\ChronologyProtector:8398b3a64e85ea00492208ce6be0e5f9:v3) on 127.0.0.1:6379: success
[DBReplication] Wikimedia\Rdbms\ChronologyProtector::applySessionReplicationPosition: DEFAULT (localhost) has no position
[DBConnection] Wikimedia\Rdbms\LoadBalancer::lazyLoadReplicationPositions: executed chronology callback.
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getForeignConnection: opened new connection for foreignInUse/0/scoutwiki_common
[DBQuery] Wikimedia\Rdbms\Database::beginIfImplied (MediaWiki\Extension\CentralAuth\User\CentralAuthUser::loadAttached) [0s] localhost: BEGIN
[DBQuery] MediaWiki\Extension\CentralAuth\User\CentralAuthUser::loadAttached [0s] localhost: SELECT lu_wiki AS `value` FROM `localuser` WHERE lu_name = '3.22.51.241'
[DBConnection] Wikimedia\Rdbms\LoadBalancer::reuseConnectionInternal: freed connection 0/scoutwiki_common
[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::open [0s] localhost: SET group_concat_max_len = 262144, `sql_mode` = ''
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: opened new connection for local/0
[DBQuery] Wikimedia\Rdbms\Database::beginIfImplied (MediaWiki\User\ActorStore::findActorIdInternal) [0s] localhost: BEGIN
[DBQuery] MediaWiki\User\ActorStore::findActorIdInternal [0s] localhost: SELECT actor_user,actor_name,actor_id FROM `actor` WHERE actor_name = 'Xenjew' LIMIT 1
[objectcache] RedisBagOStuff debug: get(WANCache:scoutwiki_nl:valid-tags-db|#|v,WANCache:scoutwiki_nl:valid-tags-db|#|t) on 127.0.0.1:6379: success
[objectcache] RedisBagOStuff debug: get(WANCache:scoutwiki_nl:valid-tags-hook|#|v,WANCache:scoutwiki_nl:valid-tags-hook|#|t) on 127.0.0.1:6379: success
[objectcache] RedisBagOStuff debug: get(WANCache:scoutwiki_nl:tags-list-summary:nl|#|v) on 127.0.0.1:6379: success
[objectcache] RedisBagOStuff debug: get(WANCache:scoutwiki_nl:page:8:7c20b9e557d52f349a44570907be063ee7da913c|#|v) on 127.0.0.1:6379: success
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Page\PageStore::getPageByNameViaLinkCache [0s] localhost: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `page` WHERE page_namespace = 8 AND page_title = 'Visualeditor-descriptionpagelink' LIMIT 1
[objectcache] fetchOrRegenerate(scoutwiki_nl:page:8:7c20b9e557d52f349a44570907be063ee7da913c): miss, new value computed
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] LinkHolderArray::replaceInternal [0s] localhost: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_latest,page_touched,page_len,page_content_model FROM `page` WHERE ((page_namespace = 4 AND page_title = 'Visuele_tekstverwerker'))
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Extension\Disambiguator\Lookup::filterDisambiguationPageIds [0s] localhost: SELECT page_id,rd_from FROM `redirect` JOIN `page` ON ((rd_namespace=page_namespace) AND (rd_title=page_title)) WHERE rd_from = 20022
[DBQuery] MediaWiki\Extension\Disambiguator\Lookup::filterDisambiguationPageIds [0s] localhost: SELECT pp_page FROM `page_props` WHERE pp_page = 20022 AND pp_propname = 'disambiguation'
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Extension\Disambiguator\Lookup::filterDisambiguationPageIds [0s] localhost: SELECT page_id,rd_from FROM `redirect` JOIN `page` ON ((rd_namespace=page_namespace) AND (rd_title=page_title)) WHERE rd_from = 20022
[DBQuery] MediaWiki\Extension\Disambiguator\Lookup::filterDisambiguationPageIds [0s] localhost: SELECT pp_page FROM `page_props` WHERE pp_page = 20022 AND pp_propname = 'disambiguation'
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Extension\Disambiguator\Lookup::filterDisambiguationPageIds [0s] localhost: SELECT page_id,rd_from FROM `redirect` JOIN `page` ON ((rd_namespace=page_namespace) AND (rd_title=page_title)) WHERE rd_from = 20022
[DBQuery] MediaWiki\Extension\Disambiguator\Lookup::filterDisambiguationPageIds [0s] localhost: SELECT pp_page FROM `page_props` WHERE pp_page = 20022 AND pp_propname = 'disambiguation'
[objectcache] RedisBagOStuff debug: get(WANCache:scoutwiki_nl:interwiki:mw|#|v) on 127.0.0.1:6379: success
[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::setBigSelects [0s] localhost: SELECT @@sql_big_selects LIMIT 1
[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::setBigSelects [0s] localhost: SET sql_big_selects=1
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] IndexPager::buildQueryInfo (LogPager) [0.002s] localhost: SELECT /*! STRAIGHT_JOIN */ log_id,log_type,log_action,log_timestamp,log_namespace,log_title,log_params,log_deleted,user_id,user_name,log_actor,logging_actor.actor_user AS `log_user`,logging_actor.actor_name AS `log_user_text`,comment_log_comment.comment_text AS `log_comment_text`,comment_log_comment.comment_data AS `log_comment_data`,comment_log_comment.comment_id AS `log_comment_cid`,(SELECT GROUP_CONCAT(ctd_name SEPARATOR ',') FROM `change_tag` JOIN `change_tag_def` ON ((ct_tag_id=ctd_id)) WHERE ct_log_id=log_id ) AS `ts_tags` FROM `logging` FORCE INDEX (log_actor_type_time) JOIN `actor` `logging_actor` ON ((actor_id=log_actor)) LEFT JOIN `user` ON ((user_id=logging_actor.actor_user)) JOIN `comment` `comment_log_comment` ON ((comment_log_comment.comment_id = log_comment_id)) WHERE (log_type NOT IN ('abusefilter','abusefilterprivatedetails','spamblacklist','titleblacklist','suppress')) AND (log_type != 'thanks') AND (log_type != 'patrol') AND (log_type != 'tag') AND (log_type != 'smw') AND log_actor = 1052 AND ((log_deleted & 4) = 0) ORDER BY log_timestamp DESC LIMIT 51
[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::setBigSelects [0.001s] localhost: SET sql_big_selects=1
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] LinkBatch::doQuery [0s] localhost: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_latest,page_touched,page_len,page_content_model FROM `page` WHERE (page_namespace = 2 AND page_title = 'Xenjew') OR (page_namespace = 3 AND page_title = 'Xenjew')
Unstubbing $wgLang on call of $wgLang::getDatePreferenceMigrationMap from Language->internalUserTimeAndDate
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Page\PageStore::getPageByNameViaLinkCache [0s] localhost: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `page` WHERE page_namespace = 4 AND page_title = 'Gebruiker' LIMIT 1
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] PageProps::getProperties [0s] localhost: SELECT pp_page,pp_propname,pp_value FROM `page_props` WHERE pp_page = 17128 AND pp_propname IN ('PFDefaultForm','SFDefaultForm')
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\User\UserEditTracker::getUserEditCount [0s] localhost: SELECT user_editcount FROM `user` WHERE user_id = 3266 LIMIT 1
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Page\PageStore::getPageByNameViaLinkCache [0s] localhost: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `page` WHERE page_namespace = 4 AND page_title = 'Overleg_gebruiker' LIMIT 1
[DBQuery] MediaWiki::preOutputCommit [0s] localhost: COMMIT
[DBQuery] MediaWiki::preOutputCommit [0s] localhost: COMMIT
MediaWiki::preOutputCommit: primary transaction round committed
MediaWiki::preOutputCommit: pre-send deferred updates completed
MediaWiki::preOutputCommit: session changes committed
[DBReplication] Wikimedia\Rdbms\ChronologyProtector::persistSessionReplicationPositions: no primary positions/timestamps to save
[DBReplication] Wikimedia\Rdbms\LBFactory::shutdown: finished ChronologyProtector shutdown
[DBReplication] LBFactory shutdown completed
OutputPage::haveCacheVaryCookies: no cache-varying cookies found
[objectcache] getWithSetCallback(global:rdbms-server-readonly:localhost:scoutwiki_nl:): process cache hit
[objectcache] RedisBagOStuff debug: get(WANCache:scoutwiki_nl:sidebar:nl|#|v,WANCache:scoutwiki_nl:messages:nl|#|t) on 127.0.0.1:6379: success
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] Wikimedia\Rdbms\Database::beginIfImplied (MediaWiki\Block\DatabaseBlock::newLoad) [0s] localhost: BEGIN
[DBQuery] MediaWiki\Block\DatabaseBlock::newLoad [0s] localhost: SELECT ipb_id,ipb_address,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id,ipb_sitewide,ipb_by_actor,ipblocks_actor.actor_user AS `ipb_by`,ipblocks_actor.actor_name AS `ipb_by_text`,comment_ipb_reason.comment_text AS `ipb_reason_text`,comment_ipb_reason.comment_data AS `ipb_reason_data`,comment_ipb_reason.comment_id AS `ipb_reason_cid` FROM `ipblocks` JOIN `actor` `ipblocks_actor` ON ((actor_id=ipb_by_actor)) JOIN `comment` `comment_ipb_reason` ON ((comment_ipb_reason.comment_id = ipb_reason_id)) WHERE ipb_address = 'Xenjew'
[objectcache] RedisBagOStuff debug: get(WANCache:global:centralauth-user:bbc93ddee97193bd8c9caa14cfe4f192|#|v) on 127.0.0.1:6379: success
[CentralAuth] Loading CentralAuthUser for user Xenjew from cache object
[Wikibase] Wikibase\Lib\SettingsArray::getSetting: setting siteGroup was given as a closure, resolve it to NULL
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\User\TalkPageNotificationManager::dbCheckNewUserMessages [0s] localhost: SELECT user_ip FROM `user_newtalk` WHERE user_ip = '3.22.51.241' LIMIT 1
[objectcache] RedisBagOStuff debug: get(WANCache:scoutwiki_nl:anonnotice::b20c142ee518435d83c190ba53cceb72|#|v) on 127.0.0.1:6379: success
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Block\DatabaseBlock::newLoad [0.001s] localhost: SELECT ipb_id,ipb_address,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id,ipb_sitewide,ipb_by_actor,ipblocks_actor.actor_user AS `ipb_by`,ipblocks_actor.actor_name AS `ipb_by_text`,comment_ipb_reason.comment_text AS `ipb_reason_text`,comment_ipb_reason.comment_data AS `ipb_reason_data`,comment_ipb_reason.comment_id AS `ipb_reason_cid` FROM `ipblocks` JOIN `actor` `ipblocks_actor` ON ((actor_id=ipb_by_actor)) JOIN `comment` `comment_ipb_reason` ON ((comment_ipb_reason.comment_id = ipb_reason_id)) WHERE ipb_address = 'Xenjew'
[objectcache] RedisBagOStuff debug: get(WANCache:global:resourceloader-titleinfo:scoutwiki_nl:2a1a139701291a3933b4ff3c7f3589f557827f35|#|v,WANCache:global:resourceloader-titleinfo:scoutwiki_nl|#|t) on 127.0.0.1:6379: success
[objectcache] RedisBagOStuff debug: get(WANCache:global:resourceloader-titleinfo:scoutwiki_nl:da39a3ee5e6b4b0d3255bfef95601890afd80709|#|v,WANCache:global:resourceloader-titleinfo:scoutwiki_nl|#|t) on 127.0.0.1:6379: success
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Block\DatabaseBlock::newLoad [0s] localhost: SELECT ipb_id,ipb_address,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id,ipb_sitewide,ipb_by_actor,ipblocks_actor.actor_user AS `ipb_by`,ipblocks_actor.actor_name AS `ipb_by_text`,comment_ipb_reason.comment_text AS `ipb_reason_text`,comment_ipb_reason.comment_data AS `ipb_reason_data`,comment_ipb_reason.comment_id AS `ipb_reason_cid` FROM `ipblocks` JOIN `actor` `ipblocks_actor` ON ((actor_id=ipb_by_actor)) JOIN `comment` `comment_ipb_reason` ON ((comment_ipb_reason.comment_id = ipb_reason_id)) WHERE ipb_address = 'Xenjew'