Improved SiteMap Display

[DivaVocals]

So I tried this, and still no dice.. All of my inactive products still show up on the site map.. **sigh** I am stumped..

$categories_query = "select c.categories_id, cd.categories_name, c.parent_id, p.products_status 
    from " . TABLE_CATEGORIES . " c LEFT JOIN "
    . TABLE_HIDE_CATEGORIES . " h ON (c.categories_id = h.categories_id), "
    . TABLE_CATEGORIES_DESCRIPTION . " cd, "
    . TABLE_PRODUCTS . " p
    where (h.visibility_status < 2 OR h.visibility_status IS NULL)
    and c.categories_id = cd.categories_id
    and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
    and c.categories_status != '0'
    and p.products_status != '0'
    order by c.parent_id, c.sort_order, cd.categories_name, p.products_status";