Untitled query #2848

SQL

SELECT DISTINCT page_id AS pages_created FROM enwiki_p.page AS p INNER JOIN enwiki_p.revision AS r ON r.rev_page = p.page_id WHERE p.page_namespace = 0 AND p.page_title IN ("15th_Light_Horse_Regiment_(Australia)", "1st_Split_Partisan_Detachment", "2/10th_Battalion_(Australia)", "2/12th_Field_Regiment_(Australia)", "2/16th_Battalion_(Australia)", "2/2nd_Machine_Gun_Battalion_(Australia)", "2/6th_Battalion_(Australia)", "25th_Waffen_Grenadier_Division_of_the_SS_Hunyadi_(1st_Hungarian)", "26th_Waffen_Grenadier_Division_of_the_SS_(2nd_Hungarian)", "319th_Special_Operations_Squadron", "342nd_Infantry_Division_(Wehrmacht)", "427th_Aircraft_Sustainment_Group", "819th_Strategic_Aerospace_Division", "8th/13th_Victorian_Mounted_Rifles", "97th_Air_Refueling_Squadron", "Alby_Lowerson", "Alexander_Burton", "Battle_of_Ampfing_(1800)", "Battle_of_Haguenau_(1793)", "Battle_of_Kaiserslautern", "Battle_of_Neerwinden_(1793)", "Buttes_New_British_Cemetery", "Buttes_New_British_Cemetery_(New_Zealand)_Memorial", "Capture_of_Le_Quesnoy_(1918)", "David_Whitehead", "Edgar_Quinet-class_cruiser", "French_cruiser_Edgar_Quinet", "French_cruiser_Ernest_Renan", "French_cruiser_Waldeck-Rousseau", "German_cruiser_Prinz_Eugen", "Henry_Burrell_(admiral)", "Henry_Dalziel", "HMAS_Bataan_(I91)", "HMAS_Bungaree", "HMAS_Diamantina_(K377)", "HMAS_Durraween", "HMAS_Flinders", "HMAS_Gladstone_(J324)", "HMAS_Quiberon_(G81)", "HMAS_Quickmatch_(G92)", "HMAS_Stuart_(D00)", "Horrie_the_Wog_Dog", "Ilija_Trifunović-Birčanin", "Italian_cruiser_Calabria", "Italian_cruiser_Fiume", "Italian_cruiser_Pola", "Jack_Hinton", "James_Park_Woods", "June_1941_uprising_in_eastern_Herzegovina", "Kosta_Mušicki", "List_of_Australian_divisions_in_World_War_II", "List_of_cruisers_of_Germany", "Operation_All_Clear", "Operation_Sana", "Operation_Southern_Move", "Operation_Una", "Paraguayan_People's_Army_insurgency", "Patag_(sword)", "Patrick_Bugden", "Pećanac_Chetniks", "Robert_Beatham", "Royal_Australian_Army_Medical_Corps", "SMS_Kaiser_Karl_VI", "SMS_Scharnhorst", "SY_Ena", "Thomas_Axford", "Thomas_Price_(soldier)", "Velepromet_camp") AND r.rev_user_text IN ('Auntieruth55', 'AustralianRupert', 'Catlemur', 'Djmaschek', 'Ian Rose', 'Lineagegeek', 'Parsecboy', 'Peacemaker67', 'Tomobe03', 'Zawed') AND r.rev_parent_id = 0 AND r.rev_timestamp > '20140901000000' AND r.rev_timestamp < '20141001000000' ;
SQL

Checking query status...
