SELECT
      `up`.`id` AS 'id',
      (
      SELECT
          COUNT(li2.`id`)
      FROM
          `links` li2
      WHERE
          (
              `uploaders_id` = `up`.`id`
          )
    ) AS 'savedVideo',
      (
      SELECT
          COUNT(li2.`id`)
      FROM
          `links` li2
      WHERE
          (
              `uploaders_id` = `up`.`id` && `episodelist_id` IS NOT NULL
          )
    ) AS 'usedVideo',
    SUM(`st`.`viewed`) AS 'viewed',
    SUM(`st`.`clicked`) AS 'clicked',
    SUM(`st`.`opened`) AS 'opened',
    `up`.`name`,
    `up`.`inda_link`,
    `up`.`fan_link`,
    `up`.`fb_link`,
    `up`.`email`,
    `up`.`pdes`
    FROM
      `uploaders` up
    INNER JOIN `links` li ON
      `li`.`uploaders_id` = `up`.`id`
    INNER JOIN `statistic__links` st ON
      `st`.`links_id` = `li`.`id`
    WHERE
      `up`.`id` = ;