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 =588
)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 05:34:57')
AND FIND_IN_SET(7, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
60697 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT RED
32509 RIP DESIGN WORXX ロゴプルオーバーパーカー2017【レッド】
43462 GALFY パーカー RED
61727 TRAVAS TOKYO【トラバストーキョー】切り替え総柄バイカラーパーカー マルチカラー
52443 STAPLE Neo Sport Nylon Hoodie
39009 KAVANE MADNESSプルオーバーパーカー (RED)
43507 RIP DESIGN WORXX マジックキャットネオンサインパーカー WINE
21701 THRASHER HOODIE TH8501H RED
38623 THRASHER TH8501FT MAG FRENCH TERRY HOODIE RED PEPPER
43752 THRASHER TH8501 MAG LOGO HOODIE RED/BLACK
61543 ZERO EVOKE Logo Second PARKA RED
34104 RIP DESIGN WORXX スプラッシュパーカー RED
22854 四星球 2015パーカー(A)
13800 Subciety TIE DYE PARKA-GLORIOUS- BGN
60167 MISHKA X DENNIS THE MENACE TROUBLE MAKER HOODIE RED
20429 PUNK DRUNKERS YUTORIパーカ BURGUNDY
43904 THRASHER STTH-1008S HOODIE BURGUNDY
60526 MAGICAL MOSH MISFITS MxMxM HOODIE RED
26302 Zephyren (ゼファレン) S/S HOODY -BEYOND- BURGUNDY
36155 PUNK DRUNKERS モアイパーカ - RED
59523 Zephyren(ゼファレン) DOLMAN BIG PARKA RED / Reverie
60503 Subciety (サブサエティ) SEA OTTER PARKA BURGUNDY
65778 アマツカミ 悲嘆/grief Hoodie
28324 PUNK DRUNKERS さかなパーカ BURGUNDY
55301 NieR (ニーア) 変則ブロッキングCUTSEW【BLACK×RED】フード付き
43025 FILA FM9417 PULL OVER HOODIE PEACOAT
43320 GALFY 普通にパーカー RED
43401 GALFY タンジョウパーカー
51493 NieR (ニーア) ポケット付総柄ペイント半袖パーカー
61732 NieR (ニーア) DESIGN刺繍BICOLOR PULLOVER PARKA 【防寒裏起毛】
41889 MISHKA (ミシカ) MAW180466 HOOD Red
64332 NieR (ニーア) HALF ZIP HOODIE【RED ROSE】
60031 HEDWiNG Game Maker Hoodie Red
50339 NieR (ニーア) フード付き総柄ROSE TEE
69070 NieR (ニーア) 切り離し可能BICOLOR 5ZIP PARKA【RED×BLACK】
42171 Zephyren(ゼファレン) PARKA -DOOR- BURGUNDY
45629 MISHKA MSS190403F75 HOOD
45985 Zephyren(ゼファレン)PARKA -alea iacta est / milestone- BURGUNDY
15325 CHUNK!NO,CAPTAIN CHUNK! Mustache Heather/Burgundy
65552 over print (オーバープリント) over punx Pile Hoodie (red)
28459 Gluttonous Slaughter (グラトナス・スローター) Gluttonous Creatures HOODIE BURGUNDY
10639 THRASHER TH8501 MAG LOGO HOODIE BRG/WHT
57410 THRASHER TH8501PL MAG LOGO HOODIE RED
54520 FILA TOKYO ユニセックス プルオーバーフーディ RED
24643 NECK DEEP Generic Pop Punk Red Marble - Pullover
60404 GoneR -La Neta- GRL05PK001New York Logo Parka Red
22646 Zephyren (ゼファレン) CROSS PAISLEY PARKA BURGUNDY
22652 Zephyren (ゼファレン) PARKA -PROVIDENCE- BURGUNDY
38952 PARADOX - PULL PARKA (RED)
39888 RUDIE'S SLICK HOOD SWEAT BURGUNDY
43244 RUDIE'S SPOIL HOOD SWEAT BURGUNDY
44163 GoneR (ゴナー) GR19PK001 Paint Mexican Skull Sweat Parka Red
44172 GoneR (ゴナー) GR19PK002 Rose Sleeve Sweat Parka Red
67510 SLIPKNOT UNISEX PULLOVER HOODIE: DON'T EVER JUDGE ME (BACK PRINT)
28050 SPITFIRE Bighead Fill Sleeve YOUTH Pullover Hoody - RED
43040 FILA FM9432 PULL OVER HOODIE CHINESE RED
58514 ぜんぶ君のせいだ。×GEKIROCK CLOTHING×UNUSUAL コラボパーカー 如月 愛海 (きさらぎ めぐみ)
56276 RUDIE'S SLICK HOOD SWEAT BURGUNDY
61821 RUDIE'S (ルーディーズ) BRINK PHAT HOOD SWEAT RED
14157 DEADHEARTZ CRESCET HOODIE Burgundy
32420 ROLLING CRADLE R-kn BEACH ZIP HOODIE / Burgundy
43299 TOY MACHINE TMF18SW7 TAPE LOGO SWEAT PARKA RED
44995 FILA FM9537 PULLOVER HOODIE FLAME RED
50278 GALFY 狂犬病パーカー RED
51217 TOY MACHINE TMF19SW16 BRAINWASH SLEEVE PRINT SWEAT PARKA BURGANDY
52520 RUDIE’S 2020 NEWYEAR PACK
53918 PSYCHOLOGICAL METAMORPHOSIS PLMP WALL PARKA RED
50170 PUNK DRUNKERS [PDSxPEACEMAKER]少林寺パーカ RED
52522 KAVANE Clothing "DECOY"OVERSIZE HOODIE(red)
58413 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA BLK-RED
21189 ROLLING CRADLE RC REFLECTION HOODIE / Burgundy
22953 ROLLING CRADLE BOX BOX FOAM LOGO HOODIE / Red
32430 ROLLING CRADLE (ロリクレ) 6090 ALL STAR HOODIE RED
45919 ROLLING CRADLE CYCLOPS HOLIDAY-WORLD TOUR- / Maroon
51176 SABBAT13 IGOR HOODIE(レッド)
55625 SABBAT13 PENNYWISE HOODIE レッド
57978 TRAVAS TOKYO【トラバストーキョー】ファンシークラゲプリントモアビッグパーカー Black×Red
60634 TRAVAS TOKYO【トラヴァストーキョー】 Furry bear Hoodie Bordeaux
34605 Subciety (サブサエティ) PARKA-THE BASE- BURGUNDY
38858 LILWHITE(dot) (リルホワイトドット) -VICTIM- HOODIE RED
41856 MISHKA (ミシカ) MAW180407 HOOD RED
42165 Zephyren(ゼファレン) PARKA -PROVE- BURGUNDY
42573 DISTURBIA CLOTHING DIS Pullover Hoody (Red)
46739 THRASHER 314278 Godzilla HOOD
56204 Anti Social Social Club Headrush All Over White Hoodie
52299 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL DRIP DOT” HOODIE RED
23887 ROLLING CRADLE FLUFFY HALF HOODIE / Red
37347 ROLLING CRADLE RC CYCLOPS TERROR HOODIE / Burgundy
43960 GALFY 総柄パーカー RED
50602 GALFY 野良犬ダブダブパーカー 赤野良犬
52586 CIVARIZE "Lethargy" , All patterned pullover hoodie RED
25707 Subciety PARKA-GLORIOUS- BURGUNDY
34615 Subciety (サブサエティ) PARKA-Nbomb- RED
34846 NineMicrophones PARKA-9MC CREW- BURGUNDY-MUSTARD
37942 Subciety (サブサエティ) PARKA-lithium- RED
39111 Hypocrite (ヒポクリット) VIETWO PULLOVERHOODY (BGDxBLK)
44101 REBEL8 Eternal Logo Pullover Red
45831 MISHKA MSS190413 HOOD RED
50437 Subciety (サブサエティ) PARKA-LABEL- BURGUNDY
51955 Zephyren(ゼファレン) PARKA -PROVE- BURGUNDY
52417 Zephyren 2020 NEW YEAR BAG
37594 ROLLING CRADLE RLIG CDLE PIGMENT HOODIE / Red
16503 Subciety PARKA-Parantica sita- BURGUNDY
23864 MISHKA (ミシカ) KEEP WATCH BOX LOGO PULLOVER HOODIE BLACK
29394 NineMicrophones (ナインマイクロフォンズ) PARKA-Honor- BURGUNDY
29925 Subciety (サブサエティ) Subciety×MarkGonzales PARKA RED
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
65718 GALFY (ガルフィー) クレイジーわんわん大学 SET UP BLACK×RED
52226 MISHKA (ミシカ) 2020福袋 -NEW YEAR BAG-
53076 SAMURAI CORE 釈迦 HOODIE RED
57351 SUPPLIER (サプライヤー) LOGO HOODIE RED
60587 RIPNDIP OG Prisma Embroidered Hoodie (Red Tie Dye)
25678 Subciety (サブサエティ) TIE-DYE PARKA-GLORIOUS- RAINBOW
25682 Subciety (サブサエティ) TIE-DYE PARKA-SALOON- RAINBOW
23296 ANIMALIA HOODIE-Logo#002 RED
61402 NineMicrophones PIGMENT PARKA RED
53112 SAMURAI CORE 夜露死苦哀愁 HOODIE RED
42389 LILWHITE(dot) (リルホワイトドット) LW-18AW-S02 -REFLECTED- HOODIE RED
45095 MUSIC SAVED MY LIFE (MSML) M1H5T-CS02 BIG HOODIE 18 RED
51869 Zephyren(ゼファレン) SWITCHING PARKA NAVY / RED