DELETE FROM `log_2011_a` WHERE 
browser LIKE '%bot%' OR
browser LIKE '%crawl%' OR
browser LIKE '%spider%' OR
browser LIKE '%googlebot%' OR 
browser LIKE '%msnbot%' OR 
browser LIKE '%ia_archiver%' OR 
browser LIKE '%miragorobot%' OR 
browser LIKE '%findlinks%' OR 
browser LIKE '%mail.ru%' OR 
browser LIKE '%Yahoo! Slurp%' OR 
browser LIKE '%SiteBot%' OR 
browser LIKE '%bingbot%' OR 
browser LIKE '%Baiduspider%' OR 
browser LIKE '%MJ12bot%' OR 
browser LIKE '%Twiceler%' OR 
browser LIKE '%Exabot%' OR 
browser LIKE '%Purebot%' OR 
browser LIKE '%Yeti%' OR 
browser LIKE '%scoutjet%' OR 
browser LIKE '%DotBot%' OR 
browser LIKE '%YandexBot%' OR 
browser LIKE '%Ezooms%' OR 
browser LIKE '%discobot%' OR 
browser LIKE '%SISTRIX Crawler%' OR 
browser LIKE '%suggybot%' OR 
browser LIKE '%TurnitinBot%' OR 
browser LIKE '%UnisterBot%' OR
browser LIKE '%AhrefsBot%' OR
browser LIKE '%yacybot%'OR
browser LIKE '%Linguee Bot%' OR
browser LIKE '%L.webis%' OR
browser LIKE '%Nutch%' OR
browser LIKE 'MyApp' OR
browser LIKE '%SWEBot%' OR
browser LIKE '%WBSearchBot%' OR
browser LIKE '%magpie-crawler%' OR
browser LIKE '%Tbot%' OR
browser LIKE '%SEOkicks-Robot%' OR
browser LIKE 'Feedfetcher-Google%' OR
browser LIKE 'BUbiNG%'