Wyszukiwanie semantyczne
Przejdź do nawigacji
Przejdź do wyszukiwania
Query-Depth:1
Debug output SQLStore
ASK Query
[[Kategoria:Zestawienie wąskotorowych pojazdów trakcyjnych]] [[Lw producent::FAUR]]
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
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=39559
AND (
(t4.o_hash='FAUR') AND t4.p_id=39367)
)
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
550
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
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=39559
AND (
(t4.o_hash='FAUR') AND t4.p_id=39367)
)
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
550
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | index_merge | s_id, p_id, s_id_2, o_hash | o_hash,p_id | 258,262 | 27 | Using intersect(o_hash,p_id); Using where; Using temporary; Using filesort | ||
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | wiki-enkol.t4.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki-enkol.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneMetryka | Numer seryjny | Rok produkcji | Typ fabryczny | Rozstaw | Ostatnie oznaczenie | Ostatnie stacjonowanie | Uwagi |
---|---|---|---|---|---|---|---|
LDE1300 25323 | 25323 | 1988 | LDE1300 | 1435 mm | SP32-071 | Polskie Koleje Państwowe | |
LDE1300 25324 | 25324 | 1988 | LDE1300 | 1435 mm | SP32-072 | Polskie Koleje Państwowe | |
LDE1300 25337 | 25337 | 1988 | LDE1300 | 1435 mm | SP32-073 | Polskie Koleje Państwowe | |
LDE1300 25338 | 25338 | 1988 | LDE1300 | 1435 mm | SP32-074 | Polskie Koleje Państwowe | |
LDE1300 25339 | 25339 | 1988 | LDE1300 | 1435 mm | SP32-075 | Polskie Koleje Państwowe | |
LDE1300 25340 | 25340 | 1988 | LDE1300 | 1435 mm | SP32-076 | Polskie Koleje Państwowe | |
LDE1300 25341 | 25341 | 1988 | LDE1300 | 1435 mm | SP32-077 | Polskie Koleje Państwowe | |
LDE1300 25342 | 25342 | 1988 | LDE1300 | 1435 mm | SP32-078 | Polskie Koleje Państwowe | |
LDE1300 25343 | 25343 | 1988 | LDE1300 | 1435 mm | SP32-079 | Polskie Koleje Państwowe | |
LDE1300 25344 | 25344 | 1988 | LDE1300 | 1435 mm | SP32-080 | Polskie Koleje Państwowe | |
LDE1300 25345 | 25345 | 1988 | LDE1300 | 1435 mm | SP32-081 | Polskie Koleje Państwowe | |
LDE1300 25346 | 25346 | 1988 | LDE1300 | 1435 mm | SP32-082 | Polskie Koleje Państwowe | |
LDE1300 25347 | 25347 | 1988 | LDE1300 | 1435 mm | SP32-083 | Polskie Koleje Państwowe | |
LDE1300 25348 | 25348 | 1988 | LDE1300 | 1435 mm | SP32-084 | Polskie Koleje Państwowe | |
LDE1300 25349 | 25349 | 1988 | LDE1300 | 1435 mm | SP32-085 | Polskie Koleje Państwowe | |
LDE1300 25350 | 25350 | 1988 | LDE1300 | 1435 mm | SP32-086 | Polskie Koleje Państwowe | |
LDE1300 25351 | 25351 | 1988 | LDE1300 | 1435 mm | SP32-087 | Polskie Koleje Państwowe | |
LDE1300 25352 | 25352 | 1988 | LDE1300 | 1435 mm | SP32-088 | Polskie Koleje Państwowe | |
LDE1300 25353 | 25353 | 1988 | LDE1300 | 1435 mm | SP32-089 | Polskie Koleje Państwowe | |
LDE1300 25354 | 25354 | 1988 | LDE1300 | 1435 mm | SP32-090 | Polskie Koleje Państwowe | |
LDE1300 25355 | 25355 | 1988 | LDE1300 | 1435 mm | SP32-091 | Polskie Koleje Państwowe | |
LDE1300 25356 | 25356 | 1988 | LDE1300 | 1435 mm | SP32-092 | Polskie Koleje Państwowe | |
LDE1300 25357 | 25357 | 1988 | LDE1300 | 1435 mm | SP32-093 | Polskie Koleje Państwowe | |
LDE1300 25358 | 25358 | 1988 | LDE1300 | 1435 mm | SP32-094 | Polskie Koleje Państwowe | |
LDE1300 25359 | 25359 | 1988 | LDE1300 | 1435 mm | SP32-095 | Polskie Koleje Państwowe | |
LDE1300 25360 | 25360 | 1988 | LDE1300 | 1435 mm | SP32-096 | Polskie Koleje Państwowe | |
LDE1300 25361 | 25361 | 1988 | LDE1300 | 1435 mm | SP32-097 | Polskie Koleje Państwowe | |
LDE1300 25362 | 25362 | 1988 | LDE1300 | 1435 mm | SP32-098 | Polskie Koleje Państwowe | |
LDE1300 25363 | 25363 | 1988 | LDE1300 | 1435 mm | SP32-099 | Polskie Koleje Państwowe | |
LDE1300 25364 | 25364 | 1988 | LDE1300 | 1435 mm | SP32-100 | Polskie Koleje Państwowe | |
LDE1300 25365 | 25365 | 1988 | LDE1300 | 1435 mm | SP32-101 | Polskie Koleje Państwowe | |
LDE1300 25366 | 25366 | 1988 | LDE1300 | 1435 mm | SP32-102 | Polskie Koleje Państwowe | |
LDE1300 25410 | 25410 | 1988 | LDE1300 | 1435 mm | SP32-103 | Polskie Koleje Państwowe | |
LDE1300 25411 | 25411 | 1988 | LDE1300 | 1435 mm | SP32-104 | Polskie Koleje Państwowe | |
LDE1300 25412 | 25412 | 1988 | LDE1300 | 1435 mm | SP32-105 | Polskie Koleje Państwowe | |
LDE1300 25413 | 25413 | 1988 | LDE1300 | 1435 mm | SP32-106 | Polskie Koleje Państwowe | |
LDE1300 25414 | 25414 | 1988 | LDE1300 | 1435 mm | SP32-107 | Polskie Koleje Państwowe | |
LDE1300 25415 | 25415 | 1988 | LDE1300 | 1435 mm | SP32-108 | Polskie Koleje Państwowe | |
LDE1300 25416 | 25416 | 1988 | LDE1300 | 1435 mm | SP32-109 | Polskie Koleje Państwowe | |
LDE1300 25417 | 25417 | 1989 | LDE1300 | 1435 mm | SP32-110 | Polskie Koleje Państwowe | |
LDE1300 25418 | 25418 | 1989 | LDE1300 | 1435 mm | SP32-111 | Polskie Koleje Państwowe | |
LDE1300 25419 | 25419 | 1989 | LDE1300 | 1435 mm | SP32-112 | Polskie Koleje Państwowe | |
LDE1300 25420 | 25420 | 1989 | LDE1300 | 1435 mm | SP32-113 | Polskie Koleje Państwowe | |
LDE1300 25421 | 25421 | 1989 | LDE1300 | 1435 mm | SP32-114 | Polskie Koleje Państwowe | |
LDE1300 25422 | 25422 | 1989 | LDE1300 | 1435 mm | SP32-115 | Polskie Koleje Państwowe | |
LDE1300 25423 | 25423 | 1989 | LDE1300 | 1435 mm | SP32-116 | Polskie Koleje Państwowe | |
LDE1300 25424 | 25424 | 1989 | LDE1300 | 1435 mm | SP32-117 | Polskie Koleje Państwowe | |
LDE1300 25425 | 25425 | 1989 | LDE1300 | 1435 mm | SP32-118 | Polskie Koleje Państwowe | |
LDE1300 25426 | 25426 | 1989 | LDE1300 | 1435 mm | SP32-119 | Polskie Koleje Państwowe | |
LDE1300 25427 | 25427 | 1989 | LDE1300 | 1435 mm | SP32-120 | Polskie Koleje Państwowe |