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
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='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
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 | 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
NoneA
-
Angrüner, Nikolaus (*1627)
- Angsbeck, Johann
- Angst, Konrad (Heidelsheim)
- Anhell, Johann Karl Borromäus (*1713 †1760)
- Anhofer, Nikolaus
- Anhofer, Stephan
- Anich, Alois Maximilian (*1778 †1852)
- Animonius, Georg
- Aninger, Georg
- Aniser, Johann Constantius (*1726)
- Ann, Johann
- Anreiter von Ziernfeld, Johann Baptist Gottfried (*1748 †1796)
- Anreiter, Franz (1642) (*1642)
- Anreiter, Franz (Bozen)
- Anselm, Benedikt
- Anselm, Christian
- Anselm, Georg (Geistlicher)
A Fortsetzung
- Anselm, Hieronymus
- Anselm, Johann (Geistlicher)
- Anselm, Konrad (Geistlicher)
- Anselm, Wilhelm
- Ansley, Heinrich ( †1633)
- Anton (Geistlicher) ( †1465 JL)
- Anton (Geistlicher, G41333)
- Anton, Ludwig
- Antonello, Lorenz
- Antonello, Trimius (*1575 JL)
- Antoni, Johann Georg
- Antonigni, Joseph Anton ( †1753)
- Antrecht, Johann Christoph
- Antreter, Joseph Karl von (*1720 †1780)
- Anwalder, Hieronymus
- Anwander, Achatius
A Fortsetzung
- Anwander, Franz Paul (*1783 †1841)
- Anwander, Joseph (1775) (*1775 †1854)
- Anwander, Kaspar
- Anwander, Lorenz (*1606)
- Anwanger, Franz Xaver
- Anweil, Burkhard von
- Apfelteuer, Andreas
- Apinus, Georg Friedrich (*1605 †1635)
- Apollinaris
- Apotheker, Heinrich (Geistlicher)
- Apotheker, Jakob (Freiburg)
- App, Christian
- App, Jakob ( †1585)
- App, Johann (Bodman)
- App, Johann (Geistlicher)