Hi guys,

I basically have two tables: locales_source (which includes English source phrases) and locales_target (which includes all the translated phrases).

I'm looking for a way to list the English phrases (from locales_source) only if translations in de, fr, and es exist in locales_target.

Any help would be appreciated.

Here's some table info:

Code MySQL:
mysql> describe locales_source;
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| lid       | int(11)      | NO   | PRI | NULL    | auto_increment |
| location  | varchar(255) | NO   |     |         |                |
| textgroup | varchar(255) | NO   | MUL | default |                |
| source    | blob         | NO   | MUL | NULL    |                |
| version   | varchar(20)  | NO   | MUL | none    |                |
+-----------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
 
mysql> SELECT * FROM locales_source LIMIT 5;
+------+-----------------------------------------------------------+-----------+--------------+---------+
| lid  | location                                                  | textgroup | source       | version |
+------+-----------------------------------------------------------+-----------+--------------+---------+
|   61 | c:\Contributions\modules\og\og.module:597;1623            | default   | Title        | 6.25    |
|  551 | notifications_content/notifications_content.module:124;35 | default   | Content type | 6.25    |
|  981 |                                                           | default   | @count days  | 6.25    |
| 1471 | admin_menu.inc:415                                        | default   | None         | 6.25    |
| 1961 | c:\Contributions\modules\og\og.module:1059;1082           | default   | Groups       | 6.25    |
+------+-----------------------------------------------------------+-----------+--------------+---------+
5 rows in set (0.00 sec)
 
mysql> describe locales_target;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| lid         | int(11)     | NO   | PRI | 0       |       |
| translation | blob        | NO   |     | NULL    |       |
| language    | varchar(12) | NO   | PRI |         |       |
| plid        | int(11)     | NO   | MUL | 0       |       |
| plural      | int(11)     | NO   | PRI | 0       |       |
| i18n_status | int(11)     | NO   |     | 0       |       |
+-------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
 
mysql> mysql> SELECT * FROM locales_target LIMIT 5;
+------+-------------+----------+------+--------+-------------+
| lid  | translation | language | plid | plural | i18n_status |
+------+-------------+----------+------+--------+-------------+
|   61 | Titel       | de       |    0 |      0 |           0 |
|  551 | Inhalt      | de       |    0 |      0 |           0 |
|  981 | @count Tage | de       |    0 |      0 |           0 |
| 1471 | Kein        | de       |    0 |      0 |           0 |
| 1961 | Gruppen     | de       |    0 |      0 |           0 |
+------+-------------+----------+------+--------+-------------+
5 rows in set (0.00 sec)