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 (69334,69333,69331,69321,71995,69324,69322,69320,69318,93438,69303,69302,69299,69298,69297,69350,69300,75095,62922,62920,62919,62276,62275,62274,62273,62272,61861,61860,61859,61858,61853,61852,61832,69307,69306,71374,71371,71370,71369,71368,71367,71366,71364,71430,71444,71428,71434,71443,71426,71432,71425,71424,64732,64731,62520,69313,71359,69377,73451,73449,69378,69291,69292,69288,87068,69287,73454,73452,73455,82520,69308,87481,71357,74762,76824,75093,75092,76809,82559,82556,82554,87475,87476,82551,93441,93442,93432,93443,93434,93470,102003,93428,93430,93455,93462,102028,93439,102031,102030,93410,93464,87478,102027,93437,80570,82548,82576,80571,93472,93471,93459,82575,82546,93466,93435,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,93460,93458,93433,93456,87472,8631,10146,93454,82543,82577,82540,93429,69371,76591,82436,82441,82437,84141,93900,93448,93446,69352,93445,93444,93440,71990,71992,71991,82732,82723,82735,82737,82734,82717,82718,82716,82739,82789,82743,82730,82727,82729,86359,86358,93929,87480,87479,87061,87473,86354,93860,93862,93865,93928,93858,93857,99303,101997,82721,82720,99302)
  • Show / hide filters
- out of records