select products.id, products.odg_sku, products.slug, CONCAT(products.title) as title, moduler.title as brandname, product_price.price as prod_price, product_price.offerprice as prod_offerprice, product_stock.instock from products, moduler, product_price, product_stock where ((products.title like '%Coleman%') OR (moduler.title like '%Coleman%')) AND products.publish='y' and moduler.publish='y' and products.brand_id=moduler.id and moduler.mod_name='product brands' and products.id=product_price.product_id and products.id=product_stock.product_id and product_stock.instock > 0 and product_stock.product_id=product_price.product_id and IF(product_price.offerprice>0, CAST(product_price.offerprice AS DECIMAL(10,2)), CAST(product_price.price AS DECIMAL(10,2))) between 1 AND 80000 group by products.id