Semantic search
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>='2457997.5') AND t4.p_id=29480)
AND (
(t6.o_sortkey<'2458027.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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t6 | ref | s_id, p_id, o_sortkey, p_id_2, s_id_2 | p_id | 4 | const | 8076 | 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 |
Query-Depth:1
| class="LogCell" | Hellish Kitchen || class="LogCell" | September 14th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Something Wicked This Way Comes || class="LogCell" | September 16th, 2017 || class="LogCell" | Ares and Shulkie are enjoying a night at a towny bar when Castiel comes in
|- class="LogRow"
| class="LogCell" | Seeing the sites || class="LogCell" | September 15th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Indistinguishable from magic || class="LogCell" | September 15th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | When Life Gives You Melons || class="LogCell" | September 14th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Log 2469 || class="LogCell" | September 15th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Heralds of Doom || class="LogCell" | September 15th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | We try not to wreck the school || class="LogCell" | September 16th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Kaldur Loves Surfacer Food || class="LogCell" | September 16th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | A Demon by Any Other Name || class="LogCell" | September 16th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Faster, Sabretooth! Kill! Kill! || class="LogCell" | September 16th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Crowley and the Cavalry || class="LogCell" | September 16th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Virginia Blues || class="LogCell" | September 9th, 2017 || class="LogCell" | Things go horribly, horribly wrong in Virginia for Jo Harvelle, Dean Winchester, and Agent Mom... er.. May.
|- class="LogRow"
| class="LogCell" | Check Engine Light On || class="LogCell" | September 16th, 2017 || class="LogCell" | Jean broke Kurt's car. She meets Mercy Thompson to discuss repairing it.
|- class="LogRow"
| class="LogCell" | Polemically Sent || class="LogCell" | September 12th, 2017 || class="LogCell" | The King of the Crossroads pays Melinda May a little visit.
|- class="LogRow"
| class="LogCell" | A Good Chat || class="LogCell" | September 16th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Remy's Return || class="LogCell" | September 23rd, 2017 || class="LogCell" | Gambit returns from the Dead! Okay, just kidding
|- class="LogRow"
| class="LogCell" | Apokolips Now: Avengers Assemble || class="LogCell" | September 19th, 2017 || class="LogCell" | The armies of Apokolips descend upon NYC, targetting the UN as a symbol of world government. The Avengers arrive to help National Guard and NYPD forces hold the line, and make a new friend in the process.
|- class="LogRow"
| class="LogCell" | A bizzar Day || class="LogCell" | September 17th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Log 2483 || class="LogCell" | September 16th, 2017 || class="LogCell" | The Guardians and Star*Drake team up (loosely) to capture a criminal.
|- class="LogRow"
| class="LogCell" | I'm Not Dead Yet || class="LogCell" | September 17th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Hello Is Robin Home || class="LogCell" | September 17th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Hunting for Info || class="LogCell" | September 16th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Tigger Momma on Campus || class="LogCell" | September 17th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Madness || class="LogCell" | September 17th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Crushed Dream || class="LogCell" | September 17th, 2017 || class="LogCell" | Timber Wolf, Kenan Kong, and Kaelyn encounter minions of Darkseid (1 of 2).
|- class="LogRow"
| class="LogCell" | A Mercy Call || class="LogCell" | September 17th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Partners in Employment || class="LogCell" | September 17th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Madam Secretary || class="LogCell" | September 18th, 2017 || class="LogCell" | Monet St. Croix, the Black Rook, approaches the silent secretary of the Hellfire Club-- Tessa.
|- class="LogRow"
| class="LogCell" | adult swim || class="LogCell" | September 18th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Raven's Dark Secret || class="LogCell" | September 17th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | A Wolf's Clothing || class="LogCell" | September 17th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Don't Look Back || class="LogCell" | September 6th, 2017 || class="LogCell" | Sam Winchester extends the hand of friendship to James Buchanan Barnes.
|- class="LogRow"
| class="LogCell" | Crushed Dream Part 2 || class="LogCell" | September 17th, 2017 || class="LogCell" | Timber Wolf, Kenan Kong, and Kaelyn encounter minions of Darkseid (2 of 2).
|- class="LogRow"
| class="LogCell" | Intern-al Affairs || class="LogCell" | September 18th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Layover || class="LogCell" | September 18th, 2017 || class="LogCell" | People meet at a Chinese Restaurant, it happens.
|- class="LogRow"
| class="LogCell" | A Crusade In The Park || class="LogCell" | September 18th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | A Rough Night || class="LogCell" | September 18th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | A Walk in the Park || class="LogCell" | September 18th, 2017 || class="LogCell" | Beth meets an angel while walking in the park.
|- class="LogRow"
| class="LogCell" | Meeting with an Angel || class="LogCell" | September 18th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Brooklyn || class="LogCell" | September 18th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Cold Case || class="LogCell" | September 18th, 2017 || class="LogCell" | Sarah Osborn asks Beth to look into the death of her parents
|- class="LogRow"
| class="LogCell" | Who Goes There || class="LogCell" | September 18th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | And the mustard is free. || class="LogCell" | September 18th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Balls out || class="LogCell" | September 19th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Strange Day || class="LogCell" | September 19th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | A Welfare Call || class="LogCell" | September 18th, 2017 || class="LogCell" | Breath checks up on the out of contact LGBT centers in the area. Her and Vorn assist Clarine with the aftermath of a battle with invaders.
|- class="LogRow"
| class="LogCell" | Chance Meetings || class="LogCell" | September 19th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Lunchtime Chat || class="LogCell" | September 19th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"
| class="LogCell" | Red wine || class="LogCell" | September 19th, 2017 || class="LogCell" | Summary needed
|- class="LogRow"