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=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 June 2019]] [[Log Date::<<1 July 2019]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1382",
    "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
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" | Changeling: And Now for Something Completely Different || class="LogCell" | June 1st, 2019 || class="LogCell" | The team gathers for a dinner *Skye* cooked and discuss plans as the final date for the mission looms. There are some surprises, and Steve baked brownies - okay they were out of a box, but baby steps, right? We can't all be Skye. |- class="LogRow"

| class="LogCell" | A bite to eat. || class="LogCell" | June 1st, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Does It Come In a Tux || class="LogCell" | June 1st, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Getting some dirt under your nails. Er, scales. || class="LogCell" | June 1st, 2019 || class="LogCell" | Ororo meets Ainsley, and Ainsley leaves the gardens with a new project in hand for Xavier Institute's botanical ambitions. |- class="LogRow"

| class="LogCell" | The Water's Fine || class="LogCell" | June 1st, 2019 || class="LogCell" | Illyana and Kitty have a soak in the school pool and discuss earthquakes, flowers and thrown pillows. |- class="LogRow"

| class="LogCell" | Truthseekers: Harley Quinn || class="LogCell" | June 1st, 2019 || class="LogCell" | April O'Neil Truthseeker's interview of Harley Quinn and the Spoiler |- class="LogRow"

| class="LogCell" | The Renaissance Faire || class="LogCell" | June 2nd, 2019 || class="LogCell" | Lorna, Rogue, Jason Todd and Kitty go to the Westchester Renaissance Fair. |- class="LogRow"

| class="LogCell" | I Just Wanted Pizza || class="LogCell" | June 2nd, 2019 || class="LogCell" | Racists didn't count on Chato. Chato didn't count on Adam. Sibil just wanted pizza. |- class="LogRow"

| class="LogCell" | New hardware || class="LogCell" | June 2nd, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Why Do They Call It Angelfood Cake || class="LogCell" | June 2nd, 2019 || class="LogCell" | Castiel brings a friend by the Trisk for lunch. Unannounced. Hilarity ensues. Complete with threats, guns, May's patented disappointed looks (tm), and admonishments to use the front door in the future. Also at gunpoint. |- class="LogRow"

| class="LogCell" | Time Heals All Wounds...Or Does It || class="LogCell" | June 1st, 2019 || class="LogCell" | Batman and Catwoman end up responding to the same van full of drug dealers, leading to their first encounter since a big loss of trust. |- class="LogRow"

| class="LogCell" | What || class="LogCell" | June 2nd, 2019 || class="LogCell" | Steve hassles Thor a bunch. |- class="LogRow"

| class="LogCell" | A Refreshing Summer Swim || class="LogCell" | June 2nd, 2019 || class="LogCell" | J'onn and Blink take a summer swim in the lake. J'onn reveals his weakness. |- class="LogRow"

| class="LogCell" | Pyro Basics || class="LogCell" | June 2nd, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | So About That Interview... || class="LogCell" | June 2nd, 2019 || class="LogCell" | With Carrie providing moral support, Stephanie approaches Bruce about her media gaffe. He lets her live to fight another day. |- class="LogRow"

| class="LogCell" | The Last Orb. || class="LogCell" | June 2nd, 2019 || class="LogCell" | Doctor Strange and Lara Croft come seeking the Autumn Orb from Steve, Wanda and Tony |- class="LogRow"

| class="LogCell" | Uptown Funk || class="LogCell" | June 2nd, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | From The Field of Weeds || class="LogCell" | June 2nd, 2019 || class="LogCell" | Splinter and Leonardo have a talk. |- class="LogRow"

| class="LogCell" | You Picked This Place on Purpose! || class="LogCell" | June 3rd, 2019 || class="LogCell" | Look, pizza's good, but it's weird when your own picture is staring back at you. Bucky, you did that on purpose!!! |- class="LogRow"

| class="LogCell" | Funnel Cake Fun || class="LogCell" | June 3rd, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Everything is Lizardier in Texas. || class="LogCell" | June 3rd, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Punishment in Arkham || class="LogCell" | June 3rd, 2019 || class="LogCell" | The Punisher tries to assassinate Harley in Arkham. Interference from Nightwing causes the operation to go sideways, fast... with Harley escaping in the chaos. |- class="LogRow"

| class="LogCell" | Checking in with MacKenzie || class="LogCell" | June 3rd, 2019 || class="LogCell" | Green Lantern Hal Jordan drops in on the MacKenzie King Space Station to check up on Kinsey. |- class="LogRow"

| class="LogCell" | Goin Cold Turkey || class="LogCell" | June 3rd, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Colt's First Day || class="LogCell" | June 3rd, 2019 || class="LogCell" | Sibil and Colt wait for a tour from Lorna. The mansion is a busy place, though, and Sean, Doug and Samuel show up to chat as well, while Lorna takes off to leave Sean with tour duty. |- class="LogRow"

| class="LogCell" | How to Train your Pippi || class="LogCell" | June 3rd, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Drinking Jason's Beer || class="LogCell" | June 3rd, 2019 || class="LogCell" | Carrie, Rogue and Kitty gather for a little underage drinking at home as Carrie sports a changed look. |- class="LogRow"

| class="LogCell" | Polarity in the Family || class="LogCell" | June 3rd, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Trifecta || class="LogCell" | June 4th, 2019 || class="LogCell" | Triads and Friends of Humanity square off at Red Hook. Rose and Conner ruin their day and give Jeff a lift. Adam drops in to lend a hand and see today's heroes in action. |- class="LogRow"

| class="LogCell" | Freaky Frid - No, Wait, Monday || class="LogCell" | June 4th, 2019 || class="LogCell" | It's Freaky Monday! Body swaps are the worst, but hey, at least it's not permanent! |- class="LogRow"

| class="LogCell" | Too pool for school || class="LogCell" | June 4th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | City Fall: A little tall for a stormtrooper || class="LogCell" | June 4th, 2019 || class="LogCell" | The Defenders play dress up and impersonate the Foot Clan to shake Shredder's hold on some of the crime bosses. |- class="LogRow"

| class="LogCell" | High Strangeness || class="LogCell" | June 4th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Frosty Flash || class="LogCell" | June 4th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | A buzz in central park! || class="LogCell" | June 4th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Investigating The Cruel || class="LogCell" | June 4th, 2019 || class="LogCell" | Kurt and Rahne stop a ring of thugs drugging the homeless for 'bum fights', Kurt calls it date night. |- class="LogRow"

| class="LogCell" | Magna Cum Laude || class="LogCell" | June 4th, 2019 || class="LogCell" | Lex acquires Adam's research for LexCorp. Adam gets a new home for his research. Everybody wins? |- class="LogRow"

| class="LogCell" | A Night At Luke's Bar || class="LogCell" | June 4th, 2019 || class="LogCell" | Johnny Blaze runs into Vanessa Carlysle, who has ducked out of the rain and into Luke's bar. |- class="LogRow"

| class="LogCell" | Slow And Steady Wins The Race || class="LogCell" | June 4th, 2019 || class="LogCell" | April lets Vanessa shelter during a troubled stretch. Leonardo pays a surprise visit. |- class="LogRow"

| class="LogCell" | Stark's Party Week doesn't have to End! || class="LogCell" | June 4th, 2019 || class="LogCell" | Tony's birthday suprise by Pepper doesn't go as well as she may have hoped. |- class="LogRow"

| class="LogCell" | I'm Not Sure If You Remember Me, But... || class="LogCell" | June 5th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | City Fall: Dangling Conversations || class="LogCell" | June 5th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Blonde Sorceress needs Sustenance! || class="LogCell" | June 5th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | Student Orientation part 2 || class="LogCell" | June 5th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | WHERE'S MY WRENCH || class="LogCell" | June 5th, 2019 || class="LogCell" | Summary needed |- class="LogRow"

| class="LogCell" | After The Beer || class="LogCell" | June 5th, 2019 || class="LogCell" | Jason comes home to find Kitty and Carrie have drank his beer. Also, red hair is now brown. |- class="LogRow"

| class="LogCell" | Bad Omen || class="LogCell" | June 5th, 2019 || class="LogCell" | Mon-El stops by to check on a CDC quarantine in New York. Belonwu fills him in about a possible bioweapon. |- class="LogRow"

| class="LogCell" | Do me a favor || class="LogCell" | June 5th, 2019 || class="LogCell" | Loki, pretending to be Thor, gets away with a heist. For now. |- class="LogRow"

| class="LogCell" | A quick pit stop. || class="LogCell" | June 5th, 2019 || class="LogCell" | One hero, one investigative reporter, both needing car repairs end up at the same shop. They meet its owner, Mercy, for the first time. |- class="LogRow"

| class="LogCell" | Gangland Blues: A Supply Run || class="LogCell" | June 5th, 2019 || class="LogCell" | Bigby and Mercy show up at the tail end of one of The Punisher's operations. Debates and 'questioning' ensue. (Warning, violence) |- class="LogRow"

Semantic search

Query log

Navigation menu

Search