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-05-25 03:05:51')
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, 60
71759 VIRGOwearworks (ヴァルゴウェアワークス)Ultimate [C] RED
70847 glamb (グラム) Punk Bouquet Sleeveless T-Shirt / パンクブーケスリーブレスTシャツ - Black
70027 glamb (グラム) Mesh Layered Tank Top / メッシュレイヤードタンクトップ Black
70012 glamb (グラム) marquee club(R) Tank Top / マーキークラブタンクトップ Black
71314 MÅNESKIN UNISEX TANK T-SHIRT: GAY FOR MANESKIN
71392 NineMicrophones (ナインマイクロフォンズ) TANKTOP-Pray with the microphone-WHITE
71393 NineMicrophones (ナインマイクロフォンズ) TANKTOP-Pray with the microphone-BLACK
62313 Zephyren(ゼファレン) TANKTOP - BEYOND - BLACK
68527 RIPNDIP (リップンディップ) Lord Savior Nerm Basketball Jersey NAVY
63196 ANIMALIA (アニマリア) TANK TOP - logo WHITE
63195 ANIMALIA (アニマリア) TANK TOP - logo BLACK
63198 ANIMALIA (アニマリア) Double Cutaway - logo WHITE
63197 ANIMALIA (アニマリア) Double Cutaway - logo BLACK
63317 GoneR (ゴナー) GR33TK001 Rose Maria Tank-Top White
63318 GoneR (ゴナー) GR33TK001 Rose Maria Tank-Top Black
61757 MISHKA (ミシカ) M21100180 VEST
62312 【予約商品】Zephyren(ゼファレン) TANKTOP - BEYOND - WHITE
62315 Zephyren(ゼファレン) TANKTOP - In vino veritas - WHITE
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
58189 【予約商品】PUNK DRUNKERS [PDSxなかやまきんに君]マッスルタンク - WHITE
57879 Subciety TANK TOP- BLACK
58704 GoneR GR29TK001 Rose Messege Tank-Top White
58350 CIVARIZE【シヴァーライズ】バイカラー切り替えロンT&タンクトップセット
57878 Subciety (サブサエティ) TANK TOP- WHITE
56995 VIRGO Off the dye GRAY
15637 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- WHT
56066 Subciety 2021 福袋 -NEW YEAR BAG-
57102 Zephyren 2021 NEW YEAR BAG
56290 CIVARIZE【シヴァーライズ】ROSE BIG L/S TEE+TANK TOP (BLACK)
56291 CIVARIZE【シヴァーライズ】ROSE BIG L/S TEE+TANK TOP (WHITE)
56214 Anti Social Social Club Goodbye Summer Black Tank
55808 SUBLIME×SULLEN HEAD HIGH STANDARD TANKTOP
54163 GoneR Rose Logo Tank-Top White
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
54166 GoneR Day of the Dead Tank-Top White
53277 Zephyren(ゼファレン)BIG TANKTOP WHITE / pagan
53278 Zephyren(ゼファレン)BIG TANKTOP BLACK / pagan
53276 Zephyren(ゼファレン)BIG TANKTOP BLACK
17676 Subciety TIE DYE TANK TOP-GLORIOUS- BLK
17695 Subciety TIE DYE TANK TOP-GLORIOUS- NAVY
7467 MEMPHIS MAY FIRE Crest Black Tank Top
7495 OF MICE & MEN Wave Black Tank Top
9314 MEMPHIS MAY FIRE Challenger Black Tank Top
9367 ATTILA Kings Black Tank Top
9373 BLESS THE FALL Hollow Bodies Album Art White Tank
9382 PIERCE THE VEIL P T V Camo Tank Top
9402 MISS MAY I New Lion Black Tank Top
9415 WE CAME AS ROMANS Sideways Black Tank Top
11245 BLESS THE FALL Tiger Black Tank Top
11303 MEMPHIS MAY FIRE Richer Black Tank Top
11436 ATTILA Reaper Navy/Heather Tank Top
11456 WE CAME AS ROMANS Tracing Back Roots Black TankTop
11458 LIKE MOTHS TO FLAMES Demon Black Tank Top
11459 LIKE MOTHS TO FLAMES Middle Finger Black Tank Top
13462 ANGRY FROG REBIRTH TANK TOP