SELECT p.*, pd.products_name, pd.products_description, pc.categories_id FROM products p, products_description pd, products_to_categories pc WHERE pc.categories_id = 198 AND p.products_id = pd.products_id AND p.products_id = pc.products_id AND p.products_status = 1 AND pd.language_id = FLOOR(1) ORDER BY pc.categories_id, pd.products_name
