Wyszukiwanie semantyczne
Przejdź do nawigacji
Przejdź do wyszukiwania
Query-Depth:1
Debug output SQLStore
ASK Query
[[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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='FAUR') AND t1.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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='FAUR') AND t1.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 | t1 | 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 | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki-enkol.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneTyp / Numer fabryczny | Rok produkcji | Stan | Rozstaw | Typ silnika | Oznaczenie | Stacjonowanie | Uwagi |
---|---|---|---|---|---|---|---|
LDE1300/25170 | 1987 | Nieznany | 1435 mm | M820SR | SP32-021 | Polskie Koleje Państwowe | |
LDE1300/25171 | 1987 | Nieznany | 1435 mm | M820SR | SP32-022 | Polskie Koleje Państwowe | |
LDE1300/25172 | 1987 | Nieznany | 1435 mm | M820SR | SP32-023 | Polskie Koleje Państwowe | |
LDE1300/25173 | 1987 | Nieznany | 1435 mm | M820SR | SP32-024 | Polskie Koleje Państwowe | |
LDE1300/25174 | 1987 | Nieznany | 1435 mm | M820SR | SP32-025 | Polskie Koleje Państwowe | |
LDE1300/25175 | 1987 | Nieznany | 1435 mm | M820SR | SP32-028 | Polskie Koleje Państwowe | |
LDE1300/25176 | 1987 | Nieznany | 1435 mm | M820SR | SP32-029 | Polskie Koleje Państwowe | |
LDE1300/25177 | 1987 | Nieznany | 1435 mm | M820SR | SP32-030 | Polskie Koleje Państwowe | |
LDE1300/25178 | 1987 | Nieznany | 1435 mm | M820SR | SP32-031 | Polskie Koleje Państwowe | |
LDE1300/25179 | 1987 | Nieznany | 1435 mm | M820SR | SP32-032 | Polskie Koleje Państwowe | |
LDE1300/25180 | 1987 | Nieznany | 1435 mm | M820SR | SP32-026 | Polskie Koleje Państwowe | |
LDE1300/25181 | 1987 | Nieznany | 1435 mm | M820SR | SP32-027 | Polskie Koleje Państwowe | |
LDE1300/25265 | 1987 | Nieznany | 1435 mm | M820SR | SP32-033 | Polskie Koleje Państwowe | |
LDE1300/25266 | 1987 | Nieznany | 1435 mm | M820SR | SP32-034 | Polskie Koleje Państwowe | |
LDE1300/25267 | 1987 | Nieznany | 1435 mm | M820SR | SP32-035 | Polskie Koleje Państwowe | |
LDE1300/25268 | 1987 | Nieznany | 1435 mm | M820SR | SP32-036 | Polskie Koleje Państwowe | |
LDE1300/25269 | 1987 | Nieznany | 1435 mm | M820SR | SP32-037 | Polskie Koleje Państwowe | |
LDE1300/25270 | 1987 | Nieznany | 1435 mm | M820SR | SP32-038 | Polskie Koleje Państwowe | |
LDE1300/25271 | 1987 | Nieznany | 1435 mm | M820SR | SP32-039 | Polskie Koleje Państwowe | |
LDE1300/25272 | 1987 | Złom | 1435 mm | M820SR | SP32-040 | Zakład Taboru we Wrocławiu | |
LDE1300/25273 | 1987 | Nieznany | 1435 mm | M820SR | SP32-041 | Polskie Koleje Państwowe | |
LDE1300/25274 | 1987 | Nieznany | 1435 mm | M820SR | SP32-042 | Polskie Koleje Państwowe | |
LDE1300/25275 | 1987 | Nieznany | 1435 mm | M820SR | SP32-043 | Polskie Koleje Państwowe | |
LDE1300/25276 | 1987 | Nieznany | 1435 mm | M820SR | SP32-044 | Polskie Koleje Państwowe | |
LDE1300/25277 | 1987 | Nieznany | 1435 mm | M820SR | SP32-045 | Polskie Koleje Państwowe | |
LDE1300/25278 | 1987 | Nieznany | 1435 mm | M820SR | SP32-046 | Polskie Koleje Państwowe | |
LDE1300/25279 | 1987 | Nieznany | 1435 mm | M820SR | SP32-047 | Polskie Koleje Państwowe | |
LDE1300/25280 | 1987 | Nieznany | 1435 mm | M820SR | SP32-048 | Polskie Koleje Państwowe | |
LDE1300/25281 | 1987 | Nieznany | 1435 mm | M820SR | SP32-049 | Polskie Koleje Państwowe | |
LDE1300/25282 | 1987 | Nieznany | 1435 mm | M820SR | SP32-050 | Polskie Koleje Państwowe | |
LDE1300/25283 | 1987 | Nieznany | 1435 mm | M820SR | SP32-051 | Polskie Koleje Państwowe | |
LDE1300/25284 | 1987 | Nieznany | 1435 mm | M820SR | SP32-052 | Polskie Koleje Państwowe | |
LDE1300/25305 | 1987 | Nieznany | 1435 mm | M820SR | SP32-053 | Polskie Koleje Państwowe | |
LDE1300/25306 | 1987 | Nieznany | 1435 mm | M820SR | SP32-054 | Polskie Koleje Państwowe | |
LDE1300/25307 | 1987 | Nieznany | 1435 mm | M820SR | SP32-055 | Polskie Koleje Państwowe | |
LDE1300/25308 | 1987 | Nieznany | 1435 mm | M820SR | SP32-056 | Polskie Koleje Państwowe | |
LDE1300/25309 | 1987 | Nieznany | 1435 mm | M820SR | SP32-057 | Polskie Koleje Państwowe | |
LDE1300/25310 | 1987 | Nieznany | 1435 mm | M820SR | SP32-058 | Polskie Koleje Państwowe | |
LDE1300/25311 | 1987 | Nieznany | 1435 mm | M820SR | SP32-059 | Polskie Koleje Państwowe | |
LDE1300/25312 | 1987 | Nieznany | 1435 mm | M820SR | SP32-060 | Polskie Koleje Państwowe | |
LDE1300/25313 | 1987 | Nieznany | 1435 mm | M820SR | SP32-061 | Polskie Koleje Państwowe | |
LDE1300/25314 | 1987 | Nieznany | 1435 mm | M820SR | SP32-062 | Polskie Koleje Państwowe | |
LDE1300/25315 | 1987 | Nieznany | 1435 mm | M820SR | SP32-063 | Polskie Koleje Państwowe | |
LDE1300/25316 | 1988 | Nieznany | 1435 mm | M820SR | SP32-064 | Polskie Koleje Państwowe | |
LDE1300/25317 | 1988 | Nieznany | 1435 mm | M820SR | SP32-065 | Polskie Koleje Państwowe | |
LDE1300/25318 | 1988 | Nieznany | 1435 mm | M820SR | SP32-066 | Polskie Koleje Państwowe | |
LDE1300/25319 | 1988 | Nieznany | 1435 mm | M820SR | SP32-067 | Polskie Koleje Państwowe | |
LDE1300/25320 | 1988 | Nieznany | 1435 mm | M820SR | SP32-068 | Polskie Koleje Państwowe | |
LDE1300/25321 | 1988 | Nieznany | 1435 mm | M820SR | SP32-069 | Polskie Koleje Państwowe | |
LDE1300/25322 | 1988 | Nieznany | 1435 mm | M820SR | SP32-070 | Polskie Koleje Państwowe |