Kod: Zaznacz cały
SELECT TOP (100) PERCENT K.Twr_Kod AS Kod, K.Twr_Nazwa AS Nazwa, K.Twr_Jm AS Jm, K.Twr_Typ AS Typ, C.TwC_Wartosc AS [Cena detaliczna netto[zl]]],
(SELECT TwO_Opis
FROM CDN.TwrOpisy AS O
WHERE (TwO_Jezyk = 0) AND (K.Twr_GIDNumer = TwO_TwrNumer)) AS [Opis-Polski],
(SELECT TwO_Opis
FROM CDN.TwrOpisy AS O
WHERE (TwO_Jezyk = 701) AND (K.Twr_GIDNumer = TwO_TwrNumer)) AS [Opis-Angielski], GD.TGD_Kod AS Grupa, 'NULL' AS Nr_Katalogowy,
(SELECT CASE K.Twr_GrupaPod WHEN 'A' THEN '23.00' ELSE K.Twr_GrupaPod END AS Expr1) AS Podatek, 'PLN' AS PLN, K.Twr_WagaBrutto AS [Waga[kg]]],
K.Twr_URL AS URL, K.Twr_Ean AS EAN
FROM CDN.TwrKarty AS K LEFT OUTER JOIN
CDN.TwrCeny AS C ON K.Twr_GIDNumer = C.TwC_TwrNumer LEFT OUTER JOIN
CDN.TwrGrupy AS G ON K.Twr_GIDNumer = G.TwG_GIDNumer RIGHT OUTER JOIN
CDN.TwrGrupyDom AS GD ON G.TwG_GrONumer = GD.TGD_GIDNumer AND GD.TGD_GIDTyp = - 16 AND GD.TGD_GrONumer = 10631
WHERE (C.TwC_TwrLp = 1) AND (G.TwG_GrONumer IN
(SELECT GIDNumer
FROM CDN.PobierzDrzewoGrupTowarowych(10631, NULL, NULL, NULL, DEFAULT, DEFAULT) AS PobierzDrzewoGrupTowarowych_8)) AND (G.TwG_GIDTyp = 16)
AND (K.Twr_Typ <> 3) AND (K.Twr_Archiwalny = 0) OR
(C.TwC_TwrLp = 1) AND (G.TwG_GrONumer IN
(SELECT GIDNumer
FROM CDN.PobierzDrzewoGrupTowarowych(10631, NULL, NULL, NULL, DEFAULT, DEFAULT) AS PobierzDrzewoGrupTowarowych_7)) AND (K.Twr_Typ <> 3) AND
(K.Twr_Archiwalny = 0) AND (0 = 1) OR
(C.TwC_TwrLp = 1) AND (G.TwG_GrONumer IN
(SELECT GIDNumer
FROM CDN.PobierzDrzewoGrupTowarowych(10631, NULL, NULL, NULL, DEFAULT, DEFAULT) AS PobierzDrzewoGrupTowarowych_6)) AND (G.TwG_GIDTyp = 16)
AND (K.Twr_Archiwalny = 0) AND (G.TwG_GIDTyp = - 16) OR
(C.TwC_TwrLp = 1) AND (G.TwG_GrONumer IN
(SELECT GIDNumer
FROM CDN.PobierzDrzewoGrupTowarowych(10631, NULL, NULL, NULL, DEFAULT, DEFAULT) AS PobierzDrzewoGrupTowarowych_5)) AND
(G.TwG_GIDTyp = - 16) AND (K.Twr_Archiwalny = 0) AND (0 = 1) OR
(C.TwC_TwrLp = 1) AND (G.TwG_GrONumer IN
(SELECT GIDNumer
FROM CDN.PobierzDrzewoGrupTowarowych(10631, NULL, NULL, NULL, DEFAULT, DEFAULT) AS PobierzDrzewoGrupTowarowych_4)) AND (G.TwG_GIDTyp = 16)
AND (K.Twr_Typ <> 3) AND (G.TwG_GIDTyp = - 16) OR
(C.TwC_TwrLp = 1) AND (G.TwG_GrONumer IN
(SELECT GIDNumer
FROM CDN.PobierzDrzewoGrupTowarowych(10631, NULL, NULL, NULL, DEFAULT, DEFAULT) AS PobierzDrzewoGrupTowarowych_3)) AND
(G.TwG_GIDTyp = - 16) AND (K.Twr_Typ <> 3) AND (0 = 1) OR
(C.TwC_TwrLp = 1) AND (G.TwG_GrONumer IN
(SELECT GIDNumer
FROM CDN.PobierzDrzewoGrupTowarowych(10631, NULL, NULL, NULL, DEFAULT, DEFAULT) AS PobierzDrzewoGrupTowarowych_2)) AND (G.TwG_GIDTyp = 16)
AND (G.TwG_GIDTyp = - 16) AND (G.TwG_GIDTyp = - 16) OR
(C.TwC_TwrLp = 1) AND (G.TwG_GrONumer IN
(SELECT GIDNumer
FROM CDN.PobierzDrzewoGrupTowarowych(10631, NULL, NULL, NULL, DEFAULT, DEFAULT) AS PobierzDrzewoGrupTowarowych_1)) AND
(G.TwG_GIDTyp = - 16) AND (0 = 1) AND (G.TwG_GIDTyp = - 16)
ORDER BY Kod