SELECT id, subject, company, department, text1, text2, text3, indexHeadline, indexDescription, indexKeywords , cast(prodcode as nvarchar(500)) COLLATE SQL_Latin1_General_CP1_CI_AS as prodcode, pict1, pict2, pict3, pict4, morepictures, TemplateID, parent, cast(textsPDF as varchar(254)) COLLATE SQL_Latin1_General_CP1_CI_AS as textsPDF ,longitude, latitude, check1, num1 FROM hotels WHERE status='active' AND pagelink='Tester' AND textsLanguage='DK' AND company='OL'