SELECT
      ISNULL(MAX(ITMStartDate), GETDATE()) AS LatestDate
    FROM
      DM_UnitItemMartDT AS VID with(nolock)
      ;
  

    --セール情報
    SELECT
      SD.SalesCD,
      SD.Caption,
      SD.ListBunnerFile AS TitleBunnerFile,
      SD.ListBunnerFileSP,
      SD.Discription,
      SD.StartDate,
      SD.EndDate,
      ISNULL(SID.ItemCount,0) AS ItemCount,
      'Sale' AS SaleMenu,
      '/item/sale?salesCD=' + SD.SalesCD AS LinkUrl
    FROM
      IM_SalesDT AS SD
      LEFT JOIN
      (
      SELECT
        COUNT(*) AS ItemCount,
        SID.SalesCD
      FROM
        IM_SalesItemDT SID
        INNER JOIN
        DM_UnitItemMartDT AS VID with(nolock) ON
        SID.ItemCD = VID.ItemCD
      WHERE
        SID.InvalidFlg = ?
      GROUP BY
        SID.SalesCD
      ) AS SID ON
      SD.SalesCD = SID.SalesCD
    WHERE
      SD.InvalidFlg = '00' AND
      SD.StartDate <= GETDATE() AND
      SD.EndDate >= GETDATE()
   UNION ALL   
   --特売情報
   SELECT
      CONVERT(varchar,LSD.LimitedSaleCD) AS SalesCD,
      LSD.Name AS Caption,
      LSD.TitleBunnerFile,
      ISNULL(LSD.ListBunnerFileSP, LSD.ListBunnerFile) AS ListBunnerFileSP,
      LSD.Discription,
      LSD.StartDate,
      LSD.EndDate,
      ISNULL(LSID.ItemCount,0) AS ItemCount,
      'LimitedSale' AS SaleMenu,   
      '/item/limitedsaleitem?limitedSaleCD=' + CONVERT(varchar,LSD.LimitedSaleCD) AS LinkUrl
    FROM
      IM_LimitedSaleBaseDT AS LSD
      LEFT JOIN
      (
      SELECT
        COUNT(*) AS ItemCount,
        LSID.LimitedSaleCD
      FROM
        IM_LimitedSaleItemDT LSID
        INNER JOIN
        DM_UnitItemMartDT AS VID with(nolock) ON
        LSID.ItemCD = VID.ItemCD
      WHERE
        LSID.InvalidFlg = ?
      GROUP BY
        LSID.LimitedSaleCD
      ) AS LSID ON
      LSD.LimitedSaleCD = LSID.LimitedSaleCD
    WHERE
      LSD.InvalidFlg = '00' AND
      LSD.StartDate <= GETDATE() AND
      LSD.EndDate >=  GETDATE()
   UNION ALL
   --よりどり情報
    SELECT
      CSD.ChoiceSetCD AS SalesCD,
      CSD.Caption,
      CSD.TitleBunnerFile,
      ISNULL(CSD.ListBunnerFileSP, CSD.ListBunnerFile) AS ListBunnerFileSP,
      CSD.Discription,      
      CSD.StartDate,
      CSD.EndDate,
      ISNULL(CSID.ItemCount,0) AS ItemCount,
      'ChoiceSet' AS SaleMenu,
      '/item/ChoiceSet?ChoiceSetCD=' + CSD.ChoiceSetCD AS LinkUrl
    FROM
      IM_ChoiceSetDT AS CSD
      LEFT JOIN
      (
      SELECT
        COUNT(*) AS ItemCount,
        CSID.ChoiceSetCD
      FROM
        IM_ChoiceSetItemDT CSID
        INNER JOIN
        DM_UnitItemMartDT AS VID with(nolock) ON
        CSID.ItemCD = VID.ItemCD
      WHERE
        CSID.InvalidFlg = ?
      GROUP BY
        CSID.ChoiceSetCD
      ) AS CSID ON
      CSD.ChoiceSetCD = CSID.ChoiceSetCD
    WHERE
      CSD.InvalidFlg = '00' AND
      CSD.StartDate <= GETDATE() AND
      CSD.EndDate >= GETDATE()
    --EC特別価格
    UNION ALL
    SELECT
      CONVERT(VARCHAR(10),SD.EcDiscountCD) AS SalesCD,
      SD.Caption,
      SD.ListBunnerFile AS TitleBunnerFile,
      SD.ListBunnerFileSP,
      SD.EcDiscountDiscription AS Discription,
      SD.StartDate,
      SD.EndDate,
      ISNULL(SID.ItemCount,0) AS ItemCount,
      'EcDiscount' AS SaleMenu,
      (
      CASE
        WHEN SD.PageTransitionUrl IS NOT NULL THEN
          SD.PageTransitionUrl
        ELSE
          '/item/EcDiscount?ecdiscountCD=' + LTRIM(STR(SD.EcDiscountCD))
        END
      ) as LinkUrl
    FROM
      IM_EcDiscountMST AS SD
      LEFT JOIN
      (
      SELECT
        COUNT(*) AS ItemCount,
        VID.EcDiscountCD
      FROM
        DM_UnitItemMartDT AS VID with(nolock)
      WHERE
        VID.InvalidFlg = ?
      GROUP BY
        VID.EcDiscountCD
      ) AS SID ON
      SD.EcDiscountCD = SID.EcDiscountCD
    WHERE
      SD.InvalidFlg = '00' AND
      SD.StartDate <= GETDATE() AND
      SD.EndDate >= GETDATE()
    ORDER BY
      StartDate DESC
    

    SELECT TOP 3
      IFD.FeatureCD,
      IFD.Name,
      IFD.ListBunnerFile,
      IFD.TitleBunnerFile,
      IFD.Discription,
      IFD.ItemCls,
      IFD.DiscriptionSEO,
      IFD.KeyWordSEO,
      IFD.TitleSEO,
      IFD.StartDate,
      IFD.EndDate,
      ISNULL(IFD.ListBunnerFileSP, IFD.ListBunnerFile) AS ListBunnerFileSP,
      ISNULL(IFD.DiscriptionSP, IFD.Discription) AS DiscriptionSP
    FROM
      IM_FeatureDT AS IFD
    WHERE 0=0
      AND IFD.InvalidFlg = ?  -- 有効
      AND IFD.StartDate <= GETDATE()
      AND IFD.EndDate >= GETDATE()
    
    ORDER BY
      IFD.StartDate DESC;
  

    SELECT TOP 3
      IFD.FeatureCD,
      IFD.Name,
      IFD.ListBunnerFile,
      IFD.TitleBunnerFile,
      IFD.Discription,
      IFD.ItemCls,
      IFD.DiscriptionSEO,
      IFD.KeyWordSEO,
      IFD.TitleSEO,
      IFD.StartDate,
      IFD.EndDate,
      ISNULL(IFD.ListBunnerFileSP, IFD.ListBunnerFile) AS ListBunnerFileSP,
      ISNULL(IFD.DiscriptionSP, IFD.Discription) AS DiscriptionSP
    FROM
      IM_FeatureDT AS IFD
    WHERE 0=0
      AND IFD.InvalidFlg = ?  -- 有効
      AND IFD.StartDate <= GETDATE()
      AND IFD.EndDate >= GETDATE()
    
      AND IFD.FeatureCD IN(?)
    
    ORDER BY
      IFD.StartDate DESC;
  

    SELECT
      SD.ChoiceSetDetailNo
     ,SD.ChoiceSetCD
     ,SD.LimitQuty
     ,SD.ChoiceDiscription
     ,ISNULL(SD.ChoiceDiscriptionSP,SD.ChoiceDiscription) AS ChoiceDiscriptionSP
     ,SD.ChoiceDetailColor
     ,SD.Caption
     ,SD.BunnerFile
     ,SD.BunnerFileSP
     ,SD.InvalidFlg
    FROM
      IM_ChoiceSetDetailDT AS SD
    INNER JOIN
      IM_ChoiceSetDT AS CM
    ON
      SD.ChoiceSetCD = CM.ChoiceSetCD
    WHERE 0=0
    
      AND SD.InvalidFlg = ?  -- 有効
      AND CM.InvalidFlg = ?
      AND CONVERT(varchar, CM.StartDate, 120) <= CONVERT(varchar, GETDATE(), 120)
      AND CONVERT(varchar, CM.EndDate, 120) >= CONVERT(varchar, GETDATE(), 120)
    ORDER BY
      SD.ChoiceSetDetailNo;
  

    SELECT
      SID.ItemCD,
      SD.ChoiceSetCD,
      SD.ChoiceItemCD,
      SD.Caption AS 'Name',
      SD.ListBunnerFile,
      SD.TitleBunnerFile,
      SD.DetailBunnerFile,
      SD.Discription,
      SD.DiscriptionSEO,
      SD.KeyWordSEO,
      SD.TitleSEO,
      SD.Caption,
      SD.ChoicePrice,
      SD.ItemQuty,
      ISNULL(SD.ListBunnerFileSP, SD.ListBunnerFile) AS ListBunnerFileSP,
      ISNULL(SD.DiscriptionSP, SD.Discription) AS DiscriptionSP,
      SDD.LimitQuty,
      SDD.ChoiceDiscription,
      SDD.ChoiceDiscriptionSP,
      SDD.ChoiceDetailColor,
      SDD.Caption,
      SDD.BunnerFile,
      ISNULL(SDD.BunnerFileSP,SDD.BunnerFile) AS BunnerFileSP,
      SDD.ChoiceSetDetailNo
    FROM
      IM_ChoiceSetDT AS SD
      INNER JOIN
      IM_ChoiceSetItemDT AS SID ON
      SD.ChoiceSetCD = SID.ChoiceSetCD
      INNER JOIN
      IM_ChoiceSetDetailDT AS SDD ON
      SD.ChoiceSetCD = SDD.ChoiceSetCD
    WHERE 0=0
    
      AND CONVERT(varchar, SD.StartDate, 120) <= CONVERT(varchar, GETDATE(), 120)
      AND CONVERT(varchar, SD.EndDate, 120) >= CONVERT(varchar, GETDATE(), 120)
      AND SD.InvalidFlg = ?  -- 有効
    ORDER BY
      SD.ChoiceSetCD,SID.ItemCD;
  

    SELECT
      MAX(
          CASE
          WHEN VID.PossibleStock <= 0 AND VID.OrderStopFlg = '01' THEN
            0
          WHEN VID.MaxUnitPrice IS NULL THEN
            0
          WHEN VID.MaxOthersPrice IS NULL THEN
            0
          WHEN VID.MaxUnitPrice <> 0 AND VID.MaxOthersPrice <> 0 THEN
            ROUND(((VID.MaxOthersPrice - VID.MaxUnitPrice) / CONVERT(FLOAT, VID.MaxOthersPrice) * 100),0)
          ELSE
            0
          END
          ) AS MaxDiscount,
      COUNT(VID.ItemCD) AS ItemCnt
    FROM
      DM_UnitItemMartDT AS VID with(nolock)
      ;
  

    SELECT
      HBT.SeqNo
      ,HBT.AltValue
      ,HBT.FilePath
      ,HBT.FilePathSp
      ,HBT.LinkURL
      ,HBT.DispStartDate
      ,HBT.DispEndDate
      ,HBT.CountdownFlg
    FROM
      SM_HeaderBunnerDT AS HBT
    WHERE 0=0
      AND HBT.DispStartDate <= GETDATE()
      AND HBT.DispEndDate >= GETDATE()
    ORDER BY
      ISNULL(HBT.Priority, 9999) ASC,
      HBT.DispStartDate DESC,
      HBT.UpdateDate DESC;
  

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?)
      
      ORDER BY
      
        OrderKana
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?)
      
      ORDER BY
      
        OrderKana
      

  SELECT
    TOP 1
    CMPopupNo,
    Comment,
    CONVERT(char(19),StartDate,120) AS StartDate,
    CONVERT(char(19),EndDate,120) AS EndDate,
    htmlURL,
    htmlURLSP,
    InvalidFlg,
    InsertOperatorCD,
    UpdateOperatorCD,
    InsertDate,
    UpdateDate,
    iconURL,
    icondispflg,
    logindispflg,
    LinkURL,
    PopupImage
  FROM
    SM_CommercialPopupDT with(nolock)
  WHERE 0 = 0
    AND StartDate <= getdate()
    AND EndDate >= getdate()
    AND InvalidFlg = ?
  ;

Application Variables:
applicationname=CosmeticTimes
commonfooter=Struct (2)
commonfooter_s=Struct (2)
header=Struct (19)
headerglovalnavictg=Struct (2)
headerpc=Struct (13)
leftnaviguidenavi=Struct (2)
leftnavikeywordnavi=Struct (2)
leftnavisidenavi=Struct (2)
leftnavkeywordnavi=Struct (1)
leftnavsearchnavi=Struct (2)
newcommonfooter=Struct (2)
newheaderglovalnavictg=Struct (2)
pctopnewitem=Struct (2)
pctopslideshow=Struct (2)
pctopstaffreview=Struct (2)
topcachedata=Struct (2)
topfaq_s=Struct (2)
topslideshow_s=Struct (2)
topspcachedata=Struct (2)

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\public\campaign\campaign.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=757713.gxwh.asia
HTTP_REFERER=
HTTP_URL=/campaign/campaign.cfm?campaigncd=thanks-coupon?campaigncd=thanks-coupon
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=103.125.217.134
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\public\campaign\campaign.cfm
QUERY_STRING=campaigncd=thanks-coupon
REMOTE_ADDR=172.70.131.72
REMOTE_HOST=172.70.131.72
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/campaign/campaign.cfm
SERVER_NAME=757713.gxwh.asia
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Request Parameters:
3dwhitememberdate=2021-06-01
accessflg=0
amazon_merchantid=A257K01BV4LLIT
amazon_public_key_id=AG6Z3D243ZFIMJA7ZBKY3JCF
amazonpay_sandbox=false
amazonpay_surl=https://www.cosmetic-times.com
append_order=true
arycashbackbrandcd=Array (8)
arycashbackfee=Array (3)
arycashbacklv=Array (3)
arycode_addmissioncd=Array (18)
arycode_aegisresult=Array (6)
arycode_agecd=Array (10)
arycode_appform=Array (2)
arycode_appointtime=Array (7)
arycode_approve=Array (3)
arycode_approvedflg=Array (2)
arycode_cardbrand=Array (6)
arycode_cautioncd=Array (15)
arycode_complaint=Array (12)
arycode_coupondivision=Array (2)
arycode_couponuseterms=Array (4)
arycode_creditpaymentcnt=Array (3)
arycode_creditstate=Array (15)
arycode_deliverybox=Array (2)
arycode_deliverycompanyflg=Array (2)
arycode_deliveryroutetype=Array (2)
arycode_discontinued=Array (2)
arycode_displaycd=Array (6)
arycode_disptypeflg=Array (4)
arycode_dsphidflg=Array (2)
arycode_ecsitecd=Array (4)
arycode_featureitemcls=Array (4)
arycode_fpstate=Array (7)
arycode_gender=Array (2)
arycode_inquiryclass=Array (10)
arycode_invalid=Array (2)
arycode_itemdescriptiontype=Array (4)
arycode_itemsalestate=Array (2)
arycode_itemsort=Array (6)
arycode_itemtypeflg=Array (6)
arycode_mailsendflg=Array (2)
arycode_memberdivisioncd=Array (4)
arycode_memberrankcd=Array (5)
arycode_memberstatus=Array (5)
arycode_necesunneces=Array (2)
arycode_ordercancel=Array (7)
arycode_orderstate=Array (7)
arycode_orderstopflg=Array (2)
arycode_paymentmethod=Array (8)
arycode_paymentstate=Array (4)
arycode_pointmessage=Array (9)
arycode_pointtranflg=Array (5)
arycode_pointtransact=Array (9)
arycode_possibunpossib=Array (2)
arycode_pricedownflg=Array (2)
arycode_processflg=Array (3)
arycode_ranking=Array (4)
arycode_rearrivemailflg=Array (2)
arycode_reshipflg=Array (2)
arycode_returnreason=Array (5)
arycode_reviewsort=Array (4)
arycode_searchpricerange=Array (8)
arycode_sellingflg=Array (2)
arycode_sendflg=Array (2)
arycode_shippingdivisionflg=Array (3)
arycode_splistcount=Array (3)
arycode_splistcount2=Array (3)
arycode_stockwaiting=Array (3)
arycode_troublecd=Array (6)
arycode_unprocproc=Array (2)
arycode_unreleasedflg=Array (2)
arycode_unusedused=Array (2)
arycode_userrequest=Array (3)
arycode_veritransexpireflg=Array (2)
arycode_wantunwant=Array (2)
arycode_warehouse=Array (2)
arycode_whitestatus=Array (3)
authorize_err_mpi=/od/authorize_err_mpi
authorize_res_mpi=/od/authorize_res_mpi
authorize_suc_mpi=/od/authorize_suc_mpi
bodytag_itemscope=
cookieexpire=360
cssversion=?ver=100023
debugflg=0
dtchecklogintime=20231203100023
dtfreecampaignend=2020/11/09 00:00
dtfreecampaignstart=2020/11/03 11:00
ec_id=1234567
ec_testid=
ecdevicetype=P
featuretrouble=False
file_path=D:\Inetpub\public\track\json\
flgcashbackcampaign=0
http_devicetype=P
https=off
image_folder=D:\Inetpub\public\image
image_s_folder=D:\Inetpub\public\sp\image
imgappleiconpath=https://img.cosmetic-times.com/sp/image/common/apple-touch-icon.png
imgiconpath=https://img.cosmetic-times.com/sp/image/common/android-touch-icon.png
imgthumbnailpath=https://img.cosmetic-times.com/image/common/header_logo_ct2.png
intcashbackdiscountratio=0
intcollectfee=324
intdiscountrate=50
intfreecarriageamount=8000
intlimitautherrcnt=3
intlimitofthreshold=300000
intmaxamount=24
intmaxorderamount=50
intmemberrank_ctvip=100000
intmemberrank_friend=15000
intmemberrank_heartful=25000
intmemberrank_lovery=40000
intmemberrank_member=14999
intorderhistorymonth=12
intordernewcustomer=5000
intorderpaymentresults=10000
intorderthreshold=25000
intorderthreshold_amazonpay=20000
intorderthreshold_dpay=100000
intorderthreshold_paypay=500000
intorderthresholdcvs=55000
intpointhistorymonth=12
intreviewpoint=50
iswhitemember=true
jsversion=?ver=100023
metatag_common_description_head=海外国内人気のデパコス、オーガニックコスメ、国内未発売ブランド、サロン・クリニック推奨コスメなど約180ブランドが最大85％OFF！約7千点のブランドコスメがなんと【8,000円以上全国送料無料】本物・新品保証でコスメ好きに嬉しい格安化粧品通販サイトです。
metatag_common_h1string=激安通販
metatag_common_keyword=コスメ,激安,コスメティックタイムズ,化粧品,口コミ,送料無料,通販
metatag_common_title_name=ブランドコスメ激安通販のコスメティックタイムズ
private_keyfile_path=D:\inetpub\Public\track\id_rsa
private_passphrase=@CosmeticTimes1234
public_folder=D:\Inetpub\public
remote_addr=172.70.131.72
run_mode=True
salt=wHgn7DdL1cE17P8C
samesite_value=
sftp_upload_path=data
sitename=コスメティックタイムズ
strdatasourcename=CosmeticTimesR
strdivisioncdinitial_catalog=7
strdivisioncdinitial_ecsite=8
strdivisioncdinitial_guest=2
strdivisioncdinitial_mobile=9
strimgserverurlssl=https://img.cosmetic-times.com
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
strmerchantccid=A100000000000001018249cc
strmerchantpw=c618594fdb80c0e161d0c86f4d3a5993cc3292b562efa1fe3fb2311776ec5506
strorderoperatorcd=900001
strreturnsalescd=000147
strsqlstringescape=\
strwebserverip=20.205.112.97
strwebserverurl=https://www.cosmetic-times.com
strwebserverurlssl=https://www.cosmetic-times.com
totalamountlimit=3000
twittercard=summary_large_image
twittersite=@CosmeticTimes
udfgetcodename=Complex type
upload_file_path=D:\Inetpub\public\track\upload\
vc_sftp_password=
vc_sftp_server=xxxx
vc_sftp_user=xxxx
zip_pass=@CosmeticTimes5678

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
basketdata=Struct (0)
cartdata=Struct (0)
carterrdata=Struct (0)
listingadtype=0
sessionid=15D36313BBD0D7C4D27E679BA08C602E.cfusion
urltoken=CFID=1443755&CFTOKEN=96a01dfb410f7654-62304164-B87D-6BCB-13D82BA290AC8A09&jsessionid=15D36313BBD0D7C4D27E679BA08C602E.cfusion

URL Parameters:
campaigncd=thanks-coupon