Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Viswaprabha
.
Toggle Highlighting
SQL
/* Last edited: 2018 Apr 06 Fri 15:09 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; USE bnwiki_p; SET @SNum := 0; SELECT 'bn ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE enwiki_p; SET @SNum := 0; SELECT 'en ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE guwiki_p; SET @SNum := 0; SELECT 'gu ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE hiwiki_p; SET @SNum := 0; SELECT 'hi ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE knwiki_p; SET @SNum := 0; SELECT 'kn ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE mlwiki_p; SET @SNum := 0; SELECT 'ml ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE mrwiki_p; SET @SNum := 0; SELECT 'mr ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE orwiki_p; SET @SNum := 0; SELECT 'or ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE pawiki_p; SET @SNum := 0; SELECT 'pa ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE sawiki_p; SET @SNum := 0; SELECT 'sa ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE tawiki_p; SET @SNum := 0; SELECT 'ta ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE tewiki_p; SET @SNum := 0; SELECT 'te ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500'); USE urwiki_p; SET @SNum := 0; SELECT 'ur ', @SNum:=@SNum + 1 AS SNum, eu_entity_id AS QID, page_id AS PageID, page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect, page_is_new AS New, eu_touched AS Touched, page_touched AS PageTouched, page_links_updated AS LinksUpdated FROM `wbc_entity_usage` LEFT JOIN page ON wbc_entity_usage.`eu_page_id` = page.`page_id` WHERE `eu_aspect` = 'S' and `eu_entity_id` in ('Q7906062','Q7288535','Q2904990','Q24006401','Q7426867','Q12441819','Q25991080','Q7117143','Q7288554','Q380446','Q325611','Q1398727','Q7929186','Q3533604','Q3595877','Q23751617','Q24565804','Q205782','Q7450','Q17488996','Q24053925','Q7293103','Q23584622','Q22003857','Q24852235','Q325393','Q24069547','Q3556093','Q6727256','Q7424434','Q15647901','Q24206356','Q23945376','Q18707512','Q19144134','Q3521462','Q24266352','Q20609549','Q5541169','Q17486541','Q7503808','Q16007650','Q4107198','Q3353479','Q2722282','Q20639296','Q17501879','Q735363','Q19899013','Q7842098','Q4699973','Q5423843','Q3351142','Q15455923','Q7906015','Q23615194','Q2041442','Q15989771','Q574605','Q7283012','Q15127403','Q467215','Q12452410','Q4841930','Q4648232','Q5591314','Q12449467','Q20738401','Q1484297','Q16846909','Q4121995','Q1880793','Q7906072','Q179201','Q4802125','Q1391255','Q5589905','Q4889104','Q3296450','Q7286026','Q381326','Q4795479','Q3529625','Q15407113','Q18129367','Q4648404','Q3519761','Q18921468','Q8064717','Q2724184','Q11115366','Q25202937','Q24565774','Q17517341','Q15460356','Q380221','Q25313788','Q20685240','Q6323839','Q26370','Q7785316','Q7387811','Q19895739','Q1188802','Q26179548','Q4648374','Q21062343','Q711237','Q23806437','Q7127802','Q7877236','Q25323997','Q92820','Q30588364','Q249244','Q24298886','Q325470','Q16137452','Q726244','Q16258286','Q4358527','Q24565815','Q21608740','Q1522801','Q12444646','Q17495891','Q7074581','Q7709411','Q24952443','Q4907323','Q20675717','Q24284394','Q6712928','Q6712261','Q24284557','Q7130773','Q4834125','Q982109','Q24176261','Q17901070','Q48846833','Q17149374','Q24007576','Q19650149','Q11179937','Q1165649','Q4177500');
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...
