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版

2011-08-21
作者: chrisfang | 分类: Excel应用 | 阅读: 4,781 次浏览 | Tags:
声明: 本站文章均属原创,转载时请标明出处

九型人格(Enneagram)

又名性格型态学、九种性格。是婴儿时期人身上的九种气质,包括活跃程度;规律性;主动性;适应性;感兴趣的范围;反应的强度;心景的素质;分心程度;专注力范围/持久性。它是一个近年来倍受美国斯坦福等国际著名大学MBA学员推崇并成为现今最热门的课程之一,近十几年来已风行欧美学术界及工商界。全球500强企业的管理阶层均有研习九型性格,并以此培训员工,建立团队,提高执行力。

【测试问卷说明】

这两份测评问卷是基于Enneagram的性格指标,使用Excel设计而成的,主要用于帮助你有效地掌握你个人的行为习惯。在Excel中选择选项后即刻可以得到分析结果,无需联网。Excel中不包含宏代码,仅使用了控件和图表。

如果您在打开Excel后发现无法点击选中选项控件,原因可能是因为您正处于“设计模式”下,可以点击下图中三角尺样式的图标按钮退出设计模式恢复正常使用。

【九型人格测试】Excel版

【评估方法说明】

在此测试中所回答的答案没有正确与错误之分,它仅是反映你自己的个性和你的世界观。

其中在144题版中,每一道题都包含了2种状况可供选择,并依据你平时的一些行为习惯选择其中一种状况。可能会遇到2种状况都不适用于你,或2种状况都适用于你,无论哪种情况,请选择其中你最倾向的答案。两种选择都将影响您的分析结果。

【九型人格测试】Excel版

而在180题版中,每一题相对独立,如果题目的描述是您比较倾向的状况,则可以勾选,否则可以留空。所有被勾选的选项将计入最终的分析结果,未勾选的选项则不影响最终结果。因此,为了保证您的测试足够准确,务必完成尽可能多的测试题目,留空的选项应是您主观上放弃勾选而非未完成的题目。

【九型人格测试】Excel版

【下载地址】

新浪微盘下载: http://vdisk.weibo.com/s/wFm2

http://vdisk.weibo.com/s/wEFl

新浪爱问下载:http://ishare.iask.sina.com.cn/f/18204633.html

http://ishare.iask.sina.com.cn/f/18204632.html

本地下载:Excel版九型人格测试180题 (1866)

Excel版九型人格测试144题 (3078)

一条评论

  1. 刘美说道:

    能告诉具体的做法么 想学习 谢谢

发表评论

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

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