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 04:38:24')
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 240, 120
42735 GoneR (ゴナー) GR18LS001 Red Pepper Long T-Shirts Maroon
42736 GoneR (ゴナー) GR18LS001 Red Pepper Long T-Shirts Black
47069 GoneR (ゴナー) GR20LS003 Rose Logo L/S T-Shirts White
47070 GoneR (ゴナー) GR20LS003 Rose Logo L/S T-Shirts Lirsh Green
47071 GoneR (ゴナー) GR20LS001 Color Maria Logo L/S T-Shirts Royal
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
48530 GoneR GR21LD003 Circular Flare Skirt Black
52609 GoneR -La Neta- La Neta 6 Panel Cap WHITE/BLACK
52610 GoneR -La Neta- La Neta 6 Panel Cap BEIGE/BLACK
52611 GoneR -La Neta- La Neta 6 Panel Cap CAMO/BLACK
52612 GoneR -La Neta- La Neta 6 Panel Cap BLACK/PURPLE
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
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
71412 GoneR (ゴナー) Graffiti Logo T-Shirts Charcoal
71413 GoneR (ゴナー) Graffiti Logo T-Shirts Black
55874 GoneR GR26OT001 Mexican Design Drivers jacket Black
60399 GoneR -La Neta- GRL05OT001 Embroidery Coverall Jacket Safari Beige
60402 GoneR -La Neta- GRL05OT001 Embroidery Coverall Jacket Black
29630 GoneR Mexican Skull Pocket L/S T-Shirts WHITE
29631 GoneR Mexican Skull Pocket L/S T-Shirts BLACK
29632 GoneR Mexican Skull Pocket L/S T-Shirts GRAY
33562 GoneR (ゴナー) Candle Mexican Skull Long T-Shirts White
33563 GoneR (ゴナー) Candle Mexican Skull Long T-Shirts D.Heather
33564 GoneR (ゴナー) Candle Mexican Skull Long T-Shirts Black
33578 GoneR (ゴナー) Candle Mexican Skull Maxi Skirt V.H Navy
33579 GoneR (ゴナー) Candle Mexican Skull Maxi Skirt Black
36511 GoneR Rose『X』 Maxi Skirt Heathre Charcoal
36514 GoneR Rose『X』 Maxi Skirt Black/Pink
36516 GoneR Rose『X』 Maxi Skirt BLACK/WHITE
36637 GoneR New Logo Bucket Hat WHITE
36638 GoneR New Logo Bucket Hat RED
36639 GoneR New Logo Bucket Hat BLACK/WHITE
36640 GoneR New Logo Bucket Hat BLACK/RED
36641 GoneR New Logo Bucket Hat Light Denim
36642 GoneR New Logo Bucket Hat Denim
37397 GoneR Two Face Long T-Shirts White
37398 GoneR Two Face Long T-Shirts Black
37399 GoneR Two Face Long T-Shirts Orange
37400 GoneR Two Face Long T-Shirts Light Blue
37402 GoneR Rose Cross Long T-Shirts White
37403 GoneR Rose Cross Long T-Shirts Orange
37404 GoneR Rose Cross Long T-Shirts Black
37405 GoneR Rose Cross Long T-Shirts Yellow
37406 GoneR Rose Cross Long T-Shirts Light Blue
37407 GoneR GR15LS003 Border Long T-Shirts White Border
37408 GoneR GR15LS003 Border Long T-Shirts Red
37409 GoneR GR15LS003 Border Long T-Shirts 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
48527 GoneR GR21TK004 Dry Basketball Tank-Top White
48528 GoneR GR21TK004 Dry Basketball Tank-Top Purple
48529 GoneR GR21TK004 Dry Basketball Tank-Top Black
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
50332 GoneR GR22LS002 Rose Sleeve L/S T-Shirts Royal
50333 GoneR GR22LS002 Rose Sleeve L/S T-Shirts Red
50334 GoneR GR22LS002 Rose Sleeve L/S T-Shirts Lirsh Green
50335 GoneR GR22LS002 Rose Sleeve L/S T-Shirts Black/Red
52604 GoneR -La Neta- Agave Pocket T-Shirts MAROON
52605 GoneR -La Neta- Agave Pocket T-Shirts WHITE
52606 GoneR -La Neta- Agave Pocket T-Shirts BLACK
55794 【バンドリ!×ゲキクロ 第2弾復刻】GoneR×花園たえコラボ 限定 ニットキャップ
55861 GoneR GR26LS001 Rough Rose L/S T-Shirts White
55862 GoneR GR26LS001 Rough Rose L/S T-Shirts Forest
55866 GoneR GR26LS002 Messege Rose Sleeve L/S T-Shirts Forest
55868 GoneR GR26LS002 Messege Rose Sleeve L/S T-Shirts Black
55871 GoneR GR26LS003 Mexican Goods Skull L/S T-Shirts Dark chocolate
55872 GoneR GR26LS003 Mexican Goods Skull L/S T-ShirtsBlack
55881 GoneR -La Neta- GRL02CP001 Logo Cotton Twill Cap Stone
55883 GoneR -La Neta- GRL02CP001 Logo Cotton Twill Cap Olive
55884 GoneR -La Neta- GRL02CP001 Logo Cotton Twill Cap Black
57989 GoneR GR28CT002 Tie-dye Line T-Shirts Black
60374 GoneR GR30PK001 Chalice Parka Hether Grey
63321 GoneR (ゴナー) GR33CP001 Rose Logo Metro hat White
61061 水野ギイ×GoneR コラボ・トラックジャケット
40406 GoneR GR17LD002 Mexican Skull T One-Piece Grey × Black
40408 GoneR GR17LD002 Mexican Skull T One-Piece White × Navy
48477 GoneR GR21LD001 Bat Rose T One-Piece White
48478 GoneR GR21LD001 Bat Rose T One-Piece Black
48479 GoneR GR21LD002 Rose Earth Skull T One-Piece White
48480 GoneR GR21LD002 Rose Earth Skull T One-Piece Black
58719 GoneR -La Neta- GRL04CT001 Mexican Flag T-Shirts Light Purple
58724 GoneR -La Neta- GRL04CT002 LUZ Y SOL T-Shirts Light Purple
58726 GoneR -La Neta- GRL04CT002 LUZ Y SOL T-Shirts Black
63305 GoneR (ゴナー) GR33CT002 Panther Tiger T-Sirts White
63307 GoneR (ゴナー) GR33CT003 Swallow T-Sirts White/Black