SELECT id, subject, text1, text2, text3, indexHeadline, indexDescription, indexKeywords , prodcode, pict1, pict2, pict3, pict4, morepictures, TemplateID, parent, textsPDF ,longitude, latitude, check1, num1 FROM texts WHERE status='active' AND pagelink='Mot-oss-pa-TUR-Massan-i-Goteborg' UNION ALL SELECT id, subject, text1, text2, text3, indexHeadline, indexDescription, indexKeywords , prodcode, pict1, pict2, pict3, pict4, morepictures, TemplateID, parent, textsPDF ,longitude, latitude, check1, num1 FROM hotels WHERE status='active' AND pagelink='Mot-oss-pa-TUR-Massan-i-Goteborg'