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 =395
)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-28 01:02:17')
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
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
61271 Zephyren 2022 NEW YEAR BAG
57102 Zephyren 2021 NEW YEAR BAG
44916 MISHKA (ミシカ) 2019 福袋 -NEW YEAR BAG-
58047 XrossOver pullOver
69660 VIRGOwearworks (ヴァルゴウェアワークス) SALLYS ARM SWT BLACK
69661 VIRGOwearworks (ヴァルゴウェアワークス) SALLYS ARM SWT NAVY
50817 CHORD NUMBER EIGHT CH01-01K5-CL52 SIDE LACE UP SWEAT BLACK
51542 PARADOX-HIGH NECK SWEAT(POWER)
56284 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT OFF WHITE
56285 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT GRAY
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
65955 Subciety (サブサエティ) VELOUR HALF ZIP BLACK
63937 VIRGO(ヴァルゴ)PIGMENT WIDE SWT BLACK
63938 VIRGO(ヴァルゴ)PIGMENT WIDE SWT KHAKI
65956 VIRGO(ヴァルゴ) GLADIATORS [VG-SWT-147]-BLACK
65958 VIRGO(ヴァルゴ) GLADIATORS [VG-SWT-147]-KHAKI
44305 SILLENT FROM ME GHOST -Asymmetry Knit Sweater- WHITE
45379 Subciety 2019 福袋 -NEW YEAR BAG-
50321 Subciety 2020 福袋 -NEW YEAR BAG-
51543 PARADOX-HIGH NECK SWEAT(BLK-ALLBK)
56066 Subciety 2021 福袋 -NEW YEAR BAG-
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
51481 KONUS K-400492 Sweatshirt with Reflective Tape BLACK
51482 KONUS K-400492 Sweatshirt with Reflective Tape ORANGE
53955 KONUS Sweatshirt With Zipper chest pocket BLACK
53956 KONUS Sweatshirt With Zipper chest pocket WHITE
43394 VIRGO VG-SWT-112 RUINS SWT COAT スウェットコート BLACK
50629 MUSIC SAVED MY LIFE M101-01K5-CL50 BALLOON SWITCHING SWEAT MUSTARD&IVORY
50630 MUSIC SAVED MY LIFE M101-01K5-CL50 BALLOON SWITCHING SWEAT RED&GRAY
50631 MUSIC SAVED MY LIFE M101-01K5-CL50 BALLOON SWITCHING SWEAT BLACK&PINK
53093 SILLENT FROM ME SHEARS -Deformed Crew Sweat- WHITE
53094 SILLENT FROM ME SHEARS -Deformed Crew Sweat- BLACK/WHITE
53095 SILLENT FROM ME SHEARS -Deformed Crew Sweat- BLACK/BLACK
56283 MUSIC SAVED MY LIFE (MSML) EMBROIDERY ZIP SWEAT BLACK
60547 ROLLING CRADLE FLUFFY CREWNECK / BLACK
60548 ROLLING CRADLE FLUFFY CREWNECK / BLUE
60549 ROLLING CRADLE FLUFFY CREWNECK / BEIGE
44077 VIRGO VG-SWT-108 SPECIAL SIDE ZIP SWT BLACK
44078 VIRGO VG-SWT-108 SPECIAL SIDE ZIP SWT WHITE
45660 VIRGO VG-SWT-108 SPECIAL SIDE ZIP SWT GRAY
59181 VIRGO ETHNIC ARMS SWEATSHIRT KHAKI
59182 VIRGO ETHNIC ARMS SWEATSHIRT BLACK
66230 glamb(グラム) Ochaco Uraraka Sweat Black
25380 BLACK SCALE REBEL SLAM CREWNECK BLK
25381 BLACK SCALE REBEL SLAM CREWNECK GRY
56566 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON SWEAT BLACK
61286 LONELY論理 KAMIKAZE CREWNECK BLACK
61287 LONELY論理 KAMIKAZE CREWNECK BURGUNDY
61288 LONELY論理 HARDCORE HALF ZIP BLACK
61442 glamb (グラム)×攻殻機動隊 SAC_2045 sweat Blue
61443 glamb (グラム)×攻殻機動隊 SAC_2045 sweat Black
70211 LONELY論理#28 13oz HEAVYWEIGHT "AKA LABEL" CREW NECK BLACK
70212 LONELY論理#28 13oz HEAVYWEIGHT "AKA LABEL" CREW NECK HEATHER GRAY
70262 ジョジョの奇妙な冒険xglamb(グラム) Kars Sweat / カーズスウェット BLACK
45516 TOY MACHINE TMP19SW9 BLOODSUCKING SWEAT HALF ZIP BLACK
45517 TOY MACHINE TMP19SW9 BLOODSUCKING SWEAT HALF ZIP BLUE
47249 SLIGHTLY NUMB CHANK SWEATSHIRT
50638 ROLLING CRADLE SWITCHING SWEAT / Navy
50639 ROLLING CRADLE SWITCHING SWEAT / Yellow
52468 GALFY 野良犬セットアップ 灰
52470 GALFY 野良犬セットアップ 黒
61323 glamb (グラム)×チェンソーマン Makima Sweat White
61324 glamb (グラム)×チェンソーマン Makima Sweat Black
61327 glamb (グラム)×チェンソーマン Aki Sweat Black
61340 glamb (グラム)×チェンソーマン Aki Sweat White
65205 GALFY (ガルフィー) 紋紋 SET UP-BLACK
65206 GALFY (ガルフィー) 紋紋 SET UP-D.PINK
43067 ANIMALIA AN18A-SW01 Puffy Sweat BLACK
69693 吉業重工(よしわざじゅうこう) タートルネックスウェットシャツ BLACK
69694 吉業重工(よしわざじゅうこう) プルオーバーフードスウェットシャツ BLACK
37386 PARADOX - V NECK SWEAT (BLACK)
37678 MUSIC SAVED MY LIFE (MSML) SLEEVE EMBROIDERY SWEAT BLACK
51143 MISHKA MAW190477 SWEAT BLACK
58111 MISHKA M21000405 Crew
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
63002 SUPPLIER (サプライヤー) PLAYBOY QUARTER ZIP SWEAT BEIGE
63571 glamb (グラム) Retro Future Sweat - Black
65457 Subciety (サブサエティ) GLORIOUS SWEATER-GREEN
65459 Subciety (サブサエティ) GLORIOUS SWEATER-BLACK
57032 VIRGO Upright zip swt WHITE
57034 VIRGO Upright zip swt BLACK
61176 CIVARIZE【シヴァーライズ】ヘビーウェイト切り替えデザインプルオーバースウェット CHARCOAL
69739 ANIMALIA (アニマリア) 12oz HEAVY CREW NECK - Chenille BLACK
69740 ANIMALIA (アニマリア) 12oz HEAVY CREW NECK - Chenille GRAY
52910 LILWHITE(dot)LW-20SS-SW01 -CHARLIE- DAMAGED WIDE SWEAT BLACK
52911 LILWHITE(dot)LW-20SS-SW01 -CHARLIE- DAMAGED WIDE SWEAT WHITE
45827 MISHKA MSS190438 SWEAT
45934 RUDIE'S COLLEGE HALFZIPHOOD SWEAT BLACK
45935 RUDIE'S COLLEGE HALFZIPHOOD SWEAT GRAY
45936 RUDIE'S COLLEGE HALFZIPHOOD SWEAT BLUE
55913 MISHKA MAW200423 SWEAT BLACK
55914 MISHKA MAW200423 SWEAT WHITE
56074 SLEEPING TABLET CAPSULE [ OVERSIZED CREW SWEAT ] BLACK
56075 SLEEPING TABLET CAPSULE [ OVERSIZED CREW SWEAT ] OLIVE
56076 SLEEPING TABLET CAPSULE [ OVERSIZED CREW SWEAT ] RED
56077 SLEEPING TABLET CAPSULE [ OVERSIZED CREW SWEAT ] BLUE
56078 SLEEPING TABLET CAPSULE [ OVERSIZED CREW SWEAT ] BABY PINK
63579 glamb (グラム) Pullover Line Jersey - Black
63580 glamb (グラム) Pullover Line Jersey - Red
63581 glamb (グラム) Pullover Line Jersey - Blue
65664 MISHKA (ミシカ) M61100404 WHITE“MOP”SWEAT
65666 MISHKA (ミシカ) M61100412 CATCH RABBIT SWEAT
69726 NineMicrophones(ナインマイクロフォンズ) HALF ZIP SWEAT BLACK
69727 NineMicrophones(ナインマイクロフォンズ) HALF ZIP SWEAT GRAY
69987 SABBAT13(サバトサーティーン) COLLEGE WIDE SWEAT BLACK ASH
69988 SABBAT13(サバトサーティーン) COLLEGE WIDE SWEAT TURQUOISE
69989 SABBAT13(サバトサーティーン) COLLEGE WIDE SWEAT OLIVE
70595 over print (オーバープリント) Rebirth shirts etc A-5
34952 SABBAT13 BEAST BOA SWEAT (ブラック) BLACK
50438 ROLLING CRADLE WONDERLAND SWEAT / Gray
50439 ROLLING CRADLE WONDERLAND SWEAT / Black
55988 ROLLING CRADLE ICEE SWEAT / RED
55989 ROLLING CRADLE ICEE SWEAT / PURPLE
55990 ROLLING CRADLE ICEE SWEAT / NAVY
57352 SUPPLIER (サプライヤー) MARBLE CREW SWEAT LIGHT BLUE