select products.*, moduler.title as brandname from products, moduler where products.publish='y' and moduler.publish='y' and products.brand_id=moduler.id and moduler.mod_name='Product Brands' and MATCH(products.title,products.sku) AGAINST('hose clips' IN BOOLEAN MODE) order by products.id desc