SELECT
                s.*,
                ROUND(s.hit_count/s.host_count,2) as depth_count,
                (s.host_count-s.newvisitor_count) as existvisitor_count,
                ROUND(100*(s.newvisitor_count/s.host_count),2) as newvisitor_persent_count,
                ROUND(100*(s.host_count-s.newvisitor_count)/s.host_count,2) as existvisitor_persent_count,
                ROUND(100*(s.targetvisitor_count/s.visitor_count),2) as targetpersent_count
            FROM
            (
                SELECT
                    DATE(vs.session_start) as rep_date,
                    
                    WEEKDAY(vs.session_start) as wd,
                    SUM(vs.action_count) as hit_count,
                    COUNT(vs.id) as host_count,
                    COUNT(DISTINCT vs.id_visitor) as visitor_count,
                    SUM(IF(vs.action_count=1,1,0)) as 1pagevisitor_count,
                    SUM(IF(vs.action_count<>1,1,0)) as non1pagevisitor_count,
                    SUM(IF(vs.target=1,1,0)) as targetvisitor_count,
                    SUM(IF(vs.target=0,1,0)) as nontargetvisitor_count,
                    COUNT(DISTINCT vs.id_visitor) as newvisitor_count
                FROM s_arkabiz vs
                JOIN visitor v ON v.id=vs.id_visitor 
                WHERE
                    DATE(vs.session_start) = '2012-02-22'
                GROUP BY rep_date
            ) sSELECT
                s.*,
                ROUND(s.hit_count/s.host_count,2) as depth_count,
                (s.host_count-s.newvisitor_count) as existvisitor_count,
                ROUND(100*(s.newvisitor_count/s.host_count),2) as newvisitor_persent_count,
                ROUND(100*(s.host_count-s.newvisitor_count)/s.host_count,2) as existvisitor_persent_count,
                ROUND(100*(s.targetvisitor_count/s.visitor_count),2) as targetpersent_count
            FROM
            (
                SELECT
                    DATE(vs.session_start) as rep_date,
                    
                    WEEKDAY(vs.session_start) as wd,
                    SUM(vs.action_count) as hit_count,
                    COUNT(vs.id) as host_count,
                    COUNT(DISTINCT vs.id_visitor) as visitor_count,
                    SUM(IF(vs.action_count=1,1,0)) as 1pagevisitor_count,
                    SUM(IF(vs.action_count<>1,1,0)) as non1pagevisitor_count,
                    SUM(IF(vs.target=1,1,0)) as targetvisitor_count,
                    SUM(IF(vs.target=0,1,0)) as nontargetvisitor_count,
                    COUNT(DISTINCT vs.id_visitor) as newvisitor_count
                FROM s_arkabiz vs
                JOIN visitor v ON v.id=vs.id_visitor 
                WHERE
                    DATE(vs.session_start) = '2012-02-22'
                GROUP BY rep_date
            ) sSELECT
                s.*,
                ROUND(s.hit_count/s.host_count,2) as depth_count,
                (s.host_count-s.newvisitor_count) as existvisitor_count,
                ROUND(100*(s.newvisitor_count/s.host_count),2) as newvisitor_persent_count,
                ROUND(100*(s.host_count-s.newvisitor_count)/s.host_count,2) as existvisitor_persent_count,
                ROUND(100*(s.targetvisitor_count/s.visitor_count),2) as targetpersent_count
            FROM
            (
                SELECT
                    DATE(vs.session_start) as rep_date,
                    
                    WEEKDAY(vs.session_start) as wd,
                    SUM(vs.action_count) as hit_count,
                    COUNT(vs.id) as host_count,
                    COUNT(DISTINCT vs.id_visitor) as visitor_count,
                    SUM(IF(vs.action_count=1,1,0)) as 1pagevisitor_count,
                    SUM(IF(vs.action_count<>1,1,0)) as non1pagevisitor_count,
                    SUM(IF(vs.target=1,1,0)) as targetvisitor_count,
                    SUM(IF(vs.target=0,1,0)) as nontargetvisitor_count,
                    COUNT(DISTINCT vs.id_visitor) as newvisitor_count
                FROM s_arkabiz vs
                JOIN visitor v ON v.id=vs.id_visitor 
                WHERE
                    DATE(vs.session_start) = '2012-02-22'
                GROUP BY rep_date
            ) sSELECT
                s.*,
                ROUND(s.hit_count/s.host_count,2) as depth_count,
                (s.host_count-s.newvisitor_count) as existvisitor_count,
                ROUND(100*(s.newvisitor_count/s.host_count),2) as newvisitor_persent_count,
                ROUND(100*(s.host_count-s.newvisitor_count)/s.host_count,2) as existvisitor_persent_count,
                ROUND(100*(s.targetvisitor_count/s.visitor_count),2) as targetpersent_count
            FROM
            (
                SELECT
                    DATE(vs.session_start) as rep_date,
                    
                    WEEKDAY(vs.session_start) as wd,
                    SUM(vs.action_count) as hit_count,
                    COUNT(vs.id) as host_count,
                    COUNT(DISTINCT vs.id_visitor) as visitor_count,
                    SUM(IF(vs.action_count=1,1,0)) as 1pagevisitor_count,
                    SUM(IF(vs.action_count<>1,1,0)) as non1pagevisitor_count,
                    SUM(IF(vs.target=1,1,0)) as targetvisitor_count,
                    SUM(IF(vs.target=0,1,0)) as nontargetvisitor_count,
                    COUNT(DISTINCT vs.id_visitor) as newvisitor_count
                FROM s_arkabiz vs
                JOIN visitor v ON v.id=vs.id_visitor 
                WHERE
                    DATE(vs.session_start) = '2012-02-22'
                GROUP BY rep_date
            ) sSELECT
                s.*,
                ROUND(s.hit_count/s.host_count,2) as depth_count,
                (s.host_count-s.newvisitor_count) as existvisitor_count,
                ROUND(100*(s.newvisitor_count/s.host_count),2) as newvisitor_persent_count,
                ROUND(100*(s.host_count-s.newvisitor_count)/s.host_count,2) as existvisitor_persent_count,
                ROUND(100*(s.targetvisitor_count/s.visitor_count),2) as targetpersent_count
            FROM
            (
                SELECT
                    DATE(vs.session_start) as rep_date,
                    vs.id_referer as id1,WEEKDAY(vs.session_start) as id2,
                    WEEKDAY(vs.session_start) as wd,
                    SUM(vs.action_count) as hit_count,
                    COUNT(vs.id) as host_count,
                    COUNT(DISTINCT vs.id_visitor) as visitor_count,
                    SUM(IF(vs.action_count=1,1,0)) as 1pagevisitor_count,
                    SUM(IF(vs.action_count<>1,1,0)) as non1pagevisitor_count,
                    SUM(IF(vs.target=1,1,0)) as targetvisitor_count,
                    SUM(IF(vs.target=0,1,0)) as nontargetvisitor_count,
                    COUNT(DISTINCT vs.id_visitor) as newvisitor_count
                FROM s_arkabiz vs
                JOIN visitor v ON v.id=vs.id_visitor 
                WHERE
                    DATE(vs.session_start) = '2012-02-22'
                GROUP BY rep_date,vs.id_referer,WEEKDAY(vs.session_start)
            ) sSELECT
                s.*,
                ROUND(s.hit_count/s.host_count,2) as depth_count,
                (s.host_count-s.newvisitor_count) as existvisitor_count,
                ROUND(100*(s.newvisitor_count/s.host_count),2) as newvisitor_persent_count,
                ROUND(100*(s.host_count-s.newvisitor_count)/s.host_count,2) as existvisitor_persent_count,
                ROUND(100*(s.targetvisitor_count/s.visitor_count),2) as targetpersent_count
            FROM
            (
                SELECT
                    DATE(vs.session_start) as rep_date,
                    vs.id_referer as id1,WEEKDAY(vs.session_start) as id2,
                    WEEKDAY(vs.session_start) as wd,
                    SUM(vs.action_count) as hit_count,
                    COUNT(vs.id) as host_count,
                    COUNT(DISTINCT vs.id_visitor) as visitor_count,
                    SUM(IF(vs.action_count=1,1,0)) as 1pagevisitor_count,
                    SUM(IF(vs.action_count<>1,1,0)) as non1pagevisitor_count,
                    SUM(IF(vs.target=1,1,0)) as targetvisitor_count,
                    SUM(IF(vs.target=0,1,0)) as nontargetvisitor_count,
                    COUNT(DISTINCT vs.id_visitor) as newvisitor_count
                FROM s_arkabiz vs
                JOIN visitor v ON v.id=vs.id_visitor 
                WHERE
                    DATE(vs.session_start) = '2012-02-22'
                GROUP BY rep_date,vs.id_referer,WEEKDAY(vs.session_start)
            ) sSELECT
                s.*,
                ROUND(s.hit_count/s.host_count,2) as depth_count,
                (s.host_count-s.newvisitor_count) as existvisitor_count,
                ROUND(100*(s.newvisitor_count/s.host_count),2) as newvisitor_persent_count,
                ROUND(100*(s.host_count-s.newvisitor_count)/s.host_count,2) as existvisitor_persent_count,
                ROUND(100*(s.targetvisitor_count/s.visitor_count),2) as targetpersent_count
            FROM
            (
                SELECT
                    DATE(vs.session_start) as rep_date,
                    vs.id_referer as id1,WEEKDAY(vs.session_start) as id2,
                    WEEKDAY(vs.session_start) as wd,
                    SUM(vs.action_count) as hit_count,
                    COUNT(vs.id) as host_count,
                    COUNT(DISTINCT vs.id_visitor) as visitor_count,
                    SUM(IF(vs.action_count=1,1,0)) as 1pagevisitor_count,
                    SUM(IF(vs.action_count<>1,1,0)) as non1pagevisitor_count,
                    SUM(IF(vs.target=1,1,0)) as targetvisitor_count,
                    SUM(IF(vs.target=0,1,0)) as nontargetvisitor_count,
                    COUNT(DISTINCT vs.id_visitor) as newvisitor_count
                FROM s_arkabiz vs
                JOIN visitor v ON v.id=vs.id_visitor 
                WHERE
                    DATE(vs.session_start) = '2012-02-22'
                GROUP BY rep_date,vs.id_referer,WEEKDAY(vs.session_start)
            ) sSELECT
                s.*,
                ROUND(s.hit_count/s.host_count,2) as depth_count,
                (s.host_count-s.newvisitor_count) as existvisitor_count,
                ROUND(100*(s.newvisitor_count/s.host_count),2) as newvisitor_persent_count,
                ROUND(100*(s.host_count-s.newvisitor_count)/s.host_count,2) as existvisitor_persent_count,
                ROUND(100*(s.targetvisitor_count/s.visitor_count),2) as targetpersent_count
            FROM
            (
                SELECT
                    DATE(vs.session_start) as rep_date,
                    vs.id_referer as id1,WEEKDAY(vs.session_start) as id2,
                    WEEKDAY(vs.session_start) as wd,
                    SUM(vs.action_count) as hit_count,
                    COUNT(vs.id) as host_count,
                    COUNT(DISTINCT vs.id_visitor) as visitor_count,
                    SUM(IF(vs.action_count=1,1,0)) as 1pagevisitor_count,
                    SUM(IF(vs.action_count<>1,1,0)) as non1pagevisitor_count,
                    SUM(IF(vs.target=1,1,0)) as targetvisitor_count,
                    SUM(IF(vs.target=0,1,0)) as nontargetvisitor_count,
                    COUNT(DISTINCT vs.id_visitor) as newvisitor_count
                FROM s_arkabiz vs
                JOIN visitor v ON v.id=vs.id_visitor 
                WHERE
                    DATE(vs.session_start) = '2012-02-22'
                GROUP BY rep_date,vs.id_referer,WEEKDAY(vs.session_start)
            ) s