git.schokokeks.org
Repositories
Help
Report an Issue
fs-words.git
Code
Commits
Branches
Tags
Suche
Strukturansicht:
9785e31
Branches
Tags
develop-client_server
master
typescript
fs-words.git
queries
dictionary.sql.tpl
query scripts
Christian Fraß
commited
9785e31
at 2017-03-19 21:20:53
dictionary.sql.tpl
Blame
History
Raw
select `x2`.`id` as `id`, `x2`.`description` as `description`, `x2`.`tags` as `tags`, `x3`.`word_id` as `word_id` from ( ( select `x0`.`id` as `id`, `x0`.`description` as `description`, group_concat(`x1`.`tag`) as `tags` from ( `concepts` as `x0` inner join `tags` as `x1` on (`x0`.`id` = `x1`.`concept_id`) ) group by `x0`.`id` ) as `x2` inner join `correlations` as `x3` on (`x2`.`id` = `x3`.`concept_id`) ) ;