SELECT id,name,slug,price,discounted_price,shipping_amount,rating_val,rating_count,prepaid_only,is_active,deleted FROM products WHERE products.is_featured = 1 and products.deleted = 0 and products.is_active = 1 LIMIT 10