Worked a charm, thanks hugo!

I'll have to really look at Join Statements. That might take me a little bit to digest.

I have managed to expand it to find only the products on special by doing this:
Code:
SELECT products_description.products_name, products_description.products_description, products_description.products_id, products.products_image, products.products_price_sorter
FROM products_description
INNER JOIN (
products, specials
) ON ( products_description.products_id = products.products_id
AND specials.status = "1"
AND products_description.products_id = specials.products_id )
WHERE products.products_status =1
Now to pull products on sale, must be similar but using master category ids.

And lastly to pull everything not on sale/special, hmmm, not sure how that will work. Any thoughts?