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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =97
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-24 10:01:11')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
14469 Subciety 2015 福袋 25,000
52538 RIP DESIGN WORXX ripdw HAPPY BAG2020
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
45546 RIP DESIGN WORXX HAPPY BAG 2019 Bタイプ
45603 RIP DESIGN WORXX HAPPY BAG 2019 Aタイプ
61271 Zephyren 2022 NEW YEAR BAG
57102 Zephyren 2021 NEW YEAR BAG
66149 glamb (グラム) GB0123/CS05 : Crazy Pullover Jersey / クレイジープルオーバージャージ - Red
66150 glamb (グラム) GB0123/CS05 : Crazy Pullover Jersey / クレイジープルオーバージャージ - Black
44916 MISHKA (ミシカ) 2019 福袋 -NEW YEAR BAG-
52977 SILLENT FROM ME CRYPTIC -Extra Wide Poncho- BLACK/WHITE
52978 SILLENT FROM ME CRYPTIC -Extra Wide Poncho- BLACK/BLACK
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
38989 ANIMALIA 2018 ANIMALIA LUCKY BAG
45379 Subciety 2019 福袋 -NEW YEAR BAG-
50321 Subciety 2020 福袋 -NEW YEAR BAG-
51694 ANIMALIA 2020 ANIMALIA LUCKY BAG
56066 Subciety 2021 福袋 -NEW YEAR BAG-
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
66247 RUDIE'S (ルーディーズ) 2023 福袋 NEWYEAR PACK
63575 glamb (グラム) Damaged Layered CS - White
45643 MISHKA MSS190021F00 T-SHIRT
46333 NOT COMMON SENSE NCS REMAKE LAYERED L/S TEE BLACK
50688 NOT COMMON SENSE "80s Hardcore punk" Remake L/S Tee BLACK
39098 RIPDW 2018 HAPPY BAG with MA-1-BLKxBLK BAG-WHT
39107 RIPDW 2018 HAPPY BAG with MA-1-KHAxBLK BAG-WHT
63585 glamb (グラム) Crazy Textiles CS - Black
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
43157 VIRGO VG-CUT-375 MUDDY STREAM CUT 切り替えカットソー BLACK
46337 NOT COMMON SENSE "NCS"LAYERED L/S TEE BLACK
46338 NOT COMMON SENSE "NCS"LAYERED L/S TEE WHITE
45116 FOG ESSENTIALS Boxy Graphic Long Sleeve T-Shirt B/CREAM
50199 REBEL8 SLAYER SPIRIT JERSEY
50555 FOG ESSENTIALS Boxy Long Sleeve T-Shirt HETHER GRAY
51275 SILLENT FROM ME CLOUD -Henley Neck Drawstring WHITE
56770 FOG ESSENTIALS RIFLECTOR LOGO LS TEE BLACK
56912 RUDIE'S 2021 NEW YEAR PACK
65693 glamb (グラム) GB0422/CS07 : Unknown Paint CS / アンノウンペイントカットソー - White
65694 glamb (グラム) GB0422/CS07 : Unknown Paint CS / アンノウンペイントカットソー - BLACK
67102 glamb (グラム)GB0223/CS12 : Triangle Jersey / トライアングルジャージ - Black
67103 glamb (グラム)GB0223/CS12 : Triangle Jersey / トライアングルジャージ - Green
70594 over print (オーバープリント) Rebirth shirts etc A-4
50149 NOT COMMON SENSE "BREAK OUT" ZIP L/S TEE BLACK
50150 NOT COMMON SENSE "BREAK OUT" ZIP L/S TEE WHITE
43267 SILLENT FROM ME VEXED -Nylon Pullover- BLACK
59552 Zephyren(ゼファレン) JACQUARD CUT L/S BLACK / MIX
60416 MUSIC SAVED MY LIFE (MSML) OVERSIZED GRAPHIC LONG SLEEVE TEE BEIGE
32128 VIRGO BIGWAVE BLACK
32129 VIRGO BIGWAVE WHITE
39849 VIRGO DIAGONAL DAMAGED White
39850 VIRGO DIAGONAL DAMAGED Charcoal
39882 VIRGO DIAGONAL DAMAGED Black
43500 NOT COMMON SENSE FRANKEN 2 L/S TEE BLACK
43501 NOT COMMON SENSE FRANKEN 2 L/S TEE S/GREEN
45770 VIRGO VG-CUT-378 2/8 CHANGE LST 切り替えカットソー BLK/GRY
45771 VIRGO VG-CUT-378 2/8 CHANGE LST 切り替えカットソー NVY/WHT
45772 VIRGO VG-CUT-378 2/8 CHANGE LST 切り替えカットソー WHT/GRN
46186 NOT COMMON SENSE MAD DOG LAYERED L/S TEE BLACK×GREEN
46189 NOT COMMON SENSE "HARD CORE"L/S TEE WHITE
46190 NOT COMMON SENSE "HARD CORE"L/S TEE BLACK
46334 NOT COMMON SENSE "CAPTURE"L/S TEE WHITE
46335 NOT COMMON SENSE "CAPTURE"L/S TEE BLACK
50686 NOT COMMON SENSE "Blaze" L/S Tee BLACK/RED
50687 NOT COMMON SENSE "Blaze" L/S Tee BLACK/BLUE
51218 【絡繰魂×ドラゴンボールZ】超サイヤ人 悟空 ロンTee WHITE
51219 【絡繰魂×ドラゴンボールZ】超サイヤ人 悟空 ロンTee BLACK
52226 MISHKA (ミシカ) 2020福袋 -NEW YEAR BAG-
65985 PUNK DRUNKERS (パンクドランカーズ) 89ラガーシャツ - D.GREEN
66367 VIRGOwearworks (ヴァルゴウェアワークス) Airly wraps ブラック
66368 VIRGO(ヴァルゴ) Airly wraps ホワイト
66369 VIRGO(ヴァルゴ) Airly wraps ネイビー
41686 PARADOX URA L/S TEE (BLACK)
54137 SILLENT FROM ME R.I.P -Long Length Cutsew- BLACK
54138 SILLENT FROM ME R.I.P -Long Length Cutsew- WHITE
57366 MISHKA M21000003 L/S T-Shirt
60418 MUSIC SAVED MY LIFE (MSML) ROSE LONG SLEEVE TEE WHITE
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
61478 glamb (グラム) Oversized Fake Layered CS NAVY
61479 glamb (グラム) Oversized Fake Layered CS BLACK
64941 A FEW GOOD KIDS (アフューグッドキッズ) DATING CLUB LONG SLEEVE WHITE
64942 A FEW GOOD KIDS (アフューグッドキッズ) DATING CLUB LONG SLEEVE BLACK
67072 glamb (グラム) GB0223/CS08 : Tri Layered CS / トライレイヤードカットソー - Black
29580 VIRGO VARIANT CUTSHIRTS BLACK
29581 VIRGO VARIANT CUTSHIRTS NAVY
29582 VIRGO VARIANT CUTSHIRTS WHITE
36341 VIRGO CELLULAR ONE L/S {GIRAFFE} WHITE
36342 VIRGO CELLULAR ONE L/S {GIRAFFE} BLACK
37550 VIRGO 2face big knit ドルマンカットソー 【VIRGO】 [VG-CUT-350] BLK/CHA
37551 VIRGO 2face big knit ドルマンカットソー 【VIRGO】 [VG-CUT-350] NVY/GRY
38671 VIRGO Wave way L/S Black
38672 VIRGO Wave way L/S White
38673 VIRGO Wave way L/S Navy
38990 VIRGO Slanting caves L/Sワッフルカットソー BLACK
38991 VIRGO Slanting caves L/Sワッフルカットソー NATURAL
43077 NOT COMMON SENSE "SABOTAGE" LAYARD SLEEVE TEE BLACK
43078 NOT COMMON SENSE "SABOTAGE" LAYARD SLEEVE TEE WHITE
43079 NOT COMMON SENSE "SABOTAGE" LAYARD SLEEVE TEE YELLOW
43080 NOT COMMON SENSE "FREEDOM" LAYARD SLEEVE TEE WHITE
43081 NOT COMMON SENSE "DUST REAPER" LAYARD SLEEVE TEE BLACK
43082 NOT COMMON SENSE "DUST REAPER" LAYARD SLEEVE TEE PURPLE
43083 NOT COMMON SENSE "DUST REAPER" LAYARD SLEEVE TEE WHITE
43084 NOT COMMON SENSE Punk Layard Sleeve Tee BLACK
46202 VIRGO VG-CUT-379 LAPUTA ロングカットソー BLACK
46203 VIRGO VG-CUT-379 LAPUTA ロングカットソー NAVY
46224 ROLLING CRADLE RC RUGBY JERSEY / Berry
46225 ROLLING CRADLE RC RUGBY JERSEY / Smokeblue
46329 NOT COMMON SENSE FUXX THE POLICE LAYERED L/S TEE WHITE
46330 NOT COMMON SENSE FUXX THE POLICE LAYERED L/S TEE BLACK
46331 NOT COMMON SENSE GENESIS LAYERED L/S TEE WHITE
46332 NOT COMMON SENSE GENESIS LAYERED L/S TEE BLACK
51152 VIRGO VG-CUT-398 CRUST LINKS WHITE
51153 VIRGO VG-CUT-398 CRUST LINKS YELLOW
53948 NOT COMMON SENSE ”ANCIENT” L/S TEE BLACK
53954 NOT COMMON SENSE ”ANCIENT” L/S TEE WHITE
56194 NOT COMMON SENSE BRAIN LAYERED L/S TEE BLACK
56195 NOT COMMON SENSE BRAIN LAYERED L/S TEE WHITE