script for "277k articles" database?

Some weeks (or maybe months) ago I bought a pack of 280,000 articles from someone on here. It was a huge sql file, and didn't include a script to read it.

I just today got an article-related domain on the cheap, so I decided to pull up this huge database file and take a look at it.

I imported the articles into a database and I'm starting to look through the articles and I realize that they're not organized properly by category.

Here's the table layout:

mysql> describe article_master;
+---------------------+--------------+------+-----+------------+----------------+
| Field               | Type         | Null | Key | Default    | Extra          |
+---------------------+--------------+------+-----+------------+----------------+
| article_id          | bigint(20)   | NO   | PRI | NULL       | auto_increment |
| article_user_id     | int(11)      | NO   |     | 0          |                |
| article_author      | varchar(100) | NO   |     |            |                |
| article_snippet     | varchar(255) | NO   |     |            |                |
| article_summary     | text         | NO   |     |            |                |
| article_title       | varchar(100) | NO   |     |            |                |
| article_category_id | int(11)      | NO   |     | 0          |                |
| article_views       | bigint(20)   | NO   |     | 0          |                |
| article_status      | int(11)      | NO   |     | 1          |                |
| article_date        | date         | NO   |     | 0000-00-00 |                |
| article_home_page   | int(11)      | NO   |     | 0          |                |
| article_email       | int(11)      | NO   |     | 0          |                |
+---------------------+--------------+------+-----+------------+----------------+
12 rows in set (0.02 sec)

Code (markup):

I started doing some listings by article_category_id, and maybe 80-90% of the articles within a category seem consistent, but some aren't.

For example, I did a listing of 10 articles from category ID 2. 8 of the 10 articles were about pets. 2 of them were about selling ebooks or something.

So, my question is:

- Has anyone else used this article database?
- Did you receive a script with it?
- Were you able to use the articles productively somehow?

I hate to just throw the articles away, but it would be very difficult, or at the least time-consuming, to winnow the wheat from the chaff.

 

I have that script, PM me if you want it(free ofcourse )