select p.*, pd.* from products p, products_description pd, products_to_categories p2c where p.products_id = p2c.products_id and p2c.categories_id = 5 and p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = 5 order by p.sort_order desc, p.products_id