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 06:13:14')
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, 240
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
33573 GoneR (ゴナー) Pineapple Skull Pull Parka White
33575 GoneR (ゴナー) Pineapple Skull Pull Parka A.GREEN
42742 GoneR (ゴナー) GR18LD001 Red Pepper Sweat One Piece Grey
42743 GoneR (ゴナー) GR18LD001 Red Pepper Sweat One Piece Black
60823 (2)YOU×GoneR×GEKIROCK CLOTHING コラボ・ロンT
67415 日高さおり × GoneR コラボ限定ロンT
37422 GoneR GR15LD002 Two Face Sweat One-Piece Black
37423 GoneR GR15LD002 Two Face Sweat One-Piece Grey
68142 GoneR(ゴナー) GR36PT001 Mexican Skull Shorts Pants Black
68144 GoneR(ゴナー) GR36PT002 Rose Shorts Pants Black
23348 GoneR Flower Star Shirts Parka - White
23349 GoneR Flower Star Shirts Parka - Chambray
23350 GoneR Flower Star Shirts Parka - Black
29662 GoneR Lady's Heart Skull Pull Parka V.Heather
29663 GoneR Lady's Heart Skull Pull Parka Black
29664 GoneR Lady's Flower Bolt Pull Parka V.Heather
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
23342 GoneR Mexican Skull Short Pants - Grey
23344 GoneR Mexican Skull Short Pants - Black
23356 GoneR Flower Skull Cardigan - Grey
23357 GoneR Flower Skull Cardigan - Navy
23358 GoneR Flower Skull Cardigan - Black
47228 GoneR (ゴナー) GR20PT001 GR Short Pants Grey
47229 GoneR (ゴナー) GR20PT001 GR Short Pants Black
54139 GoneR Rolled Shirts skirt Red Check
54140 GoneR Rolled Shirts skirt Yellow Check
54141 GoneR Rolled Shirts skirt Black Check
33570 GoneR (ゴナー) Rose&Mexican Skull Long T-Shirts White
36474 GoneR Candle Mexican Skull Short Pants Black
36475 GoneR Candle Mexican Skull Short Pants Grey
23345 GoneR GoneR × NEeeSAN Crew Neck Sweat - White
23346 GoneR GoneR × NEeeSAN Crew Neck Sweat - Grey
23347 GoneR GoneR × NEeeSAN Crew Neck Sweat - Black
50008 【バンドリ!×ゲキクロ 第3弾復刻】GoneR×美竹蘭 コラボ 限定 L/S T-Shirt
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
55795 【バンドリ!×ゲキクロ 第2弾復刻】GoneR×花園たえコラボ 限定 L/S Tシャツ
29666 GoneR Star Cross Sweat Maxi Skart Grey
29667 GoneR Star Cross Sweat Maxi Skart Navy
29668 GoneR Star Cross Sweat Maxi Skart Black
37427 GoneR GR15LD003 New Logo Maxi Skirt Black
37429 GoneR GR15LD003 New Logo Maxi Skirt Navy
42737 GoneR (ゴナー) GR18LS002 Rose Long Pocket Long T-Shirts White/Black
42738 GoneR (ゴナー) GR18LS002 Rose Long Pocket Long T-Shirts Orang/Yellow
42739 GoneR (ゴナー) GR18LS002 Rose Long Pocket Long T-Shirts Yellow/White
42740 GoneR (ゴナー) GR18LS002 Rose Long Pocket Long T-Shirts Black/Orange
43464 【ゲキクロ限定】GoneR (ゴナー) Rose Long Pocket Long T-Shirts White/Yellow
43465 【ゲキクロ限定】GoneR (ゴナー) Rose Long Pocket Long T-Shirts Black/White
59289 GoneR GR29CT004 Mexican Round Design T-Shirts White
59290 GoneR GR29CT004 Mexican Round Design T-Shirts Acid Blue
59291 GoneR GR29CT004 Mexican Round Design T-Shirts Vintage Natural
59292 GoneR GR29CT004 Mexican Round Design T-Shirts Black
62791 GoneR (ゴナー) GR32LS003 Tie-dye One Point Logo L/S T-Sirts Red
70156 GoneR(ゴナー) Embroidery Pocket L/S T-Shirts White
70157 GoneR(ゴナー) Embroidery Pocket L/S T-Shirts Black
70158 GoneR(ゴナー) Boa Logo Bucket Hat Black
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
24854 GoneR Cross Skull T-Shirts
29621 GoneR Rose Skull Base Ball T-Shirts WH-NV
33558 GoneR (ゴナー) Rose&Mexican Skull T-Shirts White
36519 GoneR Scripture MessegeT-Shirts
47231 GoneR (ゴナー) GR20CTW001 GoneR × YOICHIRO T-Shirts White
50009 【バンドリ!×ゲキクロ 第3弾復刻】GoneR×美竹蘭 コラボ 限定 バッグ
54470 【バンドリ!×ゲキクロ第1弾復刻】GoneR×花園たえコラボ 限定 Tシャツ
55854 GoneR × 大内慶 Collaboration L/S T-Shirts Dark chocolate
55855 GoneR × 大内慶 Collaboration L/S T-Shirts Black
55885 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Baige
55886 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap 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
63313 GoneR (ゴナー) GR33CT004 Mexican Pattern T-Sirts Black
63314 GoneR (ゴナー) GR33CT004 Mexican Pattern T-Sirts Army Green
63316 GoneR (ゴナー) GR33SP001 Ethnic Hoodie T-Sirts Black
64367 ADAM at×GEKIROCK CLOTHING×GoneR Collaboration T-shirts -ROSE-
64368 ADAM at×GEKIROCK CLOTHING×GoneR Collaboration T-shirts -APPLE-
65302 松山 ダリア×GoneR コラボ 限定 キャップ
65860 GoneR(ゴナー) Flash Sleeve L/S T-Shirts White
65863 GoneR(ゴナー) Flash Sleeve L/S T-Shirts Black
68027 GoneR(ゴナー) GR36CT002 Cheart T-Shirts Black
68028 GoneR(ゴナー) GR36CT002 Cheart T-Shirts Dark Blue
68029 GoneR(ゴナー) GR36CT002 Cheart T-Shirts Dark Green
68030 GoneR(ゴナー) GR36CT002 Cheart T-Shirts White
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
23359 GoneR Flower Star Drawstring Food One Piece - H.Charcoal
23360 GoneR Flower Star Drawstring Food One Piece - V.H Navy
23361 GoneR Flower Star Drawstring Food One Piece - Black
23362 GoneR Message Maxi One Piece - H.Charcoal
23363 GoneR Message Maxi One Piece - Black
23367 GoneR GoneR × ROOKiEZ is PUNK'D Bucket Hat - White
23368 GoneR GoneR × ROOKiEZ is PUNK'D Bucket Hat - Black
33571 GoneR (ゴナー) Candle Mexican Skull Drawstring One Piece H.Charcoal
33572 GoneR (ゴナー) Candle Mexican Skull Drawstring One Piece V.H Navy
33574 GoneR (ゴナー) Candle Mexican Skull Drawstring One Piece Black
40402 GoneR GR17LS001 Antonym Long T-Shirts White
40427 GoneR GR17LS001 Antonym Long T-Shirts Black
42733 GoneR (ゴナー) GR18LS001 Red Pepper Long T-Shirts White
42734 GoneR (ゴナー) GR18LS001 Red Pepper Long T-Shirts Millitary Green