エラーメッセージ




エラーメッセージ
SQLの実行に失敗しました。
select T2.product_id,dtb_products.name,T2.qty,T2.date,dtb_products.main_list_comment,dtb_products.main_list_image,dtb_products.main_comment from (select dtb_order_detail.product_id,sum(dtb_order_detail.quantity) as qty,max(dtb_order.commit_date) as date from dtb_order,dtb_order_detail,dtb_product_categories,dtb_products where dtb_order.order_id = dtb_order_detail.order_id and dtb_order_detail.product_id = dtb_product_categories.product_id and dtb_product_categories.product_id = dtb_products.product_id and dtb_order.status = '5' and () group by dtb_order_detail.product_id order by qty desc,date desc limit 50 offset 0) as T2 left outer join dtb_products on T2.product_id = dtb_products.product_id order by T2.qty desc,T2.date desc