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-19 23:45:12')
AND FIND_IN_SET(3, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 60
54351 NineMicrophones STADIUM JKT-Pray with the microphone- - BLACK/WHITE
61035 MISHKA M61000730 JACKET WHITE
56946 SILLENT FROM ME CRYPTIC -Flight Jacket-WHITE
61752 MISHKA (ミシカ) M21100651 JACKET
65079 glamb (グラム)GB0422/SH05 : Double Layered SH / ダブルレイヤードシャツ - Khaki×White
61271 Zephyren 2022 NEW YEAR BAG
66795 Subciety (サブサエティ) DUCK ANORAK OFF WHITE
59429 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - NAVY / WHITE
70862 【予約商品】glamb (グラム)Paisley Line Pants / ペイズリーラインパンツ - White
59322 SLEEPING TABLET POLAR [ BOA BLOUSON ] NATURAL/GRAY
63295 Anti Social Social Club Playboy x ASSC Bunny Logo White Hoodie
69301 Subciety (サブサエティ) PRINTED SWING TOP WHITE
70927 【予約商品】glamb (グラム) Astro Sound Shirt White × Black
61465 Subciety (サブサエティ) SWING TOP OFF WHITE
70133 GALFY (ガルフィー) 四代目卍 SET UP
70919 【予約商品】glamb (グラム) Civic Camo Cargo Pants White
68329 SLEEPING TABLET (スリーピングタブレット) CRYPTO[PATERNED OPAL SHIRTS] NAVY/WHITE
68330 SLEEPING TABLET (スリーピングタブレット) CRYPTO[PATERNED OPAL SHIRTS] BLACK/WHITE
56284 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT OFF WHITE
56881 MISHKA(ミシカ) MAW200770 JACKET WHITE
60017 【予約商品】GALFY 二代目卍SETUP WHITE
70858 【予約商品】glamb (グラム)Patchwork Scarf Shirt / パッチワークスカーフシャツ - White
70867 glamb (グラム) 4XL Lace Shirts / フォーエックスエルレースシャツ White
65214 GALFY (ガルフィー) 三代目卍 SET UP-WHITE
61935 glamb (グラム) Watercolor SH - Blue
66235 glamb(グラム) Himiko Toga Hoodie White
71386 VIRGOwearworks (ヴァルゴウェアワークス) Spark pants WHITE
44919 ROLLING CRADLE GEGEGE NO SUKAJAN / Black-White[B]
56117 SILLENT FROM ME CULTISM Long Length Shirts BK/WH
60561 Subciety 2022 福袋 -NEW YEAR BAG-
60733 MISHKA M61000619 JACKET
60864 Subciety (サブサエティ) FLEECE JKT IVORY
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
61330 【予約商品】glamb (グラム)×チェンソーマン Power Hoodie White
61336 glamb (グラム)×チェンソーマン Power & Kobeni Hoodie White
61440 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie White
61945 glamb (グラム) Paisley Pajamas SH - White
65711 LONELY論理 SLAYER V HOODIE-WHITE
65888 over print(オーバープリント) Crochet knitting Shirts (cream)
67904 RIPNDIP (リップンディップ) Family Tree Wide Leg Cotton Twill Pants (Black)
69798 over print (オーバープリント) NYLON COTTON JACKET (IVORY)
55801 FOG ESSENTIALS "LA"Limit Tee White
56969 RUDIE'S PHAT FLEECE JACKET NATURAL/NAVY
60200 Anti Social Social Club ABG White Crop Top
63518 glamb (グラム) Lips and Song Turtle Knit - White
70130 ROLLING CRADLE (ローリングクレイドル) FLEECE JKT WHITE
53956 KONUS Sweatshirt With Zipper chest pocket WHITE
56744 TOY MACHINE BOA FLEECE REVERSIBLE JACKET - WHITE/BLACK
64096 SLEEPING TABLET(スリーピング・タブレット) RECIPE [ BAND COLLAR SHIRTS ] WHITE
53093 SILLENT FROM ME SHEARS -Deformed Crew Sweat- WHITE
56287 MUSIC SAVED MY LIFE (MSML) TIE DYE SWEAT PARKA
61262 MISHKA M61000623 JACKET WHITE
61278 LONELY論理 CHRYSANTHEMUM HOODIE WHITE
61285 LONELY論理 KAMIKAZE HOODIE WHITE
61754 MISHKA (ミシカ) M21100602 JACKET
63082 MISHKA (ミシカ) M21100201 SHIRT
63527 glamb (グラム) Retro Future Sweat Pants - White
63821 Subciety(サブサエティ) MILITARY OVER SHIRT WHITE
66329 VIRGOwearworks (ヴァルゴウェアワークス) Ebony flowers Shirt ブラック×ホワイト