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='1' OR id_ekategorii IN (1159,1161,1162,1163,1164,1080,1130,1146,1071,1012,1006,1013,1008,1014,1074,1015,1016,1017,1018,1001,1019,1002,1020,1003,1009,1021,1004,1077,1023,1010,1005,1011,7010,7023,7012,7074,7014,7080,7016,7018,7020,7159,7001,7003,7005,7161,7008,7163,7021,7011,7071,7013,7077,7015,7130,7017,7019,7009,7146,7002,7004,7006,7162,7164,7,6159,6001,6003,6005,6161,6008,6163,6021,6011,6071,6013,6077,6015,6130,6017,6019,6009,6146,6002,6004,6006,6162,6164,6010,6023,6012,6074,6014,6080,6016,6018,6020,6,5010,5023,5012,5074,5014,5080,5016,5018,5020,5159,5001,5003,5005,5161,5008,5163,5021,5011,5071,5013,5077,5015,5130,5017,5019,5009,5146,5002,5004,5006,5162,5164,5,9010,9023,9012,9074,9014,9080,9016,9018,9020,9159,9001,9003,9005,9161,9008,9163,9021,9011,9071,9013,9077,9015,9130,9017,9019,9009,9146,9002,9004,9006,9162,9164,9,1) OR wfm_artykuly.id_artykulu IN (SELECT id_artykulu FROM wfm_ekategorie_powielanie WHERE id_kategorii='1'))
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,1990,2016,2054,2055,2056,2062,2071,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,6515,6457,6516,6799,6594,6665,6672,6673,6674,6675,6681,6802,6792,6800,6804,6862,7001,7058,7076,7110,7188,7189,7200,7201,7247,7244,7243,7297,7298,7370,7371,7379,7380,7403,7405,7408,7409,7440,7436,7437,7469,8346,7470,7427,7446,7441,7439,7442,7464,7471,7472,7474,7496,7501,7503,7529,7530,8191,7563,7564,7565,7566,7569,7570,8215,7571,7585,7586,7587,7590,7591,7605,7607,7608,7614,7772,7623,7625,7629,7632,7634,7636,7640,7773,7774,7775,7776,7792,7819,7797,8375,8374,8724,7874,7880,7881,7882,7896,7901,8197,8195,7990,7991,7993,7994,7996,7998,8161,8157,8079,8194,8192,8198,8199,8369,8726,8201,8202,8203,8204,8205,8206,8207,8208,8371,8540,8829,8345,9091,8218,8222,8228,8232,8238,8243,8244,8256,8257,8259,8263,8265,8280,8281,8284,8286,8288,8293,8297,8298,8299,8300,8312,8314,8315,8320,8321,8333,8334,8347,8348,8351,8353,8354,8355,8356,8357,8358,8359,8360,8363,8364,8365,8366,8367,8368,8752,8902,8830,8823,8831,8383,8385,8404,8405,8410,8412,8415,8425,8431,8434,8439,8441,8449,8451,8452,8453,8454,8455,8476,8479,8483,8503,8512,8513,8565,8576,8577,8581,8582,8827,8585,8589,8590,8591,8595,8596,8597,8598,8599,8600,8601,8602,8606,8607,8608,8610,8611,8612,8613,8614,8615,8708,8616,8620,8621,8627,8629,8630,8633,8635,8644,8645,8647,8648,8649,8650,8651,8652,8653,8654,8655,8658,8659,8660,8661,8668,8674,8678,8679,8680,8681,8682,8684,8685,8686,8709,8714,8715,8716,8717,8719,8720,8721,8727,8729,8732,8733,8736,8737,8738,8739,8740,8741,8742,8946,8746,8747,8748,8749,9103,8750,8751,8753,8754,8755,8756,8757,8758,8759,8760,8761,8762,8763,8764,8765,8766,8767,8768,8769,8770,8771,8778,8779,8780,8781,8782,8783,8784,8785,8786,8787,8788,8789,8790,8791,8792,8793,8794,8795,8796,8797,8798,8799,8800,8801,8802,8803,8804,8805,8828,9124,8814,8815,8816,8817,8818,8819,8820,8821,8824,8825,8826,8832,8842,8843,8844,8849,8850,8852,8857,8858,8878,8882,8883,8884,8885,8886,8903,8900,8906,8907,8911,8912,8913,8915,8918,8919,8930,8931,8932,8933,8934,8935,8940,8941,8942,8945,8947,8950,8951,8952,8953,8954,8960,8961,8962,8964,9062,8967,8972,8973,8977,8980,8988,8989,8991,8994,8995,8996,8997,8998,8999,9007,9008,9010,9013,9014,9017,9018,9027,9028,9030,9032,9034,9035,9036,9037,9040,9041,9042,9054,9055,9056,9057,9058,9122,9131,9059,9060,9061,9063,9064,9065,9066,9068,9069,9070,9071,9072,9073,9074,9075,9076,9077,9078,9079,9080,9088,9092,9095,9096,9101,9102,9104,9105,9106,9109,9110,9112,9115,9123,9118,9119,9120,9125,9126,9127,9128,9129,9130,9133,9135,9136) ORDER BY nazwa_kategorii ASC, nazwa_artykulu ASC LIMIT 256,16
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ń.