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 (
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-30 18:54:45')
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 13,35,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
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
63195 ANIMALIA (アニマリア) TANK TOP - logo BLACK
63197 ANIMALIA (アニマリア) Double Cutaway - logo BLACK
63318 GoneR (ゴナー) GR33TK001 Rose Maria Tank-Top Black
61757 MISHKA (ミシカ) M21100180 VEST
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
55808 SUBLIME×SULLEN HEAD HIGH STANDARD TANKTOP
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
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
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
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
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]
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
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
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
27462 MISHKA (ミシカ) EXPLODING KEEP WATCH TANK Black
27483 MISHKA (ミシカ) JV KEEP WATCH BASKETBALL JERSEY Black
27515 KILL STAR CLOTHING (キルスター・クロージング) In My Mind Tank [B]
27753 PUNK DRUNKERS コールドジムタンク BLACK
27757 PUNK DRUNKERS ふくろうタンク BLACK
27881 DISTURBIA CLOTHING (ディスタービア・クロージング) GENERIC ROCK VEST
28143 KILL STAR CLOTHING (キルスター・クロージング) People Tank [B]
28149 KILL STAR CLOTHING (キルスター・クロージング) Eternal Holiday Tank [B]
28154 KILL STAR CLOTHING (キルスター・クロージング) Satan Called Tank [B]
28155 KILL STAR CLOTHING (キルスター・クロージング) Poison Tank [B]
28262 STAY SICK CLOTHING Northern Lights Black
28310 FRONZILLA Party People's Anthem Black TankTop
28464 Gluttonous Slaughter (グラトナス・スローター) Feast of the Unbirthed BLACK
28466 Gluttonous Slaughter (グラトナス・スローター) Inversion of Christ TANK BLACK
29110 KILL STAR CLOTHING (キルスター・クロージング) Dark Side Tank [B]
29451 NineMicrophones (ナインマイクロフォンズ) TANK TOP-how high- BLACK
30634 Zephyren(ゼファレン) TANK TOP -REBEL FLAG- BLACKxWHITE
30640 Zephyren(ゼファレン) TANK TOP -BEYOND FLAME- BLACKxWHITE
30641 Zephyren(ゼファレン) TANK TOP -BEYOND FLAME- BLACKxRED
30645 Zephyren(ゼファレン) TANK TOP -ENGRAVE- BLACKxWHITE
30646 Zephyren(ゼファレン) TANK TOP -ENGRAVE- BLACKxRED
32704 Subciety (サブサエティ) TANK TOP-BANDANNA GLORIOUS- BLACK
33021 NineMicrophones 69YIN-YANG TANK TOP BLACK-WHITE
33022 NineMicrophones 69YIN-YANG TANK TOP BLACK-BURGUNDY
33843 ANIMALIA AN17U-TE08 FIGHT IT OUT BLACK
34317 SQUARE JUNK PATTERN MESH TANKTOP Black
34528 MUSIC SAVED MY LIFE (MSML) MESH LAYERED TANK TOP BLACK