<?php $sql = "SELECT * from {comments} where ";

$sql .= " subject like '%Sorry admin%' or ";
$sql .= " subject like '%levitz furniture%' or ";
$sql .= " subject like '%farmall tractor%' or ";
$sql .= " subject like '%boxer puppy%' or ";
$sql .= " subject like 'Valdis%' or ";
$sql .= " subject like 'Michael%' or ";
$sql .= " subject like 'Fillip%' or ";
$sql .= " subject like 'aa%' or ";
$sql .= " subject like 'college foot%' or ";
$sql .= " subject like 'online dating%' or ";

$sql .= " comment like '%webhost-20.info%' or ";
$sql .= " comment like '%beardless.org%' or ";
$sql .= " comment like '%bathed.org%' or ";
$sql .= " comment like '%adultfriendfinder%' or ";
$sql .= " comment like '%amateurpages.com%' or ";

$sql .= " comment like '%poker%' or ";
$sql .= " subject like '%poker%' or ";

$sql .= " comment like '%yu7a.com%' or ";
$sql .= " subject like '%yu7a.com%' or ";

$sql .= " comment like '%/~ezekiel_25%' or ";

$sql .= " comment like '%background-check-company.com%' or ";
$sql .= " subject like '%background-check-company.com%' or ";

$sql .= " comment like '%lkj7.us%' or ";
$sql .= " subject like '%lkj7.us%' or ";

$sql .= " comment like '%ty2j.com%' or ";
$sql .= " subject like '%ty2j.com%' or ";

$sql .= " comment like '%Credit Fcra Free%' or ";
$sql .= " subject like '%Credit Fcra Free%' or ";

$sql .= " comment like '%ght1.us%' or ";
$sql .= " subject like '%ght1.us%' or ";

$sql .= " comment like '%lonazepam%' or ";
$sql .= " subject like '%lonazepam%' or ";

$sql .= " comment like '%yigan999.com%' or ";
$sql .= " subject like '%yigan999.com%' or ";

$sql .= " comment like '%bxpost.com%' or ";
$sql .= " subject like '%bxpost.com%' or ";

$sql .= " comment like '%online-community-college.com%' or ";
$sql .= " subject like '%online-community-college.com%' or ";

$sql .= " comment like '%buy-cheap-pharmacy.com%' or ";
$sql .= " subject like '%buy-cheap-pharmacy.com%' or ";

$sql .= " comment like '%phedrine%' or ";
$sql .= " subject like '%phedrine%' or ";

$sql .= " comment like '%sex-pugv%' or ";
$sql .= " subject like '%sex-pugv%' or ";

$sql .= " comment like '%college-online%' or ";
$sql .= " subject like '%college-online%' or ";

$sql .= " comment like '%bad credit home loan %' or ";
$sql .= " subject like '%bad credit home loan %' or ";

$sql .= " comment like '%theguestbook.com%' or ";
$sql .= " subject like '%theguestbook.com%' or ";

$sql .= " comment like '%5e4b5a4%' or ";
$sql .= " subject like '%5e4b5a4%' or ";

$sql .= " comment like '%20six.co.uk%' or ";
$sql .= " subject like '%20six.co.uk%' or ";

$sql .= " comment like '%clickhere2.net%' or ";
$sql .= " subject like '%clickhere2.net%' or ";

$sql .= " comment like '%bpeoplesearch%' or ";
$sql .= " subject like '%bpeoplesearch%' or ";

$sql .= " comment like '%Lora Pamell%' or ";
$sql .= " comment like '%Lora Pamell%' or ";

$sql .= " comment like '%ultram%' or ";
$sql .= " comment like '%ultram%' or ";

$sql .= " comment like '%valium%' or ";
$sql .= " comment like '%valium%' or ";

$sql .= " comment like '%buy%ambien%' or ";
$sql .= " comment like '%buy%ambien%' or ";

$sql .= " comment like '%psoriasis%' or ";
$sql .= " comment like '%psoriasis%' or ";

$sql .= " comment like '%diazepam%' or ";
$sql .= " comment like '%diazepam%' or ";

$sql .= " comment like '%vioxx%' or ";
$sql .= " comment like '%vioxx%' or ";

$sql .= " comment like '%testcomment%' or ";
$sql .= " comment like '%testcomment%' or ";

$sql .= " subject like '%dir.web-marketings.com%' or ";
$sql .= " comment like '%dir.web-marketings.com%' or ";

$sql .= " subject like '%altshopcomplex.com%' or ";
$sql .= " comment like '%altshopcomplex.com%' or ";

$sql .= " subject like '%forex trading%' or ";
$sql .= " comment like '%forex trading%' or ";

$sql .= " subject like '%bielawa.pl%' or ";
$sql .= " comment like '%bielawa.pl%' or ";

$sql .= " subject like '%suwalki.pl%' or ";
$sql .= " comment like '%suwalki.pl%' or ";

$sql .= " subject like '%dlugoleka.pl%' or ";
$sql .= " comment like '%dlugoleka.pl%' or ";

$sql .= " subject like '%xxx-porn%' or ";
$sql .= " comment like '%xxx-porn%' or ";

$sql .= " subject like '%anal291.com%' or ";
$sql .= " comment like '%anal291.com%' or ";

$sql .= " subject like '%bang381.com%' or ";
$sql .= " comment like '%bang381.com%' or ";

$sql .= " subject like '%gblessons.com%' or ";
$sql .= " comment like '%gblessons.com%' or ";

$sql .= " subject like '%puszyste%' or ";
$sql .= " comment like '%puszyste%' or ";

$sql .= " subject like '%szczytno.pl%' or ";
$sql .= " comment like '%szczytno.pl%' or ";

$sql .= " subject like '%.1o1.pl%' or ";
$sql .= " comment like '%.1o1.pl%' or ";

$sql .= " subject like '%zgorzelec.pl%' or ";
$sql .= " comment like '%zgorzelec.pl%' or ";

$sql .= " subject like '%storefrontlive.net%' or ";
$sql .= " comment like '%storefrontlive.net%' or ";

$sql .= " subject like '%porn-ugh.com%' or ";
$sql .= " comment like '%porn-ugh.com%' or ";

$sql .= " subject like '%8532a.com%' or ";
$sql .= " comment like '%8532a.com%' or ";

$sql .= " subject like '%jordan shoes%' or ";
$sql .= " comment like '%jordan shoes%' or ";

$sql .= " subject like '%sonicpayday%' or ";
$sql .= " comment like '%sonicpayday%' or ";

$sql .= " subject like '%http://%ringtone%' or ";
$sql .= " comment like '%http://%ringtone%' or ";

$sql .= " subject like '%satellite tv%' or ";
$sql .= " comment like '%satellite tv%' or ";

$sql .= " subject like '%dish-network%' or ";
$sql .= " comment like '%dish-network%' or ";

$sql .= " subject like '%nude+amateurs%' or ";
$sql .= " comment like '%nude+amateurs%' or ";

$sql .= " subject like '%pockercash.com%' or ";
$sql .= " comment like '%pockercash.com%' or ";

$sql .= " subject like '%casino%' or ";
$sql .= " comment like '%casino%' or ";

$sql .= " subject like '%emistry.com%' or ";
$sql .= " comment like '%emistry.com%' or ";

$sql .= " subject like '%united%cash%' or ";
$sql .= " comment like '%united%cash%' or ";

$sql .= " subject like '%cash loan%' or ";
$sql .= " comment like '%cash loan%' or ";

$sql .= " subject like '%bbcart.com%' or ";
$sql .= " comment like '%bbcart.com%' or ";

$sql .= " subject like '%*-=*=*%' or ";
$sql .= " comment like '%*-=*=*%' or ";

$sql .= " subject like '%online pharmacy%' or ";
$sql .= " comment like '%online pharmacy%' or ";

$sql .= " subject like '%discount pharmacy%' or ";
$sql .= " comment like '%discount pharmacy%' or ";

$sql .= " subject like '%celebrex%' or ";
$sql .= " comment like '%celebrex%' or ";

$sql .= " subject like '%paxil%' or ";
$sql .= " comment like '%paxil%' or ";

$sql .= " subject like '%adipex%' or ";
$sql .= " comment like '%adipex%' or ";

$sql .= " subject like '%hardcore+sex%' or ";
$sql .= " comment like '%hardcore+sex%' or ";

$sql .= " subject like '%cialis%' or ";
$sql .= " comment like '%cialis%' or ";

$sql .= " subject like '%viagra%' or ";
$sql .= " comment like '%viagra%' or ";

$sql .= " subject like '%levitra%' or ";
$sql .= " comment like '%levitra%' or ";

$sql .= " subject like '%phentermine%' or ";
$sql .= " comment like '%phentermine%' or ";

$sql .= " subject like '%meridia%' or ";
$sql .= " comment like '%meridia%' or ";

$sql .= " subject like '%xenical%' or ";
$sql .= " comment like '%xenical%' or ";

$sql .= " subject like '%propecia%' or ";
$sql .= " comment like '%propecia%' or ";

$sql .= " subject like '%http://827.com%' or ";
$sql .= " comment like '%http://827.com%' or ";

$sql .= " subject like '%sports betting%' or ";
$sql .= " comment like '%sports betting%' or ";

$sql .= " comment like '%Yellow Monkey%' or ";
$sql .= " subject like '%Yellow Monkey%' or ";

$sql .= " comment like '%www.united-cash.com%' or ";
$sql .= " subject like '%www.united-cash.com%' or ";

$sql .= " comment like '%holdem%' or ";
$sql .= " subject like '%holdem%' or ";

$sql .= " comment like '%exas%hold%em%' or ";
$sql .= " subject like '%exas%hold%em%' or ";

$sql .= " comment like '%nude%cam%' or ";
$sql .= " subject like '%nude%cam%'";

$result = db_query($sql);

while($comment = db_fetch_object($result)) {
print $comment->cid."
";
_comment_delete_thread($comment);
}