SELECT b.id as idw, a.name as produkt, a.market_description, b.price as cena, b.foto as foto, b.magazyn, b.stan_magazynu, b.wyswietl_ilosc_dostepnych, a.promo_text FROM gb_market_product a, gb_market_wariant b WHERE a.kategoria=46 AND a.id=b.idp AND b.del=0 ORDER BY a.kolejnosc