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 =395
)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-28 18:48:56')
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
69228 パラッパラッパー グラフィック発泡プリント ハーフZIPスウェット OFF WHITE
70739 攻殻機動隊 STAND ALONE COMPLEX x Subciety GALLERY SWEAT WHITE
70230 One Drop(ワンドロップ) ふくだ 餃子刺繍スウェット WHITE
70231 One Drop(ワンドロップ) 島田つか沙×ふくだ ビスケットSweat WHITE
68900 FACT101(ファクト・イチマルイチ) 『 あしんめとりちゃん 』 スウェット WHITE
69297 MISHKA (ミシカ) Embroidery Pullover Off White
65664 MISHKA (ミシカ) M61100404 WHITE“MOP”SWEAT
69286 TheBackOfBoys(ザバックオブボーイズ) Glasses Girls Crewneck Sweat WHITE
66910 ハッピーハンバーグ カラーブロックスウェット WHITE
66450 kirou school(キロウスクール) Active Girl sweat WHITE
66445 MISHKA (ミシカ) M61100455 Monogram Mop Oversized Sweatshirt WHITE
61271 Zephyren 2022 NEW YEAR BAG
61404 NineMicrophones SWEAT-Wanderer- WHITE
63570 glamb (グラム) Retro Future Sweat - White
61323 glamb (グラム)×チェンソーマン Makima Sweat White
61340 glamb (グラム)×チェンソーマン Aki Sweat White
61760 MISHKA (ミシカ) M21100401 CREW WHITE
61793 over print (オーバープリント) Deformed sweatshirt white
61532 ZERO EVOKE Logo First SWEAT WHITE×WHITE
61533 ZERO EVOKE Logo First SWEAT WHITE×BLACK
61451 over print (オーバープリント) Plane sweatshirt white
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
57087 工藤晴香×激ロック×ゲキクロ×DI:VISIONコラボ 限定スウェット “FEEL EASY SWEAT” WHITE
60286 MISHKA M61000410 CREW WHITE
58113 MISHKA M21000414M WHITE
57417 THRASHER (スラッシャー) TH8401PL MAG LOGO SWEAT WHITE
57422 THRASHER (スラッシャー) TH8428PLGONZ SWEAT WHITE
56441 Subciety (サブサエティ) SWEAT-SERVER-WHITE
56750 SILLENT FROM ME 沈黙・秘密 -Loose Crew Sweat- WHITE
55975 ANIMALIA AN20A-SW06 “BLACKFOOT” Big silhouette Crew Neck Sweat WHITE
56284 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT OFF WHITE
56197 NOT COMMON SENSE BUTTERFLY FLEECE THREE QUARTER SLEEVE WHITE
55914 MISHKA MAW200423 SWEAT WHITE
14295 ROLLING CRADLE CHIPS SWEAT WHITE
15499 MISHKA (ミシカ) Autopsy Vex Crew Neck
17947 KILL STAR CLOTHING SPACE GRASS SWEATSHIRT
18397 Subciety SWEAT-LARGE GLORIOUS- - WHITE
21302 ROLLING CRADLE STONED SWEAT / White
21539 PUNK DRUNKERS 段染めりすトレーナー WHITE/BLUE
22131 BLACK HOLE BUNNY クルーネック Gummy Delta WHT
22183 KILL STAR CLOTHING Dino Sweatshirt
22402 KILL STAR CLOTHING Cult Sweatshirt
22409 KILL STAR CLOTHING (キルスター・クロージング) Yin/Yang Sweatshirt
22516 SABBAT13 CROWN BIG SWEAT (WH)
22782 ROLLING CRADLE AIN’T 2 PROUD SWEAT / Oatmeal
22849 ROLLING CRADLE UNREASONABLE MONSTER SWEAT / White
22872 RUDIE'S GALAXY SPARK CREWSW WHITE
23345 GoneR GoneR × NEeeSAN Crew Neck Sweat - White
23452 HER NAME IN BLOOD ダンベル・クルーネック WHITE
23781 KILL STAR CLOTHING (キルスター・クロージング) Fractal Sweatshirt [B]
23785 KILL STAR CLOTHING (キルスター・クロージング) Motto Sweatshirt [B]
23790 KILL STAR CLOTHING (キルスター・クロージング) Thelema Sweatshirt [B]
24562 Hypocrite (ヒポクリット) The Spinal cord Sweat Light BLK
25727 Subciety (サブサエティ) SWEAT-THE BASE- WHITE
25733 Subciety SWEAT-MELT GLORIOUS- WHITE-RED
25735 Subciety SWEAT-MELT GLORIOUS- BLUE-WHITE
25742 Subciety (サブサエティ) SWEAT-MUSIC DESTROY- WHITE
25748 Subciety SWEAT-GLORIOUS- WHITE
25749 Subciety SWEAT-GLORIOUS- BLACK-WHITE
25751 Subciety SWEAT-GLORIOUS- BURGUNDY
25752 Subciety SWEAT-SALOON- WHITE
25995 NineMicrophones (ナインマイクロフォンズ) SWEAT-CAMOUFLAGE 9MC Crew- WHITE
27176 Zephyren (ゼファレン) LIGHT WEIGHT SWEAT -BEYOND- WHITE
27184 Zephyren (ゼファレン) LIGHT WEIGHT SWEAT -REBEL FLAG- GRAY
27220 Zephyren (ゼファレン) HEAVY WEIGHT SWEAT -BEYOND- WHITExBLACK
27226 Zephyren (ゼファレン) HEAVY WEIGHT SWEAT -REBEL FLAG- WHITExBLACK
27618 ANIMALIA AN16A-SW05 Rustic Town WHITE
28312 Hypocrite (ヒポクリット) The Spinal cord Sweat Light WHT
28313 PUNK DRUNKERS I LOVE PD トレーナー WHITE
28317 PUNK DRUNKERS JAPトレーナー WHITE
28896 ROLLING CRADLE LOOSE SWEAT / White
29021 RIP DESIGN WORXX クルースウェットトレーナー ホワイト
29087 ROLLING CRADLE CYCLOPS SHOUT SWEAT / White
29138 SILLENT FROM ME SPELL -Crew Sweat- WHITE
29402 NineMicrophones (ナインマイクロフォンズ) SWEAT -Lightning- WHITE
29683 Hypocrite (ヒポクリット) THE BODYSTREAM ROUNDSWEAT WHITE
29705 SABBAT13 GOOD DIE C/N SWEAT WHITE
29708 SABBAT13 MONSTERS C/N SWEAT WHITE
29886 REBEL8 HIT THE WALLS GREY CREWNECK
30108 MISHKA (ミシカ) EAD END CREWNECK WHITE
31809 SILLENT FROM ME ENCRYPTION -Crew Sweat- WHITE
33962 MISHKA(ミシカ) MSS170414 Sweatshirt WHITE
34598 Subciety (サブサエティ) SWEAT-GLORIOUS- WHITE
34975 SABBAT13 MORTAL SWEAT (ホワイト) WHITE
35470 Zephyren (ゼファレン) PILE SWEAT -BEYOND- WHITE
35481 Zephyren (ゼファレン) SWEAT -PORTAL- WHITE
35793 Zephyren (ゼファレン) CLASHED SWEAT WHITE
36160 PUNK DRUNKERS 四角ロングトレーナー - 黒四角
36161 PUNK DRUNKERS 四角ロングトレーナー - 白四角
36421 MISHKA(ミシカ) MSP160412 SWEAT WHITE
37018 アマツカミ 溺薬 Sweat White
37101 THRASHER TH94130 FLAME MAG LOGO SWEA WHT/WHT
37144 MISHKA(ミシカ) EXWD1005C MISHKA VS LAMOUR SWEAT WHITE
37148 MISHKA(ミシカ) EXWD1004C TOTEM POLE SWEATSHIRT WHITE
37155 MISHKA (ミシカ) EXWD1003C WITH BEAR SWEATSHIRT WHITE
37363 THRASHER TH8401 MAG LOGO SWEAT WHITE
37365 Hi-STANDARD×MISHKA EXWDHS01C BEAR GUY SWEAT WHT
37368 Hi-STANDARD×MISHKA EXWDHS02C SPHINX SWEAT WHT
37372 Hi-STANDARD×MISHKA EXWDHS03C MONSTER SWEAT WHT
37436 MISHKA (ミシカ) MAW170403F
38622 THRASHER TH94206 BAR MAGLOGO SWEAT WHITE
38630 THRASHER TH8401FT MAG FRENCH TERRY CREW SWEAT WHITE
38758 MISHKA (ミシカ) MAW160420 Sweatshit
39051 NineMicrophones DROP SHOULDER SWEATSHIRTS WHITE
39102 SILLENT FROM ME DIVINITY -Crew Sweat- WHITE
39806 MISHKA (ミシカ) MSS180414 SWEAT
39998 MISHKA (ミシカ) MSKBC-1C Sweatshirt White
42937 THRASHER TH94225 Tiger Flame Camo CREW SWEAT WHITE
43311 TOY MACHINE TMF18SW12 TAPE LOGO SWEAT CREW WHITE
43916 PUNK DRUNKERS バランスが大事トレーナー WHITE
44150 アマツカミ 拘束/Restraint Sweat White
44152 アマツカミ Rap※ Me Sweat White
44233 FILA FM9509 MOCK NECK PULLOVER WHITE
44305 SILLENT FROM ME GHOST -Asymmetry Knit Sweater- WHITE
44306 SILLENT FROM ME GHOST -Asymmetry Knit Sweater- BLACK CHIDORI
44307 SILLENT FROM ME GHOST -Asymmetry Knit Sweater- WHITE CHIDORI
44997 FILA FM9540 CREW NECK SHIRT WHITE