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 '%garmin%') OR (moduler.title like '%garmin%')) 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
About Us...
OutdoorGears is an UAE based company Established in 2019 and has presence in India, Saudi Arabia, Oman, and East Africa. We are specialized in Adventure, sports and travel products.We are excited to make your journey a true success. There are different types of people but not everyone dares to choose challenges & differences in the World. Do you think if you are one of them then stop thinking start and chasing?
24/7 Customer Support
OutdoorGears suppport team is hard working 24/7 for our customers.We give high priority to troubleshoot and sort out all the complaints and issue of ourcustomers. We will provide entire support till your face smiles.