Write SQL query to solve given problem: Which word has the most appearances in the Wikipedia page revision ID No. 28278070? Give the word ID.. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT pid FROM pages_words WHERE pid = ( SELECT pid FROM pages WHERE revision = 28278070 ) ORDER BY occurrences DESC LIMIT 1