Product missing from admin, but showing on site and phpmyadmin

Hi,
I'm trying to turn off a product, that isn't appearing in admin.
It has an id number in phpmyadmin and is showing on the website, but the product is just not findable in admin.

Could it be from a server timeout or something when updating the product at some stage?

Please note it's not a spelling mistake I'm making and I've tried searching by id and name.

Thanks

Also noticed it only shows when searching website by product name. Doesn't seem to show in category.
http://partydudes.co.nz/buy-ladies-costumes/view-all-ladies-costumes/buy-disco-dancing-queen

Selecting previous or next leads to a non page
Do you have this item in a cat that also has sub cats?

Shouldn't be. This product would normally sit with 400 or so other products at the same level.
They are all about 3 categories deep, but hopefully no sub category along side the products (if that's even possible to do?)
It appears to be in the correct place going by the address bar, but am not able to check in my admin.

Looking through your cat view-all-ladies-costumes
I did not see the item you posted

Ah yes, that's what I meant in my 2nd post....
Only seems to show with a direct name search or following an old link etc.

Go to phpMyAdmin and check your table:
products_description

for this products_name ...

Get the products_id for that ...

Now, go to the table:
products_to_categories

search for that products_id ... do you find it?

Your item number is: 2939
other item that MAY work go to
store/YOUR_ADMIN/product.php?page=1&product_type=1&pID=2939&action=new_product

Well done bislewl :)
Came up with invalid master category, so just swapped that to a correct one and it's all go.
Now have managed to mark as out of stock so no one buys it until it's back in stock.
Thank you!
Thanks Ajeh for your input.