Id: 5170860
    User: XXXXXX
    Host: XXXXXX
      db: XXXXXX
 Command: Query
    Time: 208
   State: Queried about 60710000 rows
    Info: SELECT
                COUNT(log_inner.visit_last_action_time)
            FROM

        (

            SELECT
                log_visit.visit_last_action_time
            FROM
                piwik_log_visit AS log_visit
                LEFT JOIN piwik_log_link_visit_action AS log_link_visit_action ON log_link_visit_action.idvisit = log_visit.idvisit
            WHERE
                ( log_visit.idsite in ('2') AND log_visit.visit_last_action_time >= '2015-10-20 08:50:48' )
                AND
                ( log_link_visit_action.custom_var_v4 = 'XXXXXX' )
            GROUP BY
                log_visit.idvisit
            ORDER BY
                NULL
        ) AS log_inner

SELECT count(distinct log_link_visit_action.idvisit), count(distinct log_link_visit_action.idlink_va) 

FROM piwik_log_visit AS log_visit 

LEFT JOIN piwik_log_link_visit_action AS log_link_visit_action ON log_link_visit_action.idvisit = log_visit.idvisit 

WHERE (log_link_visit_action.idsite = 2 
AND log_link_visit_action.server_time >= '2015-10-20 08:50:48') 
AND log_link_visit_action.custom_var_v4 = 'XXXXXX';