On my newest site which is under construction I am using vbadvanced cmps for the portal page, I dredged up an old old module for displaying latest ZC products on the portal page and after many hours of playing with the query (I am not a programmer LOL) I finally managed to get it to show them...the issue I have though is that it won't display sale price or special price...can anyone help me with the following code to what I need to add in to get these to show?

Code:
SELECT distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, p.products_price, p.products_status, p.products_date_added, p.master_categories_id, m.manufacturers_name
FROM products p
LEFT JOIN manufacturers m
ON (p.manufacturers_id = m.manufacturers_id), products_description pd
WHERE p.products_id = pd.products_id
AND p.products_status = 1
and p.products_price > 0
ORDER BY p.products_date_added
LIMIT $numofprod;";
TIA