Semantische Suche
Aus BrandWiki
Debug output SQLStore
ASK Query
[[Kategorie:Certificate]] [[CertClass::Lebensmittel]]
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_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=633
AND (t4.p_id=630 AND t4.o_id=2703)
)
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_fpt_inst` AS t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=633
AND (t4.p_id=630 AND t4.o_id=2703)
)
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 | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 63 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t4 | ref|filter | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id|o_id | 8|5 | const, brandwiki_may20.t2.s_id | 1 (4%) | Using where; Using rowid filter | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | brandwiki_may20.t2.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
None4
A
- AMA Biosiegel (CertIssuer Agrarmarkt Austria Marketing GesmbH (AMA Marketing) CertCountry Österreich)
- AMA Gütesiegel (CertIssuer Agrarmarkt Austria Marketing GesmbH (AMA Marketing) CertCountry Österreich)
- Aquaculture Stewardship Council (ASC) (CertIssuer Aquaculture Stewardship Council CertCountry Niederlande (Nederland))
- Austria Bio Garantie (CertIssuer Austria Bio Garantie GmbH CertCountry Österreich)
B
- Bio Austria (CertIssuer Bio Austria – Verein CertCountry Österreich)
- Bio-Siegel (CertCountry Deutschland)
- Bioland (CertIssuer Bioland - Verband für organisch-biologischen Landbau e.V. CertCountry Deutschland, Italien)
- Biopark (CertIssuer Biopark e. V.)
- Biozyklisch-Veganer Anbau (CertIssuer Biocyclic Vegan Label Ltd. (BNL) CertCountry Zypern (Κυπριακή Δημοκρατία/Kıbrıs Cumhuriyeti))
- Bonsucro
C
- Carbon Trust Footprint (CertIssuer Carbon Trust)
- ClimatePartner (CertIssuer ClimatePartner Deutschland GmbH CertCountry Deutschland)
D
- Demeter (CertIssuer Demeter International e.V. CertCountry Deutschland)
- Donau Soja (CertIssuer Verein Donau Soja (Association Danube Soya) CertCountry Österreich)
E
E (Fortsetzung)
- Eco-Management und Audit Scheme (EMAS) (CertIssuer European Union CertCountry Europäische Union (EU))
- EcoVeg (CertIssuer VegOrganic e.V. CertCountry Deutschland)
F
- FAIR 'N GREEN (CertIssuer Fair and Green e.V. CertCountry Deutschland)
- FairChoice (CertIssuer Deutschen Institut für Nachhaltige Entwicklung e.V. (DINE e.V.))
- Forum for Sustainable Palm Oil (FONAP) (CertIssuer Forum for Sustainable Palm Oil (FONAP) CertCountry Deutschland)
G
- GEPA fair+ (CertIssuer Gesellschaft zur Förderung der Partnerschaft mit der Dritten Welt mbH CertCountry Deutschland)
- GGN Certified (CertIssuer GLOBALG.A.P c/o FoodPlus GmbH)
- GREEN BRANDS
- GenussRegion Österreich (CertIssuer Agrarmarkt Austria GmbH (AMA) CertCountry Österreich)
- Gäa ökologischer Landbau (CertIssuer Gäa e. V.)
H
I
M
- MSC (Marine Stewardship Council) (CertIssuer MSC (Marine Stewardship Council) CertCountry Vereinigtes Königreich (United Kingdom of Great Britain and Northern Ireland))
N
P
R
- Rainforest Alliance (CertIssuer Rainforest Alliance CertCountry Vereinigtes Königreich (United Kingdom of Great Britain and Northern Ireland))
- Roundtable on Sustainable Biomaterials (RSB)
- Roundtable on Sustainable Palm Oil (RSPO)
S
- SGS Institut Fresenius
- Schneider’s BioGemüseland (CertIssuer Schneider's BioGemüseland CertCountry Österreich)
- Sojarei Bio (CertIssuer Feelgood Handel - G.m.b.H. & sojarei Vollwertkost G.m.b.H. CertCountry Österreich)
- Sojvita (CertIssuer Sojvita CertCountry Österreich)
- Sonnentor (CertIssuer Sonnentor Kräuterhandels GmbH CertCountry Österreich)
U
V
a
b
- biokreis (CertIssuer Biokreis e.V. Verband für ökologischen Landbau und gesunde Ernährung)
- biokreis regional & fair (CertIssuer Biokreis e.V. Verband für ökologischen Landbau und gesunde Ernährung)
c
- certified vegan (CertIssuer vegan action/vegan awareness foundation)
- cruelty free and vegan (CertIssuer People for the Ethical Treatment of Animals (PETA) CertCountry Deutschland)
f