- -

新規会員登録

町の隠れた、名店街トップへ

• 店舗トップ
• 商品一覧
• カートを見る
• マイページ
• 店舗情報
• お問い合わせ

システムエラーが発生しました。
大変お手数ですが、サイト管理者までご連絡ください。

Copyright © All rights reserved.

本サイトで使用されている著作物（写真、ロゴマーク、図形、文章、イラストなど）に関しては、当店およびその関連団体、または名店街、原著作権者もしくはその所有者に帰属しています。
本サイトに掲載しているすべての内容および著作物について、無断で使用・複製することは固く禁じられています。

TemplateDesign Yu-ya O-mae DIRECTORY Co.,Ltd.

https://rokkobokujyo.kakuretameiten.jp/products/list.php?category_id=692

SERVER_ADDR:133.18.4.110
REMOTE_ADDR:216.73.216.192
USER_AGENT:Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

SELECT DISTINCT product_id FROM 
   (SELECT T1.product_id,
           product_code_min,
           product_code_max,
           price01_min,
           price01_max,
           price02_min,
           price02_max,
           stock_min,
           stock_max,
           stock_unlimited_min,
           stock_unlimited_max,
           del_flg,
           status,
           name,
           comment1,
           comment2,
           comment3,
           main_list_comment,
           main_image,
           main_list_image,
           product_flag,
           deliv_date_id,
           sale_limit,
           point_rate,
           sale_unlimited,
           create_date,
           update_date,
           deliv_fee,
           rank
           ,(SELECT rank AS category_rank
               FROM shopmaster.dtb_category AS T4
              WHERE T1.category_id = T4.category_id) as category_rank
           ,(SELECT category_id AS sub_category_id 
               FROM shopmaster.dtb_category T4 
              WHERE T1.category_id = T4.category_id) as category_id
      FROM (SELECT T0.product_id,
                   T0.del_flg,
                   T0.status,
                   T0.name,
                   T0.comment1,
                   T0.comment2,
                   T0.comment3,
                   T0.main_list_comment,
                   T0.main_image,
                   T0.main_list_image,
                   T0.product_flag,
                   T0.deliv_date_id,
                   T0.sale_limit,
                   T0.point_rate,
                   T0.sale_unlimited,
                   T0.create_date,
                   T0.update_date,
                   T0.deliv_fee,
                   T00.category_id,
                   T00.rank
              FROM dtb_products AS T0
         LEFT JOIN dtb_product_categories AS T00
             USING (product_id)) AS T1 
RIGHT JOIN (SELECT product_id as product_id_sub,
                   MIN(product_code) AS product_code_min,
                   MAX(product_code) AS product_code_max,
                   MIN(price01) AS price01_min,
                   MAX(price01) AS price01_max,
                   MIN(price02) AS price02_min,
                   MAX(price02) AS price02_max,
                   MIN(stock) AS stock_min,
                   MAX(stock) AS stock_max,
                   MIN(stock_unlimited) AS stock_unlimited_min,
                   MAX(stock_unlimited) AS stock_unlimited_max
              FROM dtb_products_class GROUP BY product_id) AS T2 
                ON T1.product_id = T2.product_id_sub
            )  AS allcls  WHERE del_flg = 0 AND status = 1  AND  category_id IN ( ? ) 
DB Error: unknown error

SELECT DISTINCT product_id FROM 
   (SELECT T1.product_id,
           product_code_min,
           product_code_max,
           price01_min,
           price01_max,
           price02_min,
           price02_max,
           stock_min,
           stock_max,
           stock_unlimited_min,
           stock_unlimited_max,
           del_flg,
           status,
           name,
           comment1,
           comment2,
           comment3,
           main_list_comment,
           main_image,
           main_list_image,
           product_flag,
           deliv_date_id,
           sale_limit,
           point_rate,
           sale_unlimited,
           create_date,
           update_date,
           deliv_fee,
           rank
           ,(SELECT rank AS category_rank
               FROM shopmaster.dtb_category AS T4
              WHERE T1.category_id = T4.category_id) as category_rank
           ,(SELECT category_id AS sub_category_id 
               FROM shopmaster.dtb_category T4 
              WHERE T1.category_id = T4.category_id) as category_id
      FROM (SELECT T0.product_id,
                   T0.del_flg,
                   T0.status,
                   T0.name,
                   T0.comment1,
                   T0.comment2,
                   T0.comment3,
                   T0.main_list_comment,
                   T0.main_image,
                   T0.main_list_image,
                   T0.product_flag,
                   T0.deliv_date_id,
                   T0.sale_limit,
                   T0.point_rate,
                   T0.sale_unlimited,
                   T0.create_date,
                   T0.update_date,
                   T0.deliv_fee,
                   T00.category_id,
                   T00.rank
              FROM dtb_products AS T0
         LEFT JOIN dtb_product_categories AS T00
             USING (product_id)) AS T1 
RIGHT JOIN (SELECT product_id as product_id_sub,
                   MIN(product_code) AS product_code_min,
                   MAX(product_code) AS product_code_max,
                   MIN(price01) AS price01_min,
                   MAX(price01) AS price01_max,
                   MIN(price02) AS price02_min,
                   MAX(price02) AS price02_max,
                   MIN(stock) AS stock_min,
                   MAX(stock) AS stock_max,
                   MIN(stock_unlimited) AS stock_unlimited_min,
                   MAX(stock_unlimited) AS stock_unlimited_max
              FROM dtb_products_class GROUP BY product_id) AS T2 
                ON T1.product_id = T2.product_id_sub
            )  AS allcls  WHERE del_flg = 0 AND status = 1  AND  category_id IN ( 692 )  [nativecode=1 ** Can't create/write to file '/tmp/#sql_5bd_2.MYD' (Errcode: 17)]

/shop/html/products/list.php 34:LC_Page_Products_List_Ex->process
/shop/data/class_extends/page_extends/products/LC_Page_Products_List_Ex.php 56:LC_Page_Products_List->process
/shop/data/class/pages/products/LC_Page_Products_List.php 144:LC_Page_Products_List->lfDispProductsList
/shop/data/class/pages/products/LC_Page_Products_List.php 486:SC_Query->getall
/shop/data/class/SC_Query.php 156:SC_DbConn->getAll
/shop/data/class/SC_DbConn.php 164:DB_common->getAll
/shop/data/module/DB/common.php 1610:DB_common->execute
/shop/data/module/DB/common.php 959:DB_mysql->simpleQuery
/shop/data/module/DB/mysql.php 324:DB_mysql->mysqlRaiseError
/shop/data/module/DB/mysql.php 894:DB_common->raiseError
/shop/data/module/DB/common.php 1853:PEAR->raiseError
/shop/data/module/PEAR.php 557:DB_Error->DB_Error
/shop/data/module/DB.php 893:PEAR_Error->PEAR_Error