ビジネスに特化したクオリティの高いセミナーや研修が見つかる! 会員登録をしてセミナーに申し込むとさまざまな特典が受けられます
掲載の記事・写真・図表などの無断転載を禁止します。
著作権は株式会社ファシオまたはその情報提供者に属します。
著作権は株式会社ファシオまたはその情報提供者に属します。
Copyright(c)2016.Facio Inc,.All Rights Reserved.
BC_PR110011_01.php(200)
PDOException Object
(
[message:protected] => SQLSTATE[HY000]: General error: 1016 Can't open file: '/tmp/#sql7dc9_eb18a_3.frm' (errno: 24 - Too many open files)
[string:Exception:private] =>
[code:protected] => HY000
[file:protected] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/procedure/BC_PR110011_01.php
[line:protected] => 134
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/procedure/BC_PR110011_01.php
[line] => 134
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
)
)
[1] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/TeikeiIchiranController.php
[line] => 532
[function] => BC_PR110011_01
[args] => Array
(
[0] =>
[1] =>
[2] => 20250207
[3] => 20250506
[4] =>
[5] =>
[6] => 0
[7] => 100000000
[8] => 00
[9] => 99
[10] => 00
[11] => 99
[12] => 000
[13] => 999
[14] => 0000
[15] => 9999
[16] => 1
[17] => 0
[18] => 0
[19] =>
)
)
[2] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/core/dispatch.php
[line] => 48
[function] => index
[class] => TeikeiIchiranController
[type] => ->
[args] => Array
(
)
)
[3] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
[line] => 14
[function] => dispatch
[class] => CDispatch
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/index.php
[line] => 4
[args] => Array
(
[0] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
)
[function] => include
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => HY000
[1] => 1016
[2] => Can't open file: '/tmp/#sql7dc9_eb18a_3.frm' (errno: 24 - Too many open files)
)
)
BC_SA050002_01.php(340)
Exception Object
(
[message:protected] => Out of resources when opening file './bcseminar/subcategory.MYD' (Errcode: 24 - Too many open files) [
SELECT
sr.SeminarCompanyID as SeminarCompanyID,
concat( SUBSTR(sr.SeminarCompanyID, 1, 5) ,
concat( ' - ' , SUBSTR( sr.SeminarCompanyID, 6, 4 ) )
) as SeminarCompanyIDDash,
sc.CompanyNameKanji as CompanyNameKanji,
sc.HomePageURL as SCHomePageURL,
sc.PaidType as SCPaidTypeValue,
sr.SeminarID as SeminarID,
sr.ApplicationStateID as ApplicationStateID,
CASE sr.ApplicationStateID
WHEN '01' THEN '登録中'
WHEN '02' THEN '登録申請'
WHEN '03' THEN '登録承認'
WHEN '04' THEN '更新中'
WHEN '05' THEN '更新申請'
WHEN '06' THEN '更新承認'
WHEN '07' THEN '登録申請拒否'
WHEN '08' THEN '更新申請拒否'
ELSE ''
END as ApplicationStateIDName,
sr.PrintStateID as PrintStateID,
CASE sr.PrintStateID
WHEN '01' THEN '掲載前'
WHEN '02' THEN '受付前'
WHEN '03' THEN '受付中'
WHEN '04' THEN '受付完了'
WHEN '05' THEN '開催完了'
WHEN '06' THEN '掲載完了'
ELSE ''
END as PrintStateIDName,
sr.HostCompanyName as HostCompanyName,
CASE sr.SeminarName
WHEN '*' THEN ''
ELSE sr.SeminarName
END as SeminarName,
sr.SubTitle as SubTitle,
CASE sr.SeminarOutline
WHEN '*' THEN ''
ELSE sr.SeminarOutline
END as SeminarOutline,
CASE sr.SeminarDetails
WHEN '*' THEN ''
ELSE sr.SeminarDetails
END as SeminarDetails,
(SELECT
CASE MIN(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MIN(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as StartDate,
(SELECT
CASE MAX(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MAX(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as EndDate,
CASE sr.ApplicationReceptionStartDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionStartDate
END as ApplicationReceptionStartDate,
CASE sr.ApplicationReceptionEndDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionEndDate
END as ApplicationReceptionEndDate,
sr.LocalID as LocalID,
(SELECT
lc.LocalName
FROM
local lc
WHERE
lc.DelFlag = '0' AND
lc.LocalID = sr.LocalID
) as LocalIDName,
sr.CategoryID as CategoryID,
(SELECT
cg.CategoryName
FROM
category cg
WHERE
cg.DelFlag = '0' AND
cg.CategoryID = sr.CategoryID
) as CategoryIDName,
sr.SubCategoryID as SubCategoryID,
(SELECT
scg.SubCategoryName
FROM
subcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubCategoryIDName,
sr.SubSubCategoryID as SubSubCategoryID,
(SELECT
scg.SubSubCategoryName
FROM
subsubcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubSubCategoryID = sr.SubSubCategoryID AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubSubCategoryIDName,
sr.JobTypeID as JobTypeID,
(SELECT
jt.JobTypeName
FROM
jobtype jt
WHERE
jt.DelFlag = '0' AND
jt.JobTypeID = sr.JobTypeID
) as JobTypeIDName,
sr.IndustryTypeID as IndustryTypeID,
(SELECT
it.IndustryTypeName
FROM
industrytype it
WHERE
it.DelFlag = '0' AND
it.IndustryTypeID = sr.IndustryTypeID
) as IndustryTypeIDName,
CASE IFNULL(sr.QuotaNum, '')
WHEN '' THEN '0'
ELSE sr.QuotaNum
END as QuotaNum,
(SELECT
CASE IFNULL( SUM(sa.SeminarAppNum), '')
WHEN '' THEN '0'
ELSE SUM(sa.SeminarAppNum)
END
FROM
seminarapp sa
WHERE
sa.DelFlag = '0' AND
sa.SeminarID = sr.SeminarID
) as SeminarAppNum,
sr.ReceiveNum as ReceiveNum,
sr.ConditionQualifying as ConditionQualifying,
sr.Property as Property,
sr.ParticipationCost1 as ParticipationCost1,
sr.ParticipationForm1 as ParticipationForm1,
sr.ParticipationCost2 as ParticipationCost2,
sr.ParticipationForm2 as ParticipationForm2,
CASE sr.HallName
WHEN '*' THEN ''
ELSE sr.HallName
END as HallName,
sr.HallAccess as HallAccess,
sr.HallPostal1 as HallPostal1,
sr.HallPostal2 as HallPostal2,
sr.HallAdministrativeDivisionsID as HallAdministrativeDivisionsID,
(SELECT
ad.AdministrativeDivisionsName
FROM
administrativedivisions ad
WHERE
ad.DelFlag = '0' AND
ad.LocalID = sr.LocalID AND
ad.AdministrativeDivisionsID = sr.HallAdministrativeDivisionsID
) as HallAdministrativeDivisionsIDName,
CASE sr.HallAddress
WHEN '*' THEN ''
ELSE sr.HallAddress
END as HallAddress,
sr.HallBuildingNameEtc as HallBuildingNameEtc,
sr.Map as Map,
sr.Information as Information,
sr.AttendantComment as AttendantComment,
sr.Purpose as Purpose,
sr.TakingLecObject as TakingLecObject,
sr.SpecialFavor as SpecialFavor,
sr.Icon01Flag as Icon01Flag,
sr.Icon02Flag as Icon02Flag,
sr.Icon03Flag as Icon03Flag,
sr.Icon04Flag as Icon04Flag,
sr.Icon05Flag as Icon05Flag,
sr.Icon06Flag as Icon06Flag,
sr.Icon07Flag as Icon07Flag,
sr.Icon08Flag as Icon08Flag,
sr.Icon09Flag as Icon09Flag,
sr.Icon10Flag as Icon10Flag,
sr.ConceptPicture as ConceptPicture,
sr.AttendantPicture as AttendantPicture,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial01
else ''
end as LectureBeforeMaterial01,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial02
else ''
end as LectureBeforeMaterial02,
sr.LectureBeforeAnimation as LectureBeforeAnimation,
sr.LectureAfterMaterial01 as LectureAfterMaterial01,
sr.LectureAfterMaterial02 as LectureAfterMaterial02,
sr.LectureAfterAnimation as LectureAfterAnimation,
sr.LBMSumary01 as LBMSumary01,
sr.LBMSumary02 as LBMSumary02,
sr.LBASumary as LBASumary,
sr.LAMSumary01 as LAMSumary01,
sr.LAMSumary02 as LAMSumary02,
sr.LAASumary as LAASumary,
sr.RegistDate as RegistDate,
sr.RegistUserID as RegistUserID,
sr.ModDate as ModDate,
sr.ModUserID as ModUserID,
sr.DelFlag as DelFlag,
sr.PSurlFlg as PSurlFlg,
sr.PSurlValue as PSurlValue,
sr.SMPaidTypeOpt as SMPaidTypeOpt,
sr.SMPaidTypeValue as SMPaidTypeValue,
sr.MailMagazineUsingFlag4SM as MailMagazineFlag,
sc.ClickLimitOverFlag as ClickLimitOverFlag,
sr.IntroSemiChargeValue as IntroSemiChargeValue,
sr.ApplicationReceptionStartFlag,
sr.DeliveruFlg,sr.DeliveruUrl,sr.FrontIndexFlg
FROM
seminar sr INNER JOIN
seminarcompany sc ON sc.SeminarCompanyID = sr.SeminarCompanyID AND sc.DelFlag = '0'
WHERE
sr.DelFlag = '0' AND
sr.SeminarCompanyID = '102270000' AND
sr.SeminarID = '000005982'] time:[0.0039660930633545]
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/connect/databese.php
[line:protected] => 106
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/procedure/BC_SA050002_01.php
[line] => 298
[function] => query
[args] => Array
(
[0] =>
SELECT
sr.SeminarCompanyID as SeminarCompanyID,
concat( SUBSTR(sr.SeminarCompanyID, 1, 5) ,
concat( ' - ' , SUBSTR( sr.SeminarCompanyID, 6, 4 ) )
) as SeminarCompanyIDDash,
sc.CompanyNameKanji as CompanyNameKanji,
sc.HomePageURL as SCHomePageURL,
sc.PaidType as SCPaidTypeValue,
sr.SeminarID as SeminarID,
sr.ApplicationStateID as ApplicationStateID,
CASE sr.ApplicationStateID
WHEN '01' THEN '登録中'
WHEN '02' THEN '登録申請'
WHEN '03' THEN '登録承認'
WHEN '04' THEN '更新中'
WHEN '05' THEN '更新申請'
WHEN '06' THEN '更新承認'
WHEN '07' THEN '登録申請拒否'
WHEN '08' THEN '更新申請拒否'
ELSE ''
END as ApplicationStateIDName,
sr.PrintStateID as PrintStateID,
CASE sr.PrintStateID
WHEN '01' THEN '掲載前'
WHEN '02' THEN '受付前'
WHEN '03' THEN '受付中'
WHEN '04' THEN '受付完了'
WHEN '05' THEN '開催完了'
WHEN '06' THEN '掲載完了'
ELSE ''
END as PrintStateIDName,
sr.HostCompanyName as HostCompanyName,
CASE sr.SeminarName
WHEN '*' THEN ''
ELSE sr.SeminarName
END as SeminarName,
sr.SubTitle as SubTitle,
CASE sr.SeminarOutline
WHEN '*' THEN ''
ELSE sr.SeminarOutline
END as SeminarOutline,
CASE sr.SeminarDetails
WHEN '*' THEN ''
ELSE sr.SeminarDetails
END as SeminarDetails,
(SELECT
CASE MIN(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MIN(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as StartDate,
(SELECT
CASE MAX(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MAX(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as EndDate,
CASE sr.ApplicationReceptionStartDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionStartDate
END as ApplicationReceptionStartDate,
CASE sr.ApplicationReceptionEndDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionEndDate
END as ApplicationReceptionEndDate,
sr.LocalID as LocalID,
(SELECT
lc.LocalName
FROM
local lc
WHERE
lc.DelFlag = '0' AND
lc.LocalID = sr.LocalID
) as LocalIDName,
sr.CategoryID as CategoryID,
(SELECT
cg.CategoryName
FROM
category cg
WHERE
cg.DelFlag = '0' AND
cg.CategoryID = sr.CategoryID
) as CategoryIDName,
sr.SubCategoryID as SubCategoryID,
(SELECT
scg.SubCategoryName
FROM
subcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubCategoryIDName,
sr.SubSubCategoryID as SubSubCategoryID,
(SELECT
scg.SubSubCategoryName
FROM
subsubcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubSubCategoryID = sr.SubSubCategoryID AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubSubCategoryIDName,
sr.JobTypeID as JobTypeID,
(SELECT
jt.JobTypeName
FROM
jobtype jt
WHERE
jt.DelFlag = '0' AND
jt.JobTypeID = sr.JobTypeID
) as JobTypeIDName,
sr.IndustryTypeID as IndustryTypeID,
(SELECT
it.IndustryTypeName
FROM
industrytype it
WHERE
it.DelFlag = '0' AND
it.IndustryTypeID = sr.IndustryTypeID
) as IndustryTypeIDName,
CASE IFNULL(sr.QuotaNum, '')
WHEN '' THEN '0'
ELSE sr.QuotaNum
END as QuotaNum,
(SELECT
CASE IFNULL( SUM(sa.SeminarAppNum), '')
WHEN '' THEN '0'
ELSE SUM(sa.SeminarAppNum)
END
FROM
seminarapp sa
WHERE
sa.DelFlag = '0' AND
sa.SeminarID = sr.SeminarID
) as SeminarAppNum,
sr.ReceiveNum as ReceiveNum,
sr.ConditionQualifying as ConditionQualifying,
sr.Property as Property,
sr.ParticipationCost1 as ParticipationCost1,
sr.ParticipationForm1 as ParticipationForm1,
sr.ParticipationCost2 as ParticipationCost2,
sr.ParticipationForm2 as ParticipationForm2,
CASE sr.HallName
WHEN '*' THEN ''
ELSE sr.HallName
END as HallName,
sr.HallAccess as HallAccess,
sr.HallPostal1 as HallPostal1,
sr.HallPostal2 as HallPostal2,
sr.HallAdministrativeDivisionsID as HallAdministrativeDivisionsID,
(SELECT
ad.AdministrativeDivisionsName
FROM
administrativedivisions ad
WHERE
ad.DelFlag = '0' AND
ad.LocalID = sr.LocalID AND
ad.AdministrativeDivisionsID = sr.HallAdministrativeDivisionsID
) as HallAdministrativeDivisionsIDName,
CASE sr.HallAddress
WHEN '*' THEN ''
ELSE sr.HallAddress
END as HallAddress,
sr.HallBuildingNameEtc as HallBuildingNameEtc,
sr.Map as Map,
sr.Information as Information,
sr.AttendantComment as AttendantComment,
sr.Purpose as Purpose,
sr.TakingLecObject as TakingLecObject,
sr.SpecialFavor as SpecialFavor,
sr.Icon01Flag as Icon01Flag,
sr.Icon02Flag as Icon02Flag,
sr.Icon03Flag as Icon03Flag,
sr.Icon04Flag as Icon04Flag,
sr.Icon05Flag as Icon05Flag,
sr.Icon06Flag as Icon06Flag,
sr.Icon07Flag as Icon07Flag,
sr.Icon08Flag as Icon08Flag,
sr.Icon09Flag as Icon09Flag,
sr.Icon10Flag as Icon10Flag,
sr.ConceptPicture as ConceptPicture,
sr.AttendantPicture as AttendantPicture,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial01
else ''
end as LectureBeforeMaterial01,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial02
else ''
end as LectureBeforeMaterial02,
sr.LectureBeforeAnimation as LectureBeforeAnimation,
sr.LectureAfterMaterial01 as LectureAfterMaterial01,
sr.LectureAfterMaterial02 as LectureAfterMaterial02,
sr.LectureAfterAnimation as LectureAfterAnimation,
sr.LBMSumary01 as LBMSumary01,
sr.LBMSumary02 as LBMSumary02,
sr.LBASumary as LBASumary,
sr.LAMSumary01 as LAMSumary01,
sr.LAMSumary02 as LAMSumary02,
sr.LAASumary as LAASumary,
sr.RegistDate as RegistDate,
sr.RegistUserID as RegistUserID,
sr.ModDate as ModDate,
sr.ModUserID as ModUserID,
sr.DelFlag as DelFlag,
sr.PSurlFlg as PSurlFlg,
sr.PSurlValue as PSurlValue,
sr.SMPaidTypeOpt as SMPaidTypeOpt,
sr.SMPaidTypeValue as SMPaidTypeValue,
sr.MailMagazineUsingFlag4SM as MailMagazineFlag,
sc.ClickLimitOverFlag as ClickLimitOverFlag,
sr.IntroSemiChargeValue as IntroSemiChargeValue,
sr.ApplicationReceptionStartFlag,
sr.DeliveruFlg,sr.DeliveruUrl,sr.FrontIndexFlg
FROM
seminar sr INNER JOIN
seminarcompany sc ON sc.SeminarCompanyID = sr.SeminarCompanyID AND sc.DelFlag = '0'
WHERE
sr.DelFlag = '0' AND
sr.SeminarCompanyID = '102270000' AND
sr.SeminarID = '000005982'
)
)
[1] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/TeikeiIchiranController.php
[line] => 848
[function] => BC_SA050002_01
[args] => Array
(
[0] => 102270000
[1] => 000005982
)
)
[2] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/TeikeiIchiranController.php
[line] => 562
[function] => setSeminarAdvertise
[class] => TeikeiIchiranController
[type] => ->
[args] => Array
(
[0] => 01
[1] => 99
[2] => ?mg=zeikai
)
)
[3] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/core/dispatch.php
[line] => 48
[function] => index
[class] => TeikeiIchiranController
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
[line] => 14
[function] => dispatch
[class] => CDispatch
[type] => ->
[args] => Array
(
)
)
[5] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/index.php
[line] => 4
[args] => Array
(
[0] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
)
[function] => include
)
)
[previous:Exception:private] =>
)
BC_SA050002_01.php(340)
Exception Object
(
[message:protected] => Out of resources when opening file './bcseminar/subcategory.MYD' (Errcode: 24 - Too many open files) [
SELECT
sr.SeminarCompanyID as SeminarCompanyID,
concat( SUBSTR(sr.SeminarCompanyID, 1, 5) ,
concat( ' - ' , SUBSTR( sr.SeminarCompanyID, 6, 4 ) )
) as SeminarCompanyIDDash,
sc.CompanyNameKanji as CompanyNameKanji,
sc.HomePageURL as SCHomePageURL,
sc.PaidType as SCPaidTypeValue,
sr.SeminarID as SeminarID,
sr.ApplicationStateID as ApplicationStateID,
CASE sr.ApplicationStateID
WHEN '01' THEN '登録中'
WHEN '02' THEN '登録申請'
WHEN '03' THEN '登録承認'
WHEN '04' THEN '更新中'
WHEN '05' THEN '更新申請'
WHEN '06' THEN '更新承認'
WHEN '07' THEN '登録申請拒否'
WHEN '08' THEN '更新申請拒否'
ELSE ''
END as ApplicationStateIDName,
sr.PrintStateID as PrintStateID,
CASE sr.PrintStateID
WHEN '01' THEN '掲載前'
WHEN '02' THEN '受付前'
WHEN '03' THEN '受付中'
WHEN '04' THEN '受付完了'
WHEN '05' THEN '開催完了'
WHEN '06' THEN '掲載完了'
ELSE ''
END as PrintStateIDName,
sr.HostCompanyName as HostCompanyName,
CASE sr.SeminarName
WHEN '*' THEN ''
ELSE sr.SeminarName
END as SeminarName,
sr.SubTitle as SubTitle,
CASE sr.SeminarOutline
WHEN '*' THEN ''
ELSE sr.SeminarOutline
END as SeminarOutline,
CASE sr.SeminarDetails
WHEN '*' THEN ''
ELSE sr.SeminarDetails
END as SeminarDetails,
(SELECT
CASE MIN(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MIN(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as StartDate,
(SELECT
CASE MAX(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MAX(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as EndDate,
CASE sr.ApplicationReceptionStartDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionStartDate
END as ApplicationReceptionStartDate,
CASE sr.ApplicationReceptionEndDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionEndDate
END as ApplicationReceptionEndDate,
sr.LocalID as LocalID,
(SELECT
lc.LocalName
FROM
local lc
WHERE
lc.DelFlag = '0' AND
lc.LocalID = sr.LocalID
) as LocalIDName,
sr.CategoryID as CategoryID,
(SELECT
cg.CategoryName
FROM
category cg
WHERE
cg.DelFlag = '0' AND
cg.CategoryID = sr.CategoryID
) as CategoryIDName,
sr.SubCategoryID as SubCategoryID,
(SELECT
scg.SubCategoryName
FROM
subcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubCategoryIDName,
sr.SubSubCategoryID as SubSubCategoryID,
(SELECT
scg.SubSubCategoryName
FROM
subsubcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubSubCategoryID = sr.SubSubCategoryID AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubSubCategoryIDName,
sr.JobTypeID as JobTypeID,
(SELECT
jt.JobTypeName
FROM
jobtype jt
WHERE
jt.DelFlag = '0' AND
jt.JobTypeID = sr.JobTypeID
) as JobTypeIDName,
sr.IndustryTypeID as IndustryTypeID,
(SELECT
it.IndustryTypeName
FROM
industrytype it
WHERE
it.DelFlag = '0' AND
it.IndustryTypeID = sr.IndustryTypeID
) as IndustryTypeIDName,
CASE IFNULL(sr.QuotaNum, '')
WHEN '' THEN '0'
ELSE sr.QuotaNum
END as QuotaNum,
(SELECT
CASE IFNULL( SUM(sa.SeminarAppNum), '')
WHEN '' THEN '0'
ELSE SUM(sa.SeminarAppNum)
END
FROM
seminarapp sa
WHERE
sa.DelFlag = '0' AND
sa.SeminarID = sr.SeminarID
) as SeminarAppNum,
sr.ReceiveNum as ReceiveNum,
sr.ConditionQualifying as ConditionQualifying,
sr.Property as Property,
sr.ParticipationCost1 as ParticipationCost1,
sr.ParticipationForm1 as ParticipationForm1,
sr.ParticipationCost2 as ParticipationCost2,
sr.ParticipationForm2 as ParticipationForm2,
CASE sr.HallName
WHEN '*' THEN ''
ELSE sr.HallName
END as HallName,
sr.HallAccess as HallAccess,
sr.HallPostal1 as HallPostal1,
sr.HallPostal2 as HallPostal2,
sr.HallAdministrativeDivisionsID as HallAdministrativeDivisionsID,
(SELECT
ad.AdministrativeDivisionsName
FROM
administrativedivisions ad
WHERE
ad.DelFlag = '0' AND
ad.LocalID = sr.LocalID AND
ad.AdministrativeDivisionsID = sr.HallAdministrativeDivisionsID
) as HallAdministrativeDivisionsIDName,
CASE sr.HallAddress
WHEN '*' THEN ''
ELSE sr.HallAddress
END as HallAddress,
sr.HallBuildingNameEtc as HallBuildingNameEtc,
sr.Map as Map,
sr.Information as Information,
sr.AttendantComment as AttendantComment,
sr.Purpose as Purpose,
sr.TakingLecObject as TakingLecObject,
sr.SpecialFavor as SpecialFavor,
sr.Icon01Flag as Icon01Flag,
sr.Icon02Flag as Icon02Flag,
sr.Icon03Flag as Icon03Flag,
sr.Icon04Flag as Icon04Flag,
sr.Icon05Flag as Icon05Flag,
sr.Icon06Flag as Icon06Flag,
sr.Icon07Flag as Icon07Flag,
sr.Icon08Flag as Icon08Flag,
sr.Icon09Flag as Icon09Flag,
sr.Icon10Flag as Icon10Flag,
sr.ConceptPicture as ConceptPicture,
sr.AttendantPicture as AttendantPicture,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial01
else ''
end as LectureBeforeMaterial01,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial02
else ''
end as LectureBeforeMaterial02,
sr.LectureBeforeAnimation as LectureBeforeAnimation,
sr.LectureAfterMaterial01 as LectureAfterMaterial01,
sr.LectureAfterMaterial02 as LectureAfterMaterial02,
sr.LectureAfterAnimation as LectureAfterAnimation,
sr.LBMSumary01 as LBMSumary01,
sr.LBMSumary02 as LBMSumary02,
sr.LBASumary as LBASumary,
sr.LAMSumary01 as LAMSumary01,
sr.LAMSumary02 as LAMSumary02,
sr.LAASumary as LAASumary,
sr.RegistDate as RegistDate,
sr.RegistUserID as RegistUserID,
sr.ModDate as ModDate,
sr.ModUserID as ModUserID,
sr.DelFlag as DelFlag,
sr.PSurlFlg as PSurlFlg,
sr.PSurlValue as PSurlValue,
sr.SMPaidTypeOpt as SMPaidTypeOpt,
sr.SMPaidTypeValue as SMPaidTypeValue,
sr.MailMagazineUsingFlag4SM as MailMagazineFlag,
sc.ClickLimitOverFlag as ClickLimitOverFlag,
sr.IntroSemiChargeValue as IntroSemiChargeValue,
sr.ApplicationReceptionStartFlag,
sr.DeliveruFlg,sr.DeliveruUrl,sr.FrontIndexFlg
FROM
seminar sr INNER JOIN
seminarcompany sc ON sc.SeminarCompanyID = sr.SeminarCompanyID AND sc.DelFlag = '0'
WHERE
sr.DelFlag = '0' AND
sr.SeminarCompanyID = '201020000' AND
sr.SeminarID = '000005341'] time:[0.00076889991760254]
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/connect/databese.php
[line:protected] => 106
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/procedure/BC_SA050002_01.php
[line] => 298
[function] => query
[args] => Array
(
[0] =>
SELECT
sr.SeminarCompanyID as SeminarCompanyID,
concat( SUBSTR(sr.SeminarCompanyID, 1, 5) ,
concat( ' - ' , SUBSTR( sr.SeminarCompanyID, 6, 4 ) )
) as SeminarCompanyIDDash,
sc.CompanyNameKanji as CompanyNameKanji,
sc.HomePageURL as SCHomePageURL,
sc.PaidType as SCPaidTypeValue,
sr.SeminarID as SeminarID,
sr.ApplicationStateID as ApplicationStateID,
CASE sr.ApplicationStateID
WHEN '01' THEN '登録中'
WHEN '02' THEN '登録申請'
WHEN '03' THEN '登録承認'
WHEN '04' THEN '更新中'
WHEN '05' THEN '更新申請'
WHEN '06' THEN '更新承認'
WHEN '07' THEN '登録申請拒否'
WHEN '08' THEN '更新申請拒否'
ELSE ''
END as ApplicationStateIDName,
sr.PrintStateID as PrintStateID,
CASE sr.PrintStateID
WHEN '01' THEN '掲載前'
WHEN '02' THEN '受付前'
WHEN '03' THEN '受付中'
WHEN '04' THEN '受付完了'
WHEN '05' THEN '開催完了'
WHEN '06' THEN '掲載完了'
ELSE ''
END as PrintStateIDName,
sr.HostCompanyName as HostCompanyName,
CASE sr.SeminarName
WHEN '*' THEN ''
ELSE sr.SeminarName
END as SeminarName,
sr.SubTitle as SubTitle,
CASE sr.SeminarOutline
WHEN '*' THEN ''
ELSE sr.SeminarOutline
END as SeminarOutline,
CASE sr.SeminarDetails
WHEN '*' THEN ''
ELSE sr.SeminarDetails
END as SeminarDetails,
(SELECT
CASE MIN(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MIN(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as StartDate,
(SELECT
CASE MAX(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MAX(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as EndDate,
CASE sr.ApplicationReceptionStartDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionStartDate
END as ApplicationReceptionStartDate,
CASE sr.ApplicationReceptionEndDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionEndDate
END as ApplicationReceptionEndDate,
sr.LocalID as LocalID,
(SELECT
lc.LocalName
FROM
local lc
WHERE
lc.DelFlag = '0' AND
lc.LocalID = sr.LocalID
) as LocalIDName,
sr.CategoryID as CategoryID,
(SELECT
cg.CategoryName
FROM
category cg
WHERE
cg.DelFlag = '0' AND
cg.CategoryID = sr.CategoryID
) as CategoryIDName,
sr.SubCategoryID as SubCategoryID,
(SELECT
scg.SubCategoryName
FROM
subcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubCategoryIDName,
sr.SubSubCategoryID as SubSubCategoryID,
(SELECT
scg.SubSubCategoryName
FROM
subsubcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubSubCategoryID = sr.SubSubCategoryID AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubSubCategoryIDName,
sr.JobTypeID as JobTypeID,
(SELECT
jt.JobTypeName
FROM
jobtype jt
WHERE
jt.DelFlag = '0' AND
jt.JobTypeID = sr.JobTypeID
) as JobTypeIDName,
sr.IndustryTypeID as IndustryTypeID,
(SELECT
it.IndustryTypeName
FROM
industrytype it
WHERE
it.DelFlag = '0' AND
it.IndustryTypeID = sr.IndustryTypeID
) as IndustryTypeIDName,
CASE IFNULL(sr.QuotaNum, '')
WHEN '' THEN '0'
ELSE sr.QuotaNum
END as QuotaNum,
(SELECT
CASE IFNULL( SUM(sa.SeminarAppNum), '')
WHEN '' THEN '0'
ELSE SUM(sa.SeminarAppNum)
END
FROM
seminarapp sa
WHERE
sa.DelFlag = '0' AND
sa.SeminarID = sr.SeminarID
) as SeminarAppNum,
sr.ReceiveNum as ReceiveNum,
sr.ConditionQualifying as ConditionQualifying,
sr.Property as Property,
sr.ParticipationCost1 as ParticipationCost1,
sr.ParticipationForm1 as ParticipationForm1,
sr.ParticipationCost2 as ParticipationCost2,
sr.ParticipationForm2 as ParticipationForm2,
CASE sr.HallName
WHEN '*' THEN ''
ELSE sr.HallName
END as HallName,
sr.HallAccess as HallAccess,
sr.HallPostal1 as HallPostal1,
sr.HallPostal2 as HallPostal2,
sr.HallAdministrativeDivisionsID as HallAdministrativeDivisionsID,
(SELECT
ad.AdministrativeDivisionsName
FROM
administrativedivisions ad
WHERE
ad.DelFlag = '0' AND
ad.LocalID = sr.LocalID AND
ad.AdministrativeDivisionsID = sr.HallAdministrativeDivisionsID
) as HallAdministrativeDivisionsIDName,
CASE sr.HallAddress
WHEN '*' THEN ''
ELSE sr.HallAddress
END as HallAddress,
sr.HallBuildingNameEtc as HallBuildingNameEtc,
sr.Map as Map,
sr.Information as Information,
sr.AttendantComment as AttendantComment,
sr.Purpose as Purpose,
sr.TakingLecObject as TakingLecObject,
sr.SpecialFavor as SpecialFavor,
sr.Icon01Flag as Icon01Flag,
sr.Icon02Flag as Icon02Flag,
sr.Icon03Flag as Icon03Flag,
sr.Icon04Flag as Icon04Flag,
sr.Icon05Flag as Icon05Flag,
sr.Icon06Flag as Icon06Flag,
sr.Icon07Flag as Icon07Flag,
sr.Icon08Flag as Icon08Flag,
sr.Icon09Flag as Icon09Flag,
sr.Icon10Flag as Icon10Flag,
sr.ConceptPicture as ConceptPicture,
sr.AttendantPicture as AttendantPicture,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial01
else ''
end as LectureBeforeMaterial01,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial02
else ''
end as LectureBeforeMaterial02,
sr.LectureBeforeAnimation as LectureBeforeAnimation,
sr.LectureAfterMaterial01 as LectureAfterMaterial01,
sr.LectureAfterMaterial02 as LectureAfterMaterial02,
sr.LectureAfterAnimation as LectureAfterAnimation,
sr.LBMSumary01 as LBMSumary01,
sr.LBMSumary02 as LBMSumary02,
sr.LBASumary as LBASumary,
sr.LAMSumary01 as LAMSumary01,
sr.LAMSumary02 as LAMSumary02,
sr.LAASumary as LAASumary,
sr.RegistDate as RegistDate,
sr.RegistUserID as RegistUserID,
sr.ModDate as ModDate,
sr.ModUserID as ModUserID,
sr.DelFlag as DelFlag,
sr.PSurlFlg as PSurlFlg,
sr.PSurlValue as PSurlValue,
sr.SMPaidTypeOpt as SMPaidTypeOpt,
sr.SMPaidTypeValue as SMPaidTypeValue,
sr.MailMagazineUsingFlag4SM as MailMagazineFlag,
sc.ClickLimitOverFlag as ClickLimitOverFlag,
sr.IntroSemiChargeValue as IntroSemiChargeValue,
sr.ApplicationReceptionStartFlag,
sr.DeliveruFlg,sr.DeliveruUrl,sr.FrontIndexFlg
FROM
seminar sr INNER JOIN
seminarcompany sc ON sc.SeminarCompanyID = sr.SeminarCompanyID AND sc.DelFlag = '0'
WHERE
sr.DelFlag = '0' AND
sr.SeminarCompanyID = '201020000' AND
sr.SeminarID = '000005341'
)
)
[1] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/TeikeiIchiranController.php
[line] => 848
[function] => BC_SA050002_01
[args] => Array
(
[0] => 201020000
[1] => 000005341
)
)
[2] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/TeikeiIchiranController.php
[line] => 562
[function] => setSeminarAdvertise
[class] => TeikeiIchiranController
[type] => ->
[args] => Array
(
[0] => 01
[1] => 99
[2] => ?mg=zeikai
)
)
[3] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/core/dispatch.php
[line] => 48
[function] => index
[class] => TeikeiIchiranController
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
[line] => 14
[function] => dispatch
[class] => CDispatch
[type] => ->
[args] => Array
(
)
)
[5] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/index.php
[line] => 4
[args] => Array
(
[0] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
)
[function] => include
)
)
[previous:Exception:private] =>
)
BC_SA050002_01.php(340)
Exception Object
(
[message:protected] => Out of resources when opening file './bcseminar/subcategory.MYD' (Errcode: 24 - Too many open files) [
SELECT
sr.SeminarCompanyID as SeminarCompanyID,
concat( SUBSTR(sr.SeminarCompanyID, 1, 5) ,
concat( ' - ' , SUBSTR( sr.SeminarCompanyID, 6, 4 ) )
) as SeminarCompanyIDDash,
sc.CompanyNameKanji as CompanyNameKanji,
sc.HomePageURL as SCHomePageURL,
sc.PaidType as SCPaidTypeValue,
sr.SeminarID as SeminarID,
sr.ApplicationStateID as ApplicationStateID,
CASE sr.ApplicationStateID
WHEN '01' THEN '登録中'
WHEN '02' THEN '登録申請'
WHEN '03' THEN '登録承認'
WHEN '04' THEN '更新中'
WHEN '05' THEN '更新申請'
WHEN '06' THEN '更新承認'
WHEN '07' THEN '登録申請拒否'
WHEN '08' THEN '更新申請拒否'
ELSE ''
END as ApplicationStateIDName,
sr.PrintStateID as PrintStateID,
CASE sr.PrintStateID
WHEN '01' THEN '掲載前'
WHEN '02' THEN '受付前'
WHEN '03' THEN '受付中'
WHEN '04' THEN '受付完了'
WHEN '05' THEN '開催完了'
WHEN '06' THEN '掲載完了'
ELSE ''
END as PrintStateIDName,
sr.HostCompanyName as HostCompanyName,
CASE sr.SeminarName
WHEN '*' THEN ''
ELSE sr.SeminarName
END as SeminarName,
sr.SubTitle as SubTitle,
CASE sr.SeminarOutline
WHEN '*' THEN ''
ELSE sr.SeminarOutline
END as SeminarOutline,
CASE sr.SeminarDetails
WHEN '*' THEN ''
ELSE sr.SeminarDetails
END as SeminarDetails,
(SELECT
CASE MIN(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MIN(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as StartDate,
(SELECT
CASE MAX(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MAX(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as EndDate,
CASE sr.ApplicationReceptionStartDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionStartDate
END as ApplicationReceptionStartDate,
CASE sr.ApplicationReceptionEndDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionEndDate
END as ApplicationReceptionEndDate,
sr.LocalID as LocalID,
(SELECT
lc.LocalName
FROM
local lc
WHERE
lc.DelFlag = '0' AND
lc.LocalID = sr.LocalID
) as LocalIDName,
sr.CategoryID as CategoryID,
(SELECT
cg.CategoryName
FROM
category cg
WHERE
cg.DelFlag = '0' AND
cg.CategoryID = sr.CategoryID
) as CategoryIDName,
sr.SubCategoryID as SubCategoryID,
(SELECT
scg.SubCategoryName
FROM
subcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubCategoryIDName,
sr.SubSubCategoryID as SubSubCategoryID,
(SELECT
scg.SubSubCategoryName
FROM
subsubcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubSubCategoryID = sr.SubSubCategoryID AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubSubCategoryIDName,
sr.JobTypeID as JobTypeID,
(SELECT
jt.JobTypeName
FROM
jobtype jt
WHERE
jt.DelFlag = '0' AND
jt.JobTypeID = sr.JobTypeID
) as JobTypeIDName,
sr.IndustryTypeID as IndustryTypeID,
(SELECT
it.IndustryTypeName
FROM
industrytype it
WHERE
it.DelFlag = '0' AND
it.IndustryTypeID = sr.IndustryTypeID
) as IndustryTypeIDName,
CASE IFNULL(sr.QuotaNum, '')
WHEN '' THEN '0'
ELSE sr.QuotaNum
END as QuotaNum,
(SELECT
CASE IFNULL( SUM(sa.SeminarAppNum), '')
WHEN '' THEN '0'
ELSE SUM(sa.SeminarAppNum)
END
FROM
seminarapp sa
WHERE
sa.DelFlag = '0' AND
sa.SeminarID = sr.SeminarID
) as SeminarAppNum,
sr.ReceiveNum as ReceiveNum,
sr.ConditionQualifying as ConditionQualifying,
sr.Property as Property,
sr.ParticipationCost1 as ParticipationCost1,
sr.ParticipationForm1 as ParticipationForm1,
sr.ParticipationCost2 as ParticipationCost2,
sr.ParticipationForm2 as ParticipationForm2,
CASE sr.HallName
WHEN '*' THEN ''
ELSE sr.HallName
END as HallName,
sr.HallAccess as HallAccess,
sr.HallPostal1 as HallPostal1,
sr.HallPostal2 as HallPostal2,
sr.HallAdministrativeDivisionsID as HallAdministrativeDivisionsID,
(SELECT
ad.AdministrativeDivisionsName
FROM
administrativedivisions ad
WHERE
ad.DelFlag = '0' AND
ad.LocalID = sr.LocalID AND
ad.AdministrativeDivisionsID = sr.HallAdministrativeDivisionsID
) as HallAdministrativeDivisionsIDName,
CASE sr.HallAddress
WHEN '*' THEN ''
ELSE sr.HallAddress
END as HallAddress,
sr.HallBuildingNameEtc as HallBuildingNameEtc,
sr.Map as Map,
sr.Information as Information,
sr.AttendantComment as AttendantComment,
sr.Purpose as Purpose,
sr.TakingLecObject as TakingLecObject,
sr.SpecialFavor as SpecialFavor,
sr.Icon01Flag as Icon01Flag,
sr.Icon02Flag as Icon02Flag,
sr.Icon03Flag as Icon03Flag,
sr.Icon04Flag as Icon04Flag,
sr.Icon05Flag as Icon05Flag,
sr.Icon06Flag as Icon06Flag,
sr.Icon07Flag as Icon07Flag,
sr.Icon08Flag as Icon08Flag,
sr.Icon09Flag as Icon09Flag,
sr.Icon10Flag as Icon10Flag,
sr.ConceptPicture as ConceptPicture,
sr.AttendantPicture as AttendantPicture,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial01
else ''
end as LectureBeforeMaterial01,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial02
else ''
end as LectureBeforeMaterial02,
sr.LectureBeforeAnimation as LectureBeforeAnimation,
sr.LectureAfterMaterial01 as LectureAfterMaterial01,
sr.LectureAfterMaterial02 as LectureAfterMaterial02,
sr.LectureAfterAnimation as LectureAfterAnimation,
sr.LBMSumary01 as LBMSumary01,
sr.LBMSumary02 as LBMSumary02,
sr.LBASumary as LBASumary,
sr.LAMSumary01 as LAMSumary01,
sr.LAMSumary02 as LAMSumary02,
sr.LAASumary as LAASumary,
sr.RegistDate as RegistDate,
sr.RegistUserID as RegistUserID,
sr.ModDate as ModDate,
sr.ModUserID as ModUserID,
sr.DelFlag as DelFlag,
sr.PSurlFlg as PSurlFlg,
sr.PSurlValue as PSurlValue,
sr.SMPaidTypeOpt as SMPaidTypeOpt,
sr.SMPaidTypeValue as SMPaidTypeValue,
sr.MailMagazineUsingFlag4SM as MailMagazineFlag,
sc.ClickLimitOverFlag as ClickLimitOverFlag,
sr.IntroSemiChargeValue as IntroSemiChargeValue,
sr.ApplicationReceptionStartFlag,
sr.DeliveruFlg,sr.DeliveruUrl,sr.FrontIndexFlg
FROM
seminar sr INNER JOIN
seminarcompany sc ON sc.SeminarCompanyID = sr.SeminarCompanyID AND sc.DelFlag = '0'
WHERE
sr.DelFlag = '0' AND
sr.SeminarCompanyID = '552480000' AND
sr.SeminarID = '000000766'] time:[0.00074601173400879]
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/connect/databese.php
[line:protected] => 106
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/procedure/BC_SA050002_01.php
[line] => 298
[function] => query
[args] => Array
(
[0] =>
SELECT
sr.SeminarCompanyID as SeminarCompanyID,
concat( SUBSTR(sr.SeminarCompanyID, 1, 5) ,
concat( ' - ' , SUBSTR( sr.SeminarCompanyID, 6, 4 ) )
) as SeminarCompanyIDDash,
sc.CompanyNameKanji as CompanyNameKanji,
sc.HomePageURL as SCHomePageURL,
sc.PaidType as SCPaidTypeValue,
sr.SeminarID as SeminarID,
sr.ApplicationStateID as ApplicationStateID,
CASE sr.ApplicationStateID
WHEN '01' THEN '登録中'
WHEN '02' THEN '登録申請'
WHEN '03' THEN '登録承認'
WHEN '04' THEN '更新中'
WHEN '05' THEN '更新申請'
WHEN '06' THEN '更新承認'
WHEN '07' THEN '登録申請拒否'
WHEN '08' THEN '更新申請拒否'
ELSE ''
END as ApplicationStateIDName,
sr.PrintStateID as PrintStateID,
CASE sr.PrintStateID
WHEN '01' THEN '掲載前'
WHEN '02' THEN '受付前'
WHEN '03' THEN '受付中'
WHEN '04' THEN '受付完了'
WHEN '05' THEN '開催完了'
WHEN '06' THEN '掲載完了'
ELSE ''
END as PrintStateIDName,
sr.HostCompanyName as HostCompanyName,
CASE sr.SeminarName
WHEN '*' THEN ''
ELSE sr.SeminarName
END as SeminarName,
sr.SubTitle as SubTitle,
CASE sr.SeminarOutline
WHEN '*' THEN ''
ELSE sr.SeminarOutline
END as SeminarOutline,
CASE sr.SeminarDetails
WHEN '*' THEN ''
ELSE sr.SeminarDetails
END as SeminarDetails,
(SELECT
CASE MIN(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MIN(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as StartDate,
(SELECT
CASE MAX(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MAX(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as EndDate,
CASE sr.ApplicationReceptionStartDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionStartDate
END as ApplicationReceptionStartDate,
CASE sr.ApplicationReceptionEndDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionEndDate
END as ApplicationReceptionEndDate,
sr.LocalID as LocalID,
(SELECT
lc.LocalName
FROM
local lc
WHERE
lc.DelFlag = '0' AND
lc.LocalID = sr.LocalID
) as LocalIDName,
sr.CategoryID as CategoryID,
(SELECT
cg.CategoryName
FROM
category cg
WHERE
cg.DelFlag = '0' AND
cg.CategoryID = sr.CategoryID
) as CategoryIDName,
sr.SubCategoryID as SubCategoryID,
(SELECT
scg.SubCategoryName
FROM
subcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubCategoryIDName,
sr.SubSubCategoryID as SubSubCategoryID,
(SELECT
scg.SubSubCategoryName
FROM
subsubcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubSubCategoryID = sr.SubSubCategoryID AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubSubCategoryIDName,
sr.JobTypeID as JobTypeID,
(SELECT
jt.JobTypeName
FROM
jobtype jt
WHERE
jt.DelFlag = '0' AND
jt.JobTypeID = sr.JobTypeID
) as JobTypeIDName,
sr.IndustryTypeID as IndustryTypeID,
(SELECT
it.IndustryTypeName
FROM
industrytype it
WHERE
it.DelFlag = '0' AND
it.IndustryTypeID = sr.IndustryTypeID
) as IndustryTypeIDName,
CASE IFNULL(sr.QuotaNum, '')
WHEN '' THEN '0'
ELSE sr.QuotaNum
END as QuotaNum,
(SELECT
CASE IFNULL( SUM(sa.SeminarAppNum), '')
WHEN '' THEN '0'
ELSE SUM(sa.SeminarAppNum)
END
FROM
seminarapp sa
WHERE
sa.DelFlag = '0' AND
sa.SeminarID = sr.SeminarID
) as SeminarAppNum,
sr.ReceiveNum as ReceiveNum,
sr.ConditionQualifying as ConditionQualifying,
sr.Property as Property,
sr.ParticipationCost1 as ParticipationCost1,
sr.ParticipationForm1 as ParticipationForm1,
sr.ParticipationCost2 as ParticipationCost2,
sr.ParticipationForm2 as ParticipationForm2,
CASE sr.HallName
WHEN '*' THEN ''
ELSE sr.HallName
END as HallName,
sr.HallAccess as HallAccess,
sr.HallPostal1 as HallPostal1,
sr.HallPostal2 as HallPostal2,
sr.HallAdministrativeDivisionsID as HallAdministrativeDivisionsID,
(SELECT
ad.AdministrativeDivisionsName
FROM
administrativedivisions ad
WHERE
ad.DelFlag = '0' AND
ad.LocalID = sr.LocalID AND
ad.AdministrativeDivisionsID = sr.HallAdministrativeDivisionsID
) as HallAdministrativeDivisionsIDName,
CASE sr.HallAddress
WHEN '*' THEN ''
ELSE sr.HallAddress
END as HallAddress,
sr.HallBuildingNameEtc as HallBuildingNameEtc,
sr.Map as Map,
sr.Information as Information,
sr.AttendantComment as AttendantComment,
sr.Purpose as Purpose,
sr.TakingLecObject as TakingLecObject,
sr.SpecialFavor as SpecialFavor,
sr.Icon01Flag as Icon01Flag,
sr.Icon02Flag as Icon02Flag,
sr.Icon03Flag as Icon03Flag,
sr.Icon04Flag as Icon04Flag,
sr.Icon05Flag as Icon05Flag,
sr.Icon06Flag as Icon06Flag,
sr.Icon07Flag as Icon07Flag,
sr.Icon08Flag as Icon08Flag,
sr.Icon09Flag as Icon09Flag,
sr.Icon10Flag as Icon10Flag,
sr.ConceptPicture as ConceptPicture,
sr.AttendantPicture as AttendantPicture,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial01
else ''
end as LectureBeforeMaterial01,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial02
else ''
end as LectureBeforeMaterial02,
sr.LectureBeforeAnimation as LectureBeforeAnimation,
sr.LectureAfterMaterial01 as LectureAfterMaterial01,
sr.LectureAfterMaterial02 as LectureAfterMaterial02,
sr.LectureAfterAnimation as LectureAfterAnimation,
sr.LBMSumary01 as LBMSumary01,
sr.LBMSumary02 as LBMSumary02,
sr.LBASumary as LBASumary,
sr.LAMSumary01 as LAMSumary01,
sr.LAMSumary02 as LAMSumary02,
sr.LAASumary as LAASumary,
sr.RegistDate as RegistDate,
sr.RegistUserID as RegistUserID,
sr.ModDate as ModDate,
sr.ModUserID as ModUserID,
sr.DelFlag as DelFlag,
sr.PSurlFlg as PSurlFlg,
sr.PSurlValue as PSurlValue,
sr.SMPaidTypeOpt as SMPaidTypeOpt,
sr.SMPaidTypeValue as SMPaidTypeValue,
sr.MailMagazineUsingFlag4SM as MailMagazineFlag,
sc.ClickLimitOverFlag as ClickLimitOverFlag,
sr.IntroSemiChargeValue as IntroSemiChargeValue,
sr.ApplicationReceptionStartFlag,
sr.DeliveruFlg,sr.DeliveruUrl,sr.FrontIndexFlg
FROM
seminar sr INNER JOIN
seminarcompany sc ON sc.SeminarCompanyID = sr.SeminarCompanyID AND sc.DelFlag = '0'
WHERE
sr.DelFlag = '0' AND
sr.SeminarCompanyID = '552480000' AND
sr.SeminarID = '000000766'
)
)
[1] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/TeikeiIchiranController.php
[line] => 848
[function] => BC_SA050002_01
[args] => Array
(
[0] => 552480000
[1] => 000000766
)
)
[2] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/TeikeiIchiranController.php
[line] => 562
[function] => setSeminarAdvertise
[class] => TeikeiIchiranController
[type] => ->
[args] => Array
(
[0] => 01
[1] => 99
[2] => ?mg=zeikai
)
)
[3] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/core/dispatch.php
[line] => 48
[function] => index
[class] => TeikeiIchiranController
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
[line] => 14
[function] => dispatch
[class] => CDispatch
[type] => ->
[args] => Array
(
)
)
[5] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/index.php
[line] => 4
[args] => Array
(
[0] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
)
[function] => include
)
)
[previous:Exception:private] =>
)
BC_SA050002_01.php(340)
Exception Object
(
[message:protected] => Out of resources when opening file './bcseminar/subcategory.MYD' (Errcode: 24 - Too many open files) [
SELECT
sr.SeminarCompanyID as SeminarCompanyID,
concat( SUBSTR(sr.SeminarCompanyID, 1, 5) ,
concat( ' - ' , SUBSTR( sr.SeminarCompanyID, 6, 4 ) )
) as SeminarCompanyIDDash,
sc.CompanyNameKanji as CompanyNameKanji,
sc.HomePageURL as SCHomePageURL,
sc.PaidType as SCPaidTypeValue,
sr.SeminarID as SeminarID,
sr.ApplicationStateID as ApplicationStateID,
CASE sr.ApplicationStateID
WHEN '01' THEN '登録中'
WHEN '02' THEN '登録申請'
WHEN '03' THEN '登録承認'
WHEN '04' THEN '更新中'
WHEN '05' THEN '更新申請'
WHEN '06' THEN '更新承認'
WHEN '07' THEN '登録申請拒否'
WHEN '08' THEN '更新申請拒否'
ELSE ''
END as ApplicationStateIDName,
sr.PrintStateID as PrintStateID,
CASE sr.PrintStateID
WHEN '01' THEN '掲載前'
WHEN '02' THEN '受付前'
WHEN '03' THEN '受付中'
WHEN '04' THEN '受付完了'
WHEN '05' THEN '開催完了'
WHEN '06' THEN '掲載完了'
ELSE ''
END as PrintStateIDName,
sr.HostCompanyName as HostCompanyName,
CASE sr.SeminarName
WHEN '*' THEN ''
ELSE sr.SeminarName
END as SeminarName,
sr.SubTitle as SubTitle,
CASE sr.SeminarOutline
WHEN '*' THEN ''
ELSE sr.SeminarOutline
END as SeminarOutline,
CASE sr.SeminarDetails
WHEN '*' THEN ''
ELSE sr.SeminarDetails
END as SeminarDetails,
(SELECT
CASE MIN(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MIN(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as StartDate,
(SELECT
CASE MAX(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MAX(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as EndDate,
CASE sr.ApplicationReceptionStartDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionStartDate
END as ApplicationReceptionStartDate,
CASE sr.ApplicationReceptionEndDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionEndDate
END as ApplicationReceptionEndDate,
sr.LocalID as LocalID,
(SELECT
lc.LocalName
FROM
local lc
WHERE
lc.DelFlag = '0' AND
lc.LocalID = sr.LocalID
) as LocalIDName,
sr.CategoryID as CategoryID,
(SELECT
cg.CategoryName
FROM
category cg
WHERE
cg.DelFlag = '0' AND
cg.CategoryID = sr.CategoryID
) as CategoryIDName,
sr.SubCategoryID as SubCategoryID,
(SELECT
scg.SubCategoryName
FROM
subcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubCategoryIDName,
sr.SubSubCategoryID as SubSubCategoryID,
(SELECT
scg.SubSubCategoryName
FROM
subsubcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubSubCategoryID = sr.SubSubCategoryID AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubSubCategoryIDName,
sr.JobTypeID as JobTypeID,
(SELECT
jt.JobTypeName
FROM
jobtype jt
WHERE
jt.DelFlag = '0' AND
jt.JobTypeID = sr.JobTypeID
) as JobTypeIDName,
sr.IndustryTypeID as IndustryTypeID,
(SELECT
it.IndustryTypeName
FROM
industrytype it
WHERE
it.DelFlag = '0' AND
it.IndustryTypeID = sr.IndustryTypeID
) as IndustryTypeIDName,
CASE IFNULL(sr.QuotaNum, '')
WHEN '' THEN '0'
ELSE sr.QuotaNum
END as QuotaNum,
(SELECT
CASE IFNULL( SUM(sa.SeminarAppNum), '')
WHEN '' THEN '0'
ELSE SUM(sa.SeminarAppNum)
END
FROM
seminarapp sa
WHERE
sa.DelFlag = '0' AND
sa.SeminarID = sr.SeminarID
) as SeminarAppNum,
sr.ReceiveNum as ReceiveNum,
sr.ConditionQualifying as ConditionQualifying,
sr.Property as Property,
sr.ParticipationCost1 as ParticipationCost1,
sr.ParticipationForm1 as ParticipationForm1,
sr.ParticipationCost2 as ParticipationCost2,
sr.ParticipationForm2 as ParticipationForm2,
CASE sr.HallName
WHEN '*' THEN ''
ELSE sr.HallName
END as HallName,
sr.HallAccess as HallAccess,
sr.HallPostal1 as HallPostal1,
sr.HallPostal2 as HallPostal2,
sr.HallAdministrativeDivisionsID as HallAdministrativeDivisionsID,
(SELECT
ad.AdministrativeDivisionsName
FROM
administrativedivisions ad
WHERE
ad.DelFlag = '0' AND
ad.LocalID = sr.LocalID AND
ad.AdministrativeDivisionsID = sr.HallAdministrativeDivisionsID
) as HallAdministrativeDivisionsIDName,
CASE sr.HallAddress
WHEN '*' THEN ''
ELSE sr.HallAddress
END as HallAddress,
sr.HallBuildingNameEtc as HallBuildingNameEtc,
sr.Map as Map,
sr.Information as Information,
sr.AttendantComment as AttendantComment,
sr.Purpose as Purpose,
sr.TakingLecObject as TakingLecObject,
sr.SpecialFavor as SpecialFavor,
sr.Icon01Flag as Icon01Flag,
sr.Icon02Flag as Icon02Flag,
sr.Icon03Flag as Icon03Flag,
sr.Icon04Flag as Icon04Flag,
sr.Icon05Flag as Icon05Flag,
sr.Icon06Flag as Icon06Flag,
sr.Icon07Flag as Icon07Flag,
sr.Icon08Flag as Icon08Flag,
sr.Icon09Flag as Icon09Flag,
sr.Icon10Flag as Icon10Flag,
sr.ConceptPicture as ConceptPicture,
sr.AttendantPicture as AttendantPicture,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial01
else ''
end as LectureBeforeMaterial01,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial02
else ''
end as LectureBeforeMaterial02,
sr.LectureBeforeAnimation as LectureBeforeAnimation,
sr.LectureAfterMaterial01 as LectureAfterMaterial01,
sr.LectureAfterMaterial02 as LectureAfterMaterial02,
sr.LectureAfterAnimation as LectureAfterAnimation,
sr.LBMSumary01 as LBMSumary01,
sr.LBMSumary02 as LBMSumary02,
sr.LBASumary as LBASumary,
sr.LAMSumary01 as LAMSumary01,
sr.LAMSumary02 as LAMSumary02,
sr.LAASumary as LAASumary,
sr.RegistDate as RegistDate,
sr.RegistUserID as RegistUserID,
sr.ModDate as ModDate,
sr.ModUserID as ModUserID,
sr.DelFlag as DelFlag,
sr.PSurlFlg as PSurlFlg,
sr.PSurlValue as PSurlValue,
sr.SMPaidTypeOpt as SMPaidTypeOpt,
sr.SMPaidTypeValue as SMPaidTypeValue,
sr.MailMagazineUsingFlag4SM as MailMagazineFlag,
sc.ClickLimitOverFlag as ClickLimitOverFlag,
sr.IntroSemiChargeValue as IntroSemiChargeValue,
sr.ApplicationReceptionStartFlag,
sr.DeliveruFlg,sr.DeliveruUrl,sr.FrontIndexFlg
FROM
seminar sr INNER JOIN
seminarcompany sc ON sc.SeminarCompanyID = sr.SeminarCompanyID AND sc.DelFlag = '0'
WHERE
sr.DelFlag = '0' AND
sr.SeminarCompanyID = '202940000' AND
sr.SeminarID = '000003577'] time:[0.00074100494384766]
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/connect/databese.php
[line:protected] => 106
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/module/procedure/BC_SA050002_01.php
[line] => 298
[function] => query
[args] => Array
(
[0] =>
SELECT
sr.SeminarCompanyID as SeminarCompanyID,
concat( SUBSTR(sr.SeminarCompanyID, 1, 5) ,
concat( ' - ' , SUBSTR( sr.SeminarCompanyID, 6, 4 ) )
) as SeminarCompanyIDDash,
sc.CompanyNameKanji as CompanyNameKanji,
sc.HomePageURL as SCHomePageURL,
sc.PaidType as SCPaidTypeValue,
sr.SeminarID as SeminarID,
sr.ApplicationStateID as ApplicationStateID,
CASE sr.ApplicationStateID
WHEN '01' THEN '登録中'
WHEN '02' THEN '登録申請'
WHEN '03' THEN '登録承認'
WHEN '04' THEN '更新中'
WHEN '05' THEN '更新申請'
WHEN '06' THEN '更新承認'
WHEN '07' THEN '登録申請拒否'
WHEN '08' THEN '更新申請拒否'
ELSE ''
END as ApplicationStateIDName,
sr.PrintStateID as PrintStateID,
CASE sr.PrintStateID
WHEN '01' THEN '掲載前'
WHEN '02' THEN '受付前'
WHEN '03' THEN '受付中'
WHEN '04' THEN '受付完了'
WHEN '05' THEN '開催完了'
WHEN '06' THEN '掲載完了'
ELSE ''
END as PrintStateIDName,
sr.HostCompanyName as HostCompanyName,
CASE sr.SeminarName
WHEN '*' THEN ''
ELSE sr.SeminarName
END as SeminarName,
sr.SubTitle as SubTitle,
CASE sr.SeminarOutline
WHEN '*' THEN ''
ELSE sr.SeminarOutline
END as SeminarOutline,
CASE sr.SeminarDetails
WHEN '*' THEN ''
ELSE sr.SeminarDetails
END as SeminarDetails,
(SELECT
CASE MIN(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MIN(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as StartDate,
(SELECT
CASE MAX(ss.Date)
WHEN '*' THEN ''
WHEN '19000101' THEN ''
ELSE MAX(ss.Date)
END
FROM
seminarsch ss
WHERE
ss.DelFlag = '0' AND
ss.SeminarCompanyID = sr.SeminarCompanyID AND
ss.SeminarID = sr.SeminarID
) as EndDate,
CASE sr.ApplicationReceptionStartDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionStartDate
END as ApplicationReceptionStartDate,
CASE sr.ApplicationReceptionEndDate
WHEN '*' THEN ''
ELSE sr.ApplicationReceptionEndDate
END as ApplicationReceptionEndDate,
sr.LocalID as LocalID,
(SELECT
lc.LocalName
FROM
local lc
WHERE
lc.DelFlag = '0' AND
lc.LocalID = sr.LocalID
) as LocalIDName,
sr.CategoryID as CategoryID,
(SELECT
cg.CategoryName
FROM
category cg
WHERE
cg.DelFlag = '0' AND
cg.CategoryID = sr.CategoryID
) as CategoryIDName,
sr.SubCategoryID as SubCategoryID,
(SELECT
scg.SubCategoryName
FROM
subcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubCategoryIDName,
sr.SubSubCategoryID as SubSubCategoryID,
(SELECT
scg.SubSubCategoryName
FROM
subsubcategory scg
WHERE
scg.DelFlag = '0' AND
scg.SubSubCategoryID = sr.SubSubCategoryID AND
scg.SubCategoryID = sr.SubCategoryID AND
scg.CategoryID = sr.CategoryID
) as SubSubCategoryIDName,
sr.JobTypeID as JobTypeID,
(SELECT
jt.JobTypeName
FROM
jobtype jt
WHERE
jt.DelFlag = '0' AND
jt.JobTypeID = sr.JobTypeID
) as JobTypeIDName,
sr.IndustryTypeID as IndustryTypeID,
(SELECT
it.IndustryTypeName
FROM
industrytype it
WHERE
it.DelFlag = '0' AND
it.IndustryTypeID = sr.IndustryTypeID
) as IndustryTypeIDName,
CASE IFNULL(sr.QuotaNum, '')
WHEN '' THEN '0'
ELSE sr.QuotaNum
END as QuotaNum,
(SELECT
CASE IFNULL( SUM(sa.SeminarAppNum), '')
WHEN '' THEN '0'
ELSE SUM(sa.SeminarAppNum)
END
FROM
seminarapp sa
WHERE
sa.DelFlag = '0' AND
sa.SeminarID = sr.SeminarID
) as SeminarAppNum,
sr.ReceiveNum as ReceiveNum,
sr.ConditionQualifying as ConditionQualifying,
sr.Property as Property,
sr.ParticipationCost1 as ParticipationCost1,
sr.ParticipationForm1 as ParticipationForm1,
sr.ParticipationCost2 as ParticipationCost2,
sr.ParticipationForm2 as ParticipationForm2,
CASE sr.HallName
WHEN '*' THEN ''
ELSE sr.HallName
END as HallName,
sr.HallAccess as HallAccess,
sr.HallPostal1 as HallPostal1,
sr.HallPostal2 as HallPostal2,
sr.HallAdministrativeDivisionsID as HallAdministrativeDivisionsID,
(SELECT
ad.AdministrativeDivisionsName
FROM
administrativedivisions ad
WHERE
ad.DelFlag = '0' AND
ad.LocalID = sr.LocalID AND
ad.AdministrativeDivisionsID = sr.HallAdministrativeDivisionsID
) as HallAdministrativeDivisionsIDName,
CASE sr.HallAddress
WHEN '*' THEN ''
ELSE sr.HallAddress
END as HallAddress,
sr.HallBuildingNameEtc as HallBuildingNameEtc,
sr.Map as Map,
sr.Information as Information,
sr.AttendantComment as AttendantComment,
sr.Purpose as Purpose,
sr.TakingLecObject as TakingLecObject,
sr.SpecialFavor as SpecialFavor,
sr.Icon01Flag as Icon01Flag,
sr.Icon02Flag as Icon02Flag,
sr.Icon03Flag as Icon03Flag,
sr.Icon04Flag as Icon04Flag,
sr.Icon05Flag as Icon05Flag,
sr.Icon06Flag as Icon06Flag,
sr.Icon07Flag as Icon07Flag,
sr.Icon08Flag as Icon08Flag,
sr.Icon09Flag as Icon09Flag,
sr.Icon10Flag as Icon10Flag,
sr.ConceptPicture as ConceptPicture,
sr.AttendantPicture as AttendantPicture,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial01
else ''
end as LectureBeforeMaterial01,
case
when sc.MemberTypeID IN ('01','06','16','26') then sr.LectureBeforeMaterial02
else ''
end as LectureBeforeMaterial02,
sr.LectureBeforeAnimation as LectureBeforeAnimation,
sr.LectureAfterMaterial01 as LectureAfterMaterial01,
sr.LectureAfterMaterial02 as LectureAfterMaterial02,
sr.LectureAfterAnimation as LectureAfterAnimation,
sr.LBMSumary01 as LBMSumary01,
sr.LBMSumary02 as LBMSumary02,
sr.LBASumary as LBASumary,
sr.LAMSumary01 as LAMSumary01,
sr.LAMSumary02 as LAMSumary02,
sr.LAASumary as LAASumary,
sr.RegistDate as RegistDate,
sr.RegistUserID as RegistUserID,
sr.ModDate as ModDate,
sr.ModUserID as ModUserID,
sr.DelFlag as DelFlag,
sr.PSurlFlg as PSurlFlg,
sr.PSurlValue as PSurlValue,
sr.SMPaidTypeOpt as SMPaidTypeOpt,
sr.SMPaidTypeValue as SMPaidTypeValue,
sr.MailMagazineUsingFlag4SM as MailMagazineFlag,
sc.ClickLimitOverFlag as ClickLimitOverFlag,
sr.IntroSemiChargeValue as IntroSemiChargeValue,
sr.ApplicationReceptionStartFlag,
sr.DeliveruFlg,sr.DeliveruUrl,sr.FrontIndexFlg
FROM
seminar sr INNER JOIN
seminarcompany sc ON sc.SeminarCompanyID = sr.SeminarCompanyID AND sc.DelFlag = '0'
WHERE
sr.DelFlag = '0' AND
sr.SeminarCompanyID = '202940000' AND
sr.SeminarID = '000003577'
)
)
[1] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/TeikeiIchiranController.php
[line] => 848
[function] => BC_SA050002_01
[args] => Array
(
[0] => 202940000
[1] => 000003577
)
)
[2] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/controllers/TeikeiIchiranController.php
[line] => 562
[function] => setSeminarAdvertise
[class] => TeikeiIchiranController
[type] => ->
[args] => Array
(
[0] => 01
[1] => 99
[2] => ?mg=zeikai
)
)
[3] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/core/dispatch.php
[line] => 48
[function] => index
[class] => TeikeiIchiranController
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
[line] => 14
[function] => dispatch
[class] => CDispatch
[type] => ->
[args] => Array
(
)
)
[5] => Array
(
[file] => /export1/var/www/www.bc-seminar.jp/httpd/index.php
[line] => 4
[args] => Array
(
[0] => /export1/var/www/www.bc-seminar.jp/httpd/webapp/index.php
)
[function] => include
)
)
[previous:Exception:private] =>
)
