```sql
SELECT t0.user_identifier     c0,
       t0.id                  c1,
       t0.login_id            c2,
       t0.login_password      c3,
       t0.model               c4,
       t0.platform            c5,
       t0.uuid                c6,
       t0.handle_name         c7,
       t0.email               c8,
       t0.status              c9,
       t0.campaign_code       c10,
       t0.last_remote_address c11,
       t0.last_user_agent     c12,
       t0.last_login_at       c13,
       t0.latitude            c14,
       t0.longitude           c15,
       t0.updated_at          c16,
       t0.created_at          c17,
       t1.id                  c18,
       t2.id                  c19
FROM   USER t0
       LEFT OUTER JOIN user_profile t1
                    ON t1.user_identifier = t0.user_identifier
       LEFT OUTER JOIN user_balance t2
                    ON t2.user_identifier = t0.user_identifier
WHERE  t0.email = 'watanabe0621+3@gmail.com'
       AND t0.status >= 0
       AND t0.status < 200
```
```sql
SELECT t0.user_identifier     c0,
       t0.id                  c1,
       t0.login_id            c2,
       t0.login_password      c3,
       t0.model               c4,
       t0.platform            c5,
       t0.uuid                c6,
       t0.handle_name         c7,
       t0.email               c8,
       t0.status              c9,
       t0.campaign_code       c10,
       t0.last_remote_address c11,
       t0.last_user_agent     c12,
       t0.last_login_at       c13,
       t0.latitude            c14,
       t0.longitude           c15,
       t0.updated_at          c16,
       t0.created_at          c17,
       t1.id                  c18,
       t2.id                  c19
FROM   USER t0
       LEFT OUTER JOIN user_profile t1
                    ON t1.user_identifier = t0.user_identifier
       LEFT OUTER JOIN user_balance t2
                    ON t2.user_identifier = t0.user_identifier
WHERE  t0.user_identifier = 'Ej5LDP2O7v7oobVrhLqYvFNsF2pgCbGJ'
       AND t0.status >= 0
       AND t0.status < 200
```
```json
# save user data to kvs temporally
{
    "id": null,
    "userIdentifier": "l2YtpW6usR2xXi22d9RPI6QrDs1FElgr",
    "loginId": "watanabe0621+1@gmail.com",
    "loginPassword": "d17f25ecfbcc7857f7bebea469308be0b2580943e96d13a3ad98a13675c4bfc2",
    "model": null,
    "platform": null,
    "uuid": null,
    "handleName": null,
    "email": "watanabe0621+1@gmail.com",
    "status": 0,
    "campaignCode": null,
    "lastRemoteAddress": null,
    "lastUserAgent": null,
    "lastLoginAt": null,
    "latitude": 0,
    "longitude": 0,
    "updatedAt": null,
    "createdAt": null,
    "userProfile": null,
    "userBalance": null
}
```