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 11:56:29')
AND FIND_IN_SET(3, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
28120 Xmas Eileen 『WORLD COUNTDOWN』メッシュキャップ WHT
37548 RIP DESIGN WORXX オートグラフローキャップ 白
43282 RIP DESIGN WORXX イビルロゴローキャップ WHITE
28506 PUNK DRUNKERS ドクターPUNKDメッシュCAP WHITE/NAVY
34173 THRASHER MAG LOGO ボタニカル柄平ツバキャップ WHITE
34492 THRASHER 17TH-C30T MAG LOGO SNAPBACK CAP BLK×WHT
46168 THRASHER 19TH-C03 GONZ LOGO ピグメント ローキャップ WHITE
46170 THRASHER 19TH-C10 MAG LOGO ツバサンドプリント キャップ WHITE
46172 THRASHER 19TH-C16 MAG LOGOポリエステルサージ平ツバキャップ WHT/BLK
32333 SILLENT FROM ME BILLOW -Polo Cap- WHT
35500 SILLENT FROM ME BILLOW -Polo Cap-
34100 RIP DESIGN WORXX EVIL STAR スナップバックキャップ WHITE
32052 THRASHER GONZ OLD TIMER HAT TAN/BLACK
32054 THRASHER MAGAZINE LOGO TWO-TONE HAT WHITE
36623 RIP DESIGN WORXX イビルスタースナップバックキャップ WHT STAR
21359 THRASHER MAG LOGO SNAPBACK 17TH-C50 WHT/BLK
21859 SILLENT FROM ME QUIET -Snapback- WHITE
26222 SILLENT FROM ME SPELL -Snapback- WHITE
28438 SILLENT FROM ME ENCRYPTION -Snapback- WHT
28442 SILLENT FROM ME WHISPER -Polo Cap- WHT
33422 アマツカミ 弔 Cap White
33580 アマツカミ 心中 Cap White
34208 SILLENT FROM ME HUMANE -Snapback- WHITE
36458 SILLENT FROM ME CHAOSTIAN -Braid Cap- WHITE
36577 MISHKA (ミシカ) EX1747A CAP WHITE
37008 MISHKA EX1747B CAP WHITE
42979 SILLENT FROM ME SMILE -Polo Cap- WHITE
24851 SILLENT FROM ME "20" -Snapback- MINOR LEAGUE Collaboration WHITE
29932 PUNK DRUNKERS ゾンビCAP BEIGE
30125 BAND-MAID ローキャップ(白)
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
30714 Zephyren(ゼファレン) TWILL CAP -ENGRAVE- WHITE
34219 MISHKA Strong Bodies Snapback WHT
34221 MISHKA Siesta Snapback WHT
34224 MISHKA BlackSheep Cap WHT
37292 KRY clothing KRYCAP WHT
42722 SQUARE SPORTYJET CAP WHITE
40763 PUNK DRUNKERS 元ヤンメッシュCAP WHITE/BALCK
40764 PUNK DRUNKERS PDナイロンCAP WHITE
32267 MISHKA (ミシカ) MSS173215 WHITE CAP
41913 MISHKA MAW183209 CAP Black
45850 MISHKA MSS193201 CAP WHITE
26355 Zephyren (ゼファレン) B.B. CAP -Flow- WHITE
33252 Zephyren (ゼファレン) B.B CAP -BEYOND- WHITExBLACK
54513 FILA TOKYO LABEL LOW CAP WHITE
27279 Zephyren (ゼファレン) B.B CAP -LATITUDE LONGITUDE- WHITE
29669 GoneR 6 Panel Cap White
30724 Zephyren(ゼファレン) CHOSEN MATERIAL TWILL CAP -GRAVE- WHITECAMO
34471 ALIVE LOGO SNAPBACK All White
34475 ALIVE DAD'S HAT White/Black
36427 ALIVE DAD'S HAT White
36643 GoneR New Logo 6 Panel Cap WHITE
36644 GoneR New Logo 6 Panel Cap BLACK/WHITE
69476 ROLLING CRADLE (ローリングクレイドル) LOGO CAP WHITE
27799 deathsight Low Cap WHITE
39962 SABBAT13 WEIRD LOW CAP(WH)
39965 SABBAT13 666 LOW CAP(WH)
46174 THRASHER 19TH-C17 FLAME LOGO ポリエステルサージ平ツバキャップ WHITE
40414 GoneR GR17CP001 『GR』 Two-Tone Cap Natural × Black
40416 GoneR GR17CP001 『GR』 Two-Tone Cap Natural × Red
48485 GALFY (ガルフィー) ジェットCAP WHITE
21743 MISHKA (ミシカ) OLDE SCHOOL NEW ERA 1920 STRAPBACK WHT
32037 RUDIE'S DRAWING 6PANELCAP WHITE
34543 MUSIC SAVED MY LIFE (MSML) CAP WHITE
37316 RUDIE'S HEAD GEAR SPARK MESH CAP
38934 DEADHEARTZ HEX low cap White
42931 TOY MACHINE TMJ18HW2 MESH CAP WHITE
45086 MUSIC SAVED MY LIFE (MSML) M1H5T-CP01 DAD CAP WHITE
56165 MUSIC SAVED MY LIFE (MSML) BOX LOGO DAD CAP WHITE
27389 THRASHER 16TH-C26 WASH CAP WHITE
27394 THRASHER 16TH-C25 WASH CAP WHITE
29063 ANIMALIA AN16A-CP07 Low cap #001 WHITExNAVY
38917 GoneR GR16CP001 White Black
36432 ALIVE x YOSHIROTTEN HAT Sky
70805 AIKA ELECTRONICS(アイカエレクトロニクス) Fur cap Future【WHITE】
26154 PARKWAY DRIVE Coffin Snapback
26163 deathsight logo sb cap WHT
26477 DEADHEARTZ "Intarsect" Snapback CAP / WHITE
28221 Hypocrite (ヒポクリット) Hielogo Washbaseballcap WHITE
28623 DEADHEARTZ EYE SB CAP WHT
31968 DEADHEARTZ DHTZ 18 Snapback CAP WHITE
31980 DEADHEARTZ MMXVII Snapback CAP WHITE
32016 VIRGO Smiles CAP BEIGE
34411 deathsight BOX LOGO CAP PEACOCK
34557 ALIVE HAT Drank/Faded White
36047 SILLENT FROM ME PYRAMID -Snapback- WHITE
36574 RUDIE'S HEAD GEAR BASTARD MESHCAP BLACK
36926 VIRGO VGW CAP WHITE
40591 SABBAT13 UNDERLIE CAP (WH)
42756 SILLENT FROM ME STIGMA -Snapback- WHITE
50012 【バンドリ!×ゲキクロ 第3弾復刻】RideMe×青葉モカ コラボ 限定 キャップ
44046 SANTA CRUZ SCREAMING HAND HAT WHITE×BLACK
47634 SANTA CRUZ CLASSIC DOT HIGH PROFILE MESH TRUCKER HATS BLACK/WHITE
20145 RUDIE'S HEAD GEAR SPARK SNAPBACK CAP WHITE/BLACK
35493 RUDIE'S (ルーディーズ) SPARK SNAPBACK CAP WHT/BLK
25403 SQUARE (スクエア) 6PANEL CAP"BANANA" WHITE
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
35238 SQUARE GM PANEL CAP WHITE
39416 ROLLING CRADLE SUPER ROLLING CRADLE CAP WHITE
41728 SQUARE 6PANEL CAP"KANDOLL" WHITE
47724 ROLLING CRADLE FIRE CAP / Red-Royal
47725 ROLLING CRADLE FIRE CAP / Red-Black
52449 MISHKA x '47: BEAR MOP '47 CLEAN UP WHITE/EXBMWHT CAP
52451 MISHKA x '47: CYRILLIC BARABARA '47 CLEAN UP WHITE/EXBRWHT CAP
52609 GoneR -La Neta- La Neta 6 Panel Cap WHITE/BLACK
28038 SPITFIRE Bighead Unstructured 6-Panel Snapback Hat - White/Royal
39091 TOY MACHINE TMP18BC20 american monster bbc WHITE
57222 TOY MACHINE CLAIRVOYANT BB CAP - WHITE
60003 GALFY わんわん大学 CAP O.WHITE/RED
24399 Hypocrite(ヒポクリット) The Hieloname Snapbackcap WHT
27899 LILWHITE. (リルホワイト) -ARCH- SNAPBACK CAP WHITE
27908 LILWHITE. (リルホワイト) -SYMPATHIZER- SNAPBACK CAP WHITE