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 =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-30 17:46:26')
AND FIND_IN_SET(3, p.color)
AND pc.classcategory_id1 IN( 13,35,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
70683 LINKIN PARK UNISEX PULLOVER HOODIE: STREET SOLDIER
69363 MY CHEMICAL ROMANCE UNISEX PULLOVER HOODIE: XV MARCHING FRAME (BACK PRINT)
71429 gibous(ギボス) button gothic logo hoodie WHITE
70744 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident PARKA WHITE
70235 One Drop(ワンドロップ) chao! Kiss me PK WHITE
69432 アマツカミ 紫菊/mum Hoodie WHITE
66453 MISHKA (ミシカ) M61100405 Double Strings Pullover Hoodie WHITE
68003 【BanG Dream! ×ゲキクロ 2023 ver.】パレオ×DI:VISION コラボ プルオーバーパーカー
67864 五稜結人 × KAVANE Clothing コラボ限定プルオーバーパーカー
67743 DI:VISION (ディヴィジョン) RELAPSE HOODIE WHITE
66804 THE SILENT DOG × GEKIROCK CLOTHING× NOTBADCAT 限定コラボ Pullover WHITE
66748 Non Stop Rabbit×GEKIROCK CLOTHING 限定コラボパーカー WHITE×BLUE
66749 Non Stop Rabbit×GEKIROCK CLOTHING 限定コラボパーカー WHITE×YELLOW
66750 Non Stop Rabbit×GEKIROCK CLOTHING 限定コラボパーカー WHITE×RED
66751 Non Stop Rabbit×GEKIROCK CLOTHING 限定コラボパーカー WHITE×BLACK
66235 glamb(グラム) Himiko Toga Hoodie White
66723 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise PARKA OATMEAL
65929 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・パーカー The Scream WHITE
66495 10-FEET×Zephyren(ゼファレン) BIG PARKA GRAY
66583 over print(オーバープリント) Inverted Hoodie *ZERO ZERO HERO (white)
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
66630 MAGICAL MOSH MISFITS 交響詩篇エウレカセブン x MxMxM “ANEMONE MOSH MISFITS” HOODIE WHITE
65667 MISHKA (ミシカ) M61100415 BIGSILHOUETTE PARKA WHITE
61759 MISHKA (ミシカ) M21100407 HOODIE
61271 Zephyren 2022 NEW YEAR BAG
65549 over print (オーバープリント) over punx Pile Hoodie (white)
63850 26時のマスカレイド×GEKIROCK CLOTHING×DI:VISIONコラボ・パーカー WHITE
63556 glamb (グラム) Bizarre Cord Hoodie - White
63295 Anti Social Social Club Playboy x ASSC Bunny Logo White Hoodie
56935 TEARS OF TRAGEDY×GEKIROCK CLOTHING 限定コラボ・パーカー WHITE
61336 glamb (グラム)×チェンソーマン Power & Kobeni Hoodie White
61330 【予約商品】glamb (グラム)×チェンソーマン Power Hoodie White
61527 Unlucky Morpheus×GEKIROCK CLOTHING 限定コラボ・パーカー NEWカラー OFF-WHITE
61342 SLEEPING TABLET TABLETS [ PULLOVER ] WHITE
61440 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie White
61539 ZERO EVOKE Logo Second PARKA WHITE×BLACK
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61568 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT HOODIE CREAM
61580 over print (オーバープリント) MCC Hoodie *GAKUMYU ivory
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
61447 over print (オーバープリント) PASS Hoodie white
61310 MAGICAL MOSH MISFITS まことちゃん x まじかる “どろどろまことちゃん” HOODIE WHITE
60844 エルフリーデ×ゲキクロ×DI:VISIONスペシャル・コラボ・パーカー WHITE
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60698 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT WHITE
27138 Zephyren (ゼファレン) PARKA -BEYOND- WHITE
59418 SUPPLIER (サプライヤー) Fire Logo Hoodie BEIGE
58519 ぜんぶ君のせいだ。×GEKIROCK CLOTHING×UNUSUAL コラボパーカー メイユイメイ
58109 MISHKA M21000404 Pullover WHITE
57332 Subciety×仮面ライダードライブ MACH PARKA WHITE
58056 NOT COMMON SENSE NCS SNAKE HOODIE WHITE
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
57414 THRASHER (スラッシャー) TH8528PLGONZ HOODIE WHITE
43265 SILLENT FROM ME STIGMA -Pullover- WHITE
45120 FOG ESSENTIALS Pullover Hoodie B/CREAM
56749 SILLENT FROM ME 沈黙・不穏 -Loose Pullover- WHITE
56540 ANIMALIA AN20A-SW07 “SKUNKEY” Big silhouette Hoodie
56287 MUSIC SAVED MY LIFE (MSML) TIE DYE SWEAT PARKA
55608 SABBAT13 GHOSTLY HOODIE ホワイト
56268 TOY MACHINE FIST EMBROIDERY SWEAT PARKA - WHITE
56204 Anti Social Social Club Headrush All Over White Hoodie
55916 MISHKA MAW200401 HOODIE WHITE
56119 SILLENT FROM ME EVIDENCE Plain Parka WHT
54590 アマツカミ 棘 Hoodie White
10608 MISHKA (ミシカ) HELLA STUFF PULLOVER WHITE
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
20715 Subciety PARKA-CAMOUFLAGE SALOON- WHITE
21163 BLACK CRAFT Planchette - White Hooded Pullover
21527 ROLLING CRADLE RC×Mark Gonzales CLOUD HOODIE / WHT
21762 ICECREAM INDIANS HOODIE WHITE
22008 ROLLING CRADLE Troopers Hoodie WHT
22325 THRASHER SCARRED HOODIE
22333 DEADHEARTZ GOTHIC HOODIE WHT
22354 Zephyren (ゼファレン) PARKA -Zephees- WHT
22479 DROP DEAD CLOTHING (ドロップデッド・クロージング) Tracker Hoodie
22513 SABBAT13 MORTAL PARKA (WH)
22738 PUNK DRUNKERS 星いっぱいパーカ WHITE
22853 四星球 2015パーカー(B)
22954 ROLLING CRADLE BOX FOAM LOGO HOODIE / White
23384 PUNK DRUNKERS ムカデロングパーカ WHITE
23422 SILLENT FROM ME LOSE-Pullover- WHITE
24497 RIP DESIGN WORXX 666 SWASH HOODIE WHT
25215 RIP DESIGN WORXX ロゴプルオーバーパーカー ホワイト
25683 Subciety (サブサエティ) PARKA-THE BASE- WHITE
25689 Subciety PARKA-MELT GLORIOUS- WHITE-RED
25692 Subciety (サブサエティ) PARKA-Amploud- WHITE
25698 Subciety (サブサエティ) PARKA-MUSIC DESTROYー WHITE
25704 Subciety PARKA-GLORIOUS- WHITE
25708 Subciety REFLECTOR PRINT PARKA-GLORIOUS- WHITE
25992 NineMicrophones (ナインマイクロフォンズ) LINE PARKA-Skate College- WHITE
26301 Zephyren (ゼファレン) S/S HOODY -BEYOND- WHITE
27204 Zephyren (ゼファレン) HEAVY WEIGHT PARKA -BEYOND- WHITE
27212 Zephyren (ゼファレン) HEAVY WEIGHT PARKA -SPADE- GRAY
27584 Subciety X ANDSUNS PARKA WHITE
27838 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING HOODIE WHT
28323 PUNK DRUNKERS さかなパーカ WHITE
28429 RUDIE'S PHAT HOOD SWEAT WHT
28969 ROLLING CRADLE KANJI LOGO HOODIE / White
29098 THRASHER TH95130 FLAME 3C HOODIE WHT/BLU
29200 Subciety (サブサエティ) PAISLEY PARKA-GLORIOUS- WHITE
29213 Subciety (サブサエティ) PARKA-Propaganda- WHITE
29395 NineMicrophones (ナインマイクロフォンズ) PARKA-Pass the mic- WHITE
29398 NineMicrophones (ナインマイクロフォンズ) PARKA -how high- WHITE
29496 ROLLING CRADLE (ロリクレ) ROLLING-BAR HOODIE / White
29598 ROLLING CRADLE RC×SESAMI STREET HOODIE / Oatmeal
29601 ROLLING CRADLE RC×KERMIT HOODIE / White
29635 GoneR Kiriste Waffle Pull Parka White
29638 GoneR Flower Bolt Pull Parka White
29642 GoneR Skull Heart Pull Parka White
29722 THRASHER THKH-HD08 HOODIE WHITE
29898 RIP DESIGN WORXX SCRAMBLE HOODIE 白
29947 VIRGO COEXISTENCE PARKA NATURAL
30005 MISHKA (ミシカ) LOCALS KEEP WATCH PULLOVER HOODIE WHITE
30006 MISHKA (ミシカ) WORLD PEACE PULLOVER HOODIE WHITE
30008 MISHKA (ミシカ) LAMOUR SUPREME: SPLIT ICONS PULLOVER HOODIE HEATHER
30104 MISHKA (ミシカ) SOFT CREM KEEP WATCH HOODIE WHITE
30836 Zephyren(ゼファレン) PARKA -CocaCola- WHITE
31806 SILLENT FROM ME EPITAPH -Pullover- WHITE