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 (36,32,21,75,76,78,79,80,77,81,82,83,84,85,101,86,113,114,92,93,94,115,90,91,116,117,123,126,143,148,166,167,168,169,176,179,180,181,182,183,184,185,189,194,196,200,201,202,203,206,213,215,216,217,219,241,242,279,252,259,260,261,262,275,276,263,264,265,266,267,268,269,270,271,272,273,274,277,278,285,286,297,302,303,304) and a.producent not in (34, 312, 419, 420, 414, 347, 444, 451, 452, 459,102, 435) and a.producent = 228
  • Pokaż / ukryj filtry
- z rekordów