SELECT Item_ID, Category_ID, [Catalogue Code], [Product Description], Colour, Size, UOM, Price, Image, [Web Blurb], [Web Keywords], Item_Grouping_Code, Brand_Name, Brand_Image FROM [MProduct_www.bondfurniture.co.za] WHERE (Pagination_FA IS NOT NULL OR Member_ID = '150') AND (( NOT (Item_Grouping_Code IS NULL)) or Member_ID = '150' ) AND ([MProduct_www.bondfurniture.co.za].Category_ID = '3263') ORDER BY Item_Grouping_Code, colour, [Catalogue Code], [Product Description]