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='Kapstaden-och-safari-sommarlovsresa-till-Sydafrika' 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='Kapstaden-och-safari-sommarlovsresa-till-Sydafrika'