Not knowing your exact data model and requirements, I will give you an example that should spark some ideas. We can help further with more information about your model.
The following query will find the keyword node identified with its 'word' property equal to the string 'mykeyword'. It then finds all the related pages for the given keyword node. The returns the properties of each related page, order by the 'rank_id' property of the 'LINK' relationship.
Match (:Keyword {word:"mykeyword"})-[l:LINK]->(p:Page)
RETURN properties(p) as page
ORDER by l.rank_id DESC`