Specials - Sold Out

[Renz]

Hi does anyone know how to make the sold out items or QTY 0
not appear on the specials page.
I have it worked out for the rest of the stores with some sql commands I have found here and there by Ajeh.
Just need one for specials.
Cheers
RR

[Ajeh]

You need to customize the SELECT statement in the:
/includes/modules/pages/specials/main_template_vars.php

and add the:

and p.products_quantity > 0

to it ...