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 19:38:12')
AND FIND_IN_SET(10, p.color)
AND pc.classcategory_id1 IN( 25,1,8,117,30,133,132)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 240, 120
49094 FILA FHD003 BAG YELLOW
49647 MISHKA MAW193305 SOCKS
49650 MISHKA MAW193307 SOCKS
49868 PSYCHOLOGICAL METAMORPHOSIS PLMP WAISTBAG YELLOW
49927 MISHKA EX19PIN1 PIN
50145 SLEEPING TABLET REM [ BODY BAG ] NEON GREEN
50286 HEDWiNG Cross Cut Hoodie type C
50287 HEDWiNG Cross Cut Hoodie type D
50305 LILWHITE(dot) LW-19AW-A01 LONG BELT (BLK)
50306 LILWHITE(dot) LW-19AW-A01 LONG BELT (LIME)
50307 LILWHITE(dot) LW-19AW-A03 REFLECTOR LONG BELT (BLK)
50308 LILWHITE(dot) LW-19AW-A02 REFLECTOR LONG BELT (LIME)
50440 ROLLING CRADLE LOGO KNIT CAP / Neon-Yellow
50626 MUSIC SAVED MY LIFE M1A1-01K5-GD01 LINE SOX NEON YELLOW
51004 Subciety (サブサエティ) SOCKS-THE BASE- YELLOW
51173 brokker “METALLICA” フィギュア
51210 TOY MACHINE TMF19HW24 BLOOD SUCKING BEANIE GOLD
51485 SABBAT13 SCARE UTILE POUCH (イエロー)
51491 RUDIE'S EMBER KNITCAP YELLOW
51534 MISHKA MSS203103F12 BAG SAFTY GREEN
52560 Evae mob *EVAE+ Smiley Necklace Green
52675 ROLLING CRADLE STICKER SET
52712 RIPNDIP Catch Em All Lanyard (Multi)
53139 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt YEL×GRN type A
53140 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt YEL×GRN type B
53153 HEDWiNG HD1-021 Waffle Long Tanktop Lime
53158 HEDWiNG HD8-006 Jellyfish Cap Orange
53935 KEYTALK 首から下げてネックストラップ イエロー
54536 PUNK DRUNKERS あいつ総柄スポーツタオル
54660 MISHKA(ミシカ) MSS203304 SOCKS YELLOW
54661 MISHKA(ミシカ) MSS203301 SOCKS YELLOW