select products.*, 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.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.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 and (products.brand_id in (82) or products.title like '%garmin%') Group BY products.id order by products.id desc
AED 181.00
AED 103.00
AED 65.00
AED 344.00
AED 207.00
AED 181.00
AED 181.00
AED 375.00
AED 375.00
AED 155.00
AED 220.00
AED 197.00
AED 77.00
AED 181.00
AED 153.00
AED 394.00
AED 172.00
 
 

Your Cart