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 =6
)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 02:59:14')
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
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
63593 glamb (グラム) Heavy Damaged SH - Black
63594 glamb (グラム) Heavy Damaged SH - Blue
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
65888 over print(オーバープリント) Crochet knitting Shirts (cream)
65889 over print(オーバープリント) Crochet knitting Shirts (renga)
65890 over print(オーバープリント) Crochet knitting Shirts (black)
49775 MISHKA MAW190267 L/S SHIRT
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
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
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
58304 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] BLACK
58305 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] GRAY
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
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
45547 Subciety (サブサエティ) CHECK SHIRT YELLOW
51042 Zephyren(ゼファレン) SWITCHING SHIRT L/S MIX
51043 Zephyren(ゼファレン) SWITCHING SHIRT L/S BLUE
51834 Zephyren(ゼファレン) SWITCHING SHIRT L/S BLACK
55013 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - GREEN
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
46191 ROLLING CRADLE CHECK!CHECK!CHECK! SHIRT / Yellow-White
50538 SABBAT13 SHABBY CHECK SHIRTS (ブルー)
50539 SABBAT13 SHABBY CHECK SHIRTS (グリーン)
26003 NineMicrophones OMBRE CHECK SHIRTL/S-Comrade- BLACK
26007 NineMicrophones CHECK SHIRT L/S-9MC Crew- RED
26008 NineMicrophones CHECK SHIRT L/S-9MC Crew- GREEN
42797 SLEEPING TABLET LADS WIDE NEL SHIRTS BLUE/YELLOW
51502 MISHKA MSS200251F00 L/S SHIRT
51841 Zephyren(ゼファレン) CHECK SHIRT L/S - Resolve - RED
52267 MISHKA MSS200252F00 L/S Shirt
55532 HEDWiNG Big Silhouette Plaid Shirt
69715 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BLACK
69716 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET RED
69717 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BROWN
70597 over print (オーバープリント) Rebirth shirts etc A-7
70598 over print (オーバープリント) Rebirth shirts etc A-8
22955 ROLLING CRADLE RAKURAI BIG SHIRT / White-Navy
22956 ROLLING CRADLE RAKURAI BIG SHIRT / Navy-Red
27355 SQUARE 4/3 CHECK SHIRTS RED CHECK
27356 SQUARE 4/3 CHECK SHIRTS BLUE CHECK
28897 ROLLING CRADLE GRAVY BIG SHIRTS / Black
30018 SQUARE (スクエア) HOOD CHECK SHIRTS BLUE×RED
30020 SQUARE (スクエア) HOOD CHECK SHIRTS GREEN×YELLOW
32283 SABBAT13 IGOR L/L HOOD NEL SHIRTS (WH)
39369 ROLLING CRADLE DENIM CHECK COMBI SHIRT RED
40554 SABBAT13 S-BONE BIG NEL SHIRTS RED
40555 SABBAT13 S-BONE BIG NEL SHIRTS YELLOW
40556 SABBAT13 S-BONE BIG NEL SHIRTS BLUE
45687 SABBAT13 SBT-SH-012 WITCH CRAFT CHECK SHIRTS (ブルー)
45688 SABBAT13 SBT-SH-012 WITCH CRAFT CHECK SHIRTS (イエロー)
50740 CIVARIZE【シヴァーライズ】Gravitate ペンキ散らし加工チェックワッシャーシャツ Gray,Blue,Red
51736 SABBAT13 WITLESS SHIRTS (ベージュ)
51737 SABBAT13 WITLESS SHIRTS (グリーン)
52740 ROLLING CRADLE CHECK SHIRT BROWN
52741 ROLLING CRADLE CHECK SHIRT BLUE
52985 VIRGO VG-SH-215 NOSTALGIC CHECK TOP RED
54784 PUNK DRUNKERS [PDSxTHUNDERBOX]ピクトグラムシャツ - BEIGE/BROWN
58310 ROLLING CRADLE BIG CHECK SHIRT / BEIGE
65859 ROLLING CRADLE(ローリングクレイドル) CHECK SHIRT / MULTI
20669 Subciety GINGHAM CHECK SHIRT L/S-GLORIOUS- WHITE
25646 Subciety DOBBY CHECK SHIRT L/S-Praha- BURGUNDY
25647 Subciety DOBBY CHECK SHIRT L/S-Praha- KHAKI
25648 Subciety OMBRE CHECK SHIRT L/S-THRON- BLACK
25649 Subciety OMBRE CHECK SHIRT L/S-THRON- RED
25650 Subciety OMBRE CHECK SHIRT L/S-THRON- MUSTARD
29412 NineMicrophones (ナインマイクロフォンズ) DOLMAN SLEEVE SHIRT 5/S-Comrade- BLACK
29413 NineMicrophones (ナインマイクロフォンズ) DOLMAN SLEEVE SHIRT 5/S-Comrade- BLUE
45684 Zephyren(ゼファレン)CHECK SHIRT L/S -Resolve- GREEN
46350 RUDIE'S PHAT CHECK SHIRTS NAVY
46351 RUDIE'S PHAT CHECK SHIRTS ORANGE
50259 RUDIE'S PHAT CHECK SHIRTS RED
50260 RUDIE'S PHAT CHECK SHIRTS YELLOW
50905 Subciety (サブサエティ) CHECK SHIRT -TAG- RED
50906 Subciety (サブサエティ) CHECK SHIRT -TAG- GREEN
56858 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” GRAY CHECK
56859 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” RED CHECK
15844 ROLLING CRADLE RAKURAI LONG NEL / Red
16663 ROLLING CRADLE POP-ART CRAZY SHIRT / BigCrazy
16664 ROLLING CRADLE POP-ART CRAZY SHIRT / SmallCrazy
28865 ROLLING CRADLE (ロリクレ) RAKURAI LONG NEL / Red
28866 ROLLING CRADLE (ロリクレ) RAKURAI LONG NEL / Navy
51755 PUNK DRUNKERS ビックポケ寝るシャツ NAVY