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=250
 |link=none
 |sort=
 |order=asc
 |mainlabel=
 |default=| colspan=3 | No logs submitted yet.
 |template=Log List Single
}}

Results 251 – 300 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.0757",
    "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
250

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" | Flatlined Again || class="LogCell" | June 3rd, 2017 || class="LogCell" | In which Aspen does some homework on akuma attacks, Adrien tries to explain what happened, and Hawkeye is Flatline's next victim. Or this is why the world needs a Ladybug so stop doubting yourself already, My Lady! |- class="LogRow"

| class="LogCell" | Walk in the Park || class="LogCell" | June 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Log || class="LogCell" | June 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Introducing Lina || class="LogCell" | June 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Flatline: Clint Awakens || class="LogCell" | June 3rd, 2017 || class="LogCell" | Clint wakes up under the effects of the Flatline phenomena. A battle ensues involving Darcy Lewis and Natasha Romanova. |- class="LogRow"

| class="LogCell" | Play It Safe || class="LogCell" | June 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Titans Together || class="LogCell" | June 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Singing in the Rain || class="LogCell" | June 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Log || class="LogCell" | June 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | An Act of God Wakes the Princess. || class="LogCell" | June 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | The Big Bad, Bartender, Buffy, and the Poof || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Busking Away || class="LogCell" | June 4th, 2017 || class="LogCell" | Wilykit and Wilykat are busking ... and Lion-O does not approve. Hijinks ensue. Whiskers! |- class="LogRow"

| class="LogCell" | Gateway to Dragons || class="LogCell" | June 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Flatline: S.H.I.E.L.D. Aftermath || class="LogCell" | June 4th, 2017 || class="LogCell" | Nick Fury sentences the compromised Clint to death but Agent May asks for more time. |- class="LogRow"

| class="LogCell" | On the Trail of a Devil || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Harlem Fight || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Downtime || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

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

| class="LogCell" | Cold War || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Meeting with GL || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Oh Brother Where Art Thou || class="LogCell" | June 5th, 2017 || class="LogCell" | In which Darcy helps May track Dean because Sam is in the wrong hospital, Dean may or may not be completely happy about this, May has no fucks to give, and Sam is a big ol' moose puppy. Or May really dislikes misplacing assets. |- class="LogRow"

| class="LogCell" | Home again || class="LogCell" | June 4th, 2017 || class="LogCell" | In which Marinette takes some time to clean up and change, Plagg finds the prospect of cheese homey, and Tikki tries to get her counterpart to see reason. Or, Adrien's home life really sucks. |- class="LogRow"

| class="LogCell" | Back from a Flatline || class="LogCell" | June 4th, 2017 || class="LogCell" | In which Vorpal Noir cusses out Hawkmoth, Ladybug defeats Flatline, and Adrien realizes he's missed somethings. Or, Plagg declares he is leaving Adrien for Tikki. |- class="LogRow"

| class="LogCell" | Look! Over there! || class="LogCell" | June 4th, 2017 || class="LogCell" | Clayface infiltrates the Triskelion to prove his skills to Fury, unbeknownst to everyone else. Clint gets loose while under the influence of Flatline and chaos ensues |- class="LogRow"

| class="LogCell" | Rise and Shine, Iron Man || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Manners in the Manse || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Ravager Down || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Recovery Rooms... || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Foyer Meetings || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | After the Flatline || class="LogCell" | June 4th, 2017 || class="LogCell" | In which Adrien gets caught up, Marinette is the canary that caught the cat, and Marinette's parents learn of the engagement. Or things are just easier without the masks. |- class="LogRow"

| class="LogCell" | Looking for Titans || class="LogCell" | June 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Clayface: Party of Seven || class="LogCell" | June 5th, 2017 || class="LogCell" | An alien xenobiologist gets a unique perspective on the shattered mind of a notorious supervillain, from the inside. |- class="LogRow"

| class="LogCell" | Ice Cream Social || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Completing the Syllogism || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Athena Calling || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Where is Rover || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Choose Your Own Adventure || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | From my Heart and From my Hand; || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Nipping it in the Bud! || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

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

| class="LogCell" | Fools Gambit || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | In The Garage || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | A Much Deserved Cat Nap || class="LogCell" | June 5th, 2017 || class="LogCell" | In which Adrien and Marinette finally get a much deserved cat nap. Or, I swear this is still PG. |- class="LogRow"

| class="LogCell" | Provokatsiya || class="LogCell" | June 6th, 2017 || class="LogCell" | Winter Soldier extends the Black Widow a bloody invitation and an unacceptable offer, subsequent to their encounter at the embassy attack. |- class="LogRow"

| class="LogCell" | Eating Habits || class="LogCell" | June 5th, 2017 || class="LogCell" | In which Adrien's eating habits come into question, Marinette realizes Plagg is little more than a kitten that can fly, and Vorpal drops a small bomb. Or, everyone but Adrien realizes he is WAY too skinny. |- class="LogRow"

| class="LogCell" | A Stranger Visits || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Fury at Fury || class="LogCell" | June 6th, 2017 || class="LogCell" | In which Dracy bullheadly mouths off to Fury, Rogers is disappointed, and May saves Siberia from a Darcy-rific demise. Or, This wouldn't be SHIELD if we all got along! |- class="LogRow"

| class="LogCell" | A Veritable Treasure Trove || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | When looking for a werewolf, ask one. || class="LogCell" | June 5th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | It's Showtime! || class="LogCell" | June 6th, 2017 || class="LogCell" | A Brand New Universe for a Brand New Dazzler; Polaris makes the catch. |- class="LogRow"

Semantic search

Query log

Navigation menu

Search