SELECT id, subject, text1,textsPDF, indexHeadline, indexDescription, indexKeywords, pict2 , prodcode, pict1, morepictures, pict3, TemplateID, parent, pict4 FROM texts WHERE status='active' AND pagelink='Peter-Andre' UNION ALL SELECT id, subject, text1,textsPDF, indexHeadline, indexDescription, indexKeywords, pict2 , prodcode, pict1, morepictures, pict3, TemplateID, parent, pict4 FROM hotels WHERE status='active' AND pagelink='Peter-Andre'