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-30 19:32:58')
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 12,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 180
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(サイコネーション) ボーンアップリケジップパーカー
70289 Subciety(サブサエティ)PROVIDENCE ZIP PARKA BLACK
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 限定コラボ・ジップアップパーカー
70432 GALFY (ガルフィー) B-Boy的ストリートピグメント染パーカー BLACK
70560 SUM 41 UNISEX ZIPPED HOODIE: STAR LOGO (BACK PRINT, EX-TOUR)
70149 FACT101 (ファクトイチマルイチ) 『Yop』 パーカー
69032 GALFY (ガルフィー) 染め染めわんちゃんボロボロパーカー INK BLACK
69630 GALFY (ガルフィー) チーマーパーカー BLACK
69052 GALFY (ガルフィー) ガルドッグスジップパーカー BLACK
69639 GALFY (ガルフィー) 染め染めデスメタルにゃんにゃんパーカー INK BLACK
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
69728 Subciety (サブサエティ) CORDUROY ZIP HOODY BLACK
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
68336 倉知玲鳳×NOT COMMON SENSE×GEKIROCK CLOTHINGスペシャル・コラボ・ジップアップパーカー
65306 白鳥 胡桃×HEDWiNG コラボ 限定 ジップパーカー
67561 GALFY (ガルフィー) ピカピカ注射器 SETUP 夏 BLACK
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
67456 RUDIE'S(ルーディーズ) SHADOW LOGO ZIP PARKA BLACK
66811 真っ白なキャンバス×GEKIROCK CLOTHING×over print PURE WHITE CANVAS Zip Hoodie BLACK
66790 LONELY論理 天上天下論理独尊 ZIP HOODIE BLACK
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61271 Zephyren 2022 NEW YEAR BAG
65745 GALFY (ガルフィー) ピカピカ注射器 SET UP BLACK
66459 NineMicrophones (ナインマイクロフォンズ) ZIP PARKA-9MC Loco- BLACK
63929 VIRGO(ヴァルゴ)MILSPEC LOOSE HOODIE BLACK-BLACK
65734 GALFY (ガルフィー) 久々賛否両論 SET UP オーロラ BLACK
65236 GALFY (ガルフィー) いにしえチンピラSET UP-BLACK
65936 TOY MACHINE (トイマシーン) BLOOD SUCKING DUCK PARKA-BLACK
65906 over print(オーバープリント) Melodic Zip Hoodie (black)
65215 GALFY (ガルフィー) 三代目卍 SET UP-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 コーティング加工レースアップデザインロングパーカー
57034 VIRGO Upright zip swt BLACK
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)
56129 アマツカミ 髑髏/Skull Hoodie
55107 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - BLACK
54589 アマツカミ 棘薔薇/Rose Needle Hoodie Black
54181 Subcietyx攻殻機動隊SAC_2045 ZIP PARKA-GHOST HACK- BLACK
5846 Subciety EMBROIDERY ZIP PARKA Riot Angels
11130 REBEL8 STANDARD ISSUE LOGO ZIP UP HOODIE
11204 ATTILA Death Is Calling Hoodie Black
11215 LIKE MOTHS TO FLAMES Demon Black 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
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
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
23807 SILLENT FROM ME RITUAL-Ziphood- BLACK
23980 ANIMALIA AN16U-SW01 ZIP UP HOODIE-Slashed #001 BLACK
24152 グッドモーニングアメリカ 時計パーカー(ブラック)
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