SELECT count(*)  FROM product_table WHERE delete_date IS NULL AND sub_category=:sub_category ORDER BY product_id