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 '%kore%') OR (moduler.title like '%kore%')) 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
AED 468.00
AED 421.00
Kore Outdoor Kore Outdoor Combo Pack
AED 950.00
AED 305.00
AED 150.00
AED 238.00
AED 191.00
AED 299.00
AED 269.00
AED 1,355.00
AED 1,220.00
 
 

Your Cart