git.schokokeks.org
Repositories
Help
Report an Issue
fs-words.git
Code
Commits
Branches
Tags
Suche
Strukturansicht:
bc0937f
Branches
Tags
develop-client_server
master
typescript
fs-words.git
source
sql
concept
dump.sql
[mod] logic
Christian Fraß
commited
bc0937f
at 2021-03-03 01:35:40
dump.sql
Blame
History
Raw
SELECT x1.id AS id, MIN(x2.value) AS type, MIN(x1.description) AS description, GROUP_CONCAT(DISTINCT x4.value) AS tags, GROUP_CONCAT(x5.id || ':' || x6.value || ':' || x5.value) AS translations FROM concepts AS x1 LEFT OUTER JOIN types AS x2 ON (x1.type_id = x2.id) LEFT OUTER JOIN concept_tags AS x3 ON (x1.id = x3.concept_id) LEFT OUTER JOIN tags AS x4 ON (x3.tag_id = x4.id) LEFT OUTER JOIN concept_translations AS x5 ON (x1.id = x5.concept_id) LEFT OUTER JOIN languages AS x6 ON (x5.language_id = x6.id) WHERE ( (:part IS NULL) OR (x5.value LIKE :part) ) GROUP BY x1.id ;
