fs-words.git

1) SELECT

2) 	x1.concept_id AS concept_id,

3) 	x3.value AS language_from,
4) 	x2.value AS value_from,
5) 	y3.value AS language_to,
6) 	y2.value AS value_to

7) FROM

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

13) WHERE
14) 	(

15) 		(
16) 			(:language_from = '_')
17) 			OR

18) 			(x3.value = :language_from)

19) 		)

20) 		AND

21) 		(
22) 			(:language_to = '_')
23) 			OR

24) 			(y3.value = :language_to)

25) 		)

26) 		AND

27) 		(x2.value LIKE :part)