SELECT
        COUNT(adverId) visit,
        adverId,
        statId
        developersName,
        productsName  
    FROM
        tb_statistic_adver_visit v,
        (SELECT
            chid,
            uid,
            cpid 
        FROM
            tb_statistic_stat) s,
        (SELECT
            developersName,
            productsName,
            developersId,id 
        FROM
            tb_developers_service 
        WHERE
            1=1 
        GROUP BY
            developersId ) d 
    WHERE
        1=1  
        AND s.uid=v.statId 
       AND s.cpid=d.developersId  
    GROUP BY
        adverId