PluginProbe ʕ •ᴥ•ʔ
Independent Analytics – WordPress Analytics Plugin / 1.18
Independent Analytics – WordPress Analytics Plugin v1.18
2.15.5 2.15.4 2.15.3 2.15.2 2.15.1 2.15.0 2.14.10 trunk 1.1 1.10 1.10.1 1.11 1.12 1.13 1.14 1.15 1.16 1.17 1.17.1 1.17.2 1.17.3 1.17.4 1.18 1.18.1 1.19.0 1.19.1 1.2 1.20.0 1.21.0 1.22.0 1.22.1 1.23.0 1.23.1 1.24.0 1.24.1 1.25.0 1.25.1 1.26.0 1.27.0 1.28.0 1.28.1 1.28.2 1.28.3 1.29.0 1.3 1.30.0 1.30.1 1.4 1.5 1.6 1.7 1.8 1.9 2.0.0 2.0.1 2.1.4 2.1.5 2.1.6 2.10.0 2.10.1 2.10.2 2.10.3 2.10.4 2.11.0 2.11.1 2.11.10 2.11.2 2.11.3 2.11.4 2.11.5 2.11.6 2.11.7 2.11.8 2.11.9 2.12.0 2.12.1 2.12.2 2.13.1 2.13.2 2.13.5 2.13.6 2.14.0 2.14.1 2.14.2 2.14.4 2.14.6 2.14.7 2.14.8 2.14.9 2.2.0 2.2.1 2.3.1 2.3.2 2.4.2 2.4.3 2.5.0 2.5.1 2.6.0 2.6.1 2.6.2 2.6.3 2.6.4 2.7.0 2.7.1 2.7.2 2.7.3 2.8.2 2.8.3 2.8.4 2.8.5 2.8.6 2.8.7 2.8.8 2.8.9 2.9.2 2.9.3 2.9.4 2.9.5 2.9.6 2.9.7
independent-analytics / IAWP / sql / country_statistics.txt
independent-analytics / IAWP / sql Last commit date
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
country_statistics.txt
33 lines
1 SELECT *
2 FROM (SELECT visitors.country_code,
3 visitors.country,
4 visitors.continent,
5 COUNT(CASE WHEN views.viewed_at BETWEEN :start AND :end THEN 1 END) AS views,
6 COUNT(DISTINCT (CASE
7 WHEN views.viewed_at BETWEEN :start AND :end
8 THEN sessions.visitor_id END)) AS visitors,
9 COUNT(CASE
10 WHEN views.viewed_at BETWEEN :prev_start AND :prev_end
11 THEN 1 END) AS prev_period_views,
12 COUNT(DISTINCT (CASE
13 WHEN views.viewed_at BETWEEN :prev_start AND :prev_end
14 THEN sessions.visitor_id END)) AS prev_period_visitors,
15 '' as visitor_ids,
16 0 AS wc_orders,
17 0 AS wc_gross_sales,
18 0 AS wc_refunds,
19 0 AS wc_refunded_amount
20 FROM wp_independent_analytics_views AS views
21 LEFT JOIN wp_independent_analytics_sessions AS sessions
22 on views.session_id = sessions.session_id
23 LEFT JOIN wp_independent_analytics_visitors AS visitors
24 ON sessions.visitor_id = visitors.visitor_id
25 WHERE country_code IS NOT NULL
26 AND viewed_at BETWEEN :prev_start AND :end
27 GROUP BY continent,
28 country,
29 country_code
30 ORDER BY visitors DESC,
31 views DESC,
32 country) subquery
33 WHERE views > 0