d SELECT wfm_artykuly.id_artykulu,nazwa_artykulu,jednostka,stawka_vat,indeks_katalogowy as indeks_artykulu,id_ekategorii,minimalna_ilosc,stan_minimalny,najblizsza_dostawa FROM wfm_artykuly,wfm_ekategorie WHERE wfm_artykuly.id_ekategorii=wfm_ekategorie.id_kategorii AND (id_ekategorii='5017' OR id_ekategorii IN (5017) OR wfm_artykuly.id_artykulu IN (SELECT id_artykulu FROM wfm_ekategorie_powielanie WHERE id_kategorii='5017'))
AND wfm_artykuly.id_artykulu NOT IN
(
SELECT id_artykulu FROM wfm_artykuly_wykluczone WHERE
(id_wykluczony=0 AND kontrahent_grupa='0') OR
(id_wykluczony='1' AND kontrahent_grupa='1') OR
(id_wykluczony='1' AND kontrahent_grupa='2')
)
AND (wfm_artykuly.czy_widoczny='1')
AND wfm_artykuly.id_artykulu IN (835,918,919,1114,1206,1989,2016,2054,2055,2056,2063,5818,5817,5816,5814,5812,5811,5809,5805,5754,5753,5262,5261,5260,5259,5258,5257,5256,5255,5254,5253,5252,5251,5249,5247,5242,4468,4460,4459,4458,4457,6278,6515,6412,6451,6457,6516,6537,6799,6594,6665,6672,6673,6674,6802,6718,6719,6801,6791,6792,6793,6800,6804,6805,6862,7227,6863,7001,7058,7096,7097,7105,7110,7187,7188,7189,7203,7228,7229,7247,7244,7248,7243,8148,7298,7373,7405,7407,7408,7409,7410,7411,7440,7437,8346,7427,7428,7429,7430,7441,8151,7439,7455,7457,7460,7472,7474,7491,7493,7494,7496,7497,7499,7500,7501,7502,7503,7504,7505,7529,7552,8191,7631,7557,7576,7563,7564,7565,7566,7568,7569,7570,7578,8215,7571,7572,7573,7577,7585,7587,7588,7589,7590,7591,7605,7607,7608,7611,7612,7613,7614,7616,7618,7625,7629,7628,8131,7634,8138,8145,7769,8136,7636,7637,7638,7640,7641,7642,7664,7677,7701,7702,7703,7704,7706,7707,7735,7736,7739,7740,7747,7748,7751,7752,7763,7765,7766,7767,7771,8139,7775,7788,7819,8143,8052,8153,8147,8155,7905,8150,7915,8154,8149,7874,7877,7880,7881,7882,7884,7885,7894,7895,7896,7897,7900,7906,7907,7908,7909,7910,7911,7912,7979,8146,8141,7989,7990,7991,7992,7993,7994,7995,7998,7999,8144,8152,8373,8142,8156,8140,8029,8030,8032,8053,8054,8055,8056,8057,8058,8059,8133,8074,8075,8082,8084,8085,8087,8088,8119,8120,8194,8199,8264,8200,8201,8205,8208,8345,8218,8257,8277,8278,8279,8280,8281,8284,8285,8288,8301,8331,8332,8333,8334,8347,8348,8350,8351,8352,8358,8359,8360,8363,8364,8365,8366,8367,8368,8583,8695,8696) ORDER BY nazwa_kategorii ASC, nazwa_artykulu ASC LIMIT 0,16
1
DK0024 RED M OLIVIER
SUGEROWANA CENA DETALICZNA
ROZMIARY: 39-46
69,99 PLN brutto / par
1
Zasady dotyczące cookies zamknij Korzystając z naszej witryny wyrażasz zgodę na używanie plików cookies, zgodnie z aktualnymi ustawieniami przeglądarki. W każdym momencie można dokonać zmiany ustawień.