select catalogid,cname,ccode,colourdesc,brand,gender from products where catalogid = ?