Semantische Suche
Aus Aifbportal
SQLStore debug output
ASK Query
[[Kategorie:Partner]] [[Organisationsart::Industrieunternehmen]]
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 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='176101'
AND (
(t4.o_hash='Industrieunternehmen') AND t4.p_id='176149')
)
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
70
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='176101'
AND (
(t4.o_hash='Industrieunternehmen') AND t4.p_id='176149')
)
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
70
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | index_merge | s_id,p_id,s_id_2,o_hash | o_hash,p_id | 258,262 | 1 | 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 | kit_smw1.t4.s_id | 1 | Using where |
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; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
None-
Institut für Industrielle Softwaretechniken e. V.
http://www.institut-ist.de -
Intelligent Software Components (ISOCO)
http://www.isoco.com -
Intrasoft International SA
http://www.intrasoft-intl.com/ -
ItSMF e. V.
http://www.itsmf.de -
Iw-consult GmbH
http://www.iwconsult.de -
Jesselle GmbH
http://www.jesselle.eu -
KPMG AG
http://www.kpmg.de/ -
KaSyX GmbH
http://www.kasyx.de -
Knowledge-Now Limited
http://www.knowledgenow.net -
LMS
http://www.lms-beratung.de -
LOCOM Consulting GmbH
http://www.locom.de -
Laboratorios KIN S.A.
http://www.kin.es/ -
MediaSift Limited -
Metasonic AG
http://www.metasonic.de/ -
Microsoft Deutschland GmbH
http://www.microsoft.com -
Mieschke Hofmann und Partner GmbH
http://www.mhp.de -
MsgGillardon AG
http://www.msg-gillardon.de -
Osthus GmbH
http://www.osthus.de -
POET GmbH
http://www.poet.de -
PROMATIS software GmbH
http://www.promatis.de -
PSI Logistics GmbH
http://www.psilogistics.com -
PTV AG
http://www.ptv.de -
PocketTaxi
http://www.pockettaxi.de -
Quinary SPA
http://www.quinary.it/en/ -
Robert Bosch GmbH
http://www.bosch.de -
Rolls-Royce
http://www.rolls-roycemotorcars.com -
SALT Solutions GmbH
http://www.salt-solutions.de -
SAP AG
http://www.sap.com -
Seeburger AG
http://www.seeburger.de -
Siemens AG
http://www.siemens.de -
Siemens Business Services GmbH & Co. OHG
http://www.it-solutions.siemens.com -
Siemens Medical
http://www.medical.siemens.com -
Siemens SRL
http://www.siemens.ro/ -
SingularLogic Cyprus Ltd
http://portal.singularlogic.eu/ -
SixSq
http://sixsq.com/ -
Slovenian Press Agency
http://www.sta.si/en/ -
Smart4Mobile GmbH
http://www.smart4mobile.de -
Snoopmedia GmbH
https://www.snoopmedia.com -
Software AG
http://www.softwareag.com -
Software Mind S.A.
http://www.softwaremind.pl/en/ -
Systemplan GmbH
http://www.systemplangmbh.de -
TEMIS S.A.
http://www.temis.com/home -
Thames Communications
http://www.thamescom.com -
The FLOOW Limited
http://www.thefloow.com -
UBITECH
http://www.ubitech.eu/ -
United Internet Media AG
http://www.united-internet-media.de -
VICO Research & Consulting GmbH
http://www.vico-research.com/ -
VIVAI Software AG
http://www.vivai.de -
WIBU SYSTEMS AG
http://wibu.com -
YellowMap AG
http://www.yellowmap.de