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
Gstupp
.
Toggle Highlighting
SQL
select rev_id, rev_page, rev_timestamp, page_id, page_namespace, page_title, page_touched FROM revision inner join page on revision.rev_page = page.page_id WHERE rev_timestamp > DATE_FORMAT(DATE_SUB(DATE_SUB(NOW(),INTERVAL 0 WEEK), INTERVAL 1 WEEK),'%Y%m%d%H%i%s') AND rev_timestamp < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 0 WEEK),'%Y%m%d%H%i%s') AND page_content_model = 'wikibase-item' AND page.page_title IN('Q27266694','Q7120613','Q417129','Q2737856','Q47521971','Q47522010','Q27278812','Q14985','Q421854', 'Q415107','Q139350','Q27122287','Q15628160','Q20817286','Q48829206','Q47522109','Q241516','Q47522228', 'Q426345','Q171973','Q48826195','Q27265914','Q27283107','Q5018826','Q6535779','Q27279750','Q2393348', 'Q2419445','Q47521296','Q27088963','Q29005969','Q27256242','Q419832','Q637247','Q47522131','Q47522282', 'Q27260203','Q48566820','Q412888','Q27283256','Q3268157','Q27257135','Q11129394','Q27237243','Q27278115', 'Q29005901','Q27258734','Q134583','Q47522015','Q271943','Q18355673','Q29006753','Q47522224','Q27257028', 'Q47522182','Q27284105','Q209206','Q28856135','Q20817210','Q414873','Q27257099','Q3270244','Q409393', 'Q47522364','Q29006351','Q928378','Q418086','Q27276837','Q419668','Q278809','Q7810487','Q29006518', 'Q29005767','Q47522283','Q27236434','Q27114315','Q198504','Q410739','Q47521997','Q6839784','Q47521389', 'Q29006239','Q418625','Q27896165','Q2943814','Q47522074','Q27097878','Q27103475','Q27277542','Q423757', 'Q27104782','Q27158397','Q1948992','Q410291','Q4890915','Q29005877','Q268997','Q1061007','Q27282034', 'Q21270844','Q411557','Q18324709','Q47521396','Q287415','Q47521309','Q27251935','Q27132403','Q13026783', 'Q27289243','Q47521412','Q29006173','Q133145','Q416860','Q550017','Q27261759','Q423586','Q23905965', 'Q29004968','Q29006514','Q47521474','Q47522247','Q47521865','Q27109415','Q27285491','Q27291481','Q409583', 'Q27274677','Q27268914','Q27257228','Q27292509','Q27102715','Q4890814','Q27295678','Q821641','Q27157431', 'Q27266295','Q410529','Q47521704','Q27254465','Q410209','Q4673310','Q47521621','Q27231349','Q5261287','Q27108087','Q27278154','Q422188','Q47521685','Q47522181','Q27146924','Q47521536','Q27291360','Q27260687','Q27262841','Q6827850','Q413739','Q7272243','Q47521199','Q167934','Q27266708','Q3530618','Q3655009','Q47521492','Q27251336','Q7941753','Q47521840','Q7115199','Q29006344','Q10860583','Q155883','Q182040','Q27128594','Q722419','Q29006280','Q29006534','Q29006638','Q27274961','Q27887916','Q27283300','Q27145679','Q27255529','Q410298','Q27107497','Q407613','Q27270629','Q1259495','Q21080030','Q48829264','Q4197874','Q27286100','Q48566663','Q27281873','Q48566642','Q47521304','Q4919218','Q27284240','Q15409424','Q27254260','Q27273326','Q1108','Q27270028','Q29006373','Q48828874','Q48566743','Q47521834','Q27105659','Q47521254','Q27273891','Q27271664','Q27261814','Q27071132','Q48826438','Q27101960','Q47522125','Q29006077','Q29006659','Q29006657','Q412223','Q27113586','Q27888058','Q408977','Q531965','Q1098','Q27107595','Q47521369','Q5190760','Q419926','Q3604308','Q27254253','Q903525','Q29006446','Q27236272','Q27294082','Q27275243','Q48832109','Q407699','Q410005','Q48828245','Q27273405','Q27291961','Q6807285','Q27255849','Q47522057','Q425681','Q29006081','Q47522354','Q48829353','Q5572621','Q2319112','Q411582','Q6723225','Q27116059','Q6064129','Q27252275','Q831929','Q27263580','Q27095645','Q48829367','Q7250550','Q5368263','Q27263296','Q420323','Q27105817','Q423384','Q29006120','Q27265823','Q411325','Q29006389','Q27290747','Q422229','Q1371645','Q421218','Q2901642','Q27261827','Q27106156','Q412734','Q3496452','Q47521339','Q23034944','Q219957','Q47522096','Q27890466','Q27115003','Q27292427','Q47521183','Q27277582','Q27263887','Q4784959','Q29006526','Q417902','Q209467','Q27258635','Q27166546','Q411424','Q274972','Q27290642','Q47522025','Q29006110','Q47521595','Q166476','Q47522093','Q418480','Q6628390','Q421663','Q27255947','Q48828813','Q419379','Q420454','Q27270804','Q4881990','Q47521272','Q2823284','Q4027534','Q47521189','Q413364','Q27088528','Q414501','Q7795979','Q27277561','Q10859631','Q27268058','Q27285084','Q27265501','Q48829062','Q155746','Q3906700','Q28852429','Q29006496','Q29004870','Q409618','Q27290679','Q47522309','Q5462984','Q48826336','Q410198','Q423376','Q47495786','Q26841224','Q27285635','Q11370588','Q416950','Q411552','Q243547','Q1470932','Q32703','Q27258167','Q27264195','Q419890','Q47522126','Q48832112','Q4352011','Q27144824','Q27292550','Q27269616','Q419488','Q47521440','Q27265970','Q5891790','Q420188','Q10910139','Q412486','Q184564','Q415433','Q5134338','Q27089232','Q27269783','Q48832104','Q27251740','Q27280832','Q408880','Q47521518','Q27132757','Q29006694','Q2000876','Q47521552','Q199877','Q6823933','Q27887794','Q47521695','Q3049725','Q28859599','Q27285569','Q26840913','Q4161380','Q27287271','Q47521022','Q419811','Q27253913','Q48826251','Q27278647','Q2758338','Q48828805','Q7828277','Q27289664','Q27277878','Q27269802','Q7809617','Q47521475','Q29006755','Q47521618','Q27262488','Q48829373','Q2364943','Q47521877','Q47522229','Q48829137','Q27254357','Q47521251','Q424057','Q255968','Q413740','Q47521310','Q27105052','Q47522012','Q7197363','Q47521009','Q27114280','Q47521306','Q414964','Q29004926','Q27261484','Q47521647','Q415403','Q3066718','Q27282804','Q2070778','Q27270803','Q560','Q27107688','Q339734','Q27121459','Q27286040','Q384295','Q47521984','Q29005873','Q47521244','Q1435626','Q26203284','Q27276579','Q426819','Q27294904','Q27251234','Q29006228','Q425654','Q2760221','Q27135601','Q27106427','Q29006199','Q3027890','Q47522231','Q27254453','Q27268870','Q15726025','Q3088229','Q415090','Q544393','Q18212106','Q47520983','Q48829073','Q416237','Q29006038','Q27263323','Q27114682','Q27264673','Q27122988','Q47522104','Q27279582','Q48829345','Q5659069','Q7334443','Q47521221','Q3074500','Q47521604','Q47522216','Q423520','Q27252867','Q3680934','Q6948278','Q30135771','Q6824219','Q4138145','Q8074572','Q47520988','Q27276630','Q7557110','Q27256645','Q2240116','Q29005685','Q416904','Q27279120','Q674703','Q27104584','Q27108064','Q29005657','Q27104033','Q47521342','Q2025','Q27261024','Q421100','Q906102','Q15726116','Q47522267','Q47521700','Q27155631','Q907104','Q27258678','Q48829084','Q48828303','Q5473368','Q48828184','Q27270977','Q27103186','Q27293431','Q27236985','Q47521038','Q27106523','Q4291658','Q6823517','Q418006','Q47522038','Q27286540','Q1992452','Q27261715','Q7455005','Q18216','Q5104324','Q410537','Q27295581','Q1097778','Q415939','Q27281818','Q3124290','Q48826207','Q179678','Q27074832','Q27126379','Q192464','Q27277051','Q29006271','Q17620495','Q29004954','Q416562','Q3792005','Q27287724','Q29004417','Q424477','Q271980','Q413578','Q27114748','Q47521570','Q47521880','Q410358','Q5161126','Q27268778','Q48829285','Q422654','Q27253955','Q47521013','Q26840944','Q27256288','Q180912','Q18212174','Q407535','Q27265970','Q413598','Q48826366','Q27128592','Q2359690','Q27266190','Q27890431','Q27291192','Q27107602','Q48829182','Q420296','Q27284267','Q27280661','Q411732','Q27155580','Q27289792','Q15410178','Q27264331','Q48828039','Q47521890','Q25018296','Q23766546','Q27285618','Q425073','Q27279276','Q27279207','Q27257840','Q48828086','Q48828170','Q27281858','Q29004967','Q27284955','Q47521546','Q27114724','Q7086489','Q29006368','Q27275612','Q419059','Q408300','Q48828955','Q60168','Q212272','Q48825997','Q412133','Q27236591','Q7307897','Q47522011','Q27281693','Q1707877','Q27272243','Q47521985','Q6823610','Q204906','Q27268736','Q938','Q29006525','Q47521580','Q904833','Q47521573','Q47521993','Q5277356','Q5375179','Q180713','Q47521522','Q27257969','Q375613','Q419944','Q6890329','Q27114303','Q47521211','Q410513','Q720761','Q314036','Q27145806','Q27275483','Q27262846','Q27116294','Q10860261','Q27279605','Q15426255','Q47521331','Q27891525','Q5277336','Q47521839','Q27274002','Q48566717','Q27262075','Q2683759','Q27279180','Q285790','Q27257345','Q48829189','Q172290','Q27271475','Q47521470','Q4890934','Q4735269','Q3395266','Q304088','Q193978','Q27269155','Q3876717','Q311992','Q116269','Q47521808','Q29004403','Q29006144','Q27156746','Q27293381','Q287029','Q47522259','Q47522139','Q5138908','Q27253959','Q410352','Q27290248','Q26841212','Q5220980','Q27268175','Q47522185','Q27262168','Q47521315','Q27105309','Q27266379','Q27147185','Q47520881','Q418889','Q27258258','Q7559299','Q204964','Q3791957','Q424531','Q47522324','Q1321320','Q24726011','Q27277033','Q27285537','Q47522333','Q29006343','Q6995920','Q567927','Q248466','Q5383939','Q425640','Q2295855','Q5276428','Q47521019','Q48826405','Q47521029','Q27287312','Q29006677','Q904011','Q27130132','Q47521556','Q27285536','Q7397389','Q27291666','Q27257777','Q48828830','Q47521477','Q27291396','Q27107073','Q27278883','Q5927277','Q27275308','Q3798322','Q27291919','Q27135730','Q1758380','Q48828990','Q27262974','Q47522249','Q27283785','Q415032','Q737','Q27266012','Q2552927','Q27282428','Q242627','Q17320243','Q48826376','Q27114606','Q27252751','Q27293431','Q27268231','Q1368869','Q27274351','Q29006352','Q27270837','Q48829075','Q204036','Q27266451','Q408815','Q407796','Q48829008','Q27262959','Q48566805','Q27121190','Q420439','Q29006612','Q48566756','Q27283244','Q27261789','Q47521904','Q27260938','Q1169561','Q29006047','Q27265091','Q423037','Q27104351','Q549803','Q423762','Q27114403','Q48829317','Q47521227','Q5103213','Q5132338','Q26840848','Q27264189','Q27149252','Q19598175','Q407426','Q47520879','Q4726914','Q27260984','Q47521646','Q1268941','Q27292612','Q27895653','Q27260842','Q47521746','Q27102474','Q27270622','Q48829326','Q27291041','Q19598139','Q411752','Q47521956','Q47521769','Q47521738','Q29006495','Q27294840','Q3742067','Q2662688','Q414806','Q27253616','Q27281767','Q29006458','Q416475','Q47521615','Q27259102','Q27252125','Q47521024','Q194974','Q48318','Q47522213','Q174786','Q413879','Q27272163','Q47521790','Q5134843','Q27888072','Q27280038','Q47521190','Q47521857','Q16392','Q29006498','Q26705718','Q422232','Q277785','Q27254360','Q27882076','Q413178','Q27282563','Q47522151','Q27291552','Q7164959','Q81890','Q343005','Q27114696','Q5516411','Q48829163','Q47522157','Q27258202','Q27281679','Q2619971','Q48828234','Q5038067','Q47521752','Q27277189','Q6824399','Q416894','Q417250','Q47521447','Q27107642','Q7077016','Q425881','Q27276371','Q407560','Q423366','Q47521479','Q421351','Q29006101','Q27269958','Q410237','Q48826381','Q1925607','Q47521736','Q48829186','Q5057296','Q47522203','Q2768526','Q2889971','Q414689','Q47521455','Q3680956','Q421994','Q304581','Q283033','Q425120','Q27285633','Q27271622','Q27271269','Q27259239','Q28859607','Q411787','Q29006096','Q3539707','Q27114685','Q29005776','Q27282195','Q4353252','Q766883','Q47521957','Q47521398','Q27281281','Q48825986','Q27295039','Q904308','Q27882203','Q47521829','Q47522363','Q183011','Q47521332','Q7860340','Q28852424','Q48826510','Q411452','Q1047468','Q987691','Q27294079','Q1091','Q48829000','Q27262571','Q27289765','Q47521397','Q29005842','Q352348','Q48826141','Q48829253','Q27137065','Q47521431','Q48829260','Q27098012','Q416005','Q27268618','Q11255995','Q27261755','Q47521963','Q147101','Q27266205','Q47521212','Q27108445','Q418445','Q47522127','Q27266609','Q27122484','Q47521425','Q48826310','Q131189','Q27272209','Q4789167','Q407857','Q48566693','Q47521337','Q27157250','Q47521336','Q637059','Q241006','Q423971','Q27106393','Q412939','Q48828906','Q20817270','Q161210','Q1593246','Q921133','Q27291325','Q48828078','Q23779747','Q47522222','Q47521670','Q27274427','Q419769','Q27114210','Q27262908','Q47521893','Q27262815','Q27256656','Q29006012','Q29006232','Q27284954','Q27282524','Q29004944','Q48828093','Q47522161','Q27282619','Q2938837','Q27256110','Q27158380','Q47521187','Q27105897','Q27107702','Q424952','Q22829551','Q4445828','Q29006628','Q27236780','Q27104205','Q5521314','Q27108435','Q27263620','Q201959','Q2928998','Q15491377','Q29005670','Q2757969','Q27282303','Q27279946','Q27265674', 'Q20801763','Q5103222','Q27286696','Q337188','Q29006635','Q407329','Q4661156','Q27252491','Q421338','Q422847','Q5268499','Q26840943', 'Q29006757','Q48829125','Q27074154','Q47522345','Q421224','Q15305564','Q27270945','Q47521675','Q47521274','Q27104150','Q867308','Q418123', 'Q1182795','Q416516','Q27282924','Q27263002','Q27126505','Q4738021','Q905717','Q27158444','Q1969766','Q5249594','Q27102911','Q27270050', 'Q27295871','Q47521744','Q423989','Q10442124','Q27265738','Q48826006','Q1851162','Q27280150','Q420186','Q27276476','Q372598','Q27280842', 'Q27266563','Q27115611','Q47521672','Q48828311','Q5991156','Q47521040','Q903322','Q47521042','Q28128','Q47521768','Q27257890','Q412216');
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...