SELECT SQL_CALC_FOUND_ROWS 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-03-29 10:02:33')
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 MAX(price02) DESC
LIMIT 0, 120
69058 LiSA x GoneR Stadium Jumper Green/Ivory
69059 LiSA x GoneR Stadium Jumper Gold/Navy
69060 LiSA x GoneR Stadium Jumper Black/Ivory
38997 LiSA × GoneR Reversible Souvenir Jacket WhitexBlack - Black
65874 GoneR(ゴナー) Sneakers 90’s MA-1 Black
52607 GoneR -La Neta- Chemical Wash Denim Jacket INDIGO
62793 GoneR GR32OT001 Airgel Insulation Field Coat Khaki
62794 GoneR GR32OT001 Airgel Insulation Field Coat Black
52282 GoneR GR23OT001 Micro Fur Zip Parka Beige
52283 GoneR GR23OT001 Micro Fur Zip Parka Black
52608 GoneR -La Neta- One Wash Denim Jacket BLACK
60853 GoneR Warm Shall Rose Parka Coyote Brown/Black
60854 GoneR Warm Shall Rose Parka Coyote Olive/Black
65300 松山 ダリア×GoneR コラボ 限定 マウンテンパーカー
38993 LiSA × GoneR Long Parka Black
38994 LiSA × GoneR Long Parka Grey
52634 GoneR GR24OT001 Mexico City Mods Coat Black
52635 GoneR GR24OT001 Mexico City Mods Coat Khaki
50430 GoneR GR22OT002 Rose Skull Duster Coat Black/Purple
50431 GoneR GR22OT002 Rose Skull Duster Coat Black/White
52376 GoneR GR23PK002 Rose Sleeve Parka Purple/Black
52377 GoneR Rose Sleeve Parka Black/White
50007 【バンドリ!×ゲキクロ 第3弾復刻】GoneR×美竹蘭 コラボ 限定 コーチジャケット
70206 GoneR(ゴナー) Snap Sweat 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
55796 【バンドリ!×ゲキクロ 第2弾復刻】GoneR×花園たえコラボ 限定 スタジアムJKT
50489 GoneR GR22OT001 Rose Anorak Parka Antique Green
50490 GoneR GR22OT001 Rose Anorak Parka Navy
50491 GoneR GR22OT001 Rose Anorak Parka Black/Purple
50492 GoneR GR22OT001 Rose Anorak Parka Black/White
67414 日高さおり × GoneR コラボ限定カバーオールジャケット
44165 GoneR (ゴナー) GR19OT001 Rose Track Jacket Green
44166 GoneR (ゴナー) GR19OT001 Rose Track Jacket Navy
44167 GoneR (ゴナー) GR19OT001 Rose Track Jacket Black
47075 GoneR (ゴナー) GR20OT001 Rose Logo Zip Jacket White
47076 GoneR (ゴナー) GR20OT001 Rose Logo Zip Jacket Lime Green
52481 【バンドリ!×ゲキクロ 第4弾復刻】GoneR×丸山 彩 コラボ 限定 パーカー
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
70204 GoneR(ゴナー) Eterno Pull Parka ASH
70205 GoneR(ゴナー) Eterno Pull Parka BLACK
60366 GoneR GR30PK002 Circle Rose Parka Sand Beige
60370 GoneR GR30PK002 Circle Rose Parka Black
33577 GoneR (ゴナー) Tie-Dyed Flower Skull Pull Parka A.GREEN
55860 GoneR × 田中聖 Collaboration Parka Black(Red)
60371 GoneR GR30PK001 Chalice Parka Sand Beige
60372 GoneR GR30PK001 Chalice Parka White
60376 GoneR GR30PK001 Chalice Parka Black
60824 (2)YOU×GoneR×GEKIROCK CLOTHING コラボ・バックパック
64366 ADAM at×GEKIROCK CLOTHING×GoneR Collaboration Zip Hoodie
47225 GoneR (ゴナー) GR20SH001 Rose Sleeve Oxford Shirts Ox White
47226 GoneR (ゴナー) GR20SH001 Rose Sleeve Oxford Shirts Ox Blue
47227 GoneR (ゴナー) GR20SH001 Rose Sleeve Oxford Shirts Ox Grey
65866 GoneR(ゴナー) Embroidery College Logo Crew Sweat Sumi
65877 GoneR(ゴナー) Mexican Pattern Real Skull Parka Smokey Green
65879 GoneR(ゴナー) Mexican Pattern Real Skull Parka Sumi
68137 GoneR(ゴナー) GR36SH001 Mexican Skull Shirts Black
68143 GoneR(ゴナー) GR36SH002 Rose Shirts Black
29650 GoneR Heart Skull MA-1 Kahki
29651 GoneR Heart Skull MA-1 Black
55875 GoneR GR26ZP001 Rose Photo Zip Parka White
55876 GoneR GR26ZP001 Rose Photo Zip Parka Heather gray
55877 GoneR GR26ZP001 Rose Photo Zip Parka Olive
55878 GoneR GR26ZP001 Rose Photo Zip Parka Burgundy
55879 GoneR GR26ZP001 Rose Photo Zip Parka Black
60841 GoneR Ska Sweat Parka Sand Beige
60842 GoneR Ska Sweat Parka Mix Grey
60843 GoneR Ska Sweat Parka Stone Blue
44161 GoneR (ゴナー) GR19PK001 Paint Mexican Skull Sweat Parka Heather Grey
44162 GoneR (ゴナー) GR19PK001 Paint Mexican Skull Sweat Parka Purple
44163 GoneR (ゴナー) GR19PK001 Paint Mexican Skull Sweat Parka Red
44164 GoneR (ゴナー) GR19PK001 Paint Mexican Skull Sweat Parka Black
44170 GoneR (ゴナー) GR19PK002 Rose Sleeve Sweat Parka Purple
44172 GoneR (ゴナー) GR19PK002 Rose Sleeve Sweat Parka Red
44173 GoneR (ゴナー) GR19PK002 Rose Sleeve Sweat Parka Black
44196 GoneR (ゴナー) GR19PK002 Rose Sleeve Sweat Parka Heather Grey
51380 GoneR GR23PK001 Rose Sleeve Parka White/Red
51382 GoneR GR23PK001 Rose Sleeve Parka Black/Red
51383 GoneR GR23PK001 Rose Sleeve Parka Black/Purple
51384 GoneR GR23PK001 Rose Sleeve Parka Purple/Red
51385 GoneR GR23PK001 Rose Sleeve Parka Neon Green/Yellow ゲキクロ限定カラー
50485 GoneR GR22PK001 Mexican Design Parka White
50486 GoneR GR22PK001 Mexican Design Parka Cement
50487 GoneR GR22PK001 Mexican Design Parka Black/Purple
50488 GoneR GR22PK001 Mexican Design Parka Black/White
37410 GoneR GR15ZP001 Fire Mexican Skull Zip Parka White
37411 GoneR GR15ZP001 Fire Mexican Skull Zip Parka Red
37412 GoneR GR15ZP001 Fire Mexican Skull Zip Parka Black
37413 GoneR GR15ZP001 Fire Mexican Skull Zip Parka Acid Green
60404 GoneR -La Neta- GRL05PK001New York Logo Parka Red
60406 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Red
60407 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Orange
65873 GoneR(ゴナー) 3D One Point Parka Black
29635 GoneR Kiriste Waffle Pull Parka White
29637 GoneR Kiriste Waffle Pull Parka Black
60847 GoneR Christian Crew Sweat Sand Beige
60849 GoneR Christian Crew Sweat Hether Grey
60852 GoneR Christian Crew Sweat Black
29646 GoneR Basic Logo Zip Parka White
29649 GoneR Basic Logo Zip Parka Black
42741 GoneR (ゴナー) GR18OT001 Logo Line Jersey Black
58703 GoneR GR29SH001 Chambray Work Shirts
37415 GoneR GR15OT001 Rose Cross Coach Jacket Black
37416 GoneR GR15OT001 Rose Cross Coach Jacket Navy
37417 GoneR GR15OT002 New Logo Stadium Jamper Red
37418 GoneR GR15OT002 New Logo Stadium Jamper Black
37419 GoneR GR15OT002 New Logo Stadium Jamper Navy
65301 松山 ダリア×GoneR コラボ 限定 スウェット
33565 GoneR (ゴナー) Flower&Mexican Skull Cardigan Grey
29638 GoneR Flower Bolt Pull Parka White
29639 GoneR Flower Bolt Pull Parka Grey
29640 GoneR Flower Bolt Pull Parka A.Green
29641 GoneR Flower Bolt Pull Parka Black
29642 GoneR Skull Heart Pull Parka White
29643 GoneR Skull Heart Pull Parka Grey
29645 GoneR Skull Heart Pull Parka Black