think tank forum

mysql> SELECT thread_id, title, posts FROM ttf_thread ORDER BY posts DESC LIMIT 10;           +-----------+--------------------------------+-------+
| thread_id | title                          | posts |
+-----------+--------------------------------+-------+
|       222 | one line only!                 |   930 |
|       932 | i bought things                |   604 |
|      2172 | awesome things done today pt 6 |   575 |
|      1646 | what happened?                 |   572 |
|      1941 | It was a good day!             |   497 |
|       619 | screen shots                   |   461 |
|      1773 | awesome things done today pt 3 |   433 |
|      1545 | what you ate today             |   409 |
|      1417 | school updates                 |   400 |
|      1485 | awesome things done today pt 2 |   369 |
+-----------+--------------------------------+-------+
10 rows in set (0.00 sec)

mysql> SELECT thread_id, title, posts FROM ttf_thread WHERE title LIKE 'awesome things%' ORDER BY posts DESC LIMIT 10;
+-----------+--------------------------------+-------+
| thread_id | title                          | posts |
+-----------+--------------------------------+-------+
|      2172 | awesome things done today pt 6 |   575 |
|      1773 | awesome things done today pt 3 |   433 |
|      1485 | awesome things done today pt 2 |   369 |
|      1910 | awesome things done today pt 4 |   316 |
|      2082 | awesome things done today pt 5 |   204 |
|      1310 | awesome things you did today   |   140 |
+-----------+--------------------------------+-------+
6 rows in set (0.00 sec)

mysql> SELECT SUM(posts) FROM ttf_thread WHERE title LIKE 'awesome things%';
+------------+
| SUM(posts) |
+------------+
|       2037 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT thread_id, title, posts FROM ttf_thread WHERE title NOT LIKE 'awesome things%' ORDER BY posts DESC LIMIT 9;
+-----------+----------------------------+-------+
| thread_id | title                      | posts |
+-----------+----------------------------+-------+
|       222 | one line only!             |   930 |
|       932 | i bought things            |   604 |
|      1646 | what happened?             |   572 |
|      1941 | It was a good day!         |   497 |
|       619 | screen shots               |   461 |
|      1545 | what you ate today         |   409 |
|      1417 | school updates             |   400 |
|       720 | ttf user photos.           |   345 |
|      1657 | terrible things done today |   341 |
+-----------+----------------------------+-------+
9 rows in set (0.00 sec)