queries/convert.sql.tpl (d6bb2a3) - fs-words.git

convert.sql.tpl

SELECT
	x4.id AS id,
	x4.type AS type,
	x4.description AS description,
	x4.tags AS tags,
	GROUP_CONCAT(x5.language || ':' || x5.lemma, '|') AS translations
FROM
	(
			(
				SELECT
					x2.id AS id,
					x2.type AS type,
					x2.description AS description,
					x2.tags AS tags,
					x3.word_id AS word_id
				FROM
					(
							(
								SELECT
									x0.id AS id,
									x0.type AS type,
									x0.description AS description,
									GROUP_CONCAT(x1.tag, '|') AS tags
								FROM
									(
											concepts AS x0
										LEFT JOIN
											tags AS x1
										ON
											(x0.id = x1.concept_id)
									)
								GROUP BY
									x0.id
							) AS x2
						LEFT JOIN
							correlations AS x3
						ON
							(x2.id = x3.concept_id)
					)
			) AS x4
		INNER JOIN
			(
				SELECT
					y1.id AS id,
					y1.lemma AS lemma,
					y2.iso_639_2 AS language
				FROM
					(
							words AS y1
						INNER JOIN
							languages AS y2
						ON
							(y1.language_id = y2.id)
					)
			) AS x5
		ON
			(x4.word_id = x5.id)
	)
GROUP BY
	x4.id
ORDER BY
	x4.type
;

fs-words.git

moved to flat files