-

SELECT p.products_id as pID FROM products_to_categories ptc, products p WHERE ptc.products_id= p.products_id AND ptc.categories_id = '101' AND p.products_status = '1' and p.group_permission_1=1 group by p.products_id order by pd.products_name ASC , p.products_id ASC

[XT SQL Error]