Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Schulmeister]]
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='Schulmeister') 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='Schulmeister') 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 | ref | s_id, o_hash, s_id_2, p_id | p_id | 262 | const, const | 1285 | Using index condition; 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
- Kaiser, Franz Xaver (1709) (*1709)
- Kaiser, Joseph Franz (*1717)
- Kaiser, Paul (Heilbronn)
- Kaiser, Theophil Gottlieb (Dischingen)
- Kaiser, Wolfgang Damian (*1704)
- Kalb, Thomas (Kirchenlaibach)
- Kaltenhofen, Johann ( †1495 JL)
- Kaltschmid, Johann (Zürich)
- Kamerad, David (*1551 JL †1624)
- Karl, Moritz (Höfstätten)
- Karrer, Johann (Mömpelgard)
- Karrner, Jakob (Schulmeister)
- Kastel, Georg (Augsburg)
- Kauer, Konrad
- Kaufmann, Christoph (Schulmeister)
- Kauschburg, Georg
K Fortsetzung
- Keller, Johann Georg (1591) (*1591)
- Kellermann, Lorenz (1544) (*1544 JL †1619)
- Keltermann
- Kepritz, Leonhard
- Kerber, Georg (Nürnberg) ( †1620)
- Kerber, Georg (Wöhrd) ( †1604)
- Kerling, Georg (Oberviechtach)
- Kern, Georg (Schulmeister)
- Kerner, Johann (Hohenburg)
- Kerner, Leonhard (Velburg)
- Kerr, Manilas Manilius
- Kessler, Augustin
- Kessler, Johann (Adorf) ( †1615)
- Kessler, Johann (Wiesensteig)
- Kienzel, Blasius
- Kiesler, Michael (Schulmeister)
K Fortsetzung
-
Kindler, Jakob (1570) (*1570 JL)
- Kircher, Simon (1748) (*1748 †1784)
- Kircher, Simon (Pfalzen) ( †1784)
- Kirchmeier, Balthasar (Schulmeister)
- Kirchmeier, Nikolaus (1593) (*1593 †1633)
- Kirner, Michael (Schulmeister)
- Kirsteiner, Michael (*1555 JL)
- Kistner, Christoph (1551) (*1551 JL †1607)
- Kittlinger, Wolfgang
- Klausberger, Georg
- Kleber, Johann (Studium)
- Klee, Stephan
- Klein, Johann (Schulmeister)
- Klein, Sebastian (Burgheim)
- Klusner, Michael
- Knespel, Jakob