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 =211
)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-20 00:48:02')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
57102 Zephyren 2021 NEW YEAR BAG
44916 MISHKA (ミシカ) 2019 福袋 -NEW YEAR BAG-
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
45379 Subciety 2019 福袋 -NEW YEAR BAG-
50321 Subciety 2020 福袋 -NEW YEAR BAG-
56066 Subciety 2021 福袋 -NEW YEAR BAG-
38668 VIRGO VG-JKT-178 UMA stretch boa vest black
16393 NineMicrophones GAME SHIRT-Sixth man- - BLACK
63010 GALFY (ガルフィー) わんわん大学SETUP 夏 WHITE
63011 GALFY (ガルフィー) わんわん大学SETUP 夏 BLACK
63012 GALFY (ガルフィー) わんわん大学SETUP 夏 L.GREEN
52226 MISHKA (ミシカ) 2020福袋 -NEW YEAR BAG-
61355 SLEEPING TABLET RESTLESS [ NET SLEEVELESS ] BLACK
52417 Zephyren 2020 NEW YEAR BAG
61757 MISHKA (ミシカ) M21100180 VEST
68527 RIPNDIP (リップンディップ) Lord Savior Nerm Basketball Jersey NAVY
70847 【予約商品】glamb (グラム) : Punk Bouquet Sleeveless T-Shirt / パンクブーケスリーブレスTシャツ - Black
23476 NineMicrophones GAME SHIRT-9MC Crew- - BLACK/WHITE
23477 NineMicrophones GAME SHIRT-9MC Crew- - BLACK/BURGUNDY
39796 MISHKA (ミシカ) MSS180106 VEST
47584 MUSIC SAVED MY LIFE (MSML) M1K1K-CS04 LAYERED TANK TOP (パンサープリント) BLACK
48597 NineMicrophones-GAME SHIRT-9MC Crew--BLACK/WHITE
48598 NineMicrophones GAME SHIRT-9MC Crew- BLACK/RED
48599 NineMicrophones GAME SHIRT-9MC Crew- NAVY
56214 Anti Social Social Club Goodbye Summer Black Tank
68366 Subciety (サブサエティ) PAISLEY GAME SHIRT BLACK
68367 Subciety (サブサエティ) PAISLEY GAME SHIRT BURGUNDY
68368 Subciety (サブサエティ) PAISLEY GAME SHIRT PURPLE
56291 CIVARIZE【シヴァーライズ】ROSE BIG L/S TEE+TANK TOP (WHITE)
58350 CIVARIZE【シヴァーライズ】バイカラー切り替えロンT&タンクトップセット
67595 GALFY (ガルフィー) 「チーム犬」メッシュタンク BLACK
67597 GALFY (ガルフィー) 「チーム犬」メッシュタンク PURPLE
67598 GALFY (ガルフィー) 「チーム犬」メッシュタンク RED
56121 SILLENT FROM ME DOUGLAS Fuzzy Tank Top
25390 BLACK SCALE ASYMMETRICAL TANK TOP BLK
25391 BLACK SCALE ASYMMETRICAL TANK TOP WHT
12504 NineMicrophones GAME SHIRT -SHOUT SKULL-BGN
23092 Subciety LONG LENGTH NO SLEEVE-GLORIOUS- BLACK
47305 MUSIC SAVED MY LIFE (MSML) M1K1K-CS03 LAYERED TANK TOP (スカルプリント) BLACK
47306 MUSIC SAVED MY LIFE (MSML) M1K1K-CS03 LAYERED TANK TOP (スカルプリント) WHITE
64269 RIPNDIP (リップンディップ) Nikola Basketball Jersey (Black/Blue)
70012 glamb (グラム) marquee club(R) Tank Top / マーキークラブタンクトップ Black
5191 DROP DEAD CLOTHING SWANKY CATZ
26638 SQUARE SAINT&SINNER TANKTOP
27364 SQUARE FAMOUS ICONS TANK TOP WHITE
27365 SQUARE FAMOUS ICONS TANK TOP BLACK
68375 SLEEPING TABLET (スリーピングタブレット) WAVE [ SHEAR TANK TOP ] Black
68376 SLEEPING TABLET (スリーピングタブレット) WAVE [ SHEAR TANK TOP ] Green
68377 SLEEPING TABLET (スリーピングタブレット) WAVE [ SHEAR TANK TOP ] Wine
68378 SLEEPING TABLET (スリーピングタブレット) BLOCK [ SHEAR TANK TOP ] Gray
68379 SLEEPING TABLET (スリーピングタブレット) BLOCK [ SHEAR TANK TOP ] Yellow
12525 PUNK DRUNKERS 目ん玉メッシュタンク BLACK
23996 ANIMALIA AN16U-CS07 GOLD WEST-Slashed WHITE
23997 ANIMALIA AN16U-CS07 GOLD WEST-Slashed BLACK
48113 KILL STAR CLOTHING Cat Lady Lace-Up Tunic
12958 RUDIE'S INCANDESCENT BASKETBALL SHIRTS BLACK/WHITE
12959 RUDIE'S INCANDESCENT BASKETBALL SHIRTS BLACK/RED
13869 FAMOUS STARS AND STRAPS BUBBLE JERSEY V-Neck MINT
17675 Subciety TIE DYE TANK TOP-GLORIOUS- BURGUNDY
17676 Subciety TIE DYE TANK TOP-GLORIOUS- BLK
17677 Subciety TIE DYE TANK TOP-GLORIOUS- GREEN
17695 Subciety TIE DYE TANK TOP-GLORIOUS- NAVY
36811 SLIPKNOT Embroidered and Applique-Authentic Basketball Jersey
12641 ROLLING CRADLE RC-BA TANK Lightblue×Red
12642 ROLLING CRADLE RC-BA TANK Red×Blue
12683 ROLLING CRADLE RC-BA TANK White×Black
11893 Subciety PAISLEY TANK TOP BLACK
12474 Subciety TIE DYE TANK TOP -GLORIOUS-GREEN
12475 Subciety TIE DYE TANK TOP -GLORIOUS-GRAY
13368 IRON FIST CLOTHING SPINELESS PETER PAN COLLAR BLOU
16983 ZEPHYREN (ゼファレン) TANK TOP -BONEYARD- - BLACK
18693 DISTURBIA CLOTHING Come Undone Vest Dress
19020 RUDIE'S SPARK MESH TANKTOP BLACK
19021 RUDIE'S SPARK MESH TANKTOP NAVY
46450 Zephyren(ゼファレン)BIG TANKTOP BLACK / 如意宝珠
51616 MUSIC SAVED MY LIFE M101-02L1-CS01 BORDER LAYERED TANK TOP BLACK
51617 MUSIC SAVED MY LIFE M101-02L1-CS01 BORDER LAYERED TANK TOP WHITE
53276 Zephyren(ゼファレン)BIG TANKTOP BLACK
53277 Zephyren(ゼファレン)BIG TANKTOP WHITE / pagan
53278 Zephyren(ゼファレン)BIG TANKTOP BLACK / pagan
68756 TEROMELIA(テロメリア) ピクセルネックタンクトップ ホワイト
68757 TEROMELIA(テロメリア) ピクセルネックタンクトップ ベージュ
68758 TEROMELIA(テロメリア) ピクセルネックタンクトップ ブラック
13608 DROP DEAD CLOTHING DFD SLEEVELESS CREAM
13609 DROP DEAD CLOTHING DFD SLEEVELESS BLACK
13614 DROP DEAD CLOTHING NOTHING IS GOING TO BE OK
13615 DROP DEAD CLOTHING MOTHER TONGUE SLEEVELESS
13616 DROP DEAD CLOTHING DEEZEL VEST
13617 DROP DEAD CLOTHING FEATHERS SLEEVELESS T-SHIRT
13618 DROP DEAD CLOTHING HEARTS ALL-OVER SLEEVELESS
15036 DROP DEAD CLOTHING Blood Pact Sleeveless Cream
15058 DROP DEAD CLOTHING Marble Tank Top BLACK
15059 DROP DEAD CLOTHING Marble Tank Top WHITE
15066 DROP DEAD CLOTHING Back Stabber Tank Top Black
15143 DROP DEAD CLOTHING Victimless Crime Sleeveless T-s
16636 DROP DEAD CLOTHING Smile Tank Black
16649 DROP DEAD CLOTHING Sign Language Tank
17435 DEADHEARTZ BASKET MESH TankTop
19890 KILL STAR CLOTHING KALI MUSCLE TANK [B]
24023 ANIMALIA AN16U-TE10 REZ-Tank WHITE
24024 ANIMALIA AN16U-TE10 REZ-Tank BLACK
26469 DEADHEARTZ "Blood" MESH TANKTOP / CAMO
26470 DEADHEARTZ "Blood" MESH TANKTOP / BLACK
34318 SQUARE JUNK PATTERN MESH TANKTOP White
34319 SQUARE JUNK PATTERN MESH TANKTOP Red
34528 MUSIC SAVED MY LIFE (MSML) MESH LAYERED TANK TOP BLACK
34529 MUSIC SAVED MY LIFE (MSML) MESH LAYERED TANK TOP WHITE
34530 MUSIC SAVED MY LIFE (MSML) MESH LAYERED TANK TOP BROWN
34547 MUSIC SAVED MY LIFE (MSML) TANK TOP BORDER CUTSEW BLACK&WHITE
12194 MISHKA (ミシカ) BEAST OF THE EAST TANK TOP ARMY
12206 MISHKA (ミシカ) KEEP WATCH DYNASTY TANK TOP GOLD
12209 MISHKA (ミシカ) CRYPT KEEPER TANK TOP BLACK
12210 MISHKA (ミシカ) CRYPT KEEPER TANK TOP WHITE
17502 DROP DEAD CLOTHING Dayzee Tank
19889 KILL STAR CLOTHING SPIRITUS VEST [B]
20034 DROP DEAD CLOTHING (ドロップデッド・クロージング) Deadheads tank BLACK
55808 SUBLIME×SULLEN HEAD HIGH STANDARD TANKTOP
62315 Zephyren(ゼファレン) TANKTOP - In vino veritas - WHITE