Database problems??? Searching for a product

[Stuff4Toys]

This is weird, I have an item in my store www.USToolMan.com
SKU CHA39068
Search for it from the frontend and is comes up OK, in Category
Home :: Hand Tools :: Master Sets :: Channellock 158 Pc. Mechanic's Tool Set
http://www.ustoolman.com/index.php?m...ducts_id=19262

Click on "list" and it only shows 5 items and NONE of them are this item.
Go to Catalog in Admin and go to this sub category and there are only 5 items in it (the ones you see from the front end)
Search in the Admin and the SKU does not come up.

Went to phpMyAdmin and searched and it is there and all looks OK correct master category, etc.

Optimized Tables, Repaired tables to no avail.

Now What???
Thanks in Advance.
JOhn ><>

[Stuff4Toys]

BTW this is a native 1.50 installation

[Ajeh]

What is the master_categories_id for this products_id 19262 ...

[Stuff4Toys]

The database says it's 196 however from the the table in phpMyAdmin it shows as 196, but in the Admin it is not there and the storefront it's not there.

[Stuff4Toys]

Generation Time: Aug 22, 2012 at 01:14 PM
    Generated by: phpMyAdmin 3.4.10.2 / MySQL 5.1.63-community-log
    SQL query: SELECT *  FROM `products` WHERE `products_id` = 19262  LIMIT 0, 30 ;     
    Rows: 1        
products_id
products_type
products_quantity
products_model
products_image
products_price
products_virtual
products_date_added
products_last_modified
products_date_available
products_weight
products_status
products_tax_class_id
manufacturers_id
products_ordered
products_quantity_order_min
products_quantity_order_units
products_priced_by_attribute
map_enabled
map_price
product_is_free
product_is_call
products_quantity_mixed
product_is_always_free_shipping
products_qty_box_status
products_quantity_order_max
products_sort_order
products_discount_type
products_discount_type_from
products_price_sorter
master_categories_id
products_mixed_discount_quantity
metatags_title_status
metatags_products_name_status
metatags_model_status
metatags_price_status
metatags_title_tagline_status
import_update

19262
1
97
CHA39068
CHA39068.jpg
114.2745
0
2012-03-15 19:58:45
2012-08-12 04:27:09
NULL
14
1
1
59
0
1
1
0
0
0.0000
0
0
0
0
1
0
0
0
0
114.2745
196
1
0
0
0
0
0
Y