SELECT * FROM (SELECT * FROM news WHERE Hidden = 0 AND news.Headline like '%bluetooth%' ORDER BY NewsOrder DESC) AS `a` UNION DISTINCT SELECT * FROM (SELECT * FROM news WHERE Hidden = 0 AND news.TextFull like '%bluetooth%' ORDER BY NewsOrder) AS `b`;






SELECT * FROM (SELECT reviews.ReviewID, reviews.PhoneID, reviews.ReviewOrder, reviews.DatePosted, reviews.Author, reviews.ReviewTitle, reviews.Summary, reviews.OriginalURL, reviews.Seller, reviews.Hits, reviews.SellerMainZone, reviews.SellerSkyZone, reviews.ReviewThumbPic, reviews.ReviewURL, reviews.FrontOrder, reviews.TitleFront, reviews.SubtitleFront, reviews.ReviewFrontPic, reviews.SummaryFront, reviews.Hidden, reviews.TimePublished, reviews.Tags, reviews.P2RLink, reviews.Promoted, reviews.VideoLink, reviews.ExtReviewTitle, reviews.ExtReviewURL, reviews.Priority, reviews.CommentNumber FROM reviewpages LEFT JOIN reviews ON reviewpages.ReviewID = reviews.ReviewID LEFT JOIN phones ON reviews.PhoneID = phones.PhoneID LEFT JOIN makers ON phones.MakerID = makers.MakerID WHERE reviews.Hidden = 0 AND reviews.ReviewTitle like '%bluetooth%' ORDER BY ReviewOrder DESC) AS `a` UNION DISTINCT SELECT * FROM (SELECT reviews.ReviewID, reviews.PhoneID, reviews.ReviewOrder, reviews.DatePosted, reviews.Author, reviews.ReviewTitle, reviews.Summary, reviews.OriginalURL, reviews.Seller, reviews.Hits, reviews.SellerMainZone, reviews.SellerSkyZone, reviews.ReviewThumbPic, reviews.ReviewURL, reviews.FrontOrder, reviews.TitleFront, reviews.SubtitleFront, reviews.ReviewFrontPic, reviews.SummaryFront, reviews.Hidden, reviews.TimePublished, reviews.Tags, reviews.P2RLink, reviews.Promoted, reviews.VideoLink, reviews.ExtReviewTitle, reviews.ExtReviewURL, reviews.Priority, reviews.CommentNumber FROM reviewpages LEFT JOIN reviews ON reviewpages.ReviewID = reviews.ReviewID LEFT JOIN phones ON reviews.PhoneID = phones.PhoneID LEFT JOIN makers ON phones.MakerID = makers.MakerID WHERE reviews.Hidden = 0 AND reviewpages.PageID = 1 AND reviewpages.TextFull like '%bluetooth%' ORDER BY ReviewOrder DESC) AS `b`;