chenbrok

kCOMPUTER CAS

SELECT B.* FROM (SELECT tb_id FROM products WHERE sale_price > 0 and display = 1 and match(mfg,mfg_mod_part,descr) against ("+chenbro*" in boolean mode) limit 0,200) A LEFT JOIN products B USING (tb_id) order by qty DESCWe are experiancing some techincal difficulties please check back in a few minutess