SELECT SQL_CALC_FOUND_ROWS 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 =397
)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-20 05:29:08')
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, 120
71162 GALFY(ガルフィー) 普通にGALFYニットCAP BLACK
69713 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY BEANIE BLACK
64308 RIPNDIP (リップンディップ) Lord Nermal Ribbed Beanie (Black)
69588 RIPNDIP (リップンディップ) LORD NERMAL WAFFLE KNIT BEANIE (CHARCOAL)
69711 TOY MACHINE (トイマシーン) ROBOT&SECT EMBROIDERY BEANIE BLACK
69453 PUNK DRUNKERS (パンクドランカーズ) ひとりぼっちニットCAP
70246 PUNK DRUNKERS(パンクドランカーズ) PDロゴニットCAP BLACK
69550 GALFY (ガルフィー) 犬耳ニット帽 RED/BLACK
69549 GALFY (ガルフィー) 犬耳ニット帽 BLACK
69547 GALFY (ガルフィー) 犬耳バラクラバ BLACK
68878 GALFY (ガルフィー) 直球系ビーニー BLACK
69487 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) ニット帽 BLACKxWHITE
69990 SABBAT13(サバトサーティーン) SPOOK KNIT CAP BLACK
69586 RIPNDIP (リップンディップ) LORD NERMAL POM BEANIE (BLACK & CHARCOAL)
69469 LOVE KILLER(ラブキラー) killer spiderweb beanie ホワイト×ブラック
69467 LOVE KILLER(ラブキラー) killer spiderweb beanie ブラック×ホワイト
69468 LOVE KILLER(ラブキラー) killer spiderweb beanie ブラック×レッド
69254 Subciety (サブサエティ) LOW WATCH BLACK
69233 パラッパラッパー ワンポイントロゴ刺繍ニットCAP ORANGE
69232 パラッパラッパー ワンポイントロゴ刺繍ニットCAP BLACK
68327 over print (オーバープリント) knit beanie (black)
68207 LOVE KILLER(ラブキラー) KILLER CAT BEANIE BLACK
61271 Zephyren 2022 NEW YEAR BAG
66484 MAGICAL MOSH MISFITS ネズミニット帽 BLACK
66223 over print(オーバープリント) punk knit beani black
64137 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ BEANIE ] BLACK
62930 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO KNIT CAP - BLACK
65443 RIPNDIP (リップンディップ) Lord Nermal Pom Beanie (Black/Sage/Pine)
65446 RIPNDIP (リップンディップ) Peeking Nermal Beanie 3M Reflective (Black)
65448 RIPNDIP (リップンディップ) LORD NERMAL BEANIE 3M REFLECTIVE Beanie (MULTI)
58436 Survive Said The Prophet SIDE TAG BEANIE BLACK
61633 PSYCHOLOGICAL METAMORPHOSIS LOGO KNIT CAP BULACK
61602 HYPER CORE ロゴボンボンニット帽
61592 Gluttonous Slaughter Knit Watch
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
52479 【バンドリ!×ゲキクロ 第4弾復刻】ZEPHYREN×氷川 日菜コラボ 限定 ビーニー
61289 LONELY論理 LOGO BEANIE BLACK
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60397 GoneR GR30CP001 Basic Logo Knit Cap Black/White
60398 GoneR GR30CP001 Basic Logo Knit Cap Black/Red
60808 TOY MACHINE (トイマシーン) OG MONSTER BEANIE - BLACK
60637 RIPNDIP Lord Nermal Beanie (Black / Rainbow Tie Dye)
60532 MAGICAL MOSH MISFITS MxMxM スライムニット帽 BLACK
60533 MAGICAL MOSH MISFITS MxMxM スライムニット帽 DOKU
60424 ANIMALIA AN21A-CP03 BEANIE-LOGO BLACK
59718 Zephyren(ゼファレン) LONG BEANIE -You Are Here BLACK
59949 PUNK DRUNKERS ブロック風ロゴニットCAP - BLACK
50006 【バンドリ!×ゲキクロ 第3弾復刻】ZERO EVOKE×上原ひまり コラボ 限定 ビーニー
58569 PSYCHOLOGICAL METAMORPHOSIS LOGO KNIT CAP BLACK
57829 SILLENT FROM ME EYE -Beanie-
56259 SILLENT FROM ME SILLENT FROM ME ODIN -Ear Muff Beanie-
58042 TOY MACHINE TOYMONSTER HELLO KITTY EMB BEANIE - BLACK
28720 BRING ME THE HORIZON THIS IS Beanie
56385 Subciety (サブサエティ) BEANIE-SERVER - BLACK
57187 acOlaSia SMILE MOON BEANIE BLACK
56814 AC/DC UNISEX BEANIE HAT: OVAL LOGO (CABLE-KNIT)
56530 SILLENT FROM ME VEIN -Cable Knit Beanie- BLACK
56294 NineMicrophones BEANIE-Comrade-
56263 TOY MACHINE FIST EMBROIDERY BEANIE - BLACK
54338 Subciety(サブサエティ) BEANIE BLACK
54875 PUNK DRUNKERS INDOORニットCAP - BLACK
55929 MISHKA MAW203224 BEANIE
7076 KILL STAR CLOTHING KILL BEANIE [B]
9054 REBEL8 ALPINE RUST BEANIE
9116 SANTA CRUZ CLASSIC DOT LONG SHOREMAN BEANIE BK/OR
9139 CREATURE FU LONG SHOREMAN BEANIE GRN/BLK
9447 DEADHEARTZ LOGO beanie
9745 REBEL8 ALPINE MAROON BEANIE
10498 THRASHER LOGO BEANIE 13TH-N62 BLK/WHT
10499 THRASHER LOGO BEANIE 13TH-N62 PINK
10501 THRASHER LOGO BEANIE 13TH-N62 GLD
10502 THRASHER LOGO BEANIE 13TH-N62 MLT
10602 MISHKA (ミシカ) JUNIOR ADDER BEANIE BLACK
11316 BLACK CRAFT Blackcraft Beanie
13306 MISHKA (ミシカ) LAMOUR KEEP WATCH POM BEANIE BLACK
13481 MISHKA (ミシカ) LAMOUR KEEP WATCH RUMBLE POM BEANIE
14259 DISTURBIA CLOTHING Alienation Beanie
14549 Subciety 7UNION × Subciety BEANIE -SALOON- BLACK
14660 SO SO HAPPY BEANIE BLACK
14792 RUDIE'S SPARK BORDER KNIT CAP BLACK
15032 DROP DEAD CLOTHING CBA Beanie
15073 KILL STAR CLOTHING PATCH POM POM BEANIE
15076 KILL STAR CLOTHING KILL BEANIE [B]
15079 REBEL8 YELLOW POM BEANIE
15482 ATTILA Crosses Logo Black
15766 KILL STAR CLOTHING HATERS BEANIE [B]
15875 BURNING THE REGISTER CHAOS BEANIE BLACK
16516 DROP DEAD CLOTHING Punjab Beanie
16517 DROP DEAD CLOTHING Baysik Beanie
16518 DROP DEAD CLOTHING Not Okay Beanie
18801 NineMicrophones BEANIE -Power of will- BLACK
19893 KILL STAR CLOTHING SPELL BEANIE [B]
20232 SILLENT FROM ME ICON -Beanie-
20421 DROP DEAD CLOTHING Buzzing Beanie
21213 Stay Sick Clothing Sick White - Beanie
21276 MISHKA (ミシカ) BRUTAL REALITY BEANIE Black
21341 THRASHER FLAME LOGO BEANIE TH-N59 BLK/GLD
21342 THRASHER FLAME LOGO BEANIE BLK/YEL
21444 THRASHER MAGLOGO BEANIE BLK/LIM
21446 THRASHER MAGLOGO BEANIE BLK/WHT
21447 THRASHER MAGLOGO BEANIE BLK/PNK
21518 SILLENT FROM ME CRYPTIC -Beanie- BLACK
21534 ROLLING CRADLE ROUGHLY KNIT CAP / Black
21648 RUDIE'S 2TONE KNITCAP BLACK
21662 DISTURBIA CLOTHING N.G.N.M. Beanie
21756 ICECREAM SMALL LOGO BEANIE BLACK
21971 セプテンバーミー ニット帽 黒
22166 FAMOUS STARS AND STRAPS SELF MADE TRI STAR BEANIE
22207 SILLENT FROM ME NORM -Beanie- BLACK/BLACK
22215 RUDIE'S BORDER KNITCAP BLUE/RED
22216 RUDIE'S BORDER KNITCAP NAVY/WHITE
22217 RUDIE'S BORDER KNITCAP BLACK/GRAY
22342 SQUARE CUFFED POM KNIT CAP BLACK
22446 KILL STAR CLOTHING (キルスター・クロージング) Cats Beanie
22447 KILL STAR CLOTHING(キルスター・クロージング) Forever Beanie
22448 KILL STAR CLOTHING (キルスター・クロージング) Happy Beanie
22449 KILL STAR CLOTHING (キルスター・クロージング) Party Beanie
22497 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Beanie
22498 DROP DEAD CLOTHING (ドロップデッド・クロージング) Connected Beanie
22561 KILL BRAND FUCK EVERYTHING SOFT BEANIE