Skip to content

Instantly share code, notes, and snippets.

/gist:9170625

Created February 23, 2014 12:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/9170625 to your computer and use it in GitHub Desktop.
Save anonymous/9170625 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
MySQL [piwik]> SELECT log_visit.custom_var_k2 AS `custom_var_k2`, log_visit.custom_var_v2 AS `custom_var_v2`, count(distinct log_visit.idvisitor) AS `1`, count(*) AS `2`, sum(log_visit.visit_total_actions) AS `3`, max(log_visit.visit_total_actions) AS `4`, sum(log_visit.visit_total_time) AS `5`, sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`, sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7` FROM log_visit AS log_visit USE INDEX (index_idsite_datetime) WHERE log_visit.idsite = '14' AND log_visit.visit_last_action_time >= '2014-02-12 23:00:00' AND log_visit.visit_last_action_time <= '2014-02-13 22:59:59' AND log_visit.custom_var_k2 != '' GROUP BY log_visit.custom_var_k2, log_visit.custom_var_v2;
Empty set (2.19 sec)
MySQL [piwik]> SELECT log_visit.custom_var_k2 AS `custom_var_k2`, log_visit.custom_var_v2 AS `custom_var_v2`, count(distinct log_visit.idvisitor) AS `1`, count(*) AS `2`, sum(log_visit.visit_total_actions) AS `3`, max(log_visit.visit_total_actions) AS `4`, sum(log_visit.visit_total_time) AS `5`, sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`, sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7` FROM log_visit AS log_visit USE INDEX (index_idsite_datetime) WHERE log_visit.idsite = '14' AND log_visit.visit_last_action_time >= '2014-02-12 23:00:00' AND log_visit.visit_last_action_time <= '2014-02-13 22:59:59' AND log_visit.custom_var_k2 != '' GROUP BY log_visit.custom_var_k2, log_visit.custom_var_v2;
Empty set (2.17 sec)
MySQL [piwik]> SELECT log_visit.custom_var_k2 AS `custom_var_k2`, log_visit.custom_var_v2 AS `custom_var_v2`, count(distinct log_visit.idvisitor) AS `1`, count(*) AS `2`, sum(log_visit.visit_total_actions) AS `3`, max(log_visit.visit_total_actions) AS `4`, sum(log_visit.visit_total_time) AS `5`, sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`, sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7` FROM log_visit AS log_visit WHERE log_visit.idsite = '14' AND log_visit.visit_last_action_time >= '2014-02-12 23:00:00' AND log_visit.visit_last_action_time <= '2014-02-13 22:59:59' AND log_visit.custom_var_k2 != '' GROUP BY log_visit.custom_var_k2, log_visit.custom_var_v2;
Empty set (2.89 sec)
MySQL [piwik]> SELECT log_visit.custom_var_k2 AS `custom_var_k2`, log_visit.custom_var_v2 AS `custom_var_v2`, count(distinct log_visit.idvisitor) AS `1`, count(*) AS `2`, sum(log_visit.visit_total_actions) AS `3`, max(log_visit.visit_total_actions) AS `4`, sum(log_visit.visit_total_time) AS `5`, sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`, sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7` FROM log_visit AS log_visit WHERE log_visit.idsite = '14' AND log_visit.visit_last_action_time >= '2014-02-12 23:00:00' AND log_visit.visit_last_action_time <= '2014-02-13 22:59:59' AND log_visit.custom_var_k2 != '' GROUP BY log_visit.custom_var_k2, log_visit.custom_var_v2;
Empty set (2.80 sec)
MySQL [piwik]> SELECT log_visit.custom_var_k2 AS `custom_var_k2`, log_visit.custom_var_v2 AS `custom_var_v2`, count(distinct log_visit.idvisitor) AS `1`, count(*) AS `2`, sum(log_visit.visit_total_actions) AS `3`, max(log_visit.visit_total_actions) AS `4`, sum(log_visit.visit_total_time) AS `5`, sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`, sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7` FROM log_visit AS log_visit USE INDEX (index_idsite_datetime) WHERE log_visit.idsite = '14' AND log_visit.visit_last_action_time >= '2014-02-12 23:00:00' AND log_visit.visit_last_action_time <= '2014-02-13 22:59:59' AND log_visit.custom_var_k2 != '' GROUP BY log_visit.custom_var_k2, log_visit.custom_var_v2;
Empty set (2.12 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment