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
500
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
500
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 25170 | 25170 | 1987 | LDE1300 | 1435 mm | SP32-021 | Polskie Koleje Państwowe | |
LDE1300 25171 | 25171 | 1987 | LDE1300 | 1435 mm | SP32-022 | Polskie Koleje Państwowe | |
LDE1300 25172 | 25172 | 1987 | LDE1300 | 1435 mm | SP32-023 | Polskie Koleje Państwowe | |
LDE1300 25173 | 25173 | 1987 | LDE1300 | 1435 mm | SP32-024 | Polskie Koleje Państwowe | |
LDE1300 25174 | 25174 | 1987 | LDE1300 | 1435 mm | SP32-025 | Polskie Koleje Państwowe | |
LDE1300 25175 | 25175 | 1987 | LDE1300 | 1435 mm | SP32-028 | Polskie Koleje Państwowe | |
LDE1300 25176 | 25176 | 1987 | LDE1300 | 1435 mm | SP32-029 | Polskie Koleje Państwowe | |
LDE1300 25177 | 25177 | 1987 | LDE1300 | 1435 mm | SP32-030 | Polskie Koleje Państwowe | |
LDE1300 25178 | 25178 | 1987 | LDE1300 | 1435 mm | SP32-031 | Polskie Koleje Państwowe | |
LDE1300 25179 | 25179 | 1987 | LDE1300 | 1435 mm | SP32-032 | Polskie Koleje Państwowe | |
LDE1300 25180 | 25180 | 1987 | LDE1300 | 1435 mm | SP32-026 | Polskie Koleje Państwowe | |
LDE1300 25181 | 25181 | 1987 | LDE1300 | 1435 mm | SP32-027 | Polskie Koleje Państwowe | |
LDE1300 25265 | 25265 | 1987 | LDE1300 | 1435 mm | SP32-033 | Polskie Koleje Państwowe | |
LDE1300 25266 | 25266 | 1987 | LDE1300 | 1435 mm | SP32-034 | Polskie Koleje Państwowe | |
LDE1300 25267 | 25267 | 1987 | LDE1300 | 1435 mm | SP32-035 | Polskie Koleje Państwowe | |
LDE1300 25268 | 25268 | 1987 | LDE1300 | 1435 mm | SP32-036 | Polskie Koleje Państwowe | |
LDE1300 25269 | 25269 | 1987 | LDE1300 | 1435 mm | SP32-037 | Polskie Koleje Państwowe | |
LDE1300 25270 | 25270 | 1987 | LDE1300 | 1435 mm | SP32-038 | Polskie Koleje Państwowe | |
LDE1300 25271 | 25271 | 1987 | LDE1300 | 1435 mm | SP32-039 | Polskie Koleje Państwowe | |
LDE1300 25272 | 25272 | 1987 | LDE1300 | 1435 mm | SP32-040 | Zakład Taboru we Wrocławiu | |
LDE1300 25273 | 25273 | 1987 | LDE1300 | 1435 mm | SP32-041 | Polskie Koleje Państwowe | |
LDE1300 25274 | 25274 | 1987 | LDE1300 | 1435 mm | SP32-042 | Polskie Koleje Państwowe | |
LDE1300 25275 | 25275 | 1987 | LDE1300 | 1435 mm | SP32-043 | Polskie Koleje Państwowe | |
LDE1300 25276 | 25276 | 1987 | LDE1300 | 1435 mm | SP32-044 | Polskie Koleje Państwowe | |
LDE1300 25277 | 25277 | 1987 | LDE1300 | 1435 mm | SP32-045 | Polskie Koleje Państwowe | |
LDE1300 25278 | 25278 | 1987 | LDE1300 | 1435 mm | SP32-046 | Polskie Koleje Państwowe | |
LDE1300 25279 | 25279 | 1987 | LDE1300 | 1435 mm | SP32-047 | Polskie Koleje Państwowe | |
LDE1300 25280 | 25280 | 1987 | LDE1300 | 1435 mm | SP32-048 | Polskie Koleje Państwowe | |
LDE1300 25281 | 25281 | 1987 | LDE1300 | 1435 mm | SP32-049 | Polskie Koleje Państwowe | |
LDE1300 25282 | 25282 | 1987 | LDE1300 | 1435 mm | SP32-050 | Polskie Koleje Państwowe | |
LDE1300 25283 | 25283 | 1987 | LDE1300 | 1435 mm | SP32-051 | Polskie Koleje Państwowe | |
LDE1300 25284 | 25284 | 1987 | LDE1300 | 1435 mm | SP32-052 | Polskie Koleje Państwowe | |
LDE1300 25305 | 25305 | 1987 | LDE1300 | 1435 mm | SP32-053 | Polskie Koleje Państwowe | |
LDE1300 25306 | 25306 | 1987 | LDE1300 | 1435 mm | SP32-054 | Polskie Koleje Państwowe | |
LDE1300 25307 | 25307 | 1987 | LDE1300 | 1435 mm | SP32-055 | Polskie Koleje Państwowe | |
LDE1300 25308 | 25308 | 1987 | LDE1300 | 1435 mm | SP32-056 | Polskie Koleje Państwowe | |
LDE1300 25309 | 25309 | 1987 | LDE1300 | 1435 mm | SP32-057 | Polskie Koleje Państwowe | |
LDE1300 25310 | 25310 | 1987 | LDE1300 | 1435 mm | SP32-058 | Polskie Koleje Państwowe | |
LDE1300 25311 | 25311 | 1987 | LDE1300 | 1435 mm | SP32-059 | Polskie Koleje Państwowe | |
LDE1300 25312 | 25312 | 1987 | LDE1300 | 1435 mm | SP32-060 | Polskie Koleje Państwowe | |
LDE1300 25313 | 25313 | 1987 | LDE1300 | 1435 mm | SP32-061 | Polskie Koleje Państwowe | |
LDE1300 25314 | 25314 | 1987 | LDE1300 | 1435 mm | SP32-062 | Polskie Koleje Państwowe | |
LDE1300 25315 | 25315 | 1987 | LDE1300 | 1435 mm | SP32-063 | Polskie Koleje Państwowe | |
LDE1300 25316 | 25316 | 1988 | LDE1300 | 1435 mm | SP32-064 | Polskie Koleje Państwowe | |
LDE1300 25317 | 25317 | 1988 | LDE1300 | 1435 mm | SP32-065 | Polskie Koleje Państwowe | |
LDE1300 25318 | 25318 | 1988 | LDE1300 | 1435 mm | SP32-066 | Polskie Koleje Państwowe | |
LDE1300 25319 | 25319 | 1988 | LDE1300 | 1435 mm | SP32-067 | Polskie Koleje Państwowe | |
LDE1300 25320 | 25320 | 1988 | LDE1300 | 1435 mm | SP32-068 | Polskie Koleje Państwowe | |
LDE1300 25321 | 25321 | 1988 | LDE1300 | 1435 mm | SP32-069 | Polskie Koleje Państwowe | |
LDE1300 25322 | 25322 | 1988 | LDE1300 | 1435 mm | SP32-070 | Polskie Koleje Państwowe |