Wikidata QID for Site links "List of chemical elements"

This query is marked as a draft This query has been published by Viswaprabha.
SQL

/* Last edited: 2018 Apr 06 Fri 03:48 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
/* Last edited: 2018 Apr 06 Fri 03:48 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 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_aspect AS Aspect, page_namespace AS NS, 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 ('Q11344','Q10693','Q5358842','Q428940','Q7360663','Q102500','Q1121','Q663','Q1872','Q1099','Q696','Q871','Q999','Q1112','Q1882','Q569','Q942','Q1249','Q618','Q879','Q1091','Q1108','Q706','Q1888','Q623','Q1385','Q688','Q725','Q740','Q1278','Q753','Q1876','Q1266','Q1232','Q1843','Q1892','Q1849','Q1396','Q1896','Q1302','Q650','Q671','Q1832','Q861','Q867','Q897','Q1119','Q1252','Q560','Q1846','Q556','Q1094','Q1103','Q877','Q677','Q888','Q1801','Q1905','Q708','Q568','Q1304','Q1857','Q660','Q731','Q1258','Q1898','Q925','Q1053','Q1303','Q1388','Q654','Q1105','Q744','Q1301','Q1046','Q627','Q1901','Q1307','Q751','Q629','Q1089','Q674','Q880','Q1102','Q979','Q703','Q1386','Q1809','Q1109','Q1128','Q1133','Q737','Q1087','Q1272','Q895','Q1086','Q1226','Q1819','Q713','Q1234','Q876','Q670','Q1090','Q658','Q938','Q682','Q1123','Q1054','Q1100','Q1306','Q1838','Q932','Q1115','Q1853','Q1096','Q716','Q743','Q1146','Q1466','Q1139','Q1098','Q722','Q1106','Q1855','Q941','Q758','Q1038');
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.
SQL

Checking query status...
