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 03:07:15')
AND FIND_IN_SET(1, 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
70021 glamb (グラム) Monogram Hooded Jersey / モノグラムフーデッドジャージ Black
70555 BRING ME THE HORIZON UNISEX ZIPPED HOODIE: BLUE CROW WINGS (BACK PRINT)
26134 BRING ME THE HORIZON Sickle Zip Hoodie
70687 PSYCHO NATION(サイコネーション) ボーンアップリケジップパーカー
70824 Subciety(サブサエティ)WAFFLE ZIP PARKA BLACK
70663 SLEEPING TABLET (スリーピングタブレット) FORMULA [ HEAVY WEIGHT ZIPHOOD ] BLACK
29130 RUDIE'S (ルーディーズ) SPARK ZIPHOOD SWEAT BLACK/WHITE
70788 SCENE TOKYO (シーントウキョウ)PPL girl zip hoodie black
70781 gibous (ギボス) snakecross hood fur parker
68775 旭 那由多×RUDIE'S 限定コラボ・ジップアップパーカー
70560 SUM 41 UNISEX ZIPPED HOODIE: STAR LOGO (BACK PRINT, EX-TOUR)
70149 FACT101 (ファクトイチマルイチ) 『Yop』 パーカー
70060 Risky Melody×RIP DESIGN WORXX×GEKIROCK CLOTHING コラボ・ジップパーカー
69174 glamb (グラム) GB0323/CS06 : Nylon Switch Hoodie / ナイロンスイッチフーディ Black
70071 NineMicrophones(ナインマイクロフォンズ) ZIP PARKA-Pray with the microphone- BLACK
69982 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH GRADATION ZIP HOODIE DOKU
69486 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM ZIP HOODIE NAVY
69490 Subciety (サブサエティ) EMBROIDERY MARIA ZIP PARKA BLACK
69247 Subciety (サブサエティ) CREST ZIP PARKA BLACK
68647 PUNK DRUNKERS(パンクドランカーズ)反区怒商店BIG.ZIPパーカ - BLACK
69511 AILE VIVANTES(エイルヴィヴァンテス) -赫灼-FULL ZIP HOODIE Tie Dye
69510 AILE VIVANTES(エイルヴィヴァンテス) -赫灼-FULL ZIP HOODIE BLACK
67391 TheBackOfBoys(ザバックオブボーイズ) Cute Girl Zip Hoodie Type1BLACK
67393 TheBackOfBoys(ザバックオブボーイズ) Cute Girl Zip Hoodie Type2 BLACK
65306 白鳥 胡桃×HEDWiNG コラボ 限定 ジップパーカー
53187 BLINK-182 UNISEX ZIPPED HOODIE: DOUBLE SIX ARROW SMILEY (BACK PRINT)
67744 DI:VISION (ディヴィジョン) SHED ZIP HOODIE BLACK
67791 MISHKA (ミシカ) INFINITE PAIN ZIP-UP HOODIE MIDZH-01 BLACK
66811 真っ白なキャンバス×GEKIROCK CLOTHING×over print PURE WHITE CANVAS Zip Hoodie BLACK
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61271 Zephyren 2022 NEW YEAR BAG
65936 TOY MACHINE (トイマシーン) BLOOD SUCKING DUCK PARKA-BLACK
65558 over print (オーバープリント) DSP-BOT Zip Hoodie (black)
64366 ADAM at×GEKIROCK CLOTHING×GoneR Collaboration Zip Hoodie
62568 Gluttonous Slaughter The Golden Brutal Baphomet Zip-up Hoodie / 黄金のバフォメット
61745 RIP DESIGN WORXX ハイドジップパーカー BLACK
61258 神使轟く、激情の如く。× GEKIROCK CLOTHING 第2弾限定コラボ・パーカー
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
52485 【バンドリ!×ゲキクロ 第4弾復刻】PSYCHOLOGICAL METAMORPHOSIS×大和 麻弥 コラボ 限定 パーカー
60800 HAGANE×GEKIROCK CLOTHING×KAVANE Clothing スペシャル・コラボ・ジップパーカー
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
55879 GoneR GR26ZP001 Rose Photo Zip Parka Black
59433 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - BLACK
59543 Zephyren(ゼファレン) PAISLEY PARKA BLACK
60730 LONELY論理 バキ×LONELY論理 "BAKI" ZIP HOODIE
59167 VIRGO MEXICAN VG HOODIE BLACK
59245 ANIMALIA AN21U-SW01 S/S ZIP-UP HOODIE BLACK
58636 CIVARIZE コーティング加工レースアップデザインロングパーカー
57354 SUPPLIER (サプライヤー) TINPLATE ZIP HOODIE PURPLE
57355 SUPPLIER (サプライヤー) TINPLATE ZIP HOODIE BLUE
52575 MARILYN MANSON UNISEX ZIPPED HOODIE: CROSS LOGO (EX TOUR/BACK PRINT)
56760 AC/DC LADIES ZIPPED HOODIE: LOGO (BACK PRINT)
55107 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - BLACK
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
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
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
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