fs-words.git

source/sql/concept/export.sql  1) SELECT
source/sql/concept/export.sql  2) 	x1.id AS id,
source/sql/concept/export.sql  3) 	MIN(x2.value) AS type,

source/sql/concept/dump.sql    4) 	MIN(x1.description) AS description,

source/sql/concept/export.sql  5) 	GROUP_CONCAT(DISTINCT x4.value) AS tags,

source/sql/concept/dump.sql    6) 	GROUP_CONCAT(DISTINCT (x7.value || ':' || x6.value)) AS expressions

source/sql/concept/export.sql  7) FROM
source/sql/concept/export.sql  8) 	concepts AS x1
source/sql/concept/export.sql  9) 	LEFT OUTER JOIN types AS x2 ON (x1.type_id = x2.id)
source/sql/concept/export.sql 10) 	LEFT OUTER JOIN concept_tags AS x3 ON (x1.id = x3.concept_id)
source/sql/concept/export.sql 11) 	LEFT OUTER JOIN tags AS x4 ON (x3.tag_id = x4.id)

source/sql/concept/dump.sql   12) 	LEFT OUTER JOIN concept_expressions AS x5 ON (x1.id = x5.concept_id)
source/sql/concept/dump.sql   13) 	LEFT OUTER JOIN expressions AS x6 ON (x5.expression_id = x6.id)

source/sql/concept/dump.sql   14) 	LEFT OUTER JOIN languages AS x7 ON (x6.language_id = x7.id)

source/sql/concept/dump.sql   15) WHERE
source/sql/concept/dump.sql   16) 	(
source/sql/concept/dump.sql   17) 		(:part IS NULL)
source/sql/concept/dump.sql   18) 		OR

source/sql/concept/dump.sql   19) 		(x6.value LIKE :part)

source/sql/concept/dump.sql   20) 	)