SELECT t.id, t.subject, t.text1, t.text2, t.text3, t.indexHeadline, t.indexDescription, t.indexKeywords , t.pict1, t.pict2, t.pict3, t.pict4, t.morepictures, t.TemplateID, t.parent , t.prodcode, t.textsPDF , t.longitude, t.latitude, t.check1, t.num1, t.type , t.company, t.department , t.SiteCode, m.url FROM hotels t LEFT JOIN MultipleSites m on t.siteCode = m.siteCode WHERE status='active' AND pagelink='Sommerrejser' AND textsLanguage='DK'