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 =17
)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 14:17:50')
AND FIND_IN_SET(2, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
67472 RUDIE'S(ルーディーズ) SHADOW LOGO SNAPBACK CAP DGY/BLK
71295 RIPNDIP (リップンディップ) TEAM SPIRIT STRAPBACK
71056 over print (オーバープリント) DENIM CAP chacoal
70515 TOY MACHINE (トイマシーン) ROBOT & SECT 2 TONE CAP GRAY
65630 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) モコモコボアのバケットハット-GRAY
69216 GoneR(ゴナー) GR37CP001 Flat Visor Mesh Cap Black/Grey
69133 gibous(ギボス) damage gibous life cap
68565 ANIMALIA (アニマリア) SIX PANELS MESH CAP-LOGO GRAY
67520 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ LOW CAP ]GRAY
61271 Zephyren 2022 NEW YEAR BAG
65271 GALFY (ガルフィー) 野良犬 CAP-GARY/BLACK
19657 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY - BLACK/GRAY
64289 RIPNDIP (リップンディップ) Shroom Mania Strapback (Bone)
64177 over print (オーバープリント) white stich CAP (smoky mint)
64077 AFFECTER (アフェクター) COLLEGE LOGO CAP GRAY
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
59198 VIRGO CROSS V WOOL CAP GRAY
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
59947 PUNK DRUNKERS CAPのCAP - BLACK
55882 GoneR -La Neta- GRL02CP001 Logo Cotton Twill Cap Heather Gray
54870 PUNK DRUNKERS 宇宙人スケボーCAP - H.GRAY
52820 Subciety LOW CAP GRAY
9336 MISHKA (ミシカ) NEW ERA: KEEP WATCH ORANGE
21826 DEADHEARTZ "D" SNAPBACK / GRAY
21956 THRASHER SNAP BACK 15TH-C52 H GRY/BLK
23282 REBEL8 GRID IRON CHARCOAL SNAPBACK
23303 MISHKA (ミシカ) HERITAGE KEEP WATCH NEW ERA
23377 DEADHEARTZ SINCE SNAPBACK CAP / GRAY
23674 SPITFIRE Dugout Heather Grey / Navy
24051 ANIMALIA AN16U-CP04 GRIZZLY Cap GRAYxBLACK
24163 REBEL8 NATIONAL STRIKER SNAPBACK
25374 BLACK SCALE DARK REBEL SNAPBACK GRY
25862 Subciety MESH CAP-DEATH WISH- GRAY-BLACK
25866 Subciety WOOL CAP-SYMBOL- BLACK
25867 Subciety WOOL CAP-SYMBOL- GRAY
25873 Subciety SNAP BACK CAP-New Jack- GRAY
27773 ANIMALIA AN15SP-CP01 GRAYxORANGE WHT
27774 ANIMALIA AN15SP-CP01 GRAYxBURGUNDY BLK
27784 ANIMALIA AN15SP-CP01 NAVYxGRAY WHT
27900 LILWHITE. (リルホワイト) -ARCH- SNAPBACK CAP GRAY
27909 LILWHITE. (リルホワイト) -SYMPATHIZER- SNAPBACK CAP GRAY
28035 SPITFIRE Bighead Fill Snapback Hat - Heather Grey/Black
28519 PUNK DRUNKERS P.CAP GRAY
28555 RUDIE'S HEAD GEAR SPARK SNAPBACK CAP BLACK/GRAY
28615 ROLLING STONES GRAY CLASSIC
28740 BLACK SCALE WE PROTECT REBELS GREY
28756 BLACK SCALE RESISTANCE CAP GREY
28888 REBEL8 STANDING STRONG SNAPBACK
29851 RUDIE'S COLLEGE SNAPBACKCAP CHARCOAL/BLACK
29852 RUDIE'S COLLEGE SNAPBACKCAP GRAY/BLACK
29853 RUDIE'S COLLEGE SNAPBACKCAP GRAY/NAVY
31979 DEADHEARTZ MMXVII Snapback CAP PEACOCK
32263 MISHKA (ミシカ) MSS173217 GRAY KEEP WATCH CAP
32382 REBEL8 WORLDWIDE DISTRO SNAPBACK
33489 REBEL8 UNDER THE WING SNAPBACK
33505 PUNK DRUNKERS (パンクドランカーズ) ドランクBB.CAP GRAY
34498 THRASHER 17TH-C30T MAG LOGO SNAPBACK CAP BLK×CHA
34753 Subciety (サブサエティ) SNAP BACK CAP -GLORIOUS- DARK GRAY
34757 Subciety (サブサエティ) SNAP BACK CAP -THE BASE- GRAY-BLACK