zapytanie glowne: select a.id, a.nazwa, a.opis, a.id_producenta,a.kat_id, a.cecha1, a.cecha2, a.cecha3, a.aktywny, a.data, a.cenab, a.producent, a.promocja, a.flag, a.aktualna_cena, a.HURTPL_cenab, a.ocena from artykuly_pl a inner join kategorie_produkty artKat on a.id = artKat.id_art left outer join artykuly_bestselers on artykuly_bestselers.id_art = a.id where HURTEN_aktywny='Y' and a.kat_id not in (142,141,140,52) and a.producent not in (196, 3, 222, 196,267) and a.id in (22699,22697,8218,22391,22393,8199,11704,22395,12790,16428,11708,6566,22577,22578,16432,22579,8221,16433,8224,22596,11941,22612,22618,49307,22631,12400,3916,8213,2804,22635,6553,8216,9786,6584,22644,22647,6550,22652,11711,11710,22671,22676,8214,22680,8217,8219,22684,22686,6551,11942,6552,22688,22695,74505,74508,74511,74514,74516,22621,11709,24876,24774,24768,24879,104101,104125,24769,24782,24783,24786,24788,24770,24772,82847,29001,28997,28998,28999,29000,29873,29874,6555,65693,71580,65692,65691,104058,8215,8223,34734,34726,34733,34728,34730,34731,34732,93551,93552,93553,93554,43298,43292,43291,43290,43289,43297,43294,43293,43287,43286,43285,93555,93556,93557,93558,93559,93564,93566,93567,73845,73840,74495,73844,73855,73846,23527,23528,23529,49303,93568,93569,93560,93561,93562,93563,93585,93586,93587,93594,93595,93596,93597,93598,73847,65690,64868,104121,104122,104126,104127,104128,104123,104124,65689,58635,50979,50978,50977,50987,50986,50976,50964,50963,50962,50961,51446,51445,52395,71484,52390,82851,52386,57238,57236,57235,58629,64865,73849,64863,65677,64862,64861,64840,104092,104091,104090,104089,104088,63003,63955,64839,63952,64838,104129,104133,104132,104131,104130,82845,90461,82840,82844,74497,74498,68155,68267,68268,68269,68156,68157,68158,68159,68160,68161,68162,68163,68164,68165,68166,68167,68168,68169,68170,68171,68172,68173,68174,68175,68176,68177,68178,68179,68180,68243,68244,68181,68182,68183,68284,68270,68271,68285,68286,68287,68288,68289,68290,68184,68185,68186,68226,68227,68228,68229,68230,68231,68232,68233,68234,68235,68236,68237,68187,68188,68189,68238,68291,68292,68272,68273,68293,68294,68295,68296,68297,68298,68274,68275,68276,68277,68239,68240,68241,68242,68299,68278,68279,68280,68281,68245,68246,68247,68248,68249,68250,68251,68252,68253,68254,68255,68256,68257,68258,68259,68260,68261,68282,68283,68262,68263,68264,68265,68266,68154,68153,68152,68151,68150,68116,68149,104094,104093,76400,71485,71807,71804,71803,71802,71499,71498,71497,71496,71495,71494,71493,71492,71491,71490,71489,76399,71488,71487,71486,52407,60513,63954,66706,74585,74584,74583,74493,74492,29859,29860,29861,103790,82598,76352,76353,76350,82839,82597,44083,44082,80789,80788,80787,80786,80783,80785,80784,80782,80781,80780,82612,82614,82613,103782,102672,102673,102674,102675,102676,102677,102678,102679,102680,102681,103076,103077,48390,48402,48403,48409,48408,73551,73550,86473,82846,82838,84863,82616,82615,39925,84838,82836,82843,82842,82850,82849,82848,84862,84861,84860,84859,84858,86922,86921,84839,84835,84834,84833,84832,84831,104057,104056,104055,104054,104100,84816,84830,90471,74491,90492,84813,84826,84825,84824,84837,84822,84821,84836,84818,84817,90456,93646,93645,93644,93652,93651,93650,93641,93639,39927,39926,90460,90491,90490,90489,90488,90482,90486,90480,90483,90479,90462,90470,90469,87558,87563,87577,87557,87556,87555,87562,87561,87560,87559,87576,87575,87574,86858,86859,87000,87002,87020,87022,87024,87029,87033,87031,87040,93400,93395,93394,93393,93392,93391,87036,87039,87030,87038,87045,87573,87572,87571,87570,87037,90466,87047,87441,87443,87442,87440,87439,87438,87436,87435,90459,90458,104099,104098,104097,104096,104095,90452,90449,90448,90447,90446,90445,90451,93634,93633,61729,61728,61724,61725,61715,61714,61711,61712,59008,59007,59004,59005,44346,44347,44348,44349,41323,37916,39084,39134,39135,42696,59036,39061,39062,93912,93911,93910,93909,98994,29292,29291,29288,29287,12014,29305,29301,29302,29304,29300,84367,84385,84386,84368,10920,103781,103792,103793,103791,103795,52800,103796,104059,103785,64869,48551,103860,103859,104066,104065,104063,104062,104061,104071,104070,104069,104068,104067,104060,103851,104053,104052,104118,104039,104038,104037,104036,104035,104034,104033,104032,104031,104030,104029,104025,104024,104023,104022,104021,104020,104019,104017,104016,104015,104014,41787) and a.producent in (36)
  • фильтр
- ~z ~rekordow
Результаты поиска
Товар не найден

Вернись