Nice Ranked SQL Query

Nice ranked SQL statement to take multiple keywords and then check for occurrences in multiple fields giving decreasing points to that keyword in fields. Results are sorted by the highest points for total occurrences and points awarded.

20121129-152613.jpg