ERROR OCCURED - PLEASE READ INSTRUCTIONS BELOW

Look at ERROR: below. It may help you resolve the problem (eg. wrong input on the previous page). If not, contact support and provide information displayed on this screen (or at least the REF #).

REF: 822581
DATE_TIME: 11/20/2009 11:39:18 PM
REMOTE_ADDR: 38.107.191.116
HTTP_REFERER: 
URL: www.improvenet.com/ext/manufacturerlistings/ML_2.html?CID=47
ERROR: The text, ntext, or image data type cannot be selected as DISTINCT.
SQL: SELECT DISTINCT M.*,G.Name,PCID=PC.ManufacturerID,G.ParentID FROM silver_dg..Manufacturer M (nolock),silver_dg..PS_Group G (nolock),silver_dg..ManufacturerGroup_Link ML (nolock),silver_dg..Photo_Category PC (nolock) WHERE G.ID=47 AND   M.ID=ML.ManufacturerID AND   ML.GroupID=G.ID AND   M.ID*=PC.ManufacturerID AND	ML.LinkType=1  AND   PC.Status=2 AND   PC.CategoryID=47 ORDER BY M.CompanyName
APP: SILVER