SELECT DISTINCT product_id FROM ( SELECT alldtl.*, dtb_category.rank AS category_rank, T2.category_id, T2.rank AS product_rank FROM ( SELECT dtb_products.product_id, dtb_products.name, dtb_products.deliv_fee, dtb_products.sale_limit, dtb_products.sale_unlimited, dtb_products.rank, dtb_products.status, dtb_products.product_flag, dtb_products.point_rate, dtb_products.comment1, dtb_products.comment2, dtb_products.comment3, dtb_products.comment4, dtb_products.comment5, dtb_products.comment6, dtb_products.note, dtb_products.file1, dtb_products.file2, dtb_products.file3, dtb_products.file4, dtb_products.file5, dtb_products.file6, dtb_products.main_list_comment, dtb_products.main_list_image, dtb_products.main_comment, dtb_products.main_image, dtb_products.main_large_image, dtb_products.sub_title1, dtb_products.sub_comment1, dtb_products.sub_image1, dtb_products.sub_large_image1, dtb_products.sub_title2, dtb_products.sub_comment2, dtb_products.sub_image2, dtb_products.sub_large_image2, dtb_products.sub_title3, dtb_products.sub_comment3, dtb_products.sub_image3, dtb_products.sub_large_image3, dtb_products.sub_title4, dtb_products.sub_comment4, dtb_products.sub_image4, dtb_products.sub_large_image4, dtb_products.sub_title5, dtb_products.sub_comment5, dtb_products.sub_image5, dtb_products.sub_large_image5, dtb_products.sub_title6, dtb_products.sub_comment6, dtb_products.sub_image6, dtb_products.sub_large_image6, dtb_products.del_flg, dtb_products.creator_id, dtb_products.create_date, dtb_products.update_date, dtb_products.deliv_date_id, dtb_products.product_code, dtb_products.ingredient_pdf, dtb_products.ingredient_URL, 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, COUNT(*) as class_count, openprice_flg, openprice_name, job_price01, job_price02, job_price03, job_price04, job_price05, product_yomi FROM dtb_products GROUP BY product_id ) AS alldtl LEFT JOIN dtb_product_categories AS T2 ON alldtl.product_id = T2.product_id LEFT JOIN dtb_category ON T2.category_id = dtb_category.category_id ) AS allcls WHERE del_flg = 0 AND status = 1 AND ) AND (product_id <> 8888) Resource id #28