Sort order :: specials products

[xergos055]

Nothing ...

I think the interogation in database is wrong..

I'm not sure if the code i made for interogation is ok.
All i want is that:

I'will put in the specials page the links with products categorys.
If the visitors want to see if in category with the name:
ex. category 1 is products with spacials price, click on that category.

I dont want in the specials page the specials products to be displayed all mixed.

The original code from tpl_specials_default.php is that:

$specials_query_raw = "SELECT p.products_id, p.products_image, pd.products_name, pd.products_description, p.master_categories_id
FROM (" . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )
WHERE p.products_id = s.products_id and p.products_id = pd.products_id and p.products_status = '1'
AND s.status = 1
AND pd.language_id = :languagesID
ORDER BY s.specials_date_added DESC";