select c.id, g.id, a.id, substr(c.name, -2) 'type', a.headline, a.devicePreference 'device', a.searchEngineIdentifier 'ident', displayURL, a.status from gce_campaign c join gce_adGroup g on c.id=campaignID join gce_textAd a on adGroupID=g.id where c.name like 'phej0022%' order by c.id;

+----+----+------+------+------------------------------------------------+--------+-------------+------------+----------+
| id | id | id   | type | headline                                       | device | ident       | displayURL | status   |
+----+----+------+------+------------------------------------------------+--------+-------------+------------+----------+
...
| 23 | 94 | 1050 | GM   | 安心できる家政婦サービス                       |      0 | 24726229477 | test1.com  | Disabled |
| 23 | 94 | 1053 | GM   | {KeyWord:プロの家政婦サービス}                 |      0 | 24726229597 | test1.com  | Disabled |
| 23 | 94 | 1051 | GM   | {KeyWord:安心できる家政婦サービス}             |      0 | 24726229717 | test1.com  | Disabled |
| 23 | 94 | 1052 | GM   | プロの家政婦サービス                           |      0 | 24726229837 | test1.com  | Disabled |
| 23 | 94 | 1100 | GM   | プロの家政婦サービス                           |      0 | 24726240997 | test2.com  | Enabled  |
| 23 | 94 | 1098 | GM   | 安心できる家政婦サービス                       |      0 | 24726241117 | test2.com  | Enabled  |
| 23 | 94 | 1101 | GM   | {KeyWord:プロの家政婦サービス}                 |      0 | 24726241237 | test2.com  | Enabled  |
| 23 | 94 | 1099 | GM   | {KeyWord:安心できる家政婦サービス}             |      0 | 24726241357 | test2.com  | Enabled  |
| 24 | 96 | 1061 | MO   | {KeyWord:安い家政婦をお探しなら}               |  30001 | 24726230917 | test1.com  | Disabled |
| 24 | 96 | 1059 | MO   | {KeyWord:安い家政婦をお探しなら}               |  30001 | 24726231037 | test1.com  | Disabled |
| 24 | 96 | 1060 | MO   | 安い家政婦をお探しなら                         |  30001 | 24726231157 | test1.com  | Disabled |
| 24 | 96 | 1058 | MO   | 安い家政婦をお探しなら                         |  30001 | 24726231277 | test1.com  | Disabled |
| 24 | 96 | 1108 | MO   | 安い家政婦をお探しなら                         |      0 | 24726241957 | test2.com  | Enabled  |
| 24 | 96 | 1106 | MO   | 安い家政婦をお探しなら                         |      0 | 24726242077 | test2.com  | Enabled  |
| 24 | 96 | 1109 | MO   | {KeyWord:安い家政婦をお探しなら}               |      0 | 24726242197 | test2.com  | Enabled  |
| 24 | 96 | 1107 | MO   | {KeyWord:安い家政婦をお探しなら}               |      0 | 24726242317 | test2.com  | Enabled  |
+----+----+------+------+------------------------------------------------+--------+-------------+------------+----------+