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
 |format=table
 |limit=50
 |offset=500
 |sort=
 |order=asc
 |mainlabel=-
}}

Results 501 – 550 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.1253",
    "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
500

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	2172		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
Cubic Zirconia	23 June 2083
Cultivation Crisis	30 April 2082
Cut and Crush	25 February 2081
Cut to the Chase	28 August 2082
Cutproof?	18 August 2082
Cutting It Close	28 January 2082
Cutting Teeth	30 June 2081
Cutting off the supply	3 September 2082
Cyber-Who? Cyber-Where?!	22 July 2081
Cyborg Envy	3 May 2082
D-EVO-LUTION	11 April 2081
D-UP	21 May 2081
DJ Samurai	19 August 2082
Daily Cardio	27 September 2082
Dainty Delicate Digits	27 April 2081
Dance among the Fading Memories	11 August 2082	When You Reach Me
Danzing with a Dragon - the Movie	22 July 2083	Artifact hunt
Daring Escape from Deutschland!	6 August 2084
Dark Heart News	11 May 2081
Dark Horse	30 December 2078
Data For Thieves	25 January 2081
Data Jacking	13 March 2082	Two Steps Ahead
Data gambling	19 September 2082
Dave's BBQ	31 October 2082
Dawn	1 December 2078
Dawntrail	24 September 2084	And Love You Shall Find
Day Drinking, My Favorite Hobby	16 March 2085	KAPTAIN KILLDOZER's Revenge
Dazed & Confused	30 October 2083
Dead On Arrival	12 April 2083	The Wailing of the Walled City
Dead and Deader	20 May 2082	Temple in the Shadows
Dear Helena	1 March 2085
Death of a Legend	18 December 2080
Deck The Halls	24 December 2078
Decker's Delightful Dealership	3 November 2082
Deer Dance	16 May 2081
Deimos' Initiation	19 March 2081
Deliver A Package	29 August 2082
Denial of Service Attack	22 November 2083	The Life and Times of One Kevin Crimes
Depleted Resources	23 January 2082
Derezzing the Dead Zone	15 January 2084
Dernier Saut sur l'Enfer	24 June 2082	Hail to the Pumpking
Detective Denouncement	31 May 2084
Dethroning the Dissonant	10 May 2082
Detour to Phoenix	2 January 2084
Deus Est Cammaros	2 December 2083
Devil's Bargain	23 December 2078
Diamonds Are Forever	26 July 2081
Diggin'	15 November 2084
Digging out Roots	19 September 2082	A Scattering of Deadly Petals
Digital Dark Age	27 January 2082	The Cutter's Curator

Semantic search

Query log

Navigation menu

Search