Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Arzt]]
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='Arzt') 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='Arzt') 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 | ref | s_id, o_hash, s_id_2, p_id | p_id | 262 | const, const | 1964 | Using index condition; 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
- Abrich, Friedrich
- Adelger, Lorenz
- Adler, Johann Friedrich (1614) (*1614)
- Agerius, Johann Heinrich
- Agerius, Nikolaus (Strassburg)
- Agricola, Georg (1530) (*1530 JL †1575 JL)
- Agricola, Georg (Mimbach) ( †1575 JL)
- Agricola, Johann Wilhelm
- Alber, Leonhard (Aichach)
- Albert, Johann (Wimpfen)
- Albin, Apollinaris Anton (*1771 †1830)
- Albin, Johann (Johnsdorf)
- Albrecht, Johann Rudolph (*1630 †1675)
- Albrecht, Johann Sebastian (*1695 †1774)
- Algardi, Franz Anton
- Allmacher, Johann Adam
A Fortsetzung
- Amator, Seibold Sebald
- Amelius, Tillmann
- Amling, Lukas ( †1829)
- Amma, Gottfried
- Ammann, Georg Christoph
- Ammann, Johann Jakob (1777) (*1777)
- Ammerlander, Johann Benno (1721) (*1721)
- Ampferl, Sebastian
- Amrhein, Franz Xaver (1730) (*1730 †1762)
- Anderler, Anton
- Anderson, Archibald
- Andreae, Johann David
- Andreae, Ulrich (*1555 JL †1596)
- Andreae, Zacharias (Colmar, Studium)
- Angelini, Joseph Vinzenz
- Anhorn, Bartholomäus (*1684 †1744)
A Fortsetzung
-
Annasberger, Matthias (*1719)
- Anomaeus, Johann Joachim
- Anselmi, Johann (Hagenau)
- Anton, Johann (1494) (*1494 JL †1558 JL)
- Anton, Johann (Kaschau) ( †1558 JL)
- Aquarius, Georg
- Aquarius, Theodor Dietrich
- Ardolph, Hieronymus (Chur) ( †1541 JL)
- Armbrust, Ignaz Ludwig
- Arnold, Franz Xaver (1769) (*1769)
- Arnold, Johann Christoph Franz
- Artmann, Franz Xaver (Straubing)
- Aschenbrenner, Georg (1771) (*1771)
- Ascher, Franz Xaver (Straubing)
- Assum, Johann Heinrich
- Atrocianus, Johann (1530) (*1530 JL †1564 JL)