Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Amtmann]]
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='Amtmann') 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
0
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='Amtmann') 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
0
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 | 189 | 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
NoneA
- Abt, Gabriel (*1752)
- Ackermann, Benedikt (1604) (*1604 †1670)
- Ackermann, Benedikt (Vogt)
- Ackermann, Franz Konrad (*1755)
- Adelsheim, Johann Philipp von (*1643 †1694)
- Alt, Johann (1517) (*1517 JL †1558 JL)
- Ammann, Johann Georg (Amtmann)
- Ammann, Matthias (Wackershofen)
- Ampringen, Johann Christoph von (Oberambringen)
- Andermatt, Franz Bartholomäus (*1707 †1743)
- Anderwert, Georg Joseph (*1767 †1841)
- Andler, Peter
- Apotheker, Johann (Tübingen)
- Arco, Peter Anton Graf von ( †1750)
- Arzberger, Johann Friedrich (Baiersdorf)
- Aschmann, Georg
A Fortsetzung
-
Auer, Anton Ignaz Franz Roger (*1725)
- Auer, Wolfgang Christoph (*1687)
B
-
Babel, Franz Xaver (*1733)
- Baier von Buchholz, Franz Anton (*1679 †1745)
- Baier, Alois Sigismund (*1680)
- Baier, Anton Joseph (Biberach)
- Baier, Gallus ( †1679)
- Baier, Johann Stephan (*1645 †1714)
- Baier, Quirin
- Banchero, Franz ( †1849)
- Banholzer, Georg
- Bannwart, Ferdinand Dominik Anton (*1730 †1776)
- Bardt, Johann Georg
- Bartel, Wilhelm ( †1778)
- Batti, Franz Xaver (*1750 †1821)
- Bauer von Breitenfeld, Johann Fidelis
- Bauer, Johann Ulrich (Tübingen)
B Fortsetzung
-
Bauer, Joseph Alexander (*1749)
- Baumann, Franz Joseph Ignaz Bernhard (*1731 †1798)
- Baumeister, Ignaz Friedrich
- Baumgartner, Joseph Ignaz Jodocus
- Bautenbacher, Franz Xaver (*1711 †1790)
- Becht, Georg (Reutlingen) ( †1530 JL)
- Beck, Christoph Benedikt
- Beck, Johann Georg (1699) (*1699 †1771)
- Beck, Johann Georg (1764) (*1764)
- Beer, Elias Ignaz (*1706)
- Beer, Joseph Gebhard
- Behaim, Johann (1527) (*1527 JL)
- Behlen, Johann Michael
- Beiner, Franz Joseph ( †1765)
- Belli von Pino, Alfons Maria
- Bellosier, Walter