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]]
 |?=Name
 |?HasDate=Date
 |?HasMetaplot=Metaplot(s) Run is Part of
 |?ThreatLevel=Threat Level
 |?HasGM=GM
 |?HasRunner=Runners
 |format=table
 |limit=50
 |offset=520
 |sort=
 |order=asc
 |mainlabel=-
}}

Results 521 – 570 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Runs]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1770",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Runs]]

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=3330)
  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
520

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	2168		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:1
Query-Depth:0

Errors and Warnings

None

Name	Date	Metaplot(s) Run is Part of	Threat Level	GM	Runners
Data gambling	19 September 2082		Low	Doc Mnc	Hound Canter 8133D3R
Dave's BBQ	31 October 2082		Deadly	Aurora	Nora Inu Voiceless Rhicter Hatano Mori Dr. Lollipop
Dawn	1 December 2078			ryncewynde88	Voxel Cyber Knight Fylgja =SUM
Dawntrail	24 September 2084	And Love You Shall Find	High	Fangblade_	Bumble Setter (Kanin) Red Ribbon Foxy Grampa
Day Drinking, My Favorite Hobby	16 March 2085	KAPTAIN KILLDOZER's Revenge	Low	Dawnfire	Ducky Muelsyse
Dazed & Confused	30 October 2083		Medium	Asmodeus	Fluster
Dead On Arrival	12 April 2083	The Wailing of the Walled City	Deadly	Brock	La Rapide Shy Gigabite Crazy Hoof
Dead and Deader	20 May 2082	Temple in the Shadows	Semi-Prime	Aurora	La Rapide Swerve
Dear Helena	1 March 2085		High	Asmodeus	Kadō Silver Lining Frieren
Death of a Legend	18 December 2080			danthestep	Paladin Stormcrow Kost Dr.Trauma
Deck The Halls	24 December 2078			SadSuspenders	Maddox Booker Ray Nero
Decker's Delightful Dealership	3 November 2082		High	Aurora	Grasshopper Hare Trigger Poppy Hatano Mori
Deer Dance	16 May 2081			Video	Riot Rasputin Sc4rl3tt DocSwagon
Deimos' Initiation	19 March 2081			DrBurst	Deimos Doctor Marvel
Deliver A Package	29 August 2082		High	Tekomandor	Canter
Denial of Service Attack	22 November 2083	The Life and Times of One Kevin Crimes	Deadly	Asmodeus	4NG3L Nu11st@ck Snowman
Depleted Resources	23 January 2082		Semi-Prime	Sarcarian	"Dandy" Dale Hardin Frag Face Vichnozeleny 0-K Skimmer
Derezzing the Dead Zone	15 January 2084		Deadly	Asmodeus	Heart of the Tempest Lumina 4NG3L
Dernier Saut sur l'Enfer	24 June 2082	Hail to the Pumpking	Hiigh	Asmodeus	Shy
Detective Denouncement	31 May 2084		Extreme	OrionsRequiem	Delphi
Dethroning the Dissonant	10 May 2082		High	Aurora	Sp4rks Master Morty Ca1yps0 Pulse
Detour to Phoenix	2 January 2084		Medium	Draknic	Mojo Joe Broken-Hand Zahhak Ez-Azael Nearl
Deus Est Cammaros	2 December 2083		Deadly	Eva	Rurosha Jane Excalibur Bulldozer
Devil's Bargain	23 December 2078			mitsayantan	Marionette Saludo Liquid Y3
Diamonds Are Forever	26 July 2081		Medium	BardInATavern64	Shimmer Itako Cyber Snake
Diggin'	15 November 2084		High	Fangblade_	Bunny Hop Cinders Panda Sojourner
Digging out Roots	19 September 2082	A Scattering of Deadly Petals	Medium	Dejapes	Glamor Voiceless Rurosha Genji
Digital Dark Age	27 January 2082	The Cutter's Curator	Medium	Sarcarian	Pell Charon Rewired Tripp Entropy Toughie
Dimensionless Numbers in Everyday Life	28 February 2085		Medium	John	Mojo Joe Priestess Shredder
Dining and Dashing	11 February 2085		High	Archtmag	Oberon Lappland Raum
Dinnae Steal from a Dwarf!	24 June 2083		High	Eva	Rurosha Canter Jane Excalibur Waldgeist Chipset
Dire Intervention	26 January 2082	Festering Infestation	Medium	Asmodeus	Delphi Tahki Entropy
Directing the fury	10 December 2078			Ridlez	Booker Kilbo Mister Sarcarian
Dirty Little Secret	23 May 2081	Suffer the Children		Ghostlin	Kost John from IT Canter
Disassembling & Cutting Supply Lines	23 May 2085		High	Asmodeus	Trades
Disassembling the Foodchain	7 May 2085		High	Villiers	Thunder Trauma Trades
Divided Assets	16 July 2084	It's a Small Underworld After All	Moderate	Kirk	Shugi Count of Three Alkaios the Cretan JuJu Ka$hious
Doctor Alcome	28 February 2079			West	Akula 8bit Queen
Does This Look Infected?	4 November 2081		Medium	Sarcarian	Charon Nitro Nogitsune Seven
Dog Days are Over	25 January 2085		Medium	Discogoblin	Frieren Honeypie
Doggo Run	10 December 2078			SilithDark	Vergil Kilbo Alias Nova Yokai (Dusk)
Dogs vs Cats	7 April 2081	God Save the Queen		Doc	Frag Face John Brown La Rapide Skylark
Don of a New Era	24 November 2081		Low	Mudge6	Flyboy Delphi Skimmer Sp4rks
Don't Copy That Floppy	9 September 2079			mudge	Knox Light Marster Samuro
Don't Fear The Yokai	1 January 2084		Deadly	Asmodeus	Katherine Tyler Blackhawk
Don't Kick The Anthill	2 September 2083	No Legion But Still Deadly	Semi-Prime	Aurora	Marionette La Rapide Turm Falke Heart of the Tempest Crazy Hoof Chipset
Don't Mess with Raccoons, Either	30 March 2083		High	Eva	Rougarou La Rapide Heavy Ordnance Drop Dead Gorgeous Lappland
Don't Threaten Me With a Good Time	12 October 2081		Medium	SedatedAlice	Rambozo The Clown Rougarou Relay Zephyr Delphi
Don't Wine About It	3 February 2082		Low	TheFrozenMoogle	Charon Delphi Oathbane Sp4rks
Don't mess with a sergeant's daughter	29 December 2083		Deadly	Zerre	Bumble Waldgeist Lurker

Semantic search

Query log

Navigation menu

Search