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 dtb_products AS p
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 00:20:19')
AND pc.price02 > 2727
AND price02 <= 4545
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 240
71162 GALFY(ガルフィー) 普通にGALFYニットCAP BLACK
71199 GALFY (ガルフィー) 普通にGALFYサンダル BLACK
71201 GALFY (ガルフィー) 犬激寄サンダル BLACK
35489 RUDIE'S (ルーディーズ) SPARK-Tee BLK/WHT
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
24329 RUDIE'S DRAWING-T BLACK
37316 RUDIE'S HEAD GEAR SPARK MESH CAP
3211 RUDIE'S SPARK MESH CAP BLACK/BLACK/WHITE
67469 RUDIE'S (ルーディーズ) SHADOW LOGO SAKOSSHU
68453 RUDIE'S (ルーディーズ) PHAT POUCH BLACK
71423 Subciety (サブサエティ) CREST TANK TOP BLACK
69232 パラッパラッパー ワンポイントロゴ刺繍ニットCAP BLACK
71493 AVRIL LAVIGNE UNISEX T-SHIRT: LOVE SUX BALLOONS
71494 AVRIL LAVIGNE UNISEX T-SHIRT: LOVE SUX (BACK PRINT)
71495 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: WOLFMAN
71496 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: DETROIT (BACK PRINT)
71497 BAD OMENS UNISEX T-SHIRT: SUNFLOWER
69765 BAD OMENS UNISEX T-SHIRT: TAKE ME
71498 DEFTONES UNISEX T-SHIRT: SPHYNX
71499 DEFTONES UNISEX T-SHIRT: STATIC SKULL (BACK PRINT)
71500 DEFTONES UNISEX T-SHIRT: STAR & PONY
71501 MOTIONLESS IN WHITE UNISEX T-SHIRT: SPLIT SCREEN
71502 MOTIONLESS IN WHITE UNISEX T-SHIRT: GRAVEYARD SHIFT
71503 NINE INCH NAILS UNISEX T-SHIRT: DOWNWARD SPIRAL (BACK PRINT)
71504 NINE INCH NAILS UNISEX T-SHIRT: HEAD LIKE A HOLE
71505 SYSTEM OF A DOWN UNISEX T-SHIRT: DOVE OVERCOME
69445 BRING ME THE HORIZON UNISEX T-SHIRT: GREEN NEX GEN
69443 BRING ME THE HORIZON UNISEX T-SHIRT: NEX GEN COVER
69444 BRING ME THE HORIZON UNISEX T-SHIRT: DISTRESSED NEX GEN
67935 BRING ME THE HORIZON UNISEX T-SHIRT: SPRAY HEX
69354 BRING ME THE HORIZON UNISEX T-SHIRT: FLAMING HEX BLACK
67940 BRING ME THE HORIZON UNISEX T-SHIRT: WARRIOR
70554 BRING ME THE HORIZON UNISEX T-SHIRT: WHY...?
69441 BRING ME THE HORIZON UNISEX T-SHIRT: LOST (BACK PRINT)
69442 BRING ME THE HORIZON UNISEX T-SHIRT: ALL HAIL (BACK PRINT)
43345 BRING ME THE HORIZON Sempiternal TEE
71313 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 FACES
71250 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 POSTER (EX-TOUR)
71249 MÅNESKIN UNISEX T-SHIRT: TEATRO D'IRA DOODLES (BACK PRINT & EX-TOUR)
71314 MÅNESKIN UNISEX TANK T-SHIRT: GAY FOR MANESKIN
71316 MÅNESKIN UNISEX MESH BACK CAP: LOUD KIDS ON TOUR
70819 POLYPHIA UNISEX T-SHIRT: RITUAL
70820 POLYPHIA UNISEX T-SHIRT: SKULL CIRCLE P
70818 POLYPHIA UNISEX T-SHIRT: CHERUB
71431 SKINDRED UNISEX T-SHIRT: RASTA LOGO
71430 SKINDRED UNISEX T-SHIRT: LOUD MUSIC
68833 SLIPKNOT UNISEX T-SHIRT: ZOMBIE (BACK PRINT)
51199 SLIPKNOT UNISEX TEE: WANYK LOGO (BACK PRINT)
35296 SLIPKNOT UNISEX T-SHIRT: .5: THE GRAY CHAPTER (BACK PRINT)
35289 SLIPKNOT UNISEX T-SHIRT: BAND FRAME
68837 SLIPKNOT UNISEX T-SHIRT: 20TH ANNIVERSARY TATTERED & TORN (BACK PRINT)
68835 SLIPKNOT UNISEX T-SHIRT: DEVIL SINGLE - LOGO BLUR (BACK PRINT)
68580 SLIPKNOT UNISEX T-SHIRT: ALIEN (BACK PRINT)
68581 SLIPKNOT UNISEX T-SHIRT: SKELETON & PENTAGRAM (BACK PRINT)
35502 SLIPKNOT Blocks T-Shirt
51191 SLIPKNOT TURNTABLE SLIPMAT SET: THE GRAY CHAPTER
67957 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY BLACK
68577 LINKIN PARK UNISEX T-SHIRT: LIVING THINGS ALBUM
70686 LINKIN PARK UNISEX T-SHIRT: SHIFT
70685 LINKIN PARK UNISEX T-SHIRT: METEORA PORTRAITS
68575 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO BLACK
66944 KORN UNISEX T-SHIRT: BLOCKS
52907 KORN UNISEX TEE: DEATH DREAM
67955 KORN UNISEX T-SHIRT: BLOCK PHOTO
68574 KORN UNISEX HI-BUILD T-SHIRT: LOGO
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
60191 MARILYN MANSON UNISEX T-SHIRT: WE ARE CHAOS (BACK PRINT)
67965 MARILYN MANSON UNISEX T-SHIRT: AMERICAN FAMILY (BACK PRINT)
28592 MARILYN MANSON CROWN T-Shirts
35642 MARILYN MANSON RED LIPS T-SHIRTS
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
37810 BULLET FOR MY VALENTINE Logo T-shirt Black
70279 BULLET FOR MY VALENTINE UNISEX T-SHIRT: FLORAL OMEN
70278 BULLET FOR MY VALENTINE UNISEX T-SHIRT: THRASH SKULL
59257 NINE INCH NAILS Unisex Tee: Classic Logo
8372 FALLING IN REVERSE Lips T-Shirt BLACK
55729 OASIS UNISEX TEE: DECCA LOGO BLACK
69157 METALLICA UNISEX T-SHIRT: AND JUSTICE FOR ALL TRACKS (BACK PRINT)
10233 METALLICA DORIS T-Shirt
700 METALLICA-KILL EM ALL
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
10235 METALLICA VINTAGE METAL UP T-Shirt
585 RED HOT CHILI PEPPERS Asterisk Logo Black
70938 RED HOT CHILI PEPPERS UNISEX HI-BUILD T-SHIRT: CLASSIC ASTERISK LOGO
60192 RED HOT CHILI PEPPERS UNISEX T-SHIRT: GETAWAY ALBUM ASTERISK
67504 RED HOT CHILI PEPPERS UNISEX T-SHIRT: BLACK & WHITE LOGO
70950 RED HOT CHILI PEPPERS UNISEX T-SHIRT: RED CIRCLE ASTERISK (ECO-FRIENDLY)
67962 MY CHEMICAL ROMANCE UNISEX T-SHIRT: MARCH
60189 MY CHEMICAL ROMANCE MY CHEMICAL ROMANCE UNISEX T-SHIRT: THE BLACK PARADE COVER
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
68578 MY CHEMICAL ROMANCE UNISEX T-SHIRT: SPIDER
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
70948 SUM41 UNISEX T-SHIRT: AKNF SKELETON EUROPEAN TOUR 2022 (BACK PRINT & EX-TOUR)
70561 SUM41 UNISEX T-SHIRT: DOES THIS LOOK LIKE ALL KILLER NO FILLER EUROPEAN TOUR 20
67506 SUM41 UNISEX T-SHIRT: GRINNING SKULL
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
70936 BLINK-182 UNISEX T-SHIRT: BIG SMILE
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
51426 GREEN DAY Unisex Tee: Hypno 4
10258 GUNS N' ROSES CROSS T-Shirt
36663 GUNS N' ROSES BULLET LOGO
35620 GUNS N' ROSES BIG GUNS T-SHIRTS
59255 NIRVANA Unisex Tee:White Happy Face
4598 NIRVANA Happy Face T-Shirt
4599 NIRVANA MANY Happy Face T-Shirt
67967 NIRVANA UNISEX T-SHIRT: SORBET RAY Happy Face
67968 NIRVANA UNISEX T-SHIRT: NEVERMIND ALBUM
59258 Kurt Cobain Unisex Tee: Coloured Side View
59264 Ed Sheeran Unisex Tee: Dashed Stage Photo
59265 Ed Sheeran Unisex Tee: Chords
59266 Ed Sheeran Unisex Tee: Divide
67954 FALL OUT BOY UNISEX T-SHIRT: POISONED YOUTH
67953 FALL OUT BOY UNISEX T-SHIRT: TAKE THIS TO YOUR GRAVE
64308 RIPNDIP (リップンディップ) Lord Nermal Ribbed Beanie (Black)
69913 PUNK DRUNKERS(パンクドランカーズ) あみだボクサーパンツ - BLACK
71304 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE BK/BLU
70946 SLEEP TOKEN UNISEX T-SHIRT: EUCLID
70947 SLEEP TOKEN UNISEX T-SHIRT: THE LOVE YOU WANT SKELETON
69895 PUNK DRUNKERS(パンクドランカーズ) ですメタルTEE - SUMI
68516 over print (オーバープリント) ZERO NYLON CAP BLACK
70801 AIKA ELECTRONICS(アイカエレクトロニクス) Fur cap Galaxy【BLACK】
70803 AIKA ELECTRONICS(アイカエレクトロニクス) Fur cap Future【BLACK】
70718 Survive Said The Prophet SHAPES L/S TEE
70716 Survive Said The Prophet OMEN TEE
70714 Survive Said The Prophet MAKE / BREAK TEE (BLACK)
70722 Survive Said The Prophet UNIVERSE BUCKET HAT
70719 Survive Said The Prophet CIRCLE BUCKET HAT BLACK
67781 TRAVAS TOKYO【トラバストーキョー】 Loose leg warmer BLACK×WHITE
68785 美園 礼音 × LONELY論理 コラボ限定ソックス
68793 界川 深幸×CMP LABEL コラボ限定トートバッグ
69453 PUNK DRUNKERS (パンクドランカーズ) ひとりぼっちニットCAP
70623 DXMOUVE (ドゥモーヴェ) リングZIP付パーカー
70520 DXMOUVE(ドゥモーヴェ) 変形フラップ付きワイドパンツ
69310 高木美佑×DI:VISION×GEKIROCK CLOTHINGスペシャル・コラボ・ソックス
69945 ROLLING CRADLE (ローリングクレイドル) HEART CRADLE CAP CHARCOAL
60857 TRAVAS TOKYO【トラバストーキョー】Frill spare collar Black
35589 BRING ME THE HORIZON The H T-Shirts
69487 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) ニット帽 BLACKxWHITE
69990 SABBAT13(サバトサーティーン) SPOOK KNIT CAP BLACK
69056 CMP LABEL (シーエムピーレーベル) 曼荼羅 oversized T-shirt
69473 LOVE KILLER(ラブキラー) killer border muffler ブラック
69162 MOTLEY CRUE UNISEX T-SHIRT: TOO FAST CYCLE
69163 MOTLEY CRUE UNISEX T-SHIRT: FEELGOOD HOLLYWOOD REVISION
69164 MOTLEY CRUE UNISEX T-SHIRT: THEATRE OF PAIN CRY
69165 MOTLEY CRUE UNISEX T-SHIRT: BAD BOYS SHIELD
69158 DEF LEPPARD UNISEX T-SHIRT: CLASSIC TRIANGLE
69159 DEF LEPPARD UNISEX T-SHIRT: TRIANGLE LOGO
69160 DEF LEPPARD UNISEX T-SHIRT: SHATTER
62578 METALLICA FADE TO BLACK WALLET
62598 MY CHEMICAL ROMANCE PARADE TRAVEL BAG
62599 MY CHEMICAL ROMANCE PARADE WALLET
69065 Dogmatic Gourmet x over print x RIP DESIGN WORXX ラーメンガールTシャツ BLACK
69108 PUNK DRUNKERS(パンクドランカーズ)サンドウィッチTEE'23 / REVIVAL BLACK
69113 PUNK DRUNKERS(パンクドランカーズ)ABCDTEE'23 / REVIVAL BLACK
69103 PUNK DRUNKERS(パンクドランカーズ)美少女TEE'23 / REVIVAL BLACK
68741 Gluttonous Slaughter(グラトナススローター) The Monster Slayer Cat T-shirt BLACK
68884 DI:VISION (ディヴィジョン) 666 CAP BLKxGRN
68902 FACT101(ファクト・イチマルイチ) 『殺戮バニーガール』 Tシャツ BLACK
68907 FACT101(ファクト・イチマルイチ) 『track!』 Tシャツ BLACK
68908 FACT101(ファクト・イチマルイチ) 『妖』 Tシャツ BLACK
68895 FACT101(ファクト・イチマルイチ) 「恐竜生活」Tシャツ BLACK
68890 FACT101(ファクト・イチマルイチ) 『Peace』 Tシャツ BLACK
67665 PUNK DRUNKERS(パンクドランカーズ)アイツ大佐TEE - SUMI
67654 PUNK DRUNKERS(パンクドランカーズ)アニメ少女TEE - BLACK
58322 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT BLACK
54042 THRASHER (スラッシャー) FLAME LOGO S/S TEE BLACK
4449 THRASHER (スラッシャー) TH8101 Mag LogoTee BK/WH
68545 THRASHER (スラッシャー) Gonz Thumbs Up S/S T-SHIRTS BLACK
68543 THRASHER (スラッシャー) Devils Music S/S T-SHIRTS BLACK
27392 THRASHER 16TH-C25 WASH CAP BLACK
68570 IRON MAIDEN UNISEX T-SHIRT: PIECE OF MIND MULTI HEAD EDDIE
68572 IRON MAIDEN UNISEX T-SHIRT: THE FUTURE PAST TOUR '23 GREYSCALE
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
68609 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) DORODORO MxMxM DRY TEE BLACK
68606 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH GRADATION TEE COLD
68607 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH GRADATION TEE YELLOW
68361 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MY PIZZA CAP Black
68482 over print (オーバープリント) Visor BLACK
68224 DXMOUVE(ドゥモーヴェ) 臓器看板柄カシュクールチャイナトップス MIX
68225 DXMOUVE(ドゥモーヴェ) 臓器看板柄カシュクールチャイナトップス PINK
68742 Gluttonous Slaughter(グラトナススローター) Ghoulish Harvest ビッグシルエットTシャツ BLACKxGRAY
68744 Gluttonous Slaughter(グラトナススローター) Feast of the Unbirthed T-shirt BLACK
68563 ANIMALIA (アニマリア) Polygiene DRY SHORTS BLACK
67931 BLUR UNISEX T-SHIRT: CIRCLE LOGO
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
35655 PANTERA Red Vulgar T-Shirts
12067 PANTERA HOSTILE SKULL T-Shirt
66967 MEGADETH UNISEX T-SHIRT: KILLING IS MY BUSINESS (BACK PRINT)
66968 MEGADETH UNISEX T-SHIRT: PEACE SELLS… TRACK LIST (BACK PRINT)
66966 MEGADETH UNISEX T-SHIRT: RUST IN PEACE 30TH ANNIVERSARY (BACK PRINT)
37586 MEGADETH -Dystopia-Black t-shirt
36681 MEGADETH MEGADETH YAMAHA DRUMS
66941 BAD RELIGION UNISEX T-SHIRT: BURNING BLACK
37811 ALL TIME LOW UNISEX TEE: SCRATCH
68584 SYSTEM OF A DOWN UNISEX T-SHIRT: TOXICITY
68586 SYSTEM OF A DOWN UNISEX T-SHIRT: BANNER MARCHES
53874 MY CHEMICAL ROMANCE COFFIN T-Shirts
68212 LOVE KILLER(ラブキラー) KILLER HAND WARMER BLACK×WHITE
68210 LOVE KILLER(ラブキラー) KILLER HAND WARMER BLACK
68079 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / BLACK
68403 MISHKA (ミシカ) DEEP DRIP KEEP WATCH TRUCKER CAP
63233 TOY MACHINE (トイマシーン) AXEL SS TEE - BLACK
63238 DXMOUVE(ドゥモーヴェ) ストレンジトイ切替半袖プルオーバー カラフル
68158 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH CAMOFITS TEE WHITE
68159 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH CAMOFITS TEE YELLOW
67976 YUNGBLUD UNISEX T-SHIRT: WEIRD FLAMING SKELETONS (BACK PRINT)
67941 EVANESCENCE UNISEX T-SHIRT: SYNTHESIS
35292 SLIPKNOT PAUL GRAY
51190 SLIPKNOT UNISEX FINGERLESS GLOVES: LOGO
66484 MAGICAL MOSH MISFITS ネズミニット帽 BLACK
66259 ANIMALIA (アニマリア) ROLL UP BEANIE BLACK
58357 KILL STAR CLOTHING Lock Me Up Choker
65275 HAGANE×GEKIROCK CLOTHING×HYPER CORE DRAGON CAP
65690 CAPRICE (カプリース) LOGO LS Tee BLACK
62930 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO KNIT CAP - BLACK
62849 PSYCHOLOGICAL METAMORPHOSIS COLLEGE WIDE TEE - BLACK
65272 kirou school (キロウスクール) krs_012 cheat S/S T-shirts BLACK
65146 ANIMALIA VELCRO WALLET - SKUNK SCOUT
64936 kirou school (キロウスクール) krs_011 counter logo S/S T-shirts BLACK
64894 kirou school (キロウスクール) krs_09 "GSD" T-shirts BLACK
64859 Wall Of Graphic(ウォールオブグラフィック)WG2 Tシャツ ブラック
64854 Wall Of Graphic(ウォールオブグラフィック)Ash2 Tシャツ
64207 kirou school (キロウスクール) krs_07 club logo S/S T-shirts BLACK
64211 kirou school (キロウスクール) krs_08 JUST SLEEP S/S T-shirts BLACK
63877 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) まもみずし CAP マグロ
63878 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) まもみずし CAP ドクロ
64093 Meltyglow (メルティグロウ) 刺繍入り配色LOGO CAP【ORANGE×BLACK】
63699 AFFECTER (アフェクター) AFE COLLEGE LOGO L/S Tee Black
64075 AFFECTER (アフェクター) TAG Tee BLACK
64078 AFFECTER (アフェクター) COLLEGE LOGO CAP BLACK
63820 BAD BOY (バッドボーイ) TEAM LOGO EMBROIDERY TEE BLACK
63825 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY TEE BLACK
63193 ANIMALIA (アニマリア) HOODIE Tee S/S - logo BLACK