クエリ［bunken1］
SELECT bunken.bunken, bunken.sakka1, sakka1.sakkamei AS sakkamei1, sakka1.sakkameiyomi AS sakkameiyomi1, bunken.sakka2, sakka2.sakkamei AS sakkamei2, sakka2.sakkameiyomi AS sakkameiyomi2, bunken.henja1, henja1.henjamei AS henjamei1, bunken.henja2, henja2.henjamei AS henjamei2, bunken.henshu, bunken.shomei, bunken.shomeiyomi, Left([shomeiyomi],1) AS kasira, bunken.fukudai, bunken.label, label.labelmei, label.labelmeiyomi, bunken.labelnumber, bunken.labelnumberkey, bunken.labeltag, bunken.labeltagkey, bunken.seriesmei, bunken.seriesmeiyomi, bunken.senshukanmei, bunken.senshukan, bunken.hakkobi, IIf(Left([hakkobi],4) Like "","",Int(Left([hakkobi],4)/10)*10) AS hakkonendai, IIf(Left([hakkobi],4) Like "","",Left([hakkobi],4)) AS hakkonen, IIf(Mid([hakkobi],6,2) Like "","",Mid([hakkobi],6,2)) AS hakkogetsu, Int([bl_atogaki]) AS atogaki, Int([bl_kaisetsu]) AS kaisetsu, Int([bl_nenpu]) AS nenpu, bunken.bunkenhosoku, bunken.isbn, bunken.isbnmuko, IIf([boto],[boto],"00") AS botoichi, IIf([shoshu],[shoshu],0) AS shoshusu, bunken.hoyu FROM label RIGHT JOIN (((((bunken LEFT JOIN [shoshu/bunken] ON bunken.bunken = [shoshu/bunken].bunken) LEFT JOIN henja AS henja1 ON bunken.henja1 = henja1.henja) LEFT JOIN henja AS henja2 ON bunken.henja2 = henja2.henja) LEFT JOIN sakka AS sakka1 ON bunken.sakka1 = sakka1.sakka) LEFT JOIN sakka AS sakka2 ON bunken.sakka2 = sakka2.sakka) ON label.label = bunken.label WHERE (((bunken.bl_bunkenvalid)=True)) ORDER BY bunken.bunken; 

クエリ［bunken2］
SELECT bunken1.bunken, bunken1.sakka1, bunken1.sakkamei1, bunken1.sakkameiyomi1, bunken1.sakka2, bunken1.sakkamei2, bunken1.sakkameiyomi2, IIf([sakkamei1],[sakkamei1],[sakka1]) & IIf([sakkamei2],"／" & [sakkamei2],IIf([sakka2] Like "ほか",[sakka2],"")) AS sakkahyoki, bunken1.henja1, bunken1.henjamei1, bunken1.henja2, bunken1.henjamei2, bunken1.henshu, IIf([henjamei1],[henjamei1],[henja1]) & IIf([henjamei2],"・" & [henjamei2],IIf([henja2] Like "ほか",[henja2],"")) & IIf([henshu],[henshu],"") AS henjahyoki, bunken1.shomei, bunken1.shomeiyomi, bunken1.kasira, sakuin.sakuin, bunken1.fukudai, bunken1.label, bunken1.labelmei, bunken1.labelmeiyomi, bunken1.labelnumber, bunken1.labelnumberkey, bunken1.labeltag, bunken1.labeltagkey, bunken1.seriesmei, bunken1.seriesmeiyomi, bunken1.senshukanmei, bunken1.senshukan, bunken1.hakkobi, bunken1.hakkonendai, bunken1.hakkonen, bunken1.hakkogetsu, bunken1.atogaki, bunken1.kaisetsu, bunken1.nenpu, bunken1.bunkenhosoku, bunken1.isbn, bunken1.isbnmuko, bunken1.botoichi, bunken1.shoshusu, bunken1.hoyu FROM bunken1 LEFT JOIN sakuin ON bunken1.kasira = sakuin.kasira; 

クエリ［download_bunken］
SELECT [labelmei] & IIf([labeltag]," " & [labeltag],"") AS レーベル, bunken2.sakkahyoki AS 作家, "『" & IIf([seriesmei],[seriesmei] & " ","") & [shomei] & "』（" & IIf([henjahyoki],[henjahyoki] & "、","") & [hakkonen] & "年）" AS 書名 FROM bunken2 ORDER BY bunken2.labelmeiyomi, bunken2.labeltagkey, bunken2.hakkobi; 

クエリ［download_honyaku］
SELECT shuroku1.sakkamei AS 作家, shuroku1.sakuhinmei AS 作品, shuroku1.hanmei AS 翻訳, [labelmei] & "『" & IIf([seriesmei],[seriesmei] & " ","") & [shomei] & "』（" & [hakkonen] & "年）" AS 文献 FROM shuroku1 ORDER BY shuroku1.sakkameiyomi, shuroku1.sakuhinmeiyomi, shuroku1.hakkobi; 

クエリ［download_sakka］
SELECT sakka2.sakkamei AS 名前, sakka2.seimei AS フルネーム, sakka2.gengomei AS 原語名, sakka2.seibotsunen AS 生没年, sakka2.sakkahosoku AS 説明 FROM sakka2 WHERE (((sakka2.sakka) Not Like "anonyme" And (sakka2.sakka) Not Like "autres")) ORDER BY sakka2.sakkameiyomi; 

クエリ［download_sakuhin］
SELECT sakuhin2.sakkamei AS 作家, sakuhin2.sakuhinmei AS 題名, sakuhin2.gendai AS 原語題名, sakuhin2.tokatsumei AS シリーズ名, sakuhin2.tokatsugendai AS 原語シリーズ名, Int([happyonen]) & IIf([happyonenhosoku],[happyonenhosoku],"") AS 刊年, sakuhin2.kubunmei AS 分類 FROM sakuhin2 ORDER BY sakuhin2.sakkameiyomi, sakuhin2.sakuhinmeiyomi; 

クエリ［han1］
SELECT han.sakka, sakka.sakkamei, han.sakuhin, sakuhin.sakuhinmei, han.han, han.hanmei, han.handai, han.kansu, han.fukanzen, han.fukanzenhosoku, [shokan/han].shokan_ichi, [shokan/han].shokan_bunkatsu, [shokan/han].shokan_bunken, [shokan/han].shokan_shomei, [shokan/han].shokan_label, [shokan/han].shokan_labelmei, [shokan/han].shokan_seriesmei, [shokan/han].shokan_hakkobi, IIf([shokan_hakkobi] Like "","",Left([shokan_hakkobi],4)) AS shokan_hakkonen FROM (sakka RIGHT JOIN sakuhin ON sakka.sakka = sakuhin.sakka) RIGHT JOIN (han LEFT JOIN [shokan/han] ON (han.sakka = [shokan/han].sakka) AND (han.sakuhin = [shokan/han].sakuhin) AND (han.han = [shokan/han].han)) ON (sakuhin.sakuhin = han.sakuhin) AND (sakuhin.sakka = han.sakka) WHERE (((sakka.bl_sakkavalid)=True) AND ((sakuhin.bl_sakuhinvalid)=True) AND ((han.bl_hanvalid)=True)) ORDER BY han.sakka, han.sakuhin, han.han; 

クエリ［henja1］
SELECT henja.henja, henja.henjamei, henja.henjameiyomi, Left([henjameiyomi],1) AS kasira, henja.henjaseibotsunen, Format([kensu],"000") AS henshusu, [kincho/henja3].kincho FROM henja LEFT JOIN [kincho/henja3] ON henja.henja = [kincho/henja3].henja WHERE (((Format([kensu],"000")) Not Like "")) ORDER BY henja.henja; 

クエリ［henja2］
SELECT henja1.henja, henja1.henjamei, henja1.henjameiyomi, henja1.kasira, sakuin.sakuin, henja1.henjaseibotsunen, henja1.henshusu, henja1.kincho FROM henja1 LEFT JOIN sakuin ON henja1.kasira = sakuin.kasira; 

クエリ［henshu1］
SELECT henshu.sakka, sakka.sakkamei, henshu.sakuhin, sakuhin.sakuhinmei, kubun.kubunmei, sakuhin.kubunhosoku, henshu.han, han.hanmei, han.handai, han.kansu, han.fukanzen, han.fukanzenhosoku, henshu.henja, henja.henjamei, henshu.henshu, henshu.henjajuni, [yakusho/henshu].yakusho_ichi, [yakusho/henshu].yakusho_bunkatsu, [yakusho/henshu].yakusho_bunken, [yakusho/henshu].yakusho_shomei, [yakusho/henshu].yakusho_seriesmei, [yakusho/henshu].yakusho_label, [yakusho/henshu].yakusho_labelmei, [yakusho/henshu].yakusho_hakkobi, IIf(Left([yakusho_hakkobi],4) Like "","",Left([yakusho_hakkobi],4)) AS yakusho_hakkonen FROM (sakka RIGHT JOIN (kubun RIGHT JOIN sakuhin ON kubun.kubun = sakuhin.kubun) ON sakka.sakka = sakuhin.sakka) RIGHT JOIN (henja RIGHT JOIN (han RIGHT JOIN (henshu LEFT JOIN [yakusho/henshu] ON (henshu.han = [yakusho/henshu].han) AND (henshu.sakuhin = [yakusho/henshu].sakuhin) AND (henshu.sakka = [yakusho/henshu].sakka)) ON (han.han = henshu.han) AND (han.sakuhin = henshu.sakuhin) AND (han.sakka = henshu.sakka)) ON henja.henja = henshu.henja) ON (sakuhin.sakuhin = han.sakuhin) AND (sakuhin.sakka = han.sakka) ORDER BY henshu.sakka, henshu.sakuhin, henshu.han, henshu.henja; 

クエリ［honyakusho1］
SELECT bunken.sakka1 AS sakka, bunken.bunken FROM bunken WHERE (((bunken.sakka1) Is Not Null)) UNION SELECT bunken.sakka2, bunken.bunken FROM bunken WHERE (((bunken.sakka2) Is Not Null)) UNION SELECT shuroku.sakka, shuroku.bunken FROM shuroku GROUP BY shuroku.sakka, shuroku.bunken; 

クエリ［honyakusho2］
SELECT honyakusho1.sakka, honyakusho1.bunken, IIf([boto],[boto],"00") AS botoichi, IIf([shoshu],[shoshu],0) AS shoshusu FROM honyakusho1 LEFT JOIN [shoshu/honyakusho] ON (honyakusho1.sakka = [shoshu/honyakusho].sakka) AND (honyakusho1.bunken = [shoshu/honyakusho].bunken); 

クエリ［honyakusho3］
SELECT honyakusho2.sakka, honyakusho2.bunken AS honyakusho, bunken.henja1, henja1.henjamei AS henjamei1, bunken.henja2, henja2.henjamei AS henjamei2, bunken.henshu, bunken.seriesmei, bunken.shomei, label.labelmei, bunken.hakkobi, IIf([hakkobi] Like "","",Left([hakkobi],4)) AS hakkonen, IIf(Mid([hakkobi],6,2) Like "","",Mid([hakkobi],6,2)) AS hakkogetsu, bunken.isbn, bunken.isbnmuko, bunken.hoyu, Int([bl_bunkenvalid]) AS bunkenvalid, honyakusho2.botoichi, shuroku.shurokububun, shuroku.sakuhin, sakuhin.sakuhinmei, honyakusho2.shoshusu FROM sakuhin RIGHT JOIN (label RIGHT JOIN (han RIGHT JOIN ((((honyakusho2 LEFT JOIN bunken ON honyakusho2.bunken = bunken.bunken) LEFT JOIN shuroku ON (honyakusho2.botoichi = shuroku.ichi) AND (honyakusho2.bunken = shuroku.bunken) AND (honyakusho2.sakka = shuroku.sakka)) LEFT JOIN henja AS henja1 ON bunken.henja1 = henja1.henja) LEFT JOIN henja AS henja2 ON bunken.henja2 = henja2.henja) ON (han.han = shuroku.han) AND (han.sakuhin = shuroku.sakuhin) AND (han.sakka = shuroku.sakka)) ON label.label = bunken.label) ON (sakuhin.sakuhin = han.sakuhin) AND (sakuhin.sakka = han.sakka); 

クエリ［jidai1］
SELECT jidai.jidaikey, jidai.jidai, jidai.jidaimei, jidai.jidaikikan, jidai.bungakushi FROM jidai ORDER BY jidai.jidaikey; 

クエリ［kiji1］
SELECT kiji.kijikey, kiji.kiji, kiji.kijimei, kiji.kijimeiyomi, kiji.kijihosoku, jidai.jidaikey, kiji.jidai, jidai.jidaimei, jidai.bungakushi FROM jidai RIGHT JOIN kiji ON jidai.jidai = kiji.jidai ORDER BY kiji.kijikey; 

クエリ［kincho/henja1］
SELECT henshu.henja, han.sakka, han.sakuhin, han.han FROM han RIGHT JOIN henshu ON (han.han = henshu.han) AND (han.sakuhin = henshu.sakuhin) AND (han.sakka = henshu.sakka); 

クエリ［kincho/henja2］
SELECT [kincho/henja1].henja, shuroku.bunken FROM shuroku INNER JOIN [kincho/henja1] ON (shuroku.han = [kincho/henja1].han) AND (shuroku.sakuhin = [kincho/henja1].sakuhin) AND (shuroku.sakka = [kincho/henja1].sakka) GROUP BY [kincho/henja1].henja, shuroku.bunken UNION SELECT bunken.henja1, bunken.bunken FROM bunken LEFT JOIN henja ON bunken.henja1 = henja.henja WHERE (((henja.henja) Is Not Null)) UNION SELECT bunken.henja2, bunken.bunken FROM bunken LEFT JOIN henja ON bunken.henja2 = henja.henja WHERE (((henja.henja) Is Not Null)); 

クエリ［kincho/henja3］
SELECT [kincho/henja2].henja, Count([kincho/henja2].bunken) AS kensu, Max(bunken.hakkobi) AS kincho FROM [kincho/henja2] LEFT JOIN bunken ON [kincho/henja2].bunken = bunken.bunken GROUP BY [kincho/henja2].henja; 

クエリ［kinkan/label］
SELECT bunken.label, Count(bunken.bunken) AS kensu, Max(bunken.hakkobi) AS kinkan FROM bunken WHERE (((bunken.bl_bunkenvalid)=True)) GROUP BY bunken.label; 

クエリ［label1］
SELECT label.labelkey, label.label, label.labelmei, label.labelmeiyomi, Left([labelmeiyomi],1) AS kasira, label.shuppansha, shuppansha.shuppanshamei, Format([kensu],"000") AS kankosu, [kinkan/label].kinkan, Int([bl_ippan]) AS ippan FROM shuppansha RIGHT JOIN (label LEFT JOIN [kinkan/label] ON label.label = [kinkan/label].label) ON shuppansha.shuppansha = label.shuppansha WHERE (((Format([kensu],"000")) Not Like "") AND ((label.bl_labelvalid)=True)); 

クエリ［label2］
SELECT label1.labelkey, label1.label, label1.labelmei, label1.labelmeiyomi, label1.kasira, sakuin.sakuin, label1.shuppansha, label1.shuppanshamei, label1.kankosu, label1.kinkan, label1.ippan FROM label1 LEFT JOIN sakuin ON label1.kasira = sakuin.kasira; 

クエリ［nenpyo_botsunen］
SELECT sakka.botsunen AS nengo, sakka.botsunenhosoku AS nengohosoku, "1" AS jikenkey, "botsu" AS jiken, sakka.sakka, "" AS sakuhin, "" AS yogo, "[[K]]没" AS jikengaiyo, sakka.sakkachomei AS jikenchomei FROM sakka WHERE (((sakka.botsunen) Is Not Null) AND ((sakka.bl_sakkavalid)=True)) ORDER BY sakka.botsunen; 

クエリ［nenpyo_happyonen］
SELECT sakuhin.happyonen AS nengo, sakuhin.happyonenhosoku AS nengohosoku, "2" AS jikenkey, "happyo" AS jiken, sakuhin.sakka, sakuhin.sakuhin, "" AS yogo, [sakkamei] & "[[H]]" AS jikengaiyo, sakuhin.sakuhinchomei AS jikenchomei FROM sakka RIGHT JOIN sakuhin ON sakka.sakka = sakuhin.sakka WHERE (((sakuhin.happyonen) Is Not Null) AND ((sakuhin.bl_sakuhinvalid)=True)) ORDER BY sakuhin.happyonen; 

クエリ［nenpyo1］
SELECT nenpyo.nengo, nenpyo.nengohosoku, IIf([jiken] Like "bungaku","3","4") AS jikenkey, nenpyo.jiken, nenpyo.sakka, nenpyo.sakuhin, nenpyo.yogo, nenpyo.jikengaiyo, nenpyo.jikenchomei FROM nenpyo WHERE (((nenpyo.bl_jikenvalid)=True)) ORDER BY nenpyo.nengo; 

クエリ［nenpyo2］
SELECT nenpyo1.* FROM nenpyo1 UNION SELECT nenpyo_botsunen.* FROM nenpyo_botsunen UNION SELECT nenpyo_happyonen.* FROM nenpyo_happyonen ORDER BY nenpyo1.nengo, nenpyo1.jikenkey; 

クエリ［output_bunken］
SELECT bunken2.* FROM bunken2; 

クエリ［output_han］
SELECT han1.* FROM han1; 

クエリ［output_henja］
SELECT henja2.* FROM henja2; 

クエリ［output_henshu］
SELECT henshu1.* FROM henshu1; 

クエリ［output_honyakusho］
SELECT honyakusho3.* FROM honyakusho3; 

クエリ［output_jidai］
SELECT jidai1.* FROM jidai1; 

クエリ［output_kiji］
SELECT kiji1.* FROM kiji1; 

クエリ［output_label］
SELECT label2.* FROM label2; 

クエリ［output_nenpyo］
SELECT nenpyo2.* FROM nenpyo2; 

クエリ［output_sakka］
SELECT sakka2.* FROM sakka2; 

クエリ［output_sakuhin］
SELECT sakuhin2.* FROM sakuhin2; 

クエリ［output_sakuin］
SELECT sakuin1.* FROM sakuin1; 

クエリ［output_shuroku］
SELECT shuroku1.* FROM shuroku1; 

クエリ［output_yakucho］
SELECT yakucho3.* FROM yakucho3; 

クエリ［output_yogo］
SELECT yogo2.* FROM yogo2; 

クエリ［sakka1］
SELECT sakka.sakka, sakka.bogo, bogo.bogomei, sakka.sakkamei, sakka.sakkameiyomi, Left([sakkameiyomi],1) AS kasira, sakka.seimei, sakka.gengomei, sakka.gengomeisort, Left([gengomeisort],1) AS gengokasira, sakka.gengomeiword, sakka.sakkahosoku, jidai.jidaikey, sakka.jidai, jidai.jidaimei, sakka.seinen, sakka.seinenhosoku, sakka.botsunen, sakka.botsunenhosoku, [seinen] & [seinenhosoku] & "-" & [botsunen] & [botsunenhosoku] AS seibotsunen, sakka.sakkachomei FROM bogo RIGHT JOIN (jidai RIGHT JOIN sakka ON jidai.jidai = sakka.jidai) ON bogo.bogo = sakka.bogo WHERE (((sakka.bl_sakkavalid)=True)) ORDER BY sakka.sakka; 

クエリ［sakka2］
SELECT sakka1.sakka, sakka1.bogo, sakka1.bogomei, sakka1.sakkamei, sakka1.sakkameiyomi, sakka1.kasira, sakuin1.sakuin, sakka1.seimei, sakka1.gengomei, sakka1.gengomeisort, sakka1.gengokasira, sakuin2.sakuin AS gengosakuin, sakka1.gengomeiword, sakka1.sakkahosoku, sakka1.jidaikey, sakka1.jidai, sakka1.jidaimei, sakka1.seinen, sakka1.seinenhosoku, sakka1.botsunen, sakka1.botsunenhosoku, sakka1.seibotsunen, sakka1.sakkachomei FROM (sakka1 LEFT JOIN sakuin AS sakuin1 ON sakka1.kasira = sakuin1.kasira) LEFT JOIN sakuin AS sakuin2 ON sakka1.gengokasira = sakuin2.kasira; 

クエリ［sakuhin1］
SELECT sakuhin.sakka, sakka.sakkamei, sakka.sakkameiyomi, sakuhin.sakuhin, sakuhin.sakuhinmei, sakuhin.sakuhinmeiyomi, Left([sakuhinmeiyomi],1) AS kasira, sakuhin.gendai, sakuhin.gendaihosei, sakuhin.gendaisort, Left([gendaisort],1) AS gengokasira, sakuhin.gendaiword, sakuhin.tokatsumei, sakuhin.tokatsugendai, sakuhin.happyonen, sakuhin.happyonenhosoku, sakuhin.sakuhinchomei, sakuhin.kubun, kubun.kubunmei, sakuhin.kubunhosoku, Int([bl_daihyosaku]) AS daihyosaku, [shinyaku/sakuhin].shinyaku FROM sakka RIGHT JOIN (kubun RIGHT JOIN (sakuhin LEFT JOIN [shinyaku/sakuhin] ON (sakuhin.sakuhin = [shinyaku/sakuhin].sakuhin) AND (sakuhin.sakka = [shinyaku/sakuhin].sakka)) ON kubun.kubun = sakuhin.kubun) ON sakka.sakka = sakuhin.sakka WHERE (((sakka.bl_sakkavalid)=True) AND ((sakuhin.bl_sakuhinvalid)=True)) ORDER BY sakuhin.sakka, sakuhin.sakuhin; 

クエリ［sakuhin2］
SELECT sakuhin1.sakka, sakuhin1.sakkamei, sakuhin1.sakkameiyomi, sakuhin1.sakuhin, sakuhin1.sakuhinmei, sakuhin1.sakuhinmeiyomi, sakuhin1.kasira, sakuin1.sakuin, sakuhin1.gendai, sakuhin1.gendaihosei, sakuhin1.gendaisort, sakuhin1.gengokasira, sakuin2.sakuin AS gengosakuin, sakuhin1.gendaiword, sakuhin1.tokatsumei, sakuhin1.tokatsugendai, sakuhin1.happyonen, sakuhin1.happyonenhosoku, sakuhin1.sakuhinchomei, sakuhin1.kubun, sakuhin1.kubunmei, sakuhin1.kubunhosoku, sakuhin1.daihyosaku, sakuhin1.shinyaku FROM (sakuhin1 LEFT JOIN sakuin AS sakuin1 ON sakuhin1.kasira = sakuin1.kasira) LEFT JOIN sakuin AS sakuin2 ON sakuhin1.gengokasira = sakuin2.kasira; 

クエリ［sakuin1］
SELECT sakuin.kasira, sakuin.sakuin, sakuin.sakuinmei FROM sakuin WHERE (((sakuin.sakuinmei) Is Not Null)) ORDER BY sakuin.kasira; 

クエリ［shinyaku/sakuhin］
SELECT shuroku.sakka, shuroku.sakuhin, Max(bunken.hakkobi) AS shinyaku FROM bunken RIGHT JOIN shuroku ON bunken.bunken = shuroku.bunken GROUP BY shuroku.sakka, shuroku.sakuhin; 

クエリ［shokan/han］
SELECT shuroku.sakka, shuroku.sakuhin, shuroku.han, Max(shuroku.ichi) AS shokan_ichi, Max(shuroku.bunkatsu) AS shokan_bunkatsu, First(bunken.bunken) AS shokan_bunken, First(bunken.shomei) AS shokan_shomei, First(bunken.label) AS shokan_label, First(label.labelmei) AS shokan_labelmei, First(bunken.seriesmei) AS shokan_seriesmei, Max(bunken.hakkobi) AS shokan_hakkobi FROM label RIGHT JOIN (bunken RIGHT JOIN shuroku ON bunken.bunken = shuroku.bunken) ON label.label = bunken.label GROUP BY shuroku.sakka, shuroku.sakuhin, shuroku.han; 

クエリ［shoshu/bunken］
SELECT shuroku.bunken, Min(shuroku.ichi) AS boto, Count(shuroku.han) AS shoshu FROM shuroku GROUP BY shuroku.bunken; 

クエリ［shoshu/honyakusho］
SELECT shuroku.sakka, shuroku.bunken, Min(shuroku.ichi) AS boto, Count(shuroku.han) AS shoshu FROM shuroku GROUP BY shuroku.sakka, shuroku.bunken; 

クエリ［shuroku1］
SELECT shuroku.sakka, sakka.sakkamei, sakka.sakkameiyomi, shuroku.sakuhin, sakuhin.sakuhinmei, sakuhin.sakuhinmeiyomi, kubun.kubunmei, sakuhin.kubunhosoku, shuroku.han, han.hanmei, han.handai, han.fukanzen, han.fukanzenhosoku, shuroku.bunken, bunken.shomei, label.labelmei, bunken.seriesmei, bunken.hakkobi, IIf([hakkobi] Like "","",Left([hakkobi],4)) AS hakkonen, shuroku.ichi, shuroku.bunkatsu, shuroku.bunkatsumei, shuroku.shurokububun FROM (sakka RIGHT JOIN (kubun RIGHT JOIN sakuhin ON kubun.kubun = sakuhin.kubun) ON sakka.sakka = sakuhin.sakka) RIGHT JOIN (label RIGHT JOIN (han RIGHT JOIN (bunken RIGHT JOIN shuroku ON bunken.bunken = shuroku.bunken) ON (han.han = shuroku.han) AND (han.sakuhin = shuroku.sakuhin) AND (han.sakka = shuroku.sakka)) ON label.label = bunken.label) ON (sakuhin.sakuhin = han.sakuhin) AND (sakuhin.sakka = han.sakka) ORDER BY shuroku.sakka, shuroku.sakuhin, shuroku.han, shuroku.bunken; 

クエリ［yakucho1］
SELECT henshu.henja, han.sakka, han.sakuhin, han.han FROM han RIGHT JOIN henshu ON (han.han = henshu.han) AND (han.sakuhin = henshu.sakuhin) AND (han.sakka = henshu.sakka); 

クエリ［yakucho2］
SELECT yakucho1.henja, shuroku.bunken FROM shuroku INNER JOIN yakucho1 ON (shuroku.sakka = yakucho1.sakka) AND (shuroku.sakuhin = yakucho1.sakuhin) AND (shuroku.han = yakucho1.han) GROUP BY yakucho1.henja, shuroku.bunken UNION SELECT bunken.henja1, bunken.bunken FROM bunken GROUP BY bunken.henja1, bunken.bunken HAVING (((bunken.henja1) Is Not Null)) UNION SELECT bunken.henja2, bunken.bunken FROM bunken GROUP BY bunken.henja2, bunken.bunken HAVING (((bunken.henja2) Is Not Null)); 

クエリ［yakucho3］
SELECT yakucho2.henja, henja.henjamei, yakucho2.bunken, bunken.sakka1, sakka1.sakkamei AS sakkamei1, bunken.sakka2, sakka2.sakkamei AS sakkamei2, bunken.shomei, bunken.label, label.labelmei, bunken.hakkobi, IIf(Left([hakkobi],4) Like "","",Left([hakkobi],4)) AS hakkonen, IIf(Mid([hakkobi],6,2) Like "","",Mid([hakkobi],6,2)) AS hakkogetsu, bunken.isbn, bunken.isbnmuko, Int([bl_bunkenvalid]) AS bunkenvalid FROM label RIGHT JOIN ((((yakucho2 LEFT JOIN henja ON yakucho2.henja = henja.henja) LEFT JOIN bunken ON yakucho2.bunken = bunken.bunken) LEFT JOIN sakka AS sakka1 ON bunken.sakka1 = sakka1.sakka) LEFT JOIN sakka AS sakka2 ON bunken.sakka2 = sakka2.sakka) ON label.label = bunken.label; 

クエリ［yakusho/henshu］
SELECT shuroku.sakka, shuroku.sakuhin, shuroku.han, First(shuroku.ichi) AS yakusho_ichi, Max(shuroku.bunkatsu) AS yakusho_bunkatsu, First(bunken.bunken) AS yakusho_bunken, First(bunken.shomei) AS yakusho_shomei, First(bunken.seriesmei) AS yakusho_seriesmei, First(bunken.label) AS yakusho_label, First(label.labelmei) AS yakusho_labelmei, Max(bunken.hakkobi) AS yakusho_hakkobi FROM label RIGHT JOIN (bunken RIGHT JOIN shuroku ON bunken.bunken = shuroku.bunken) ON label.label = bunken.label GROUP BY shuroku.sakka, shuroku.sakuhin, shuroku.han; 

クエリ［yogo1］
SELECT yogo.yogo, yogo.yogomei, yogo.yogomeiyomi, Left([yogomeiyomi],1) AS kasira, yogo.yogogengo, yogo.yogogengosort, Left([yogogengosort],1) AS gengokasira, yogo.yogogengoword, yogo.yogogaiyo, yogo.yogochomei, jidai.jidaikey, yogo.jidai, jidai.jidaimei, jidai.bungakushi FROM jidai RIGHT JOIN yogo ON jidai.jidai = yogo.jidai WHERE (((yogo.bl_yogovalid)=True)) ORDER BY yogo.yogo; 

クエリ［yogo2］
SELECT yogo1.yogo, yogo1.yogomei, yogo1.yogomeiyomi, yogo1.kasira, sakuin1.sakuin, yogo1.yogogengo, yogo1.yogogengosort, yogo1.gengokasira, sakuin2.sakuin AS gengosakuin, yogo1.yogogengoword, yogo1.yogogaiyo, yogo1.yogochomei, yogo1.jidaikey, yogo1.jidai, yogo1.jidaimei, yogo1.bungakushi FROM (yogo1 LEFT JOIN sakuin AS sakuin1 ON yogo1.kasira = sakuin1.kasira) LEFT JOIN sakuin AS sakuin2 ON yogo1.gengokasira = sakuin2.kasira; 

2023-08-14