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(x5.id || ':' || x6.value || ':' || x5.value) AS translations

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/export.sql 12) 	LEFT OUTER JOIN concept_translations AS x5 ON (x1.id = x5.concept_id)
source/sql/concept/export.sql 13) 	LEFT OUTER JOIN languages AS x6 ON (x5.language_id = x6.id)

source/sql/concept/dump.sql   14) WHERE
source/sql/concept/dump.sql   15) 	(
source/sql/concept/dump.sql   16) 		(:part IS NULL)
source/sql/concept/dump.sql   17) 		OR
source/sql/concept/dump.sql   18) 		(x5.value LIKE :part)
source/sql/concept/dump.sql   19) 	)