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-04-29 02:01:25')
AND FIND_IN_SET(1, p.color)
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
69060 LiSA x GoneR Stadium Jumper Black/Ivory
38997 LiSA × GoneR Reversible Souvenir Jacket WhitexBlack - Black
65874 GoneR(ゴナー) Sneakers 90’s MA-1 Black
62794 GoneR GR32OT001 Airgel Insulation Field Coat Black
52283 GoneR GR23OT001 Micro Fur Zip Parka Black
52608 GoneR -La Neta- One Wash Denim Jacket BLACK
60854 GoneR Warm Shall Rose Parka Coyote Olive/Black
65300 松山 ダリア×GoneR コラボ 限定 マウンテンパーカー
38993 LiSA × GoneR Long Parka Black
52634 GoneR GR24OT001 Mexico City Mods Coat Black
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
50491 GoneR GR22OT001 Rose Anorak Parka Black/Purple
50492 GoneR GR22OT001 Rose Anorak Parka Black/White
67414 日高さおり × GoneR コラボ限定カバーオールジャケット
44167 GoneR (ゴナー) GR19OT001 Rose Track Jacket Black
70205 GoneR(ゴナー) Eterno Pull Parka BLACK
60370 GoneR GR30PK002 Circle Rose Parka Black
55860 GoneR × 田中聖 Collaboration Parka Black(Red)
60376 GoneR GR30PK001 Chalice Parka Black
60824 (2)YOU×GoneR×GEKIROCK CLOTHING コラボ・バックパック
64366 ADAM at×GEKIROCK CLOTHING×GoneR Collaboration Zip Hoodie
65866 GoneR(ゴナー) Embroidery College Logo Crew Sweat Sumi
65879 GoneR(ゴナー) Mexican Pattern Real Skull Parka Sumi
68137 GoneR(ゴナー) GR36SH001 Mexican Skull Shirts Black
68143 GoneR(ゴナー) GR36SH002 Rose Shirts Black
29651 GoneR Heart Skull MA-1 Black
55879 GoneR GR26ZP001 Rose Photo Zip Parka Black
44164 GoneR (ゴナー) GR19PK001 Paint Mexican Skull Sweat Parka Black
44173 GoneR (ゴナー) GR19PK002 Rose Sleeve Sweat Parka Black
51382 GoneR GR23PK001 Rose Sleeve Parka Black/Red
51383 GoneR GR23PK001 Rose Sleeve Parka Black/Purple
51385 GoneR GR23PK001 Rose Sleeve Parka Neon Green/Yellow ゲキクロ限定カラー
50487 GoneR GR22PK001 Mexican Design Parka Black/Purple
50488 GoneR GR22PK001 Mexican Design Parka Black/White
37412 GoneR GR15ZP001 Fire Mexican Skull Zip Parka Black
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
29637 GoneR Kiriste Waffle Pull Parka Black
60852 GoneR Christian Crew Sweat Black
29649 GoneR Basic Logo Zip Parka Black
42741 GoneR (ゴナー) GR18OT001 Logo Line Jersey Black
37415 GoneR GR15OT001 Rose Cross Coach Jacket Black
37418 GoneR GR15OT002 New Logo Stadium Jamper Black
65301 松山 ダリア×GoneR コラボ 限定 スウェット
29641 GoneR Flower Bolt Pull Parka Black
29645 GoneR Skull Heart Pull Parka Black
42743 GoneR (ゴナー) GR18LD001 Red Pepper Sweat One Piece Black
60823 (2)YOU×GoneR×GEKIROCK CLOTHING コラボ・ロンT
68142 GoneR(ゴナー) GR36PT001 Mexican Skull Shorts Pants Black
68144 GoneR(ゴナー) GR36PT002 Rose Shorts Pants Black
23350 GoneR Flower Star Shirts Parka - Black
29663 GoneR Lady's Heart Skull Pull Parka Black
29665 GoneR Lady's Flower Bolt Pull Parka Black
69061 LiSA x GoneR SnapBack Cap White/Black
69062 LiSA x GoneR SnapBack Cap Black/White
47229 GoneR (ゴナー) GR20PT001 GR Short Pants Black
36474 GoneR Candle Mexican Skull Short Pants Black
23347 GoneR GoneR × NEeeSAN Crew Neck Sweat - Black
52483 【バンドリ!×ゲキクロ 第4弾復刻】GoneR×丸山 彩 コラボ 限定 L/S Tシャツ
61062 水野ギイ×GoneR コラボ・ロングスリーブTEE
67416 日高さおり × GoneR コラボ限定ウエストバッグ
71420 GoneR (ゴナー) Bi-Color Logo L/S T-Shirts White/Black
71421 GoneR (ゴナー) Bi-Color Logo L/S T-Shirts Black/White
29667 GoneR Star Cross Sweat Maxi Skart Navy
29668 GoneR Star Cross Sweat Maxi Skart Black
42737 GoneR (ゴナー) GR18LS002 Rose Long Pocket Long T-Shirts White/Black
42740 GoneR (ゴナー) GR18LS002 Rose Long Pocket Long T-Shirts Black/Orange
43465 【ゲキクロ限定】GoneR (ゴナー) Rose Long Pocket Long T-Shirts Black/White
59292 GoneR GR29CT004 Mexican Round Design T-Shirts Black
70157 GoneR(ゴナー) Embroidery Pocket L/S T-Shirts Black
70158 GoneR(ゴナー) Boa Logo Bucket Hat Black
71416 GoneR (ゴナー) Mexican Butterfly L/S T-Shirts Black
71419 GoneR (ゴナー) Neon Cross L/S T-Shirts Black
50009 【バンドリ!×ゲキクロ 第3弾復刻】GoneR×美竹蘭 コラボ 限定 バッグ
55855 GoneR × 大内慶 Collaboration L/S T-Shirts Black
55886 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Black
62782 GoneR GR32LS001 Wall decoration L/S T-Sirts Black/Red
63313 GoneR (ゴナー) GR33CT004 Mexican Pattern T-Sirts Black
63316 GoneR (ゴナー) GR33SP001 Ethnic Hoodie T-Sirts Black
65302 松山 ダリア×GoneR コラボ 限定 キャップ
65863 GoneR(ゴナー) Flash Sleeve L/S T-Shirts Black
68027 GoneR(ゴナー) GR36CT002 Cheart T-Shirts Black
68031 GoneR(ゴナー) GR36LS001 Fire Rose L/S T-Shirts Black
68033 GoneR(ゴナー) GR36LS002 Cross Mexican Skull L/S T-Shirts Black
68035 GoneR(ゴナー) GR36LS003 Rose “GR” L/S T-Shirts Black
69211 GoneR(ゴナー) GR37CT002 Rose Ribbon T-Shirt Black/Red
69212 GoneR(ゴナー) GR37CT002 Rose Ribbon T-Shirt Black/Purple
69214 GoneR(ゴナー) GR37CT003 Mix Design T-Shirt Black/Red
69215 GoneR(ゴナー) GR37CT003 Mix Design T-Shirt Black/Purple
33574 GoneR (ゴナー) Candle Mexican Skull Drawstring One Piece Black
42736 GoneR (ゴナー) GR18LS001 Red Pepper Long T-Shirts Black
47074 GoneR (ゴナー) GR20LS003 Rose Logo L/S T-Shirts Black
47082 GoneR (ゴナー) GR20LS001 Color Maria Logo L/S T-Shirts Black
47084 GoneR (ゴナー) GR20LS002 『G』 Rose L/S T-Shirts Black
47224 GoneR (ゴナー) GR20CT001 Cross Rose T-Shirts White
47851 【ゲキクロ限定】GoneR (ゴナー) Rose Logo L/S T-Shirts Black/Purple
48524 GoneR GR21CT005 Mexican Design T-Shrits Black
48530 GoneR GR21LD003 Circular Flare Skirt Black
52612 GoneR -La Neta- La Neta 6 Panel Cap BLACK/PURPLE
52627 GoneR GR24LS001 Barbed Wire Rose L/S T-Shirts Black
52644 GoneR × LESSTRESS GR24LSW00 GoneR × LESSTRESS L/S T-Shirts Black
53059 【ゲキクロ限定】GoneR GR24LS001 Barbed Wire Rose L/S T-Shirts BLACK/PURPLE
57999 GoneR GR28LS002 Rose Arrange Skull L/S T-Shirts Black
60388 GoneR GR30LS002 Spiritus L/S T-Shirts Black
69216 GoneR(ゴナー) GR37CP001 Flat Visor Mesh Cap Black/Grey
69217 GoneR(ゴナー) GR37CP001 Flat Visor Mesh Cap Black/Black
71411 GoneR (ゴナー) Graffiti Logo T-Shirts White
71413 GoneR (ゴナー) Graffiti Logo T-Shirts Black
55874 GoneR GR26OT001 Mexican Design Drivers jacket Black
60402 GoneR -La Neta- GRL05OT001 Embroidery Coverall Jacket Black
29631 GoneR Mexican Skull Pocket L/S T-Shirts BLACK
33564 GoneR (ゴナー) Candle Mexican Skull Long T-Shirts Black
33579 GoneR (ゴナー) Candle Mexican Skull Maxi Skirt Black
36514 GoneR Rose『X』 Maxi Skirt Black/Pink