FireStats error processing pending hits: 数据库错误:Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (gbk_chinese_ci,IMPLICIT) for operation 'regexp'

MySQL Version: 5.1.48-log
SQL Query:
SELECT useragent FROM wp_firestats_useragent_classes right join (SELECT 'curl/7.29.0' AS useragent UNION SELECT 'Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)' AS useragent UNION SELECT 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.81 YisouSpider/5.0 Safari/537.36' AS useragent UNION SELECT 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.95 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)' AS useragent UNION SELECT 'Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; Bytespider; https://zhanzhang.toutiao.com/)' AS useragent UNION SELECT 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 SP-engine/2.28.0 main%2F1.0 baiduboxapp/12.10.5.10 (Baidu; P2 13.6.1) NABar/1.0 themeUA=Theme/default' AS useragent UNION SELECT 'Mozilla/5.0 (Linux;u;Android 4.2.2;zh-cn;) AppleWebKit/534.46 (KHTML,like Gecko) Version/5.1 Mobile Safari/10600.6.3 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)' AS useragent UNION SELECT 'Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html)' AS useragent UNION SELECT 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.107 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)' AS useragent UNION SELECT 'Mozilla/5.0 (Linux; Android 10; SM-A315G) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.105 Mobile Safari/537.36' AS useragent UNION SELECT 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36,gzip(gfe)' AS useragent UNION SELECT 'Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://aspiegel.com/petalbot)' AS useragent UNION SELECT 'YisouSpider' AS useragent UNION SELECT 'curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.14.0.0 zlib/1.2.3 libidn/1.18 libssh2/1.4.2' AS useragent UNION SELECT 'ZoominfoBot (zoominfobot at zoominfo dot com)' AS useragent UNION SELECT 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.192 Safari/537.36' AS useragent UNION SELECT 'Mozilla/5.0 (Linux; Android 6.0; HUAWEI MLA-AL10 Build/HUAWEIMLA-AL10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/76.0.3809.89 Mobile Safari/537.36 T7/12.11 SP-engine/2.29.0 baiduboxapp/12.11.0.10 (Baidu; P1 6.0) NABar/1.0' AS useragent UNION SELECT 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.1 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot)' AS useragent UNION SELECT 'ICC-Crawler/2.0 (Mozilla-compatible; ; http://ucri.nict.go.jp/en/icccrawler.html)' AS useragent UNION SELECT 'Mozilla/5.0 (compatible; coccocbot-web/1.0; +http://help.coccoc.com/searchengine)' AS useragent UNION SELECT 'Mozilla/5.0 (compatible; MixrankBot; crawler@mixrank.com)' AS useragent UNION SELECT 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)' AS useragent UNION SELECT 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.102 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)' AS useragent UNION SELECT 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/7.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; InfoPath.1; InfoPath.3; .NET CLR 1.1.4322)' AS useragent UNION SELECT 'Mozilla/5.0 (compatible; Barkrowler/0.9; +https://babbar.tech/crawler)' AS useragent UNION SELECT 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 10.0; WOW64; Trident/7.0; .NET4.0C; .NET4.0E; .NET CLR 2.0.50727; .NET CLR 3.0.30729; .NET CLR 3.5.30729; InfoPath.3; Zoom 3.6.0; ms-office)' AS useragent UNION SELECT 'Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)' AS useragent UNION SELECT 'Mozilla/5.0 (compatible; MegaIndex.ru/2.0; +http://megaindex.com/crawler)' AS useragent) urls ON useragent REGEXP wildcard GROUP BY useragent HAVING count(wildcard) > 0
chrisfang的Excel大全

在线课程

由我本人主导开发设计的在线课程均独家发布在『网易云课堂』平台上。
目前共有两门课程,六千多人付费订阅。

课程一:【和方骥一起学Excel】

【适合人群】
有Excel使用需求和应用场景的职场人士,特别适合从事数据统计分析、项目管理、财务和销售管理、人事管理、办公文秘、审计等相关工作的人士。课程难度循序渐进,适合零起点入门也适用于需要进阶提高的人群。配合图书《Excel这么用就对了》一起学习的话效果更佳。

【内容简介】
以职场常见需求为目标,提供各种Excel的解决方案,包含排序、筛选、填充、查询、函数公式、透视统计、图表等关键必备功能的介绍。

【主要特色】
1.以职场实用场景来设计教学案例
2.专业视角下系统化的组织知识点
3.课程难度循序渐进学习上无压力
4.专设学员群由专家讲师全程辅导
5.学员群中每周布置习题讲解答疑
6.学习技能的同时也培养学习方法

课程二:【Excel VBA数据处理实战】

【适合人群】
需要对数据进行大批量处理,希望以自动化方式来高效完成重复工作的人群。特别适合从事数据统计分析相关工作的人士。
本课程以代码编程为主要内容,以零基础方式教学,适合没有任何编程基础的人士。有少量编程相关经验的人群学习效果更佳。

【内容简介】
用Excel VBA编程来实现数据处理工作的自动化和高效化,其中包含数据清理、自动抽样、多表合并、结构转换、数据库的连接和读写查询、网页数据的抓取等相关介绍。

【主要特色】
1.以数据处理分析工作流程为主线
2.提供多种解决方案拓展学习思路
3.讲授技巧方法同时注重原理详解
4.专设学员群由专家讲师提供答疑
5.零基础无门槛趣味性的教学方式

发表评论

邮箱地址不会被公开。 必填项已用*标注

您可以使用这些HTML标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>