SELECT products.*, texts.mtitle, texts.mtext FROM products INNER JOIN texts ON texts.mid=products.id WHERE (products.deleted IS NULL or products.deleted='0') and texts.lang='1' and mtype='2' and products.show_it='1' ORDER BY case when products.true_raod!='1' or products.amount>'0' then products.price else 99999999999999 end ASC LIMIT 0, 24 chateauateni
USD