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 =97
)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 10:01:36')
AND pc.price03 IS NOT NULL
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
56109 N.B.O. CONTRAST EMBROIDERY T KHAKI
60295 MISHKA M61000014 L/S T-SHIRT
63574 glamb (グラム) Damaged Layered CS - Black
58317 SLEEPING TABLET GRRL [ MULTI BORDER LONG SLEEVE ] BLACK
60052 SAMURAI CORE コラージュLS TEE WHITE
61439 glamb (グラム)×攻殻機動隊 SAC_2045 long sleeve CS Black
62635 LONELY論理 MEID NAGISA ASSASIN LONG SLEEVE PURPLE
60419 MUSIC SAVED MY LIFE (MSML) ROSE LONG SLEEVE TEE BLACK
60720 MISHKA M61000010 L/S T-Shirt
56157 MUSIC SAVED MY LIFE (MSML) COTTON MESH LONG SLEEVE SLIT CUTSEW BLACK
58318 SLEEPING TABLET GRRL [ MULTI BORDER LONG SLEEVE ] GRAY
58320 SLEEPING TABLET GRRL [ MULTI BORDER LONG SLEEVE ] PURPLE
60759 MUSIC SAVED MY LIFE (MSML) OVERSIZED SIDE SLIT LONG CUTSEW BLACK
65804 ROLLING CRADLE(ローリングクレイドル) YF LONG SLEEVE BLACK
54053 FILA FM9787 L/S TEE BLACK
56290 CIVARIZE【シヴァーライズ】ROSE BIG L/S TEE+TANK TOP (BLACK)
66731 NOTBADCAT (ノットバッドキャット) ニャルボロ LS Tee WHITE
57256 ガリュウホンポ 金魚ラグラン
55082 Zephyren(ゼファレン)BIG L/S TEE - VISIONARY / Kaleidoscope - BLACK
56771 FOG ESSENTIALS RIFLECTOR LOGO LS TEE TAN
57289 FOG ESSENTIALS FRONT LOGO LS TEE BLACK
57290 FOG ESSENTIALS FRONT LOGO LS TEE TAN
57291 FOG ESSENTIALS FRONT LOGO LS TEE CREAM
57365 MISHKA M21000001 L/S T-Shirt WHITE
60497 Subciety (サブサエティ) SUEDE SWITCHED L/S NAVY
62623 LONELY論理 NEW LOGO LONG SLEEVE PURPLE
62624 LONELY論理 NEW LOGO LONG SLEEVE BLACK
62626 LONELY論理 LONELISM6 LONG SLEEVE SAX
62628 LONELY論理 LONELISM6 LONG SLEEVE BLACK
60322 CIVARIZE【シヴァーライズ】モノトーン総柄ビッグロンT CV21-B06 WHITE
60797 MAGICAL MOSH MISFITS EVANGELION x MxMxM “MxMxM 2号機” LONG TEE REAL
66481 MAGICAL MOSH MISFITS EVANGELION キン肉マン x MxMxM “ドクロビン” LONG TEE BLACK
59069 Subciety (サブサエティ) RAGLAN L/S - BLACK
59071 Subciety (サブサエティ) RAGLAN L/S - BEIGE
61239 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション NIRVASH L/S BLACK
63605 glamb (グラム) Belivers Long Sleeve T - Black
59550 Zephyren(ゼファレン) JACQUARD CUT L/S WHITE
59551 Zephyren(ゼファレン) JACQUARD CUT L/S BLACK
59553 Zephyren(ゼファレン) JACQUARD CUT L/S GREEN / MIX
60356 RUDIE'S (ルーディーズ) GOOD VIBRATION LS-T GRADATION LOGO LAVENDER
60415 MUSIC SAVED MY LIFE (MSML) OVERSIZED GRAPHIC LONG SLEEVE TEE WHITE
65797 RUDIE'S (ルーディーズ) BRINK PHAT LS-T-WHITE
43499 NOT COMMON SENSE FRANKEN 2 L/S TEE WHITE
46185 NOT COMMON SENSE MAD DOG LAYERED L/S TEE WHITE×RED
61564 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - WHITE
59603 Zephyren(ゼファレン) BIG L/S TEE - jua - WHITE
65165 Subciety (サブサエティ) NOVEL GLORIOUS TEE-GRAY/BLACK
65167 Subciety (サブサエティ) NOVEL GLORIOUS TEE-BLACK/KHAKI
65170 Subciety (サブサエティ) NOVEL GLORIOUS TEE-WHITE/GREEN
60422 GALFY (ガルフィー) わんわん大学ロンTee T.GRAY
61252 TRAVAS TOKYO【トラバストーキョー】クラウンキャットプリント ロングスリーブカットソー WHITE
60417 MUSIC SAVED MY LIFE (MSML) ANGER LONG SLEEVE TEE
51151 VIRGO VG-CUT-398 CRUST LINKS BLACK
61132 Subciety (サブサエティ) SABBAT13 × Subciety L/S BLACK
61133 Subciety (サブサエティ) SABBAT13 × Subciety L/S WHITE
62617 CIVARIZE【シヴァーライズ】 ZIPデザインモードロンT BLACK
65381 Subciety (サブサエティ) G.I SIGN L/S BLACK
67442 TOY MACHINE (トイマシーン) FLAME FIST LONG TEE BLACK
58319 SLEEPING TABLET GRRL [ MULTI BORDER LONG SLEEVE ] BLUE
61712 HEDWiNG College logo C/C Longsleeve T-shirt Navy
60543 ROLLING CRADLE COSPLAY GIRL-MOON- LONG SLEEVE / WHITE
56161 MUSIC SAVED MY LIFE (MSML) BOX LOGO LONG SLEEVE TEE PURPLE
56162 MUSIC SAVED MY LIFE (MSML) MSML GRAPHIC LONG SLEEVE TEE BLACK
58488 SILLENT FROM ME FILLM -Loose Long Sleeve- BLACK
59018 Nine Microphones EMERGE L/S - WHITE
59230 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE LS TEE BLACK×RED
60749 HYPER CORE L-130 DID YOU GET THE VACCINE?ロングスリーブTシャツ ブルー
62786 GoneR GR32LS002 Fire Pattern L/S T-Sirts Black/Red
63836 アマツカミ 棘文字 L/S T-shirts
63837 アマツカミ 棘/Thorn L/S T-shirts
64360 DI:VISION (ディヴィジョン) FICTION LS TEE CHACOAL
65795 アマツカミ 藤/wisteria L/S T-shirts
57395 FILA FS3020 L/S T-Shirt BLACK
62132 ROLLING CRADLE SMILE LONG SLEEVE WHITE
64118 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ LONG SLEEVE ] BLACK
57128 SABBAT13 SPOOK INSIDE L/S T BLUE
57133 SABBAT13 HIDE&SEEK L/S T WHITE
58803 HYPER CORE SAUSE ロングスリーブTシャツ BLACK×GREEN
58804 HYPER CORE CROISSANT ロングスリーブTシャツ YELLOW
57995 GoneR GR28LS002 Rose Arrange Skull L/S T-Shirts White
40852 REBEL8 111030027 KEEPERS OF THE EIGHT CREWNECK BLK
56156 MUSIC SAVED MY LIFE (MSML) BANDANA LONG SLEEVE SLIT CUTSEW BLACK
57810 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×BLACK
61216 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO KENNY LONG TEE - WHITE
61218 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - WHITE
58024 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - WHITE
60040 HEDWiNG Right or wrong Longsleeve T-shirt White
62537 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - WHITE
56048 KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(Wht)
61366 SLEEPING TABLET (スリーピングタブレット) ORDER [ LONG SLEEVE ] WHITE
61741 東京13零式 (トウキョウイチサンゼロシキ) T-Shirt 狗吠 Smoky Purple
61714 HEDWiNG One stroke owl Longsleeve T-shirt Stone blue
64433 PUNK DRUNKERS [PDSx高須クリニック]YES!高須クリニックロンTEE - BEIGE
57255 ガリュウホンポ 子猫ロングTシャツ
63660 Gluttonous Slaughter The MONARCH OF UNHOLY CAT Long Sleeve / 邪悪なる猫の君主
50646 CHORD NUMBER EIGHT CH01-01K5-CL03 LONG CUTSEW BLACK
56017 ドラマストア×GEKIROCK CLOTHING 限定コラボ・ロンT WHITE
56018 ドラマストア×GEKIROCK CLOTHING 限定コラボ・ロンT BLACK
56125 N.B.O. SPHERE PRINT T
56126 N.B.O. WASH UFO T
56171 HEDWiNG HD-012 Pierrot Mask Longsleeve T-shirt Purple
58333 RUDIE'S (ルーディーズ) DRAWING LS-T WHITE
58337 RUDIE'S (ルーディーズ) GOOD VIBRATION LS-T BLACK
60051 SAMURAI CORE サイコLS TEE BLACK
60053 SAMURAI CORE コラージュLS TEE BLACK
60357 RUDIE'S (ルーディーズ) GOOD VIBRATION LS-T GRADATION LOGO BEIGE
60359 RUDIE'S (ルーディーズ) PHAT LS-T BLACK
61438 glamb (グラム)×攻殻機動隊 SAC_2045 long sleeve CS White
61484 glamb (グラム) Cactus Print Raglan CS WINE
62171 KILL STAR Deimos Long Sleeve Top
62941 RUDIE'S (ルーディーズ) SAFARI PHAT LS-T BLACK
62942 RUDIE'S (ルーディーズ) VITAMIN PHAT LS-T BLACK
55947 TOY MACHINE FIST EMBROIDERY LONG TEE - WHITE
60296 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - WHITE
61563 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - BLACK
61565 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - GREEN
63176 DI:VISION (ディヴィジョン) WYRM LS TEE WHITE
65682 SABBAT13(サバトサーティーン) SCAPEGOAT L/S T BLACK
57198 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” LONG TEE BLUE
62788 GoneR (ゴナー) GR32LS003 Tie-dye One Point Logo L/S T-Sirts White