Semantische Suche
Debug output SQLStore
ASK Query
[[Nachname::Meier]] [[Person::!Meier (Forstmeister)]]
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 t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_hash='Meier') AND t2.p_id=525
AND (
(t4.o_hash!='Meier (Forstmeister)') AND t4.p_id=528)
)
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 t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_hash='Meier') AND t2.p_id=525
AND (
(t4.o_hash!='Meier (Forstmeister)') AND t4.p_id=528)
)
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 | t2 | index_merge | s_id, o_hash, s_id_2, p_id | o_hash,p_id | 258,262 | 918 | 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.t2.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, o_hash, s_id_2, p_id | s_id | 8 | rupp.t2.s_id, const | 1 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
None- Meier, Augustin (Augustinerchorherr) - Augustinerchorherr, Kanoniker
- Meier, Augustin (Augustinerchorherr, D29571) - Augustinerchorherr, Kanoniker
- Meier, Augustin (Deggendorf) - Studium
- Meier, Augustin (Dillingen) - Mönch, Benediktiner
- Meier, Augustin (Dillingen, Priester) - Priester, Mönch, Benediktiner
- Meier, Augustin (Dominikaner) - Dominikaner
- Meier, Augustin (Forstmeister) - Forstmeister, Landschreiber
- Meier, Augustin (Freiburg/Br.) - Studium
- Meier, Augustin (Kanoniker) - Kanoniker, Augustinerchorherr
- Meier, Augustin (Kanoniker, A26320) - Kanoniker, Augustinerchorherr
- Meier, Augustin (Landshut) - Studium, Zoller
- Meier, Augustin (Pfarrer) - Pfarrer, Kanoniker, Augustinerchorherr
- Meier, Augustin (Schwaben) - Studium
- Meier, Augustin (Studium) - Studium, Kassenverwalter, Rat
- Meier, Augustin Almachius - Studium, Kapuziner, Mönch
- Meier, Augustin Euphronius - Franziskaner, Mönch
- Meier, Aurelius - Franziskaner, Mönch
- Meier, Balthasar (1593) - Jesuit
- Meier, Balthasar (1608) - Priester
- Meier, Balthasar (1610) - Priester
- Meier, Balthasar (1612) - Studium, Pfarrer, Priester
- Meier, Balthasar (1620) - Jesuit
- Meier, Balthasar (1643) - Studium, Priester
- Meier, Balthasar (1648) - Studium
- Meier, Balthasar (1650) - Studium, Pfarrer
- Meier, Balthasar (1650, Pösling) - Studium, Priester
- Meier, Balthasar (1663) - Studium
- Meier, Balthasar (1669) - Studium
- Meier, Balthasar (1672) - Studium, Priester
- Meier, Balthasar (1673) - Studium
- Meier, Balthasar (1675) - Studium
- Meier, Balthasar (1677) - Studium
- Meier, Balthasar (1679) - Studium, Geistlicher
- Meier, Balthasar (1692) - Studium
- Meier, Balthasar (1700) - Studium
- Meier, Balthasar (1738) - Studium, Geistlicher
- Meier, Balthasar (Abensberg) - Studium
- Meier, Balthasar (Augsburg) - Wagmeister
- Meier, Balthasar (Dillingen) - Studium, Pfarrer
- Meier, Balthasar (Dominikaner) - Dominikaner, Mönch, Pfarrer
- Meier, Balthasar (Fischbach) - Studium
- Meier, Balthasar (Geistlicher) - Geistlicher
- Meier, Balthasar (Gundelfingen) - Studium
- Meier, Balthasar (Haigerloch) - Schüler
- Meier, Balthasar (Hecklingen) - Studium
- Meier, Balthasar (Kanoniker) - Kanoniker, Augustinerchorherr
- Meier, Balthasar (Kempten) - Studium
- Meier, Balthasar (Krugzell) - Spitalmeister, Studium, Kreuzherr, Pfarrer, Heiliggeistorden, Propst
- Meier, Balthasar (Lauingen) - Studium, Gymnasium illustre
- Meier, Balthasar (Matrei) - Studium