sessions
2 years ago
create_city.txt
2 years ago
create_country.txt
2 years ago
create_referrer.txt
3 years ago
create_resource.txt
3 years ago
create_view.txt
3 years ago
get_campaign.txt
3 years ago
get_campaigns.txt
2 years ago
get_cities.txt
2 years ago
get_city.txt
2 years ago
get_countries.txt
2 years ago
get_country.txt
2 years ago
get_current_traffic.txt
2 years ago
get_device_browsers.txt
2 years ago
get_device_operating_systems.txt
2 years ago
get_device_types.txt
2 years ago
get_referrer.txt
3 years ago
get_referrers.txt
2 years ago
get_resource.txt
3 years ago
get_resources.txt
2 years ago
get_visitors_by_minute_interval.txt
3 years ago
get_visitors_by_ten_second_interval.txt
3 years ago
get_current_traffic.txt
10 lines
| 1 | SELECT COUNT(DISTINCT (sessions.visitor_id)) AS visitor_count, |
| 2 | COUNT(DISTINCT (views.resource_id)) AS page_count, |
| 3 | COUNT(DISTINCT (sessions.referrer_id)) AS referrer_count, |
| 4 | COUNT(DISTINCT (sessions.country_id)) AS country_count, |
| 5 | COUNT(DISTINCT (sessions.campaign_id)) AS campaign_count, |
| 6 | COUNT(*) AS view_count |
| 7 | FROM wp_independent_analytics_views AS views |
| 8 | LEFT JOIN wp_independent_analytics_sessions AS sessions |
| 9 | ON views.session_id = sessions.session_id |
| 10 | WHERE viewed_at BETWEEN :start AND :end |