Semantische Suche
Debug output SQLStore
ASK Query
[[Geschlecht::m]] [[Person::~C*]]
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='m') AND t2.p_id=502
AND (
(t4.o_hash LIKE 'C%') 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
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 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='m') AND t2.p_id=502
AND (
(t4.o_hash LIKE 'C%') 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
1000
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | range | s_id, o_hash, s_id_2, p_id | p_id | 262 | 10684 | Using index condition; Using temporary; Using filesort | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | rupp.t4.s_id | 1 | Using where | |
1 | SIMPLE | t2 | ref | s_id, o_hash, s_id_2, p_id | s_id | 8 | rupp.t4.s_id, const | 1 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneC
-
Carli, Valentin , Studium
- Carlier, Leonhard (Aachen) , Studium
- Carlier, Leonhard (Studium) , Jurist Studium
- Carlier, Peter Philipp , Studium
- Carlier, Wilhelm , Studium
- Carlin, Christoph , Studium
- Carlin, Johann , Studium
- Carlis, Anton von , Studium
- Carlis, Dominik (*1688), Priester
- Carlis, Jakob von , Studium
- Carlis, Johann Baptist Heraclius (*1758 †1815), Kapuziner Mönch Studium
- Carlis, Paul von , Priester
- Carlis, Stephan Vinzenz , Priester
- Carlis, Vigil , Geistlicher
- Carlon, Karl , Studium
- Carlon, Wolfgang Joseph Anton , Studium
- Carlotti, Franz , Priester
C Fortsetzung
-
Carlotti, Hieronymus Graf von , Studium
- Carlotus, Peter (*1594), Jesuit Studium
- Carls, Johann Friedrich , Studium
- Carminelli, Johann Baptist , Studium
- Carminelli, Johann Vinzenz , Studium
- Carmintran, Christoph (*1650 †1691), Jesuit
- Carnal, Andreas Joseph , Studium
- Carnarius, Anton , Studium
- Carnelle, Georg , Studium
- Carnelli, Angelus Maria ( †1739), Mönch Servit
- Carnelli, Georg , Studium
- Carnelli, Stephan , Studium
- Carneri von Eben und Bergfelden, Anton Peregrinus , Studium
- Carneri von Eben und Bergfelden, Franz Anton von ( †1719), Jurist Professor Rektor Studium
- Carneri von Eben und Bergfelden, Franz Gaudentius Anton , Studium
- Carneri von Eben und Bergfelden, Franz Georg , Studium
- Carneri von Eben und Bergfelden, Gaudentius , Studium
C Fortsetzung
-
Carneri, Adam , Studium
- Carneri, Alfons Sebastian Innozenz (*1683 †1745), Kapuziner Mönch Studium
- Carneri, Franz Anton , Studium
- Carneri, Franz Xaver , Studium
- Carneri, Johann Christoph Anton Johann Nepomuk (*1727), Kanoniker Studium
- Carneri, Johann Fortunat , Studium
- Carneri, Johann Thomas (Cles) , Studium
- Carneri, Johann Thomas (Nonsberg) , Studium
- Carneri, Joseph Anton , Studium
- Carneri, Joseph Anton Gaudentius (*1723 †1796), Pfarrer Studium
- Carneri, Romedius , Priester
- Carneri, Sigismund (Trient) , Geistlicher Studium
- Carneri, Sigismund (Trient, Studium) , Studium
- Carnesari, Jakob , Geistlicher
- Carnesio, Hieronymus (*1644), Priester
- Carnevali, Hieronymus , Studium