Semantische Suche
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_fpt_inst` 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_id='176488'
AND (
((t4.o_hash!='Gastwissenschaftler') OR (t4.o_hash='Hilfskraft') OR (t4.o_hash='Auszubildende') OR (t4.o_hash='Auszubildender') OR (t4.o_hash='Techniker') OR (t4.o_hash='Sekretärin') OR (t4.o_hash='Wissenschaftlicher Mitarbeiter')
) AND t4.p_id='176134')
)
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
350
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | range | s_id,p_id,s_id_2,o_hash | p_id | 262 | 772 | Using index condition; Using temporary; Using filesort | |
1 | SIMPLE | t2 | ref | s_id,o_id,s_id_2,o_id_2 | s_id_2 | 9 | kit_smw1.t4.s_id,const | 1 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | kit_smw1.t4.s_id | 1 | Using where |
Query-Depth:1
Email: mika.peckruhn@kit.edu
AIFB
Dipl.-Inform. Murat Citak
Dr. Müge Klein
Prof. Dr. N. Santoro
Dipl.-Inform. Nadia Ahmed
Dr.-Ing. Nelly Schuster
Dr. Nenad Stojanovic
Dipl.-Wirtsch.Inf. Nico Stieler
Email: niklas.hasebrook9@kit.edu
Dr.-Ing. Niklas Kühl
Prof. Dr. Nikolai Preiß
M.Sc. Nina Gerber
Email: nina.gerber@kit.edu
Email: noah.schlegel@secuso.org
Dr.-Ing. Nugroho Fredivianus
Dr. Oliver Diessel
Dipl.-Ökonom Oliver Paulzen
Dipl.-Inform.Wirt Oliver Schöll
Dr. Olivier Sandel
Dr. Otto Nurmi
Prof. Dr. Pascal Hitzler
Dipl.-Wi-Ing. Patrick Klose
Dr. Patrick Philipp
Email: wiener@fzi.de
Dipl.-Ing. Peter Bungert
Prof. Dr. Peter Dadam
Dr. Peter Dolland
Prof. Peter Eades
Prof. Dr. Peter Elzer
Dr. Peter Haase
Prof. Dr. Peter Jaeschke
Dr. Peter Sander
Dr. Peter Weiß
Prof. Dr. Peter Widmayer
Prof. Dr. Philipp Cimiano
Dr. Philipp Sorg
M.Sc. Philipp Zehnder
Email: zehnder@fzi.de
Prof. Qin Weiping