Simple SQL query to get phrase pairs from a translations table
I recommend using more vertical space when you write a query to make it easier to read. That said, this should work:

SELECT 
    P1.phrase_id, 
    P1.language, 
    P1.text, 
    P2.phrase_id, 
    P2.language, 
    P2.text
FROM    phrases P1
INNER JOIN translations T
    ON P1.phrase_id = T.source_id
INNER JOIN phrases P2 
    ON P2.phrase_id = T.destination_id
WHERE   P1.language = 'eng' 
AND     P2.language = 'fra'
LIMIT 100;