fs-words.git

1) SELECT

2) 	x1.concept_id AS concept_id,
3) 	x2.value AS language_from,
4) 	x1.value AS value_from,
5) 	y2.value AS language_to,
6) 	y1.value AS value_to

7) FROM

8) 	concept_translations AS x1
9) 	INNER JOIN languages AS x2 ON (x1.language_id = x2.id)
10) 	INNER JOIN concept_translations AS y1 ON ((x1.id <> y1.id) AND (x1.concept_id = y1.concept_id))
11) 	INNER JOIN languages AS y2 ON (y1.language_id = y2.id)

12) WHERE
13) 	(

14) 		(
15) 			(:language_from = '_')
16) 			OR
17) 			(x2.value = :language_from)
18) 		)

19) 		AND

20) 		(
21) 			(:language_to = '_')
22) 			OR
23) 			(y2.value = :language_to)
24) 		)

25) 		AND

26) 		(x1.value LIKE :part)