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 21:55:41')
AND pc.price03 IS NOT NULL
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 240
60771 MUSIC SAVED MY LIFE (MSML) OVERSIZED BOA RIDERS JACKET BLACK
56984 VIRGO Special Petaurista cargo pants NAVY
65968 PUNK DRUNKERS (パンクドランカーズ) ヤンキーJKT - BLACK
55401 VIRGO ROCKET LONG SHIRTS - BLACK
57292 SALUTExEVAE bomber jacket
61351 SLEEPING TABLET X [ DOCTOR COAT ] BLACK
60661 MISHKA M61000729 JACKET BLACK
57345 SUPPLIER (サプライヤー) WHITE TYVEK PUFFER
57293 SALUTExEVAE shears jacket
54988 Zephyren(ゼファレン)STUDIUM JACKET - As above,So below - BLACK / WHITE
59874 PUNK DRUNKERS [PDSxSONIC]ソニックスタジャン - BLACK
59875 PUNK DRUNKERS [PDSxSONIC]ソニックスタジャン - D.PURPLE
66848 RIPNDIP (リップンディップ) Neon Cat Puffer Jacket Black
59876 PUNK DRUNKERS [PDSxGreatMUTA]グレート・ムタ スカジャン / BLUE - BLUE/BLACK
66625 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM ビチャビチャスライム JKT BLUE
65957 VIRGO(ヴァルゴ) GLADIATORS [VG-SWT-147]-BLUE
54983 Zephyren(ゼファレン)FUR JACKET BLACK
59441 Zephyren(ゼファレン) DENIM JKT - Victoria - INDIGO/RED
65595 GALFY (ガルフィー)×東京リベンジャーズ 東京卍會 構成員 SET UP
59191 VIRGO STRUMMER CHESTER COAT BEIGE
59192 VIRGO STRUMMER CHESTER COAT AQUA
65718 GALFY (ガルフィー) クレイジーわんわん大学 SET UP BLACK×RED
62113 ROLLING CRADLE SKAJAN JERSEY / RED
61414 VIRGO BAGGY-D CARGO 22[CLASSIC LINE] CHARCOAL
56522 SILLENT FROM ME VEIN -Cable Knit Sweater- WHITE
58958 Subciety (サブサエティ) SOUVENIR JKT - BLACK
58342 SILLENT FROM ME OBSCURE -Mesh Knit Sweater- WHITE
60728 LONELY論理 バキ×LONELY論理 "FIGHTING POSE" PO HOODIE GREEN
60883 PUNK DRUNKERS Mt.FUJIナイロンJKT - BLACK
56767 FOG ESSENTIALS Riflector Logo Crew Sweat Shirts BLACK
56768 FOG ESSENTIALS Riflector Logo Crew Sweat Shirts WHITE
65084 glamb (グラム)GB0422/CS02 : Big Drape Hoodie / ビッグドレープフーディ - Black
61087 VIRGO MIXTURE LONG SHIRTS KHAKI
61125 VIRGO CREST PANTS(CLASSIC LINE) NAVY
54228 Subciety LEOPARD SWING TOP BEIGE
59446 Zephyren(ゼファレン) TRENCH COAT BLACK
63474 glamb (グラム) Snow Mountain JKT - Multi
63475 glamb (グラム) Snow Mountain JKT - Black
63885 ROLLING CRADLE (ローリングクレイドル) 2TONE KUNG-FU SHIRT / BLACK
61372 SLEEPING TABLET (スリーピングタブレット) PYLON [ 6 POCKETS CARGO PANTS ] BLACK
58483 SILLENT FROM ME LAWYER -Oversized Tailored Jacket- GRAY CHECK
59445 Zephyren(ゼファレン) MA-1 Type BLOUSON TIEDYE
60153 Anti Social Social Club BORED GAMES PURPLE FLANNEL
60668 MISHKA M61000730 JACKET BLACK
56204 Anti Social Social Club Headrush All Over White Hoodie
59335 SLEEPING TABLET GENE [ RAW DENIM TRUCKER JACKET ] BLACK
60545 ROLLING CRADLE HOOD CHECK SHIRT / YELLOW
62208 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK / PAISLEY
59839 Evae mob *EVAE+Tyga Collaboration Necklace
56286 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT ORANGE
56848 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT BLACK
63529 glamb (グラム) Glen Check Balloon Pants - Gray
66707 ROLLING CRADLE(ローリングクレイドル) 2023 NEW YEAR LOGO HOODIE BLACK
57922 Subciety (サブサエティ) HALF ZIP CUBA SHIRT- BLACK
58952 Subciety (サブサエティ) EXTREME JKT - GRAY
61892 glamb (グラム) Old School Pile Jersey - Black
61893 glamb (グラム) Old School Pile Jersey - Green
64102 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] BLACK
64103 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] GRAY
64104 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] GREEN
55379 VIRGO VINTAGE RATS LONG COAT - WHITE
56971 NOT COMMON SENSE CIRCLELOGO C/N RIPSTOP OZONE WASHINGJACKET BLACK
56109 N.B.O. CONTRAST EMBROIDERY T KHAKI
56116 SILLENT FROM ME CULTISM Long Length Shirts WHT
63600 glamb (グラム) 4XL Denim SH - Indigo
64281 RIPNDIP (リップンディップ) Nerm Doodle Work Jacket (Chocolate)
60665 MISHKA M61000712 JACKET BEIGE
61264 MISHKA M61000735 JACKET SAFETY GREEN
58031 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - TAN
63028 GALFY (ガルフィー) 色激渋SETUP WHITE/G.BLUE
63029 GALFY (ガルフィー) 色激渋SETUP WHITE/L.GREEN
63030 GALFY (ガルフィー) 色激渋SETUP GREIGE/GRAY
63033 GALFY (ガルフィー) 炎上大学SETUP 夏 NAVY
60289 MISHKA M61000518 JACKET
60551 MUSIC SAVED MY LIFE (MSML) NYLON SAROUEL PANTS BLACK
60567 HEDWiNG R.A.M Leopard Fur Jacket
65747 GALFY (ガルフィー) ピカピカ注射器 SET UP EMERALD
62115 ROLLING CRADLE SKAJAN JERSEY / GREEN
61095 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS KHAKI
60295 MISHKA M61000014 L/S T-SHIRT
56203 Anti Social Social Club Birdbath Black Hoodie
56207 Anti Social Social Club Sweeter Then You Think Black Hoodie
64095 SLEEPING TABLET(スリーピング・タブレット) RECIPE [ BAND COLLAR SHIRTS ] GRAY
55403 VIRGO ROCKET LONG SHIRTS - WHITE
55977 MISHKA(ミシカ) MAW200512 JACKET
58949 Subciety (サブサエティ) M-65 FIELD JKT - BLACK
62632 LONELY論理 MEID NAGISA ASSASIN HALF ZIP BLACK
63819 Subciety(サブサエティ) MILITARY OVER SHIRT BLACK
65935 TOY MACHINE (トイマシーン) WINGED SECT ROCKET PADDING JACKET-BLACK
65612 TRAVAS TOKYO【トラバストーキョー】 Myriad of bears zip hoodie Black
56985 VIRGO Special Petaurista cargo pants BLACK
62131 SUPPLIER (サプライヤー) FIRE PATTERN STITCH LOGO DENIM LIGHT BLUE
65532 VIRGO(ヴァルゴ) SPLASH VGW SHIRTS BLUE
65734 GALFY (ガルフィー) 久々賛否両論 SET UP オーロラ BLACK
65735 GALFY (ガルフィー) 久々賛否両論 SET UP SAX
63574 glamb (グラム) Damaged Layered CS - Black
66004 PUNK DRUNKERS (パンクドランカーズ) タイダイきのこトレーナー - BLUE/PURPLE
59458 Zephyren(ゼファレン) WIDE TAILORD JACKET BLACK
59461 Zephyren(ゼファレン) WIDE TAILORD JACKET FLOWER
59488 Zephyren(ゼファレン) LONG COAT BLACK
59490 Zephyren(ゼファレン) LONG COAT D.GREEN / CHECK
67516 SLEEPING TABLET(スリーピング・タブレット) FORMULA [ NYLON COACH JACKET ]COYOTE
55632 Anti Social Social Club FRANTIC RED FLANNEL
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
64970 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / COLOR
64971 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / MONO
54170 SILLENT FROM ME VICTOR -Slim Slacks- GRAY CHECK
57354 SUPPLIER (サプライヤー) TINPLATE ZIP HOODIE PURPLE
58340 SILLENT FROM ME CHEAP -Band collar Shirts- WHITE
60290 MISHKA M61000209 L/S SHIRT
63826 Subciety(サブサエティ) MONSTER CARGO PANTS KHAKI
65663 MISHKA (ミシカ) M61100907 DAMAGE PANTS
54982 Zephyren(ゼファレン)FUR JACKET WHITE
56485 SALUTE Flower Anarchy Hoodie BLACK
58317 SLEEPING TABLET GRRL [ MULTI BORDER LONG SLEEVE ] BLACK
58329 ANIMALIA AN21S-SW03 INDIGO Z/U HOODIE -CHIMAYO INDIGO
59439 Zephyren(ゼファレン) DENIM JKT - Victoria - BLACK / RED
61171 GALFY (ガルフィー) チャラ男 JKT GREEN/PINK
62158 Subciety (サブサエティ) NYLON CARGO SHORTS BLACK
65207 GALFY (ガルフィー) 紋紋 SET UP-BEIGE
65742 GALFY (ガルフィー) ヘビ JKT BLACK
66646 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS MUSTARD
66647 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS BLACK
61724 TRAVAS TOKYO【トラヴァストーキョー】クマ総柄ライン入りジャージパーカー White
61300 MAGICAL MOSH MISFITS Mポケ モコモコ ボア JKT (裏地フリース) BEIGE
61480 glamb (グラム) Old School Jersey BLUE
61695 TOY MACHINE (トイマシーン) TM & EYE STADIUM JACKET NAVY
64157 ガリュウホンポ 寅袖切プルオーバーパーカー
56765 FOG ESSENTIALS Solid Hoodie L/H.GRY
56766 FOG ESSENTIALS Solid Hoodie TAN
59179 VIRGO MIDDLE TAILORED JKT KHAKI
59431 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - KHAKI
60718 VIRGO NYLON RACER MOD HOODIE
60454 ROLLING CRADLE CHECK NELSHIRT / YELLOW
60456 ROLLING CRADLE CHECK FLARE PANTS / YELLOW
60457 ROLLING CRADLE CHECK FLARE PANTS / BLUE
61070 VIRGO VGW SWEAT RIDERS BLACK
61130 VIRGO 90S VINTAGE FAT DENIME INDIGO(VINTAGE)
58112 MISHKA M21000414M BLACK
59537 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S BLACK / GREEN
60273 MISHKA M61000301 KNIT BLACK
60280 MISHKA M61000411 HOODIE
62341 Zephyren(ゼファレン) EASY PANTS 8/S CHECK
67746 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) どろたまスウェットパンツ GRAY
67747 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) どろたまスウェットパンツ BLACK
59953 CIVARIZE【シヴァーライズ】 デザインワイドパンツ BLACK/RED
61167 GALFY (ガルフィー) 新 走り屋 JKT BLACK/RED
61169 GALFY 新 走り屋 JKT BLACK/SAX
61571 SUPPLIER (サプライヤー) CROSS HOODIE LIGHT BLUE
61809 CIVARIZE【シヴァーライズ】 ZIPデザインスラックス A
65233 GALFY (ガルフィー) 犬暖嘘革 JKT-RED
65728 GALFY (ガルフィー) チェックのわんわん大学 JKT GREEN チェック
65988 PUNK DRUNKERS (パンクドランカーズ) 寅ブッシュパンツ - BLACK
59332 SLEEPING TABLET GENE [ RAW DENIM PANTS ] BLACK
59333 SLEEPING TABLET GENE [ RAW DENIM PANTS ] INDIGO
66653 kirou school (キロウスクール) ぱっつんがーる hoodie GREY
65201 GALFY (ガルフィー) 二代目わんわん大学セーター-GREEN
54970 Zephyren(ゼファレン)SKA JUMPER - Kaleidoscope - BLACK
55627 Anti Social Social Club THE GROVE BLACK HOODIE
55630 Anti Social Social Club BAT EMOJI WHITE HOODIE
55979 MISHKA(ミシカ) MAW200507 JACKET SAFTY GREEN
56769 FOG ESSENTIALS Solid Crew Sweat Shirts TAN
57453 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - WHITE CHECK
57457 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - PAISLEY
58061 ANIMALIA AN21S-JK01 Canyoning Parka KHAKI
58062 ANIMALIA AN21S-JK01 Canyoning Parka BLACK
59012 Subciety (サブサエティ) PIGMENT PARKA - BLACK
59433 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - BLACK
59456 Zephyren(ゼファレン) MA-1 BLACK
59520 Zephyren(ゼファレン) DOLMAN BIG PARKA BLACK / Reverie
59535 Zephyren(ゼファレン) BIG SHIRT L/S NAVY / PAISLEY
60262 RUDIE'S (ルーディーズ) PHAT OVERALL BLACK
60263 RUDIE'S (ルーディーズ) PHAT OVERALL BLUEGRAY
60555 MISHKA M61000418 HOODE BLACK
61275 LONELY論理 3EMBROIDERY HOODIE BLACK
62118 STAPLE×Hello Kitty Friends Hoodie BLACK
63294 Anti Social Social Club Playboy x ASSC Bunny Logo Black Hoodie
66857 RIPNDIP (リップンディップ) Waves Sherpa Hoodie Blue
54745 Dezzn Oversized Hooded T-Shirt Beige
61808 CIVARIZE【シヴァーライズ】 オーバーミリタリーシャツ B
65990 PUNK DRUNKERS (パンクドランカーズ) 鮫人テーパードデニム - INDIGO
54354 Nine Microphones SWING TOP-The bonds with family- KHAKI
56892 SALUTE DESERT SHIRT
56894 SALUTE RACING PRINTER SHIRT
57796 METALLICA Met Glitch Duck Jacket Jacket
55106 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - WHITE
55142 Zephyren(ゼファレン)PARKA - VISIONARY / Kaleidoscope - WHITE
55917 MISHKA MAW200210 SHIRTS
57341 MISHKA M21000402 SWEAT SHIRT BLACK
57442 Zephyren(ゼファレン) EMBLEM SHIRT S/S MIX
57443 Zephyren(ゼファレン) EMBLEM SHIRT S/S WHITE / You are hare
57463 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - BLACK / PAISLEY
57825 SILLENT FROM ME EYE -Pullover- WHITE
57921 Subciety (サブサエティ) WEEKENDER SHIRT - BEIGE
60052 SAMURAI CORE コラージュLS TEE WHITE
61236 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション Compac Drive PARKA BLACK
61439 glamb (グラム)×攻殻機動隊 SAC_2045 long sleeve CS Black
61493 glamb (グラム) Wide Slacks BLACK
61509 ANIMALIA AN22SP-JK01 ECWCS LEVEL-4 JACKET BLACK
61814 MISHKA (ミシカ) M21100404 HOODIE
61868 glamb (グラム) Military Remake CS - Black×Gray
62155 Subciety (サブサエティ) BAKER BAGGY PANTS BLACK
62635 LONELY論理 MEID NAGISA ASSASIN LONG SLEEVE PURPLE
64681 Zephyren(ゼファレン)BIG PARKA - INFINITY - BLACK
64902 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) スライム BACKPACK (黄金比サイズ) DOKU
66852 RIPNDIP (リップンディップ) Lord Nermal Flippy Knitty Sweater Black
57120 SABBAT13 ALTER CARDIGAN BLACK
57155 SABBAT13 GHOST CHECK SLACKS GRAY
58338 SILLENT FROM ME LAWYER -Oversized Tailored Jacket- BLACK CHECK
59442 Zephyren(ゼファレン) MA-1 Type BLOUSON BROWN / PAISLEY
60155 Anti Social Social Club BORED GAMES BROWN FLANNEL
61145 SABBAT13 SPOOK CHECK SHIRTS PURPLE
61467 Subciety (サブサエティ) SWING TOP KHAKI
63031 GALFY (ガルフィー) 炎上大学SETUP 夏 WHITE
65698 TRAVAS TOKYO【トラバストーキョー】Locked bear shirts-タイダイ
61513 ANIMALIA AN22SP-SH01 CHAMBRAY SHIRTS - A.C. Brand DENIMxBLACK
62654 PUNK DRUNKERS PDベースボールシャツ - BLUE
65685 SABBAT13(サバトサーティーン) STORY TELLING BIG SWEAT ASH
57017 VIRGO Big neck sell hoodie BLACK
59177 VIRGO ATS DAMAGE KNIT ZIP CARDIGAN GRAY
59178 VIRGO ATS DAMAGE KNIT ZIP CARDIGAN BLACK
59185 VIRGO SQUARE PKT SPECIAL CARGO BLACK
59186 VIRGO SQUARE PKT SPECIAL CARGO CHARCOAL
59187 VIRGO SQUARE PKT SPECIAL CARGO KHAKI
61306 MAGICAL MOSH MISFITS モコモコボアパンツ (裏地フリース) BEIGE
61307 MAGICAL MOSH MISFITS モコモコボアパンツ (裏地フリース) DOKU
54779 PUNK DRUNKERS チャイナコーチJKT - BLACK
55637 Anti Social Social Club KKOCH BLACK HOODIE
58981 Subciety (サブサエティ) COVER ALL SHIRT - WHITE
58985 Subciety (サブサエティ) COVER ALL SHIRT - BLACK
60782 RUDIE'S (ルーディーズ) PHAT MA-1 BLACK
63298 Anti Social Social Club ASSC x retaW Black Hoodie
63382 Anti Social Social Club Out Of Time Black Hoodie
58485 SILLENT FROM ME SPELL -Patterned Cutsew-BLACK/WHITE
58487 SILLENT FROM ME SPELL -Patterned Cutsew-WHITE
58994 NineMicrophones SWEAT-FULLERTON- BLACK
59221 LONELY論理 LONELISM SHIRTS black
60419 MUSIC SAVED MY LIFE (MSML) ROSE LONG SLEEVE TEE BLACK
60506 Subciety (サブサエティ) NYLON JKT BLACK / WHITE
60720 MISHKA M61000010 L/S T-Shirt