論文要旨（Abstract）一覧
SELECT
paper.paper_id,
paper_title,
paperUser_name1,
paperUser_name2,
paperUser_prefix,
paperUser_englishName3,
paperUser_englishName2,
paperUser_englishName1,
paperUser_degree,
paperUser_englishDegree,
paperUser_groups1,
paperUser_groups2,
paperContribution_abstractFile,
paperUser.member_id,
member_family_name,
member_first_name,
member_office,
member_office_unit,
(CASE WHEN paperUser.member_id != 0 THEN member.member_family_name_kana
ELSE paperUser.paperUser_kana1 END) as kana1,
(CASE WHEN paperUser.member_id != 0 THEN member.member_first_name_kana
ELSE paperUser.paperUser_kana2 END) as kana2
FROM `paper` left join (
( select * from
(SELECT MAX(paperContribution_id) as maxpcid FROM
paperContribution where `paperContribution_abstractFile` != '' group by paper_id
) as sortpc left join (
paperContribution
) on paperContribution.paperContribution_id = sortpc.maxpcid
)as abstructs left join (paperUser left join member on member.member_id = paperUser.member_id) on abstructs.paperUser_id = paperUser.paperUser_id
) on paper.paper_id = abstructs.paper_id
where paper_abstractStatus = 3 AND (paper_status != 4 AND paper_status != 6)AND ( paper.paperCategory_id = 17 OR paper.paperCategory_id = 18) order by kana1 ASC, kana2 ASC