User:Certes/Reports/R from sort name
Redirects from Surname, Forename where the target may not be a person, based on quarry:query/80174
{{Database report
|sql=
SELECT Pr.page_title AS Redirect, Pa.page_title AS Target
FROM linktarget
JOIN templatelinks ON tl_target_id=lt_id AND tl_from_namespace=0
JOIN redirect ON rd_from=tl_from AND rd_namespace=0 AND rd_title REGEXP "^[^\\W_]+_[^\\W_]+$" AND rd_title NOT REGEXP "^(The_{{!}}\\d{4}_{{!}}List_of_)"
JOIN page Pa ON Pa.page_namespace=0 AND Pa.page_title=rd_title
JOIN page Pt ON Pt.page_namespace=1 AND Pt.page_title=rd_title
LEFT JOIN categorylinks CLa ON CLa.cl_type="page" AND CLa.cl_from=Pa.page_id
AND CLa.cl_to REGEXP "Living_people{{!}}_births{{!}}_deaths{{!}}[Cc]haracter{{!}}eople{{!}}[Dd]isambiguation{{!}}name{{!}}century{{!}}[Pp]seudonym"
LEFT JOIN categorylinks CLt ON CLt.cl_type="page" AND CLt.cl_from=Pt.page_id
AND CLt.cl_to REGEXP "[Bb]iograph[iy]"
JOIN page Pr ON Pr.page_id=tl_from AND Pr.page_namespace=0 AND Pr.page_title REGEXP "^[^\\W_]+,_[^\\W_]+$"
AND Pr.page_title = REGEXP_REPLACE(Pa.page_title, '^(.*)_(.*)$', '\\2,_\\1')
WHERE lt_namespace=10 AND lt_title="R_from_sort_name" AND CLa.cl_from IS NULL AND CLt.cl_from IS NULL
ORDER BY Redirect, Target
|wikilinks=1,2
|excerpts=
|comments=
|interval=
|table_style=
|pagination=
|max_pages=
}}
| class="wikitable sortable" style="overflow-wrap: anywhere" |
| scope="col" | Redirect
! scope="col" | Target ! scope="col" | Notes |
|---|
| Golder, David
| Title character |
| Golovin, Maria
| Title character |
| Grimes, Peter
| Title character |
| Grogan, Tom
| Title character |
| Gunasekera, Frank
| Actual person |
| Gunn, Peter
| Title character |
| Harum, David
| Title character |
| Hastings, Frank
| Title character |
| Hatley, James
| Title character |
| Hebert, Thomas
| Name of a ship (origin unclear) |
| Hero, Stephen
| Title character |
| Hippie, Harry
| Title character |
| Honai, John
| Title character |
| Hufkens, Xavier
| Company named for founder |
| Hugglemonster, Henry
| Title character |
| Iredale, Peter
| Ship named for person |
| Irlam, James
| Company named for founder |
| Isnard, Paul
| Company named for founder |
| Kelver, Paul
| Title character |
| Ketland, Thomas
| Company named for founder |
| Kilian, Joseph
| Title character |
| Knott, Alice
| Title character |
| Labo, Maria
| Title character |
| Lammie, Andrew
| Title character |
| Lassale, Jean
| Company named for founder |
| Lefevre, William
| Company named for founder |
| Longden, Eric
| Company named for founder |
| Lourds, Thomas
| Title character |
| Lukes, Martin
| Title character |
| Maass, Oliver
| Title character |
| MacBrayne, David
| Company named for founder |
| Mack, Daniel
| Actual person |
| Macnab, John
| Title character |
| Magodaig, Joseph
| Actual person |
| Marslin, Arthur
| Actual person |
| Marston, Mary
| Title character |
| McBride, Arthur
| Title character |
| McCoskry, William
| Actual person |
| Miller, Herman
| Company named for founder |
| Minturn, John
| Name of a ship |
| Mondiola, Juan
| Title character |
| Moreland, Mary
| Title character |
| Morning, Martin
| Title character |
| Mullady, Henry
| Actual person |
| Mulliner, Arthur
| Company named for person |
| Munter, Harry
| Title character |
| Nickleby, Nicholas
| Title character |
| Nolan, Anthony
| Charity named for child |
| Nye, Nicholas
| Title character |
| Obdyke, Benjamin
| Company named for founder |
| Oudin, Charles
| Company named for person |
| Papoila, Maria
| Title character |
| Passant, George
| Title character |
| Paz, Martin
| Title character |
| Perret, Jean
| Company named for person |
| Pettinger, Peter
| Title character |
| Pietzschke, Paul
| Company named for person |
| Pillibi, Tom
| Title character |
| Plain, Mary
| Title character |
| Playfair, Tom
| Title character |
| Polainas, Juan
| |
| Poppins, Mary
| |
| Postlethwaite, James
| |
| Potts, Tom
| |
| Prime, Robert
| |
| Probsthain, Arthur
| |
| Punk, Peter
| |
| Quay, Bill
| |
| Quest, Martha
| |
| Quinn, Harry
| |
| R, Elizabeth
| |
| Rahauser, William
| |
| Raj, Michael
| |
| Remsen, Alice
| |
| Rest, William
| |
| Robb, Henry
| |
| Roop, Henry
| |
| Roumagnac, Martin
| |
| Salway, Joseph
| |
| Sands, David
| |
| Sarasqueta, Victor
| |
| Scarr, Henry
| |
| Schlegel, George
| |
| Scialac, Victor
| |
| Serf, Robert
| |
| Shoolbred, James
| |
| Shrinks, George
| |
| Sinukuan, Maria
| |
| Sion, Steve
| |
| Sloane, Martin
| |
| Smith, Herbert
| |
| Socman, John
| |
| Southard, Ellen
| |
| Specters, Harry
| |
| Stoke, Harry
| |
| Stone, Aaron
| |
| Strohm, Peter
| |
| Strong, Christopher
| |
| Stuarda, Maria
| |
| Swan, Thomas
| |
| Tamad, Juan
| |
| Tebbits, Ellen
| |
| Thornhill, Sarah
| |
| Thug, Tom
| Tom Thug | |
| Tracy, Ellen
| |
| Trogneux, Jean
| |
| Troy, Jonathan
| |
| Tudor, Maria
| |
| Turtle, Timothy
| |
| Uncle, David
| |
| Universe, Steven
| |
| Vran, Victor
| |
| Walker, Johnnie
| |
| Wave, Martin
| |
| Wheatley, Christopher
| |
| Whitby, Henry
| |
| Whites, Timothy
| Company named for founder |
| Whitlohn, Harry
| Fictional character |
| Wiggen, Henry
| Fictional character |
| Bara, Paul
| Company named for founder |
| Beale, Arthur
| Company named for proprietor |
| Bech, Henry
| Fictional character |
| Bihn, Tom
| Tom Bihn | Company named for founder |
| Bimba, Juan
| Fictional character |
| Cacao, Maria
| Fictional character |
| Chermayeff, Peter
| Company named for founder |
| Christian, Andrew
| Company named for founder |
| Clark, Matthew
| Company named for founder |
| Colmer, James
| Company named for founder |
| Corry, Harry
| Company named for founder |
| Cossar, William
| Ship named for person |
| Coventry, Sarah
| Namesake of company |
| Currey, James
| Founder |
| Curtis, Leonard
| Founder |
| Danger, Joseph
| Mythic figure |
| Dunston, Richard
| Founder |
| Dyas, Robert
| Founder |
| Eures, Robert
| Person |
| Fitzooth, Robert
| Fictitious identity |
| Foss, Arthur
| Ship named for person |
| Gaskin, Robert
| Name of a ship (origin unclear) |
| Gavanti, John
| Title of an album |
| Gibbs, Alexander
| Company named for founder |
| Wycliffe, Charles
| Fictional character |
----
{{Database report/footer|count=213|query_runtime=11.34|last_updated=01:08, 23 October 2024 (UTC)}}