1. There is a table with the languages
2. Each table with textual information, for which you need a translation, there is a field with the ID of the language.
3. What can optimize if the query is added to only the sample for the current language?
Lucas7 answered on April 4th 20 at 00:53
In fact the page text is another attribute, the disadvantage of this approach is that you need to handle fulbeck with an empty translation, or add flags/bitmask for the finished translation
A separate table with translations
tid - int
page - text
lang_iso_code - int