(Real) ALL DATA - NON PGC (BUZZ UP)

SELECT
    g.app_id as app_id,
    COUNT(DISTINCT g.gid) as gids,
    SUM(g.pan_click_count) AS click,
    SUM(g.client_impression_count) AS impression,
    SUM(g.pan_click_count) / SUM(g.client_impression_count) AS ctr,
    SUM(g.share_count) AS share,
    SUM(g.digg_count) AS digg,
    SUM(g.bury_count) AS bury,
    SUM(g.favorite_count) AS favorite
FROM
    i18n_pgc_dw_sg.log_v3_item_stats g
    LEFT JOIN `default`.crawl_group_stats_all c ON g.gid = c.gid
WHERE
    (
        g.`date` BETWEEN '20180129' AND '20180204'
    )
    AND g.app_id = 1194
    AND c.language = 'id'
GROUP BY g.app_id
ORDER BY click DESC
LIMIT 5