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-23 18:23:17')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
70026 glamb (グラム) Mesh Layered Tank Top / メッシュレイヤードタンクトップ White
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
71315 MÅNESKIN UNISEX VEST T-SHIRT: ZITTI E BUONI
71423 Subciety (サブサエティ) CREST TANK TOP BLACK
71422 Subciety (サブサエティ) CREST TANK TOP WHITE
71392 NineMicrophones (ナインマイクロフォンズ) TANKTOP-Pray with the microphone-WHITE
71393 NineMicrophones (ナインマイクロフォンズ) TANKTOP-Pray with the microphone-BLACK
62313 Zephyren(ゼファレン) TANKTOP - BEYOND - BLACK
68375 SLEEPING TABLET (スリーピングタブレット) WAVE [ SHEAR TANK TOP ] Black
68756 TEROMELIA(テロメリア) ピクセルネックタンクトップ ホワイト
68757 TEROMELIA(テロメリア) ピクセルネックタンクトップ ベージュ
68758 TEROMELIA(テロメリア) ピクセルネックタンクトップ ブラック
68378 SLEEPING TABLET (スリーピングタブレット) BLOCK [ SHEAR TANK TOP ] Gray
68377 SLEEPING TABLET (スリーピングタブレット) WAVE [ SHEAR TANK TOP ] Wine
68376 SLEEPING TABLET (スリーピングタブレット) WAVE [ SHEAR TANK TOP ] Green
68379 SLEEPING TABLET (スリーピングタブレット) BLOCK [ SHEAR TANK TOP ] Yellow
68527 RIPNDIP (リップンディップ) Lord Savior Nerm Basketball Jersey NAVY
68364 Subciety (サブサエティ) CUT OFF TANK TOP WHITE
68365 Subciety (サブサエティ) CUT OFF TANK TOP BLACK
68368 Subciety (サブサエティ) PAISLEY GAME SHIRT PURPLE
68367 Subciety (サブサエティ) PAISLEY GAME SHIRT BURGUNDY
68366 Subciety (サブサエティ) PAISLEY GAME SHIRT BLACK
67598 GALFY (ガルフィー) 「チーム犬」メッシュタンク RED
67597 GALFY (ガルフィー) 「チーム犬」メッシュタンク PURPLE
67595 GALFY (ガルフィー) 「チーム犬」メッシュタンク BLACK
64269 RIPNDIP (リップンディップ) Nikola Basketball Jersey (Black/Blue)
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
63010 GALFY (ガルフィー) わんわん大学SETUP 夏 WHITE
63012 GALFY (ガルフィー) わんわん大学SETUP 夏 L.GREEN
63011 GALFY (ガルフィー) わんわん大学SETUP 夏 BLACK
61355 SLEEPING TABLET RESTLESS [ NET SLEEVELESS ] BLACK
61757 MISHKA (ミシカ) M21100180 VEST
60150 Unlucky Morpheus×GEKIROCK CLOTHING×CIVARIZE 限定タンクトップ BLACK
62315 Zephyren(ゼファレン) TANKTOP - In vino veritas - WHITE
62316 Zephyren(ゼファレン) TANKTOP - In vino veritas - BLACK
60149 Unlucky Morpheus×GEKIROCK CLOTHING×CIVARIZE 限定タンクトップ WHITE
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
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
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
56121 SILLENT FROM ME DOUGLAS Fuzzy Tank Top
55808 SUBLIME×SULLEN HEAD HIGH STANDARD TANKTOP
55683 RIP DESIGN WORXX スラッシュロゴメッシュタンクトップ BLACK
55684 RIP DESIGN WORXX スラッシュロゴメッシュタンクトップ WHITE
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
55300 NieR (ニーア) NO SLEEVES HOODIE
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
48525 GoneR GR21TK001 Grave Rose 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
3888 IRON FIST Mr Wong's Sequined Tank
4660 SUGARFIX CLOTHING Creature Stole My Twinkie Lace T
4745 DROP DEAD CLOTHING MOMMY'S VERY ANGRY
4936 ARKAIK CLOTHING BLACK TANK TOP(B)
5191 DROP DEAD CLOTHING SWANKY CATZ
6316 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK NAVY
6317 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK BLACK
6595 FAMOUS STARS AND STRAPS Stone BOH Jrs Derby Tank
6599 FAMOUS STARS AND STRAPS Foundation Jrs Lucky Tank
6874 GLAMOUR KILLS GIRLS SLAY ON DRAPE TANK
7079 KILL STAR CLOTHING BLACK MAGIC VEST [B]
7103 KILL STAR CLOTHING NOCTEM VEST [B]
7223 FAMOUS STARS AND STRAPS Lips Jrs Derby Tank
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
7650 DISTURBIA CLOTHING Monk Vest Dress
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
9808 DISTURBIA CLOTHING Negative Creep Girls Tank Top
9811 DISTURBIA CLOTHING Sex Sex Sex Girls Tank Top
9837 DISTURBIA CLOTHING The Queen Is Dead Vest Dress
9861 KILL STAR CLOTHING GRUMPY VEST [B]