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 =588
)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-18 16:34:23')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
52538 RIP DESIGN WORXX ripdw HAPPY BAG2020
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
51306 LILWHITE(dot) LW-19AW-J01 "TM" BOA ANORAK PARKA (ORG)
70104 BLXCK Tokyo(ブラックトーキョー) Extra Damaged Hoodie (Black)
70105 BLXCK Tokyo(ブラックトーキョー) Extra Damaged Hoodie (Pink)
55638 Anti Social Social Club TONE DEAF RED HOODIE
55639 Anti Social Social Club TONE DEF SAND HOODIE
45546 RIP DESIGN WORXX HAPPY BAG 2019 Bタイプ
45603 RIP DESIGN WORXX HAPPY BAG 2019 Aタイプ
70103 【予約商品】BLXCK Tokyo(ブラックトーキョー) Extra Damaged Crop Hoodie
45091 MUSIC SAVED MY LIFE (MSML) M1H5K-CS02 HEAVY FRENCHTERRY OVERSIZED PARKA BLACK
61271 Zephyren 2022 NEW YEAR BAG
66793 Subciety (サブサエティ) DUCK ANORAK CAMEL
66794 Subciety (サブサエティ) DUCK ANORAK BLACK
66795 Subciety (サブサエティ) DUCK ANORAK OFF WHITE
57102 Zephyren 2021 NEW YEAR BAG
57407 FOG ESSENTIALS Riflector Logo Hoodie PINK
70656 SLEEPING TABLET (スリーピングタブレット) AVA [ DEFORMED HIGH NECK HOODIE ] BLACK
70657 SLEEPING TABLET (スリーピングタブレット) AVA [ DEFORMED HIGH NECK HOODIE ] SKY GRAY
70658 SLEEPING TABLET (スリーピングタブレット) AVA [ DEFORMED HIGH NECK HOODIE ] BLUE
70659 SLEEPING TABLET (スリーピングタブレット) AVA [ DEFORMED HIGH NECK HOODIE ] ORANGE
58048 XrossOver BigParka
44916 MISHKA (ミシカ) 2019 福袋 -NEW YEAR BAG-
45119 FOG ESSENTIALS Pullover Hoodie BLACK
45120 FOG ESSENTIALS Pullover Hoodie B/CREAM
50552 FOG ESSENTIALS Pullover Hoodie LIGHT HEATHER
51161 SLEEPING TABLET PATIENT [ HALF BUTTON VELOUR PULLOVER ] BLACK
51162 SLEEPING TABLET PATIENT [ HALF BUTTON VELOUR PULLOVER ] NAVY
55628 Anti Social Social Club SAMSIES BLUE HOODIE
55629 Anti Social Social Club SAMSIES PINK HOODIE
55635 Anti Social Social Club MIND GAMES BLACK HOODIE
63295 Anti Social Social Club Playboy x ASSC Bunny Logo White Hoodie
69180 glamb (グラム) GB0323/CS10 : Cross Stitch Hoodie / クロスステッチフーディ Black
69181 glamb (グラム) GB0323/CS10 : Cross Stitch Hoodie / クロスステッチフーディ Gray
70093 glamb (グラム) Multi Layered Hoodie / マルチレイヤードフーディ CHARCOAL
70094 glamb (グラム) Multi Layered Hoodie / マルチレイヤードフーディ BLUE
51348 CHORD NUMBER EIGHT CH01-01K5-CL54 BOA HOODIE BLACK
56931 SLEEPING TABLET WOOLY [ SUSPEND ANORAK ] ORANGE
56936 SLEEPING TABLET WOOLY [ SUSPEND ANORAK ] BLACK
60201 Anti Social Social Club Guard Down Flower Hoodie
69175 glamb (グラム) GB0323/CS16 : Drape Neck Hoodie / ドレープネックフーディ Black
56202 Anti Social Social Club True Colors Purple Camo
56205 Anti Social Social Club Don’T Black Hoodie
56206 Anti Social Social Club Don’t Red Hoodie
45961 KONUS K-49440 Pullover Hoodie w/ Acid Wash Black
50493 SILLENT FROM ME RESULT -Half Snap Pullover- BLACK
50494 SILLENT FROM ME RESULT -Half Snap Pullover- WHITE
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
63376 Anti Social Social Club Passing Fad Pink Hoodie
63378 Anti Social Social Club Self Conclusion Black Hoodie
66301 Subciety 2023 福袋 -NEW YEAR BAG-
70869 glamb (グラム) Deformed Light Hoodie / ディフォームライトフーディ
70640 glamb (グラム) marquee club(R) Patch Hoodie / マーキークラブパッチフーディ
35117 LILWHITE(dot) (リルホワイトドット) -ICICLE- EXTRA OVERSIZED HOODIE
66235 glamb(グラム) Himiko Toga Hoodie White
66246 glamb(グラム) Himiko Toga Hoodie Black
70370 チェンソーマン×glamb(グラム) Chainsaw Man Hoodie / チェンソーマンフーディ BLACK
70374 チェンソーマン×glamb(グラム) Denji Hoodie / デンジフーディ BLACK
70375 チェンソーマン×glamb(グラム) Power Hoodie / パワーフーディ BLACK
70376 チェンソーマン×glamb(グラム) Power Hoodie / パワーフーディ GRAY
70377 チェンソーマン×glamb(グラム) Kobeni Hoodie / コベニフーディ BLACK
70378 チェンソーマン×glamb(グラム) Kobeni Hoodie / コベニフーディ GRAY
70379 チェンソーマン×glamb(グラム)Samurai Sword Hoodie / サムライソードフーディ BLACK
45379 Subciety 2019 福袋 -NEW YEAR BAG-
50321 Subciety 2020 福袋 -NEW YEAR BAG-
51694 ANIMALIA 2020 ANIMALIA LUCKY BAG
54132 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] NAVY
54133 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] GRAY
54134 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] SAX
55039 Zephyren(ゼファレン)FUR PARKA WHITE
55040 Zephyren(ゼファレン)FUR PARKA BLACK
56066 Subciety 2021 福袋 -NEW YEAR BAG-
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
61330 【予約商品】glamb (グラム)×チェンソーマン Power Hoodie White
61331 【予約商品】glamb (グラム)×チェンソーマン Power Hoodie Black
61336 glamb (グラム)×チェンソーマン Power & Kobeni Hoodie White
61337 【予約商品】glamb (グラム)×チェンソーマン Power & Kobeni Hoodie Hoodie Black
61440 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie White
61441 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie Black
62634 LONELY論理 NAMENJYANEYO SCHOOL GIRL HOODIE BLACK
63677 【セット販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! SET UP GREENタイダイ
63678 【セット販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! SET UP REDタイダイ
63679 【セット販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! SET UP BLACKタイダイ
65710 LONELY論理 SLAYER V HOODIE-BLACK
65711 LONELY論理 SLAYER V HOODIE-WHITE
65712 LONELY論理 GREAT SEXUAL TEACHER "MAHO" HOODIE-BLACK
66247 RUDIE'S (ルーディーズ) 2023 福袋 NEWYEAR PACK
70259 ジョジョの奇妙な冒険xglamb(グラム) Santana Hoodie / サンタナフーディ BLACK
66963 PLEASURES(プレジャーズ) REALITY HOODIE BLACK
69996 ANIMALIA (アニマリア) ATTERNED ALL OVER HOODIE : Vintage Flowers BLACK
69997 ANIMALIA (アニマリア) ATTERNED ALL OVER HOODIE : Vintage Flowers BEIGE
35113 LILWHITE(dot) (リルホワイトドット) -VAIN- EXTRA OVERSZED HOODIE BLACK/WHITE
35114 LILWHITE(dot) (リルホワイトドット) -VAIN- EXTRA OVERSZED HOODIE BLACK/RED
35115 LILWHITE(dot) (リルホワイトドット) -VAIN- EXTRA OVERSZED HOODIE SAND
35116 LILWHITE(dot) (リルホワイトドット) -VAIN- EXTRA OVERSZED HOODIE ORANGE
56565 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON PARKA PURPLE
59312 Anti Social Social Club A Fire Inside Black Hoodie - Flame
60161 Anti Social Social Club I SEE BLUE SPLASH BLACK HOODIE
60162 Anti Social Social Club I SEE PINK SPLASH BLACK HOODIE
60200 Anti Social Social Club ABG White Crop Top
63000 SUPPLIER (サプライヤー) PLAYBOY ALL OVER EMBROIDERY PULLOVER BLACK
63001 SUPPLIER (サプライヤー) PLAYBOY ALL OVER EMBROIDERY PULLOVER BROWN
65719 GALFY (ガルフィー) クレイジーわんわん大学 SET UP SAX×L.PINK
65720 GALFY (ガルフィー) クレイジーわんわん大学 SET UP GREEN×BLUE
14565 SQUARE POLKA DOTS HOODY BLACK
29496 ROLLING CRADLE (ロリクレ) ROLLING-BAR HOODIE / White
29497 ROLLING CRADLE (ロリクレ) ROLLING-BAR HOODIE / Gray
32123 SQUARE (スクエア) SCREAM SWEAT HOODY
44199 NOT COMMON SENSE NCS SPECIAL SEAM HOODIE MULTI
46187 NOT COMMON SENSE "NCS" Special Seam HOODIE MULTI 3
46210 NOT COMMON SENSE "NCS" Special Seam HOODIE MULTI 2
46211 NOT COMMON SENSE "NCS" Special Seam HOODIE MULTI 1
46212 NOT COMMON SENSE "NCS" Special Seam HOODIE MULTI 4
46213 NOT COMMON SENSE "NCS" Special Seam HOODIE MULTI 5
50684 NOT COMMON SENSE "Break Out" LAYERED HOODIE PURPLExGREEN CK
50685 NOT COMMON SENSE "Break Out" LAYERED HOODIE BLACKxRED CK