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-28 14:43:41')
AND pc.classcategory_id1 IN( 159)
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
62793 GoneR GR32OT001 Airgel Insulation Field Coat Khaki
62794 GoneR GR32OT001 Airgel Insulation Field Coat Black
47075 GoneR (ゴナー) GR20OT001 Rose Logo Zip Jacket White
47076 GoneR (ゴナー) GR20OT001 Rose Logo Zip Jacket Lime Green
52481 【バンドリ!×ゲキクロ 第4弾復刻】GoneR×丸山 彩 コラボ 限定 パーカー
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
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
64366 ADAM at×GEKIROCK CLOTHING×GoneR Collaboration Zip Hoodie
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
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
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
60404 GoneR -La Neta- GRL05PK001New York Logo Parka Red
60406 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Red
65873 GoneR(ゴナー) 3D One Point Parka Black
60847 GoneR Christian Crew Sweat Sand Beige
60849 GoneR Christian Crew Sweat Hether Grey
60852 GoneR Christian Crew Sweat Black
65301 松山 ダリア×GoneR コラボ 限定 スウェット
60823 (2)YOU×GoneR×GEKIROCK CLOTHING コラボ・ロンT
67415 日高さおり × GoneR コラボ限定ロンT
50008 【バンドリ!×ゲキクロ 第3弾復刻】GoneR×美竹蘭 コラボ 限定 L/S T-Shirt
52483 【バンドリ!×ゲキクロ 第4弾復刻】GoneR×丸山 彩 コラボ 限定 L/S Tシャツ
61062 水野ギイ×GoneR コラボ・ロングスリーブTEE
71420 GoneR (ゴナー) Bi-Color Logo L/S T-Shirts White/Black
71421 GoneR (ゴナー) Bi-Color Logo L/S T-Shirts Black/White
55795 【バンドリ!×ゲキクロ 第2弾復刻】GoneR×花園たえコラボ 限定 L/S Tシャツ
62791 GoneR (ゴナー) GR32LS003 Tie-dye One Point Logo L/S T-Sirts Red
71414 GoneR (ゴナー) Mexican Butterfly L/S T-Shirts White
71415 GoneR (ゴナー) Mexican Butterfly L/S T-Shirts Charcoal
71416 GoneR (ゴナー) Mexican Butterfly L/S T-Shirts Black
71417 GoneR (ゴナー) Neon Cross L/S T-Shirts White
71418 GoneR (ゴナー) Neon Cross L/S T-Shirts Charcoal
71419 GoneR (ゴナー) Neon Cross L/S T-Shirts Black
47231 GoneR (ゴナー) GR20CTW001 GoneR × YOICHIRO T-Shirts White
54470 【バンドリ!×ゲキクロ第1弾復刻】GoneR×花園たえコラボ 限定 Tシャツ
55854 GoneR × 大内慶 Collaboration L/S T-Shirts Dark chocolate
55855 GoneR × 大内慶 Collaboration L/S T-Shirts Black
58006 GoneR GR28LS004 Tie-dye Cactus Flower L/S T-Shirts White
62779 GoneR GR32LS001 Wall decoration L/S T-Sirts Purple
62782 GoneR GR32LS001 Wall decoration L/S T-Sirts Black/Red
62783 GoneR GR32LS002 Fire Pattern L/S T-Sirts White
64367 ADAM at×GEKIROCK CLOTHING×GoneR Collaboration T-shirts -ROSE-
64368 ADAM at×GEKIROCK CLOTHING×GoneR Collaboration T-shirts -APPLE-
65860 GoneR(ゴナー) Flash Sleeve L/S T-Shirts White
65863 GoneR(ゴナー) Flash Sleeve L/S T-Shirts Black
68031 GoneR(ゴナー) GR36LS001 Fire Rose L/S T-Shirts Black
68032 GoneR(ゴナー) GR36LS001 Fire Rose L/S T-Shirts White
68033 GoneR(ゴナー) GR36LS002 Cross Mexican Skull L/S T-Shirts Black
68034 GoneR(ゴナー) GR36LS002 Cross Mexican Skull L/S T-Shirts White
68035 GoneR(ゴナー) GR36LS003 Rose “GR” L/S T-Shirts Black
68036 GoneR(ゴナー) GR36LS003 Rose “GR” L/S T-Shirts White
69210 GoneR(ゴナー) GR37CT002 Rose Ribbon T-Shirt White
69211 GoneR(ゴナー) GR37CT002 Rose Ribbon T-Shirt Black/Red
69212 GoneR(ゴナー) GR37CT002 Rose Ribbon T-Shirt Black/Purple
69213 GoneR(ゴナー) GR37CT003 Mix Design T-Shirt White
69214 GoneR(ゴナー) GR37CT003 Mix Design T-Shirt Black/Red
69215 GoneR(ゴナー) GR37CT003 Mix Design T-Shirt Black/Purple
47069 GoneR (ゴナー) GR20LS003 Rose Logo L/S T-Shirts White
47072 GoneR (ゴナー) GR20LS003 Rose Logo L/S T-Shirts Red
47073 GoneR (ゴナー) GR20LS003 Rose Logo L/S T-Shirts Royal
47074 GoneR (ゴナー) GR20LS003 Rose Logo L/S T-Shirts Black
47079 GoneR (ゴナー) GR20LS001 Color Maria Logo L/S T-Shirts White
47080 GoneR (ゴナー) GR20LS001 Color Maria Logo L/S T-Shirts Lirsh Green
47081 GoneR (ゴナー) GR20LS001 Color Maria Logo L/S T-Shirts Red
47082 GoneR (ゴナー) GR20LS001 Color Maria Logo L/S T-Shirts Black
47083 GoneR (ゴナー) GR20LS002 『G』 Rose L/S T-Shirts White
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
47852 【ゲキクロ限定】GoneR (ゴナー) Rose Logo L/S T-Shirts White/Purple
48469 GoneR GR21CT001 Whole Surface Logo T-Shirts
48523 GoneR GR21CT005 Mexican Design T-Shrits White
48524 GoneR GR21CT005 Mexican Design T-Shrits Black
52624 GoneR GR24LS001 Barbed Wire Rose L/S T-Shirts White
52625 GoneR GR24LS001 Barbed Wire Rose L/S T-Shirts Light Pink
52626 GoneR GR24LS001 Barbed Wire Rose L/S T-Shirts Light Blue
52627 GoneR GR24LS001 Barbed Wire Rose L/S T-Shirts Black
52628 GoneR GR24LS002 GoneR Azteca L/S T-Shirts White
52642 GoneR × LESSTRESS GR24LSW00 GoneR × LESSTRESS L/S T-Shirts Light Pink
52643 GoneR × LESSTRESS GR24LSW00 GoneR × LESSTRESS L/S T-Shirts Light Blue
52644 GoneR × LESSTRESS GR24LSW00 GoneR × LESSTRESS L/S T-Shirts Black
53057 【ゲキクロ限定】GoneR GR24LS001 Barbed Wire Rose L/S T-Shirts WHITE/PURPLE
53059 【ゲキクロ限定】GoneR GR24LS001 Barbed Wire Rose L/S T-Shirts BLACK/PURPLE
57991 GoneR GR28LS001 Rainbow Rose L/S T-Shirts Sand
57999 GoneR GR28LS002 Rose Arrange Skull L/S T-Shirts Black
60384 GoneR GR30LS002 Spiritus L/S T-Shirts White
71411 GoneR (ゴナー) Graffiti Logo T-Shirts White
71412 GoneR (ゴナー) Graffiti Logo T-Shirts Charcoal
71413 GoneR (ゴナー) Graffiti Logo T-Shirts Black
60399 GoneR -La Neta- GRL05OT001 Embroidery Coverall Jacket Safari Beige
60402 GoneR -La Neta- GRL05OT001 Embroidery Coverall Jacket Black
48470 GoneR GR21CT003 Bat Rose T-Shirts White
48471 GoneR GR21CT003 Bat Rose T-Shirts Purple
48472 GoneR GR21CT003 Bat Rose T-Shirts Black
48473 GoneR GR21CT004 Rose Earth Skull T-Shirts White
50326 GoneR GR22LS001 Box Logo Sleeve L/S T-Shirts Black/White
50327 GoneR GR22LS001 Box Logo Sleeve L/S T-Shirts Black/Purple
50328 GoneR GR22LS001 Box Logo Sleeve L/S T-Shirts White
50330 GoneR GR22LS002 Rose Sleeve L/S T-Shirts Purple
50331 GoneR GR22LS002 Rose Sleeve L/S T-Shirts Black/Purple