SELECT p.PageId , p.Title , p.Content ,p.MenuId FROM page p,menu m WHERE p.MenuId=m.MenuID and ( Title LIKE '%%' OR Content LIKE '%%' ) AND Title <>'' AND Content <> '' AND ShowPage = 1 ORDER BY Title