OK, I admit I hacked my way this far and have now become stuck

What I am trying to do is a custom query that will give the the following that I can save after the query runs.

I need the:

Product URL (comes from products_description table)
Product Name (comes from products_description table)
Product Description (comes from products_description table)
Image URL (comes from products_description table)
Product Category (I believe comes from categories_description table - categories_name)
Product Price (comes from products table)

Here is my query I hacked together so far:

SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, pd.products_url, p.products_image, p.master_categories_id
FROM zen_products p
LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id)
LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id)
WHERE p.products_status = 1
ORDER BY p.products_last_modified DESC

I got half of the correct results. Can anyone please assist me in finishing it off???

tia...

0be1