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-28 08:48:04')
AND pc.price02 > 2727
AND price02 <= 4545
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
71423 Subciety (サブサエティ) CREST TANK TOP BLACK
63195 ANIMALIA (アニマリア) TANK TOP - logo BLACK
63197 ANIMALIA (アニマリア) Double Cutaway - logo BLACK
63318 GoneR (ゴナー) GR33TK001 Rose Maria Tank-Top Black
58705 GoneR GR29TK001 Rose Messege Tank-Top Black
58190 【予約商品】PUNK DRUNKERS [PDSxなかやまきんに君]マッスルタンク - BLACK
57879 Subciety TANK TOP- BLACK
15638 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- BLK
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
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
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
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
18109 KILL STAR CLOTHING FUNERAL MUSCLE TANK [B]
18831 KILL STAR CLOTHING PIZZA ORDER MUSCLE TANK [B]
19007 WHITECHAPEL Sawblades Black TANK
19106 ATTILA REAPER BLACK/HEATHER TANK TOP
19883 WITHIN THE RUINS Green Crest Black Tank Top
20552 PALISADES Future Music Black Tank Top
21110 Stay Sick Clothing Hands Black Tank Top
21201 Stay Sick Clothing MMXV Black - TankTop
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
23791 KILL STAR CLOTHING (キルスター・クロージング) Unsocial Tank [B]
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
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
26537 RideMe R Logo Tanktop BLACK
26539 RideMe Beer Logo Tanktop BLACK
26590 Zephyren (ゼファレン) SPADE TRIBAL TANKTOP BLACK
26633 RUDIE'S VICE TANKTOP BLACK
27483 MISHKA (ミシカ) JV KEEP WATCH BASKETBALL JERSEY Black
27515 KILL STAR CLOTHING (キルスター・クロージング) In My Mind Tank [B]
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]