Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Pfleger]]
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='Pfleger') 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='Pfleger') 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 | 4288 | 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
NoneB
- Bullinger, Degenhard
- Bullinger, Erasmus
- Bullinger, Georg (Pfleger)
- Bullinger, Hermann Johann
- Bunzinger, Georg
- Bunzinger, Kaspar
- Burg, Friedrich
- Burgau in Griesbeckerzell, Johann Jakob Desiderius Freiherr von (*1650 †1726)
- Burgau zu Leibersdorf, Johann Hubert Heinrich Erhard von ( †1758)
- Burgau, Franz Jakob Anton Freiherr von (*1680)
- Burger, Martin (Pfleger)
- Burger, Wilhelm (Pfleger)
- Burggraf, Ulrich (Pfleger) ( †1549 JL)
- Burgstall, Gallus von
- Burgstall, Volkmar
- Burgstaller, Ulrich (Pfleger)
B Fortsetzung
- Busch von Vilsheim, Georg ( †1542 JL)
- Busch, Gabriel
- Busch, Johann (Pfleger)
- Busch, Wolfgang ( †1532 JL)
- Butzinger, Kaspar
- Bönninghausen, Engelbert von ( †1622)
- Bös, Ludwig ( †1520 JL)
- Bühler von Weitenegg, Albrecht
- Bühler, Albrecht ( †1483 JL)
- Bühler, Egloff
- Bühler, Johann (Pfleger)
- Bühler, Leonhard (Pfleger)
C
C Fortsetzung
- Cesana-Colle-Langquart-Bompruch, Joseph Heinrich Anton Ignaz Maria Graf von ( †1762)
- Chabo, Philibert von ( †1719)
- Chabo, Sigismund Ferdinand von
- Chlingensberg, Hermann Anton Maria (*1685 †1755)
- Chraüstorf, Vinzenz
- Christ, Peter
- Cilli, Hermann Graf von
- Clement, Wolf
- Closen (*1550 JL)
- Closen in Haidenburg, Franz Freiherr von
- Closen in Haidenburg, Georg Joseph Anton Freiherr von
- Closen zu Arnstorf und Gern, Georg Ferdinand Freiherr von ( †1699)
- Closen zu Stubenberg und Haidenburg, Stephan von (*1509 JL)
- Closen, Alban von
- Closen, Georg von