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-04-28 04:10:52')
AND FIND_IN_SET(22, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
37649 MUSIC SAVED MY LIFE (MSML) REVERSIBLE BOMBER JKT RED CHECK-PINK
69999 glamb (グラム) Holy Punks M-65 / ホーリーパンクスエムシックスティファイブ Brown
70000 glamb (グラム) Holy Punks M-65 / ホーリーパンクスエムシックスティファイブ Check
54986 Zephyren(ゼファレン)TRENCH COAT TWEED
54968 Zephyren(ゼファレン)WIDE TAILORD JACKET TWEED
59459 Zephyren(ゼファレン) WIDE TAILORD JACKET BLACK / CHECK
61271 Zephyren 2022 NEW YEAR BAG
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
61034 MISHKA M61000617 JACKET
61376 SLEEPING TABLET (スリーピングタブレット) PYLON [ 6 POCKETS CHECK CARGO PANTS ] BROWN
56799 ROLLING CRADLE CHECK HOOD JACKET BLUE
56468 Subciety (サブサエティ) CPO COACH JKT- YELLOW
63593 glamb (グラム) Heavy Damaged SH - Black
63594 glamb (グラム) Heavy Damaged SH - Blue
66989 glamb (グラム)GB0223/SH06 : Stand Collar Check SH / スタンドカラーチェックシャツ - Blue
66990 glamb (グラム)GB0223/SH06 : Stand Collar Check SH / スタンドカラーチェックシャツ - Yellow
66991 glamb (グラム)GB0223/SH06 : Stand Collar Check SH / スタンドカラーチェックシャツ - Red
50499 SILLENT FROM ME SHADOW -Deformed Pullover Shirts- CHECK
64105 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] PURPLE
30086 【予約商品】MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT WHITE
30087 MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT YELLOW
54132 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] NAVY
54133 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] GRAY
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
65888 over print(オーバープリント) Crochet knitting Shirts (cream)
65889 over print(オーバープリント) Crochet knitting Shirts (renga)
65890 over print(オーバープリント) Crochet knitting Shirts (black)
40913 ROLLING CRADLE RC-OW1496 CHECK GOWN Green-Red
51442 FILA FM9695 JACKET RED
51443 FILA FM9695 JACKET BLUE
49775 MISHKA MAW190267 L/S SHIRT
45939 NOT COMMON SENSE DOBBY CHECK PANTS D/GREEN CK
45940 NOT COMMON SENSE DOBBY CHECK PANTS PURPLE CK
46188 NOT COMMON SENSE "NCS" Remake SHIRTS GREEN CK×BEIGE CK×RED CK
38776 VIRGO Gradation check middle shirts RED
38777 VIRGO Gradation check middle shirts BLUE
25667 Subciety BACK ZIP LONG SHIRT-CHECK- BLACK
29143 Subciety (サブサエティ) PAISLEY COACH JACKET-GLORIOUS- BLACK
47314 MUSIC SAVED MY LIFE (MSML) M1K1T-SH01 BALLOON CHECK SHIRTS BLACK
47315 MUSIC SAVED MY LIFE (MSML) M1K1T-SH01 BALLOON CHECK SHIRTS BLUE
47316 MUSIC SAVED MY LIFE (MSML) M1K1T-SH01 BALLOON CHECK SHIRTS RED
50190 Subciety (サブサエティ) FRINGE CHECK SHIRT BLACK
50191 Subciety (サブサエティ) FRINGE CHECK SHIRT RED
50500 SLEEPING TABLET 17 [ FRAYED HEM LOOSE SHIRTS ] BLUE
50501 SLEEPING TABLET 17 [ FRAYED HEM LOOSE SHIRTS ] GREEN
50503 SLEEPING TABLET 17 [ FRAYED HEM LOOSE SHIRTS ] GRAY
50815 MUSIC SAVED MY LIFE M101-01K5-PL02 2LINE CHECK PANTS BLACK
50816 MUSIC SAVED MY LIFE M101-01K5-PL02 2LINE CHECK PANTS BEIGE
53115 LILWHITE(dot) LW-20SS-SH01CHARLIE FRINGE EMBROIDERY SHIRT RED
53116 LILWHITE(dot) LW-20SS-SH01CHARLIE FRINGE EMBROIDERY SHIRT GREEN
54211 SLEEPING TABLET M [ FRAYED HEM LOOSE SHIRTS ] YELLOW
54212 SLEEPING TABLET M [ FRAYED HEM LOOSE SHIRTS ] GREEN
54213 SLEEPING TABLET M [ FRAYED HEM LOOSE SHIRTS ] BLUE
54214 SLEEPING TABLET M [ FRAYED HEM LOOSE SHIRTS ] BLACK
56257 SILLENT FROM ME SILLENT FROM ME HARRY -Slim Slacks- GRAY CHECK
56258 SILLENT FROM ME SILLENT FROM ME HARRY -Slim Slacks- BLACK CHECK
58304 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] BLACK
58305 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] GRAY
58484 SILLENT FROM ME LAWYER -Wide Slacks- GRAY CHECK
60547 ROLLING CRADLE FLUFFY CREWNECK / BLACK
60548 ROLLING CRADLE FLUFFY CREWNECK / BLUE
60549 ROLLING CRADLE FLUFFY CREWNECK / BEIGE
40007 VIRGO GUITARIST DOLMAN SHIRTS RED
70263 VIRGO(ヴァルゴ) PARALLEL SHIRT RED
50210 PARADOX - PRDX CHECK SHIRTS BLACK
50214 PARADOX - PRDX CHECK SHIRTS BLUE
50822 PARADOX - PX16-SH04-C CHECK SHIRTS(BLUE)
50823 PARADOX - PX16-SH04-C CHECK SHIRTS(BLACK)
56033 PARADOX PRINTED CHECK SHIRTS (BLUE)
43090 NOT COMMON SENSE "PUNK ART" BLOCK CHECK SHIRTS RED CK
49275 CRIMIE CR01-01K3-SH76 PLAYBOY CHECK SHIRT BLUE
49276 CRIMIE CR01-01K3-SH76 PLAYBOY CHECK SHIRT RED
50638 ROLLING CRADLE SWITCHING SWEAT / Navy
52676 VIRGO G-PT-324 HANDLE NINJAS GREEN
52677 VIRGO G-PT-324 HANDLE NINJAS BLUE
52742 ROLLING CRADLE CHECK CROPPED PANTS BROWN
52743 ROLLING CRADLE CHECK CROPPED PANTS BLUE
53952 NOT COMMON SENSE REBUILDING L/S SHIRT
60546 ROLLING CRADLE HOOD CHECK SHIRT / BLACK
20665 Subciety CRAZY CHECK SHIRT L/S-Praha- BLACK
20666 Subciety CRAZY CHECK SHIRT L/S-Praha- GREEN
39712 NineMicrophones CHECK GATHERD SHIRT RED
39713 NineMicrophones CHECK GATHERD SHIRT NAVY
45547 Subciety (サブサエティ) CHECK SHIRT YELLOW
50529 Zephyren(ゼファレン) SLACKS BLACK / CHECK
51042 Zephyren(ゼファレン) SWITCHING SHIRT L/S MIX
51043 Zephyren(ゼファレン) SWITCHING SHIRT L/S BLUE
51435 FILA FM9696 JACKET RED
51436 FILA FM9696 JACKET BLUE
51834 Zephyren(ゼファレン) SWITCHING SHIRT L/S BLACK
55013 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - GREEN
56253 SILLENT FROM ME HARRIET -6pockets Wrap Skirt- GRAY CHECK
56255 SILLENT FROM ME HARRIET -6pockets Wrap Skirt- BLACK CHECK
57583 Zephyren(ゼファレン) EASY PANTS BROWN CHECK
57587 Zephyren(ゼファレン) EASY PANTS 8/S BROWN CHECK
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
62209 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK CHECK
15842 ROLLING CRADLE SWALLOW TAIL SHIRTL / Gray/Red
15843 ROLLING CRADLE SWALLOW TAIL SHIRTL / Black/Yellow
28760 VIRGO 90S PSYCO SHIRTS BLACK
28762 VIRGO 90S PSYCO SHIRTS YELLOW
32310 VIRGO Variable change shirts 切り替えチェックシャツ WHITE
39188 SQUARE LV CHECK SHIRTS BLUE CHECK
39189 SQUARE LV CHECK SHIRTS RED CHECK
40577 VIRGO OBLIQUE CHECK PANTS チェックサルエルパンツ GREEN
41356 ROLLING CRADLE WIDE CHECK PANTS / White-Red
45363 ROLLING CRADLE RC CHECKER WIDE PANTS Black
45928 SABBAT13 SBT-PT-007 CHECK UTILITY PANTS (ブラック)
45929 SABBAT13 SBT-PT-007 CHECK UTILITY PANTS (レッド)
46191 ROLLING CRADLE CHECK!CHECK!CHECK! SHIRT / Yellow-White
47715 ROLLING CRADLE CHECK PANTS / Gray
50538 SABBAT13 SHABBY CHECK SHIRTS (ブルー)
50539 SABBAT13 SHABBY CHECK SHIRTS (グリーン)
50730 SABBAT13 CHILLAXING CHECK PANTS (グリーン)
50731 SABBAT13 CHILLAXING CHECK PANTS (ブラウン)