SELECT DISTINCT count(*) AS count,ip,keywords,pagefrom,pageurl FROM table
WHERE (
pagefrom like "%baidu.com%"
AND keywords !=''
AND pageurl like "%/2011%"
AND pageurl not LIKE '%ozc=2%'
and pageurl not LIKE '%bdlx%'
and pageurl not LIKE '%bwlx%'
and pageurl not LIKE '%wdlx%'
and pageurl not LIKE '%360lx%'
and pageurl not LIKE '%solx%'
and pageurl not LIKE '%swlx%'
and pageurl not LIKE '%smlx%'
and pagefrom not LIKE '%ozc=2%'
and pagefrom not LIKE '%bdlx%'
and pagefrom not LIKE '%bwlx%'
and pagefrom not LIKE '%wdlx%'
and pagefrom not LIKE '%360lx%'
and pagefrom not LIKE '%solx%'
and pagefrom not LIKE '%swlx%'
and pagefrom not LIKE '%smlx%')
GROUP BY keywords
ORDER BY count DESC;