SELECT product_id, product_class_id, classcategory_id1, classcategory_id2, name, status, product_flag, product_code, price01, price02, stock, deliv_fee, point_rate, sale_limit, comment1, comment3, main_list_comment, main_list_image, main_comment, main_image, main_large_image, file1, file2, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, deliv_date_id, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_product_id1, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_comment1, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_product_id2, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_comment2, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_product_id3, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_comment3, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_product_id5, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_comment5, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_product_id6, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_comment6 FROM (SELECT * FROM (SELECT T3.product_class_id, T3.product_id AS product_id_sub, classcategory_id1, classcategory_id2, T3.rank AS rank1, T4.rank AS rank2, T3.class_id AS class_id1, T4.class_id AS class_id2, stock, price01, price02, stock_unlimited, product_code FROM ( SELECT T1.product_class_id, T1.product_id, classcategory_id1, classcategory_id2, T2.rank, T2.class_id, stock, price01, price02, stock_unlimited, product_code FROM (dtb_products_class AS T1 LEFT JOIN dtb_classcategory AS T2 ON T1.classcategory_id1 = T2.classcategory_id)) AS T3 LEFT JOIN dtb_classcategory AS T4 ON T3.classcategory_id2 = T4.classcategory_id) AS T5 LEFT JOIN dtb_products AS T6 ON product_id_sub = T6.product_id) AS prdcls WHERE del_flg = 0 ORDER BY update_date DESC, product_id DESC
DB Error: unknown error
SELECT product_id, product_class_id, classcategory_id1, classcategory_id2, name, status, product_flag, product_code, price01, price02, stock, deliv_fee, point_rate, sale_limit, comment1, comment3, main_list_comment, main_list_image, main_comment, main_image, main_large_image, file1, file2, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, deliv_date_id, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_product_id1, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_comment1, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_product_id2, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_comment2, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_product_id3, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_comment3, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_product_id5, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_comment5, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_product_id6, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_comment6 FROM (SELECT * FROM (SELECT T3.product_class_id, T3.product_id AS product_id_sub, classcategory_id1, classcategory_id2, T3.rank AS rank1, T4.rank AS rank2, T3.class_id AS class_id1, T4.class_id AS class_id2, stock, price01, price02, stock_unlimited, product_code FROM ( SELECT T1.product_class_id, T1.product_id, classcategory_id1, classcategory_id2, T2.rank, T2.class_id, stock, price01, price02, stock_unlimited, product_code FROM (dtb_products_class AS T1 LEFT JOIN dtb_classcategory AS T2 ON T1.classcategory_id1 = T2.classcategory_id)) AS T3 LEFT JOIN dtb_classcategory AS T4 ON T3.classcategory_id2 = T4.classcategory_id) AS T5 LEFT JOIN dtb_products AS T6 ON product_id_sub = T6.product_id) AS prdcls WHERE del_flg = 0 ORDER BY update_date DESC, product_id DESC [nativecode=1242 ** Subquery returns more than 1 row]
/home/httpd/vhosts/casolea.jp/httpdocs/store/admin/products/index.php 34:LC_Page_Admin_Products_Ex->process
/home/httpd/vhosts/casolea.jp/httpdocs/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_Ex.php 56:LC_Page_Admin_Products->process
/home/httpd/vhosts/casolea.jp/httpdocs/data/class/pages/admin/products/LC_Page_Admin_Products.php 263:SC_Helper_CSV->lfGetProductsCSV
/home/httpd/vhosts/casolea.jp/httpdocs/data/class/helper/SC_Helper_CSV.php 112:SC_Query->select
/home/httpd/vhosts/casolea.jp/httpdocs/data/class/SC_Query.php 95:SC_DbConn->getAll
/home/httpd/vhosts/casolea.jp/httpdocs/data/class/SC_DbConn.php 162:DB_common->getAll
/home/httpd/vhosts/casolea.jp/httpdocs/data/module/DB/common.php 1613:DB_common->query
/home/httpd/vhosts/casolea.jp/httpdocs/data/module/DB/common.php 1167:DB_mysql->simpleQuery
/home/httpd/vhosts/casolea.jp/httpdocs/data/module/DB/mysql.php 324:DB_mysql->mysqlRaiseError
/home/httpd/vhosts/casolea.jp/httpdocs/data/module/DB/mysql.php 894:DB_common->raiseError
/home/httpd/vhosts/casolea.jp/httpdocs/data/module/DB/common.php 1853:PEAR->raiseError
/home/httpd/vhosts/casolea.jp/httpdocs/data/module/PEAR.php 557:DB_Error->DB_Error
/home/httpd/vhosts/casolea.jp/httpdocs/data/module/DB.php 893:PEAR_Error->PEAR_Error