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=100
 |offset=20
 |sort=hasDate
 |order=desc
 |mainlabel=-
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Runs]] [[HasMetaplot::+]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0812",
    "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, t8.o_sortkey
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
INNER JOIN
`smw_di_time` AS t8 ON t0.smw_id=t8.s_id
WHERE
(t2.o_id=3330
   AND (t4.p_id=2973)
  )
   AND (t8.p_id=1621)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t8.o_sortkey DESC
LIMIT
105
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	821	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
1	SIMPLE	t8	ref	s_id, p_id, p_id_2, s_id_2	s_id_2	8	mediawiki_db.t4.s_id, const	1	Using index

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
1.1 1-one6away.caf	2 March 2085	An Anhedonic Code	Fangblade_
El Diablo Cazador De Hombres	2 March 2085	Meatgrinder	Asmodeus
RATS A Night at The Opera	27 February 2085	All The World's a Stage	Villiers
Rapunzel, Rapunzel, Let Down Your Bear	23 February 2085	Compound Interest	Sleevey
Race To The War	20 February 2085	Meatgrinder	Asmodeus
Spray, Pray, and Co-Pay	17 February 2085	Compound Interest	jit
Chain Mail	10 February 2085	La Famille Du Peintre	Sleevey
Johnfidence	6 February 2085	Yorshka Val'bane's Sky-high Wild Ride	Fangblade_
Belle nuit, ô nuit d'amour	4 February 2085	The Opera House Slasher	Dawnfire
Outsider Trading	27 January 2085	Compound Interest	Sample Text
Budding Heavenseeker	26 January 2085	The Name of Heaven	Sleevey
Shakedown Breakdown	16 January 2085	Compound Interest	jit
Stars Long Dead	15 January 2085	The Light Before We Land	Fangblade_
Who's A Good Boy?	13 January 2085	The Crow of Seattle	Asmodeus
Hic Svnt Leones	13 January 2085	The Light Before We Land	Fangblade_
Third-Story Malpractice	11 January 2085	La Famille Du Peintre	Sleevey
A Wolf In Wolf's clothing?	6 January 2085	Trophäenjagd	Bulldogc
Guerilla Gangoons	3 January 2085	The Arrival	Asmodeus
Redmond Rage	31 December 2084	Compound Interest	Sample Text
RATS in The Barrens Part I	30 December 2084	All The World's a Stage	Villiers
Ash Replevin	27 December 2084	La Famille Du Peintre	Sleevey
In Shadows We Hyde	23 December 2084	Call of the Shadows	OrionsRequiem
Meatgrinder, Part 1 - Tide of Darkness	21 December 2084	Meatgrinder	Asmodeus
Seasons Beatings	9 December 2084	Christmas Special, With a Vengeance	Furaidopeto
Qui sème le vent... Récolte l'Atomique	8 December 2084	Contre-Révolution Rad Wars 2084	Zerre
No Time to Die	6 December 2084	Two Steps Ahead	Sarcarian
Special Delivery... for the Military!	5 December 2084	Arma Ex Machina Rad Wars 2024	TidanShock
A Dragon's Double-Header	3 December 2084	Dragon of a Problem	OrionsRequiem
Operation Poseidon	2 December 2084	Rad Wars 2084	Sarcarian
Hedge Your Bets	26 November 2084	Rad Wars 2084	Asmodeus
Thunder Rolls: Interlude 1	25 November 2084	Amatsu Kaze An Obscure Wanderer	Fangblade_
The Burden of Blood	25 November 2084	Amatsu Kaze	Fangblade_
Contrôle d'Accès	22 November 2084	Rad Wars 2084	Sarcarian
Hegemony of the Food Chain	20 November 2084	Swarming Season	Asmodeus
Revolutions	19 November 2084	Amatsu Kaze	Fangblade_
Methodical Approach	19 November 2084	Rad Wars 2084	Zerre
Go big, go loud, or go home!	18 November 2084	The Life and Times of One Kevin Crimes	TidanShock
Zone de Réseautage	13 November 2084	Rad Wars 2084	Sarcarian
Knock Knock	10 November 2084	Swarming Season	Asmodeus
Ula Menida Tula Oh	10 November 2084	Amatsu Kaze An Obscure Wanderer	Fangblade_
Move Ahead, Lay Down Dead, or Slip on By	8 November 2084	Sign of Zeta	Fangblade_
La Nouvelle Cavalerie	8 November 2084	Rad Wars 2084	Zerre
High Caliber Spectrometry	7 November 2084	The Arrival	Asmodeus
Noblesse Oblige	6 November 2084	The Light Before We Land	Fangblade_
This Is Halloween H20	31 October 2084	Hail to the Pumpking	Asmodeus
Foreclosure	29 October 2084	Compound Interest	Sample Text
Omenbearers	27 October 2084	Hail to the Pumpking	Asmodeus
An average Ohio extermination	26 October 2084	Arma Ex Machina	TidanShock
Duvet	24 October 2084	And Love You Shall Find The Light Before We Land	Fangblade_
A slightly rainy day in Kansas	20 October 2084	Swarming Season	Lotus
Fort Dumbass	20 October 2084	And Love You Shall Find	Fangblade_
Stars of the midnight Ranger	18 October 2084	The Arrival	TidanShock
Of Clans and Families	16 October 2084	Arma Ex Machina	TidanShock
Enemy of my Enemy of my Enemy	8 October 2084	When the hunters came to town	TidanShock
So Goes Darkness Part 1	7 October 2084	And Love You Shall Find	Fangblade_
Halloween Kitty	6 October 2084	Hail to the Pumpking	Asmodeus
Fake French Fox Finds Friends and Files	4 October 2084	Contre-Révolution	Zerre
The Run Where They Carve Pumpkins	3 October 2084	And Love You Shall Find	Fangblade_
As Goes Light	30 September 2084	When the hunters came to town And Love You Shall Find	Fangblade_
Heavensward	25 September 2084	When the hunters came to town And Love You Shall Find	Fangblade_
Dawntrail	24 September 2084	And Love You Shall Find	Fangblade_
Spotter	22 September 2084	And Love You Shall Find	Fangblade_
The End of All You'll Know	10 September 2084	And Love You Shall Find Sign of Zeta	Fangblade_
Saving the Survivors	7 September 2084	Swarming Season	Lotus
Remaniement	7 September 2084	Contre-Révolution	Zerre
Reject Enlightenment	2 September 2084	The Crow of Seattle	Asmodeus
Cascade Cola	2 September 2084	It's a Small Underworld After All Devil's Night	YouMayFireWhenReady
The Burden of Possibility	1 September 2084	Sign of Zeta Amatsu Kaze	Fangblade_
Ghostwire in the Shell	23 August 2084	Sign of Zeta	Fangblade_
Werewolves & CIcadas	21 August 2084	Swarming Season	Asmodeus
Condolences for Johnsons	20 August 2084	It's a Small Underworld After All	YouMayFireWhenReady
Finger Lickin' Good	19 August 2084	The C in UCAS is for Corruption	Villiers
Overmind Dead Body	18 August 2084	Swarming Season	Asmodeus
Winning through logistics	16 August 2084	Contre-Révolution	Zerre
"Fragile? It Must Be Italian!" Finale	15 August 2084	It's a Small Underworld After All	YouMayFireWhenReady
What Is Lu-(i)ck	12 August 2084	It's a Small Underworld After All	Keeper M
Waves of Despair	11 August 2084	The Crow of Seattle	Asmodeus
Saved by the bell	6 August 2084	The Metroplex Governor Race of '84	Aurora
The Virgin Affair	5 August 2084	It's a Small Underworld After All The Metroplex Governor Race of '84	YouMayFireWhenReady
Oasis of the Soul	5 August 2084	The Arrival	Asmodeus
The Suite Life of Five of Nines	4 August 2084	The Metroplex Governor Race of '84	TidanShock
Navigating the Noosphere	4 August 2084	The Metroplex Governor Race of '84	Sarcarian
This Is Why We Fight	4 August 2084	The Metroplex Governor Race of '84	Aurora
Rally For Technorights!	2 August 2084	The Metroplex Governor Race of '84	Aurora
Public Safety by Committee	1 August 2084	The Metroplex Governor Race of '84	YouMayFireWhenReady
Who can say no to this face, part 6	1 August 2084	When the hunters came to town	TidanShock
This is STRICTLY business	31 July 2084	The Metroplex Governor Race of '84	TidanShock
Knights of Change	31 July 2084	The Metroplex Governor Race of '84	Asmodeus
Sniffing out the powder	30 July 2084	Quinn Connoway's Family Matters	LHOG
Outlaw Country	30 July 2084	It's a Small Underworld After All The Metroplex Governor Race of '84	YouMayFireWhenReady
Cleaning up the past	28 July 2084	The Metroplex Governor Race of '84	Bulldogc
Embrace Your SINs	27 July 2084	The Metroplex Governor Race of '84	YouMayFireWhenReady
Robble robble!	27 July 2084	The Metroplex Governor Race of '84	Kirk
Revenge for a world	27 July 2084	The Metroplex Governor Race of '84	TitanShock
A tail of rats and bombs	26 July 2084	The Life and Times of One Kevin Crimes	TidanShock
Who Can Say No To This Face, Part 5	25 July 2084	When the hunters came to town	TidanShock
Libertines and Laes	23 July 2084	It's a Small Underworld After All The Metroplex Governor Race of '84	YouMayFireWhenReady
Quis Custodiet Ipsos Custodes?	22 July 2084	The Metroplex Governor Race of '84	Keeper M
You don't make up for sins by going to church	22 July 2084	The Metroplex Governor Race of '84	Draknic
The Gambian	20 July 2084	The Metroplex Governor Race of '84	YouMayFireWhenReady

Semantic search

Query log

Navigation menu

Search