Hello Friend's I have 10 PHPLD Directories, and I have to approve the links regularly after every 15 days. They all are running on the free version. I have a approving tool called AutoApprove that will help a lot, but I have to check spam or bad link submissions before run AutoApprove. Normally I go to PHPMyAdmin and fund bad links to run search quarries like this, SELECT * FROM `PLD_LINK` WHERE `URL` LIKE CONVERT( _utf8 '%//%/%' USING latin1 ) COLLATE latin1_swedish_ci AND `STATUS` =1 LIMIT 0 , 1000 Code (markup): And change the keyword again and again, but I seen there will be lots of bad links approved after this. I am not so good in mysql. I have these doubts : What sql command to search all internal links (deep links)? What sql command to search bad submissions like no title/description and bad word's like 'porn' 'drug' etc? If anyone can know then please let me know about this, every time when I approve links I spent a lot of time to complete this. I also hear about one tool for multiple directory links checker at here. Please let me more about this, will it help me or not? Will it work in free version? Please Help !