Hello there,

Thanks for the quick reply... and your idea does makes sense.. except the fact that I do not know what sql query I need to use to unvalidate the listings once I get the ID numbers of all the listings within certain category?

B) I can do a test install, import entire DB, change the settings to it should display 10,000 link on one page, and then change the link.html page so it will only display the ID number of the listing, I think doing so should give me the ID number of all the listings within any given category within seconds... thanks for the wonderful trick. :)

Now still I am hoping if I can get some help with the sql query to unvalidate all the listings.

Vishal

Vishal
-------------------------------------------------------