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 2019]] [[Log Date::<<1 November 2019]]
 |?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 2019]] [[Log Date::<<1 November 2019]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1525",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Roleplay Logs]] [[Log Date::≥1 October 2019]] [[Log Date::<<1 November 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>='2458757.5') AND t4.p_id=29480)
   AND (
   (t6.o_sortkey<'2458788.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	t4	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.t4.s_id, const	1	Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	heroes.t4.s_id	1	Using where
1	SIMPLE	t6	ref	s_id, p_id, o_sortkey, p_id_2, s_id_2	s_id_2	8	heroes.t4.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" | Coffee Break || class="LogCell" | October 1st, 2019 || class="LogCell" | Hector and Kitora meet and chat. |- class="LogRow"

| class="LogCell" | Sam working in the Kitchen Nook. || class="LogCell" | October 1st, 2019 || class="LogCell" | Sam and Andrea talk about life, music and love. |- class="LogRow"

| class="LogCell" | Cheap One-Liners || class="LogCell" | October 1st, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | No country for spider-men. || class="LogCell" | October 1st, 2019 || class="LogCell" | Spider-Man saves Silk from Kraven, then finds out she wants to leave on a jet plane. Fin. |- class="LogRow"

| class="LogCell" | Mistake || class="LogCell" | October 1st, 2019 || class="LogCell" | A brief meeting in Gotham's crime alley. |- class="LogRow"

| class="LogCell" | Let's get physical .. (physical!) || class="LogCell" | October 1st, 2019 || class="LogCell" | Samuel and Andrea work out before Shannon stops by. The talk finally happened. |- class="LogRow"

| class="LogCell" | Deerfield 90210... Er 60015 || class="LogCell" | October 1st, 2019 || class="LogCell" | Kitty and Peter go back to her hometown and Peter meets Theresa Pryde. Peter has a surprise for Kitty. |- class="LogRow"

| class="LogCell" | Dance the Night Away || class="LogCell" | October 1st, 2019 || class="LogCell" | Megan meets the enigmatic Fantomex who turns out to be a thief. |- class="LogRow"

| class="LogCell" | Sentinels: Executions || class="LogCell" | October 1st, 2019 || class="LogCell" | X-men and Avenger investigate the Sentinel executions in a northern florida junkyard. |- class="LogRow"

| class="LogCell" | Stop playing with the Danger Room Controls, Kurt || class="LogCell" | October 1st, 2019 || class="LogCell" | Kobayashi Maru MOTHA- |- class="LogRow"

| class="LogCell" | Painkillers and Paychecks || class="LogCell" | October 2nd, 2019 || class="LogCell" | Multiple Man finally pays Domino back. No, seriously. He did. For real! Oh, come on... it's true this time! |- class="LogRow"

| class="LogCell" | Got Out of Town On a Boat Going to Southern Islands || class="LogCell" | October 2nd, 2019 || class="LogCell" | Rogue, Janet and Kitty board the Beesting, Janet's yacht, and take it to warmer waters. |- class="LogRow"

| class="LogCell" | Happy Birthday, Space Avenger! || class="LogCell" | October 2nd, 2019 || class="LogCell" | Asgardian Ale! Traditional dancing! Flying people! More dancing! A birthday party to remember! |- class="LogRow"

| class="LogCell" | They did the Mash || class="LogCell" | October 28th, 2019 || class="LogCell" | Around Halloween, Beast Boy and Vorpal get into an odd situation in a costume shop. They find they aren't the only ones caught up in it. |- class="LogRow"

| class="LogCell" | Asgard's Requiem: No Secrets || class="LogCell" | October 2nd, 2019 || class="LogCell" | 'Thor', as played by Loki, asks Sif about ...Loki |- class="LogRow"

| class="LogCell" | A Little Extra Dessert.... || class="LogCell" | October 2nd, 2019 || class="LogCell" | Sam and Shannon talk about what could be learned from the danger room session with Kurt. |- class="LogRow"

| class="LogCell" | Working through a few things || class="LogCell" | October 2nd, 2019 || class="LogCell" | In which Andrea starts to doubt the path she is walking on. |- class="LogRow"

| class="LogCell" | Some things never change || class="LogCell" | October 2nd, 2019 || class="LogCell" | June and Drake run into each other after Drake returns to NYC. |- class="LogRow"

| class="LogCell" | Rasputin Times Two || class="LogCell" | October 2nd, 2019 || class="LogCell" | Piotr has returned to the mansion. |- class="LogRow"

| class="LogCell" | HFC: Royals || class="LogCell" | October 2nd, 2019 || class="LogCell" | Lorna takes her first steps into the HFC with her father and Emma Frost |- class="LogRow"

| class="LogCell" | The Lightness of Being... it's Unbearable. || class="LogCell" | October 3rd, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Sittin' on the Tower by the Bay || class="LogCell" | October 3rd, 2019 || class="LogCell" | Two teammates meet each other. Awkwardness ensues. |- class="LogRow"

| class="LogCell" | Priorities || class="LogCell" | October 3rd, 2019 || class="LogCell" | Pepper comes home after a late night to talk Tony into some brief work before they both decide they have some other more important priorities for the night -- namely, each other. |- class="LogRow"

| class="LogCell" | Handy at Heroism AND Handball || class="LogCell" | October 3rd, 2019 || class="LogCell" | Bucky and Steve indulge in an old hobby: handball. There's also potentially a v-blog in the future? |- class="LogRow"

| class="LogCell" | Who Can Say No to a Lamb Gyro || class="LogCell" | October 3rd, 2019 || class="LogCell" | Loki can say no to a lamb gyro! But only after surprising both Sif and Caitlin out for dinner at their favorite Greek restaurant. |- class="LogRow"

| class="LogCell" | An Evening in Parrington || class="LogCell" | October 3rd, 2019 || class="LogCell" | Danny and Colleen watch Shogun |- class="LogRow"

| class="LogCell" | Out at the club || class="LogCell" | October 3rd, 2019 || class="LogCell" | Sam And Karen chat and dance, will they meet again? |- class="LogRow"

| class="LogCell" | On That Note.... || class="LogCell" | October 3rd, 2019 || class="LogCell" | Shannon and Andrea talk about music, love, and meeting their heroes. Plans for a shopping trip are afoot! |- class="LogRow"

| class="LogCell" | Enter, Gwendolyn! || class="LogCell" | October 3rd, 2019 || class="LogCell" | Gwendolyn seeks help through Andrea's charity Starlight, and gets picked up by Shannon and Hank on a trip to Xavier's. |- class="LogRow"

| class="LogCell" | The Ferris/Gotham Connection || class="LogCell" | October 3rd, 2019 || class="LogCell" | The Mad-Hatter plots to use Ferris Airfield, and tries to murder Amarok and Hal Jordan as The Green Lantern by blowing up his own warehouse and killing a bunch of his own men. |- class="LogRow"

| class="LogCell" | Age of Darkness: Sentinels Attack! || class="LogCell" | October 3rd, 2019 || class="LogCell" | Winifred Burkle and several mutant children are attacked by Sentinels. Superman arrives enraged, and several bystanders are injured. The Sentinels are defeated. A young mutant boy and Fred are critically injured and taken to hospital. |- class="LogRow"

| class="LogCell" | April in October || class="LogCell" | October 3rd, 2019 || class="LogCell" | Leonardo comes to April's place to give her a rundown on recent events, as she does with him in return. They swap some stories, some vitamin waters, and he gets some keys to a sweet farm in the middle of no where. |- class="LogRow"

| class="LogCell" | Shiny Happy People || class="LogCell" | October 3rd, 2019 || class="LogCell" | Colossus and Jubilee reacquaint themselves. |- class="LogRow"

| class="LogCell" | Delivery in Brooklyn || class="LogCell" | October 3rd, 2019 || class="LogCell" | Pippi comes accross Joe Miller, a super-strong gentleman of human appearance. After crashing an AC, the Power Pup makes a hasty retreat. |- class="LogRow"

| class="LogCell" | Never Let Go Jack || class="LogCell" | October 3rd, 2019 || class="LogCell" | Lorna and Bobby have a chat on the lake. |- class="LogRow"

| class="LogCell" | Stayin Alive || class="LogCell" | October 4th, 2019 || class="LogCell" | A fight breaks out in a penthouse |- class="LogRow"

| class="LogCell" | Sweet Dreams Are Made Of Cheese.... || class="LogCell" | October 4th, 2019 || class="LogCell" | Shannon and Sam-bean talk about life, classic conundrums, and maybe--just maybe--find that more can be faced together than apart. Awwwww! <3 |- class="LogRow"

| class="LogCell" | No Place Like Home || class="LogCell" | October 4th, 2019 || class="LogCell" | What is the truth? Whispers from a silver tongue parried by the armor of wisdom end in answers abounding. Perhaps it's a gift. |- class="LogRow"

| class="LogCell" | My Brother went to the Savage land and all I got was this T-shirt. || class="LogCell" | October 4th, 2019 || class="LogCell" | Least I got a tooth |- class="LogRow"

| class="LogCell" | Times they are a changing || class="LogCell" | October 4th, 2019 || class="LogCell" | Svetlana and Nadia get into a brawl at a protest that turns ugly. |- class="LogRow"

| class="LogCell" | City Fall: Black Mask || class="LogCell" | October 4th, 2019 || class="LogCell" | The Question and Shadow interfere with a gang meeting in Gotham. They manage to disrupt the Shredder's plans, but it comes at a cost. |- class="LogRow"

| class="LogCell" | Hospital visitor for Fred || class="LogCell" | October 4th, 2019 || class="LogCell" | Fred receives a visit from Hank McCoy of the XMen, who calls in his friend Shannon. Shannon's healing powers are used to take Fred's VERY severe injuries, but now Shannon has taken those injuries on herself. |- class="LogRow"

| class="LogCell" | Membership Requirements are Strict || class="LogCell" | October 4th, 2019 || class="LogCell" | Namorita negotiates an invitation to interview with Emma Frost for the Hellfire Club. |- class="LogRow"

| class="LogCell" | New Meat looking for well New Meat. || class="LogCell" | October 4th, 2019 || class="LogCell" | Sam meets the new kid and has breakfast burritos |- class="LogRow"

| class="LogCell" | There's No Taking The Illinois Out Of The Girl || class="LogCell" | October 4th, 2019 || class="LogCell" | Kitty takes Peter for a walk around her hometown. |- class="LogRow"

| class="LogCell" | A Meeting at the Zoo || class="LogCell" | October 4th, 2019 || class="LogCell" | Hammerhead and Cheetah make a deal while Ivory watches |- class="LogRow"

| class="LogCell" | Asgard's Requiem: It isn't Over || class="LogCell" | October 4th, 2019 || class="LogCell" | Dr. Strange makes some demands of Loki. |- class="LogRow"

| class="LogCell" | So About This Club... || class="LogCell" | October 4th, 2019 || class="LogCell" | Lorna goes to Roberto for help regarding the HFC. |- class="LogRow"

| class="LogCell" | Seriously Shannon, We May Need To Move Your Stuff In Here || class="LogCell" | October 4th, 2019 || class="LogCell" | Shannon is visited by Kitty and Emma in Med Bay, while Megan and Andrea stop in for treatment. |- class="LogRow"

| class="LogCell" | A Stone for a Key to the House || class="LogCell" | October 4th, 2019 || class="LogCell" | The bargain agreed upon in Asgard between Doctor Strange and Loki is fulfilled with as minimal fuss as could be managed -- which means it was chaotic. |- class="LogRow"

Semantic search

Query log

Navigation menu

Search