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-05-26 21:47:40')
AND pc.price02 > 4545
AND price02 <= 9090
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
15534 MAYDAY PARADE Arrow Black / Red Snapback
19838 LIKE MOTHS TO FLAMES FLAMES CAMO SNAPBACK
19871 YELLOWCARD LOGO BLACK/GREEN BRIM
24701 MEMPHIS MAY FIRE Logo Black - White Brim Snapback
25155 WE CAME AS ROMANS WCAR Black - Snapback
25160 WE CAME AS ROMANS Crest Black / Red - Snapback
25178 ERRA Circle Logo Black - Snapback Hat
25494 THE WORD ALIVE REAL Black - Snapback
26190 BAD RELIGION BR Logo Snapback
26203 BEASTIE BOYS Check Your Head Snapback
26206 BEHEMOTH Logo Snapback Hat
39169 LINKIN PARK Logo Snapback
41043 OBEY x Misfits Caress Snapback BLACK
41048 OBEY x Misfits Fiend Club 6 Panel Hat BLACK
50246 MISHKA MAW193206 CAP
50247 MISHKA MAW193236 CAP
52934 TOY MACHINE TMP20HW26 CAP BLACK
52991 RUDIE'S SPARK SNAPBACK CAP GALAXY
53157 HEDWiNG HD8-006 Jellyfish Cap Black
53164 TOY MACHINE TMS20HW12 BB CAP BLACK
53202 MISHKA [ミシカ] MSS203213F99 CAP BLACK
54663 MISHKA(ミシカ) MSS203210 CAP
54667 MISHKA(ミシカ) MSS203213 CAP BLACK
54668 MISHKA(ミシカ) MSS203209 CAP
54869 PUNK DRUNKERS 宇宙人スケボーCAP - BLACK
55945 TOY MACHINE TOYMONSTER BB CAP - BLACK
55544 HEDWiNG Graffiti Logo Cap
55886 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Black
55995 ROLLING CRADLE NEW ERA CAP 59FIFTY-CIRCLE LOGO- / NAVY
56960 MAGICAL MOSH MISFITS MxMxM モコモコ PILOT CAP(2WAY) BLACK
57063 ANIMALIA AN20A-CP03 “R.I.B.” BOMBER CAP BLACK
56339 NineMicrophones SNAP BACK CAP-NM/CS- BLACK/RED
57221 TOY MACHINE CLAIRVOYANT BB CAP - BLACK
56401 Subciety SNAP BACK CAP-SERVER- BLACK/WHITE
56684 PUNK DRUNKERS ユル鮫人CAP - BLACK
58040 TOY MACHINE TOYMONSTER HELLO KITTY EMB SIX PANEL CAP - BLACK
56682 PUNK DRUNKERS [PDSxGODZILLA]メカゴジラCAP - BLACK
57309 HEDWiNG Flamingo Skater Cap Black
57616 【予約商品】Zephyren(ゼファレン) B.B CAP -BEYOND- BLACK / GRAY
57610 【予約商品】Zephyren(ゼファレン) B.B CAP -BEYOND- BLACK / WHITE
58490 SILLENT FROM ME EYE -Snapback-
58583 TOY MACHINE SECT EYE MESH CAP BLACK
57868 Subciety LOWCAP-Robin- BLACK
58230 PUNK DRUNKERS スーパーPDSジェットCAP - BLACK
59222 LONELY論理 LIMP CAP BLACK
58232 PUNK DRUNKERS メタルロゴCAP - BLACK
59306 Subciety (サブサエティ) SNAPBACK CAP-CROWD- BLACK/WHITE
59382 MAGICAL MOSH MISFITS MxMxM ビリビリ BB CAP DOKU
59381 MAGICAL MOSH MISFITS MxMxM ビリビリ BB CAP BLUE
57871 Subciety SNAPBACK CAP-Fuckyou- BLACK
60004 GALFY わんわん大学 CAP BLACK/YELLOW
60143 SUPPLIER (サプライヤー) LEATHER BASEBALL CAP
59136 PUNK DRUNKERS [PDSxPAC-MAN]GAMER.CAP - BLACK
60335 LONELY論理 COTTON DAMAGED CLASSIC LOGO CAP BLACK
59947 PUNK DRUNKERS CAPのCAP - BLACK
60531 MAGICAL MOSH MISFITS MxMxM DOKURO BB CAP DOKU
60530 MAGICAL MOSH MISFITS MxMxM DOKURO BB CAP BLACK
60304 TOY MACHINE (トイマシーン) TOYMONSTER CAT BB CAP - BLACK
59200 VIRGO CROSS V WOOL CAP BLACK
62554 over print (オーバープリント) ZERO ZERO HERO CAP black
62140 DEXCORE×GEKIROCK CLOTHING×KAVANE Clothing コラボ・キャップ
61344 SLEEPING TABLET TABLETS [ LOW CAP ] BLACK
62823 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN MOSH SNAPBACKCAP BLACK
62540 TOY MACHINE (トイマシーン) TM & EYE BB CAP - BLACK
64220 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG MESH CAP - BLACK
64317 Subciety (サブサエティ) FLOCKS CAP BLACK
64290 RIPNDIP (リップンディップ) Summer Revenge 6 Panel (Black)
65270 GALFY (ガルフィー) 野良犬 CAP-BLACK/SAX
65441 RIPNDIP (リップンディップ) Dark Twisted Fantasy 6 Panel Hat (Black)
65634 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) ぬくぬくCAP (フリース)-BLACK
65701 LONELY論理 ICON CHECK LOW CAP-BLACK
17231 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- - BLACK/WHITE
17236 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- BLACK/GRAY
66276 ANIMALIA (アニマリア) FLIGHT CAP BLACK
65269 GALFY (ガルフィー) 野良犬 CAP-BLACK/BLACK
65271 GALFY (ガルフィー) 野良犬 CAP-GARY/BLACK
65524 Subciety (サブサエティ) WOOL HUNTING BLACK
65525 Subciety (サブサエティ) CORDUROY CAP-CROWD- BLACK
66867 RIPNDIP (リップンディップ) Taste The Rainbow Wool Snapback Black
66054 PUNK DRUNKERS (パンクドランカーズ) アイツちゃんCAP - BLACK
67471 RUDIE'S(ルーディーズ) SHADOW LOGO SNAPBACK CAP BLACK
67520 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ LOW CAP ]GRAY
67519 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ LOW CAP ]BLACK
67873 白石万浬 × DI:VISION コラボ限定キャップ
67891 RIPNDIP (リップンディップ) Love U Dad Hat (Black)
68324 over print (オーバープリント) Washer Cap (black)
65302 松山 ダリア×GoneR コラボ 限定 キャップ
65296 山手 響子×RIPDW コラボ 限定 キャップ
66959 TOY MACHINE (トイマシーン) OG MONSTER BB CAP BLACK/RED
68244 TOY MACHINE (トイマシーン) TOYMONSTER PIGMENT 2 TONE CAP BLACK
68474 HEDWiNG (ヘドウィグ) Two Tone Ball Cap BLACKxBURGUNDY
68111 Subciety (サブサエティ) SNAPBACK CAP-CREST- BLACK/WHITE
68480 RIPNDIP (リップンディップ) Nerminator 2.0 Snapback BLACK
68815 HYPER CORE(ハイパーコア) A-519 HC BONEロゴキャップ
68816 HYPER CORE(ハイパーコア) A-519 HC メタルロゴロゴキャップ
68817 HYPER CORE(ハイパーコア) A-519 HC 招き猫ロゴキャップ
68969 PSYCHOLOGICAL METAMORPHOSIS PM BB CAP BLACK
69217 GoneR(ゴナー) GR37CP001 Flat Visor Mesh Cap Black/Black
69216 GoneR(ゴナー) GR37CP001 Flat Visor Mesh Cap Black/Grey
69242 THRASHER (スラッシャー) Gonz 5 Panel Camp Hat BLACK/RED
69241 THRASHER (スラッシャー) Mag Logo Snapback BLACK/WHITE
67407 愛本りんく × RUDIE'S コラボ限定キャップ
69253 Subciety (サブサエティ) CAMPER CAP BLACK
69251 Subciety (サブサエティ) SNAPBACK CAP-SOLID- BLACK
69252 Subciety (サブサエティ) SNAPBACK CAP-theCREW- BLACK/WHITE
69250 Subciety (サブサエティ) SNAPBACK CAP-faith- BLACK/WHITE
68389 SABBAT13(サバトサーティーン) SPOOK CAP (BLACK)
69590 RIPNDIP (リップンディップ) MAN I LOVE FELINES STRAPBACK
69742 ANIMALIA (アニマリア) CORDURA® AVIATOR CAP BLACK
69744 ANIMALIA (アニマリア) CORDURA® FLAP CAP BLACK
65629 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) モコモコボアのバケットハット-BLACK
69984 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) FIRE MOSH MISFITS CAP DOKU
69983 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) FIRE MOSH MISFITS CAP RED
69255 NineMicrophones(ナインマイクロフォンズ) LOW CAP-Comrade- BLACK
69022 GALFY (ガルフィー) 犬耳フライトキャップ BLACK
69061 LiSA x GoneR SnapBack Cap White/Black
69062 LiSA x GoneR SnapBack Cap Black/White
70538 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM COLORS LOGO BB CAP BLACK
70513 TOY MACHINE (トイマシーン) ROBOT & SECT 2 TONE CAP BLACK
68779 旭 那由多×RUDIE'S コラボ限定キャップ