queries/associate.sql.tpl (9785e31) - fs-words.git

associate.sql.tpl

select
	`x6`.`lemma` as `lemma`,
	`x7`.`iso_639_2` as `language`
from
	(
			(
				select
					`x4`.`tag` as `tag`,
					`x5`.`lemma` as `lemma`,
					`x5`.`language_id` as `language_id`
				from
					(
							(
								select
									`x2`.`tag` as `tag`,
									`x3`.`word_id` as `word_id`
								from
									(
											(
												select
													`x0`.`id` as `concept_id`,
													`x0`.`tag` as `tag`
												from
													(
															`tags` as `x0`
														inner join
															`concepts` as `x1`
														on
															(`x0`.`concept_id` = `x1`.`id`)
													)
											) as `x2`
										inner join
											`correlations` as `x3`
										on
											(`x2`.`concept_id` = `x3`.`concept_id`)
									)
							) as `x4`
						inner join
							`words` as `x5`
						on
							(`x4`.`word_id` = `x5`.`id`)
					)
			) as `x6`
		inner join
			`languages` as `x7`
		on
			(`x6`.`language_id` = `x7`.`id`)
	)
where
	(
		(`tag` = :tag)
		and
		(
			(:language is null)
			or
			(`x7`.`iso_639_1` = :language)
			or
			(`x7`.`iso_639_2` = :language)
		)
	)
;

fs-words.git

query scripts