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 11:16:26')
AND pc.price02 > 2727
AND price02 <= 4545
AND FIND_IN_SET(7, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
70950 RED HOT CHILI PEPPERS UNISEX T-SHIRT: RED CIRCLE ASTERISK (ECO-FRIENDLY)
70525 DXMOUVE(ドゥモーヴェ) グラデーションボーダーダメージニット RED
69679 TOY MACHINE (トイマシーン) TOYMONSTER PUPPET DOLL KEYHOLDER RED
65778 アマツカミ 悲嘆/grief Hoodie
69106 PUNK DRUNKERS(パンクドランカーズ)NEKOCATS.TEE'23 / REVIVAL BURGUNDY
68883 DI:VISION (ディヴィジョン) 666 CAP BLKxRED
67664 PUNK DRUNKERS(パンクドランカーズ)アイツ大佐TEE - RED
69086 ROLLING CRADLE (ローリングクレイドル) Re:STEP TEE / RED
68805 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT BURGUNDY/WHITE
68804 THRASHER TH91130 FLAME MAG LOGO TEE BURGUNDY
28395 THRASHER (スラッシャー) TH8101 MAG LOGO TEE BURGUNDY
53184 ALL TIME LOW UNISEX TEE: DA BOMB
68432 NieR (ニーア) HALF SLEEVE CUTSEW BLACKxRED
67977 YUNGBLUD UNISEX T-SHIRT: R-U-OK?
67498 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Wine red
60167 MISHKA X DENNIS THE MENACE TROUBLE MAKER HOODIE RED
66222 over print(オーバープリント) punk knit beanie red
62669 PUNK DRUNKERS (パンクドランカーズ) タイダイきのこTEE - RED
65827 NieR (ニーア) 2WAY OFF-Shoulder 長袖ZIP PARKA【彼岸花 】
65369 NieR (ニーア) 超BIG SILHOUETTE RED CUTSEW 【NieR TAIL】
64980 over print(オーバープリント) hair band red
48502 【PDS×まあたそ×ゲキクロ】まあたそとあいつボクサーパンツ WHITE
62200 Zephyren(ゼファレン) CHECK SHIRT S/S - Resolve - BURGUNDY
61727 TRAVAS TOKYO【トラバストーキョー】切り替え総柄バイカラーパーカー マルチカラー
60471 NieR (ニーア) RED ROSE ZIP PARKA
61865 glamb (グラム) Fake Layered Border CS - Red×Navy
61484 glamb (グラム) Cactus Print Raglan CS WINE
61543 ZERO EVOKE Logo Second PARKA RED
61608 HYPER CORE ピザイアニーハイ
59203 VIRGO DEFOLIATION GLOVES BLU×RED
59523 Zephyren(ゼファレン) DOLMAN BIG PARKA RED / Reverie
59536 Zephyren(ゼファレン) BIG SHIRT L/S DRAGONFLY
60526 MAGICAL MOSH MISFITS MxMxM HOODIE RED
60503 Subciety (サブサエティ) SEA OTTER PARKA BURGUNDY
60360 RUDIE'S SLICK HAIRBAND RED
58996 NineMicrophones SWEAT-FULLERTON- BURGUNDY
60230 NieR (ニーア) 変型RED LEGGINGS PANTS
58727 VIRGO VGW ALOHA SHIRTS RED
59297 GoneR GR29CTW001 GoneR × PICTURE MOUSE Collavoration T-Shirts Gardenal Red
59546 Zephyren(ゼファレン) PAISLEY PARKA RED
59230 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE LS TEE BLACK×RED
59366 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE RED
58229 【予約商品】PUNK DRUNKERS 23周年TEE - RED
58361 KILL STAR CLOTHING Mika Knit Sweater
57431 THRASHER (スラッシャー) TH8928C GONZ COACH JKT RED
54917 PUNK DRUNKERS [PDSxキン肉マン]超人総柄ハイブリットタオル - RED
55589 SABBAT13 GHOST LOGO BELT レッド
55558 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE RED
54761 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS RED
54165 GoneR Rose Logo Tank-Top Black/Red
54168 GoneR Day of the Dead Tank-Top Black/Red
49865 PSYCHOLOGICAL METAMORPHOSIS PLMP MARK 3 RED
49874 PSYCHOLOGICAL METAMORPHOSIS PLMP FLOWER TEE BURGANDY
41280 PSYCHOLOGICAL METAMORPHOSIS PLMP HEAVY CIRCLE BURGUNDY
41287 PSYCHOLOGICAL METAMORPHOSIS PLMP TEE RED
41290 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO 2 BURGUNDY
49863 PSYCHOLOGICAL METAMORPHOSIS PLMP CARD TEE RED
52604 GoneR -La Neta- Agave Pocket T-Shirts MAROON
48520 GoneR GR21CT002 Grave Rose T-Shirts Red
36638 GoneR New Logo Bucket Hat RED
54680 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” TEE WHITE
4457 SYSTEM OF A DOWN AERIALS T-Shirt
6297 NineMicrophones WALLET CHAIN -9MC Crew- BGN/MUS
10333 Subciety LONG BEANIE NY RED
10959 FAMOUS STARS AND STRAPS DEATH CROW Tee WHT
11589 KILL STAR CLOTHING CUNT BEANIE [B]
13797 NineMicrophones BORDER TEE S/S -9MC Crew- RED
13800 Subciety TIE DYE PARKA-GLORIOUS- BGN
14103 SLIPKNOT THORNS ALL OVER T-Shirt
14693 FAMOUS STARS AND STRAPS NEXT MOVE MENS PREMIUM
14793 RUDIE'S SPARK BORDER KNIT CAP RED
15186 HOLDTUBE HT-0171 NIGHT TIPI HOLDTUBE
15402 MEMPHIS MAY FIRE Ordinary Love Red Tank Top
15511 WE CAME AS ROMANS Conquer Maroon
15584 TEXAS IN JULY Ministry Maroon
15878 BURNING THE REGISTER CHAOS BEANIE RED
17233 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- BURGUNDY
17450 DEADHEARTZ MESH CAP RED
17629 DEADHEARTZ MOON TEES RED
17971 KILLSWITCH ENGAGE DRAGON ZOMBIE WALLET
18036 BAD RELIGION NAUGHTY NUNS
18068 DEADHEARTZ “WORLD”TEES RED
18802 NineMicrophones BEANIE -Power of will- BURGUNDY
18805 NineMicrophones WATCH CAP -Higher than the RED
18980 MEMPHIS MAY FIRE Eagle Dagger Red
18988 WE CAME AS ROMANS Floral Script HeatherMountain
19094 ATTILA About That Life Graffiti Red
19654 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY - BURGUNDY
19697 ZEPHYREN (ゼファレン) BON BON KNIT - BURGUNDY
19800 CHUNK!NO,CAPTAIN CHUNK! Steering Wheel Cardinal Re
19808 CAPTURE THE CROWN Grim Concrete/Cherry
19821 MAYDAY PARADE Label Crimson Tie Dye
19844 FOR TODAY IMMORTAL RED
19856 A SKYLIT DRIVE Rise Again Maroon
20193 KEYTALK ボーダーTシャツ赤
20429 PUNK DRUNKERS YUTORIパーカ BURGUNDY
21138 BEFORE MY LIFE FAILS Deep Red Wool Snapback Cap
21220 ATTILA RageAholics Red - T-Shirt
21478 アーバンギャルド 水玉ショルダーバッグ レッド
21565 DEADHEARTZ "BLOOD" SNAPBACK BURGUNDY
21604 FAMOUS STARS AND STRAPS DEAD BEASTS MENS TEE BGN
21667 SQUARE CABLE KNIT CAP RED
21681 FAMOUS STARS AND STRAPS F YOU YOU F MENS TEE RED
21701 THRASHER HOODIE TH8501H RED
21796 MISHKA (ミシカ) Snuffy Emotional Snapback
22114 THRASHER TH8401 MAG LOGO SWEAT BURGUNDY/WHITE
22171 FAMOUS STARS AND STRAPS VERNON BOYS TEE RED
22551 KILL BRAND FILA KILLA RED SOFT BEANIE
22747 Zephyren (ゼファレン) BUCKET HAT -SKULL HEAD- BURGUNDY
22854 四星球 2015パーカー(A)
22901 ANIMALIA BEANIE #005 RED
24062 ANIMALIA AN16S-CP08 BEANIE #006 RED
24153 グッドモーニングアメリカ 時計パーカー(バーガンディ)
24489 RIP DESIGN WORXX STRAIGHT EDGEロゴジップパーカーレッド
24493 RIP DESIGN WORXX スウェットハーフパンツ BGN
24594 ROLLING CRADLE SD ROLICLE Tee / Red
24668 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) Wild Patriot Tank Top RED
24692 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) Wild Patriot Mens Tee BGN
24741 MEMPHIS MAY FIRE Challenger Red - T-Shirt
24951 Zephyren (ゼファレン) POLO SHIRT -SPADE- BURGUNDY