Lichidare Stocuri » Lichidare stoc lenjerie
Produsul cautat nu este prezent in baza noastra de date.
SELECT DISTINCT prod.sku, prod.video, prod.id, name_ERO name, prod.url_word_ERO url_word, description_ERO description, price_ERO price, promo_ERO promo, discountype_ERO discountype, recommend,dailypromo, top, feat_more_ERO feat_more, TO_DAYS(`date`)-TO_DAYS(NOW())+120 as new, img, bonus_id, stock, stock_ext, delivery_time FROM prod WHERE (prod.subcat_id='476' OR prod.subcat_multiple LIKE "%`476`%") AND prod.publish_ERO = 'x' AND prod.child_of=0 ORDER BY (stock/abs(stock)) DESC,(stock_ext/abs(stock_ext)) DESC, prod.show_order_ERO LIMIT 0,18;
