 |
| 関東地方 |
|
聖学院大学総合図書館
|
〒362-8585 上尾市戸崎 1-1
Tel.: 048-725-5461
Fax: 048-780-1096 |
| http:// www.seigakuin-univ.ac.jp/scr/lib.asp
|
コレクション: |
Error in query - 1030 - Got error 28 from storage engine
SQL:
select p.*,
tv1.value_ja_data as 'name',
tv1.data_lang_ja as name_lang,
tv2.value_ja_data as 'namecomm',
tv2.data_lang_ja as namecomm_lang,
tv3_0.value_ja_data as institution_0,
tv3_0.data_lang_ja as institution_0_lang,
tv4.value_ja_data as 'description',
tv4.data_lang_ja as description_lang,
tv5.value_ja_data as 'page',
tv5.data_lang_ja as page_lang
FROM tks_collections p
LEFT OUTER JOIN object_textvalues_col tv1 on tv1.text_id = p.name_txtid
LEFT OUTER JOIN object_textvalues_col tv2 on tv2.text_id = p.namecomm_txtid
LEFT OUTER JOIN tks_institutions rt3 on rt3.id = p.institution_id
LEFT OUTER JOIN object_textvalues_col tv3_0 on tv3_0.text_id = rt3.name_txtid
LEFT OUTER JOIN object_textvalues_col tv4 on tv4.text_id = p.description_txtid
LEFT OUTER JOIN object_textvalues_col tv5 on tv5.text_id = p.page_txtid
where p.institution_id = '603' ORDER BY tv1.value_ys_data
|
