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

Debug output SQLStore

ASK Query

[[Category:Roleplay Logs]] [[Log Date::≥1 June 2019]] [[Log Date::<<1 July 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>='2458635.5') AND t4.p_id=29480)
   AND (
   (t6.o_sortkey<'2458665.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	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" | Not Another Walks Into A Bar Joke || class="LogCell" | June 16th, 2019 || class="LogCell" | Barbara's search for a villain lands her in Luke's Bar. Jokes about bars ensue. |- class="LogRow"

| class="LogCell" | What's In That Barrel || class="LogCell" | June 16th, 2019 || class="LogCell" | Crystal stops somebody from littering. Maybe saves a life or two. |- class="LogRow"

| class="LogCell" | When Agents Go Missing || class="LogCell" | June 17th, 2019 || class="LogCell" | Alopex and Pippi go looking for Agent Garrett, but find evidence of the Foot Clan's involvement instead. |- class="LogRow"

| class="LogCell" | Poking Around || class="LogCell" | June 17th, 2019 || class="LogCell" | The police show up to ask some questions at Xavier's. |- class="LogRow"

| class="LogCell" | Just a tiny favor || class="LogCell" | June 17th, 2019 || class="LogCell" | Bucky gets to murder some people at Loki's request. |- class="LogRow"

| class="LogCell" | Not Quite Sylvester and Tweety || class="LogCell" | June 16th, 2019 || class="LogCell" | Kian meets Akat, er, Catwoman |- class="LogRow"

| class="LogCell" | Sentinels: A Conversation with Hank Pym || class="LogCell" | June 17th, 2019 || class="LogCell" | Jessica visits Dr. Hank Pym in his recovery room to get some answers. She gets exactly that: SOME answers. Leaves with more questions than she arrived with. |- class="LogRow"

| class="LogCell" | A human, a super, and a 'yote girl walk into a bar... || class="LogCell" | June 17th, 2019 || class="LogCell" | In which there is a bank robbery, Omnis speeds into to save the day, Mercy's bad luck is deadly, and Darcy orders everyone around. Or Darcy is scary when blood splattered. |- class="LogRow"

| class="LogCell" | Where in the world is Agent Cody Garrett || class="LogCell" | June 17th, 2019 || class="LogCell" | The Punisher follows up surveillance that shows a pair of mutants entering the apartment of one of his contacts, deciding to hunt down the mutants for information. |- class="LogRow"

| class="LogCell" | Wandering In The Park || class="LogCell" | June 17th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | After Shower Scene || class="LogCell" | June 17th, 2019 || class="LogCell" | In which Thor takes a shower and Darcy sees him naked. Or All Myths are True, More or Less. |- class="LogRow"

| class="LogCell" | Uninvited Guest || class="LogCell" | June 17th, 2019 || class="LogCell" | The Punisher drops by Captain Quaid's apartment. The Punisher gives the captain information and a splitting headache. |- class="LogRow"

| class="LogCell" | Even Sam has chores. || class="LogCell" | June 17th, 2019 || class="LogCell" | Sam chats with Mila about classes. |- class="LogRow"

| class="LogCell" | Dead for the Money || class="LogCell" | June 17th, 2019 || class="LogCell" | Jackie and Floyd meet up to talk business. |- class="LogRow"

| class="LogCell" | Checking Up on the Pooch || class="LogCell" | June 17th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Sentinels: History of Guilt || class="LogCell" | June 17th, 2019 || class="LogCell" | Nick Fury has some questions for Hank Pym. |- class="LogRow"

| class="LogCell" | Sentinels: Cargo Crush || class="LogCell" | June 17th, 2019 || class="LogCell" | Sentinels attack mutants at Port Newark and each other. Joseph Miller and Kid jump in to save port workers. Chato jumps in to settle a score. |- class="LogRow"

| class="LogCell" | A Day In The Life of Gotham U || class="LogCell" | June 17th, 2019 || class="LogCell" | Tim, Carrie and Stephanie find each other on campus and go for coffee and snacks. |- class="LogRow"

| class="LogCell" | Wong Makes Lasagna || class="LogCell" | June 17th, 2019 || class="LogCell" | Wong makes lasagna. Wanda and Lara eat while Doctor Strange eats what looks like a urinal mint. Felicia brings lime pie. But who wants that after urinal mint? |- class="LogRow"

| class="LogCell" | Sentinels: A Conversation with Hank Pym, Take 2 || class="LogCell" | June 17th, 2019 || class="LogCell" | Jessica visits Hank with a barrage of questions. |- class="LogRow"

| class="LogCell" | Sentinels: Chaos Spreads || class="LogCell" | June 17th, 2019 || class="LogCell" | Spiderwoman shows up unexpectedly at a Sentinel disaster. Frank nearly has a heart attack. Spiderwoman heads into the mix do what the emergency services personnel can't. |- class="LogRow"

| class="LogCell" | Age of Despair: I Believe These are Yours || class="LogCell" | June 18th, 2019 || class="LogCell" | Willow revisits the Watchtower to return Superman's glasses and introduce herself. And, once again, completely misses that she's considered one of 'the team'. |- class="LogRow"

| class="LogCell" | WHen you meet a God || class="LogCell" | June 18th, 2019 || class="LogCell" | In which Skye meets Thor, Darcy's true codename is revealed, and Skye doesn't realize her bestie ratted her out. Or This is why SHIELD HR Department cries during yearly Sexual Harassness renewal training. |- class="LogRow"

| class="LogCell" | Sentinels: Pym is Home || class="LogCell" | June 18th, 2019 || class="LogCell" | Hank Pym returns from his coma. Steve and Janet brief him on what he missed. |- class="LogRow"

| class="LogCell" | Finally Catching Up! || class="LogCell" | June 18th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Family Matters: That Feeling When You're Not Alone || class="LogCell" | June 18th, 2019 || class="LogCell" | Skye, May, and some of the gang deal with pre-mission jitters by discussing Skye's odd invitation to the Avenger's mansion to meet another Inhuman who has requested an audience. Plus stirfry is eaten. Om Nom Nom. |- class="LogRow"

| class="LogCell" | A quiet night under the stars || class="LogCell" | June 18th, 2019 || class="LogCell" | Sam and Rachel talk and Sam gets the hint. |- class="LogRow"

| class="LogCell" | Titans: For Once the Sky Isn't Falling. || class="LogCell" | June 18th, 2019 || class="LogCell" | Two Robins and a bear walk into a room... this is no joke. |- class="LogRow"

| class="LogCell" | Oh Look, It's You Again || class="LogCell" | June 18th, 2019 || class="LogCell" | It's a tete-a-tete on a rooftop between a Thunderer, a Trickster, and a Cat which ends in a wager involving not only gemstones, but Mario Kart. |- class="LogRow"

| class="LogCell" | Loungin || class="LogCell" | June 18th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Interrogation: Another interview for Harley || class="LogCell" | June 18th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Sentinels: Hello Houston.. Is This Thing On || class="LogCell" | June 18th, 2019 || class="LogCell" | Late night sleeplessness before mission finds Skye texting Tony Stark.. only to get Hank Pym. They exchange 'notes' and arrange for a clandestine exchange of information. Kind of. |- class="LogRow"

| class="LogCell" | Retaliation: Sleeping Beauty || class="LogCell" | June 18th, 2019 || class="LogCell" | The Birds Of Prey and company try to save a comatose woman, and fail. The death of Linda Macenzi triggers a dead mans switch. |- class="LogRow"

| class="LogCell" | Recruiting the Terminator || class="LogCell" | June 18th, 2019 || class="LogCell" | L1 recruits Deathstroke to the Light as an Enforcer. |- class="LogRow"

| class="LogCell" | We Meet Again! || class="LogCell" | June 18th, 2019 || class="LogCell" | Selene pays a visit to Frank. This time she gives him information instead of a broken nose. |- class="LogRow"

| class="LogCell" | City Fall: Hunting the Hunter || class="LogCell" | June 21st, 2019 || class="LogCell" | Karai attacks the Punisher, and it makes a really big mess. |- class="LogRow"

| class="LogCell" | Blood Delivery! || class="LogCell" | June 18th, 2019 || class="LogCell" | Buffy feels obligated to drop off some pig's blood at the Crypt to help Spike out. Things get (almost) cozy as they have an awkward discussion about 'things'. |- class="LogRow"

| class="LogCell" | Checking on the big guy. || class="LogCell" | June 18th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Sentinels: Robot Wrangling || class="LogCell" | June 18th, 2019 || class="LogCell" | Quaid asks Reed Richards for helping dealing with Sentinels. Richards gets two Sentinels for his trouble. |- class="LogRow"

| class="LogCell" | On a Lark in a Park || class="LogCell" | June 18th, 2019 || class="LogCell" | Ororo and Diana meet at a park event and decide how great they both are! Yay! |- class="LogRow"

| class="LogCell" | Tag. You're It. || class="LogCell" | June 19th, 2019 || class="LogCell" | Black Alice manages to chase down an artifact she lost to a demon without being smote by the X-Men who mostly seemed confused. |- class="LogRow"

| class="LogCell" | Changeling: Finale || class="LogCell" | June 19th, 2019 || class="LogCell" | SHIELD finally tracks down Arnim Zola and enacts their plan not only to take him and his forces down, but to purge him from SHIELD's systems forever, in a finale to years of RP that brings the house down...literally. |- class="LogRow"

| class="LogCell" | Long Time || class="LogCell" | June 19th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Just some shit || class="LogCell" | June 19th, 2019 || class="LogCell" | In which Darcy visits Rhodey and he feeds her his meat. Or why are you all so preverted? For reals!? It was steak, you sick freaks. |- class="LogRow"

| class="LogCell" | Jimmy's Diner || class="LogCell" | June 19th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Is it magic || class="LogCell" | June 19th, 2019 || class="LogCell" | ... and Felicia got a kitten, somehow. (I don't know.) |- class="LogRow"

| class="LogCell" | On the nature of good and evil. || class="LogCell" | June 19th, 2019 || class="LogCell" | Fiona Glenanne and Nadia Pym have a bit of a chat about slowing down in space and morality. |- class="LogRow"

| class="LogCell" | A Fresh Start || class="LogCell" | June 19th, 2019 || class="LogCell" | Cody gets a new set of memories from Kitsune. |- class="LogRow"

| class="LogCell" | Where in the world is Cody Garrett || class="LogCell" | June 19th, 2019 || class="LogCell" | Frank and Alopex meet for the first time. Frank gets some information about Foot Clan safehouses, and Alopex gets another contact. This occurs a few hours before Hunting the Hunter (scene 7946) |- class="LogRow"

| class="LogCell" | A Mercifer visit || class="LogCell" | June 19th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

Semantic search

Query log

Navigation menu

Search