Template redirects with too high protection level (target level: ECP))

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

select
  replace(page_title,"_"," "),
  user_name,
  ug_group
from
  revision
  join page on rev_page = page_id
  join user on user_id = rev_user
  join user_groups on ug_user = rev_user
where
  rev_parent_id = 0
  and page_namespace = 0
  and replace(page_title,"_"," ") in (
  /* titles to test go here */
'1st Tank Division (Soviet Union)',
'1TV (Macedonian TV channel)',
'2nd Infantry Brigade (Lebanon)',
'A Cabinet of Curiosities (painting)',
'A Caprice',
'Adaptation (The Walking Dead)',
'After Darkness (2018 film)',
'Aina (Crete)',
'Ajax (ship)',
'Alacrity (ship)',
'Albert Jackson (mail carrier)',
'Albert Taylor (trade unionist)',
'Alexander Ross (cricketer)',
'Alfred Loomis (sailor)',
'Antony and Cleopatra (musical duo)',
'Arlington (band)',
'Arshad Sami Khan',
'Atomic (cocktail)',
'Azure (painting)',
'Bahar (raga)',
'Bald Eagle (clipper)',
'Begum (magazine)',
'Behind the Eight Ball (film)',
'Belfast East (Dáil constituency)',
'Belfast North (Dáil constituency)',
'Belfast South (Dáil constituency)',
'Belfast West (Dáil constituency)',
'Better Love (Katerine Duska song)',
'Biba (restaurant)',
'Big Book (award)',
'Bill Scott (bowls)',
'Black Bitch (TV series)',
'Black Day (South Korea)',
'Brinkworth (surname)',
'Broad Run (conservation area)',
'Bush (upcoming film)',
'Cabaret (2015 film)',
'Cabaret (2016 film)',
'Cabaret (2017 film)',
'Carlos Imperial (politician)',
'Carousel (band)',
'Central High School (Beaumont, Texas)',
'Ceres (1794 Calcutta ship)',
'Ceres (1800 ship)',
'Ceres (1802 ship)',
'Charles Eaton (1833 ship)',
'Charles Frazer (cricketer)',
'Chryse (Aeolis)',
'Chryse (Bithynia)',
'Chryse (Caria)',
'Chryse (Hellespont)',
'Chryse (Lesbos)',
'Chryse (Troad)',
'Coelia (gens)',
'Commitment (Monica song)',
'Concordia Lutheran Church (denomination)',
'Confluence (shopping mall)',
'Daniel Greenberg (author)',
'Daniel Wise (American football)',
'Danny Carroll (Kentucky politician)',
'David Campbell (comics)',
'David K. Thomson',
'David Rogers (North Carolina politician)',
'Destiny (2018 film)',
'DMAX (Turkey)',
'Doi (Curd)',
'Eduardo Herrera (Venezuelan footballer)',
'Edward Herbert Wright',
'Edward J. Barton',
'Ely (Cardiff electoral ward)',
'Epilogue (film)',
'Ernest Johnson (American football)',
'Espe (manor house)',
'Family Tree (Oh Land album)',
'Fanatics (group)',
'Fastlane (2019)',
'Father Damien (Escobar)',
'Firebase (U.S.-Afghanistan War)',
'Firebase (U.S.-Vietnam War)',
'Flotsam and Jetsam (album)',
'Fly by Night (TV play)',
'Fontanelle (comics)',
'Forever and a Day (novel)',
'Francisco José Alcaraz',
'Francis George Howard',
'Frank Beckett Lewis',
'Frank Campbell (bowls)',
'Frank Johnston (rugby league)',
'Franklin Pitcher Johnson jr.',
'Furie (film)',
'Garbage (film)',
'George Andrews (artist)',
'George Bennett (cricketer, born 1883)',
'George Foster Platt',
'George Henry Horton',
'George Washington (John Trumbull, 1790)',
'Geron (singer)',
'Glam (film)',
'Glen Burnie (Hopkinsville, Kentucky)',
'Grand Slam (video game)',
'Greatest Love (Ciara song)',
'Great Synagogue (Bila Tserkva)',
'Greg Lewis (Kansas politician)',
'Gus Johnson (comedian)',
'Gustaf Torsten Johansson',
'Hardcore (video game)',
'Heal (corporation)',
'Henry Barker (canon)',
'Henry O\'Brien, 8th Earl of Thomond',
'Henry Walter Wood',
'Henry Ward (artist)',
'Hot Pepper (1973 film)',
'Hougham',
'HUGE',
'IID (Imperial Institute of Design)',
'Imperialism (speech)',
'Insanity (ride)',
'IPad (2012)',
'IPad (2019)',
'Jalali (surname)',
'James Austin (American football)',
'James Drummond (chaplain)',
'James Hamilton (Archdeacon of Raphoe)',
'James Joseph Sheridan',
'James Weeks (artist)',
'Jimmy Jones (footballer, born 1919)',
'John Carr (cricketer, born 1892)',
'John C. West (philatelist)',
'John Franklin Moore',
'John Frederic Leary',
'John Hay (priest)',
'John Heath (cricketer, born 1978)',
'John James (administrator)',
'John King (lord of the manor)',
'John Marshall (bowls)',
'John McDermott (Scottish artist)',
'John Q. Ross',
'John Rae (minister)',
'John Storey Barwick',
'John Woodward (rugby league)',
'José Manuel Franco',
'Joseph F. Cooper',
'Joseph Taylor (wrestler)',
'Justin (gnostic)',
'Keeper of the Flame (Richie Cole album)',
'Keith Black (businessman)',
'Kenneth Jackson (sportsman)',
'Kenneth Victor Young',
'Lanes (song)',
'Larissa (Thrace)',
'La Voz (U.S.A.)',
'Lawrence Lewis, Jr.',
'Leave Me Lonely (Hilltop Hoods song)',
'Leonora (singer)',
'LIberty (sternwheeler)',
'LIght Year (Isakov song)',
'Line 14 (Xi\'an Metro)',
'LKG (2018 film)',
'Love Is Forever (Leonora song)',
'Luis P. Torres',
'Malang (film)',
'María Bruguera Pérez',
'Marion County Courthouse (Illinois)',
'Mark White (model)',
'Mary Mildred Williams',
'Mary Shipman Howard',
'Matt Roy (ice hockey)',
'Mian (tribe)',
'Michael A. Sutton',
'Michael G. Bailey',
'Michael Potter (minister)',
'Michael Spencer Jones',
'Ministry of Human Rights (Somalia)',
'Ministry of Internal Security (Somalia)',
'Missamma (soundtrack)',
'Mom (Earth, Wind & Fire song)',
'Mountain Dew (film)',
'Mount Parker (constituency)',
'Natalie Brown (author)',
'Natural elements',
'Necromancer (board game)',
'Needy (Ariana Grande song)',
'Notebook (2019 film)',
'Octopussy (adventure)',
'Omega (esports team)',
'Omega (The Walking Dead)',
'On Stage (radio show)',
'Patrick Patterson (rugby union)',
'Pedro Silva (footballer, born 1997)',
'Peekaboo (musician)',
'Peter D. Graves',
'Peter Waterhouse (military officer)',
'PGP (song)',
'Pinas (ship)',
'Possessed (TV series)',
'Powers (duo)',
'Pritam Kumar Singh',
'QUIN (Singer)',
'Rainbow (Kacey Musgraves song)',
'Ray Williams (bowls)',
'Reservoir (Gordi album)',
'Richard Benyon (author)',
'Richard Peck (British Army officer)',
'Río de Oro (Catatumbo)',
'Robbery (song)',
'Robert Barr (American football)',
'Robert Davies Roberts',
'Robert Dick (salt-grieve)',
'Robert J. McCarthy',
'Robert the Bruce (film)',
'Robert Traill (minister)',
'Romantic (architecture)',
'Ronald P. Clark',
'Roses (suit)',
'Ruff (album)',
'Salinas (surname)',
'Scum (Rat Boy album)',
'Seaman (name)',
'Sebastopol (album)',
'Shim (band)',
'Shine a Light (Bryan Adams album)',
'Shin Heike Monogatari(1972 TV series)',
'Siege (board game)',
'Simba (2018 film)',
'Sir Hugh Campbell',
'Sir Patrick Johnston',
'Sister (S!sters song)',
'Son of Man (album)',
'Sooner or Later (GF4 song)',
'Southern Comfort (Conway Twitty album)',
'Special (TV series)',
'Spectrum (group)',
'Spitting Image (Strypes album)',
'Stadionul Municipal (Odorheiu Secuiesc)',
'Stephen Lee (bishop)',
'Stephen White (priest)',
'Steve Harrison (ice hockey)',
'Strange Creatures (album)',
'Substitute (French elections)',
'Susan Cooper (producer)',
'Test Pilot (cocktail)',
'The Attack (TV play)',
'The Chatham',
'The Courier (upcoming film)',
'The Dangerous Summer (The Dangerous Summer album)',
'The Fellowship of the Ring (board game)',
'The Final Call (TV series)',
'The Flight (band)',
'The Friend (film)',
'The Furies (band)',
'The Great (miniseries)',
'The Green-Eyed Monster (2001 film)',
'The Misfits (upcoming film)',
'The Moderate Party (Ireland)',
'The Quin',
'The Revolver',
'The Secret (Alan Parsons album)',
'The Sisters (painting)',
'Thomas Bruce (priest)',
'Thomas Smith (Registrary)',
'Thomas Wyndham (clergyman)',
'Touched (2017 film)',
'Toy (A Giant Dog album)',
'Tristan (musician)',
'Underrated (album)',
'Untouchable (2019 film)',
'Uprising (video game)',
'Valley Girl (upcoming film)',
'Violin Concerto No. 4 (Schnittke)',
'Virginal (Shouta Aoi song)',
'Walter Ross Taylor (1838–1907)',
'Waterworks (Hollis)',
'Wayne Smith (rugby league)',
'William Coates (technician)',
'William Duckett (died 1749)',
'William Evans (cricketer, born 1897)',
'William Fletcher Shaw',
'William J. Day',
'William Johnston Thomson',
'William L. Sims II',
'William Thorne (philatelist)',
'William Washington Williams',
'William Watts (translator)',
'William Webb (cricketer, born 1898)'
  );
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...
