Dictionaries dump

gistfile1.sql

create table dictionary_dump_20120504 as
select l.prefix, v.id, v.word, vhr.translation, a.worker_id, p.quality, p.total 
from voc_hits_results vhr, languages l, vocabulary v, assignments a, voc_hits_workers_performance p 

where 
a.id=vhr.assignment_id and
p.id=a.worker_id and p.language_id=l.id and
vhr.is_control=1 and vhr.quality=1
and v.id=vhr.word_id
and v.language_id=l.id
order by prefix, v.id;

copy dictionary_dump_20120504 to '/users/dkachaev/repos/hcil/hitman/process/src/dictionary_dump_20120504.txt';