Semantische Suche
Debug output SQLStore
ASK Query
[[Item::Ort]] [[Region::Mittelfranken]]
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 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_hash='Ort') AND t2.p_id=508
AND (
(t4.o_hash='Mittelfranken') AND t4.p_id=504)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
505
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 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_hash='Ort') AND t2.p_id=508
AND (
(t4.o_hash='Mittelfranken') AND t4.p_id=504)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
505
OFFSET
500
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id, o_hash, s_id_2, p_id | p_id | 262 | const, const | 667 | Using index condition; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | rupp.t4.s_id | 1 | Using where | |
1 | SIMPLE | t2 | ref | s_id, o_hash, s_id_2, p_id | s_id | 8 | rupp.t4.s_id, const | 1 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneR
S
- Sammenheim
- Sandsee
- Sausenhofen
- Schabach
- Schalkhausen
- Schambach
- Scheinfeld
- Schillingsfürst
- Schlossberg
- Schnaittach
- Schnodsenbach
- Schopfloch
- Schupf
- Schutzendorf
- Schwabach
- Schwaben
- Schwalbach
- Schwand
- Schwarzenberg
- Schweinau
- Schweinfurt
- Schweinsdorf
- Schwenningen
- Schönberg
- Seckendorf
- Seehaus
- Segnitz
- Segringen
- Siegelsdorf
- Sinbronn
- Sindersdorf
- Solar
- Solnhofen
- Sommersdorf
- Spalt
- Spalth
- Speckfeld
- Speikern
- Spielberg
- Stegbruck
- Stein
- Steinfurt
- Stettberg
- Stetten
- Stettenfels
- Stirn
- Stopfenheim
- Strass
- Strassburg
- Streudorf
S Fortsetzung
T
- Talheim
- Tauberbischofsheim
- Taubergau
- Tauberzell
- Tennenlohe
- Thalheim
- Thalmannsfeld
- Thalmässing
- Theilenberg
- Theilenhofen
- Thierbach
- Trautskirchen
- Treuchtlingen
- Treuf
- Triesdorf
- Trommetsheim
U
- Uehlfeld
- Uffenheim
- Uhlangen
- Ullstadt
- Ulsenheim
- Unterampfrach
- Unterasbach
- Unterfarrnbach
- Unterklingen
- Unterlaimbach
- Unterleinleiter
- Untermässing
- Unternzenn
- Unterschwaningen
- Unterzenn
- Urfersheim
- Ursheim
- Urspring
- Uttenhofen
V
W
W Fortsetzung
- Wald
- Walkershofen
- Wallersbach
- Wallmereshof
- Wallmersbach
- Walting
- Wassertrüdingen
- Wasserzell
- Wattenbach
- Weidelbach
- Weidenbach
- Weigenheim
- Weigenhofen
- Weihenzell
- Weikershof
- Weiltingen
- Weimersheim
- Weinberg
- Weisenburg
- Weisendorf
- Weissenbronn
- Weissenburg
- Weißenburg
- Welbhausen
- Wellerstadt
- Wendelstein
- Wernfels
- Wernsbach
- Westheim
- Wettelsheim
- Wettringen
- Wetzendorf
- Wieseth
- Wilburgstetten
- Wildenholz
- Wilhelmsdorf
- Wilhermsdorf
- Windischeschenbach
- Windsbach
- Windsfeld
- Windsheim
- Wissembourg
- Wittelshofen
- Wittenbach
- Wolframs-Eschenbach
- Wöhrd
- Wörnitz
- Wörth
- Wülzburg
- Würzburg
Z
Ö