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-04-20 11:35:59')
AND FIND_IN_SET(7, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
67510 SLIPKNOT UNISEX PULLOVER HOODIE: DON'T EVER JUDGE ME (BACK PRINT)
69755 Subciety (サブサエティ) Pieta PARKA MULTI
65778 アマツカミ 悲嘆/grief Hoodie
69070 NieR (ニーア) 切り離し可能BICOLOR 5ZIP PARKA【RED×BLACK】
67840 MISHKA (ミシカ) END IT NOW HOODIE MIGHO-BURGUNDY
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61402 NineMicrophones PIGMENT PARKA RED
60167 MISHKA X DENNIS THE MENACE TROUBLE MAKER HOODIE RED
66265 【単品販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! プルオーバーパーカー REDタイダイ
63678 【セット販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! SET UP REDタイダイ
65718 GALFY (ガルフィー) クレイジーわんわん大学 SET UP BLACK×RED
65552 over print (オーバープリント) over punx Pile Hoodie (red)
64332 NieR (ニーア) HALF ZIP HOODIE【RED ROSE】
61727 TRAVAS TOKYO【トラバストーキョー】切り替え総柄バイカラーパーカー マルチカラー
61821 RUDIE'S (ルーディーズ) BRINK PHAT HOOD SWEAT RED
61543 ZERO EVOKE Logo Second PARKA RED
61732 NieR (ニーア) DESIGN刺繍BICOLOR PULLOVER PARKA 【防寒裏起毛】
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
59518 Zephyren(ゼファレン) DOLMAN BIG PARKA RED / Creux
59523 Zephyren(ゼファレン) DOLMAN BIG PARKA RED / Reverie
60766 ROLLING CRADLE LOGO ROSE HOODIE / RED
60404 GoneR -La Neta- GRL05PK001New York Logo Parka Red
60697 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT RED
60587 RIPNDIP OG Prisma Embroidered Hoodie (Red Tie Dye)
60634 TRAVAS TOKYO【トラヴァストーキョー】 Furry bear Hoodie Bordeaux
60526 MAGICAL MOSH MISFITS MxMxM HOODIE RED
60503 Subciety (サブサエティ) SEA OTTER PARKA BURGUNDY
60031 HEDWiNG Game Maker Hoodie Red
59014 Subciety (サブサエティ) PIGMENT PARKA - RED
60201 Anti Social Social Club Guard Down Flower Hoodie
42165 Zephyren(ゼファレン) PARKA -PROVE- BURGUNDY
58413 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA BLK-RED
58514 ぜんぶ君のせいだ。×GEKIROCK CLOTHING×UNUSUAL コラボパーカー 如月 愛海 (きさらぎ めぐみ)
57978 TRAVAS TOKYO【トラバストーキョー】ファンシークラゲプリントモアビッグパーカー Black×Red
57410 THRASHER TH8501PL MAG LOGO HOODIE RED
57351 SUPPLIER (サプライヤー) LOGO HOODIE RED
56895 SALUTE CACTUS PRINTER HOODIE
56927 SLEEPING TABLET SAD [ HOODED SWEAT ] RED
56276 RUDIE'S SLICK HOOD SWEAT BURGUNDY
55625 SABBAT13 PENNYWISE HOODIE レッド
56204 Anti Social Social Club Headrush All Over White Hoodie
56206 Anti Social Social Club Don’t Red Hoodie
50339 NieR (ニーア) フード付き総柄ROSE TEE
55301 NieR (ニーア) 変則ブロッキングCUTSEW【BLACK×RED】フード付き
13800 Subciety TIE DYE PARKA-GLORIOUS- BGN
14157 DEADHEARTZ CRESCET HOODIE Burgundy
15325 CHUNK!NO,CAPTAIN CHUNK! Mustache Heather/Burgundy
16503 Subciety PARKA-Parantica sita- BURGUNDY
20429 PUNK DRUNKERS YUTORIパーカ BURGUNDY
21189 ROLLING CRADLE RC REFLECTION HOODIE / Burgundy
21701 THRASHER HOODIE TH8501H RED
21774 SQUARE WASHED LOGO HOODIE RED
22646 Zephyren (ゼファレン) CROSS PAISLEY PARKA BURGUNDY
22652 Zephyren (ゼファレン) PARKA -PROVIDENCE- BURGUNDY
22854 四星球 2015パーカー(A)
22953 ROLLING CRADLE BOX BOX FOAM LOGO HOODIE / Red
23296 ANIMALIA HOODIE-Logo#002 RED
23864 MISHKA (ミシカ) KEEP WATCH BOX LOGO PULLOVER HOODIE BLACK
23887 ROLLING CRADLE FLUFFY HALF HOODIE / Red
24643 NECK DEEP Generic Pop Punk Red Marble - Pullover
25678 Subciety (サブサエティ) TIE-DYE PARKA-GLORIOUS- RAINBOW
25682 Subciety (サブサエティ) TIE-DYE PARKA-SALOON- RAINBOW
25707 Subciety PARKA-GLORIOUS- BURGUNDY
26302 Zephyren (ゼファレン) S/S HOODY -BEYOND- BURGUNDY
28050 SPITFIRE Bighead Fill Sleeve YOUTH Pullover Hoody - RED
28324 PUNK DRUNKERS さかなパーカ BURGUNDY
28459 Gluttonous Slaughter (グラトナス・スローター) Gluttonous Creatures HOODIE BURGUNDY
29394 NineMicrophones (ナインマイクロフォンズ) PARKA-Honor- BURGUNDY
29925 Subciety (サブサエティ) Subciety×MarkGonzales PARKA RED
32420 ROLLING CRADLE R-kn BEACH ZIP HOODIE / Burgundy
32430 ROLLING CRADLE (ロリクレ) 6090 ALL STAR HOODIE RED
32509 RIP DESIGN WORXX ロゴプルオーバーパーカー2017【レッド】
34104 RIP DESIGN WORXX スプラッシュパーカー RED
34605 Subciety (サブサエティ) PARKA-THE BASE- BURGUNDY
34615 Subciety (サブサエティ) PARKA-Nbomb- RED
34846 NineMicrophones PARKA-9MC CREW- BURGUNDY-MUSTARD
36155 PUNK DRUNKERS モアイパーカ - RED
37347 ROLLING CRADLE RC CYCLOPS TERROR HOODIE / Burgundy
37594 ROLLING CRADLE RLIG CDLE PIGMENT HOODIE / Red
37942 Subciety (サブサエティ) PARKA-lithium- RED
38623 THRASHER TH8501FT MAG FRENCH TERRY HOODIE RED PEPPER
38858 LILWHITE(dot) (リルホワイトドット) -VICTIM- HOODIE RED
38952 PARADOX - PULL PARKA (RED)
39009 KAVANE MADNESSプルオーバーパーカー (RED)
39111 Hypocrite (ヒポクリット) VIETWO PULLOVERHOODY (BGDxBLK)
39879 PARADOX - ARM BELT PARKA(SCARLET)
39888 RUDIE'S SLICK HOOD SWEAT BURGUNDY
41856 MISHKA (ミシカ) MAW180407 HOOD RED
41889 MISHKA (ミシカ) MAW180466 HOOD Red
42171 Zephyren(ゼファレン) PARKA -DOOR- BURGUNDY
42389 LILWHITE(dot) (リルホワイトドット) LW-18AW-S02 -REFLECTED- HOODIE RED
42573 DISTURBIA CLOTHING DIS Pullover Hoody (Red)
43025 FILA FM9417 PULL OVER HOODIE PEACOAT
43040 FILA FM9432 PULL OVER HOODIE CHINESE RED
43244 RUDIE'S SPOIL HOOD SWEAT BURGUNDY
43299 TOY MACHINE TMF18SW7 TAPE LOGO SWEAT PARKA RED
43320 GALFY 普通にパーカー RED
43401 GALFY タンジョウパーカー
43462 GALFY パーカー RED
43507 RIP DESIGN WORXX マジックキャットネオンサインパーカー WINE
43752 THRASHER TH8501 MAG LOGO HOODIE RED/BLACK
43904 THRASHER STTH-1008S HOODIE BURGUNDY
43960 GALFY 総柄パーカー RED
44101 REBEL8 Eternal Logo Pullover Red
44163 GoneR (ゴナー) GR19PK001 Paint Mexican Skull Sweat Parka Red
44172 GoneR (ゴナー) GR19PK002 Rose Sleeve Sweat Parka Red
44995 FILA FM9537 PULLOVER HOODIE FLAME RED
45095 MUSIC SAVED MY LIFE (MSML) M1H5T-CS02 BIG HOODIE 18 RED
45627 MISHKA MSS190404M75 HOOD
45629 MISHKA MSS190403F75 HOOD
45831 MISHKA MSS190413 HOOD RED
45919 ROLLING CRADLE CYCLOPS HOLIDAY-WORLD TOUR- / Maroon
45942 NOT COMMON SENSE FUXX THE POLICE SEAM HOODIE RED
45945 NOT COMMON SENSE GENESIS SEAM HOODIE RED
45985 Zephyren(ゼファレン)PARKA -alea iacta est / milestone- BURGUNDY
46739 THRASHER 314278 Godzilla HOOD