SELECT `key`.*,
       `client`.`id`                    AS `client.id`,
       `client`.`f_name`                AS `client.f_name`,
       `client`.`l_name`                AS `client.l_name`,
       `client`.`email`                 AS `client.email`,
       `client`.`phone`                 AS `client.phone`,
       `client`.`note`                  AS `client.note`,
       `client`.`last_login`            AS `client.last_login`,
       `client`.`created_at`            AS `client.createdAt`,
       `client`.`updated_at`            AS `client.updatedAt`,
       `client`.`subscription_id`       AS `client.subscriptionId`,
       `client->subscription`.`id`      AS `client.subscription.id`,
       `client->subscription`.`name`    AS `client.subscription.name`,
       `client->subscription`.`info`    AS `client.subscription.info`,
       `client->subscription`.`key_qty` AS `client.subscription.key_qty`,
       `client->subscription`.`age`     AS `client.subscription.age`,
       `client->accounts`.`id`          AS `client.accounts.id`,
       `client->accounts`.`acc`         AS `client.accounts.acc`,
       `client->accounts`.`acc_type`    AS `client.accounts.acc_type`,
       `client->accounts`.`broker`      AS `client.accounts.broker`,
       `client->accounts`.`balance`     AS `client.accounts.balance`,
       `client->accounts`.`leverage`    AS `client.accounts.leverage`,
       `client->accounts`.`owner_name`  AS `client.accounts.owner_name`,
       `client->accounts`.`lang`        AS `client.accounts.lang`,
       `client->accounts`.`client_id`   AS `client.accounts.clientId`
FROM   (SELECT `key`.`id`,
               `key`.`key`,
               `key`.`exp_date`,
               `key`.`created_at` AS `createdAt`,
               `key`.`updated_at` AS `updatedAt`,
               `key`.`client_id`  AS `clientId`
        FROM   `keys` AS `key`
        WHERE  `key`.`key` = '23423'
        LIMIT  1) AS `key`
       LEFT OUTER JOIN `clients` AS `client`
                    ON `key`.`clientid` = `client`.`id`
       LEFT OUTER JOIN `subscriptions` AS `client->subscription`
                    ON `client`.`subscription_id` = `client->subscription`.`id`
       LEFT OUTER JOIN `accounts` AS `client->accounts`
                    ON `client`.`id` = `client->accounts`.`client_id`;