Semantic search

This page or action requires Javascript to work, please enable Javascript in your browser or use a browser where this is supported so that functionality can be served and is provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

Condition

Printout selection

Options

Parameters [+]

limit:

The maximum number of results to return

offset:

The offset of the first result

link:

Show values as links

headers:

Display the headers/property names

mainlabel:

The label to give to the main page name

intro:

The text to display before the query results, if there are any

outro:

The text to display after the query results, if there are any

searchlabel:

Text for continuing the search

default:

The text to display if there are no query results

class:

An additional CSS class to set for the table

transpose:

Display table headers vertically and results horizontally

sep:

The separator between results

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: <q>[[Category:Runs]] [[HasRunner::Trash Panda]] OR  <q>[[HasRunner::Howler]]</q>  OR  <q>[[HasRunner::Good Boy]]</q>  OR  <q>[[HasRunner::Riot]]</q>  OR  <q>[[HasRunner::Wildman]]</q>  OR  <q>[[HasRunner::Hot Mess]]</q> </q>
 |?=Name
 |?HasGM=GM
 |?HasMetaplot=Metaplot
 |?HasDate=Date of Run
 |?HasRunner=Team
 |format=table
 |limit=50
 |offset=1
 |sort=
 |order=asc
 |mainlabel=-
 |default=No runs yet. This list will auto-populate when this character is tagged in a run AAR.
}}

Results 2 – 51 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Runs]] [[HasRunner::Trash Panda]] OR  [[HasRunner::Howler]]<\/q>  OR  [[HasRunner::Good Boy]]<\/q>  OR  [[HasRunner::Riot]]<\/q>  OR  [[HasRunner::Wildman]]<\/q>  OR  [[HasRunner::Hot Mess]]<\/q> <\/q>",
    "query_source": "SMWSQLStore",
    "query_time": "0.1510",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Runs]] [[HasRunner::Trash Panda]] OR [[HasRunner::Howler]] OR [[HasRunner::Good Boy]] OR [[HasRunner::Riot]] OR [[HasRunner::Wildman]] OR [[HasRunner::Hot Mess]]

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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
1

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ALL	PRIMARY				132		Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	mediawiki_db.t1.id	1		Using where

Auxilliary Tables

Temporary table t1
  INSERT IGNORE INTO `t1` SELECT DISTINCT t3.s_id FROM `smw_fpt_inst` AS t3 INNER JOIN `smw_di_wikipage` AS t5 ON t3.s_id=t5.s_id WHERE t3.o_id=3330 AND (t5.p_id=3611 AND t5.o_id=2788)
  INSERT IGNORE INTO `t1` SELECT DISTINCT t8.s_id FROM `smw_di_wikipage` AS t8 WHERE t8.p_id=3611 AND t8.o_id=3758
  INSERT IGNORE INTO `t1` SELECT DISTINCT t11.s_id FROM `smw_di_wikipage` AS t11 WHERE t11.p_id=3611 AND t11.o_id=4013
  INSERT IGNORE INTO `t1` SELECT DISTINCT t14.s_id FROM `smw_di_wikipage` AS t14 WHERE t14.p_id=3611 AND t14.o_id=4038
  INSERT IGNORE INTO `t1` SELECT DISTINCT t17.s_id FROM `smw_di_wikipage` AS t17 WHERE t17.p_id=3611 AND t17.o_id=4169
  INSERT IGNORE INTO `t1` SELECT DISTINCT t20.s_id FROM `smw_di_wikipage` AS t20 WHERE t20.p_id=3611 AND t20.o_id=3780

Query Metrics

Query-Size:13
Query-Depth:1

Errors and Warnings

None

Name	GM	Metaplot	Date of Run	Team
24K Magic (Hell's Kitchen)	Purkinje		12 October 2080	C-Unit 537 - Hunter Cryo Howler
404 Error	Aurora	Deus Machina	16 May 2081	Howler Janitor Dan La Rapide Wild Bull Woman From Another Place
A Crisp Taste of Christmas	danthestep		28 December 2080	Trash Panda Evans Doyle Stormcrow Hybrid
A Portal Opened Up in My Mansion, so I Hired Some Shadow Runners to Deal with the Demon that is Causing this Massive Problem in My Life!	DocMcGuffin	Adversaries	17 February 2081	Night Claws - John Holis Trash Panda Rapture Maek Ikari
A Portal Opened Up in My Mansion, so I Hired Some Shadow Runners to Deal with the Demon that is.. Wait didn't we do this run already? There's no way this is just to make the title longer!	DocMcGuffin	Adversaries	7 May 2081	Trash Panda Rapture Ikari Twitch Click
A Shadowrun Based on Weary by Mal Blum	DrBurst		26 October 2080	Frag Face Howler Stormcrow Fletchette
A Shudder of Clowns	Aurora		14 May 2081	Howler Twitch Phantom Drifter Aristotle
A Special Package	danthestep		20 November 2080	Kera Night Claws - John Holis Howler Selena Warlock
A Taste of Corruption	Darklordiablo		2 January 2081	Trash Panda Spider Captain Boomerang Dr-Boo Boom Poom
A Wild Extraction	danthestep		24 December 2080	Trash Panda Tanuki Neko Stalker
A prequel to multiple Shadowruns based on Flags and Concrete by Larry and His Flask	DrBurst		16 November 2080	Night Claws - John Holis Purkinje Howler
Adversaries: Night at the Museum	Doc McGuffins	Adversaries	1 June 2081	"Dandy" Dale Hardin Trash Panda Moth Twitch Flow
Agency Agency	OB	The Life and Times of One Kevin Crimes	26 June 2081	Vergil Good Boy Indus
All In A Daze Work	mudge	Shadow Heroes	12 April 2081	Good Boy Gh0st Mendacius Tobias
Axemas Chaos	Darklordiablo		25 December 2080	Dolos Dr.Trauma Good Boy Calypso Setback
Back With A Vengeance	Gravity	Sweet Sweet Revenge	18 June 2081	Hot Mess Sinister Roadie
Bazaar Blitz	Zombono		18 June 2081	Blue Streak Wildman Santesso Doris
Beer Run	Malyc		12 December 2080	Deimos Jezebel Kost Riot
Before they are lost to us	Darklordiablo	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	30 November 2080	Paladin Trash Panda Evans Doyle Shark
Bottom of The Beautiful Briny	Chrisst111	Runners Gone Wild	12 August 2081	Trash Panda Roadie Ironclad Rigs
Bunraku Blues	Otter		4 June 2081	Ice Cube Hot Mess Flyboy La Rapide
Byter	Mach Ten	Crouching Dragon, Hidden Tiger	2 November 2080	Paladin Dokkaebi Dolos Yata Howler Eyes Stormcrow
CALLING ALL HEROES: The Horror Before Christmas	DocMcGuffin	Shadow Heroes	23 December 2080	Trash Panda Frag Face CAPTAIN FREEFALL Spider Crusader
Calling All Heroes! Hellraiser	DocMcGuffin	Shadow Heroes	4 March 2081	Trash Panda Kani Granuaile Esper Rasputin
Carmilla's Debutante	Doom	Coronation	16 February 2081	Night Claws - John Holis Trash Panda Kitsune Stygian Viper
Code 8	Doc McGuffin	Adversaries	24 May 2081	Trash Panda Setback Moth Twitch Hydro
Coffee Run	Aurora		19 December 2080	Cheshire Jezebel Tunguska Wildman
Competitive Intelligence	tkul	Killer A.P.P.	8 March 2081	Night Claws - John Holis Hot Mess Mush
Cut and Crush	OptimismBeast		25 February 2081	Good Boy Desdinova Mickey
D-UP	Pillare		21 May 2081	Kost Good Boy Setback Sinister
Dainty Delicate Digits	Doom		27 April 2081	Night Claws - John Holis Trash Panda Wild Bull
Data For Thieves	Divergent0		25 January 2081	Dolos Rabbit Yata Hot Mess
Deer Dance	Video		16 May 2081	Riot Rasputin Sc4rl3tt DocSwagon
Down the Rabbit Hole	SedatedAlice		20 June 2081	Usagi Tanuki Riot Jenny Glitz
Drone Catcher	danthestep	New Job	2 January 2081	Paladin Howler Stormcrow Neko Dr-Boo
Drug Resupply in the Fallen's Land	JD		25 March 2081	Trash Panda MK Kara Burn0ut
Emerald Kitty Blues	Kryosite	God Save the Queen	3 May 2081	Trash Panda Twitch Skylark Troika
Entomologist's Cookbook	Darklordiablo	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	22 November 2080	Paladin Trash Panda Slink Purkinje
Everything Must Go in 60 Seconds	Malibi		1 February 2081	Good Boy Itztli Witch Of Bones Twitch
Filling Coffers	Doom	Coronation	31 January 2081	Paladin Night Claws - John Holis Trash Panda Kani Glamor Stygian
First and Last Time	Eye of the Storm		25 April 2081	Evans Doyle Riot Chop Shop Turul La Rapide Payday
Forget the Cage, We Know How to Make the Key	Ghostlin	Adversaries	31 July 2081	Riot Captain Boomerang Flak
Free cruise for you and your friends; a Christmas vacation for runners	DocMcGuffin		22 December 2080	Night Claws - John Holis Riot Hybrid Setback
Get Em' High	Pillare		4 May 2081	Trash Panda La Rapide Moon Jelly Gunner Smith (Huntsman)
Gotta Get the Cash	Pillare		18 April 2081	Purkinje Howler Pack Sinister
Great at Crime	Pillare	A Matter of Multiple Engagements	18 May 2081	Trash Panda Twitch Itako
Grimm Woods	Doom		26 January 2081	Kera Paladin Wildman
Heart of Stone	ArcaneFuror		21 June 2081	Trash Panda Pell John Brown
Heathers	DocMcGuffin		2 March 2081	Riot Valet Chop Shop Mendacius
Heaven is a Place on Earth	Ghostlin		1 August 2081	Kost Good Boy Flyboy Ironclad

Semantic search

Query log

Navigation menu

Search