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 =211
)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 18:31:31')
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, 120
71423 Subciety (サブサエティ) CREST TANK TOP BLACK
70027 glamb (グラム) Mesh Layered Tank Top / メッシュレイヤードタンクトップ Black
70012 glamb (グラム) marquee club(R) Tank Top / マーキークラブタンクトップ Black
70847 【予約商品】glamb (グラム) : Punk Bouquet Sleeveless T-Shirt / パンクブーケスリーブレスTシャツ - Black
71314 MÅNESKIN UNISEX TANK T-SHIRT: GAY FOR MANESKIN
71393 NineMicrophones (ナインマイクロフォンズ) TANKTOP-Pray with the microphone-BLACK
62313 Zephyren(ゼファレン) TANKTOP - BEYOND - BLACK
68375 SLEEPING TABLET (スリーピングタブレット) WAVE [ SHEAR TANK TOP ] Black
68758 TEROMELIA(テロメリア) ピクセルネックタンクトップ ブラック
68365 Subciety (サブサエティ) CUT OFF TANK TOP BLACK
68366 Subciety (サブサエティ) PAISLEY GAME SHIRT BLACK
67595 GALFY (ガルフィー) 「チーム犬」メッシュタンク BLACK
64269 RIPNDIP (リップンディップ) Nikola Basketball Jersey (Black/Blue)
63195 ANIMALIA (アニマリア) TANK TOP - logo BLACK
63197 ANIMALIA (アニマリア) Double Cutaway - logo BLACK
63318 GoneR (ゴナー) GR33TK001 Rose Maria Tank-Top Black
63011 GALFY (ガルフィー) わんわん大学SETUP 夏 BLACK
61355 SLEEPING TABLET RESTLESS [ NET SLEEVELESS ] BLACK
61757 MISHKA (ミシカ) M21100180 VEST
60150 Unlucky Morpheus×GEKIROCK CLOTHING×CIVARIZE 限定タンクトップ BLACK
62316 Zephyren(ゼファレン) TANKTOP - In vino veritas - BLACK
56997 VIRGO Off the dye BLACK
58705 GoneR GR29TK001 Rose Messege Tank-Top Black
58190 【予約商品】PUNK DRUNKERS [PDSxなかやまきんに君]マッスルタンク - BLACK
57879 Subciety TANK TOP- BLACK
58350 CIVARIZE【シヴァーライズ】バイカラー切り替えロンT&タンクトップセット
15638 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- BLK
56290 CIVARIZE【シヴァーライズ】ROSE BIG L/S TEE+TANK TOP (BLACK)
56214 Anti Social Social Club Goodbye Summer Black Tank
56121 SILLENT FROM ME DOUGLAS Fuzzy Tank Top
55808 SUBLIME×SULLEN HEAD HIGH STANDARD TANKTOP
55683 RIP DESIGN WORXX スラッシュロゴメッシュタンクトップ BLACK
54164 GoneR Rose Logo Tank-Top Black/Purple
54165 GoneR Rose Logo Tank-Top Black/Red
54168 GoneR Day of the Dead Tank-Top Black/Red
53278 Zephyren(ゼファレン)BIG TANKTOP BLACK / pagan
55300 NieR (ニーア) NO SLEEVES HOODIE
17676 Subciety TIE DYE TANK TOP-GLORIOUS- BLK
42726 GoneR (ゴナー) GR18TK001 Hibiscus 57 Tank-Top Black
24870 GoneR Photo Logo Tank-Top Black
1464 Subciety TANK TOP-GLORIOUS- BLK/GLD
1465 Subciety TANK TOP-GLORIOUS- BLK/WHT
4936 ARKAIK CLOTHING BLACK TANK TOP(B)
7624 FAMOUS STARS AND STRAPS Bombard BOH Tank Top
9314 MEMPHIS MAY FIRE Challenger Black Tank Top
9367 ATTILA Kings Black Tank Top
9415 WE CAME AS ROMANS Sideways Black Tank Top
11303 MEMPHIS MAY FIRE Richer Black Tank Top
11373 BLACK CRAFT Lucipurr Tank top BLACK
11375 BLACK CRAFT One Nation No God Tank Top BLACK
11578 KILL STAR CLOTHING GIZA TANK [B]
11662 FAMOUS STARS AND STRAPS Full Circle BOH Tank BLK
11784 Subciety PAISLEY TANK TOP BLACK
11893 Subciety PAISLEY TANK TOP BLACK
13368 IRON FIST CLOTHING SPINELESS PETER PAN COLLAR BLOU
15015 HER NAME IN BLOOD RETURN OF THE BEAST TOUR TANK BL
15346 WHITECHAPEL Spark Black Tank Top
15383 WITHIN THE RUINS Red Crest Black Tank Top
15407 MEMPHIS MAY FIRE On Our Own Black Tank Top
15462 MOTIONLESS IN WHITE Raven Black Tank Top
15533 MAYDAY PARADE Floral Black Tank Top
15579 SECRETS Heart Black Tank Top
16776 FAMOUS STARS AND STRAPS GOTHIC ROSBUD JRS FLOWY
16786 FAMOUS STARS AND STRAPS OG BOH MENS TANK BLK
16983 ZEPHYREN (ゼファレン) TANK TOP -BONEYARD- - BLACK
18109 KILL STAR CLOTHING FUNERAL MUSCLE TANK [B]
18831 KILL STAR CLOTHING PIZZA ORDER MUSCLE TANK [B]
19007 WHITECHAPEL Sawblades Black TANK
19021 RUDIE'S SPARK MESH TANKTOP NAVY
19106 ATTILA REAPER BLACK/HEATHER TANK TOP
19883 WITHIN THE RUINS Green Crest Black Tank Top
19889 KILL STAR CLOTHING SPIRITUS VEST [B]
19890 KILL STAR CLOTHING KALI MUSCLE TANK [B]
19997 IRON FIST CLOTHING Tank Sweet Tooth Muscle Tank
20031 MISHKA (ミシカ) PIZZA KEEP WATCH TANK BLACK
20123 KILL STAR CLOTHING CATS MUSCLE TANK [B]
20471 RIP DESIGN WORXX ロゴタンクトップ BLK
20551 PALISADES NXTLVL Black Basketball
20552 PALISADES Future Music Black Tank Top
21110 Stay Sick Clothing Hands Black Tank Top
21199 Stay Sick Clothing Finger All-Over - TankTop
21201 Stay Sick Clothing MMXV Black - TankTop
21204 Stay Sick Clothing I'm Not Deaf Black - Tank Top
21369 FAMOUS STARS AND STRAPS Turnt Wreath Muscle Tank B
21614 DISTURBIA CLOTHING Ride Vest Dress
21615 DISTURBIA CLOTHING This World Sucks Vest Dress
21616 DISTURBIA CLOTHING Ouija Vest Dress
22189 KILL STAR CLOTHING F* Monday Vest Dress [B]
22582 BREATHE CAROLINA Hello Bubble Tank
22790 DIAWOLF DW ONE-PIECE TANK
22939 REBEL8 STANDARD ISSUE BLACK TANK
23092 Subciety LONG LENGTH NO SLEEVE-GLORIOUS- BLACK
23157 Subciety TANK TOP-SYMBOL- BLACK
23161 Subciety GLORIOUS TANK TOP BLACK/TARQUOISE
23187 Subciety GLORIOUS TANK TOP-ALOHA- BLACK
23277 REBEL8 WOMENS FOREVER FUCKED FLEECE MUSCLE TEE
23335 GoneR Flower Star Tank-Top - Black
23476 NineMicrophones GAME SHIRT-9MC Crew- - BLACK/WHITE
23477 NineMicrophones GAME SHIRT-9MC Crew- - BLACK/BURGUNDY
23791 KILL STAR CLOTHING (キルスター・クロージング) Unsocial Tank [B]
24024 ANIMALIA AN16U-TE10 REZ-Tank BLACK
24425 Hypocrite(ヒポクリット) The Psyboxlogo Tank WB
24426 Hypocrite(ヒポクリット) The Psyboxlogo Tank BW
24667 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) Wild Patriot Tank Top BLK
24693 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) SHOTTA MEN'S TANK TOP
24694 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) Self Made Arch BLK
24872 GoneR GoneR Dot Tank-Top Black
25390 BLACK SCALE ASYMMETRICAL TANK TOP BLK
25479 PIERCE THE VEIL Sugar Skull Black - TankTop
26298 FALLING IN REVERSE Fashionably Late Zip HoodLips 2013 Tank Top
26458 SLEEPING WITH SIRENS White Symbol Tank
26470 DEADHEARTZ "Blood" MESH TANKTOP / BLACK
26537 RideMe R Logo Tanktop BLACK
26539 RideMe Beer Logo Tanktop BLACK
26590 Zephyren (ゼファレン) SPADE TRIBAL TANKTOP BLACK
26603 Zephyren (ゼファレン) TANK TOP -BEYOND- BLACKxRED
26605 Zephyren (ゼファレン) TANK TOP -VISIONARY- BLACKxRED
26633 RUDIE'S VICE TANKTOP BLACK
27365 SQUARE FAMOUS ICONS TANK TOP BLACK
27405 DEADHEARTZ dream one piece