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

戻る
このページのTOPへ
Copyright(C) 2009  INTERMEDIA-RYO
http://www.intermedia-ryo.com/products/list.php

SERVER_ADDR:202.221.29.150
REMOTE_ADDR:18.97.9.171
USER_AGENT:CCBot/2.0 (https://commoncrawl.org/faq/)

SELECT DISTINCT product_id FROM 
 (SELECT
                    pr.product_id
                    ,pl.product_code_min
                    ,pl.product_code_max
                    ,pl.price01_min
                    ,pl.price01_max
                    ,pl.price02_min
                    ,pl.price02_max
                    ,pl.stock_min
                    ,pl.stock_max
                    ,pl.stock_unlimited_min
                    ,pl.stock_unlimited_max
                    ,pr.del_flg
                    ,pr.status
                    ,pr.name
                    ,pr.comment1
                    ,pr.comment2
                    ,pr.comment3
                    ,pr.main_list_comment
                    ,pr.main_image
                    ,pr.main_list_image
                    ,pr.product_flag
                    ,pr.deliv_date_id
                    ,pr.sale_limit
                    ,pr.point_rate
                    ,pr.sale_unlimited
                    ,pr.create_date
                    ,pr.deliv_fee
                    ,pc.rank
                    ,cc.rank AS category_rank
                    ,cc.category_id
                FROM
                    (((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 pl
                    LEFT JOIN dtb_products AS pr ON pl.product_id_sub = pr.product_id) LEFT JOIN dtb_product_categories AS pc ON pr.product_id = pc.product_id) LEFT JOIN dtb_category AS cc ON pc.category_id = cc.category_id)  AS allcls  WHERE del_flg = 0 AND status = 1 
DB Error: unknown error

SELECT DISTINCT product_id FROM 
 (SELECT
                    pr.product_id
                    ,pl.product_code_min
                    ,pl.product_code_max
                    ,pl.price01_min
                    ,pl.price01_max
                    ,pl.price02_min
                    ,pl.price02_max
                    ,pl.stock_min
                    ,pl.stock_max
                    ,pl.stock_unlimited_min
                    ,pl.stock_unlimited_max
                    ,pr.del_flg
                    ,pr.status
                    ,pr.name
                    ,pr.comment1
                    ,pr.comment2
                    ,pr.comment3
                    ,pr.main_list_comment
                    ,pr.main_image
                    ,pr.main_list_image
                    ,pr.product_flag
                    ,pr.deliv_date_id
                    ,pr.sale_limit
                    ,pr.point_rate
                    ,pr.sale_unlimited
                    ,pr.create_date
                    ,pr.deliv_fee
                    ,pc.rank
                    ,cc.rank AS category_rank
                    ,cc.category_id
                FROM
                    (((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 pl
                    LEFT JOIN dtb_products AS pr ON pl.product_id_sub = pr.product_id) LEFT JOIN dtb_product_categories AS pc ON pr.product_id = pc.product_id) LEFT JOIN dtb_category AS cc ON pc.category_id = cc.category_id)  AS allcls  WHERE del_flg = 0 AND status = 1  [nativecode=1030 ** Got error 28 from storage engine]

/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/html/products/list.php 34:LC_Page_Products_List_Ex->process
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/class_extends/page_extends/products/LC_Page_Products_List_Ex.php 56:LC_Page_Products_List->process
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/class/pages/products/LC_Page_Products_List.php 132:LC_Page_Products_List->lfDispProductsList
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/class/pages/products/LC_Page_Products_List.php 471:SC_Query->getall
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/class/SC_Query.php 156:SC_DbConn->getAll
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/class/SC_DbConn.php 162:DB_common->getAll
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/module/DB/common.php 1613:DB_common->query
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/module/DB/common.php 1167:DB_mysql->simpleQuery
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/module/DB/mysql.php 324:DB_mysql->mysqlRaiseError
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/module/DB/mysql.php 894:DB_common->raiseError
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/module/DB/common.php 1853:PEAR->raiseError
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/module/PEAR.php 557:DB_Error->DB_Error
/home/userabo/web/www.intermedia-ryo.com/eccube/eccube-2.3.4/data/module/DB.php 893:PEAR_Error->PEAR_Error