SQL formatting is weird

-- Union of subselects
        SELECT  COUNT(DISTINCT `email`)
          FROM (        SELECT `users`.`realemail`           `email`
                          FROM `subscriptions_delta`
                          JOIN `users`
                       USING ( `uid` )
                         WHERE `changed_at` >= '2014-01-01'
                  UNION SELECT `realemail`                   `email`
                          FROM `subscriptions_delta`
                         WHERE `changed_at` >= '2014-01-01'
               ) `useless_name_required_by_SQL`
             ;

-- Subselects joined to subselects: variation I
        SELECT `date_uids`.`date`         `date`
             ,                            `uids`
             ,                            `emails`
             , `uids`+IFNULL(`emails`,0)  `total`
          FROM (        SELECT                         `date`
                             ,  COUNT(DISTINCT `uid`)  `uids`
                          FROM  (       SELECT  DATE(`changed_at`)  `date`
                                             ,                      `uid`
                                          FROM `subscriptions_delta`
                                         WHERE `changed_at` >= '2014-06-01'
                                ) `date_uid`
                      GROUP BY `date`
               ) `date_uids`
     LEFT JOIN (        SELECT                           `date`
                             ,  COUNT(DISTINCT `email`)  `emails`
                          FROM (        SELECT  DATE(`changed_at`)  `date`
                                             , `realemail`          `email`
                                          FROM `subscriptions_delta`
                                         WHERE `changed_at` >= '2014-06-01'
                                           AND `uid` = 666
                               ) `date_email`
                      GROUP BY `date`
               ) `date_emails`
         USING ( `date` )
      ORDER BY `date` ASC
             ;

-- Subselects joined to subselects: variation II
        SELECT `date_uids`.`date` `date`
             , `uids`
             , `emails`
             , `uids`+IFNULL(`emails`,0) `total`
          FROM (
                SELECT `date`
                     ,  COUNT(DISTINCT `uid`) `uids`
                  FROM (
                        SELECT  DATE(`changed_at`) `date`
                             , `uid`
                          FROM `subscriptions_delta`
                         WHERE `changed_at` >= '2014-01-01'
                     ) `date_uid`
              GROUP BY `date`
             ) `date_uids`
     LEFT JOIN (
                SELECT `date`
                     ,  COUNT(DISTINCT `email`) `emails`
                  FROM (
                        SELECT  DATE(`changed_at`) `date`
                             , `realemail` `email`
                          FROM `subscriptions_delta`
                         WHERE `changed_at` >= '2014-01-01'
                           AND `uid` = 666
                             ) `date_email`
                      GROUP BY `date`
             ) `date_emails`
         USING ( `date` )
      ORDER BY `date` ASC
             ;

-- Subselects joined to subselects: variation III
        SELECT `date_uids`.`date` `date`
             , `uids`
             , `emails`
             , `uids`+IFNULL(`emails`,0) `total`
          FROM (
        SELECT `date`
             ,  COUNT(DISTINCT `uid`) `uids`
          FROM (
        SELECT  DATE(`changed_at`) `date`
             , `uid`
          FROM `subscriptions_delta`
         WHERE `changed_at` >= '2014-01-01'
             ) `date_uid`
      GROUP BY `date`
             ) `date_uids`
     LEFT JOIN (
        SELECT `date`
             ,  COUNT(DISTINCT `email`) `emails`
          FROM (
        SELECT  DATE(`changed_at`) `date`
             , `realemail` `email`
          FROM `subscriptions_delta`
         WHERE `changed_at` >= '2014-01-01'
           AND `uid` = 666
             ) `date_email`
      GROUP BY `date`
             ) `date_emails`
        USING ( `date` )
      ORDER BY `date` ASC
             ;