Endecken Sie das Produktportfolio der menges group.
SELECT COALESCE(pg.GUID, pg1.GUID, pg2.GUID, pg3.GUID, pg4.GUID, pg5.GUID, pg6.GUID, pg7.GUID) as guid, CONCAT_WS('||', pg7.DESC_DE, pg6.DESC_DE, pg5.DESC_DE, pg4.DESC_DE, pg3.DESC_DE, pg2.DESC_DE, pg1.DESC_DE, pg.DESC_DE) as pgRoot FROM PRODUCT_GROUP_CATALOGUE pg left join PRODUCT_GROUP_CATALOGUE pg1 on pg1.GUID = pg.PG_PARENT_GUID and pg1.PG_PARENT_GUID <> '' and pg1.PG_PARENT_GUID is not null left join PRODUCT_GROUP_CATALOGUE pg2 on pg2.GUID = pg1.PG_PARENT_GUID and pg2.PG_PARENT_GUID <> '' and pg2.PG_PARENT_GUID is not null left join PRODUCT_GROUP_CATALOGUE pg3 on pg3.GUID = pg2.PG_PARENT_GUID and pg3.PG_PARENT_GUID <> '' and pg3.PG_PARENT_GUID is not null left join PRODUCT_GROUP_CATALOGUE pg4 on pg4.GUID = pg3.PG_PARENT_GUID and pg4.PG_PARENT_GUID <> '' and pg4.PG_PARENT_GUID is not null left join PRODUCT_GROUP_CATALOGUE pg5 on pg5.GUID = pg4.PG_PARENT_GUID and pg5.PG_PARENT_GUID <> '' and pg5.PG_PARENT_GUID is not null left join PRODUCT_GROUP_CATALOGUE pg6 on pg6.GUID = pg5.PG_PARENT_GUID and pg6.PG_PARENT_GUID <> '' and pg6.PG_PARENT_GUID is not null left join PRODUCT_GROUP_CATALOGUE pg7 on pg7.GUID = pg6.PG_PARENT_GUID and pg7.PG_PARENT_GUID <> '' and pg7.PG_PARENT_GUID is not null where pg.HTML_DE is null order BY pgRoot
Laufzeit: 0.017052888870239 Sekunden!
SELECT pgT.GUID, pgT.PG_PARENT_GUID, pgT.CLASSIFICATION_PROXY_GUID, pgT.DESC_de as DESCR, pgT.HTML_de as HTML, pgT.ORDNUM FROM PRODUCT_GROUP_CATALOGUE pg left join PRODUCT_GROUP_CATALOGUE pg0 on pg0.PG_PARENT_GUID=pg.PG_PARENT_GUID left join PRODUCT_GROUP_CATALOGUE pgS1 on pgS1.PG_PARENT_GUID=pg.GUID AND pgS1.PG_PARENT_GUID=pg0.GUID left join PRODUCT_GROUP_CATALOGUE pg1 on pg1.GUID=pg.PG_PARENT_GUID left join PRODUCT_GROUP_CATALOGUE pg2 on pg2.GUID=pg1.PG_PARENT_GUID left join PRODUCT_GROUP_CATALOGUE pg3 on pg3.GUID=pg2.PG_PARENT_GUID left join PRODUCT_GROUP_CATALOGUE pg4 on pg4.GUID=pg3.PG_PARENT_GUID left join PRODUCT_GROUP_CATALOGUE pg5 on pg5.GUID=pg4.PG_PARENT_GUID left join PRODUCT_GROUP_CATALOGUE pg6 on pg6.GUID=pg5.PG_PARENT_GUID left join PRODUCT_GROUP_CATALOGUE pg7 on pg7.GUID=pg6.PG_PARENT_GUID join PRODUCT_GROUP_CATALOGUE pgT on pgT.PG_PARENT_GUID IN (pgS1.PG_PARENT_GUID, pg0.PG_PARENT_GUID, pg1.PG_PARENT_GUID, pg2.PG_PARENT_GUID, pg3.PG_PARENT_GUID, pg4.PG_PARENT_GUID, pg5.PG_PARENT_GUID, pg6.PG_PARENT_GUID, pg7.PG_PARENT_GUID) WHERE pg.HTML_de ='/de/e-katalog' OR pg.DESC_DE = 'ROOT' GROUP BY pgT.DESC_de, pgT.GUID, pgT.PG_PARENT_GUID, pgT.CLASSIFICATION_PROXY_GUID, pgT.HTML_de, pgT.ORDNUM
Laufzeit: 0.0040490627288818 Sekunden!
SELECT pgT.GUID from PRODUCT_GROUP_CATALOGUE pg left join PRODUCT_GROUP_CATALOGUE pg1 on pg1.PG_PARENT_GUID = pg.GUID left join PRODUCT_GROUP_CATALOGUE pg2 on pg2.PG_PARENT_GUID = pg1.GUID left join PRODUCT_GROUP_CATALOGUE pg3 on pg3.PG_PARENT_GUID = pg2.GUID left join PRODUCT_GROUP_CATALOGUE pg4 on pg4.PG_PARENT_GUID = pg3.GUID left join PRODUCT_GROUP_CATALOGUE pg5 on pg5.PG_PARENT_GUID = pg4.GUID left join PRODUCT_GROUP_CATALOGUE pg6 on pg6.PG_PARENT_GUID = pg5.GUID left join PRODUCT_GROUP_CATALOGUE pg7 on pg7.PG_PARENT_GUID = pg6.GUID join PRODUCT_GROUP_CATALOGUE pgT on pgT.GUID in (pg.GUID, pg1.GUID, pg2.GUID, pg3.GUID, pg4.GUID, pg5.GUID, pg6.GUID, pg7.GUID) where pg.HTML_de = '/de/e-katalog' GROUP BY pgT.GUID;
Laufzeit: 0.00075697898864746 Sekunden!
Select count(ac.GUID), max(ac.MENGES_AID), max(ac.ARTICLE_DESC) ARTICLE_DESC, ac.MANUFACTURER, max(ac.MANUFACTURER_AID) MANUFACTURER_AID, max(ac.MANUFACTURER_DESC) MANUFACTURER_DESC, max(ac.EAN), sum(ac.QUANTITY) QUANTITY, ac.DATECODE, ac.TRIM_IDENT, max(ac.HTML) HTML, max(ac.HTML_TAG), max(menges.PRODUCT_GROUP_GUID) FROM article_catalogue ac LEFT JOIN (SELECT max(ac1.PRODUCT_GROUP_GUID) PRODUCT_GROUP_GUID, ac1.TRIM_IDENT FROM article_catalogue ac1 WHERE ac1.PRODUCT_GROUP_GUID is NOT null GROUP by ac1.TRIM_IDENT) menges on menges.TRIM_IDENT = ac.TRIM_IDENT WHERE menges.PRODUCT_GROUP_GUID IN ('') GROUP by ac.TRIM_IDENT, ac.MANUFACTURER, ac.DATECODE
Laufzeit: 2.5616149902344 Sekunden!
Unsere Artikelsuche hilft Ihnen Ihren Artikelbedarf zu analysieren und Lieferzeiten zu verkürzen. In Zusammenarbeit mit unseren Distributionspartnern und ein optimiertes Lager am Standort Dortmund liefern wir Ihnen mehr als 1.500.000 Artikel innerhalb von 3-5 Werktagen. - Fragen Sie Ihren aktuellen Bedarf bei uns an. Wir unterbreiten Ihnen gerne ein individuelles Angebot.
Von der kundenspezifischen Produktentwicklung, über ein intelligentes C-Teile-Management, bis hin zur kundenspezifischen Logistik. Wir helfen Ihnen Ihre Prozesse zu optimieren und dadurch Kosten zu sparen.mehr erfahren
Kostenlosen Rückruf anfordern
