TYPE=VIEW
query=select date_format(convert_tz(`wp_wsm_uniqueVisitors`.`firstVisitTime`,\'+00:00\',\'+00:00\'),\'%Y-%m\') AS `recordMonth`,count(`wp_wsm_uniqueVisitors`.`visitorId`) AS `visitors` from `skills_wp`.`wp_wsm_uniqueVisitors` group by date_format(convert_tz(`wp_wsm_uniqueVisitors`.`firstVisitTime`,\'+00:00\',\'+00:00\'),\'%Y-%m\')
md5=7d733ed8662d2f37daf8e553bfc0617c
updatable=0
algorithm=0
definer_user=skills_wp
definer_host=localhost
suid=1
with_check_option=0
timestamp=2024-12-11 02:45:23
create-version=2
source=select date_format(convert_tz(`wp_wsm_uniqueVisitors`.`firstVisitTime`,\'+00:00\',\'+00:00\'),\'%Y-%m\') AS `recordMonth`,count(`wp_wsm_uniqueVisitors`.`visitorId`) AS `visitors` from `wp_wsm_uniqueVisitors` group by date_format(convert_tz(`wp_wsm_uniqueVisitors`.`firstVisitTime`,\'+00:00\',\'+00:00\'),\'%Y-%m\')
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_unicode_ci
view_body_utf8=select date_format(convert_tz(`wp_wsm_uniqueVisitors`.`firstVisitTime`,\'+00:00\',\'+00:00\'),\'%Y-%m\') AS `recordMonth`,count(`wp_wsm_uniqueVisitors`.`visitorId`) AS `visitors` from `skills_wp`.`wp_wsm_uniqueVisitors` group by date_format(convert_tz(`wp_wsm_uniqueVisitors`.`firstVisitTime`,\'+00:00\',\'+00:00\'),\'%Y-%m\')
mariadb-version=100244