SELECT
	x.concept_id AS concept_id,
	x.value AS value_from,
	y.value AS value_to
FROM
	concept_translations AS x INNER JOIN concept_translations AS y ON (x.concept_id = y.concept_id)
WHERE
	(
		(x.language_id = (SELECT id FROM languages WHERE (value = :language_value_from)))
		AND
		(y.language_id = (SELECT id FROM languages WHERE (value = :language_value_to)))
		AND
		(x.value LIKE :part)
	)
;

