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 (30,13,31,244) and a.id in (75202,75191,75194,59337,59395,62871,75203,75199,59863,68739,59862,59858,68741,82385,59839,59838,59352,69334,69333,69331,71994,87481,69321,69316,71995,69324,69323,69322,69320,69317,69318,59837,69358,59342,69300,69303,69302,69301,69298,69297,69350,59835,75095,74762,102003,62922,62920,62919,75192,69017,62276,62275,62274,61861,61858,61832,69307,69306,69304,71374,71373,71371,71370,71369,71368,71367,71366,71364,71430,71429,71428,71434,71433,71443,71426,71432,71425,71424,64732,64731,63441,63435,62520,69313,71997,64022,71359,69377,73451,73450,73449,69378,69291,69292,73488,73454,73456,73452,82387,69308,71999,72001,72000,71357,71435,75197,74761,76824,75093,75092,75188,75187,76809,76820,76817,87071,82389,93433,82559,82556,82554,93469,87475,82551,93441,93432,93443,93442,93434,93470,93457,93428,93430,93455,93462,93461,102028,93439,102031,102030,93410,93464,87478,102027,80570,82548,82576,82384,80571,93472,93471,87474,82575,82546,93466,93465,80572,80573,80574,80575,80576,80577,80578,80579,80580,80581,80582,80583,80584,80585,80586,80587,80588,80589,80590,80591,80593,80594,80595,80597,80608,80609,80610,80618,80615,93459,93437,82383,93458,82381,93456,87472,8631,10146,93454,82543,82577,82540,93438,93429,69371,69237,62918,76591,82436,69240,82441,82437,84141,93900,93448,93446,69352,87325,93445,93444,93440,71990,71992,93435,87248,87214,93412,82732,82723,82731,82735,82737,82734,82717,82718,82716,82739,82789,82743,82730,82727,82729,86359,86358,87479,87476,87208,87470,87473,87217,86354,87469,99297,87207,87206,99295,93860,93862,82512,82510,93865,99296,93925,93858,93857,99303,101997,82719,82721,82720,99302)
  • Show / hide filters
- out of records