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-30 19:11:45')
AND FIND_IN_SET(7, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
37046 MARILYN MANSON×KILL STAR CLOTHING Cryptorchid Harness Dress
51493 NieR (ニーア) ポケット付総柄ペイント半袖パーカー
10639 THRASHER TH8501 MAG LOGO HOODIE BRG/WHT
52439 STAPLE Supernova Bubble Jacket
52447 STAPLE Neo Sport Nylon Crew
50161 Subciety (サブサエティ) WORK SHIRT-BABYLON- BURGUNDY
43527 PARADOX - ZIP SHIRTS (RED-CHECK)
52620 RUDIE'S (ルーディーズ) MIGHTY SHOWER SANDAL RED
702 AC/DC Angus Young-Guitar Hero Statue-
2239 THE LIBERTINES Flag Black Ethletic Hi-Top
3551 BREATHE CAROLINA - Breathe Red
4457 SYSTEM OF A DOWN AERIALS T-Shirt
6297 NineMicrophones WALLET CHAIN -9MC Crew- BGN/MUS
7980 Subciety COIN CASE RED
8142 MISHKA KEEP WATCH VINTAGE JACKET HEATHER CRIMSON
9245 PUNK DRUNKERS 虫くいジップパーカ RED
9423 WE CAME AS ROMANS Alive Red Rubber Bracelet
9745 REBEL8 ALPINE MAROON BEANIE
10333 Subciety LONG BEANIE NY RED
10959 FAMOUS STARS AND STRAPS DEATH CROW Tee WHT
11382 RUDIE'S WHEEL KEYHOLDER RED
11589 KILL STAR CLOTHING CUNT BEANIE [B]
11625 KILL STAR CLOTHING KAWAII LEGGINGS
12220 ROLLING CRADLE ALIEN CAN BADGE Red
12222 ROLLING CRADLE LAUNDRY CAN BADGE
12228 MISHKA (ミシカ) KILL WITH POWER NE 5950 RED
12504 NineMicrophones GAME SHIRT -SHOUT SKULL-BGN
12858 ROLLING CRADLE RC DRY CLOTH Laundry
13187 VANS APPAREL MARITIME19 SURF SHORTS BLUE
13511 MISHKA (ミシカ) CITY JACK BUTTON UP RED
13753 REBEL8 FINGERS CROSSED GLOW IN THE DARK RED
13797 NineMicrophones BORDER TEE S/S -9MC Crew- RED
13800 Subciety TIE DYE PARKA-GLORIOUS- BGN
14103 SLIPKNOT THORNS ALL OVER T-Shirt
14148 RUDIE'S SPARK ZIPHOOD SW RED
14157 DEADHEARTZ CRESCET HOODIE Burgundy
14272 Subciety BON BON KNIT-SALOON- BURGUNDY
14305 MISHKA (ミシカ) DEATH ADDER NEW ERA BURGUNDY
14552 Subciety 7UNION × Subciety BEANIE -SALOON- RED
14693 FAMOUS STARS AND STRAPS NEXT MOVE MENS PREMIUM
14778 MISHKA (ミシカ) BOOTLEG HORNS POM BEANIE RED
14793 RUDIE'S SPARK BORDER KNIT CAP RED
14889 Subciety PAISLEY SHIRTS L/S BURGUNDY
15114 NineMicrophones 9MC SK8 PATTERNED ZIP PARKA BUR
15186 HOLDTUBE HT-0171 NIGHT TIPI HOLDTUBE
15263 ZEPHYREN (ゼファレン) COIN CASE -BEYOND- RED
15325 CHUNK!NO,CAPTAIN CHUNK! Mustache Heather/Burgundy
15360 KILL STAR CLOTHING TARTAN SKATER DRESS
15402 MEMPHIS MAY FIRE Ordinary Love Red Tank Top
15511 WE CAME AS ROMANS Conquer Maroon
15512 WE CAME AS ROMANS Fade Away Black
15584 TEXAS IN JULY Ministry Maroon
15597 BREATHE CAROLINA We Are Savages Glow-In-The-Dark
15780 ROLLING CRADLE CYCLOPS SHOUT COACH JKT / Red
15844 ROLLING CRADLE RAKURAI LONG NEL / Red
15870 SABBAT13 KNIT CAP BURGUNDY
15878 BURNING THE REGISTER CHAOS BEANIE RED
15948 DROP DEAD CLOTHING Snow Parka Red
16401 NineMicrophones 9MC Crew S/S - BURGUNDY
16499 Subciety ZIP PARKA-Parantica sita- BURGUNDY
16503 Subciety PARKA-Parantica sita- BURGUNDY
16506 Subciety ZIP PARKA-LARGE GLORIOUS- BURGUNDY
16522 KILL STAR CLOTHING Tartan Backpack B/R
16716 ICECREAM ALL OVER POPSICLE PINK
16741 バックドロップシンデレラ よのっしー缶バッヂ(小) 赤
16743 バックドロップシンデレラ よのっしー缶バッヂ(大)
17230 Zephyren MESH CAP -BEYOND- - BURGUNDY
17233 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- BURGUNDY
17256 Zephyren MESH CAP -VISIONARY- - BURGUNDY
17402 RUDIE'S STUDS SILICONE WRIST BAND RED/YELLOW
17450 DEADHEARTZ MESH CAP RED
17568 NineMicrophones CHECK L/S-King Of The Road- BGN
17629 DEADHEARTZ MOON TEES RED
17784 Subciety BUCKET HAT-GLORIOUS- PPL
17971 KILLSWITCH ENGAGE DRAGON ZOMBIE WALLET
18036 BAD RELIGION NAUGHTY NUNS
18042 四星球 小宇宙シリーズ ニットキャップ BGN
18068 DEADHEARTZ “WORLD”TEES RED
18136 ZEPHYREN (ゼファレン) S/S TEE -10-FEET BUR
18229 RUDIE'S BRISTLE GLEAM KEYHOLDER RED
18339 Subciety STADIUM JKT-NX- - BURGUNDY
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
19221 Zephyren (ゼファレン) COACH JKT -EMBLEM - BURGUNDY
19308 ZEPHYREN (ゼファレン) CHECK SHIRT L/S -Resolve - BURGUNDY
19353 ZEPHYREN (ゼファレン) EMBLEM CARDIGAN - BURGUNDY
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
19814 MISHKA (ミシカ) CYCO REAPER SOCKS
19821 MAYDAY PARADE Label Crimson Tie Dye
19844 FOR TODAY IMMORTAL RED
19856 A SKYLIT DRIVE Rise Again Maroon
19868 SQUARE FLOWER TANKTOP RED
20193 KEYTALK ボーダーTシャツ赤
20429 PUNK DRUNKERS YUTORIパーカ BURGUNDY
20494 MISHKA (ミシカ) KEEP WATCH SNAPBACK RED
20540 SPITFIRE Big Head Raglan RED
20567 FAMOUS STARS AND STRAPS MONSTER MASH BOH RED
20609 MISHKA (ミシカ) KEEP WATCH CREST CREWNECK RED
21064 ライブキッズあるある ラバーバンドの数はステータスラバーバンド 赤×白
21134 BEFORE MY LIFE FAILS Sunglasses Division Point
21138 BEFORE MY LIFE FAILS Deep Red Wool Snapback Cap
21142 BEFORE MY LIFE FAILS Keychain
21189 ROLLING CRADLE RC REFLECTION HOODIE / Burgundy
21216 Stay Sick Clothing Custom Pizza - Crewneck
21220 ATTILA RageAholics Red - T-Shirt
21298 ROLLING CRADLE ROLLCRDL SWEAT / Red
21356 THRASHER SNAP BACK 17TH-C65 BURG
21357 THRASHER SNAP BACK 17TH-C64 BURG
21424 ZOX STRAPS TURBINE
21436 RUDIE'S BRISTLE CHECK HOOD SHIRTS RED
21460 SQUARE NOTORIOUS CREW NECK SWEAT RED
21477 アーバンギャルド KAITAIタオル
21478 アーバンギャルド 水玉ショルダーバッグ レッド
21565 DEADHEARTZ "BLOOD" SNAPBACK BURGUNDY