SELECT id, subject, text1,textsPDF, indexHeadline, indexDescription, indexKeywords, pict2 , prodcode, pict1, morepictures, pict3, TemplateID, parent, pict4 FROM texts WHERE status='active' AND pagelink='Rugby-6-Nations-France-v-England' 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='Rugby-6-Nations-France-v-England'