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-05-22 00:56:32')
AND pc.classcategory_id1 IN( 11)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 180
65915 Subciety (サブサエティ) CORDUROY DOWN JKT-BLACK
70237 VIRGOwearworks (ヴァルゴウェアワークス) DIAGONAL ZIP DOWN JKT CHARCOAL
70238 VIRGOwearworks (ヴァルゴウェアワークス) DIAGONAL ZIP DOWN JKT BLACK
71563 【数量限定予約商品】ゲキクロX5万フォロワー達成記念HAPPY BAG 50000
70154 MISHKA (ミシカ) MONOGRAM DOWN JACKET BEIGE
59193 VIRGO STRUMMER CHESTER COAT BLACK
69031 【ONE PIECE×絡繰魂】 赤髪のスカジャン リバーシブル
65902 over print(オーバープリント) Denim jacket *J.W.DAVIS
70153 MISHKA (ミシカ) MONOGRAM DOWN JACKET GRAY
70136 MISHKA (ミシカ) フェイクレザースタジアムジャケット
54238 Subciety (サブサエティ) DOWN JKT BLACK
69030 【ONE PIECE×絡繰魂】 ギア5 スカジャン リバーシブル
69058 LiSA x GoneR Stadium Jumper Green/Ivory
69059 LiSA x GoneR Stadium Jumper Gold/Navy
69060 LiSA x GoneR Stadium Jumper Black/Ivory
61566 SUPPLIER (サプライヤー) DETACHABLE HOOD PUFFER BLACK
61832 A FEW GOOD KIDS AFGK BOWLING STADIUM JACKET PINK
63903 VIRGO(ヴァルゴ)LAYERED MID VA-1 BLACK
63904 VIRGO(ヴァルゴ)LAYERED MID VA-1 BURGANDY
60861 Subciety (サブサエティ) DOWN JKT BLACK
60862 Subciety (サブサエティ) DOWN JKT BLACK/PAISLEY
56972 NOT COMMON SENSE CIRCLELOGO C/N RIPSTOP OZONE WASHINGJACKET OLIVE
57346 SUPPLIER (サプライヤー) BROWN CORDUROY PUFFER
61567 SUPPLIER (サプライヤー) 1st ANV. LEATHER VARSITY JACKET
55638 Anti Social Social Club TONE DEAF RED HOODIE
55639 Anti Social Social Club TONE DEF SAND HOODIE
56796 ROLLING CRADLE MODS COAT BLACK
53912 ANIMALIA AN20SP-JK01 APACHE-Stretch Denim Anorak INDIGO
57336 MISHKA M21000502 JACKET
61753 MISHKA (ミシカ) M21100691 JACKET
69728 Subciety (サブサエティ) CORDUROY ZIP HOODY BLACK
69729 Subciety (サブサエティ) CORDUROY ZIP HOODY BLUE
69730 Subciety (サブサエティ) CORDUROY ZIP HOODY PURPLE
70151 MISHKA (ミシカ) CHECK SHIRT JKT BEIGE
70562 RIPNDIP (リップンディップ) FUCKIN FUCK PUFFER JACKET
70563 RIPNDIP (リップンディップ) FAMILY TREE PUFFER JACKET
54985 Zephyren(ゼファレン)TRENCH COAT BLACK
54986 Zephyren(ゼファレン)TRENCH COAT TWEED
64379 PUNK DRUNKERS [PDSxTOY MACHINE]玩具機械ドカジャン - KHAKI
64380 PUNK DRUNKERS [PDSxTOY MACHINE]玩具機械ドカジャン - NAVY
65423 RIPNDIP (リップンディップ) Ultralight Beam Puffer Jacket (Multi)
67897 RIPNDIP (リップンディップ) Stop Being A Pussy Varsity Jacket (Black)
68611 円谷プロ×PUNK DRUNKERS(パンクドランカーズ) ウルトラ怪獣JKT BLACK
70103 【予約商品】BLXCK Tokyo(ブラックトーキョー) Extra Damaged Crop Hoodie
61071 VIRGO COSMIC FLOWER 2FACE JKT L.GRY/AQUA
61072 VIRGO COSMIC FLOWER 2FACE JKT NAVY/KHAKI
61073 VIRGO COSMIC FLOWER 2FACE JKT BLACK/BLACK
61856 A FEW GOOD KIDS BADGE PUFFER JACKET BLACK
54955 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - BLACK
54956 Zephyren(ゼファレン)LONG COAT - ビレッジマンズストア × Zephyren - ZEBRA
59479 Zephyren(ゼファレン) STUDIUM JACKET MIX
59491 【予約商品】Zephyren(ゼファレン) LONG COAT RED / CHECK
59877 PUNK DRUNKERS [PDSxGreatMUTA]グレート・ムタ スカジャン / BLACK - BLACK/GREEN
70067 ANIMALIA (アニマリア) BOA COACH JACKET BLACK
70478 SABBAT13(サバトサーティーン) SPOOK PUFF JKT (BK)
70480 SABBAT13(サバトサーティーン) SPOOK PUFF JKT (GY)
70481 SABBAT13(サバトサーティーン) SPOOK PUFF JKT (OL)
68613 PUNK DRUNKERS(パンクドランカーズ)A DRUNKERS PUNKスタジャン - BLACK
47019 NOVE NV-18FW02 OVER ALL
59480 Zephyren(ゼファレン) FUR COAT BLACK
59481 Zephyren(ゼファレン) FUR COAT BROWN
61271 Zephyren 2022 NEW YEAR BAG
65777 Subciety (サブサエティ) BOA JKT BLACK
65781 Subciety (サブサエティ) BOA JKT OLIVE
66793 Subciety (サブサエティ) DUCK ANORAK CAMEL
66794 Subciety (サブサエティ) DUCK ANORAK BLACK
66795 Subciety (サブサエティ) DUCK ANORAK OFF WHITE
69492 Subciety (サブサエティ) B-3 JKT BLACK/IVORY
64383 PUNK DRUNKERS PDSハンティングJKT - KHAKI
53946 NOT COMMON SENSE ”BLAZE” BOMBER REVERSIBLE JACKET
55337 VIRGO COMPOSITION VA1 - BLACK
56611 PUNK DRUNKERS [PDSxGODZILLA]ガイガン&ヘドラリバスカジャン / NAVY - NAVY/BLACK
56612 PUNK DRUNKERS [PDSxGODZILLA]ガイガン&ヘドラリバスカジャン / KHAKI - BLACK/KHAKI
56752 RUDIE'S (ルーディーズ) PHAT MOUNTAIN JACKET BLACK
56753 RUDIE'S PHAT MOUNTAIN JACKET KHAKI
57102 Zephyren 2021 NEW YEAR BAG
59428 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - BLACK
59429 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - NAVY / WHITE
61634 STAPLE×Sesame Street Puffer Jacket
63384 Anti Social Social Club Dialtone Olive Tie Dye Flannel
63385 Anti Social Social Club Chromey Red Tie Dye Flannel
63386 Anti Social Social Club Dialtone Black Tie Dye Flannel
66782 LONELY論理 NYLON BOMBER JACKET OLIVE
69481 VIRGOwearworks (ヴァルゴウェアワークス) CREW STUDIUM BLOUSON BLACK
69482 VIRGOwearworks (ヴァルゴウェアワークス) CREW STUDIUM BLOUSON BROWN
55574 SABBAT13 WITCH FLIGHT JKT オリーブ
61069 VIRGO VGW SWEAT RIDERS BLUE
63928 VIRGO(ヴァルゴ)MILSPEC LOOSE HOODIE BEIGE-CHARCOAL
63929 VIRGO(ヴァルゴ)MILSPEC LOOSE HOODIE BLACK-BLACK
66392 VIRGOwearworks (ヴァルゴウェアワークス) Special Petaurista cargo pants ブラック
66441 VIRGOwearworks (ヴァルゴウェアワークス) Special Petaurista cargo pants オリーブドラブ
70528 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM DREAM JKT BLACK
54973 Zephyren(ゼファレン)SWITCHING MA-1 - Resolve - MIX I
54974 Zephyren(ゼファレン)SWITCHING MA-1 - Resolve - MIX II
66443 MISHKA (ミシカ) M61100650 Boa College Stadium Jacket GREEN
66444 MISHKA (ミシカ) M61100650 Boa College Stadium Jacket BLACK
66448 MISHKA (ミシカ) M61100646 SHIRTS JACKET
68222 MISHKA (ミシカ)CROWN JACQUARD DENIM VARSITY JACKET M21200551 BLUE
63925 VIRGO(ヴァルゴ)NATIVE KNIT SNAP SWT BEIGE
63926 VIRGO(ヴァルゴ)NATIVE KNIT SNAP SWT BLACK
54778 PUNK DRUNKERS 占いJKT - BLACK
54951 Zephyren(ゼファレン)MOUNTAIN PARKA - Ailiph Doepa × Zephyren - BLACK
54952 Zephyren(ゼファレン)MOUNTAIN PARKA - Ailiph Doepa × Zephyren - COLORFUL
54964 Zephyren(ゼファレン)REVERSIBLE JACKET BLACK
54966 Zephyren(ゼファレン)REVERSIBLE JACKET PAINT
54972 Zephyren(ゼファレン)SKA JUMPER - Kaleidoscope - MIX
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
55980 MISHKA(ミシカ) MAW200608W JACKET
59457 Zephyren(ゼファレン) MA-1 FLOWER
63295 Anti Social Social Club Playboy x ASSC Bunny Logo White Hoodie
68221 MISHKA (ミシカ) K.W GRAFF DAMAGED DENIM JACKET M21200504 BLUE
69292 MISHKA (ミシカ) Printed Jacquard Denim Jacket
69301 Subciety (サブサエティ) PRINTED SWING TOP WHITE
69302 Subciety (サブサエティ) PRINTED SWING TOP BLACK
70183 TOY MACHINE (トイマシーン) CORDUROY PUFFER JACKET BLACK
70826 NineMicrophones(ナインマイクロフォンズ)NYLON STADIUM JKT BLACK
70827 NineMicrophones(ナインマイクロフォンズ)NYLON STADIUM JKT BURGUNDY
70908 優里xZEPHYREN -Betelgeuse- SOUVENIR JACKET BEIGE
70909 優里xZEPHYREN -Betelgeuse- SOUVENIR JACKET BLACK
71633 【数量限定予約商品】ゲキクロX5万フォロワー達成記念HAPPY BAG 25000
68957 AILE VIVANTES(エイルヴィヴァンテス) R-LONG SHIRT BLACK
71232 AILE VIVANTES (エイルヴィヴァンテス) FLIGHT JACKET_ROSE
54771 PUNK DRUNKERS [PDSxPAC-MAN]名人コーデュロイJKT - BEIGE
54772 PUNK DRUNKERS [PDSxPAC-MAN]名人コーデュロイJKT - BLUE
54227 Subciety LEOPARD SWING TOP BLACK
54353 Nine Microphones SWING TOP-The bonds with family- - BLACK
54953 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - BLACK
54954 Zephyren(ゼファレン)OME-1 - オメでたい頭でなにより × Zephyren - KHAKI
59448 Zephyren(ゼファレン) TRENCH COAT FLOWER
65475 Subciety (サブサエティ) SUEDE SWING TOP-BLACK
65662 MISHKA (ミシカ) M61100506 総柄プリントJACKET
66492 10-FEET×Zephyren(ゼファレン) TRACK JACET BLACK
67898 RIPNDIP (リップンディップ) Ripnlit Denim Jacket (Black Denim Wash)
56613 PUNK DRUNKERS [PDSxTEKKEN]吉光JKT - BLACK
50239 MISHKA MAW190510 JACKET BLACK
50240 MISHKA MAW190545 JACKET
58122 MISHKA M21000559 Jacket
59444 Zephyren(ゼファレン) MA-1 Type BLOUSON FLOWER
60015 GALFY 犬革 JKT BLACK
60154 Anti Social Social Club BORED GAMES YELLOW FLANNEL
60201 Anti Social Social Club Guard Down Flower Hoodie
61465 Subciety (サブサエティ) SWING TOP OFF WHITE
61466 Subciety (サブサエティ) SWING TOP BLACK
65468 Subciety (サブサエティ) SHORT MODS COAT-OLIVE
65469 Subciety (サブサエティ) SHORT MODS COAT-BLACK
66537 GALFY (ガルフィー) わんわんヤニカススカジャン GREEN BLACK
66538 GALFY (ガルフィー) わんわんヤニカススカジャン YELLOW SAX
66539 GALFY (ガルフィー) わんわんヤニカススカジャン PINK GREEN
69810 PUNK DRUNKERS(パンクドランカーズ) HOT DOG BOY.JKT - BEIGE
69811 PUNK DRUNKERS(パンクドランカーズ) HOT DOG BOY.JKT - D.GREEN
70133 GALFY (ガルフィー) 四代目卍 SET UP
70181 TOY MACHINE (トイマシーン) SECT EYE STITCH QUILTED BOMBER JACKET BLACK
70182 TOY MACHINE (トイマシーン) SECT EYE STITCH QUILTED BOMBER JACKET GREEN
70305 GALFY (ガルフィー) 四代目卍 SET UP 江戸紫
56538 ROLLING CRADLE FLIGHT JACKET / DENIM
56539 ROLLING CRADLE FLIGHT JACKET / BLACK
56799 ROLLING CRADLE CHECK HOOD JACKET BLUE
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
56947 MAGICAL MOSH MISFITS MAGICAL ANIMAL MISFITS JKT (軽量保温中綿) HYOH
56948 MAGICAL MOSH MISFITS MAGICAL ANIMAL MISFITS JKT (軽量保温中綿) DOKU
69220 MICHIKO LONDON KOSHINO×VIRGOwearworks (ヴァルゴウェアワークス) RESONANCE JKT BLACK×WHITE
69224 VIRGOwearworks (ヴァルゴウェアワークス) SNAKE ZIP JKT BLACK
69225 VIRGOwearworks (ヴァルゴウェアワークス) SNAKE ZIP JKT KHAKI
69660 VIRGOwearworks (ヴァルゴウェアワークス) SALLYS ARM SWT BLACK
69661 VIRGOwearworks (ヴァルゴウェアワークス) SALLYS ARM SWT NAVY
56176 MISHKA(ミシカ) MAW200612 JACKET BLACK
56177 MISHKA(ミシカ) MAW200612 JACKET BEIGE
56467 Subciety (サブサエティ) CPO COACH JKT - BLACK
56468 Subciety (サブサエティ) CPO COACH JKT- YELLOW
56880 MISHKA(ミシカ) MAW200770 JACKET SAFTY GREEN
56881 MISHKA(ミシカ) MAW200770 JACKET WHITE
56882 MISHKA(ミシカ) MAW200770 JACKET BLACK
56886 MISHKA(ミシカ) MAW200678 JACKET
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE