Ricerca semantica
Vai alla navigazione
Vai alla ricerca
Query-Depth:0
Debug output SQLStore
ASK Query
[[Categoria:Universo dello Specchio]]
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 t1
INNER JOIN
`wiki_t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
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 t1
INNER JOIN
`wiki_t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
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 | t2 | ALL | PRIMARY | 8 | Using temporary; Using filesort | ||||
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | wikitrek.t2.id | 45 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wikitrek.t1.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) (1079).
SELECT s_id FROM `wiki_smw_fpt_subc` WHERE o_id=1079 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- Impero Terrestre
- In a Mirror, Darkly - Part I
- In a Mirror, Darkly - Part II
- Into the Forest I Go
- Jadzia Dax (specchio)
- James T. Kirk (specchio)
- Jennifer Sisko (specchio)
- Joann Owosekun (specchio)
- Jonathan Archer (specchio)
- Julian Bashir (specchio)
- Kelby (Specchio)
- Kira Nerys (specchio)
- Kyle (specchio)
- Leeta (specchio)
- Leonard McCoy (specchio)
- MACO (Specchio)
- Malcolm Reed (specchio)
- Marlena Moreau (specchio)
- Maxwell Forrest (specchio)
- McKenzie (specchio)
- Miles O'Brien (specchio)
- Mirror, Mirror
- Mirrors
- Montgomery Scott (specchio)
- Nyota Uhura (specchio)
- Occultamento sulibano
- Odo (specchio)
- Pavel Chekov (specchio)
- Phlox (specchio)
- Quark (specchio)
- R.A. Bryce (specchio)
- Regency One
- Resistenza Terrestre
- Resurrection
- Rom (specchio)
- Shattered Mirror
- Slar
- Soval (specchio)
- Spock (specchio)
- T'Pol (specchio)
- Telok
- Terev
- Terok Nor
- Terra Firma, Part 1
- Terra Firma, Part 2
- The Emperor's New Cloak
- The Tholian Web
- The Wolf Inside
- Through the Looking Glass
- Travis Mayweather (specchio)