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: [[Category:Runs]] [[HasMetaplot::+]]
 |?=Name
 |?HasDate=Date
 |?HasMetaplot=Metaplot(s) Run is Part of
 |?HasGM=GM
 |format=table
 |limit=50
 |offset=20
 |sort=
 |order=asc
 |mainlabel=-
}}

Results 21 – 70 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Runs]] [[HasMetaplot::+]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1288",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Runs]] [[HasMetaplot::+]]

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 t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=3330
   AND (t4.p_id=2973)
  )
  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
20

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t4	ref	s_id, p_id, s_id_2, s_id_3	p_id	4	const	827	Using index; Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	s_id_2	9	mediawiki_db.t4.s_id, const	1	Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	mediawiki_db.t4.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:2
Query-Depth:1

Errors and Warnings

None

Name	Date	Metaplot(s) Run is Part of	GM
A Lil' Legwork Never Killed Anyone	6 August 2082	A Taint On Us All	Si1as
A Little Doll's Dream	2 June 2081	String Theocracy	Pillare
A Little Pro Bono Work	24 May 2081	God Save the Queen	Kryosite
A Night On The Slopes	10 August 2080	What Fate Weaves	Tekomandor
A Night Under the Stars	19 August 2082	By Royal Decree	Archtmag
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!	17 February 2081	Adversaries	DocMcGuffin
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!	7 May 2081	Adversaries	DocMcGuffin
A Rain of Really Repulsive Renraku Reinforcements	26 April 2082	Head In A Jar	Aurora
A Roof Over Our Heads	25 July 2081	The Farm and The Furious Home is where the heart is	Crimson
A Run based on Stick and Poke's Remember Me when you Sing	7 July 2080	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	DrBurst
A Sea Of Opportunities	2 June 2082	The Cradle Of Betrayal	Scranton
A Shadowrun Based on Big D and the Kids Table's LAX	25 May 2080	Unwanted Evolution - A Punk Rock Tour	DrBurst
A Shadowrun Based on Charge Into the Sun by The Briggs	26 October 2080	Never Again	Drburst
A Shadowrun Based on Crywank's A Soreness So Familiar It Soon Becomes Unquestioned	6 May 2081	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	Burst
A Shadowrun Based on Into The Night by Firkin	7 August 2080	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	DrBurst
A Shadowrun Based on Multiple Songs from the Album Now You Are One of Us by The Paper Chase	15 September 2080	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	DrBurst
A Shadowrun Based on Poison by Stick and Poke	7 September 2080	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	DrBurst
A Shadowrun Based on Rock Plaza Central's Anthem For The Already Defeated	1 June 2080	Unwanted Evolution - A Punk Rock Tour	DrBurst
A Shadowrun Based on Set Your Goals' This Will Be The Death Of Us	1 June 2080	Unwanted Evolution - A Punk Rock Tour	DrBurst
A Shadowrun Based on Stick and Poke's Running	18 June 2080	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	DrBurst
A Shadowrun Based on The Paper Chase's We Will Make You One of Us	24 April 2080	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	DrBurst
A Shadowrun Based on The Paper Chase's You Will Never Take Us Alive 3	4 May 2080	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	DrBurst
A Shadowrun Based on The Paper Chase's You Will Never Take Us Alive 4	4 May 2080	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	DrBurst
A Shadowrun Based on Weary Traveller by Stick and Poke	7 September 2080	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	DrBurst
A Six Hour Tour	28 June 2081	Adversaries	Ghostlin
A Taste of One's Own Medicine	11 November 2082	In Remembrance	Sarcarian
A Treatise on the Logistics of Farming and Land Management	15 May 2081	The Farm and The Furious	Atlatl
A Walk in the Woods	16 July 2081	String Theocracy	Pillare
A Wolf In Wolf's clothing?	6 January 2085	Trophäenjagd	Bulldogc
A bulwark against the insects	20 April 2083	Enemy within	Aurora
A nice walk in the woods	21 November 2082	Enemy within	KaterSalem
A slightly rainy day in Kansas	20 October 2084	Swarming Season	Lotus
A tail of rats and bombs	26 July 2084	The Life and Times of One Kevin Crimes	TidanShock
AC/DC - Thunderstruck	9 February 2080	Dance Around The Fire That We Once Believed - The Ex-Firewatch Story	DrBurst
ACHEy Breaky Bones	20 February 2082	Deus Machina	Aurora
Aching & Festering	11 April 2082	Festering Infestation	Asmodeus
Adversaries: Night at the Museum	1 June 2081	Adversaries	Doc McGuffins
Agassou's Blessing	6 August 2082	Orichalcum Traitors	Tekomandor
Agency Agency	26 June 2081	The Life and Times of One Kevin Crimes	OB
Aggressive Research	24 January 2081	New Job	Teksura
Air America	22 June 2081	The Farm and The Furious	Atlatl
All I Want for Christmas is K-10	23 December 2081	It's Always Wednesday in Seattle	Sarcarian
All In A Daze Work	12 April 2081	Shadow Heroes	mudge
All Our Days	27 June 2081	String Theocracy	Pillare
All Paths Lead to Yellowstone	25 June 2082	Hail to the Pumpking	Asmodeus
All You Need Is Kill	24 November 2078	All You Need Is Love For Your Eyes Only	mitsayantan
Among Us	8 November 2083	The Crow of Seattle	Asmodeus
An AI-Generated Shadowrun	31 January 2084	The Arrival	Asmodeus
An Undergound Robbery	15 September 2082	Baker Wars	Aurora
An average Ohio extermination	26 October 2084	Arma Ex Machina	TidanShock

Semantic search

Query log

Navigation menu

Search