Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Deutschordensritter]]
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='Deutschordensritter') 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='Deutschordensritter') 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 | 145 | 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
- Adler, Joseph Karl
- Altmann, Alois (Pfarrer)
- Ampringen, Johann Kaspar von (*1619 †1684)
- Andlau, Balthasar von (Wittenheim)
- Andlau, Georg von (Deutschordensritter)
- Andlau, Johann Baptist Christoph von (*1715 †1788)
- Andreas (Pfarrer, E26414)
- Anselm, Wilhelm
- Arnold (Pfarrer, E13810)
- Arnstein, Johann
- Arter, Wolfgang Wilhelm ( †1466 JL)
- Ast, Johann de
- Aue, Sebastian von
B
B Fortsetzung
- Bader, Peter (Röfingen) ( †1526 JL)
- Baier, Georg (Deutschordensritter)
- Balneator, Georg ( †1575 JL)
- Barner, Nikolaus (Lauchheim)
- Bauer, Karl (Pfarrer)
- Bauer, Michael G.
- Bauernbier, Philipp
- Baum, Johann Georg
- Baumann, Johann (Pfarrer, B42740)
- Baumeister
- Baumhauer, Johann Heinrich
- Beck, Alois (1757) (*1757)
- Beckhard, Marquard
- Beienburg, Heinrich von
- Beienburg-Aistegen-Baumgarten, Friedrich von
- Bender, Johann (Pfarrer)
B Fortsetzung
-
Benz, Franz Reinhard (*1679 †1749)
- Benz, Johann Jakob (Altshausen)
- Berndorf, Philipp Albert von (*1629 †1666)
- Bernhausen-Herrlingen-Klingenstein, Ferdinand Alexander Maria Stanislaus von (*1700 †1748)
- Bert, Johann (Pfarrer)
- Berthold (Pfarrer, E13811)
- Besch, Wolfgang
- Beser, Johann (Pfarrer)
- Biber, Christoph (*1760 †1800)
- Biber, Gabriel (Schwäbisch Hall)
- Biber, Johann Ulrich Christoph (*1710 †1775)
- Bibra, Karl Rudolph Freiherr von
- Bidermann, Ambrosius
- Biller, Kaspar
- Binger, Johann (Heidenfeld)
- Bittel, Sebastian