Custom inventory query statement - Need help please
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
"Give me one hundred preachers who fear nothing but sin and desire nothing but God, and I care not whether they be clergymen or laymen, they alone will shake the gates of Hell and set up the kingdom of Heaven upon Earth." - John Wesley
Bookmarks