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-25 07:39:32')
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
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
51677 MUSIC SAVED MY LIFE M201-02L1-CS03 LONG TANK TOP WHITE
15637 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- WHT
15638 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- BLK
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
13159 Subciety TANK TOP -TRUST-BLACK/WHITE
17675 Subciety TIE DYE TANK TOP-GLORIOUS- BURGUNDY
17676 Subciety TIE DYE TANK TOP-GLORIOUS- BLK
17695 Subciety TIE DYE TANK TOP-GLORIOUS- NAVY
48361 Subciety (サブサエティ) TANKTOP-TAG- WHITE
48475 GoneR GR21TK002 Rose Earth Skull Tank-Top White
42726 GoneR (ゴナー) GR18TK001 Hibiscus 57 Tank-Top Black
23333 GoneR Mexican Skull Tank-Top - Black
24869 GoneR Photo Logo Tank-Top White
24870 GoneR Photo Logo Tank-Top Black
24871 GoneR GoneR Dot Tank-Top White
1464 Subciety TANK TOP-GLORIOUS- BLK/GLD
1465 Subciety TANK TOP-GLORIOUS- BLK/WHT
4745 DROP DEAD CLOTHING MOMMY'S VERY ANGRY
6316 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK NAVY
6317 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK BLACK
7079 KILL STAR CLOTHING BLACK MAGIC VEST [B]
7103 KILL STAR CLOTHING NOCTEM VEST [B]
7255 REBEL8 GOO BLOCK BLACK TANK
7289 MISHKA (ミシカ) KEEP WATCH TANK TOP WHITE
7467 MEMPHIS MAY FIRE Crest Black Tank Top
7495 OF MICE & MEN Wave Black Tank Top
7624 FAMOUS STARS AND STRAPS Bombard BOH Tank Top
8061 KILL STAR CLOTHING SACRIFICE VEST [B]
9208 BLACK CRAFT Hail Satan And Drink Coffee 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
9861 KILL STAR CLOTHING GRUMPY VEST [B]
9866 KILL STAR CLOTHING BATS VEST [B]
10822 MISHKA (ミシカ) CYCO PUSHER TANK TOP TIE-DYE
10824 MISHKA (ミシカ) CYCO PUSHER TANK TOP BLACK
10826 MISHKA (ミシカ) FINAL MOMENTS TANK TOP PURPLE TIE-DYE
10832 MISHKA (ミシカ) KEEP WATCH TANK RED
10833 MISHKA (ミシカ) LAMOUR RING OF HELL KW TANK TOP BLACK
11058 VANS APPAREL BIDWELL TANK TOP RED
11063 VANS APPAREL BURKE TANK TOP BALTIC GRAVEL
11064 VANS APPAREL BURKE TANK TOP GREY
11082 MISHKA (ミシカ) THE MOTOR CITY DEATH ADDERS TANK TOP BLACK
11087 MISHKA (ミシカ) CYCO SPIDER TANK BLACK
11091 MISHKA (ミシカ) THE WORLD WIDE WEIRDOS TANK GREEN TIE DYE
11092 MISHKA (ミシカ) THE WORLD WIDE WEIRDOS TANK BLACK
11245 BLESS THE FALL Tiger 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
11412 Subciety TANK TOP2014-GLORIOUS- BLACK/WHITE
11413 Subciety TANK TOP 2014-TRIBE CROS- BLACK/WHITE
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
11576 KILL STAR CLOTHING CARE LESS VEST [B]
11578 KILL STAR CLOTHING GIZA TANK [B]
11580 KILL STAR CLOTHING ILLUMINATI TANK [B]
11583 KILL STAR CLOTHING OUIJA TANK [B]
11585 KILL STAR CLOTHING REPTILE TANK [B]
11587 KILL STAR CLOTHING SUCK MY SYMBOL TANK [B]
11588 KILL STAR CLOTHING WEDNESDAY TANK [B]
11652 FAMOUS STARS AND STRAPS TIGER TEXT Tank
11654 FAMOUS STARS AND STRAPS LOYAL Tank ORANGE
11656 FAMOUS STARS AND STRAPS FAM RESPECT Tank BLK
11657 FAMOUS STARS AND STRAPS FAM RESPECT Tank WHT
11662 FAMOUS STARS AND STRAPS Full Circle BOH Tank BLK
11664 FAMOUS STARS AND STRAPS PALM SKULL EYES Tank BLK
11784 Subciety PAISLEY TANK TOP BLACK
11790 Subciety TANK TOP -TRIBE CROSS- BLACK/GOLD
11893 Subciety PAISLEY TANK TOP BLACK
12040 DISTURBIA CLOTHING House Of Wolves VEST Girls
12180 PUNK DRUNKERS 野球タンク BLUE
12192 MISHKA (ミシカ) SNAKE BITE BOA TANK TOP BOA
12194 MISHKA (ミシカ) BEAST OF THE EAST TANK TOP ARMY
12195 MISHKA (ミシカ) BEAST OF THE EAST TANK TOP WHITE