Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Logs]] [[Category:Chapter 1, Act 4]]
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
`wiki_smw_object_ids` AS t0
INNER JOIN
(`wiki_smw_fpt_inst` AS t2
INNER JOIN
`wiki_smw_fpt_inst` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=3750
AND (t4.o_id=2968)
)
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
50
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
`wiki_smw_object_ids` AS t0
INNER JOIN
(`wiki_smw_fpt_inst` AS t2
INNER JOIN
`wiki_smw_fpt_inst` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=3750
AND (t4.o_id=2968)
)
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 225 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | dc_wiki.t4.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | dc_wiki.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:0
Errors and Warnings
None- 2018-09-28: Be Kind, Remind
- 2018-09-28: Outreach Gathering
- 2018-09-29: The Amazing Spider-Kalve
- 2018-09-29: The War-Giant
- 2018-09-30: Site Recon in St Centour
- 2018-09-30: Star in the Darkness
- 2018-10-02: It's Okay to be Scared
- 2018-10-04: Crab And Butterfly
- 2018-10-04: Dance With Me
- 2018-10-04: Just a Little Glint
- 2018-10-04: Let's Hope It's Not Contagious
- 2018-10-04: Some Time to Spare
- 2018-10-05: Constriction
- 2018-10-06: Returning to Duty
- 2018-10-07: A Ceremony at Sea
- 2018-10-08: Walking The Hard Road
- 2018-10-09: Go Fish
- 2018-10-09: Please Rely On Us
- 2018-10-09: The Journey More Pleasant
- 2018-10-09: White Flowers and Balms
- 2018-10-11: Swimming Lessons
- 2018-10-11: You Can Yet Fly Higher
- 2018-10-12: Forest Of Blades
- 2018-10-12: It's ( not important )
- 2018-10-12: The New Church
- 2018-10-12: Timing Most Fortuitous
- 2018-10-13: The Fine Distinction Between Fear and Cowardice
- 2018-10-14: Horsing Around
- 2018-10-14: Lost Lunar Lambs
- 2018-10-14: The Mark(etability) of a Hero
- 2018-10-14: Within ARMs' Reach
- 2018-10-15: The Source of Impurity
- 2018-10-15: Where the Sky Leads
- 2018-10-16: Settling The Past
- 2018-10-16: Survivors
- 2018-10-16: The Shepherd, The Wolf and The Lion
- 2018-10-16: Vale Of Twisting Metal
- 2018-10-17: One Single Memory
- 2018-10-17: Profane Ground of Chets
- 2018-10-19: No Extreme Routine
- 2018-10-19: Returning to the Silent Home
- 2018-10-19: The First Ordeal
- 2018-10-20: In the Heart of the Mirage
- 2018-10-20: Metal Demons Visit the Port
- 2018-10-22: My Little Nemesis Can't Be This Cute!
- 2018-10-22: Now, Engage Yourself To Me
- 2018-10-23: Until Then, and Forever After
- 2018-10-26: Lava Quod Est Sordium
- 2018-10-26: Voicing Concerns
- 2018-10-27: ARMed And Dangerous