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.00054383277893066 Sekunden!
SELECT pgT.GUID, pgT.PG_PARENT_GUID, pgT.CLASSIFICATION_PROXY_GUID, pgT.DESC_en as DESCR, pgT.HTML_en 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_en ='' OR pg.DESC_DE = 'ROOT' GROUP BY pgT.DESC_en, pgT.GUID, pgT.PG_PARENT_GUID, pgT.CLASSIFICATION_PROXY_GUID, pgT.HTML_en, pgT.ORDNUM
Laufzeit: 0.0012269020080566 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_en = '' GROUP BY pgT.GUID;
Laufzeit: 0.00038003921508789 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: 0.14193105697632 Sekunden!
Our article search helps you to analyze your article requirements and to shorten delivery times. In cooperation with our distribution partners and our optimized warehouse in Dortmund, we supply you more than 1.500.000 items within 3-5 working days. - Ask for your current requirements. We will gladly provide you with an individualized offer.
From customer-specific product development, through intelligent C-part management, to customer-specific logistics. We help you to optimize your processes and save costs.learn more
Request for callback
