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 October 2017]] [[Log Date::<<1 November 2017]]
 |?Log Date
 |?Log Synopsis
 |format=template
 |limit=50
 |offset=0
 |link=none
 |sort=
 |order=asc
 |mainlabel=
 |default=| colspan=3 | No logs submitted yet.
 |template=Log List Single
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Roleplay Logs]] [[Log Date::\u22651 October 2017]] [[Log Date::<<1 November 2017]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0842",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Roleplay Logs]] [[Log Date::≥1 October 2017]] [[Log Date::<<1 November 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>='2458027.5') AND t4.p_id=29480)
   AND (
   (t6.o_sortkey<'2458058.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
0

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	8078	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" | All grown up || class="LogCell" | October 1st, 2017 || class="LogCell" | Kurt and Kitty do a little catching up, now that she's home from college. |- class="LogRow"

| class="LogCell" | Heads Will Roll || class="LogCell" | October 2nd, 2017 || class="LogCell" | SHIELD sends a team on a rescue op. Things are far worse than intel suggested. |- class="LogRow"

| class="LogCell" | Holy Roller Crazies! || class="LogCell" | October 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | TITANS: I forgot what I was remembering to not forget. || class="LogCell" | October 1st, 2017 || class="LogCell" | TITANS: Stardust is too late for the end of the battle... but who cares about that? Tommy is too late to buy comics. By several years. Now that is a tragedy. |- class="LogRow"

| class="LogCell" | You Ain't No Daisy... || class="LogCell" | October 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Voluntary Overtime || class="LogCell" | October 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Family Reunion || class="LogCell" | October 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Anti-Mind over Anti-Matter Part 2: In the Clutches of the Wraith || class="LogCell" | October 1st, 2017 || class="LogCell" | Rescuing Brainiac 5 hits a glitch. Continued from Anti-Mind over Anti-Matter. |- class="LogRow"

| class="LogCell" | A Plumed Proposal || class="LogCell" | October 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Empty Chairs at Empty Tables || class="LogCell" | October 1st, 2017 || class="LogCell" | Vorpal, Timber Wolf, and Speed cross paths in a damaged Mutant Town and strangeness follows, namely in the pulling up of bad memories. |- class="LogRow"

| class="LogCell" | Dude Where's my Space Boat || class="LogCell" | October 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | You Are Cordially Invited || class="LogCell" | October 1st, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | The Hangover || class="LogCell" | October 2nd, 2017 || class="LogCell" | Three SHIELD agents--Melinda May, Skye Johnson, and Abe Sapien (BPRD)--head to an ancient viking settlement on the Canadian coast to investigate the possibility of Hydra activity. The reality is so much stranger. |- class="LogRow"

| class="LogCell" | Feast Fit For a Faerie || class="LogCell" | October 2nd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | In Operations || class="LogCell" | October 2nd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Queen of the Desert || class="LogCell" | October 2nd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Invasion: Erf || class="LogCell" | October 2nd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Darkseid: the Thankening || class="LogCell" | October 2nd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Admiration of Fine Art || class="LogCell" | October 2nd, 2017 || class="LogCell" | At an art gallery to add a little something to her collection, Catwoman encounters the last person she'd have expected: the Joker. |- class="LogRow"

| class="LogCell" | Peabody's Improbable History || class="LogCell" | October 2nd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | We Have Cancelled The Apokolips || class="LogCell" | October 2nd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Page Pals Pizza Party || class="LogCell" | October 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | The Descent of Ishtar || class="LogCell" | October 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Cape, Please! || class="LogCell" | October 3rd, 2017 || class="LogCell" | Laura happens by a pair of LGBTQs+ etc', misunderstandings ensue, as Laura learns of a new Weapon-X ally in the hunt against her. |- class="LogRow"

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

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

| class="LogCell" | The Chinese Connection || class="LogCell" | October 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | I Lost My Jacket || class="LogCell" | October 3rd, 2017 || class="LogCell" | Agents Romanova and Johnson speak to Ares about tactics when dealing with alien invasions in the future. |- class="LogRow"

| class="LogCell" | Who Dun It || class="LogCell" | October 3rd, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Oooh, shiny.. || class="LogCell" | October 8th, 2017 || class="LogCell" | Origami and Pixie come across a burning building that shouldn't be able to burn, and a firey pest. |- class="LogRow"

| class="LogCell" | Seeing a Man About a Penguin || class="LogCell" | October 3rd, 2017 || class="LogCell" | Iceberg Lounge, Gotham City... a palace of ice and excess; a place Norman finds himself, to seek answers and potential partnership from the information broker known as Oswald Cobblepot. |- class="LogRow"

| class="LogCell" | Home....is where the heart is. || class="LogCell" | October 3rd, 2017 || class="LogCell" | Susan and Jen come home after battling the forces of Apokolips |- class="LogRow"

| class="LogCell" | Thesis Projects || class="LogCell" | October 2nd, 2017 || class="LogCell" | Dean had received a text from Sam saying Mercy could use some help fixing a car. It turns out the car has been all but destroyed... |- class="LogRow"

| class="LogCell" | The Charges of a Teacher || class="LogCell" | October 4th, 2017 || class="LogCell" | Captain America, Black Widow and the Winter Soldier assist the Green Ranger on a rescue mission |- class="LogRow"

| class="LogCell" | Out for Shawarma || class="LogCell" | October 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | A Missing Person || class="LogCell" | October 4th, 2017 || class="LogCell" | Tigra is looking for a missing person. She finds him, but also a lot more than that. |- class="LogRow"

| class="LogCell" | Mother May and I || class="LogCell" | October 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Penny for Your Thoughts || class="LogCell" | October 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Mother May I Pt 2 || class="LogCell" | October 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | A Rainy Gotham Night || class="LogCell" | October 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Coming Home to New Faces || class="LogCell" | October 4th, 2017 || class="LogCell" | Old student meeting new ones. |- class="LogRow"

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

| class="LogCell" | No One Will Ever Know... || class="LogCell" | October 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

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

| class="LogCell" | SHIELD Under Siege || class="LogCell" | October 8th, 2017 || class="LogCell" | Enemy agents infiltrate SHIELD and attempt to abscond with incredibly valuable equipment. |- class="LogRow"

| class="LogCell" | We Have a Space Station || class="LogCell" | October 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | All the King's Horses || class="LogCell" | October 5th, 2017 || class="LogCell" | Brainy's back, but not really all in one piece yet. Reassembly is a family affair. |- class="LogRow"

| class="LogCell" | Broken Bridges || class="LogCell" | October 5th, 2017 || class="LogCell" | Bucky and Natasha have a long-avoided but inevitable conversation about their shared history -- and future. |- class="LogRow"

| class="LogCell" | Blood Ties || class="LogCell" | October 9th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Queen and Princess || class="LogCell" | October 4th, 2017 || class="LogCell" | Summary needed |- class="LogRow"

Semantic search

Query log

Navigation menu

Search