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-29 03:12:12')
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
52952 Survive Said The Prophet FIRE LOGO CAP
61164 AFFECTER (アフェクター) LOGO CAP BLACK
60614 SABBAT13 PARADISE LOST CAP BLACK
56813 AC/DC UNISEX BASEBALL CAP: RED LOGO
50362 ANIMALIA AN19M-CP03 CORDURA® BUCKET HAT-LOGO BLACK
37071 THRASHERxVANS TRUCKER
34161 THRASHER MAG LOGO ラバープリント平ツバキャップ BLACK×GRAY
37549 RIP DESIGN WORXX オートグラフローキャップ 黒
43280 RIP DESIGN WORXX イビルロゴローキャップ BLACK
45318 KAVANE Clothing "Half Rose"Cap(red)
45319 KAVANE Clothing "Half Rose"Cap(Purple)
45321 KAVANE Clothing "Meaning"Cap(red)
45322 KAVANE Clothing "Meaning"Cap(Purple)
21348 THRASHER SNAP BACK 14TH-C03 BLK/RED
27390 THRASHER 16TH-C26 WASH CAP BLACK
28503 PUNK DRUNKERS ドクターPUNKDメッシュCAP BLACK
34138 PUNK DRUNKERS さかさまメッシュCAP BLACK
34167 THRASHER MAG LOGO ボタニカル柄平ツバキャップ BLACK
34183 THRASHER FALME LOGO アクリルサージ平ツバキャップ BLACK×PURPLE
34184 THRASHER FALME LOGO アクリルサージ平ツバキャップ BLACK×YELLOW
34499 THRASHER 17TH-C30T MAG LOGO SNAPBACK CAP WHT×BLK
41625 RIP DESIGN WORXX "ジェイリー"フラットバイザーキャップ
46165 THRASHER 19TH-C01 BOX MAG ムラ染めツイル 6Pキャップ BLACK
46169 THRASHER 19TH-C10 MAG LOGO ツバサンドプリント キャップ BLACK
48483 GALFY (ガルフィー) ジェットCAP BLACK
32330 SILLENT FROM ME BILLOW -Polo Cap- BLK
35499 SILLENT FROM ME BILLOW -Polo Cap- BLK
44973 KILL STAR CLOTHING (キルスター・クロージング) Got Plans Snapback [B]
60738 ANIMALIA AN21A-CP04 FLIGHT CAP BLACK
27428 THRASHER MAGAZINE LOGO MESH BLK/WHT
61279 LONELY論理 LOGO PU LEATHER CAP BLACK
22697 RIP DESIGN WORXX コーデュロイBOXロゴスナップバックキャップ
32455 RIP DESIGN WORXX 666スナップバックキャップ BLACK
34099 RIP DESIGN WORXX EVIL STAR スナップバックキャップ BLACK
32053 THRASHER MAGAZINE LOGO TWO-TONE HAT BLACK
36622 RIP DESIGN WORXX イビルスタースナップバックキャップ BLK STAR
36623 RIP DESIGN WORXX イビルスタースナップバックキャップ WHT STAR
10222 THRASHER TIGER STRIPE SNAPBACK CAP
21358 THRASHER MAG LOGO SNAP BACK 17TH-C50 BLK/WHT
21858 SILLENT FROM ME QUIET -Snapback- BLACK
21859 SILLENT FROM ME QUIET -Snapback- WHITE
22673 THRASHER MAG LOGO SNAPBACK 17TH-C50 BLK/BLK
24380 SILLENT FROM ME LOSE-Snapback- BLK
26223 SILLENT FROM ME SPELL -Snapback- BLACK
28439 SILLENT FROM ME ENCRYPTION -Snapback- BLK/BLK
28441 SILLENT FROM ME ENCRYPTION -Snapback- BLK
28443 SILLENT FROM ME WHISPER -Polo Cap- BLK
28806 SILLENT FROM ME EPITAPH -5 Panel- BLACK
33423 アマツカミ 弔 Cap Black
33435 アマツカミ 心中 Cap Black
34207 SILLENT FROM ME HUMANE -Snapback- BLACK
36046 SILLENT FROM ME PYRAMID -Snapback- BLACK
36459 SILLENT FROM ME CHAOSTIAN -Braid Cap- BLACK
36578 MISHKA (ミシカ) EX1747A CAP BLACK
37009 MISHKA EX1747C CAP BLACK
37069 THRASHERxVANS JOCKEY
42755 SILLENT FROM ME STIGMA -Snapback- BLACK
42978 SILLENT FROM ME SMILE -Polo Cap- BLACK
45335 THRASHER 3131376 CHINA BANKS SNAPBACK BLACK
63252 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM 逮捕 CAP BLUE
58795 HYPER CORE BATTLEFIELD ロゴキャップ RED
24850 SILLENT FROM ME "20" -Snapback- MINOR LEAGUE Collaboration BLACK
27426 THRASHER SKATEGOAT WOOL BLEND SB BLACK
27427 THRASHER OATH PINSTRIPE SNAPBACK
28521 PUNK DRUNKERS PUN-Kds.CAP BLACK
29931 PUNK DRUNKERS ゾンビCAP BLACK
32064 PUNK DRUNKERS アイツップルCAP BLACK
35011 PUNK DRUNKERS さかなナイロンジェットCAP BLACK
35012 PUNK DRUNKERS 出刃CAP GRAY
28121 Xmas Eileen 『WORLD COUNTDOWN』メッシュキャップ BLK
21350 THRASHER SNAP BACK 15TH-C52 H.BLK/BLK
21351 THRASHER SNAP BACK 15TH-C52 BLK/BLK
21354 THRASHER SNAP BACK 17TH-C65 BLACK
23604 THRASHER SNAP BACK 17TH-C64 BLK
23919 THRASHER SNAP BACK 17TH-C64 BLK/RED
32051 THRASHER FLAME LOGO 5-PANEL HAT
46804 HEDWiNG Dripping Logo Cap Black/White
46805 HEDWiNG Dripping Logo Cap Black/Green
46806 HEDWiNG Dripping Logo Cap Black/Yellow
14775 MISHKA (ミシカ) BOOTLEG HORNS SNAPBACK BLACK
15255 ZEPHYREN (ゼファレン) MESH CAP -Thorns fame- BLK
17227 ZEPHYREN (ゼファレン) MESH CAP -BEYOND- BLACK/BURGUNDY
20499 MISHKA (ミシカ) CYCO MANIA SNAPBACK BLACK/WHITE
22059 MISHKA (ミシカ) KEEP WATCH SNAPBACK
24936 Zephyren (ゼファレン) JET CAP -BEYOND- BLACK
26346 Zephyren (ゼファレン) MESH CAP -VISIONARY- BLACKxWHITE
26347 Zephyren (ゼファレン) MESH CAP -VISIONARY- BLACKxBURGUNDY
26565 MISHKA x FAMOUS STARS AND STRAPS ALL SEEING SNAPBACK
26576 MISHKA (ミシカ) DAMAGED KEEP WATCH SNAPBACK Black
26578 MISHKA (ミシカ) KEEP WATCH SNAPBACK
26579 MISHKA (ミシカ) CARTOON ADDER SNAPBACK
26909 Zephyren (ゼファレン) TWILL CAP -NY- BLACK
30715 Zephyren(ゼファレン) TWILL CAP -ENGRAVE- BLACK
31810 SILLENT FROM ME SPELL -Cord Cap-
32087 MISHKA (ミシカ) EXPP162001D DADHAT
32088 MISHKA (ミシカ) EXPP162001C DADHAT
34217 MISHKA Fanzine Keep Watch Snapback BLK
34223 MISHKA BlackSheep Cap BLK
34225 MISHKA Hyper Real Keep Watch Snapback
34232 MISHKA Strong Bodies Dad Hat BLK
34233 MISHKA Lamour Keep Watch Snapback BLK
34234 MISHKA No Mercy Snapback BLK
34306 MISHKA (ミシカ) MSS173203 KEEP WATCH STRAPBACK
34307 MISHKA (ミシカ) MSS173204 KEEP WATCH STRAPBACK
34898 NineMicrophones SNAPBACKCAP-Comrade- BLACK-GOLD
35624 MISHKA (ミシカ) EXSP1728 KEEP WATCH SNAPBACK GREEN
35625 MISHKA (ミシカ) SM171706 KEEP WATCH SNAPBACK
35626 MISHKA (ミシカ) SM171707 SNAPBACK
35627 MISHKA (ミシカ) SM171707B STRAPBACK
35631 MISHKA (ミシカ) SM171710 SNAPBACK BLACK
35636 MISHKA (ミシカ) EXSP1728 KEEP WATCH SNAPBACK PURPLE
36384 MISHKA (ミシカ) EXSP1727 BOMB KW RED
36385 MISHKA (ミシカ) EXSP1727 BOMB KW BLUE
48517 MISHKA Cyrillic Snapback
61377 SLEEPING TABLET (スリーピングタブレット) ORDER [ LOW CAP ] BLACK
61692 TOY MACHINE (トイマシーン) FLAME FIST BB CAP BLACK
42721 SQUARE SPORTY JET CAP BLACK
29933 PUNK DRUNKERS PDSxKNAVE タグロゴCAP BLACK
29934 PUNK DRUNKERS PDSxKNAVE タグロゴCAP NAVY
33504 PUNK DRUNKERS (パンクドランカーズ) ドランクBB.CAP BLACK