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, t4.o_sortkey
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>='2457844.5') AND t4.p_id=29480)
AND (
(t6.o_sortkey<'2457874.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
t4.o_sortkey DESC
LIMIT
205
OFFSET
200
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t6 | range | s_id, p_id, o_sortkey, p_id_2, s_id_2 | o_sortkey | 9 | 243 | Using index condition; Using where; 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 |
Query-Depth:1
| class="LogCell" | Broken Heart || class="LogCell" | April 11th, 2017 || class="LogCell" | An attempt to steal a graphics card in hopes of getting meds is stopped by Dick Grayson.
|- class="LogRow"
| class="LogCell" | A Rooftop Meeting || class="LogCell" | April 10th, 2017 || class="LogCell" | Red Hood and Black Cat meet leading to an invitation to join the Outlaws
|- class="LogRow"
| class="LogCell" | Here Be Dragons || class="LogCell" | April 10th, 2017 || class="LogCell" | Diana fights a giant sea creature and flies INSIDE OF IT to defeat it.
|- class="LogRow"
| class="LogCell" | A Case of the Mondays || class="LogCell" | April 10th, 2017 || class="LogCell" | Virginia "Pepper" Potts and "Natalie Rushman" (the Black Widow Natasha Romanoff working undercover) discuss business.
|- class="LogRow"
| class="LogCell" | Not on My Turf || class="LogCell" | April 10th, 2017 || class="LogCell" | Dragonfly and Crusader search for criminals robbing electronics stores in the area
|- class="LogRow"
| class="LogCell" | Special Snowflakes || class="LogCell" | April 10th, 2017 || class="LogCell" | Holly gets a visit from Ororo about becoming a student at xaviers.
|- class="LogRow"
| class="LogCell" | The Truth about Monsters || class="LogCell" | April 10th, 2017 || class="LogCell" | Pepper is taken by a thrall of a vampire. Goblin-Girl and Hawkeye (Kate Bishop) help her out.
|- class="LogRow"
| class="LogCell" | Moving In || class="LogCell" | April 9th, 2017 || class="LogCell" | Supergirl moves in and meets more of her fellow Titans
|- class="LogRow"
| class="LogCell" | Moths to a Flame || class="LogCell" | April 9th, 2017 || class="LogCell" | Gypsy Moth battles the Slayer Faith and the vigilante Red Hood
|- class="LogRow"
| class="LogCell" | A Liason... || class="LogCell" | April 9th, 2017 || class="LogCell" | Sue Storm-Richards and Superman come to an agreement.
|- class="LogRow"
| class="LogCell" | ...and the Holograms || class="LogCell" | April 8th, 2017 || class="LogCell" | Elycia Kreiger heads to Subway only to meet the one and only Dazzler
|- class="LogRow"
| class="LogCell" | The New Girl || class="LogCell" | April 8th, 2017 || class="LogCell" | Supergirl visits the Tower for the first time and meets Donna Troy
|- class="LogRow"
| class="LogCell" | Art and Small talk || class="LogCell" | April 7th, 2017 || class="LogCell" | HOlly has a little run in with M'gann and Crusader after the events of the bank.
|- class="LogRow"
| class="LogCell" | Catching Up || class="LogCell" | April 7th, 2017 || class="LogCell" | Superman and Supergirl chat.
|- class="LogRow"
| class="LogCell" | What Chocolate || class="LogCell" | April 7th, 2017 || class="LogCell" | After the attempted robbery at the Mint, Crusader and Dazzler meet. A bag of dropped chocolates mysteriously disappear!
|- class="LogRow"
| class="LogCell" | Central Park Confrontation || class="LogCell" | April 7th, 2017 || class="LogCell" | A lovely afternoon ruined by villains!
|- class="LogRow"
| class="LogCell" | Metropolis Robbery || class="LogCell" | April 7th, 2017 || class="LogCell" | An attempted robbery at the Metropolis Mint! The heroes rush in to foil the caper.
|- class="LogRow"
| class="LogCell" | Crusader Quarantine || class="LogCell" | April 5th, 2017 || class="LogCell" | Jack-In-The-Box confronts Crusader about the danger her presents to Earth.
|- class="LogRow"
| class="LogCell" | Calling Dr. Stank || class="LogCell" | April 4th, 2017 || class="LogCell" | Spider-Man and Black Cat pursue a lead and encounter Gregory Stark.
|- class="LogRow"
| class="LogCell" | Trouble down in Mutant Town || class="LogCell" | April 4th, 2017 || class="LogCell" | Crusader and Rory Sakura meet, in the process facing off against a criminal.
|- class="LogRow"
| class="LogCell" | Foiled Plans || class="LogCell" | April 3rd, 2017 || class="LogCell" | Gambit seems to be interested in nefarious deeds at Bjorn's electronic store.
|- class="LogRow"
| class="LogCell" | The Cat Came Back || class="LogCell" | April 3rd, 2017 || class="LogCell" | Felicia Hardy springs a surprise visit on Peter Parker.
|- class="LogRow"
| class="LogCell" | A day in Flatbush || class="LogCell" | April 2nd, 2017 || class="LogCell" | Rogue and Gambit visit Bjorn's electronics shop.
|- class="LogRow"
| class="LogCell" | No Honor Among Thieves || class="LogCell" | April 2nd, 2017 || class="LogCell" | Gambit and Black Cat find themselves after the same target.
|- class="LogRow"
| class="LogCell" | Two Men Walk Into a Bar... || class="LogCell" | April 1st, 2017 || class="LogCell" | Crusader and Chamber randomly meet in a bar.
|- class="LogRow"