SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, p.product_id, p.main_image, p.main_list_comment, p.comment2, p.update_date, p.sub_title6, MAX(price02), MAX(price03), MAX(stock), pc.point_rate, p.sales_datetime, p.sales_end_datetime, IF(p.tweet=p.tweet, 1, 0) AS tweet, p.name, p.movie_s, GROUP_CONCAT(cc.name separator ' ') AS classlist, GROUP_CONCAT(pc.stock separator ' ') AS stocklist
FROM dtb_products AS p
LEFT JOIN dtb_products_class AS pc ON p.product_id = pc.product_id
LEFT JOIN dtb_classcategory AS cc ON pc.classcategory_id1 = cc.classcategory_id
WHERE p.product_id IS NOT NULL
AND p.del_flg !=1
AND p.status =1
AND (p.sales_end_datetime IS NULL OR p.sales_end_datetime >= '2024-05-01 16:35:29')
AND pc.price02 > 9090
AND price02 <= 13636
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 518)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
70206 GoneR(ゴナー) Snap Sweat Jacket BLACK
70205 GoneR(ゴナー) Eterno Pull Parka BLACK
70204 GoneR(ゴナー) Eterno Pull Parka ASH
67414 日高さおり × GoneR コラボ限定カバーオールジャケット
52481 【バンドリ!×ゲキクロ 第4弾復刻】GoneR×丸山 彩 コラボ 限定 パーカー
60366 GoneR GR30PK002 Circle Rose Parka Sand Beige
60370 GoneR GR30PK002 Circle Rose Parka Black
50007 【バンドリ!×ゲキクロ 第3弾復刻】GoneR×美竹蘭 コラボ 限定 コーチジャケット
55796 【バンドリ!×ゲキクロ 第2弾復刻】GoneR×花園たえコラボ 限定 スタジアムJKT
54469 【バンドリ!×ゲキクロ第1弾復刻】GoneR×花園たえコラボ 限定 パーカー
29633 GoneR Flannel Check Paint Shirts BlueCH
29634 GoneR Flannel Check Paint Shirts Black CH
44160 GoneR (ゴナー) GR19SW001 Opal Denim Sweat INDIGO
44165 GoneR (ゴナー) GR19OT001 Rose Track Jacket Green
44166 GoneR (ゴナー) GR19OT001 Rose Track Jacket Navy
44167 GoneR (ゴナー) GR19OT001 Rose Track Jacket Black
44175 GoneR (ゴナー) GR19OT002 Switching Shell Parka Beige/Black
44176 GoneR (ゴナー) GR19OT002 Switching Shell Parka Purple/Black
44179 GoneR (ゴナー) GR19OT002 Switching Shell Parka Olive/Black
47075 GoneR (ゴナー) GR20OT001 Rose Logo Zip Jacket White
47076 GoneR (ゴナー) GR20OT001 Rose Logo Zip Jacket Lime Green
50430 GoneR GR22OT002 Rose Skull Duster Coat Black/Purple
50431 GoneR GR22OT002 Rose Skull Duster Coat Black/White
50489 GoneR GR22OT001 Rose Anorak Parka Antique Green
50490 GoneR GR22OT001 Rose Anorak Parka Navy