SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 05:08 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `phorum_messages` ORDER BY `viewcount` ASC LIMIT 0, 30;
Rows: 3

message_id forum_id thread parent_id author subject body email ip status msgid modifystamp user_id thread_count moderator_post sort datestamp meta viewcount closed
1 1 1 0 Phorum Installer Test Message This is a test message.  You can delete it after install using the admin.

Phorum 5 Team
  127.0.0.1 2   1182891684 0 2 0 2 1182891420 a:3:{s:11:"recent_post";a:3:{s:7:"user_id";s:1:"1";s:6:"author";s:5:"ppcru";s:10:"message_id";s:1:"2";}s:11:"message_ids";a:2:{i:0;i:1;i:1;i:2;}s:21:"message_ids_moderator";a:2:{i:0;i:1;i:1;i:2;}} 0 0
2 1 1 1 ppcru Re: Test Message test #2   adsl-70-240-102-97.dsl.hstntx.swbell.net 2 7f9d447641d4a155bba36f406ba300a2.TestForum 0 1 0 1 2 1182891684 a:0:{} 0 0
3 1 3 0 ppcru Another Test another tester   adsl-70-240-102-97.dsl.hstntx.swbell.net 2 430c38de1da94adb23180f35a6371a07.TestForum 1182893859 1 1 1 2 1182893859 a:3:{s:11:"recent_post";a:3:{s:7:"user_id";s:1:"1";s:6:"author";s:5:"ppcru";s:10:"message_id";s:1:"3";}s:11:"message_ids";a:1:{i:0;i:3;}s:21:"message_ids_moderator";a:1:{i:0;i:3;}} 0 0