Mining the search engine

From Drafts
Jump to: navigation, search
  • Listing the keywords by weight
SELECT engine.key_id, SUM( engine.weight ) AS wa, keywords.keyword
FROM ENGINE , keywords
WHERE keywords.key_id = engine.key_id
AND LENGTH( keywords.keyword ) >2
GROUP BY key_id
ORDER BY wa DESC 
  • Viewing the distribution of the keywords by folders, by sites, by pages