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
0
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
0
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 |
---|---|---|---|---|---|---|---|
A20D-P 25119 | 25119 | 1986 | A20D-P | 750 mm | MBxd2-215 | Rogów Towarowy Wąskotorowy | Brak wielu części - wyjęte lub rozkradzione. |
A20D-P 25194 | 25194 | 1986 | A20D-P | 785 mm | MBxd2-218 | Rudy | |
A20D-P ?(224) | ?(224) | 1986 | A20D-P | 750 mm | MBxd2-224 | Krośniewice | |
A20D-P b/d | b/d | 1988 | A20D-P | 785mm | Bxhpi 00-450024-236-7 | Rudy | |
A20D-P b/d | b/d | 1988 | A20D-P | 785mm | Bxhpi 00-450024-237-5 | Rudy | |
A20D-P b/d | b/d | 1988 | A20D-P | 785mm | Bxhpi 00-450024-238-3 | Rudy | |
DH30M 21866 | 21866 | 1974 | DH30M | 1000 mm | Mk33-01 | Kopalnia w Diósgyőr | |
DH30M 21867 | 21867 | 1974 | DH30M | 1000 mm | Mk33-02 | Kopalnia w Diósgyőr | |
DH30M 21868 | 21868 | 1974 | DH30M | 1000 mm | Mk33-03 | Kopalnia w Diósgyőr | |
L18H 24828 | 24828 | 1985 | L18H | 760 mm | L18H-001 | Vișeu de Sus | Nazwa własna "Ecaterina"; kolor żółty, obecnie niebieski |
L18H 24857 | 24857 | 1984? | L18H | 760 mm | L 184 003 (?) | CFF Vişeu de Sus | Nazwa własna "Cristina"; kolor żółty, |
L18H 24858 | 24858 | 1984 | L18H | 600 mm | L18H-002 | Mladejov | |
L18H 24860 | 24860 | 1984 | L18H | 600 mm | L18H-004 | Mladejov | |
L18H 24963 | 24963 | 1984 | L18H | b/d | L18H-005 | - | |
L18H 24964 | 24964 | 1984 | L18H | b/d | L18H-006 | - | |
L18H 25162 | 25162 | 1986 | L18H | b/d | L18H-007 | - | |
L18H 25163 | 25163 | 1986 | L18H | b/d | L18H-008 | Amstetten | |
L18H 25665 | 25665 | 1990 | L18H | b/d | L18H-009 | - | |
L18H 25666 | 25666 | 1990 | L18H | b/d | L18H-010 | - | |
L30H 23380 | 23380 | 1977 | L30H | 600 mm | Lyd2-51 | Pinelière w gminie Saint-Germain-d'Arcé | Sprzedana do Francji |
L30H 23381 | 23381 | 1977 | L30H | 600 mm | Lyd2-52 | Żnin Wąsk. | Kolor niebieski |
L30H 23382 | 23382 | 1977 | L30H | 600 mm | Lyd2-53 | Żnin Wąsk. | |
L30H 23383 | 23383 | 1977 | L30H | 600 mm | Lyd2-54 | Białośliwie Wąsk. | Barwa pomarańczowa |
L30H 23384 | 23384 | 1977 | L30H | 600 mm | Lyd2-55 | Żnin Wąsk. | Kolor niebieski |
L30H 23385 | 23385 | 1978 | L30H | 600 mm | Lyd2-56 | Białośliwie Wąsk. | Od 2017 imię "Rubinek" |
L30H 23386 | 23386 | 1977 | L30H | 600 mm | Lyd2-57 | Żnin Wąsk. | Kolor czerwony |
L30H 23387 | 23387 | 1977 | L30H | 597 mm | Lyd2-58 | Welsh Highland Heritage Railway |
|
L30H 23388 | 23388 | 1977 | L30H | 600 mm | Lyd2-59 | Zakłady Naprawcze Taboru Kolejowego w Ostrowie Wielkopolskim | Kolor niebieski |
L30H 23389 | 23389 | 1977 | L30H | 597 mm | 60 Eryri | Welsh Highland Heritage Railway |
|
L30H 23390 | 23390 | 1977 | L30H | 600 mm | Lyd2-61 | Firma "TransMot" w Bydgoszczy | Kolor czerwony |
L30H 23391 | 23391 | 1977 | L30H | 600 mm | Lyd2-062 | Tabor Dębica | Kolor niebieski |
L30H 23392 | 23392 | 1977 | L30H | 750 mm | LP-Lyd2-01 | Majdan | Kolor czerwony (wąski biały pas, poziomy na ścianie przedniej, czołownice czerwono-białe, przynajmniej od 2014 czarno-białe) |
L30H 23393 | 23393 | 1977 | L30H | 750 mm | LP-Lyd2-02 | Majdan | Kolor czerwony |
L30H 23394 | 23394 | 1977 | L30H | 750 mm | KJ-Lyd2-01 | Kopalnia Węgla Kamiennego "Janina" | Kolor niebieski |
L30H 23395 | 23395 | 1977 | L30H | 750 mm | KJ-Lyd2-02 | Protor Dzierżno | Kolor czerwony |
L30H 23396 | 23396 | 1977 | L30H | 762 mm | Lyd2-1 | St. Kitts Scenic Railway, Karaiby |
|
L30H 23397 | 23397 | 1977 | L30H | 760 mm | TU38.001 | Třemešná ve Šlezsku |
|
L30H 23398 | 23398 | 1977 | L30H | 750 mm | CW-Lyd2-01 | Cukrownia Włostów | |
L30H 23399 | 23399 | 1977 | L30H | 750 mm | CW-Lyd2-02 | Cukrownia Łubna | |
L30H 23400 | 23400 | 1977 | L30H | 750 mm | CW-Lyd2-03 | Cukrownia Włostów | |
L30H 23410 | 23410 | 1977 | L30H | 785 mm | HP-Lyd2-01 | Huta Pokój |
|
L30H 23411 | 23411 | 1977 | L30H | 785 mm | HP-Lyd2-02 | Huta Pokój |
|
L30H 23412 | 23412 | 1977 | L30H | 785 mm | HP-Lyd2-03 | Huta Pokój |
|
L30H 23413 | 23413 | 1977 | L30H | 785 mm | HP-Lyd2-04 | Huta Pokój |
|
L30H 23414 | 23414 | 1977 | L30H | 785 mm | HP-Lyd2-05 | Huta Pokój |
|
L30H 23415 | 23415 | 1977 | L30H | 785 mm | HP-Lyd2-06 | Huta Pokój |
|
L30H 23416 | 23416 | 1977 | L30H | 785 mm | KD-Lyd2-01 | Kopalnia Węgla Kamiennego "Centrum" | Kolor czerwony |
L30H 23417 | 23417 | 1977 | L30H | 785 mm | H1M-Lyd2-01 | Huta Gliwice |
|
L30H 23418 | 23418 | 1977 | L30H | 785 mm | H1M-Lyd2-02 | nieznane |
|
L30H 23419 | 23419 | 1977 | L30H | 785 mm | H1M-Lyd2-03 | nieznane |
|