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 17:40:02')
AND FIND_IN_SET(3, p.color)
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
61271 Zephyren 2022 NEW YEAR BAG
66795 Subciety (サブサエティ) DUCK ANORAK OFF WHITE
45120 FOG ESSENTIALS Pullover Hoodie B/CREAM
63295 Anti Social Social Club Playboy x ASSC Bunny Logo White Hoodie
50494 SILLENT FROM ME RESULT -Half Snap Pullover- WHITE
66235 glamb(グラム) Himiko Toga Hoodie White
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
61330 【予約商品】glamb (グラム)×チェンソーマン Power Hoodie White
61336 glamb (グラム)×チェンソーマン Power & Kobeni Hoodie White
61440 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie White
65711 LONELY論理 SLAYER V HOODIE-WHITE
60200 Anti Social Social Club ABG White Crop Top
29496 ROLLING CRADLE (ロリクレ) ROLLING-BAR HOODIE / White
21762 ICECREAM INDIANS HOODIE WHITE
56287 MUSIC SAVED MY LIFE (MSML) TIE DYE SWEAT PARKA
61278 LONELY論理 CHRYSANTHEMUM HOODIE WHITE
61285 LONELY論理 KAMIKAZE HOODIE WHITE
69756 Subciety (サブサエティ) Pieta PARKA BLACK
70681 TOY MACHINE (トイマシーン) MATOKIE MONSTER ANORAK PARKA L.BEIGE
59996 GALFY わんわん大学SETUP O.WHITE
65193 GALFY (ガルフィー)二代目わんわん大学 SET UP-O.WHITE
58056 NOT COMMON SENSE NCS SNAKE HOODIE WHITE
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
29947 VIRGO COEXISTENCE PARKA NATURAL
61568 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT HOODIE CREAM
69029 【ONE PIECE×絡繰魂】 愛と自由 プルパーカー WHITE
25992 NineMicrophones (ナインマイクロフォンズ) LINE PARKA-Skate College- WHITE
43942 SILLENT FROM ME TEARING -Zip Veluor Parka- WHITE
45810 Zephyren(ゼファレン)RAINBOW BIG PARKA WHITE
47583 MUSIC SAVED MY LIFE (MSML) M1K1K-CS01 OVERSIZED GRUNGE PARKA WHITE
51144 MISHKA MAW190476 Pullover WHITE
58109 MISHKA M21000404 Pullover WHITE
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
65667 MISHKA (ミシカ) M61100415 BIGSILHOUETTE PARKA WHITE
66453 MISHKA (ミシカ) M61100405 Double Strings Pullover Hoodie WHITE
66495 10-FEET×Zephyren(ゼファレン) BIG PARKA GRAY
43056 ANIMALIA AN18A-SW05 SIDE ZIP HOODIE L/S GRAY
42388 LILWHITE(dot) (リルホワイトドット) LW-18AW-S02 -REFLECTED- HOODIE WHITE
45718 LILWHITE(dot) LW-19SS-S01 "PLATE LOGO" HOODIE WHITE
45722 LILWHITE(dot) LW-19SS-S02 "NIGHTHEAD" HOODIE WHITE
50384 Zephyren(ゼファレン) DOLMAN BIG PARKA WHITE
50387 Zephyren(ゼファレン) TAPE BIG PARKA WHITE
50670 Subciety (サブサエティ) BOA PARKA IVORY
51868 Zephyren(ゼファレン) SWITCHING PARKA BLACK / WHITE
52495 SALUTE REMADE HOODIE
52957 RIPNDIP Catch Em All Hoodie (Tan)
56119 SILLENT FROM ME EVIDENCE Plain Parka WHT
57332 Subciety×仮面ライダードライブ MACH PARKA WHITE
66723 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise PARKA OATMEAL
68061 プランクスターズ×GALFYコラボ・パーカー WHITE
51239 SAMURAI CORE SR-PK-07-B PUNK侍 pk white
53111 SAMURAI CORE 夜露死苦哀愁 HOODIE WHITE
59418 SUPPLIER (サプライヤー) Fire Logo Hoodie BEIGE
47325 RIPNDIP Multi Hoodie (White)
25708 Subciety REFLECTOR PRINT PARKA-GLORIOUS- WHITE
29200 Subciety (サブサエティ) PAISLEY PARKA-GLORIOUS- WHITE
35121 LILWHITE(dot) (リルホワイトドット) -INFERIOR- Q/S SIDE ZIP HOODIE WHITE
42386 LILWHITE(dot) (リルホワイトドット) LW-18AW-S01 -STATEMENT- HOODIE WHITE
45301 Subciety (サブサエティ) Daisy PARKA WHITE
50217 Subciety (サブサエティ) EMBROIDERY PARKA-kid- WHITE
50878 Subciety CUTOFF PARKA WHITE
51967 Zephyren(ゼファレン) BIG PARKA - VISIONARY / zebra eye - WHITE
70271 ステミレイツ×NOT COMMON SENSE×GEKRIOCK CLOTHING コラボ・パーカー WHITE
38138 SQUARE RISKY GAME HOODY WHT
53075 SAMURAI CORE 釈迦 HOODIE WHITE
54650 CIVARIZE【シヴァーライズ】 レースアップZIPプルオーバーパーカー WHITE
63010 GALFY (ガルフィー) わんわん大学SETUP 夏 WHITE
52226 MISHKA (ミシカ) 2020福袋 -NEW YEAR BAG-
10788 DROP DEAD CLOTHING AK'S PULLOVER HOODY
27584 Subciety X ANDSUNS PARKA WHITE
37378 Hi-STANDARD×MISHKA EXWDHS03H MONSTER PULLOVER WHT
43811 REBEL8 LOVING MEMORY PULLOVER HOODIE WHITE
45147 Subciety (サブサエティ) Rewind PARKA WHITE
45630 MISHKA MSS190403F80 HOOD
49058 GALFY (ガルフィー) YABAI YABAI パーカー WHITE
50887 Subciety (サブサエティ) PARKA-Venus- WHITE
51962 Zephyren(ゼファレン) PARKA - Raw color - WHITE
55130 Zephyren(ゼファレン)PARKA - variat omnia tempus - WHITE
55916 MISHKA MAW200401 HOODIE WHITE
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
70744 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident PARKA WHITE
22008 ROLLING CRADLE Troopers Hoodie WHT
29598 ROLLING CRADLE RC×SESAMI STREET HOODIE / Oatmeal
29601 ROLLING CRADLE RC×KERMIT HOODIE / White
40571 SABBAT13 MSG BIG S/S HOODIE (WH)
43042 FILA FM9440 PULL OVER HOODIE WHITE
43517 ROLLING CRADLE RLGCDL HOODIE / Oatmeal
52377 GoneR Rose Sleeve Parka Black/White
56787 TRAVAS TOKYO Rhinestone Ribbon bear Hoodie White
60483 GALFY 燃えるわんわんパーカー O.WHITE
63845 TRAVAS TOKYO【トラバストーキョー】Color scheme Furry bear H/S hoodie White
65610 TRAVAS TOKYO【トラバストーキョー】 Switching bear half zip hoodie White
65611 TRAVAS TOKYO【トラバストーキョー】 Switching bear half zip hoodie Black
66542 GALFY (ガルフィー) もくもくグラフィティパーカー WHITE
69621 GALFY (ガルフィー) チャカパッチパーカー OFF WHITE
52705 RIPNDIP Nermio Hoodie (Tan)
52891 ANIMALIA AN20SP-SW02 150 Country Jail-P/O Hoodie WHITE
56540 ANIMALIA AN20A-SW07 “SKUNKEY” Big silhouette Hoodie
20715 Subciety PARKA-CAMOUFLAGE SALOON- WHITE
22479 DROP DEAD CLOTHING (ドロップデッド・クロージング) Tracker Hoodie
25689 Subciety PARKA-MELT GLORIOUS- WHITE-RED
25692 Subciety (サブサエティ) PARKA-Amploud- WHITE
25698 Subciety (サブサエティ) PARKA-MUSIC DESTROYー WHITE
27138 Zephyren (ゼファレン) PARKA -BEYOND- WHITE
29213 Subciety (サブサエティ) PARKA-Propaganda- WHITE
29395 NineMicrophones (ナインマイクロフォンズ) PARKA-Pass the mic- WHITE
29398 NineMicrophones (ナインマイクロフォンズ) PARKA -how high- WHITE
33459 REBEL8 IMMORTALS HOODIE WHITE
33609 MISHKA(ミシカ) No Mercy Pullover
34844 NineMicrophones PARKA-9MC CREW- BLACK-WHITE
37938 Subciety (サブサエティ) PARKA-SWEET- IVORY
38646 REBEL8 Stigma Pullover
41819 MISHKA (ミシカ) MAW180401 HOOD White
41879 REBEL8 FORTITUDE PULLOVER HOODIE CREAM
44324 VIRGO VIRGOwearworks×montage SWEAT PARKA VG-CB-78 WHITE
45306 NineMicrophones PARKA-badge- WHITE