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-24 03:01:04')
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 12,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
70027 glamb (グラム) Mesh Layered Tank Top / メッシュレイヤードタンクトップ Black
70012 glamb (グラム) marquee club(R) Tank Top / マーキークラブタンクトップ Black
70847 【予約商品】glamb (グラム) : Punk Bouquet Sleeveless T-Shirt / パンクブーケスリーブレスTシャツ - Black
71423 Subciety (サブサエティ) CREST TANK TOP BLACK
71393 NineMicrophones (ナインマイクロフォンズ) TANKTOP-Pray with the microphone-BLACK
62313 Zephyren(ゼファレン) TANKTOP - BEYOND - BLACK
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
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
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
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