SELECT adv_stat.*, adv_project.* FROM
adv_project
LEFT JOIN (SELECT
    COALESCE (
        adv_stat_day_ad.project_id,
        adv_stat_day_goal.project_id
    ) AS project_id,
    SUM (adv_stat_day_ad.views) AS views,
    SUM (adv_stat_day_ad.clicks) AS clicks,
    SUM (adv_stat_day_ad.spent) AS spent,
    SUM (adv_stat_day_goal.conversions) AS conv,
    SUM (adv_stat_day_goal.revenue) AS revenue,
    MAX (adv_stat_day_ad.last_update) AS last_update
FROM
        adv_stat_day_ad
        FULL JOIN adv_stat_day_goal ON (
                adv_stat_day_ad.ad_id = adv_stat_day_goal.ad_id
                AND adv_stat_day_ad."day" = adv_stat_day_goal."day"
        )
WHERE
    (adv_stat_day_goal.project_goal_id IS NULL OR adv_stat_day_goal.project_goal_id IN (SELECT id from adv_project_goal where is_default AND project_id IN (58,63)))
                AND (adv_stat_day_ad. DAY BETWEEN '2014-08-21' AND '2014-08-21' or adv_stat_day_ad. DAY is NULL)
                AND (adv_stat_day_goal. DAY BETWEEN '2014-08-21' AND '2014-08-21' or adv_stat_day_goal. DAY is NULL)

GROUP BY
    COALESCE (
        adv_stat_day_ad.project_id,
        adv_stat_day_goal.project_id
    )
) as adv_stat ON adv_stat.project_id = adv_project.id
WHERE
adv_project.id IN (58,63)
ORDER BY adv_stat.clicks DESC;