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 =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-03-29 19:44:27')
AND FIND_IN_SET(3, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
37316 RUDIE'S HEAD GEAR SPARK MESH CAP
70805 AIKA ELECTRONICS(アイカエレクトロニクス) Fur cap Future【WHITE】
70286 Subciety(サブサエティ)MESH CAP-Hard Days- BLACK
69476 ROLLING CRADLE (ローリングクレイドル) LOGO CAP WHITE
65627 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) モコモコボアのバケットハット-WHITE
69591 RIPNDIP (リップンディップ) LUCKY NERM WOOL STRAPBACK
27394 THRASHER 16TH-C25 WASH CAP WHITE
63723 over print (オーバープリント) Aurora CAP
61271 Zephyren 2022 NEW YEAR BAG
64289 RIPNDIP (リップンディップ) Shroom Mania Strapback (Bone)
48485 GALFY (ガルフィー) ジェットCAP WHITE
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60635 RIPNDIP Not Today Strapback (Light Blue Tie Dye)
35493 RUDIE'S (ルーディーズ) SPARK SNAPBACK CAP WHT/BLK
60333 LONELY論理 COTTON DAMAGED CLASSIC LOGO CAP BIEGE
50012 【バンドリ!×ゲキクロ 第3弾復刻】RideMe×青葉モカ コラボ 限定 キャップ
60003 GALFY わんわん大学 CAP O.WHITE/RED
56215 Anti Social Social Club Headrush Cap
58137 MISHKA M21003251 Cap White
47449 ANIMALIA AN19A-CP08 '49 Cap : LOGO WHITExBLK刺繍
57222 TOY MACHINE CLAIRVOYANT BB CAP - WHITE
56165 MUSIC SAVED MY LIFE (MSML) BOX LOGO DAD CAP WHITE
38450 Zephyren (ゼファレン) LONG STRAP LO CAP -ENGRAVE- WHITE
52609 GoneR -La Neta- La Neta 6 Panel Cap WHITE/BLACK
11688 アマツカミ さよなら snapback WHITE
16183 Subciety SNAP BACK CAP-GLORIOUS- WHITE/BLACK
17532 MISHKA (ミシカ) ETERNAL KEEP WATCH NEW ERA 5950
20145 RUDIE'S HEAD GEAR SPARK SNAPBACK CAP WHITE/BLACK
20882 Subciety 7UNION×Subciety BUCKET HAT-SYMBOL- WHITE
21359 THRASHER MAG LOGO SNAPBACK 17TH-C50 WHT/BLK
21743 MISHKA (ミシカ) OLDE SCHOOL NEW ERA 1920 STRAPBACK WHT
21859 SILLENT FROM ME QUIET -Snapback- WHITE
23279 REBEL8 TAP THE ROCKIES GREY SNAPBACK
24047 ANIMALIA AN16U-CP02 LEOPARD Cap WHITE
24399 Hypocrite(ヒポクリット) The Hieloname Snapbackcap WHT
24851 SILLENT FROM ME "20" -Snapback- MINOR LEAGUE Collaboration WHITE
24925 ANIMALIA SHUNKAMANITO TANKA Cap BLKxWHTxRED
25384 BLACK SCALE VINTAGE B LOGO NEW ERA SNAPBACK WHT
25403 SQUARE (スクエア) 6PANEL CAP"BANANA" WHITE
25880 Subciety SNAP BACK CAP-Reborn- WHITE
26102 NineMicrophones SNAP BACK CAP-Strum your mind- WHT
26154 PARKWAY DRIVE Coffin Snapback
26163 deathsight logo sb cap WHT
26222 SILLENT FROM ME SPELL -Snapback- WHITE
26355 Zephyren (ゼファレン) B.B. CAP -Flow- WHITE
26477 DEADHEARTZ "Intarsect" Snapback CAP / WHITE
26567 MISHKA x FAMOUS STARS AND STRAPS SNAPBACK WHITE
26569 MISHKA (ミシカ) CREEP SNAPBACK
26573 MISHKA (ミシカ) KEEP WATCH CAP
26577 MISHKA (ミシカ) DAMAGED KEEP WATCH SNAPBACK White
26908 Zephyren (ゼファレン) TWILL CAP -NY- WHITE
27279 Zephyren (ゼファレン) B.B CAP -LATITUDE LONGITUDE- WHITE
27389 THRASHER 16TH-C26 WASH CAP WHITE
27565 BLACK SCALE QUICKHIT SNAPBACK WHT
27588 Subciety×ANDSUNS SNAP BACK CAP WHITE/BLACK
27772 ANIMALIA AN15SP-CP01 WHTxNVxRED BLK
27783 ANIMALIA AN15SP-CP01 WHT CEMENT BLK
27790 ANIMALIA AN15SP-CP01 WHITExBLACK BLK
27791 ANIMALIA AN15SP-CP01 WHITE BLK
27792 ANIMALIA AN15SP-CP01 WHITE WHT
27799 deathsight Low Cap WHITE
27899 LILWHITE. (リルホワイト) -ARCH- SNAPBACK CAP WHITE
27908 LILWHITE. (リルホワイト) -SYMPATHIZER- SNAPBACK CAP WHITE
27927 LILWHITE. (リルホワイト) -ARCH- LOW CAP WHITE
28038 SPITFIRE Bighead Unstructured 6-Panel Snapback Hat - White/Royal
28120 Xmas Eileen 『WORLD COUNTDOWN』メッシュキャップ WHT
28221 Hypocrite (ヒポクリット) Hielogo Washbaseballcap WHITE
28438 SILLENT FROM ME ENCRYPTION -Snapback- WHT
28442 SILLENT FROM ME WHISPER -Polo Cap- WHT
28506 PUNK DRUNKERS ドクターPUNKDメッシュCAP WHITE/NAVY
28623 DEADHEARTZ EYE SB CAP WHT
29063 ANIMALIA AN16A-CP07 Low cap #001 WHITExNAVY
29315 Subciety (サブサエティ) PAISLEY VISOR SNAP BACK CAP-Trust- WHITE
29586 ICECREAM ICJP16H021DAD HAT OFF WHT
29669 GoneR 6 Panel Cap White
29928 Subciety (サブサエティ) Subciety x MarkGonzales SNAP BACK CAP WHITE
29932 PUNK DRUNKERS ゾンビCAP BEIGE
30125 BAND-MAID ローキャップ(白)
30714 Zephyren(ゼファレン) TWILL CAP -ENGRAVE- WHITE
30724 Zephyren(ゼファレン) CHOSEN MATERIAL TWILL CAP -GRAVE- WHITECAMO
31968 DEADHEARTZ DHTZ 18 Snapback CAP WHITE
31980 DEADHEARTZ MMXVII Snapback CAP WHITE
32016 VIRGO Smiles CAP BEIGE
32037 RUDIE'S DRAWING 6PANELCAP WHITE
32052 THRASHER GONZ OLD TIMER HAT TAN/BLACK
32054 THRASHER MAGAZINE LOGO TWO-TONE HAT WHITE
32094 Subciety (サブサエティ) SNAP BACK CAP-THE BASE- WHITE
32096 NineMicrophones SNAP BACK CAP -Comrade- WHITE/BLACK
32120 Hypocrite (ヒポクリット) HIELOGO SNAPBACK OFFWHITE×BLACK
32267 MISHKA (ミシカ) MSS173215 WHITE CAP
32333 SILLENT FROM ME BILLOW -Polo Cap- WHT
32983 NineMicrophones SNAPBACKCAP-how high- WHITE-BLACK
33025 NineMicrophones 69MESH CAP WHITE-BLACK
33026 NineMicrophones 69MESH CAP WHITE-BURGUNDY
33028 NineMicrophones 69SNAP BACK CAP WHITE-BURGUNDY
33059 SPITFIRE SB PENTA CAPS WHITE
33060 SPITFIRE SB LIL BH CAPS WHITE
33252 Zephyren (ゼファレン) B.B CAP -BEYOND- WHITExBLACK
33422 アマツカミ 弔 Cap White
33580 アマツカミ 心中 Cap White
33619 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) Cityscape NE Snapback
34100 RIP DESIGN WORXX EVIL STAR スナップバックキャップ WHITE
34173 THRASHER MAG LOGO ボタニカル柄平ツバキャップ WHITE
34208 SILLENT FROM ME HUMANE -Snapback- WHITE
34219 MISHKA Strong Bodies Snapback WHT
34221 MISHKA Siesta Snapback WHT
34224 MISHKA BlackSheep Cap WHT
34411 deathsight BOX LOGO CAP PEACOCK
34466 REBEL8 BOGEY STRAPBACK WHITE
34471 ALIVE LOGO SNAPBACK All White
34475 ALIVE DAD'S HAT White/Black
34492 THRASHER 17TH-C30T MAG LOGO SNAPBACK CAP BLK×WHT
34543 MUSIC SAVED MY LIFE (MSML) CAP WHITE
34557 ALIVE HAT Drank/Faded White
34749 Subciety (サブサエティ) CORDUROY SNAP BACK CAP BLACK
34751 Subciety (サブサエティ) SNAP BACK CAP-Basjoe- BLACK
34754 Subciety (サブサエティ) SNAP BACK CAP -GLORIOUS- GRAY-RED
35081 REBEL8 Olde Strapback WHITE