SELECT SQL_CALC_FOUND_ROWS 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 =1
)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-26 15:44:52')
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
70724 Subciety (サブサエティ) Hard Days TEE BURGUNDY
71533 NineMicrophones (ナインマイクロフォンズ) Pray with the microphone TEE BURGUNDY
70950 RED HOT CHILI PEPPERS UNISEX T-SHIRT: RED CIRCLE ASTERISK (ECO-FRIENDLY)
71220 【予約商品】GALFY(ガルフィー) GALFY DAYoボーダーTee RED BORDER
71206 【予約商品】GALFY (ガルフィー) 番犬Tee 赤系
71241 TOY MACHINE (トイマシーン) MARKED MONSTER EMBROIDERY SS TEE BURGANDY
71349 over print (オーバープリント) GHOST BUSTERS Tee 9 wine
71409 PSYCHO NATION(サイコネーション) メッシュアンサンブルTEE タイダイREDxBLACK
71355 over print (オーバープリント) GHOST BUSTERS Tee 10 red
71224 【予約商品】GALFY(ガルフィー) ガルスモリンガーTee BURGUNDY
69211 GoneR(ゴナー) GR37CT002 Rose Ribbon T-Shirt Black/Red
69214 GoneR(ゴナー) GR37CT003 Mix Design T-Shirt Black/Red
69106 PUNK DRUNKERS(パンクドランカーズ)NEKOCATS.TEE'23 / REVIVAL BURGUNDY
67664 PUNK DRUNKERS(パンクドランカーズ)アイツ大佐TEE - RED
69097 NieR (ニーア) 超BIG SILHOUETTE RED CUTSEW 【WHITE×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
68012 【BanG Dream! ×ゲキクロ 2023 ver.】今井リサ×RIP DESIGN WORXX コラボ Tシャツ
53184 ALL TIME LOW UNISEX TEE: DA BOMB
68432 NieR (ニーア) HALF SLEEVE CUTSEW BLACKxRED
65539 NieR (ニーア) 超OVERSIZE SILHOUETTE CUTSEW【FIRE×HEART】
67813 over print(オーバープリント) CARD Tee wine
67977 YUNGBLUD UNISEX T-SHIRT: R-U-OK?
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
62669 PUNK DRUNKERS (パンクドランカーズ) タイダイきのこTEE - RED
65369 NieR (ニーア) 超BIG SILHOUETTE RED CUTSEW 【NieR TAIL】
63811 Subciety(サブサエティ) FIVE LIGHTS TEE BURGUNDY
63342 Subciety (サブサエティ) BLACK PANTHER TEE BURGUNDY
63817 ROLLING CRADLE (ローリングクレイドル) VVV TEE / RED
63719 over print (オーバープリント) planet Tee (azuki)
63737 over print (オーバープリント) EMB logo Tee 1 (azuki)
59356 TRAVAS TOKYO【トラバストーキョー】フロントアップビッグクマTシャツ Black
61865 glamb (グラム) Fake Layered Border CS - Red×Navy
62615 NineMicrophones Chug S/S BURGUNDY
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60717 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / RED
60604 RIPNDIP OG Prisma Embroidered Tee (Red Tie Dye)
60463 NieR (ニーア) BACK RABBIT CHECKERED CUTSEW 【RED PINK】
54529 SAMURAI CORE SR-TE-004C GIVE IT こけしTEE RED
53151 SAMURAI CORE 釈迦 TEE RED
53147 SAMURAI CORE 地震ー雷ー火事ーオヤジ TEE RED
59357 TRAVAS TOKYO【トラヴァストーキョー】グラフィック総柄スーパービッグTシャツ White
59297 GoneR GR29CTW001 GoneR × PICTURE MOUSE Collavoration T-Shirts Gardenal Red
59865 PSYCHOLOGICAL METAMORPHOSIS NOT TEE BURGANDY
59366 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE RED
59843 HYPER CORE T-367 承認欲求がぁる2 -I need your Reply, Retweet & いいね- Tシャツ ホワイト×レッド
59355 TRAVAS TOKYO【トラヴァストーキョー】フロントアップビッグクマTシャツ White
58522 ぜんぶ君のせいだ。×GEKIROCK CLOTHING×UNUSUAL コラボTシャツ 如月 愛海 (きさらぎ めぐみ)
58387 GALFY (ガルフィー) 半分カラーギャング BIG Tee 漆黒 × 紅
57885 Subciety (サブサエティ) WEEKENDER S/S- RED
58475 TRAVAS TOKYO Furry bear BIG Tee【Red】
58229 【予約商品】PUNK DRUNKERS 23周年TEE - RED
56671 PUNK DRUNKERS リアルあいつTEE - CORAL
57323 Subciety×仮面ライダードライブ DRIVE S/S RED
57813 PARADOX SELECTABLE LAYERED T-SHIRTS BLACK×BURGUNDY
56326 NineMicrophones NM/CS S/S BURGUNDY
56213 Anti Social Social Club Headrush All Over White Tee
47369 RUDIE'S (ルーディーズ) MONSTER-T BURGUNDY
55939 NieR (ニーア) DECORATE SLEEVE CUTSEW【SWEAR RED】LONG LENGTH
55555 PSYCHOLOGICAL METAMORPHOSIS WIRE SS TE BURGANDY
55558 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE RED
53249 Zephyren(ゼファレン)PONCHO BIG STRIPE TEE S/S WHITE / BURGUNDY
49865 PSYCHOLOGICAL METAMORPHOSIS PLMP MARK 3 RED
49874 PSYCHOLOGICAL METAMORPHOSIS PLMP FLOWER TEE BURGANDY
47870 Subciety (サブサエティ) X-RATIO S/S BURGUNDY
46765 【Subciety x RADIO EVA】 RADIO EVA TOUR S/S RED/WHITE
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
53242 Zephyren(ゼファレン)SWITCHING TEE S/S BLACK / RED
52604 GoneR -La Neta- Agave Pocket T-Shirts MAROON
48520 GoneR GR21CT002 Grave Rose T-Shirts Red
54680 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” TEE WHITE
4457 SYSTEM OF A DOWN AERIALS T-Shirt
10959 FAMOUS STARS AND STRAPS DEATH CROW Tee WHT
13753 REBEL8 FINGERS CROSSED GLOW IN THE DARK RED
13797 NineMicrophones BORDER TEE S/S -9MC Crew- RED
14103 SLIPKNOT THORNS ALL OVER T-Shirt
14693 FAMOUS STARS AND STRAPS NEXT MOVE MENS PREMIUM
15511 WE CAME AS ROMANS Conquer Maroon
15584 TEXAS IN JULY Ministry Maroon
16401 NineMicrophones 9MC Crew S/S - BURGUNDY
17629 DEADHEARTZ MOON TEES RED
18036 BAD RELIGION NAUGHTY NUNS
18068 DEADHEARTZ “WORLD”TEES RED
18136 ZEPHYREN (ゼファレン) S/S TEE -10-FEET BUR
18980 MEMPHIS MAY FIRE Eagle Dagger Red
18988 WE CAME AS ROMANS Floral Script HeatherMountain
19094 ATTILA About That Life Graffiti Red
19800 CHUNK!NO,CAPTAIN CHUNK! Steering Wheel Cardinal Re
19821 MAYDAY PARADE Label Crimson Tie Dye
19844 FOR TODAY IMMORTAL RED
19856 A SKYLIT DRIVE Rise Again Maroon
20193 KEYTALK ボーダーTシャツ赤
21220 ATTILA RageAholics Red - T-Shirt
21604 FAMOUS STARS AND STRAPS DEAD BEASTS MENS TEE BGN
21681 FAMOUS STARS AND STRAPS F YOU YOU F MENS TEE RED
21923 MISHKA (ミシカ) KEEP WATCH TEE Cardinal
22171 FAMOUS STARS AND STRAPS VERNON BOYS TEE RED
22841 PUNK DRUNKERS O.F.TEE08.2016 BURGUNDY
22913 REBEL8 ETERNAL BROTHERHOOD BURGUNDY TEE
23442 MISHKA (ミシカ) KEEP WATCH BOX LOGO S/S TEE Red
23511 NineMicrophones Sun forever S/S - BURGUNDY
23732 ANIMALIA Aged T-shirts LOGO RED
24031 ANIMALIA AN16U-TE13 LOGO-Paint TIE DYE RED
24205 ROLLING CRADLE ROLLCRDL BIG Tee / Red
24281 PUNK DRUNKERS 富士山TEE BURGUNDY
24594 ROLLING CRADLE SD ROLICLE Tee / Red
24616 PUNK DRUNKERS 【PDSx円谷プロ】ダダTEE RED
24692 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) Wild Patriot Mens Tee BGN
24724 Zephyren (ゼファレン) S/S TEE -REBEL FLAG- BURGUNDY
24741 MEMPHIS MAY FIRE Challenger Red - T-Shirt
24955 Zephyren (ゼファレン) PAISLEY NECK S/S TEE BURGUNDY
24999 RideMe FLAG TEE RED