Звоните с 09-00 до 21-00 по МСК                  8 (499) 213-00-93



Сигнальные пистолеты

    SELECT t.id, t.name, t.price, t.old_price, t.price_opt, t.price_opt1, t.price_opt2, t.price_opt3, t.tag_new, t.flag_nalichie, t.Quant, categ_new.new_suf, c.new_suf as csuf FROM tovars as t LEFT JOIN categ_new ON t.categ_new = categ_new.id LEFT JOIN categ_new as c ON t.podcateg_new = c.id where t.categ_new='654' and t.price>0 and t.dis!='1' order by t.flag_nalichie DESC, t.Quant DESC limit 60


TOP