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 ON products_description.products_id = products.products_id) INNER JOIN specials ON products.products_id = specials.products_id
WHERE products.products_status=1;
in most cases Im lazzzy and use openoffice or msaccess to build the query graphicaly