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 (
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-05-01 21:48:04')
AND pc.classcategory_id1 IN( 14,61,35)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
45546 RIP DESIGN WORXX HAPPY BAG 2019 Bタイプ
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
69180 glamb (グラム) GB0323/CS10 : Cross Stitch Hoodie / クロスステッチフーディ Black
56931 SLEEPING TABLET WOOLY [ SUSPEND ANORAK ] ORANGE
56936 SLEEPING TABLET WOOLY [ SUSPEND ANORAK ] BLACK
50493 SILLENT FROM ME RESULT -Half Snap Pullover- BLACK
50494 SILLENT FROM ME RESULT -Half Snap Pullover- WHITE
70869 glamb (グラム) Deformed Light Hoodie / ディフォームライトフーディ
66235 glamb(グラム) Himiko Toga Hoodie White
66246 glamb(グラム) Himiko Toga Hoodie Black
45379 Subciety 2019 福袋 -NEW YEAR BAG-
54132 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] NAVY
54133 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] GRAY
54134 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] SAX
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61441 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie Black
66247 RUDIE'S (ルーディーズ) 2023 福袋 NEWYEAR PACK
60200 Anti Social Social Club ABG White Crop Top
21761 ICECREAM INDIANS HOODIE NAVY
21762 ICECREAM INDIANS HOODIE WHITE
27110 Zephyren (ゼファレン) CAMOUFLAGE QUILT PARKA BLACK
27111 Zephyren (ゼファレン) CAMOUFLAGE QUILT PARKA GREEN
42460 SABBAT13 SBT-PK-022 MEDUSA HOODIE (ブラック)
42461 SABBAT13 SBT-PK-022 MEDUSA HOODIE (ピンク)
42462 SABBAT13 SBT-PK-023 PATCH HOODIE(ブラック)
42463 SABBAT13 SBT-PK-023 PATCH HOODIE(イエロー)
27928 LILWHITE. (リルホワイト) -LILARCH-SIDE ZIP HOODIE GRAY
27930 LILWHITE. (リルホワイト) -LILARCH-SIDE ZIP HOODIE BLACK
61758 MISHKA (ミシカ) M21100462 HOODIE
20064 ICECREAM VARSITY PULLOVER BLACK
37681 MUSIC SAVED MY LIFE (MSML) GRUNGE HOODIE GAWN BLACK
43942 SILLENT FROM ME TEARING -Zip Veluor Parka- WHITE
54135 SILLENT FROM ME SHHH -Long Length Parka- BLACK
54136 SILLENT FROM ME SHHH -Long Length Parka- WHITE
66473 10-FEET×Zephyren(ゼファレン) BIG PARKA BLACK
66494 10-FEET×Zephyren(ゼファレン) BIG PARKA BlackxBlack
66495 10-FEET×Zephyren(ゼファレン) BIG PARKA GRAY
66496 10-FEET×Zephyren(ゼファレン) BIG PARKA OFF WHITE
43217 RIPNDIP Mother Fish Baby Hoodie (Black)
43219 RIPNDIP TATTOO NEARMAL HOODIE (Black)
44019 RIPNDIP GREAT WAVE OF NERM PULLOVER BABY BLUE
47323 RIPNDIP Color Block Multi Panel Hoodie (Multi)
13802 Subciety TIE DYE ZIP PARKA-EMOTION- NAVY
13803 Subciety TIE DYE ZIP PARKA-EMOTION- GRAY
16718 ICECREAM CONES & BONES ALL OVER PULLOVER
19408 ZEPHYREN (ゼファレン) TIE DYE PARKA -VISIONARY - NAVY
21394 FAMOUS STARS AND STRAPS MONSTER MASH Men's Zip
37317 SILLENT FROM ME SICK -Modified Pullover- BLACK
66723 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise PARKA OATMEAL
66725 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise PARKA BLACK
47322 RIPNDIP Taped Hoodie (Tan)
47324 RIPNDIP Rubber Logo Hoodie (Orange)
47325 RIPNDIP Multi Hoodie (White)
47649 RIPNDIP RIPNTAIL Hoodie (Royal Blue)
23295 ANIMALIA HOODIE-Logo#002 BLACK
23296 ANIMALIA HOODIE-Logo#002 RED
23297 ANIMALIA HOODIE-Logo#002 NAVY
13411 ICECREAM LUX CONE PULLOVER GRAY
13412 ICECREAM CONE BAR PULLOVER BLACK
13799 Subciety TIE DYE PARKA-GLORIOUS- GRAY
13801 Subciety TIE DYE PARKA-GLORIOUS- GREEN
15028 DROP DEAD CLOTHING Anti-Social Hoodie
15530 ICECREAM RUNNING DOG PINK GREEN
20189 REBEL8 EIGHTH OMEN GREY HEATHER
21406 FAMOUS STARS AND STRAPS LINKED UP Pullover Hoodie
25708 Subciety REFLECTOR PRINT PARKA-GLORIOUS- WHITE
25709 Subciety REFLECTOR PRINT PARKA-GLORIOUS- BLACK
29009 ICECREAM ICJP16K015 HOODIE BLACK
61237 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション Compac Drive PARKA KHAKI
61238 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション Compac Drive PARKA GRAY
52226 MISHKA (ミシカ) 2020福袋 -NEW YEAR BAG-
37185 ANIMALIA AN17A-SW07 WANNABE BLACK
15266 ICECREAM ICECREAM STOKED PULLOVER
16503 Subciety PARKA-Parantica sita- BURGUNDY
16508 Subciety PARKA-LARGE GLORIOUS- BLACK
16510 Subciety PARKA-LARGE GLORIOUS- CHARCOAL
16689 Subciety PARKA-PATTERNED ALL OVER- GRAY
18717 NineMicrophones PARKA -RUN 9MC- BLACK
20344 REBEL8 GUILLOCHE HOODIE
21384 PUNK DRUNKERS トゲトゲパーカ BLACK
21547 LILWHITE. STUDS Side zip Hoodie BLK
23864 MISHKA (ミシカ) KEEP WATCH BOX LOGO PULLOVER HOODIE BLACK
25711 Subciety PARKA-SALOON- BLACK
34523 MUSIC SAVED MY LIFE (MSML) SLEEVELESS HOODIE BROWN
34524 MUSIC SAVED MY LIFE (MSML) SLEEVELESS HOODIE NAVY
37376 Hi-STANDARD×MISHKA EXWDHS02H SPHINX PULLOVER BLK
37377 Hi-STANDARD×MISHKA EXWDHS02H SPHINX PULLOVER PUR
37378 Hi-STANDARD×MISHKA EXWDHS03H MONSTER PULLOVER WHT
37380 Hi-STANDARD×MISHKA EXWDHS03H MONSTER PULLOVER PUR
51962 Zephyren(ゼファレン) PARKA - Raw color - WHITE
51963 Zephyren(ゼファレン) PARKA - Raw color - BLACK
54252 Subciety LOOP TIE PARKA GRAY
70744 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident PARKA WHITE
70746 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident PARKA BLACK
70748 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident PARKA GRAY
22008 ROLLING CRADLE Troopers Hoodie WHT
22009 ROLLING CRADLE Troopers Hoodie BLK
29600 ROLLING CRADLE RC×KERMIT HOODIE / Black
29601 ROLLING CRADLE RC×KERMIT HOODIE / White
22906 ANIMALIA HOODIE-Four Coners GRAY
22907 ANIMALIA HOODIE-Four Coners BLACK
65084 glamb (グラム)GB0422/CS02 : Big Drape Hoodie / ビッグドレープフーディ - Black
16595 KILL STAR CLOTHING RITUAL HOODIE [B]
17500 DROP DEAD CLOTHING Cod-eyed Hoodie
20715 Subciety PARKA-CAMOUFLAGE SALOON- WHITE
20716 Subciety PARKA-CAMOUFLAGE SALOON- BLACK
21413 FAMOUS STARS AND STRAPS BAJA Men's Pullover Hoodie
22065 REBEL8 NIGHT WATCH HOODIE
22163 FAMOUS STARS AND STRAPS BASS PULLOVER HOODY
22355 Zephyren (ゼファレン) PARKA -Zephees- BLK
22470 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Knit Hoodie
22479 DROP DEAD CLOTHING (ドロップデッド・クロージング) Tracker Hoodie
22919 REBEL8 PROPERTY OF PULLOVER HOODIE
25689 Subciety PARKA-MELT GLORIOUS- WHITE-RED