fs-words.git

source/sql/concept/get_translations.sql  1) SELECT

source/sql/concept/get_translations.sql  2) 	x1.concept_id AS concept_id,

source/sql/concept/get_translations.sql  3) 	x3.value AS language_from,
source/sql/concept/get_translations.sql  4) 	x2.value AS value_from,
source/sql/concept/get_translations.sql  5) 	y3.value AS language_to,
source/sql/concept/get_translations.sql  6) 	y2.value AS value_to

source/sql/concept/get_translations.sql  7) FROM

source/sql/concept/get_translations.sql  8) 	concept_expressions AS x1 INNER JOIN concept_expressions AS y1 ON ((x1.id <> y1.id) AND (x1.concept_id = y1.concept_id))
source/sql/concept/get_translations.sql  9) 	LEFT OUTER JOIN expressions AS x2 ON (x1.expression_id = x2.id)
source/sql/concept/get_translations.sql 10) 	LEFT OUTER JOIN languages AS x3 ON (x2.language_id = x3.id)
source/sql/concept/get_translations.sql 11) 	LEFT OUTER JOIN expressions AS y2 ON (y1.expression_id = y2.id)
source/sql/concept/get_translations.sql 12) 	LEFT OUTER JOIN languages AS y3 ON (y2.language_id = y3.id)

source/sql/concept/get_translations.sql 13) WHERE
source/sql/concept/get_translations.sql 14) 	(

source/sql/concept/get_translations.sql 15) 		(
source/sql/concept/get_translations.sql 16) 			(:language_from = '_')
source/sql/concept/get_translations.sql 17) 			OR

source/sql/concept/get_translations.sql 18) 			(x3.value = :language_from)

source/sql/concept/get_translations.sql 19) 		)

source/sql/concept/get_translations.sql 20) 		AND

source/sql/concept/get_translations.sql 21) 		(
source/sql/concept/get_translations.sql 22) 			(:language_to = '_')
source/sql/concept/get_translations.sql 23) 			OR

source/sql/concept/get_translations.sql 24) 			(y3.value = :language_to)

source/sql/concept/get_translations.sql 25) 		)

source/sql/concept/get_translations.sql 26) 		AND

source/sql/concept/get_translations.sql 27) 		(x2.value LIKE :part)