SELECT DISTINCT price02_min, product_id, product_code_min, product_code_max, name, comment1, comment2, comment3, main_list_comment, main_image, main_list_image, price01_min, price01_max, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max, point_rate, sale_limit, sale_unlimited, deliv_date_id, deliv_fee, status, product_flag, create_date, del_flg 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,            deliv_fee,            rank            ,(SELECT rank AS category_rank                FROM dtb_category AS T4               WHERE T1.category_id = T4.category_id) as category_rank            ,(SELECT category_id AS sub_category_id                 FROM 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.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 T1 WHERE del_flg = 0 AND status = 1  AND  category_id IN ( ?,? ,? ,?  )   ORDER BY price02_min ASC, product_id ASC  LIMIT 15 OFFSET 0
DB Error: unknown error

SELECT DISTINCT price02_min, product_id, product_code_min, product_code_max, name, comment1, comment2, comment3, main_list_comment, main_image, main_list_image, price01_min, price01_max, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max, point_rate, sale_limit, sale_unlimited, deliv_date_id, deliv_fee, status, product_flag, create_date, del_flg 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,            deliv_fee,            rank            ,(SELECT rank AS category_rank                FROM dtb_category AS T4               WHERE T1.category_id = T4.category_id) as category_rank            ,(SELECT category_id AS sub_category_id                 FROM 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.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 T1 WHERE del_flg = 0 AND status = 1  AND  category_id IN ( 1,'3' ,'4' ,'5'  )   ORDER BY price02_min ASC, product_id ASC  LIMIT 15 OFFSET 0 [nativecode=1037 ** Out of memory; restart server and try again (needed 65528 bytes)]

E:\data\html_docs\eccube2\html\products\list.php 34:LC_Page_Products_List_Ex->process
E:\data\html_docs\eccube2\data\class_extends\page_extends\products\LC_Page_Products_List_Ex.php 56:LC_Page_Products_List->process
E:\data\html_docs\eccube2\data\class\pages\products\LC_Page_Products_List.php 127:LC_Page_Products_List->lfDispProductsList
E:\data\html_docs\eccube2\data\class\pages\products\LC_Page_Products_List.php 475:SC_Query->select
E:\data\html_docs\eccube2\data\class\SC_Query.php 67:SC_DbConn->getAll
E:\data\html_docs\eccube2\data\class\SC_DbConn.php 156:DB_common->getAll
E:\data\html_docs\eccube2\data\module\DB\common.php 1610:DB_common->execute
E:\data\html_docs\eccube2\data\module\DB\common.php 959:DB_mysql->simpleQuery
E:\data\html_docs\eccube2\data\module\DB\mysql.php 324:DB_mysql->mysqlRaiseError
E:\data\html_docs\eccube2\data\module\DB\mysql.php 894:DB_common->raiseError
E:\data\html_docs\eccube2\data\module\DB\common.php 1853:PEAR->raiseError
E:\data\html_docs\eccube2\data\module\PEAR.php 557:DB_Error->DB_Error
E:\data\html_docs\eccube2\data\module\DB.php 893:PEAR_Error->PEAR_Error