performance with joins

I have 3 tables: - table_1 - pri key is id+lang - table_2 - pri key is id - table_3 - pri key is id+lang (Full-Text table) To join all 3 tables with their keys and run a full-text query, I understand I need to put the Full-Text table at the end of the joins.. If I use the tables as def

Getting a particular row from GROUP BY

Hello, I have the next table (the primary key is id+language): || id || language ||title|| --- 1 de{some_text} 1 en{some_text} 1 fr{some_text} 2 fr{some_text} 2