WordPress-Datenbank-Fehler: [Table 'ahelmke.wp_wsm_logUniqueVisit' doesn't exist]
CREATE OR REPLACE VIEW wp_wsm_monthWiseVisitors AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+02:00'),'%Y-%m') as recordMonth, COUNT(*) as visitors FROM wp_wsm_logUniqueVisit GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+02:00'),'%Y-%m')

WordPress-Datenbank-Fehler: [Table 'ahelmke.wp_wsm_pageViews' doesn't exist]
CREATE OR REPLACE VIEW wp_wsm_monthWisePageViews AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+02:00'),'%Y-%m') as recordMonth, SUM(totalViews) as pageViews FROM wp_wsm_pageViews GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+02:00'),'%Y-%m')

WordPress-Datenbank-Fehler: [Table 'ahelmke.wp_wsm_uniqueVisitors' doesn't exist]
CREATE OR REPLACE VIEW wp_wsm_monthWiseFirstVisitors AS SELECT DATE_FORMAT(CONVERT_TZ(firstVisitTime,'+00:00','+02:00'),'%Y-%m') as recordMonth, COUNT(visitorId) as visitors FROM wp_wsm_uniqueVisitors GROUP BY DATE_FORMAT(CONVERT_TZ(firstVisitTime,'+00:00','+02:00'),'%Y-%m')

WordPress-Datenbank-Fehler: [Table 'ahelmke.wp_wsm_bounceVisits' doesn't exist]
CREATE OR REPLACE VIEW wp_wsm_monthWiseBounce AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+02:00'),'%Y-%m') as recordMonth, COUNT(*) as bounce FROM wp_wsm_bounceVisits GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+02:00'),'%Y-%m-')

WordPress-Datenbank-Fehler: [Table 'ahelmke.wp_wsm_monthWiseBounce' doesn't exist]
CREATE OR REPLACE VIEW wp_wsm_monthWiseBounceRate AS SELECT mwb.recordMonth, mwb.bounce, mwp.pageViews, mwv.visitors, ((mwb.bounce/mwp.pageViews)*100) AS bRatePageViews, ((mwb.bounce/mwv.visitors)*100) AS bRateVisitors FROM wp_wsm_monthWiseBounce mwb LEFT JOIN wp_wsm_monthWisePageViews mwp ON mwb.recordMonth=mwp.recordMonth LEFT JOIN wp_wsm_monthWiseVisitors mwv ON mwb.recordMonth=mwv.recordMonth

1.0Webseite von Prof. Dr. Andreas Helmkehttp://andreas-helmke.de2017rich600338<blockquote class="wp-embedded-content"><a href="http://andreas-helmke.de/download/2017-2/">2017</a></blockquote> <script type='text/javascript'> <!--//--><![CDATA[//><!-- !function(d,l){"use strict";var e=!1,n=!1;if(l.querySelector)if(d.addEventListener)e=!0;if(d.wp=d.wp||{},!d.wp.receiveEmbedMessage)if(d.wp.receiveEmbedMessage=function(e){var t=e.data;if(t)if(t.secret||t.message||t.value)if(!/[^a-zA-Z0-9]/.test(t.secret)){for(var r,i,a,s=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),n=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),o=new RegExp("^https?:$","i"),c=0;c<n.length;c++)n[c].style.display="none";for(c=0;c<s.length;c++)if(r=s[c],e.source===r.contentWindow){if(r.removeAttribute("style"),"height"===t.message){if(1e3<(a=parseInt(t.value,10)))a=1e3;else if(~~a<200)a=200;r.height=a}if("link"===t.message)if(i=l.createElement("a"),a=l.createElement("a"),i.href=r.getAttribute("src"),a.href=t.value,o.test(a.protocol))if(a.host===i.host)if(l.activeElement===r)d.top.location.href=t.value}}},e)d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",t,!1),d.addEventListener("load",t,!1);function t(){if(!n){n=!0;for(var e,t,r=-1!==navigator.appVersion.indexOf("MSIE 10"),i=!!navigator.userAgent.match(/Trident.*rv:11\./),a=l.querySelectorAll("iframe.wp-embedded-content"),s=0;s<a.length;s++){if(!(e=a[s]).getAttribute("data-secret"))t=Math.random().toString(36).substr(2,10),e.src+="#?secret="+t,e.setAttribute("data-secret",t);if(r||i)(t=e.cloneNode(!0)).removeAttribute("security"),e.parentNode.replaceChild(t,e)}}}}(window,document); //--><!]]> </script><iframe sandbox="allow-scripts" security="restricted" src="http://andreas-helmke.de/download/2017-2/embed/" width="600" height="338" title="„2017“ — Webseite von Prof. Dr. Andreas Helmke" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe>