Untitled query #68663

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

select page_title, min(rev_timestamp) as creation_date
from revision
join page on page_id=rev_page
where page_title in ("P10003","P10026","P10074","P10075","P10076","P10078","P10079","P10084","P10087","P10091","P10094","P10101","P10107","P10108","P10117","P10118","P10123","P10124","P10125","P10127","P10129","P10134","P10140","P10142","P10145","P10153","P10161","P10165","P10176","P10177","P10179","P10183","P10185","P10186","P10188","P10193","P10199","P10201","P10202","P10204","P10208","P10209","P10211","P10223","P10224","P10233","P10237","P10246","P10247","P10251","P10256","P10264","P10273","P10279","P10281","P10282","P10284","P10306","P10310","P10315","P10330","P10332","P10340","P10341","P10342","P10345","P10346","P10347","P10350","P10352","P10361","P10362","P10368","P10375","P10381","P10388","P10389","P10406","P10409","P10411","P10413","P10417","P10423","P10427","P10430","P10435","P10440","P10443","P10444","P10460","P10462","P10468","P10470","P10474","P10477","P10479","P10481","P10482","P10489","P10490","P10491","P10493","P10497","P10498","P10502","P10504","P10512","P10515","P10517","P1052","P10520","P10523","P10530","P10531","P10534","P10541","P10543","P10544","P10546","P10548","P10549","P10550","P10556","P10558","P10560","P10566","P10567","P10570","P10571","P10572","P10573","P10575","P10581","P10584","P10587","P10591","P10595","P10596","P10599","P10601","P10610","P10613","P10614","P10616","P10617","P10623","P10625","P10628","P10630","P10636","P10637","P10640","P10642","P10643","P10644","P10645","P10648","P10659","P10662","P10665","P10676","P10681","P10683","P10686","P1069","P10693","P10695","P10696","P10705","P10710","P10712","P10714","P10716","P10721","P10722","P10724","P10726","P10727","P10728","P10732","P10733","P10734","P10735","P10737","P10740","P10746","P10749","P10754","P1076","P10777","P10778","P10781","P10798","P10807","P10808","P10809","P10810","P10812","P10813","P10814","P10815","P10816","P10817","P10823","P10824","P10825","P10839","P10853","P10860","P10868","P10871","P10876","P10877","P10878","P10884","P10889","P10893","P10896","P10899","P10904","P10910","P10917","P10922","P10924","P10933","P10939","P10940","P10941","P10942","P10944","P10945","P10946","P10953","P10954","P10955","P10959","P10961","P10964","P10965","P10966","P10967","P10968","P1097","P10970","P10973","P10975","P10980","P10982","P10983","P10984","P10985","P10986","P10988","P10989","P10990","P10991","P10992","P10993","P10995","P11002","P11006","P11007","P11009","P11011","P11015","P11017","P11023","P11024","P11026","P11027","P11028","P11030","P11033","P11034","P11035","P11038","P11056","P11064","P11069","P11081","P11082","P11086","P11089","P11094","P11096","P11097","P11099","P11100","P11102","P11103","P11113","P11116","P11117","P11121","P11126","P11129","P11133","P11134","P11139","P11140","P11141","P11146","P11147","P11148","P11151","P11153","P11154","P11155","P11156","P11157","P11158","P11159","P11161","P11162","P11163","P11164","P11165","P11166","P1210","P1221","P1271","P1275","P1295","P1450","P1575","P1675","P1676","P1689","P1738","P1913","P1914","P1915","P1917","P1918","P1929","P1948","P1956","P2086","P2126","P2135","P2136","P2140","P2141","P2150","P2185","P2208","P2220","P2221","P2222","P2223","P2232","P2255","P2292","P2294","P2296","P2297","P2362","P2368","P2406","P2430","P2524","P2535","P2542","P2576","P2587","P2662","P2710","P2717","P2718","P2766","P2796","P2834","P2835","P2836","P2874","P2972","P2983","P2986","P2988","P3076","P3116","P3146","P3149","P3199","P3200","P3251","P3252","P3268","P3291","P3337","P3375","P3386","P3399","P3447","P3464","P3467","P3486","P3492","P3524","P3586","P3623","P3717","P3731","P3736","P3741","P3756","P3768","P3775","P3805","P3809","P3819","P3892","P3944","P3969","P3971","P3972","P3978","P3991","P4001","P4018","P4041","P4045","P4047","P4078","P4105","P4113","P4121","P4142","P4207","P4221","P4233","P4236","P4242","P4268","P4269","P4280","P4294","P4325","P4337","P4349","P4355","P4393","P4445","P4447","P4455","P4487","P4512","P4554","P4624","P4669","P4670","P4677","P4734","P4752","P4809","P4827","P4849","P4850","P4851","P4853","P4882","P4922","P4923","P4926","P4937","P4938","P4940","P4941","P4950","P4951","P4958","P4982","P5013","P5014","P5018","P5070","P5090","P5118","P5169","P5170","P5189","P5214","P5215","P5231","P5411","P5428","P5434","P5438","P5439","P5474","P5481","P5509","P5520","P5547","P5557","P5560","P5563","P5575","P5589","P5593","P5594","P5596","P5608","P5609","P5620","P5668","P5669","P5670","P5672","P5673","P5674","P5675","P5676","P5677","P5678","P5679","P5681","P5682","P5685","P5706","P5709","P5710","P5727","P5756","P5762","P578","P5784","P5798","P5802","P5803","P5808","P5809","P5864","P5867","P5876","P5877","P5881","P5893","P5899","P5913","P5926","P5929","P5934","P5937","P5938","P5939","P5947","P5967","P5979","P5992","P5993","P6013","P6014","P6017","P6035","P6043","P6067","P6069","P6073","P6075","P6076","P6089","P6090","P6095","P6098","P6116","P6168","P6171","P6205","P6212","P6220","P6225","P6245","P6247","P6248","P6250","P626","P6260","P6261","P6289","P6320","P6322","P6330","P6410","P6420","P6430","P6447","P6448","P6454","P6470","P6497","P6510","P6557","P6558","P656","P6577","P6586","P660","P6604","P6626","P6640","P6650","P6653","P6657","P6661","P6664","P6688","P6697","P6701","P6707","P6708","P6729","P6737","P6749","P6754","P6757","P6763","P6768","P6790","P6798","P6808","P6810","P6816","P6820","P6822","P6825","P6841","P6854","P6859","P6876","P6884","P6888","P6899","P6905","P6906","P6924","P6938","P6940","P6946","P6948","P6956","P6957","P6958","P6971","P6975","P6993","P6994","P7001","P7020","P7034","P7064","P7069","P7073","P7074","P7079","P7083","P7093","P7111","P7113","P7114","P7115","P7134","P7144","P7155","P7161","P7162","P7172","P7183","P7186","P7216","P7221","P7230","P7258","P7269","P7270","P7273","P7283","P7292","P7302","P7310","P7336","P7337","P7375","P7391","P7408","P7413","P7447","P7448","P7456","P7460","P7482","P7484","P7485","P7489","P7513","P7515","P7527","P7529","P7536","P7538","P7539","P7542","P7543","P7544","P7547","P7549","P7565","P7566","P7600","P7601","P7605","P7610","P7621","P7631","P7651","P7652","P7654","P7657","P7658","P7675","P7684","P7738","P7750","P7755","P7762","P7765","P7768","P7773","P7792","P7794","P7795","P7805","P7806","P7821","P7826","P7873","P7899","P7906","P7907","P7922","P7945","P7946","P7974","P7976","P7987","P7999","P8012","P8016","P8027","P8043","P8056","P8064","P8073","P8075","P8096","P8097","P8117","P8118","P8120","P8123","P8126","P8128","P8139","P8182","P8183","P8186","P8187","P8190","P8191","P8192","P8198","P8203","P8216","P8220","P8221","P8228","P8244","P8245","P8254","P8257","P8263","P8275","P8306","P8310","P8319","P8323","P8339","P8354","P8356","P8380","P8390","P8397","P8409","P8442","P8454","P8459","P8461","P8465","P8466","P8480","P8481","P8485","P8486","P8489","P849","P8495","P8497","P8502","P8503","P8508","P8509","P855","P8552","P8553","P8560","P8561","P8576","P8615","P862","P8620","P8622","P8638","P8644","P8675","P8684","P8685","P8698","P8700","P8715","P8722","P8724","P875","P8757","P876","P8760","P8763","P8787","P8789","P8792","P8818","P8820","P8823","P8824","P8830","P8835","P8836","P8837","P8845","P8857","P8862","P8864","P8866","P8871","P8873","P8884","P8890","P8891","P8893","P8930","P8936","P8949","P8963","P8970","P9018","P9023","P9027","P9028","P9031","P9038","P9040","P9063","P9064","P9077","P9103","P9120","P9124","P9126","P9140","P9145","P9156","P9162","P9176","P9180","P9184","P9188","P9190","P9193","P9195","P9197","P9202","P9206","P9207","P9209","P9216","P9217","P922","P9220","P9225","P9238","P9249","P925","P9252","P9253","P9254","P926","P9262","P9263","P9270","P9275","P9278","P9288","P929","P9306","P9308","P9309","P9317","P9323","P9334","P9351","P9354","P9355","P9356","P9358","P9362","P9364","P9369","P9372","P9373","P9375","P9380","P9396","P9412","P9421","P9424","P9428","P9429","P9431","P9436","P9445","P9451","P9453","P9479","P9480","P9481","P9496","P9500","P9512","P9514","P9515","P9516","P9517","P9529","P9530","P9540","P9542","P9547","P9560","P9565","P9576","P9583","P9590","P9596","P9605","P9611","P9630","P9633","P9638","P9639","P9645","P9657","P9666","P9672","P9689","P9693","P970","P9705","P9711","P9718","P9719","P9723","P9727","P9752","P9785","P9790","P9804","P9824","P9833","P9834","P9860","P9861","P9869","P9872","P9874","P9891","P9894","P9895","P9896","P9902","P9923","P9924","P9930","P9931","P9933","P9953","P9960","P9974","P9978","P9987","P9990","P9991","P9992","P9998")
and page_namespace=120
group by page_title;
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...
