gistfile1.txt

MySQL [marketplace_firefox_com]> select extensions_extension.id, extensions_extension.created, extensions_extension.modified, slug, status, name, locale, localized_string, localized_string_clean from extensions_extension, translations where extensions_extension.name = translations.id;
+----+---------------------+---------------------+------------------------------+--------+---------+--------+--------------------------------+------------------------+
| id | created             | modified            | slug                         | status | name    | locale | localized_string               | localized_string_clean |
+----+---------------------+---------------------+------------------------------+--------+---------+--------+--------------------------------+------------------------+
|  1 | 2015-10-11 04:01:54 | 2015-10-11 04:01:54 | quick-settings-enhancement   |      4 | 8495013 | en-us  | Quick Settings Enhancement     | NULL                   |
|  2 | 2015-10-12 06:59:36 | 2015-10-12 06:59:36 | homebar-plus                 |      4 | 8495088 | en-us  | Homebar-Plus                   | NULL                   |
|  3 | 2015-10-12 10:30:39 | 2015-10-12 10:30:39 | imgur-screenshots            |      4 | 8495106 | en-us  | IMGUR Screenshots              | NULL                   |
|  4 | 2015-10-13 00:22:46 | 2015-10-13 00:22:46 | unread-icons                 |     12 | 8495132 | en-us  | Unread Icons                   | NULL                   |
|  5 | 2015-10-13 12:37:24 | 2015-10-13 12:37:24 | NULL                         |      0 | 8495152 | en-us  | Back Button                    | NULL                   |
|  6 | 2015-10-13 12:40:59 | 2015-10-13 12:40:59 | NULL                         |      2 | 8495158 | en-us  | Back Button                    | NULL                   |
|  7 | 2015-10-13 12:47:35 | 2015-10-13 12:47:35 | NULL                         |      2 | 8495160 | en-us  | Back Button                    | NULL                   |
|  8 | 2015-10-13 12:57:12 | 2015-10-13 12:57:12 | NULL                         |      2 | 8495162 | en-us  | Back Button                    | NULL                   |
|  9 | 2015-10-13 13:00:12 | 2015-10-13 13:00:12 | NULL                         |      2 | 8495164 | en-us  | Back Button                    | NULL                   |
| 10 | 2015-10-13 20:29:28 | 2015-10-13 20:29:28 | back-button-4                |      2 | 8495183 | en-us  | Back Button                    | NULL                   |
| 11 | 2015-10-15 00:20:56 | 2015-10-15 00:20:56 | system-draggable-home-button |      2 | 8495255 | zh-tw  | System - Draggable Home Button | NULL                   |
| 12 | 2015-10-15 00:22:05 | 2015-10-15 00:22:05 | system-yellow-mask           |      2 | 8495257 | zh-tw  | System - Yellow Mask           | NULL                   |
| 13 | 2015-10-15 02:40:14 | 2015-10-15 02:40:14 | system-sound-switch          |      2 | 8495262 | zh-tw  | System - Sound Switch          | NULL                   |
| 14 | 2015-10-15 02:41:41 | 2015-10-15 02:41:41 | system-beacon-scanner        |      2 | 8495264 | zh-tw  | System - Beacon Scanner        | NULL                   |
+----+---------------------+---------------------+------------------------------+--------+---------+--------+--------------------------------+------------------------+
14 rows in set (0.00 sec)