git.schokokeks.org
Repositories
Help
Report an Issue
fs-words.git
Code
Commits
Branches
Tags
Suche
Strukturansicht:
9815a42
Branches
Tags
develop-client_server
master
typescript
fs-words.git
source
sql
concept
get_translations.sql
[add] typescript logic
Christian Fraß
commited
9815a42
at 2021-03-03 00:27:18
get_translations.sql
Blame
History
Raw
SELECT x.concept_id AS concept_id, x.value AS value_from, y.value AS value_to FROM concept_translations AS x INNER JOIN concept_translations AS y ON (x.concept_id = y.concept_id) WHERE ( (x.language_id = (SELECT id FROM languages WHERE (value = :language_value_from))) AND (y.language_id = (SELECT id FROM languages WHERE (value = :language_value_to))) AND (x.value LIKE :part) ) ;