Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Public Contacts]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=3216)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
0
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=3216)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 1127 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | mediawiki_db.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneName | Profession | Archetype | Connection | Aspects | Faction | Active PCs with this Contact | Location | Metatype | Gender |
---|---|---|---|---|---|---|---|---|---|
"Adam" | Infobroker | Networking | 5 | Dirty Laundry Vipers' Nest White Hands, Black Tie Maybe Gonna Give You Up Toys of the Trade Blood Runs Thick Just for the Night Tastes Just Like Poison Varied Clientele | None | 0 | Seattle | Human | Male |
"CIA Bill" Cooper | CIA Handler | Custom (K,N,G,A) | 4 | Arm's Length Intelligence Community Company Man Military Intelligence Special Operations Cover Identity Q | CIA | 0 | Washington, FDC | Human | Male |
"Dirty" Hikari Sera | Joygirl/Noodle Stand Operator | Networking | 2 | Entrepreneurial Obligations Hungry people talk What people want Where to find Joy Pop-Up on Demand | 0 | Loveland, Puyallup, Seattle Metroplex | Elf | Female | |
"General" Dave | "General" | Service | 3 | Greatest Leader in Republic Of Dave Greatest Cook in Republic Of Dave International Affairs Micronations | Republic of Dave | 3 | Seattle, Redmond - Republic of Dave | Human | Male |
"Happy" Lombardo | Smuggler | Custom(G,K,N,A) | 4 | Hard to Reach Cautious Aloof The soldier swore like thunder He loved her more than plunder And shewed her many a scar, sir The freedom man was born to Like Eden, fruitful of its own accord Frail flesh gave way We who remain The first-fruit offering | 0 | Snohomish, Seattle | Human | Masculine (He/him) | |
"Lucky" Lucia Carina | Gambler | Custom(A,N,K,G) | 4 | Cursed Luck Lucky High Rolling Friends Poker Face Training Go-to for Laying Low Gambler, both High and Low Gourmand | Independent | 3 | Seattle, Downtown - Mystic Springs Penthouse | Human | Female |
"Philip" | Free Spirit | Legwork | 2 | Rambling Study Free Spirit Astral-Metahuman Interactions Knowledge is Power! Puyallup-Bound | N/A | 0 | Puyallup, Seattle Metroplex | Free Spirit | Male |
"Shokunin" Danill | Career Artist | Custom(A,N,K,G) | 6 | Blissfully Unaware Artisan sculptor SINner Consumer Grade Restricted Grade Gossip Personal guidance Invite entry | 0 | Seattle, Renton, Four lakes | Human | Female | |
"Wild Goose" | ID Manufacturer | Gear | 2 | SIN Forger License Forger Matchmaker | 5 | Seattle, Redmond Barrens | Elf (Nocturna) | Female | |
$p1keslinger | White-Hat Hacker | Custom(K,N,G,A) | 4 | Matrix Native Deep in the Weeds You'll Never Turn Me Yeah, I've been around. High and Mighty | None | 2 | Seattle | Human | Feminine (She/her) |
'Doc' Mortimer | Street Doc | Custom(G,A,K,N) | 5 | Biotechnologist Advanced 'Ware Black Market Pipeline Forbidden Gear Cybertechnologist Cyberlimbs | Ezekiel Martin's Smugglers | 8 | Seattle, Tacoma | Troll | Male |
'Princess' Rosemary | Celebrity | Service | 3 | In Hiding Royal Aura Entertainment star Gifted Bloodline Silver tongue and a Golden spoon Not in the Spotlight | 0 | Seattle | Elf | Female | |
3310 | Custom(A,K,N,G) | 3 | Too Spicy Grid Hopper Data Digger Brilliant Heuristics Analytical Mind Sisu Reprogrammer Corporate Insider | Alcatel-Nokia | 1 | Oulu, Finland | Human | Female | |
863 (Contact) | Ex-Neohaven Decker | Legwork | 1 | Decker Ex-NeoHaven | Ex-Neohaven | 1 | Human | Male | |
8ball | Decker | Service | 1 | Data hoarder Metahuman Interest | None | 1 | Seattle | Human | Male |
Aaron Knight | Journalist | Custom(K,N,A,G) | 4 | Quick to Anger Well Traveled Educated Live to Work Faces and Names Willing to Pay Night Owl | 1 | Seattle | Troll | Male | |
Abdul el-Aswan | Fixer | Fixer | 4 | More Metal than Man Former Buisness partners Bloodspray savant Lock and Load, Rinse, Repeat Steel Might Manhunter Honor Honored | 0 | Snohomish | Human | Male | |
Ace Powers | Horizon Talent Agent | Fixer | 6 | Musical Talent Corporate Deals Keep it Classy Fake SINs Insider Knowledge Horizon Agent Hired Muscle | Horizon HBI 48 | 9 | Seattle, Downtown | Human | Male |
Addison Keller | Networking | Networking | 2 | Vendetta: Ghost Cartels Caribbean League Citizen Hatred of the Syndicates | 1 | Seattle, Renton | Elf | Female | |
Adem Quel | Personal Driver | Service | 2 | Personal Driver Vehicles Your Vehicle | Silver Ash Private Investigations | 0 | Seattle | Elf Banshee | Male |
Adowa "Moria" Webster | DIMR Scientist | Fixer | 4 | Hermetic Mage Decker Nerd Draco Foundation Fixer Arcane-Archaeologist | Draco Foundation | 7 | Seattle | Troll | Female |
Agathon | Greek Cab Driver | Service | 1 | Greek Cabbie Port City Connections | 1 | Athens (Greece) | Minotaur | Male | |
Agustin Diaz | (un)Tortured Artist | Service | 2 | I'm an artist you know I'm kind of a big deal I bet you've never heard of it | Aztechnology | 0 | Seattle, Downtown | Human | Male |
Aidan Byrne | Fixer | Custom(G,K,A,N) | 2 | Damn thievin' dandelion eaters Aih' know my ways round' a cyberdeck Gotta' few decker buds, dey'll have somethin' IRA Ties Loveada' Musics | None | 0 | Renton, Seattle | Human | Male |
Ailbe O'Maly | Bounty Hunter | Legwork | 2 | Mystic Adept Combat the Infection The ol' Irish Hospitality | Take Back the Night | 0 | Seattle Metroplex | Human | Female |
Aisee Yuunao | Rogue Surgeon AI | Service | 3 | Better Safe Than Sorry Digital Denizen Encyclopedic Anatomist Mechanical Mind Ripper Network | 0 | Southeast Snohomish | AI | Gender is fake. | |
Al Green | FBI agent | Legwork | 5 | Federal Investigator Baseball Fan Skeptical FBI Rising Star Stakeout Duty Anti-Terrorism Task Force | FBI | 4 | Seattle, Downtown | Elf | Male |
Alain "Al" Levant | Grassroots Organizer | Fixer | 3 | Radical Groups Street Savant Hungry People Talk Family Ties | Imagination Foundation | 0 | Toronto | Human | Male |
Alan | Escaped Prisoner in Hiding | Custom(A,K,N,G) | 3 | In Hiding Emerged Helping Hand | 0 | Abandoned Host | Unknown, | Unknown | |
Albert Costello | Psychiatrist | Fixer | 3 | Weapon Dealer Firearm Modifications Medicine and Medical Government/Military Information | 0 | Seattle, Redmond | Ork | Male | |
Alcatraz | Smuggler | Gear | 3 | Smugglers gotta Smuggle Hermetic Mage I don't know it, but I know someone who will "I think I know someone from that metaplanes. | 0 | Los Angeles | Elf | Male | |
Alejandro Contreras | Shamanic Talismonger | Gear | 3 | East Bay Shaman Talismonger United Talismongers Association | United Talismongers Association | 0 | San Francisco, Fremont | Human | Male |
Aleshanee Yoomee | Yakima Valley Museum Custodian Shaman | Service | 3 | Spirit Champion Shaman Raccoon Follower Night at the Museum Shaman's Code Aesop Raccoon Raiders | 0 | Goose Prairie, SSC or Yakima Valley Museum, Naches, SSC | Human | Female | |
Alessa P | Owner of The Daze | Fixer | 4 | The Daze Shadow Connections Ear to the Ground Punk Rocker Bootleggers | Streets of Redmond | 22 | Seattle, Touristville | Pixie | Female |
Alex "Good'ol" Samson | Fixer | Fixer | 6 | Money Laundry Haggler Word On The Street... Antiques I Know An Expert I Have A Bridge To Sell Ya! Debt Collector Loan Shark Take No Wooden Nickles | Streets of Redmond | 1 | Seattle, Redmond | Human | Male |
Alex Bernard | Pirate (Smuggler) | Service | 2 | Pirate of the Sea Syndicate Smuggler Los Angeles Local | 0 | Los Angeles | Elf | Male | |
Alexa Beasley | Green Grocer | Fixer(N,K,G,A) | 5 | The Grocer's Unofficial Leader Green Grocer It Fits in small containers This big box? Broccoli. An ear to the Shadows Unassuming Fixer | The Grocers | 1 | Bellevue | Human | Female |
Alexander Tyrell Gates | Microdeck CTO and Technoshaman | Generalist | 6 | Hard To Reach A Man of Principle Corporeal Anxieties Caped Crusader’s Creed Look For The Helpers Helping Hands Connection Established, Never Lost Technoshaman of the World Tree Wuxing-Forbes Ranked 707 Microdeck Reverse-Engineering First Toy A Cyberdeck Nuyen Is No Object Put Your Nuyen Where Your Mouth Is Siblings of the Matrix Child’s Play Consult The Tree ALTruistic To The End Help The Helpers | Microdeck | 0 | Seattle (Downtown) | Human | Male |
Alexander-James Brodrick Johnson III | CorpKid | Networking | 4 | Party all Night... What time is it? Everybody's Friend. Did Someone say Drugs? Brodie J IN THE HOUSE! Ride Wrecked? Brodie J's got it! Oh yeah! I have a job! Good looks, Money, and a savant-level understanding of rocket physics | Federated-Boeing | 12 | Seattle, Everett | Human | Male |
Alexey Dorosov | Vory Fixer | Fixer | 5 | Vory Networker More Machine Than Ork Armed To The Tusks Cybork Trog Networker Prototype Collector | Red Vory | 3 | Seattle, Redmond Barrens | Ork | Male |
Alfred Bester | UCAS Blackops | Custom(K,N,G,A) | 6 | Example Positive Aspect P12 Rating Shady Blackops The Corps is Mother, the Corps is Father Totally not a UCAS Officer | UCAS | 0 | Seattle, Everett | Human | Male |
Alfred Rockbell | Aztechnology Magical Researcher | Custom(K,N,A,G) | 2 | Blissfully Unaware Blood Mage Arcane Researcher Goes Hard Corporate Ladderclimber | Aztechnology | 0 | Seattle, Bellevue | Elf | Male |
Alias | SIN Forger | Gear | 5 | SIN Forger Police Contacts Disguise Enthusiast Hacker Infiltrator College Educated | 5 | Seattle, Downtown | Elf | Female | |
Alice "Pink" Herrington | Info Broker | Legwork | 3 | Stream Addict Info Dump Corp Password Collection Buyer Beware | Streets of Downtown | 2 | Seattle, Downtown | Human | Female |
Alice Kane | Cyber Surgeon | Fixer | 5 | Mechanic Info Broker Weapon Specialist Tech Savy Cyber Surgeon Gamer Grrl | 5 | Seattle, Kent | Elf | Female | |
Amadou Zheng | MCT's Magical Middle Manager | Fixer | 5 | All for the Bottom Line The Boss is the Boss Corpo Connections Wannabe Crime Lord Fell Through the Cracks Can't Spell "Smuggler" Without "Smug" Lawyer Up Livin' the Dream Eyes on the Prize, Not on the Bodies Not so Big Anymore | Mitsuhama Computer Technologies | 0 | Seattle, Bellevue | Elf | Male |
Amanda | Street Doc | Custom(G,A,N,K) | 3 | University Troll Incredible Precision I Know a Troll... Oh! Sorry - I didn't see you there! | Streets of Bellevue | 3 | Seattle, Bellevue - Amanda's Street Cyber | Giant | Female |
Amar "Bash" Ruano | Semi-Reformed Cyberpsycho | Service | 1 | Criminal SINner Slightly Unstable Go With What You Know Street Soldier Prep Work Natural Born Doorman | Hellraisers | 1 | Loveland | Orc | Male |
Amelia "Millie" Carter | Bartender/Waitstaff at the 'Bolt & Brew' | Custom(N,K,A,G) | 2 | Always Working She's for the streets An unspoken Union Like a fine wine Rumor Mill | 0 | Bolt and Brew bar | Human | Female | |
Amelia Novak | Urban Primitive | Service | 1 | The Beast Within Use Every Part | Skraacha | 2 | Seattle, Ork Underground/Tacoma | Ork | Female |