mysql> SELECT
-> thread.threadid
-> , thread.postusername
-> FROM
-> cukforums.thread
-> INNER JOIN cukforums.poll
-> ON (thread.pollid = poll.pollid)
-> WHERE (poll.options like '%AndyW%')
-> ORDER BY thread.threadid ASC limit 15;
+----------+--------------+
| threadid | postusername |
+----------+--------------+
| 9912 | sasguru |
| 10492 | AtW |
| 10516 | AtW |
| 10576 | AtW |
| 10579 | AtW |
| 10687 | AtW |
| 10848 | AtW |
| 11147 | AtW |
| 11324 | AtW |
| 11609 | Pondlife |
| 11675 | sasguru |
| 11823 | Xenophon |
| 11981 | AtW |
| 12011 | Xenophon |
| 12233 | AtW |
+----------+--------------+
15 rows in set (0.03 sec)
) asking "Who is the thickest CUK member?" the next eight are then AtW "establishing the tradition."
) asking "Who is the thickest CUK member?" the next eight are then AtW "establishing the tradition."
Comment