Mining the search engine
From Drafts
- 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