<?php require_once 'includes/bootstrap.php'; require_once 'includes/product-card.php'; include 'includes/header.php'; $rs=mysqli_query($conn,"SELECT p.*,b.name brand_name FROM products p LEFT JOIN brands b ON p.brand_id=b.id WHERE p.status=1 AND (p.is_hot=1 OR p.discount_percent>0) ORDER BY p.id DESC LIMIT 60"); ?><main class="container section"><div class="title-row"><h2>Hot Deals</h2><a class="see-all" href="search.php?lang=<?php echo e($lang); ?>"><?php echo e(t('see_all')); ?></a></div><div class="product-row"><?php if($rs): while($p=mysqli_fetch_assoc($rs)): render_product_card($conn,$p,$lang); endwhile; endif; ?></div></main><?php include 'includes/footer.php'; ?>