確かに私の環境でもエラーが出ます。
SQLに問題がありそうで、メッセージも表示されているので追跡すれば解決できそうですね。
っと、今ちょっと余力がないので、表示されたメッセージを貼り付けておきます ^-^;

http://xxxx/eccube200/products/list.php?category_id=1

SELECT DISTINCT ON (price02_min, 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, 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 ) 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: syntax error

SELECT DISTINCT ON (price02_min, 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, 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 ) 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=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON (price02_min, product_id) * FROM (SELECT T1.product_id, produc' at line 1]

/xxxxx/eccube200/html/products/list.php 34:lc_page_products_list_ex->process
/xxxxx/eccube200/data/class_extends/page_extends/products/LC_Page_Products_List_Ex.php 56:lc_page_products_list->process
/xxxxx/eccube200/data/class/pages/products/LC_Page_Products_List.php 127:lc_page_products_list_ex->lfdispproductslist
/xxxxx/eccube200/data/class/pages/products/LC_Page_Products_List.php 465:sc_query->select
/xxxxx/eccube200/data/class/SC_Query.php 67:sc_dbconn->getall
/xxxxx/eccube200/data/class/SC_DbConn.php 156:db_mysql->getall
/xxxxx/eccube200/data/module/DB/common.php 1610:db_mysql->execute
/xxxxx/eccube200/data/module/DB/common.php 959:db_mysql->simplequery
/xxxxx/eccube200/data/module/DB/mysql.php 324:db_mysql->mysqlraiseerror
/xxxxx/eccube200/data/module/DB/mysql.php 894:db_mysql->raiseerror
/xxxxx/eccube200/data/module/DB/common.php 1853:pear->raiseerror
/xxxxx/eccube200/data/module/PEAR.php 557:db_error->db_error
/xxxxx/eccube200/data/module/DB.php 893:db_error->pear_error

----------------
EC Orangeもよろしくお願いしますm(_ _