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 =1
)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-21 05:21:07')
AND pc.price02 > 909
AND price02 <= 2727
AND pc.price03 IS NOT NULL
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
61371 SLEEPING TABLET (スリーピングタブレット) TABLETS [ TEE ] BLUE
55806 SUBLIME×SULLEN LIVIN DIZZY STANDARD Tee
57469 Zephyren(ゼファレン) DOLMAN BIG TEE S/S BLACK / NEVER say NEVER
57484 Zephyren(ゼファレン) DOLMAN BIG TEE S/S - 冥 - BLACK
59956 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA chaos LOGO TEE PEPPER BLACK
59957 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA MEZAME NO ANIME GIRL TEE WHITE
59985 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA 黄緑 繭子 炎上 TEE BLACK
63428 ZENON(ゼノン) Simple logo S/S big tee WHITE/BLACK
64259 RIPNDIP (リップンディップ) Beach Boys Tee (Purple Mineral Wash)
64857 Wall Of Graphic(ウォールオブグラフィック)Four Tシャツ
58809 HYPER CORE Dark cherry with Poison girl FrappuccinoグラフィックジップTシャツ
58810 HYPER CORE CROISSANT グラフィックジップTシャツ
58811 HYPER CORE PINK SNIPER グラフィックジップTシャツ
58812 HYPER CORE SAUCE グラフィックジップTシャツ
59843 HYPER CORE T-367 承認欲求がぁる2 -I need your Reply, Retweet & いいね- Tシャツ ホワイト×レッド
64265 RIPNDIP (リップンディップ) Summer Splash Tee (Black)
69069 NieR (ニーア) BACK DESIGN CUTSEW【NIER VIAL】
55653 THRASHER (スラッシャー) TH91214US FLAME OUTLINE S/S T-SHIRTS BLACK/YELLOW
55962 火寺企画 チャイナガールTシャツ BLACK
58078 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN MICROPHONE-T ORANGE
58081 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN FAMILY-T BLACK
58609 SLEEPING TABLET SAD [ TEE ] BLACK
58629 MISHKA SPOOKY CREW TEE BLACK
58666 KILL STAR CLOTHING Stay Weird T-Shirt White
58788 HYPER CORE PINK SNIPER Tシャツ PURPLE
60268 MISHKA M61000056 T-SHIRT BLACK
62613 NineMicrophones Chug S/S WHITE
62614 NineMicrophones Chug S/S BLACK
62615 NineMicrophones Chug S/S BURGUNDY
62674 PUNK DRUNKERS (パンクドランカーズ) メニメニプリントTEE - D.H.NAVY
62804 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN BENISASORITAI TEE BLACK
62807 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN LOCALFEST TEE WHITE
62808 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN LOCALFEST TEE BLACK
63433 ZENON(ゼノン) Front embroidery S/S big tee WHITE
64199 Subciety (サブサエティ) MARIA TEE WHITE/GOLD
64355 DI:VISION (ディヴィジョン) UN-ARMED Tee WHITE
64867 HYPER CORE(ハイパーコア) MELON PAIN Tシャツ WHITE
64871 HYPER CORE(ハイパーコア) TROPICAL BEAR Tシャツ YELLOW
65020 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (SMOKE)
58155 TOY MACHINE (トイマシーン) TURTLEBOY T-Shirt WHITE
60596 RIPNDIP Not Today Tee White
63004 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - WHITE
63008 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - SAND
63009 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - BLACK
54125 ROLLING CRADLE JUDGEMENT BIG TEE
57141 SABBAT13 HIDE&SEEK T BLACK
57142 SABBAT13 HIDE&SEEK T WHITE
57151 SABBAT13 CREEPY BIG T BEIGE
58555 SABBAT13 MALUS T コーラルベージュ
58557 SABBAT13 SUPPER T ベージュ
58559 SABBAT13 WIND PRANK T ブラック
58790 HYPER CORE ADDICT Tシャツ
59145 ROLLING CRADLE LIP RINGER TEE BLACK
59146 ROLLING CRADLE LIP RINGER TEE GRAIGE
59938 PUNK DRUNKERS [PDSxSONIC]ソニック総柄TEE - LT.BLUE
60104 LONELY論理 ASKA FUTATABI T-SHIRTS PURPLE
60952 PUNK DRUNKERS [PDSx太鼓の達人]太鼓マスターTEE - SUMI
62665 PUNK DRUNKERS[PDSxCOCALERO]八福神TEE - H.BLACK
62667 PUNK DRUNKERS[PDSxホープ軒]元祖背脂TEE - YELLOW
64911 THRASHER (スラッシャー)×TURTLES T-shirt WHITE
64912 THRASHER (スラッシャー)×TURTLES T-shirt BLUE
62677 PUNK DRUNKERS (パンクドランカーズ) サスペンダーTEE - WHITE
62678 PUNK DRUNKERS (パンクドランカーズ) サスペンダーTEE - BLACK
62684 PUNK DRUNKERS (パンクドランカーズ) カミナリBIG.TEE - BLACK
62686 PUNK DRUNKERS (パンクドランカーズ) うさちゃんBIG.TEE - D.BLUE
62687 PUNK DRUNKERS (パンクドランカーズ) うさちゃんBIG.TEE - LT.PINK
62116 ROLLING CRADLE Mjolnir TEE / WHITE
54947 PARADOX PX17-BT01 GRAPHIC BIG T-SHIRTS(NEVER SATISFIED) BLACK
54949 PARADOX PX17-BT02 GRAPHIC BIG T-SHIRTS(STAY DIFFERENT) BLACK
57985 GoneR GR28CT002 Tie-dye Line T-Shirts White
57988 GoneR GR28CT002 Tie-dye Line T-Shirts Dark Chocolate
58157 TOY MACHINE MONSTER T-Shirt BLACK
58159 TOY MACHINE MONSTER T-Shirt WHITE
58299 KILL STAR CLOTHING Unholy Sabbath T-Shirt
58700 GoneR GR29CT003 Rose Messege T-Shirts White
58701 GoneR GR29CT003 Rose Messege T-Shirts Stone
59111 MAGICAL MOSH MISFITS RATFINK x MxMxM "MAGICAL MOSH RATFINK" TEE GRAY
62840 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. TEE 04 - TURQUOISE
62874 PSYCHOLOGICAL METAMORPHOSIS 4 SEASONS TEE - BLACK
62875 PSYCHOLOGICAL METAMORPHOSIS 4 SEASONS TEE - WHITE
63177 THRASHER (スラッシャー) Godzilla Flame T-shirt Black
63178 THRASHER (スラッシャー) Mexico Revista T-shirt Black
64145 SABBAT13(サバトサーティーン) GOD T (PK)
64148 SABBAT13(サバトサーティーン) STORY TELLING T (BG)
64149 SABBAT13(サバトサーティーン) STORY TELLING T (KH)
65014 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (BG)
65021 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (GR)
65605 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (WH)
26143 ARCHITECTS Coffin
54834 RIP DESIGN WORXX MIMIC MASKEDホッケーTシャツ WHITE
54835 RIP DESIGN WORXX MIMIC MASKEDホッケーTシャツ RED
56681 PUNK DRUNKERS PT.TEE - BLACK
60973 PUNK DRUNKERS SHARK.TEE - ASH
60976 PUNK DRUNKERS PUNKS BAND.TEE - BLACK
60977 PUNK DRUNKERS PUNKS BAND.TEE - SUMI
62691 PUNK DRUNKERS (パンクドランカーズ) アーポくんTEE - SUMI
62692 PUNK DRUNKERS (パンクドランカーズ) あいつ遊泳TEE - WHITE
62694 PUNK DRUNKERS 餅つきTEE - BLACK
62695 PUNK DRUNKERS 餅つきTEE - BLUE
62711 PUNK DRUNKERS べちゃロゴTEE / O.Fシリーズ - BLUE
62712 PUNK DRUNKERS べちゃロゴTEE / O.Fシリーズ - A.GREEN
58716 GoneR -La Neta- GRL04CT001 Mexican Flag T-Shirts White
58721 GoneR -La Neta- GRL04CT001 Mexican Flag T-Shirts Black
58722 GoneR -La Neta- GRL04CT002 LUZ Y SOL T-Shirts White
63304 GoneR (ゴナー) GR33CT001 Rose Maria T-Sirts Black
58408 RUDIE'S (ルーディーズ) GUESTPASS-T BLACK
58410 RUDIE'S (ルーディーズ) GOOD VIBRATION BIGSILHOUETTE PKT-T BLACK
58411 RUDIE'S (ルーディーズ) PHAT BIGSILHOUETTE-T WHITE
59217 LONELY論理 BLUE EYEZ TEE black
59218 LONELY論理 BLUE EYEZ TEE white
59234 LONELY論理 LONELY UNIV TEE pink
59236 LONELY論理 LONELY UNIV TEE purple
60029 SUPPLIER (サプライヤー) ANGEL TEE CHARCOAL
60107 LONELY論理 ANTI V.A T-SHIRTS BLACK
60260 RUDIE'S (ルーディーズ) SLICK BIGSILHOUETTE-T BLACK
60343 RUDIE'S (ルーディーズ) VITAMIN PHAT-T WHITE
61104 VIRGO PERFECTION 22(BIG) WHITE
61105 VIRGO PERFECTION 22(BIG) BLUE
61106 VIRGO PERFECTION 22(BIG) BLACK
63137 RUDIE'S (ルーディーズ) DONUTS PHAT-T BLACK