SELECT  translation_table.id,translation_table.searchtext,translation_table.replacetext,translation_table.language,translation.description,translation.prefix FROM translation_table LEFT JOIN translation ON translation.id=translation_table.id_translation WHERE  translation.prefix='netpet_frontend' and translation_table.language='de'  ORDER BY  LENGTH(searchtext) DESC