city_statistics.txt
3 years ago
city_statistics_with_woocommerce.txt
3 years ago
country_statistics.txt
3 years ago
create_referrer.txt
3 years ago
create_resource.txt
3 years ago
create_session.txt
3 years ago
create_view.txt
3 years ago
create_visitor.txt
3 years ago
get_campaign.txt
3 years ago
get_campaigns.txt
3 years ago
get_campaigns_with_woocommerce.txt
3 years ago
get_current_session.txt
3 years ago
get_current_traffic.txt
3 years ago
get_geos.txt
3 years ago
get_geos_with_woocommerce.txt
3 years ago
get_referrer.txt
3 years ago
get_referrers.txt
3 years ago
get_referrers_with_woocommerce.txt
3 years ago
get_resource.txt
3 years ago
get_resources.txt
3 years ago
get_visitors_by_minute_interval.txt
3 years ago
get_visitors_by_ten_second_interval.txt
3 years ago
get_visitors_by_ten_second_interval.txt
8 lines
| 1 | SELECT COUNT(DISTINCT (sessions.visitor_id)) AS visitors, |
| 2 | COUNT(*) as views, |
| 3 | ABS(CEILING(TIMESTAMPDIFF(SECOND, :end, views.viewed_at) / 10)) AS interval_ago |
| 4 | FROM wp_independent_analytics_views as views |
| 5 | LEFT JOIN wp_independent_analytics_sessions AS sessions |
| 6 | ON views.session_id = sessions.session_id |
| 7 | WHERE viewed_at BETWEEN :start AND :end |
| 8 | GROUP BY interval_ago |