カート

        SELECT 
            StoreName
            ,StartDate
            ,EndDate
            ,Type
            ,Vals
        FROM SM_CampaignMST
        WHERE 0=0
            AND InvalidFlg='00'
            AND StoreName = 'SIC'
            AND StartDate <= getdate()
            AND EndDate >= getdate()
          
                
            AND Type in ('01','02')
          
        ;
    

        SELECT 
            StoreName
            ,StartDate
            ,EndDate
            ,Type
            ,Vals
        FROM SM_CampaignMST
        WHERE 0=0
            AND InvalidFlg='00'
            AND StoreName = 'SIC'
            AND StartDate <= getdate()
            AND EndDate >= getdate()
          
                
            AND Type in ('01','02')
          
        ;
    

    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
      TOP 10
      ID.ItemCD
      ,ID.BrandCD
      ,ID.UnitPrice
      ,ID.BaseCD
      ,ID.BrandName
      ,ID.BrandEName
      ,ID.ItemName
      ,ID.Net
      ,ID.Color
      ,ID.ReferPrice
      ,ID.SpecialPrice
      ,ID.ConversionPrice
      ,VSD.PossibleStock
      ,ID.ReArriveMailFlg
      ,ID.ITMStartDate
      ,ID.ImageFileName
      ,IsNull(ID.Evaluate,0) AS Evaluate
      ,IsNull(ID.ReviewCnt,0) AS ReviewCnt
      ,IsNull(ID.PriceDownFlg,'00') AS PriceDownFlg
      ,ID.UnreleasedFlg
      ,ID.EcDiscountPrice
      ,ID.ChoiceSetDetailNo
      ,ID.LimitQuty
      ,ID.ChoiceDiscription
      ,ID.ChoiceDiscriptionSP
      ,ID.ChoiceCaption
      ,ID.ChoiceDetailColor
      ,ISNULL(ID.StockBaseShippingAreaCD,'00') AS StockBaseShippingAreaCD
    FROM
      DM_UnitItemMartDT AS ID with(nolock)
      INNER JOIN
      V_StockDT AS VSD WITH (nolock) ON
      ID.ItemCD = VSD.ItemCD
      LEFT JOIN
      DM_RankingItemSalesSummaryDT AS RID WITH(NOLOCK) ON
      ID.ItemCD = RID.ItemCD 
    WHERE
      0=0
      AND VSD.PossibleStock > 0
      AND ISNULL(ID.EcDiscountPrice,ID.UnitPrice) >= ? 
    ORDER BY
      CASE
      WHEN ISNULL(ID.EcDiscountPrice,ID.UnitPrice) - ? <= 500 THEN
        0
      ELSE
        ISNULL(ID.EcDiscountPrice,ID.UnitPrice)
      END,
      ISNULL(RID.SalesQty,0) DESC,
      ISNULL(ID.EcDiscountPrice,ID.UnitPrice)
      ;
  

    SELECT
      ID.ItemCD
      ,ID.BrandCD
      ,ID.UnitPrice
      ,ID.BaseCD
      ,ID.BrandName
      ,ID.BrandEName
      ,ID.ItemName
      ,ID.Net
      ,ID.Color
      ,ID.ReferPrice
      ,ID.SpecialPrice
      ,VSD.PossibleStock
      ,ID.ConversionPrice
      ,ID.ReArriveMailFlg
      ,ID.ITMStartDate
      ,ID.ImageFileName
      ,IsNull(ID.Evaluate,0) AS Evaluate
      ,IsNull(ID.ReviewCnt,0) AS ReviewCnt
      ,IsNull(ID.PriceDownFlg,'00') AS PriceDownFlg
      ,ID.UnreleasedFlg
      ,ID.EcDiscountPrice
      ,ID.ChoiceSetDetailNo
      ,ID.LimitQuty
      ,ID.ChoiceDiscription
      ,ID.ChoiceDiscriptionSP
      ,ID.ChoiceCaption
      ,ID.ChoiceDetailColor
      ,ISNULL(ID.StockBaseShippingAreaCD,'00') AS StockBaseShippingAreaCD
    FROM
      DM_UnitItemMartDT AS ID WITH (nolock)
      INNER JOIN
      V_StockDT AS VSD WITH (nolock) ON
      ID.ItemCD = VSD.ItemCD
    WHERE
      ID.ItemCD IN
        (
        SELECT
          TOP 5 
          ODT.ItemCD
        FROM
          OM_OrderDetailDT ODT  WITH (nolock)
          INNER JOIN
          OM_orderDT OT  WITH (nolock) ON
          OT.OrderKey = ODT.OrderKey
          INNER JOIN
          DM_UnitItemMartDT AS DUM WITH (nolock) ON
          ODT.ItemCD = DUM.ItemCD
          INNER JOIN
          V_StockDT AS VSD WITH (nolock) ON
          ODT.ItemCD = VSD.ItemCD
        WHERE
          OT.OrderKey IN
            (
            SELECT
              OT.OrderKey
            FROM
              OM_OrderDetailDT ODT  WITH (nolock)
              INNER JOIN
              OM_orderDT OT  WITH (nolock) ON
              OT.OrderKey = ODT.OrderKey
              INNER JOIN
              OM_CartDetailDT OCT  WITH (nolock) ON
              OCT.ItemCD = ODT.ItemCD AND
              OCT.CartKey = ? AND
              OCT.InvalidFlg = '00'
            WHERE
              OT.StateCD ='04' AND
              ODT.CancelFlg = '00'
            ) AND
          ODT.ItemCD NOT IN (?)
          AND VSD.PossibleStock > 0
        ORDER BY
          OT.OrderDate DESC
        )
  

    SELECT
      CRT.CartKey
      ,CRT.MemberCD
      ,CTD.ItemCD
      ,CTD.Amount
      ,ISNULL(CTD.StockBaseShippingAreaCD,'00') AS StockBaseShippingAreaCD
      ,CTD.EcSecretCD
      ,CTD.UnitPrice
    FROM
      OM_CartDT AS CRT
      INNER JOIN 
      OM_CartDetailDT AS CTD ON 
      CRT.CartKey = CTD.CartKey
      INNER JOIN 
      DM_UnitItemMartDT AS UIM ON 
      CTD.ItemCD = UIM.ItemCD
    WHERE 0 = 0
      AND CRT.CartKey = ? 
      AND CRT.InvalidFlg = ?
      AND ISNULL(CTD.InvalidFlg,?) = ?
    ORDER BY
      CTD.ItemCD ASC;
  

  SELECT AK.KeyCode
  FROM dbo.SM_AmazonKeyTBL AK
  WHERE AK.KeyName = 'PRIVATE_KEY'

    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\cart\cart_main.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=JSESSIONID=B782340A84353E02228BC74A179FEB9A.cfusion
HTTP_HOST=757713.gxwh.asia
HTTP_REFERER=
HTTP_URL=/cart/cart_main.cfm
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\cart\cart_main.cfm
QUERY_STRING=
REMOTE_ADDR=172.70.126.44
REMOTE_HOST=172.70.126.44
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/cart/cart_main.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=

Cookie Variables:
JSESSIONID=B782340A84353E02228BC74A179FEB9A.cfusion

Form Fields:
ADDITEMCD=
AMOUNT=
CARTTOKENID=
ECSECRETCD=
ITEMCD=
MODE=
MTD=

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=114400
debugflg=0
dtchecklogintime=20231201114400
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=114400
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.126.44
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:
amazon_checkoutreviewreturntype=cart
basketdata=Struct (0)
cartdata=Struct (0)
carterrdata=Struct (0)
cashbackfee=0
cashbackmessage=
listingadtype=0
orderinfo=Struct (1)
refererpage=
savesessionid=B782340A84353E02228BC74A179FEB9A.cfusion
sessionid=B782340A84353E02228BC74A179FEB9A.cfusion
setcashbackfee=0
urltoken=CFID=1440985&CFTOKEN=e6ae59cd191403a6-FEE566B2-B1FB-4702-5EE5A03477F1F20C&jsessionid=B782340A84353E02228BC74A179FEB9A.cfusion

URL Parameters:
POPUP=0
TXTSEARCH=