Matthias Koch, Claus Harmer & Florian Coulmas
   
   

三か国語対照人口学用語集

2007, Brill, Leiden, Boston, x, 924 p., ISBN: 978-9004154-76-6, € 149 / US$ 199 / ¥ 28,090.  注文 -> www.brill.nl  

本書は、英・日・独三か国語対照による人口学研究のための最新用語集である。収録した用語は、英・日・独語等で書かれた人口学に関する専門文献、百科事典、データベース、既存の用語集に基づいている。7500語を超える専門用語が、英・日・独のどの言語からもアクセス可能となっている。すなわち、すべての用語を次の三通りの配列で並べた「英語-日本語-ドイツ語」「日本語-英語-ドイツ語」「ドイツ語-日本語-英語」。  © 2007

Error in query - 1030 - Got error 28 from storage engine
SQL:



select count(p.id) count,
p.id id,
t1.value_de dename,
t21.value_de natdename,
UCASE(LEFT(t1.value_de,1)) stde,
t2.value_en enname,
t22.value_en natenname,
UCASE(LEFT(t1.value_en,1)) sten,
t3.value_ja janame,
t23.value_ja natjaname,
t4.value_yo yoname,
t24.value_yo natyoname,
t5.value_ys ysname,
t25.value_ys natysname,
LEFT(t1.value_ys,1) stys,
t6.value_ro roname,
UCASE(LEFT(t1.value_ro,1)) stro,
t7.value_de desecname,
t8.value_en ensecname,
t9.value_ja jasecname,
t10.value_yo yosecname,
t11.value_ys yssecname,
t12.value_ro rosecname,
t13.value_de deabr,
t14.value_en enabr,
t15.value_ja jaabr,
t16.value_yo yoabr,
t17.value_yo ysabr,
t18.value_ro roabr,
t26.value_en encomm,
t27.value_ja jacomm,
t28.value_de decomm,

wl.language_id langid,
wnal.language_id nlangid




from demglos_words p
left outer join object_textvalues_col t1 on
t1.text_id = p.name_txtid
left outer join object_textvalues_col t21 on
t21.text_id = p.natname_txtid
left outer join object_textvalues_col t2 on
t2.text_id = p.name_txtid
left outer join object_textvalues_col t22 on
t22.text_id = p.natname_txtid
left outer join object_textvalues_col t3 on
t3.text_id = p.name_txtid
left outer join object_textvalues_col t23 on
t23.text_id = p.natname_txtid
left outer join object_textvalues_col t4 on
t4.text_id = p.name_txtid
left outer join object_textvalues_col t24 on
t24.text_id = p.natname_txtid
left outer join object_textvalues_col t5 on
t5.text_id = p.name_txtid
left outer join object_textvalues_col t25 on
t25.text_id = p.natname_txtid
left outer join object_textvalues_col t26 on
t26.text_id = p.comment_txtid
left outer join object_textvalues_col t27 on
t27.text_id = p.comment_txtid
left outer join object_textvalues_col t28 on
t28.text_id = p.comment_txtid
left outer join object_textvalues_col t6 on
t6.text_id = p.name_txtid
left outer join object_textvalues_col t7 on
t7.text_id = p.secname_txtid
left outer join object_textvalues_col t8 on
t8.text_id = p.secname_txtid
left outer join object_textvalues_col t9 on
t9.text_id = p.secname_txtid
left outer join object_textvalues_col t10 on
t10.text_id = p.secname_txtid
left outer join object_textvalues_col t11 on
t11.text_id = p.secname_txtid
left outer join object_textvalues_col t12 on
t12.text_id = p.secname_txtid
left outer join object_textvalues_col t13 on
t13.text_id = p.abrev_txtid
left outer join object_textvalues_col t14 on
t14.text_id = p.abrev_txtid
left outer join object_textvalues_col t15 on
t15.text_id = p.abrev_txtid
left outer join object_textvalues_col t16 on
t16.text_id = p.abrev_txtid
left outer join object_textvalues_col t17 on
t17.text_id = p.abrev_txtid
left outer join object_textvalues_col t18 on
t18.text_id = p.abrev_txtid
left outer join objects o on
p.id = o.object_id

left outer join demglos_word_lang wl on
wl.word_id = p.id
left outer join demglos_word_nalang wnal on
wnal.word_id = p.id


where ( t1.value_yo like 'り%' )

group by yoname
order by yoname