ブランド一覧

    SELECT
       BM.BrandCD
      ,BM.Name
      ,BM.BrandInitial
      ,BM.BrandInitialE
      ,BM.Kana
      ,BM.EName
      ,BM.DiscriptionL
      ,BM.DiscriptionM
      ,BM.DiscriptionS
      ,BM.DiscriptionB
      ,BM.SearchKeyWord
      ,BM.BunnerFileName
      ,BM.LargeBunnerFileName
      ,BM.BrandLogoFileName
      ,BM.CountryCD
      ,ROW_NUMBER() OVER (ORDER BY BM.kana)  AS OrderKana    --
      ,ROW_NUMBER() OVER (ORDER BY BM.EName) AS OrderEName   --
      ,'' AS ItemCount
      ,BM.DiscriptionSEO
      ,BM.KeyWordSEO
      ,BM.TitleSEO
      ,BM.ShortName
      ,VID.ItemCnt
      ,VID.MaxStartDate
      ,VID.MaxDiscount
    FROM
      IM_BrandMST AS BM with(nolock)
      INNER JOIN
      (
      SELECT
        VID.BrandCD,
        COUNT(VID.ItemCD) AS ItemCnt,
        MAX(VID.ITMStartDate) AS MaxStartDate,
        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
      FROM
        DM_UnitItemMartDT AS VID with(nolock)
      WHERE
        0 = 0
      
      GROUP BY
        VID.BrandCD
      ) AS VID ON
      BM.BrandCD = VID.BrandCD
    WHERE 
      BM.InvalidFlg = ?  -- 有効
    
    ORDER BY
      BM.Kana
      ;
  

    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 
      FD.FeatureCD,
      FD.Name,
      FD.ListBunnerFile,
      FD.TitleBunnerFile,
      ISNULL(FD.ListBunnerFileSP, FD.ListBunnerFile) AS ListBunnerFileSP,
      ISNULL(FD.DiscriptionSP, FD.Discription) AS DiscriptionSP,
      FD.Discription,
      FD.ItemCls,
      FD.DiscriptionSEO,
      FD.KeyWordSEO,
      FD.TitleSEO,
      FD.StartDate,
      CASE
      WHEN FD.ItemCls ='00' THEN
        ISNULL(FTD.ItemCount,0)
      WHEN FD.ItemCls ='01' THEN
        ISNULL(FID.ItemCount,0)
      WHEN FD.ItemCls ='02' THEN
        ISNULL(RID.ItemCount,0)
      END AS ItemCount
    FROM
      IM_FeatureDT AS FD
      LEFT JOIN
      (
      SELECT
        COUNT(*) AS ItemCount,
        FID.FeatureCD
      FROM
        IM_FeatureItemDT FID
        INNER JOIN
        V_ItemDT AS VID ON
        FID.ItemCD = VID.ItemCD
      WHERE
            FID.InvalidFlg = ? 
      GROUP BY
        FID.FeatureCD
      ) AS FID ON
      FD.FeatureCD = FID.FeatureCD
      LEFT JOIN
      (
      SELECT
        FTD.FeatureCD,
        COUNT(DISTINCT VID.ItemCD) AS ItemCount
      FROM
        IM_FeatureTroubleDT AS FTD
        INNER JOIN
        IM_ItemTroubleDT AS ITD ON
        FTD.SubTroubleCD = ITD.SubTroubleCD
        INNER JOIN
        V_ItemDT AS VID ON
        ITD.ItemCD = VID.ItemCD
      WHERE
            FTD.InvalidFlg = ?
        AND ITD.InvalidFlg = ? 
      GROUP BY
        FTD.FeatureCD
      ) AS FTD ON
      FD.FeatureCD = FTD.FeatureCD
      LEFT JOIN
      (
      SELECT
        COUNT(*) AS ItemCount,
        RD.ReferenceCD AS FeatureCD
      FROM
        IM_ResponsiveDT AS RD
        INNER JOIN
        IM_ResponsiveItemDT AS RID ON
        RD.ResponsiveNo = RID.ResponsiveNo
        INNER JOIN
        V_ItemDT AS VID ON
        RID.ItemCD = VID.ItemCD
      WHERE
            RD.InvalidFlg = ? 
        AND RID.InvalidFlg = ? 
      GROUP BY
        RD.ReferenceCD
      ) AS RID ON
      FD.FeatureCD = RID.FeatureCD
    
      INNER JOIN IM_FeatureTagDT IFD
        ON IFD.FeatureCD = FD.FeatureCD
        AND IFD.tagNo = ? 
    WHERE 
          FD.InvalidFlg = ?  -- 有効
      AND CONVERT(varchar, FD.StartDate, 120) <= CONVERT(varchar, GETDATE(), 120)
      AND CONVERT(varchar, FD.EndDate, 120) >= CONVERT(varchar, GETDATE(), 120)
    
    ORDER BY
      FD.StartDate DESC,
      FD.FeatureCD DESC;
  

    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 = ?
  ;

    SELECT
      BM.BrandCD,
      BM.Name,
      BM.EName,
      tmp1.ITMStartDate,
      tmp1.ItemCnt,
      tmp1.MaxDiscount
    FROM
      (
      SELECT
        VID.BrandCD,
        MAX(VID.ITMStartDate) AS ITMStartDate,
        COUNT(VID.ItemCD) AS ItemCnt,
        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
      FROM
        DM_UnitItemMartDT AS VID WITH (nolock)
        INNER JOIN
        IM_ItemMST AS ITM WITH (nolock) ON
        VID.ItemCD = ITM.ItemCD
      GROUP BY
        VID.BrandCD
      HAVING
        CONVERT(VARCHAR, MAX(VID.ITMStartDate), 120) >= DATEADD(MONTH, - 3, GETDATE())
      ) AS tmp1
      INNER JOIN
      IM_BrandMST AS BM WITH (nolock) ON
      tmp1.BrandCD = BM.BrandCD
    ORDER BY
      tmp1.ITMStartDate DESC,
      tmp1.BrandCD ASC
  

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitialE IN( ?)
      
      ORDER BY
      
        OrderEName
      

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\brand\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=/brand/top.cfm?lang=en?lang=en
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\brand\top.cfm
QUERY_STRING=lang=en
REMOTE_ADDR=108.162.241.182
REMOTE_HOST=108.162.241.182
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/brand/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=140327
debugflg=0
dtchecklogintime=20231201140327
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=140327
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=108.162.241.182
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=5EA796F1130AF23FC5452368B4029935.cfusion
urltoken=CFID=1441088&CFTOKEN=3325e30f5d135b23-03E2336A-AD6D-351F-2AA3CD3FFC380488&jsessionid=5EA796F1130AF23FC5452368B4029935.cfusion

URL Parameters:
lang=en