SELECT
		SUM(`perf_agg_253779_p6482000`.`spent`) AS `FACEBOOK_STATISTICS_DATA_spent`,
		SUM(`perf_agg_253783_p6482000`.`spent`) AS `DATE_COMPARISON_FACEBOOK_STATISTICS_spent`,
		group_concat(campaign.uuid),
		dates.date
FROM campaign_portfolio
       INNER JOIN advertiser ON advertiser.uuid = campaign_portfolio.advertiser_id
       INNER JOIN profile ON profile.parent_id = advertiser.uuid
       INNER JOIN budget_policy ON budget_policy.uuid = campaign_portfolio.budget_policy
       INNER JOIN budget_policy_constraint ON budget_policy.uuid = budget_policy_constraint.parent_id
       JOIN dates ON ((dates.date BETWEEN '2019-02-12' AND '2019-02-14') OR (dates.date BETWEEN '2019-02-09' AND '2019-02-11'))
       INNER JOIN `portfolio_structure_tmp_4bba1413-f0fc-4591-9b8a-1cbd7b7a30cd`
                  ON `portfolio_structure_tmp_4bba1413-f0fc-4591-9b8a-1cbd7b7a30cd`.portfolio_id = campaign_portfolio.uuid AND `portfolio_structure_tmp_4bba1413-f0fc-4591-9b8a-1cbd7b7a30cd`.date = dates.date
       LEFT JOIN campaign ON `portfolio_structure_tmp_4bba1413-f0fc-4591-9b8a-1cbd7b7a30cd`.adset_id = campaign.uuid
       LEFT JOIN `perf_agg_253779_p6482000`
                 ON `perf_agg_253779_p6482000`.campaign_id = campaign.id_in_target AND `perf_agg_253779_p6482000`.date = dates.date AND
                    `portfolio_structure_tmp_4bba1413-f0fc-4591-9b8a-1cbd7b7a30cd`.date = `perf_agg_253779_p6482000`.date
       LEFT JOIN `perf_agg_253780_p6482000` ON `perf_agg_253780_p6482000`.ad_set_id = campaign.uuid AND `perf_agg_253780_p6482000`.date = dates.date AND
                                               `portfolio_structure_tmp_4bba1413-f0fc-4591-9b8a-1cbd7b7a30cd`.date = `perf_agg_253780_p6482000`.date
       LEFT JOIN `perf_agg_253783_p6482000`
                 ON `perf_agg_253783_p6482000`.campaign_id = campaign.id_in_target AND `perf_agg_253783_p6482000`.date = dates.date AND
                    `portfolio_structure_tmp_4bba1413-f0fc-4591-9b8a-1cbd7b7a30cd`.date = `perf_agg_253783_p6482000`.date
       LEFT JOIN `perf_agg_253784_p6482000` ON `perf_agg_253784_p6482000`.ad_set_id = campaign.uuid AND `perf_agg_253784_p6482000`.date = dates.date AND
                                               `portfolio_structure_tmp_4bba1413-f0fc-4591-9b8a-1cbd7b7a30cd`.date = `perf_agg_253784_p6482000`.date
WHERE (advertiser.uuid = 6482000) AND campaign_portfolio.uuid = 99511901
GROUP BY dates.date