select * from products where available=1 and outOfStock=0 and code!="" and (category1 in (44) or category2 in (44) or category3 in (44)) and (price*(100-discount)/100>=0 and price*(100-discount)/100<=100000) order by onTop desc, hasQnt desc, new_pr desc, id desc limit 0,24
ΤΗΛΕΦΩΝΙΚΗ ΕΞΥΠΗΡΕΤΗΣΗ: 22510 24107 | Δευτ-Σαβ 9πμ - 4μμ
SOCIALS
