Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Wikidata QID for Site links "Category:Nobel_laureates_in_"
by
Viswaprabha
This query is marked as a draft
This query has been published
by
Viswaprabha
.
Toggle Highlighting
SQL
/* Last edited: 2018 Apr 06 Fri 15:25 User:Viswaprabha*/ SELECT '26227' 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481'); 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 ('Q7564201','Q102250','Q76595','Q102266','Q102278','Q80956','Q102291','Q57078','Q102419','Q102379','Q76614','Q1351105','Q76606','Q102395','Q102406','Q43917','Q5327','Q49347','Q135180','Q106699','Q202146','Q233205','Q135171','Q135154','Q135151','Q135139','Q7186','Q110930','Q103835','Q76612','Q76616','Q41585344','Q33128','Q76600','Q122272','Q60066','Q76613','Q106738','Q3259614','Q44594','Q76604','Q70554','Q176351','Q28833112','Q217734','Q110073','Q217486','Q104582','Q202140','Q57075','Q57065','Q189803','Q157212','Q107422','Q204600','Q106471','Q106751','Q91410','Q1678456','Q243196','Q232302','Q76602','Q76951','Q157701','Q48986','Q7487','Q102822','Q273279','Q76623','Q150989','Q7504','Q106733','Q903471','Q73093','Q232295','Q190626','Q110947','Q80907','Q78510','Q170676','Q157250','Q78483','Q184286','Q243190','Q80910','Q107690','Q233985','Q6832227','Q190486','Q1886068','Q110935','Q110942','Q211482','Q239067','Q48977','Q19009','Q224153','Q77086','Q207992','Q7151888','Q1387059','Q102804','Q19045','Q110952','Q233355','Q157224','Q234145','Q105927','Q57125','Q235834','Q106399','Q157210','Q192603','Q107405','Q12658','Q48983','Q244998','Q78480','Q237825','Q233973','Q106762','Q78482','Q83501','Q183509','Q60061','Q950726','Q189465','Q49351','Q230652','Q111190','Q9123','Q122996','Q104575','Q15118973','Q151564','Q3169751','Q202159','Q48973','Q48990','Q110925','Q44111','Q205345','Q110916','Q1687170','Q106746','Q232289','Q102830','Q105937','Q48956','Q156492','Q109559','Q376243','Q106756','Q105949','Q186391','Q48979','Q110963','Q235983','Q233026','Q157242','Q200470','Q179777','Q157239','Q235184','Q57127','Q4790366','Q123014','Q76610','Q274128','Q77072','Q77142','Q77171','Q232316','Q110957','Q7426','Q106624','Q76624','Q78481');
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...
