I'm trying to get an index working on a table. This is my data structure (with non important columns omitted):
Each translation in the translations table can be used by none or more elements.
For example:
--Elements--
(id, translationid, elementname)
1000, 1, 'btnDay'
1001, 1...