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 =393
)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-29 00:21:27')
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
14355 FAMOUS STARS AND STRAPS DESTROYER Mens Snap Fleece
52696 CIVARIZE "Loser" , Coated hoodie
5846 Subciety EMBROIDERY ZIP PARKA Riot Angels
11130 REBEL8 STANDARD ISSUE LOGO ZIP UP HOODIE
11204 ATTILA Death Is Calling Hoodie Black
11208 ENTER SHIKARI Skankers Hoodie Black
11215 LIKE MOTHS TO FLAMES Demon Black Hoodie
11217 MISERY SIGNALS Absent Light Navy Zip-Up Hoodie
11220 WHITECHAPEL Demon Shield Hoodie Black
11267 BLACK CRAFT Tarot Zip Up Hoodie
12610 LUCKY13 BLACK CAT FULL ZIP Hoodey
13324 MISHKA (ミシカ) CREEPING DEATH SPLIT ZIP HOODIE BLACK
13515 RUDIE'S ENOUGH ZIPHOOD SW BLACK
13727 NineMicrophones PATCHWORK ZIP PARKA -FIGHT-BLK/WHT
13728 NineMicrophones PATCHWORK ZIP PARKA -FIGHT-BLK/BGN
13736 NineMicrophones ZIP PARKA -9MC Crew- BLK/BGN
13739 NineMicrophones ZIP PARKA -9MC Crew- BLK/WHT
13945 Subciety ZIP PARKA-WELL MADE-BLACK/WHITE
14130 Subciety PATTERNED ZIP PARKA-GLORIOUS- BLK/MUS
14154 REBEL8 ANY MEANS BLACK ZIP-UP HOODIE
14236 Subciety EMBROIDERY ZIP PARKA BLACK/TRIBE CROSS
14311 PUNK DRUNKERS 【PDSxキン肉マン】 ヘルミッショネルズパーカ BLK
14579 SO SO HAPPY SIQ Hoodie In Pink and Black
14642 Subciety TRIBAL ZIP PARKA BLACK
14703 RUDIE'S TUSK ZIPHOOD SW BLACK/RED
14773 MISHKA (ミシカ) ELEVATED REALM ZIP UP HOODIE
14843 MISHKA (ミシカ) AUTOPS DEATH ZIP UP HOODIE
15086 REBEL8 EIGHTERS ZIP-UP HOODIE
15111 NineMicrophones 9MC SK8 PATTERNED ZIP PARKA BLK
15231 ZEPHYREN (ゼファレン) ZIP PARKA -SKULL HEAD- BLK
15232 ZEPHYREN (ゼファレン) ZIP PARKA -Skull head- BLK×BGN
15293 REBEL8 WOMENS BANDANA 8 ZIP-UP HOODIE
15330 YELLOWCARD Logo Black Charcoal - Two-Tone Zip-Up
15345 WHITECHAPEL Tetanus Black Zip-Up Sweatshirt
15349 WHITECHAPEL Freedom Black - Zip-Up Sweatshirt
15361 KILL STAR CLOTHING OCCULT HOODIE [B]
15371 FINCH Linear Black Zip-Up Sweatshirt
15403 MEMPHIS MAY FIRE Ordinary Love Black Zip-Up Sweats
15420 DEADHEARTZ ILLUMINATI ZIP UP /BLACK
15452 MOTIONLESS IN WHITE Dracula Black Hooded Zip Up
15463 MOTIONLESS IN WHITE Raven Black
15480 ATTILA FTW Black
15516 WE CAME AS ROMANS Hope Black Zip-Up Sweatshirt
15536 MAYDAY PARADE Umbrellas Black
15560 FAR★STAR 六芒星 パーカー WHT
15569 FAR★STAR 目苺パーカー
15645 ZEPHYREN (ゼファレン) ZIP PARKA -Determination- BLK
15786 NineMicrophones ZIP PARKA-King Of The Road- BLK/RE
15792 NineMicrophones ZIP PARKA-King Of The Road- BLK/WH
15959 KILL STAR CLOTHING ZODIAC ZIP HOODIE [B]
16504 Subciety ZIP PARKA-LARGE GLORIOUS- BLACK
16687 Subciety ZIP PARKA-PATTERNED ALL OVER- SOUNDSYSTEM
16691 NineMicrophones ZIP PARKA-NINE BONES- BLK
16840 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- BLACK
16841 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- BLK/BGN
17420 MISHKA (ミシカ) RAINBOW KEEP WATCH FULL ZIP HOODIE
17599 ZEPHYREN (ゼファレン) ZIP PARKA -Never Despair- BLK×BGN
18002 FAR★STAR チェーンスター ZIPパーカー
18004 FAR★STAR 六Bone星 パーカー
18412 Subciety ZIP PARKA-NX- - BLACK
18728 NineMicrophones ZIP PARKA -Comrade- - BLACK
19000 WHITECHAPEL Our Endless War Black
19370 ZEPHYREN (ゼファレン) TIE DYE TRIBAL ZIP PARKA -Resolve - BLACK
19380 ZEPHYREN (ゼファレン) SUBLIMATION PARKA - BLK PAISLEY
19400 Zephyren (ゼファレン) EMBROIDERY PARKA L/S - BLK/Charmed SQ Tone
19508 Zephyren ZIP PARKA -EMBLEM - BLACK×BLACK
19874 WE CAME AS ROMANS Wolf Black ZIP Hoodie
20037 ZEPHYREN (ゼファレン) ZIP PARKA -Never Despair- BLACK
20114 KILL STAR CLOTHING RA ZIP HOODIE [B]
20118 KILL STAR CLOTHING CREEP KNIT SWEATER [B]
20345 REBEL8 COVER THE 8 ZIP HOODIE
20718 Subciety PARKA-PAISLEY GLORIOUS- BLACK
20728 Subciety (サブサエティ) ZIP PARKA-Praha- BLACK
21170 SILLENT FROM ME SQUARE -Ziphood- BLACK
21231 ROLLING CRADLE RLCR-PATCH ZIP HOODIE / Black
21311 SILLENT FROM ME FU-Ziphood- Black
21448 RIP DESIGN WORXX SCREAMジップアップパーカー
21450 RIP DESIGN WORXX Number69 ジップアップパーカー BLACK
21505 RUDIE'S MOSH ZOMBIES ZIPHOOD SW BLACK
21507 RUDIE'S PRICKLE HOOD SW BLACK
21548 LILWHITE. 1st ANIV Zip Hoodie
21556 DEADHEARTZ "BLOOD"ZIPUP HOODIE BLACK
21558 DEADHEARTZ "BLOOD"ZIPUP HOODIE BLOOD
21755 ICECREAM DRIP ZIPUP HOODY BLACK/RED
21929 SQUARE PAISLEY POCKET HOODY BLACK
22005 SQUARE GUN PATTERN ZIPUP HOODY BLK
22045 REBEL8 UNTIL DEATH ZIP-UP HOODIE
22088 REBEL8 TOP GUNNER ZIP-UP HOODIE
22161 FAMOUS STARS AND STRAPS Misfits Full Zip Hoodie
22176 SILLENT FROM ME DIVISION -Pullover- BLK
22179 KILL STAR CLOTHING Azrael Zip Hoodie
22390 FAR★STAR 惡の華XFAR★STAR パーカー2
22429 KILL STAR CLOTHING(キルスター・クロージング) IDOL BATWING VELVET HOODIE
22430 KILL STAR CLOTHING (キルスター・クロージング) Goth Batwing Velvet Hoodie
22484 DROP DEAD CLOTHING (ドロップデッド・クロージング) Lit Up Hoodie
22510 SABBAT13 ARCH ZIP-PARKA (BK)
22532 DEADHEARTZ X SILLENT FROM ME ZIP HOODIE BLACK
22568 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- BLACK x PAISLEY
22570 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- BLACK x CHECK
22647 Zephyren (ゼファレン) CROSS PAISLEY ZIP PARKA BLACK x WHITE
22653 Zephyren (ゼファレン) ZIP PARKA -PROVIDENCE- BLACK
22687 RIP DESIGN WORXX ピザジップアップパーカーブラック
22689 RIP DESIGN WORXX ロゴジップアップパーカーブラック
22744 Zephyren (ゼファレン) ZIP PARKA -PROVIDENCE- BLACK x WHITE
22870 RUDIE'S SKULL ZIPHOODSW
22887 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLACK/WHITE
22888 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLACK/BURGUNDY
23276 REBEL8 LOGO COLLAGE ZIP-UP CHARCOAL HOODIE
23369 DEADHEARTZ D ZIP HOODIE /BLACK
23656 FAR★STAR ラインチェーンスター 2016 限定版パーカー
23657 FAR★STAR Sperm パーカー
23807 SILLENT FROM ME RITUAL-Ziphood- BLACK
23980 ANIMALIA AN16U-SW01 ZIP UP HOODIE-Slashed #001 BLACK
24152 グッドモーニングアメリカ 時計パーカー(ブラック)
24252 SpecialThanks missaパーカー
24378 SILLENT FROM ME BRAIN-Hood Shirts- BLK
24488 RIP DESIGN WORXX STRAIGHT EDGEロゴジップパーカーブラック
24715 Zephyren (ゼファレン) SWITCHING NOSLEEVE LONG PARKA -Resolve- BLACK x PAISLEY
24717 Zephyren (ゼファレン) SWITCHING NOSLEEVE LONG PARKA -Resolve- BLACK x CHECK
25146 WE CAME AS ROMANS Totem Black - Zip Up