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 (398) or products.title like '%kazoo%') Group BY products.id order by products.id desc
AED 261.00
AED 261.00
AED 599.00
AED 599.00
AED 799.00
AED 799.00
 
 

Your Cart