Ricerca semantica
Vai alla navigazione
Vai alla ricerca
Query-Depth:0
Debug output SQLStore
ASK Query
[[Categoria:Flotta Stellare]]
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) (1192).
SELECT s_id FROM `wiki_smw_fpt_subc` WHERE o_id=1192 LIMIT 1
Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- Intelligence della Flotta Stellare
- Intrepid
- Linee guida per la squadra di sbarco
- MACO
- Museo della Flotta Stellare
- Ordine 104
- Ordine Generale 1
- Ordine Generale 12
- Ordine Generale 15
- Ordine Generale 24
- Ordine Generale 6
- Ordine Generale 7
- Ordine Speciale 66715
- Ordini Generali e Regolamenti della Flotta Stellare
- Policy di Spostamento Temporale
- Procedura di emergenza Alfa 2
- Progetto Genesis
- Propulsione a Spore
- Protocollo di Sicurezza 28
- Regolamento 121
- Regolamento 157
- Regolamento 191
- Regolamento 3
- Regolamento 42/15
- Regolamento 46A
- Regolamento 476-9
- Ricerca Fase 1
- SS Beagle
- Schema di ricerca Alfa
- Sezione 31
- Shuttle Tipo 6A
- Sonde
- Sottotenente
- Squadra Rossa
- Tenente
- Tenente Comandante
- Terraforming
- USS Bellerophon NCC-74706
- USS Intrepid NCC-74600
- USS Musashi NCC-74660
- USS Olympia
- USS Portland NCC-57418
- USS Revere NCC-595
- USS Sarek
- USS Sentinel NCC-68455
- USS Shiku Maru
- USS Ticonderoga
- USS Voyager NCC-74656