セール,激安,コスメ,期間限定,化粧品

    --セール情報
    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 5 
      RBSS.BrandCD,
      BM.Name AS BrandName,
      BM.EName AS BrandEName,
      BM.DiscriptionL,
      BM.DiscriptionM,
      BM.LargeBunnerFileName,
      VID.ItemCnt,
      VID.MaxStartDate,
      VID.MaxDiscount,
      ROW_NUMBER() OVER (ORDER BY RBSS.SalesQty DESC)  AS rank
    FROM
      DM_RankingBrandSalesSummaryDT AS RBSS WITH (nolock)
      INNER JOIN
      (
      SELECT
        BrandCD,
        NAME,
        EName,
        DiscriptionL,
        DiscriptionM,
        LargeBunnerFileName
      FROM
        IM_BrandMST
      WHERE
        0 = 0 AND
        InvalidFlg = ? -- 有効
      ) AS BM ON
      RBSS.BrandCD = BM.BrandCD
      INNER JOIN
      (
      SELECT
        VID.BrandCD,
        COUNT(VID.ItemCD) AS ItemCnt,
        MAX(VID.ITMStartDate) AS MaxStartDate,
        MAX(
            CASE
            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
      FROM
        DM_UnitItemMartDT AS VID WITH (nolock)
      GROUP BY
        VID.BrandCD
      ) AS VID ON
      RBSS.BrandCD = VID.BrandCD
    WHERE
      0 = 0
    ORDER BY
      RBSS.SalesQty 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\sale\top.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=/sale/top.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\sale\top.cfm
QUERY_STRING=
REMOTE_ADDR=172.71.254.45
REMOTE_HOST=172.71.254.45
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/sale/top.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=114153
debugflg=0
dtchecklogintime=20231201114153
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=114153
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.71.254.45
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=FC2BF489D3822482513B654E7DC27162.cfusion
urltoken=CFID=1440971&CFTOKEN=13a55bdd7e230a94-FED1F0CE-015D-CF6A-EE8AC8A3121CA630&jsessionid=FC2BF489D3822482513B654E7DC27162.cfusion

URL Parameters:
TXTSEARCH=