Search options (Page 32 of 106)

define('PUN_ADMIN', 1);
define('PUN_MOD', 2);
define('PUN_GUEST', 3);
define('PUN_MEMBER', 4);

mysql> SELECT sw.word, COUNT(sm.post_id) AS hits
    -> FROM search_words AS sw
    -> INNER JOIN search_matches AS sm ON sw.id = sm.word_id
    -> GROUP BY sw.id
    -> ORDER BY hits DESC LIMIT 50;
+----------+------+
| word     | hits |
+----------+------+
| moved    |    2 |
| enjoy    |    1 |
| posting  |    1 |
| and      |    1 |
| imported |    1 |
| maybe    |    1 |
| guests   |    1 |
| new      |    1 |
| forum    |    1 |
| put      |    1 |
| spam     |    1 |
| removed  |    1 |
| portal   |    1 |
| bots     |    1 |
| fairly   |    1 |
| brand    |    1 |
| again    |    1 |
| flooding |    1 |
| hosting  |    1 |
| section  |    1 |
| doubt    |    1 |
| us       |    1 |
| links    |    1 |
| strategy |    1 |
| data     |    1 |
| needed   |    1 |
| anyway   |    1 |
| page     |    1 |
| improved |    1 |
| old      |    1 |
+----------+------+
30 rows in set (0.10 sec)

mysql> SELECT COUNT( m.post_id ) , w.word
    -> FROM search_matches AS m
    -> INNER JOIN search_words AS w ON m.word_id = w.id
    -> GROUP BY m.word_id
    -> ORDER BY COUNT( m.post_id ) DESC
    -> LIMIT 100;
+--------------------+----------+
| COUNT( m.post_id ) | word     |
+--------------------+----------+
|                  2 | moved    |
|                  1 | needed   |
|                  1 | data     |
|                  1 | section  |
|                  1 | fairly   |
|                  1 | spam     |
|                  1 | maybe    |
|                  1 | old      |
|                  1 | strategy |
|                  1 | hosting  |
|                  1 | bots     |
|                  1 | put      |
|                  1 | imported |
|                  1 | improved |
|                  1 | links    |
|                  1 | flooding |
|                  1 | portal   |
|                  1 | forum    |
|                  1 | and      |
|                  1 | page     |
|                  1 | us       |
|                  1 | again    |
|                  1 | removed  |
|                  1 | new      |
|                  1 | posting  |
|                  1 | anyway   |
|                  1 | doubt    |
|                  1 | brand    |
|                  1 | guests   |
|                  1 | enjoy    |
+--------------------+----------+
30 rows in set (0.06 sec)