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

import-annotation:

Additional annotated data are to be copied during the parsing of a subject

propsep:

The separator between the properties of a result entry

valuesep:

The separator between the values for a property of a result

template:

The name of a template with which to display the printouts

named args:

Name the arguments passed to the template

userparam:

A value passed into each template call, if a template is used

class:

An additional CSS class to set for the list

introtemplate:

The name of a template to display before the query results, if there are any

outrotemplate:

The name of a template to display after the query results, if there are any

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:Roleplay Logs]] [[Log Date::≥1 February 2019]] [[Log Date::<<1 March 2019]]
 |?Log Date
 |?Log Synopsis
 |format=template
 |limit=50
 |offset=200
 |link=none
 |sort=
 |order=asc
 |mainlabel=
 |default=| colspan=3 | No logs submitted yet.
 |template=Log List Single
}}

Results 201 – 250 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Roleplay Logs]] [[Log Date::\u22651 February 2019]] [[Log Date::<<1 March 2019]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.2682",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Roleplay Logs]] [[Log Date::≥1 February 2019]] [[Log Date::<<1 March 2019]]

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
`mw_smw_object_ids` AS t0
INNER JOIN
(`mw_smw_fpt_inst` AS t2
INNER JOIN
`mw_smw_di_time` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`mw_smw_di_time` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=29615
   AND (
   (t4.o_sortkey>='2458515.5') AND t4.p_id=29480)
   AND (
   (t6.o_sortkey<'2458543.5') AND t6.p_id=29480)
  )
  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
200

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t6	ref	s_id, p_id, o_sortkey, p_id_2, s_id_2	p_id	4	const	8066	Using index condition; Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	s_id_2	9	heroes.t6.s_id, const	1	Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	heroes.t6.s_id	1	Using where
1	SIMPLE	t4	ref	s_id, p_id, o_sortkey, p_id_2, s_id_2	s_id_2	8	heroes.t6.s_id, const	1	Using where; Using index; Distinct

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:5
Query-Depth:1

Errors and Warnings

None

| class="LogCell" | Curious Coffee || class="LogCell" | February 17th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Refugee blues || class="LogCell" | February 17th, 2019 || class="LogCell" | Arella gets a first day orientation for her arrangement at LexCorp... and some ground rules and intentions are given. |- class="LogRow"

| class="LogCell" | Burgers and awk || class="LogCell" | February 17th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Mayan Secrets: The Vigilante || class="LogCell" | February 17th, 2019 || class="LogCell" | T'Challa seeks info from Frank Castle on a mob boss with an art collection |- class="LogRow"

| class="LogCell" | Black Team || class="LogCell" | February 17th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Crane Style || class="LogCell" | February 17th, 2019 || class="LogCell" | Bobby experiences Kitty's retaliation for his earlier tinfoil prank |- class="LogRow"

| class="LogCell" | Kingston Park Art Appreciation || class="LogCell" | February 18th, 2019 || class="LogCell" | Jason and Kitty meet over a piece of art in the Park. They end up having dinner together and discuss learning more about each other. |- class="LogRow"

| class="LogCell" | Study Hall at Wayne Manor || class="LogCell" | February 18th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Rogue Ideas Are Best Ideas || class="LogCell" | February 18th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | School Night || class="LogCell" | February 18th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Just Doing Science, Don't Mind Me. || class="LogCell" | February 18th, 2019 || class="LogCell" | Arella and Steve cross paths on the street outside of the mansion. No violence ensues, but students from rival campuses colliding in a snowfall of papers provide enough 'tribal' entertainment for all. |- class="LogRow"

| class="LogCell" | Cappuccino To Go || class="LogCell" | February 18th, 2019 || class="LogCell" | Cappuccino, tea and tarts for Jessica Drew and T'Challa |- class="LogRow"

| class="LogCell" | My new BFF || class="LogCell" | February 18th, 2019 || class="LogCell" | Meggan returns to Xaviers. Various people visit. Erika gets embarrassed a lot. |- class="LogRow"

| class="LogCell" | Don't Club Baby Rillas || class="LogCell" | February 18th, 2019 || class="LogCell" | Just something casual. |- class="LogRow"

| class="LogCell" | Nova Corps: Nuala and Thor are almost kidnapped! || class="LogCell" | February 18th, 2019 || class="LogCell" | Loki ruins Thor's awesome exit. |- class="LogRow"

| class="LogCell" | The Fastest Invader Alive || class="LogCell" | February 18th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Meeting an advisor || class="LogCell" | February 18th, 2019 || class="LogCell" | Cannonball and Souvenir discuss team tactics. |- class="LogRow"

| class="LogCell" | Looking Out For A Hero || class="LogCell" | February 18th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Arts of Paradise || class="LogCell" | February 18th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Poking Around Amnesty Bay || class="LogCell" | February 19th, 2019 || class="LogCell" | Jason Blood and Morrigan explore the coast line a bit and find a place where Mo jokes about Elder Gods. |- class="LogRow"

| class="LogCell" | Let's get physical! Physical. || class="LogCell" | February 19th, 2019 || class="LogCell" | Going on a walk with Doogie, Andrea and him talks a lot about life. |- class="LogRow"

| class="LogCell" | 867-530-ni-ee-aye-ine || class="LogCell" | February 19th, 2019 || class="LogCell" | Jason Todd and Kitty Pryde chat on the phone while Jason is staking out some bad guys |- class="LogRow"

| class="LogCell" | Pool'n'Drinks || class="LogCell" | February 19th, 2019 || class="LogCell" | Several of the X-Men girls have a good time at Harry's Hideaway near Xavier's. Scott makes a cameo and acts like an angry school principal from an 80s movie. Its great! |- class="LogRow"

| class="LogCell" | A Study In Scarlet || class="LogCell" | February 19th, 2019 || class="LogCell" | T'Challa and Wanda Maximoff share a meal and become reacquainted |- class="LogRow"

| class="LogCell" | Three Ladies at a Bar Fight || class="LogCell" | February 19th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | With Leadership Comes Responsibility || class="LogCell" | February 19th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Gangland Blues/City Fall: Differences of Opinion || class="LogCell" | February 19th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | A DEMO || class="LogCell" | February 20th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Movie Night with the Stars || class="LogCell" | February 20th, 2019 || class="LogCell" | The second date between Kitty Pryde and Jason Todd finds them realizing that there's something more there than a love of good movies and laughing. |- class="LogRow"

| class="LogCell" | House of Metal Man || class="LogCell" | February 20th, 2019 || class="LogCell" | Colossus returns to the X-Mansion and is greeted outside by the Southern Belle with a smile and a hug! |- class="LogRow"

| class="LogCell" | A Joyous Reunion of the Best of Friends || class="LogCell" | February 20th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Sentinels: Ready or not || class="LogCell" | February 20th, 2019 || class="LogCell" | The Avengers discuss how to extract a target from the Sentinel factories; unfortunately, Hydra is attempting to murder the same target... |- class="LogRow"

| class="LogCell" | An evening on the town. || class="LogCell" | February 20th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | No Sputnik || class="LogCell" | February 20th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Welcome to my parlor said the spider to the hawk.. || class="LogCell" | February 20th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | What Shall We Do About Nuala || class="LogCell" | February 20th, 2019 || class="LogCell" | Plans are made! |- class="LogRow"

| class="LogCell" | Sentinels: Pamela and the Shadow King || class="LogCell" | February 20th, 2019 || class="LogCell" | Zoom interviews Pamela about her experience with the Shadow King. |- class="LogRow"

| class="LogCell" | Sentinels: LOOK AT MY ASS || class="LogCell" | February 20th, 2019 || class="LogCell" | Deadpool shows Steve his Sentinel parts. |- class="LogRow"

| class="LogCell" | Morning After Steaks || class="LogCell" | February 20th, 2019 || class="LogCell" | After the events of (Movie Night with the Stars), Jason and Kitty get an unexpected visitor. |- class="LogRow"

| class="LogCell" | Operation Paris, Part Two || class="LogCell" | February 21st, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Visitations in the Concrete Jungle || class="LogCell" | February 21st, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Sentinels: Rumors || class="LogCell" | February 21st, 2019 || class="LogCell" | Logan gives info about Sentinels to Forge and Storm. |- class="LogRow"

| class="LogCell" | Checking a pull box || class="LogCell" | February 21st, 2019 || class="LogCell" | An awkward meeting at a comic shop. |- class="LogRow"

| class="LogCell" | The Late Night Return || class="LogCell" | February 21st, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Manhunt: Subway Punishment || class="LogCell" | February 21st, 2019 || class="LogCell" | Winter Soldier dangles himself as bait to lure out the person trying to kill him... and gets a lot more than he bargained for. |- class="LogRow"

| class="LogCell" | Ice Cream - Mutant Style || class="LogCell" | February 21st, 2019 || class="LogCell" | Pixie, Kitty and Cannonball have ice cream sundaes and chat about pranks and Sentinels |- class="LogRow"

| class="LogCell" | The Librarian: The Lost Motel 6 || class="LogCell" | February 21st, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | late night x-snack || class="LogCell" | February 21st, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Ladies' Night || class="LogCell" | February 21st, 2019 || class="LogCell" | Ladies' Night at Luke's Bar, though some of the women who make it would hardly qualify as ladies... |- class="LogRow"

| class="LogCell" | But Is This Dinner... || class="LogCell" | February 21st, 2019 || class="LogCell" | But is it 'dinner' or is it |- class="LogRow"

Semantic search

Query log

Navigation menu

Search