Semantische Suche
Aus Aifbportal
SQLStore debug output
ASK Query
[[Kategorie:Partner]]
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_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='176101')
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
150
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='176101')
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
150
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id,o_id,s_id_2,o_id_2 | o_id_2 | 5 | const | 277 | Using index; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | kit_smw1.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NonePartner Logo | Partner URL | Actor | Partner | |
---|---|---|---|---|
Osthus GmbH | not an actor | an actor | ||
POET GmbH | not an actor | an actor | ||
PROMATIS software GmbH | not an actor | an actor | ||
PSI Logistics GmbH | not an actor | an actor | ||
PTV AG | not an actor | an actor | ||
Peter L. Reichertz Institut für Medizinische Informatik | not an actor | an actor | ||
PocketTaxi | not an actor | an actor | ||
Pontifícia Universidade Católica do Rio de Janeiro | not an actor | an actor | ||
Punjab College of Technical Education | not an actor | an actor | ||
Quinary SPA | not an actor | an actor | ||
RWTH Aachen | not an actor | an actor | ||
Rensselaer Polytechnic Institute | not an actor | an actor | ||
Robert Bosch GmbH | not an actor | an actor | ||
Rolls-Royce | not an actor | an actor | ||
SALT Solutions GmbH | not an actor | an actor | ||
SAP AG | not an actor | an actor | ||
SAP Research | not an actor | an actor | ||
SEERC - South East European Research Center | not an actor | an actor | ||
SICS - Swedish ICT AB | not an actor | an actor | ||
STI International | not an actor | an actor | ||
Seeburger AG | not an actor | an actor | ||
Shandong University of Science and Technology | not an actor | an actor | ||
Siemens AG | not an actor | an actor | ||
Siemens Business Services GmbH & Co. OHG | not an actor | an actor | ||
Siemens Medical | not an actor | an actor | ||
Siemens SRL | not an actor | an actor | ||
SingularLogic Cyprus Ltd | not an actor | an actor | ||
SixSq | not an actor | an actor | ||
Slovenian Press Agency | not an actor | an actor | ||
Smart4Mobile GmbH | not an actor | an actor | ||
Snoopmedia GmbH | not an actor | an actor | ||
Software AG | not an actor | an actor | ||
Software Mind S.A. | not an actor | an actor | ||
Southern New Hampshire University | not an actor | an actor | ||
Stanford University | not an actor | an actor | ||
Stiftung Innovation in der Hochschullehre | not an actor | an actor | ||
Swinburne University of Technology | not an actor | an actor | ||
Systemplan GmbH | not an actor | an actor | ||
TEMIS S.A. | not an actor | an actor | ||
TNO | not an actor | an actor | ||
TU Berlin | not an actor | an actor | ||
TU Braunschweig | not an actor | an actor | ||
TU Dresden | not an actor | an actor | ||
TU Graz | not an actor | an actor | ||
TU Ilmenau | not an actor | an actor | ||
TU München | not an actor | an actor | ||
TU Wien | not an actor | an actor | ||
Telefonica | not an actor | an actor | ||
Thames Communications | not an actor | an actor | ||
The Aerospace Corporation | not an actor | an actor |