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-22 00:21:47')
AND pc.point_rate >1
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
36670 IRON MAIDEN HIGHWAY
63341 Subciety (サブサエティ) BLACK PANTHER TEE BLACK
59304 Subciety (サブサエティ) CROWD S/S BLACK
64313 Subciety (サブサエティ) Monogram TEE BLACK
51191 SLIPKNOT TURNTABLE SLIPMAT SET: THE GRAY CHAPTER
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
64306 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Black)
62313 Zephyren(ゼファレン) TANKTOP - BEYOND - BLACK
60857 TRAVAS TOKYO【トラバストーキョー】Frill spare collar Black
64094 SLEEPING TABLET(スリーピング・タブレット) RECIPE [ BAND COLLAR SHIRTS ] BLACK
64100 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL PLAIN SHIRTS ] BLACK
63104 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT BLACK
64319 NieR (ニーア) OFF-SHOULDER PULLOVER【MADNESS GIRL】
64333 NieR (ニーア) ZIP HOODIE【手錠】
64336 NieR (ニーア) ZIP HOODIE【FLOWER】
63230 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - BLACK
63233 TOY MACHINE (トイマシーン) AXEL SS TEE - BLACK
63228 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - BLACK
63225 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - BLACK
63006 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - BLACK
63238 DXMOUVE(ドゥモーヴェ) ストレンジトイ切替半袖プルオーバー カラフル
49833 SLIPKNOT Barcode-CD Wallet
61401 NineMicrophones PIGMENT PARKA BLACK
61405 NineMicrophones SWEAT-Wanderer- BLACK
58134 MISHKA M21000809 Shorts
63926 VIRGO(ヴァルゴ)NATIVE KNIT SNAP SWT BLACK
60453 GALFY (ガルフィー) 缶バッチ(3点セット)
65078 glamb (グラム)GB0422/SH05 : Double Layered SH / ダブルレイヤードシャツ - Black×Navy
58357 KILL STAR CLOTHING Lock Me Up Choker
58354 KILL STAR CLOTHING Crossbones Creepers
57074 SLIGHTLY NUMB×Kappa shoes BLACK
63517 glamb (グラム) Lips and Song Turtle Knit - Black
58363 KILL STAR CLOTHING Savage Mini Skirt [LEOPARD]
61988 glamb (グラム) Classic Jersey Pants - Black
64115 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ CREW SWEAT ] BLACK
64129 SLEEPING TABLET(スリーピング・タブレット) METEOR [ PUFF JACKET ] BLACK
64124 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ PULLOVER ] BLACK
64113 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ PULLOVER ] BLACK
64132 SLEEPING TABLET(スリーピング・タブレット) FARM [ FRINGE WOOL STOLE ] BLACK
64133 SLEEPING TABLET(スリーピング・タブレット) FARM [ FRINGE WOOL CHECK STOLE ] BLACK
63695 NieR (ニーア) 5BUCKLE STYLISH ZIP OUTER
62930 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO KNIT CAP - BLACK
65120 glamb (グラム)GB0422/T02 : Aestheticism T / エステティシズムT - Black
65155 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY HALFZIP SWEAT BLACK
65152 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY SWEAT BLACK
34489 ALIVE ALIVE x DRAGON BALL “4 Star Ball”
63508 glamb (グラム) Multi Button Cardigan - Black
64354 【ゲキクロ限定】DI:VISION (ディヴィジョン) FICTION TEE BLACK
62849 PSYCHOLOGICAL METAMORPHOSIS COLLEGE WIDE TEE - BLACK
65145 ANIMALIA BIG SILHOUETTE POLO SHIRTS -WORK SUCKS-
65146 ANIMALIA VELCRO WALLET - SKUNK SCOUT
65147 ANIMALIA AirPods Pro CASE - LOGO
65148 ANIMALIA AirPods CASE(第1、第2世代)
64246 SABBAT13(サバトサーティーン) SPOOK SAFARI SHIRTS BLACK
63593 glamb (グラム) Heavy Damaged SH - Black
65007 TRAVAS TOKYO【トラバストーキョー】 配色ニットポロシャツ/Black×Purple(ブラック×パープル)
65009 SUPPLIER (サプライヤー) IRON LOGO RAGLAN TEE/GREEN
64962 ROLLING CRADLE RC x KUDAN LOGO TEE / BLACK
64940 A FEW GOOD KIDS (アフューグッドキッズ) POPULAR CARTOON TEE BLACK
64938 A FEW GOOD KIDS (アフューグッドキッズ) STARRY SKY LOGO TEE BLACK