Page MenuHomePhabricator
Paste P16961

GoogleNewsSitemap queries
ActivePublic
Actions

Authored by Legoktm on Aug 5 2021, 9:50 AM.
Tags
None
Referenced Files
F34585022: GoogleNewsSitemap queries
Aug 5 2021, 9:50 AM
Subscribers
None
2021-08-05 09:45:32 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getCacheInvalidationInfo [0.001s] db2127: SELECT cat_pages FROM `category` WHERE cat_title IN ('Published','Asia','No_publish','Disputed') ORDER BY cat_title {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getCacheInvalidationInfo","sql":"SELECT cat_pages FROM `category` WHERE cat_title IN ('Published','Asia','No_publish','Disputed') ORDER BY cat_title ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:32 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getCacheInvalidationInfo [0.001s] db2127: (SELECT MAX(cl_timestamp) AS ts FROM `categorylinks` WHERE cl_to = 'Published' ) UNION ALL (SELECT MAX(cl_timestamp) AS ts FROM `categorylinks` WHERE cl_to = 'Asia' ) UNION ALL (SELECT MAX(cl_timestamp) AS ts FROM `categorylinks` WHERE cl_to = 'No_publish' ) UNION ALL (SELECT MAX(cl_timestamp) AS ts FROM `categorylinks` WHERE cl_to = 'Disputed' ) {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getCacheInvalidationInfo","sql":"(SELECT MAX(cl_timestamp) AS ts FROM `categorylinks` WHERE cl_to = 'Published' ) UNION ALL (SELECT MAX(cl_timestamp) AS ts FROM `categorylinks` WHERE cl_to = 'Asia' ) UNION ALL (SELECT MAX(cl_timestamp) AS ts FROM `categorylinks` WHERE cl_to = 'No_publish' ) UNION ALL (SELECT MAX(cl_timestamp) AS ts FROM `categorylinks` WHERE cl_to = 'Disputed' )","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:32 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getCategories [0.065s] db2127: SELECT page_namespace,page_title,page_id,c1.cl_timestamp FROM `page` LEFT JOIN `flaggedpages` ON ((page_id = fp_page_id)) INNER JOIN `categorylinks` `c1` ON ((page_id = c1.cl_from) AND (c1.cl_to='Published')) INNER JOIN `categorylinks` `c2` ON ((page_id = c2.cl_from) AND (c2.cl_to='Asia')) LEFT OUTER JOIN `categorylinks` `c3` ON ((page_id = c3.cl_from) AND (c3.cl_to='No_publish')) LEFT OUTER JOIN `categorylinks` `c4` ON ((page_id = c4.cl_from) AND (c4.cl_to='Disputed')) WHERE page_namespace = 0 AND (fp_stable IS NOT NULL ) AND page_is_redirect = 0 AND (c3.cl_to IS NULL) AND (c4.cl_to IS NULL) ORDER BY c1.cl_timestamp DESC LIMIT 15 {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getCategories","sql":"SELECT page_namespace,page_title,page_id,c1.cl_timestamp FROM `page` LEFT JOIN `flaggedpages` ON ((page_id = fp_page_id)) INNER JOIN `categorylinks` `c1` ON ((page_id = c1.cl_from) AND (c1.cl_to='Published')) INNER JOIN `categorylinks` `c2` ON ((page_id = c2.cl_from) AND (c2.cl_to='Asia')) LEFT OUTER JOIN `categorylinks` `c3` ON ((page_id = c3.cl_from) AND (c3.cl_to='No_publish')) LEFT OUTER JOIN `categorylinks` `c4` ON ((page_id = c4.cl_from) AND (c4.cl_to='Disputed')) WHERE page_namespace = 0 AND (fp_stable IS NOT NULL ) AND page_is_redirect = 0 AND (c3.cl_to IS NULL) AND (c4.cl_to IS NULL) ORDER BY c1.cl_timestamp DESC LIMIT 15 ","domain":"enwikinews","runtime":0.065}
2021-08-05 09:45:32 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2927381 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2927381 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2927049 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2927049 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2926957 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2926957 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2925313 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2925313 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2924985 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2924985 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2924411 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2924411 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2923692 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2923692 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2921097 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2921097 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2921086 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2921086 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.002s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2920210 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2920210 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.002}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2920166 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2920166 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2919535 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2919535 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2919508 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2919508 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2918646 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2918646 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
2021-08-05 09:45:33 [46d12dfa-debb-4f24-8934-c276e2861bf2] mwdebug2001 enwikinews 1.37.0-wmf.17 DBQuery DEBUG: GoogleNewsSitemap::getVisibleCategories [0.001s] db2127: SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2918237 AND pp_propname IS NULL {"db_server":"db2127","db_name":"enwikinews","db_user":"wikiuser","method":"GoogleNewsSitemap::getVisibleCategories","sql":"SELECT cl_to FROM `categorylinks` LEFT OUTER JOIN `page` ON (page_namespace = 14 AND (page_title=cl_to)) LEFT OUTER JOIN `page_props` ON ((pp_page=page_id) AND pp_propname = 'hiddencat') WHERE cl_from = 2918237 AND pp_propname IS NULL ","domain":"enwikinews","runtime":0.001}
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL