Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Geistlicher]]
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='Geistlicher') 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
1000
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='Geistlicher') 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
1000
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 | o_hash | 258 | const | 66336 | Using index condition; 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
NoneB
- Bals, Anton (*1679)
- Bals, Christoph
- Bals, Erhard
- Bals, Johann (Geistlicher) ( †1656)
- Bals, Michael (1642) (*1642)
- Balthasar (1497) (*1497 JL)
- Balthasar (1497, Geistlicher) (*1497 JL)
- Balthasar (Geistlicher)
- Balthasar (Pfarrer, G3283)
- Balthasar, Johann (Geistlicher)
- Balthasar, Johann Melchior (*1604 †1659)
- Balthasar, Philipp
- Balthasar, Von
- Balthasaris, Dominik
- Baluner, Johann ( †1481 JL)
- Balzer, Johann Georg (Alvaschein) ( †1840)
B Fortsetzung
-
Balzer, Johann Jakob (*1703)
- Balzer, Ulrich
- Balzin, Matthäus
- Bamberger, Jakob
- Bamberger, Jakob Augustin (*1719)
- Bamberger, Ulrich
- Bamer, Johann (Hemau)
- Bamer, Johann Jakob (*1721 †1771)
- Bamp, Ulrich (*1470 JL †1482 JL)
- Bamül, Peter
- Banchere, Johann Baptist ( †1797)
- Banf, Ernst
- Banhof, Johann
- Banhofer, Wolfgang
- Banholz, Georg (Ehingen)
- Banholz, Jakob
- Banholz, Matthias ( †1491 JL)
B Fortsetzung
- Bankschiele, Johann Tiberius ( †1592)
- Bannwart, Georg
- Bannwart, Heinrich
- Bannwart, Ignaz (1744) (*1744 †1801)
- Bannwart, Ignaz (Sigmaringen) ( †1801)
- Bannwart, Jakob (1608) (*1608)
- Bannwart, Johann (Geistlicher) ( †1480 JL)
- Bannwart, Johann Anton (*1696)
- Bannwart, Sixt
- Bantel, Christoph (Dillingen, Geistlicher)
- Bantel, Dionysius
- Bantel, Franz Anton (1708) (*1708)
- Bantele, Johann (Geistlicher)
- Bantele, Johann Bernhard (*1720)
- Bantele, Johann Georg (*1761 †1818)