git.schokokeks.org
Repositories
Help
Report an Issue
fs-words.git
Code
Commits
Branches
Tags
Suche
Strukturansicht:
1b85fc9
Branches
Tags
develop-client_server
master
typescript
fs-words.git
source
sql
concept
search.sql
[mod] makefile
Christian Fraß
commited
1b85fc9
at 2021-03-03 23:53:00
search.sql
Blame
History
Raw
SELECT x1.id 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_expressions AS x5 ON (x1.id = x5.concept_id) LEFT OUTER JOIN expressions AS x6 ON (x5.expression_id = x6.id) LEFT OUTER JOIN languages AS x7 ON (x6.language_id = x7.id) WHERE ( (:part IS NULL) OR (x6.value LIKE :part) ) GROUP BY x1.id ;
