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 June 2017]] [[Log Date::<<1 July 2017]]
 |?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 June 2017]] [[Log Date::<<1 July 2017]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0195",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Roleplay Logs]] [[Log Date::≥1 June 2017]] [[Log Date::<<1 July 2017]]

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>='2457905.5') AND t4.p_id=29480)
   AND (
   (t6.o_sortkey<'2457935.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	range	s_id, p_id, o_sortkey, p_id_2, s_id_2	o_sortkey	9		1207	Using index condition; Using where; 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" | An Assassin's Anguish || class="LogCell" | June 30th, 2017 || class="LogCell" | Winter Soldier is stuck in a nightmare from his own mind. Claire and Mercy-Coyote try to save him. |- class="LogRow"

| class="LogCell" | Small Problems || class="LogCell" | June 30th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Into the spider's web. || class="LogCell" | June 29th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | The Plight of War and Fear || class="LogCell" | June 29th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | A Change of Scenery || class="LogCell" | June 30th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | No more evil doing for you, little akuma. || class="LogCell" | June 30th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | The plight of Fear and War finale || class="LogCell" | June 30th, 2017 || class="LogCell" | Ares and Phobos' battle brings them to the exterior of the Triskelion |- class="LogRow"

| class="LogCell" | Midsummer Confusion: Cherry Blossoms and April in June || class="LogCell" | June 30th, 2017 || class="LogCell" | April O'Neal and Michelangelo (turtle ninja) find themselves in a surreal art-movie experience ... with ninjas |- class="LogRow"

| class="LogCell" | Log || class="LogCell" | June 30th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Of Gods and Men || class="LogCell" | June 30th, 2017 || class="LogCell" | Ares comes back to let Buffy know what happened in his battle with Phobos |- class="LogRow"

| class="LogCell" | Book Bindings || class="LogCell" | June 30th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | The Troubled Trickster || class="LogCell" | June 30th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Super-Homework || class="LogCell" | June 30th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Fancy Meeting You Here || class="LogCell" | June 30th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | It will be a cold day || class="LogCell" | June 30th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Stay on target || class="LogCell" | June 30th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Really Tall & Really Fast || class="LogCell" | June 30th, 2017 || class="LogCell" | Grace runs into Liz, and walks her home through a seedy neighborhood. |- class="LogRow"

| class="LogCell" | Interrogatus Interruptus || class="LogCell" | June 5th, 2017 || class="LogCell" | Jessica Jones tries to interrogate one of the participants in the latest streetfight, but has an encounter with Talia al'Ghul instead. |- class="LogRow"

| class="LogCell" | Black and White || class="LogCell" | June 11th, 2017 || class="LogCell" | The White and Black Roses clash, heedless of the innocent few attending a funeral. The Steppin' Razor Molly Millions assists Miss Moreau in her bloody deeds, and Tim Drake attempts to stop them all. Only Moreau leaves happy. |- class="LogRow"

| class="LogCell" | The Proper Dress || class="LogCell" | June 18th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Another day.... || class="LogCell" | June 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | An Oncoming Storm || class="LogCell" | June 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Terror in the Tunnels || class="LogCell" | June 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Code Blue: Flatline || class="LogCell" | June 1st, 2017 || class="LogCell" | In which Marinette dies and Plagg is the only one keeping his cool. |- class="LogRow"

| class="LogCell" | Aftermath: The Lesser of Two Evils || class="LogCell" | June 2nd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | A Diamond in the Rough || class="LogCell" | June 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | The Language of Flowers || class="LogCell" | June 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Plotting! || class="LogCell" | June 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | The Twofer || class="LogCell" | June 6th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Log || class="LogCell" | June 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Flatline: Leaving the Hospital || class="LogCell" | June 1st, 2017 || class="LogCell" | In which Flatline 'kills' Lois Lane, Wolf gets trapped in an elevator, Tikki hits Vorpal in the head with a clue-by-four, Plagg comtemplates the fun of havng an ACUTAL cat for a Chat Noir, and a new Chat Noir shows up with Cheshire powers. Or Hawkmoth is about to have a really bad time with this akuma. |- class="LogRow"

| class="LogCell" | The Wendigo Hunt || class="LogCell" | June 3rd, 2017 || class="LogCell" | A Wendigo stalks the hallways of a hospital in Hell's Kitchen. Mercy, Claire, Loki and Winter Soldier work to defeat. Or Claire and Mercy run like hell and Loki and the Soldier kill the beast. |- class="LogRow"

| class="LogCell" | Earthbound || class="LogCell" | June 6th, 2017 || class="LogCell" | Dyrk and Brainy reveal their frustrations to each other, and work some of them out. |- class="LogRow"

| class="LogCell" | An Estimation, of GLORY! || class="LogCell" | June 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | To Obliteration and Beyond || class="LogCell" | June 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Another night, another nightmare, another day || class="LogCell" | June 1st, 2017 || class="LogCell" | Another talk about 'us' from Karrin and Harry |- class="LogRow"

| class="LogCell" | Norway or the Highway... || class="LogCell" | June 2nd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Sense of Doubt || class="LogCell" | June 2nd, 2017 || class="LogCell" | In which Tommy approaches Hank McCoy for answers, and ends up reconsidering his course. |- class="LogRow"

| class="LogCell" | Too Late to Help || class="LogCell" | June 2nd, 2017 || class="LogCell" | In which Clark is told of Lois's injury, Plagg is grumpy, and Tikki is adorably clueless about the Big Blue Boyscout. Or Superman meets the Miraculous Kwamis and promises them he and his friends would super help. No one is surprised by any of it. |- class="LogRow"

| class="LogCell" | Why Do I Get to Take It Home || class="LogCell" | June 2nd, 2017 || class="LogCell" | Mercy comes home with the shattered mirror (from Mirror, Mirror) and Loki helps to unravel the mysteries of the shattered glass. |- class="LogRow"

| class="LogCell" | What Sarah Said... || class="LogCell" | June 2nd, 2017 || class="LogCell" | Karrin and Harry FINALLY take the next step, but it takes near death to make it happen. |- class="LogRow"

| class="LogCell" | The Tumor City || class="LogCell" | June 2nd, 2017 || class="LogCell" | Strange things abound in an unfortunate city, heroes respond, and a certain ghosbuster manages to save the day with a little help from her friends. |- class="LogRow"

| class="LogCell" | Flatline: Out of the Hospital || class="LogCell" | June 3rd, 2017 || class="LogCell" | In which Vorpal's rabbit hole teleport roulette drops Flatline off near Harlem and the cat elsewhere, Tony Stark is Flatline's next high-profile victim, Aspen sneaks a peek into the mind of an akuma victim, Supergirl tempts fate by catching Flatline's eye, Iron Fist finds where the akuma is hidden, and Thor causes an Act of God with a car - Tony's car and Top Gear mourns. Or what happens when superheros don't read the Ladyblog. |- class="LogRow"

| class="LogCell" | Super Worried || class="LogCell" | June 3rd, 2017 || class="LogCell" | In which Clark tells Kara what he knows about what has afflicted Lois. |- class="LogRow"

| class="LogCell" | The Canary and the Bat || class="LogCell" | June 2nd, 2017 || class="LogCell" | Batman paid Dinah a visit at her home, where the two discussed Autumn's mob situation and other matters. |- class="LogRow"

| class="LogCell" | Ivy builds a Garden || class="LogCell" | June 2nd, 2017 || class="LogCell" | Poison Ivy makes an impression on both Till and Tigra. |- class="LogRow"

| class="LogCell" | The Covens Curiousity:Wildfire V Juggernaut || class="LogCell" | June 3rd, 2017 || class="LogCell" | The Coven curious about a newly arrived player send their Mercenary against this mysterious space travaller only to be surprised just what he's capable of. |- class="LogRow"

| class="LogCell" | Bugs over Supermen || class="LogCell" | June 3rd, 2017 || class="LogCell" | In which Kal goes to apologize for slipping in up his worry. Or why everyone is afraid to make Tikki mad. |- class="LogRow"

| class="LogCell" | Ferris and the Foibles || class="LogCell" | June 2nd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

Semantic search

Query log

Navigation menu

Search