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('Starrett Cutting Blades' IN BOOLEAN MODE)
order by
products.id desc
