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 aktywny='Y'and artKat.kat_id in (60,40,119,124,43,294,295,296,298,299,300,118,41,120,66,159,160,125,127,128,221,280,42,121,301) and a.producent not in (34, 312, 419, 420, 414, 347, 444, 451, 452, 459,102, 435) and a.data >= DATE_SUB( CURDATE( ) , INTERVAL 60 DAY ) and a.id in (42926,33572,33590,33577,102522,102521,45839,102525,102518,102524,102523,39701,102515,50492,39699,39704,39705,39706,34680,34674,33617,33625,39709,39708,39712,39711,39714,39713,40642,39715,50346,40643,40644,40646,18073,18075,50347,40648,42923,40649,42922,18070,12950,42928,42927,42925,12945,42929,42930,42932,42931,42933,42935,40638,18076,40650,68341,68343,68344,68373,68374,102450,102449,102444,102453,102452,102451,102445,102447,102448,103041,103042,35503,35512,49177,35499,35498,50435,50437,50443,50444,50460,50461,74844,74845,74827,74825,74856,74847,74848,50434,50442,50462,40040,40039,74871,74858,74860,74863,74866,74835,74846,102776,102777,102778,104611,104612,66704,103232,103621,45154,45942,46409,45508,45838,46282,46281,46280,102527,102533,102532,102531,102530,103169,103168,103170,102489,102526,50463,34677,33626,33639,33442,35427,40041,45941,45153,46283,103171,103173,103174,103175,103176,103177,47057,103187,103188,103192,103193,103194,103195,103196,103197,103198,103226,50335,50333,47443,68425,68426,68427,68428,102815,67997,68002,68001,68000,67998,66453,66450,66448,66445,66441,66409,66408,66399,66387,66386,66385,66383,66380,46413,46411,46410,102779,102813,102814,65944,65945,65946,66698,66699,66700,66456,66455,66454,66458,66457,66461,66460,66459,66463,66462,66537,66465,66464,66468,66467,66466,66471,66470,66469,66472,66473,66474,72103,66695,79612,51040,84229,102816,73384,73383,60756,60755,60754,60753,60752,60750,60749,60748,60747,60746,60745,60744,60743,60742,60741,60740,60739,60738,60737,60736,60735,60734,102520,102819,102818,102817,65889,102517,102516,40074,40075,40076,40077,65168,65166,65167,79611,79609,79608,79607,79606,79604,99007,66133,66135,66128,72101,102862,66667,71013,71012,70996,70995,70994,70992,70989,70988,70987,70986,70985,103978,103980,103979,99005,99004,103938,103940,103939,103941,103981,103959,103982,103961,103960,103962,103963,79620,79513,79514,79515,79516,79517,79518,79625,79519,79520,79522,79521,48321,46873,46871,44266,44265,103043,79529,79534,79533,77816,79579,79578,79580,79581,79582,79583,79584,79585,79586,79587,79588,79589,79590,79591,79592,79593,79594,79595,79596,79598,79599,79600,79601,79602,79603,99003,99002,99001,102809,102811,104618,104619,104613,104614,104615,104616,104617,80883,80874,80875,80877,80870,80872,80779,80778,102822,102823,102825,102827,102830,102831,102832,102834,102864,102865,102866,102867,102868,102869,102870,102871,102872,102873,102874,102875,102876,102877,102878,102879,102880,102881,81993,82018,82015,80852,104607,104608,104609,102792,102794,104610,102785,102786,102787,102789,102790,102768,102769,76844,14347,84166,64820,60472,76881,76909,7496,76907,76884,60473,104546,104547,104559,104560,104561,104562,104548,104549,104550,104551,104552,12947,102529,102528,65608,65609,66804,65587,102883,102884,102885,102886,102887,102888,102889,102890,104623,104624,104625,104626,65611,65612,66835,65388,65620,65621,104627,104628,104629,66833,65387,104630,104631,104632,102820,102882,68531,65632,65631,104633,65633,104634,104635,104636,104637,104638,104639,104640,104641,104642,104643,104644,104645,104646,104647,104648,104649,65456,65457,66810,66812,66811,66809,65397,65399,65400,65398,65596,65595,68529,104650,65594,104651,65593,104652,104653,104654,104655,104656,104657,104658,104659,66828,66830,66827,104660,104661,104662,68522,65619,66815,66814,66813,65602,65601,65419,68503,68502,65589,65394,68539,65402,65625,65622,66798,66797,66796,68510,68512,68511,68509,65615,68537,65450,66822,66826,66823,66845,66844,66843,65603,68532,65417,102541,102540,84567,84566,84565,84564,84568,84562,84561,84560,84559,84558,84557,84540,84539,84538,84537,84536,84535,84534,84533,84532,84531,84530,84529,84528,84527,84526,84525,84524,84523,84522,84521,84520,84519,84518,84517,84516,84515,84514,84513,84512,84511,84510,84509,84508,84507,84506,84505,84504,84503,84502,84501,84500,84499,84498,84497,84496,84495,84494,84493,84492,84491,84490,84489,84488,84487,84486,84485,84484,84483,84482,84481,84480,84479,84478,84477,84476,84475,84474,84473,84472,84471,84470,84469,84468,84365,84364,84363,84362,84361,84360,84359,84358,84357,84356,84355,84354,84353,84352,84351,84350,84349,84348,84347,84346,84345,84344,84343,84342,84341,84340,84339,84338,84332,84331,84330,84329,84328,84327,84326,84325,84324,84323,84322,84321,84320,84319,84318,84317,84316,84315,84314,84313,84312,84311,84310,84309,84308,84307,84306,84305,84303,84302,84301,84431,84430,84429,84420,84419,84418,84417,84415,84414,84413,84412,84411,84410,84409,84408,84407,84406,84405,84404,84403,84402,84400,84399,84398,84397,84395,84394,84393,84392,84298,84297,84296,84295,84294,84293,84292,84291,84290,84289,84288,84287,84286,84285,84284,84283,84282,84281,84280,84279,84278,84277,84276,84275,84274,84273,84272,84271,84270,84269,102426,86980,86981,86989,86991,86992,94177,93870,93871,102812,103623,103624,103626,103627,103628,103629,77695,77694,77693,31334,31337,102542,86491,86492,86493,86494,86497,86495,86498,86496,76745,76744,76743,98975,102537,94094,94093,94092,94091,94090,94089,94088,94087,94086,94085,94084,94083,94082,94081,94080,94079,94078,94077,93908,93907,93906,93905,93904,94480,102808,60833,60830,60829,60832,60831,35197,35199,35201,60835,60838,60834,60839,60840,60837,60841,35196,35187,35195,35191,35189,84300,84299,72070,84226,84225,94482,102774,102775,94490,79691,102801,84865,102795,94481,102549,102770,94484,94521,94520,94519,94518,94517,94516,94515,94514,94495,94494,94493,94492,94491,94489,94488,94487,94486,94485,94510,94509,94507,94506,94505,94504,94462,94461,94460,94459,94458,94456,94455,94454,94453,94452,94499,94498,94497,94496,94450,94449,94448,94447,94446,94444,94443,94442,94441,94440,94438,94437,94436,94435,94434,94432,94431,94430,94429,94428,102548,102539,102535,94479,94478,94477,94476,94475,94474,94473,94472,94471,94470,94469,94468,94467,94466,94465,94464,94463,94483,94457,94451,94445,94439,94433,94427,94596,94595,94594,94593,102538,102545,102536,102543,102547,102555,102554,102553,102552,102551,102550,102546,102544,94179,94180,94181,94176,94175,94173,94172,94170,94169,94168,94157,94138,94182,65531,65533,65534,104620,104621,104622,103142,103257,103053,102557,102556,102946,102945,103056,103055,103060,103063,103066,103065,103064,103069,103051,103054,103052,103973,103955,103958,103957,103956,103977,103976,103975,103974,103141,103140,103139,103137,103937,103954,103644,103681,103680,103677,103820,103819,103817,104197,104196,104195,104194,104189,104187,104186,104185,104184,104182,104181,104180,104176,104175,104174,104173,104172,104170,104169,104168,104167,104166,104165,104164,104162,104161,104160,104158,104157,104156,104155,104154,104145,103953,103952,103951,103950,103949,103948,103947,103946,103945,103944,103943,103942,103972,103971,103970,103969,103968,103967,103966,103965,103964,103936,103935,103934,103933,104576,104575,104574,104579,104578,104577,104582,104581,104580,104584,104583,104587,104586,104590,104589,104588,104594,104593,104592,104599,104598,104597,104595,104600,104558,104557,104556,104555,104554,104553,64004,77697,84336) and a.producent in (457)
  • Pokaż / ukryj filtry
- z rekordów
Wyniki szukania
Niestety nic nie znaleziono.

Wróć