Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Advokat]]
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='Advokat') AND t1.p_id=509)
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='Advokat') AND t1.p_id=509)
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, o_hash, s_id_2, p_id | o_hash,p_id | 258,262 | 225 | 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 | rupp.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneK
-
Kuhhorn, Bernhard (1539) (*1539 JL)
- Kuhhorn, Jakob Friedrich
- Kuhhorn, Johann Reinhard (Speyer)
- Kuhhorn, Johann Ulrich
- Kumpfmüller, Johann Georg
- Kumpthoff, Johann
- Kunkel, Johann Georg
- Kuno, Augustin
- Kuno, Sebastian (*1592 †1655)
- Kurz, Anton (1770) (*1770)
- Kurz, Franz Martin Jakob
- Kölble, Johann Jakob (Worms)
- König, Johann Ludwig (1560) (*1560 JL †1611)
- König, Vinzenz
- Königsbach, Johann (1478) (*1478 JL †1559 JL)
- Kühnckius, Johann Friedrich
- Kühninger, Joseph Anton
K Fortsetzung
-
Kühnle, Wilhelm ( †1615)
- Kümmerle, Johann Christian (*1718 †1803)
L
- Lamm, Hieronymus
- Lang, Johann Philibert
- Lang, Michael (Notar)
- Lang, Philipp (Grossgartach) ( †1541 JL)
- Langenmantel, David (1697) (*1697)
- Langenmantel, Johann David (*1680 †1736)
- Langjahr von Buchberg, Zacharias (*1586 †1623)
- Larcher in Eisegg und Niederhaus, Anton Joseph von (*1752)
- Lasser, Johann Konrad (Villingen) ( †1623)
- Laterner, Joseph Maximilian Friedrich
- Laub, Heinrich
- Lauser, Kaspar
- Leeb, Franz Andreas
- Leibfried, Johann Christoph (*1601 †1633)
L Fortsetzung
- Leistner, Johann Nepomuk von (*1778)
- Leone, Michael von ( †1355 JL)
- Leopold, Johann Sigismund
- Leupold, Konrad
- Leuser, Valentin ( †1613)
- Levo, Franz Matthias von (*1767)
- Lieb, Johann (Advokat)
- Lieb, Johann (Schaffhausen)
- Liebensau, Heinrich von
- Liebhart, Gabriel
- Lilienheim, Christian Gerhard (*1752)
- Limbach, Johann Christoph
- Lind, Hugo
- Lind, Ulrich
- Lindinger, Vitus (*1687)