0 and item_stock_id not in (select item_stock_id from cleanup_item_stock) and DATE(expiry_date)<= (CURDATE() + INTERVAL $expiryAlertAdvance DAY )) itm_stk where itm_stk.item_id=i.item_id";
$results_expiry_items = mysqli_query($conn,$sql_expiry_items);
$total_item = mysqli_num_rows($results_expiry_items);
?>