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-25 00:06:57')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
60216 NieR (ニーア) 超BIG SILHOUETTE CUTSEW【和柄九尾】
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
41049 OBEY x Misfits Legacy of Phenome Heavyweight Box Tee BLACK
41050 OBEY x Misfits Legacy of Phenome Heavyweight Box Tee TAPE
41051 OBEY x Misfits Legacy of Phenome Heavyweight Box Tee WHITE
41052 OBEY x Misfits Fiend Rocker Basic Tee RED
41053 OBEY x Misfits Fiend Rocker Basic Tee WHITE
41054 OBEY x Misfits Fiend Rocker Basic Tee BLACK
54718 PUNK DRUNKERS なにわボーダーTEE 細ボーダー
54719 PUNK DRUNKERS なにわボーダーTEE 太ボーダー
54720 PUNK DRUNKERS JACKあいつBIG.TEE BLACK
54721 PUNK DRUNKERS JACKあいつBIG.TEE WHITE
56671 PUNK DRUNKERS リアルあいつTEE - CORAL
58212 PUNK DRUNKERS りんごTEE - WHITE
58213 PUNK DRUNKERS りんごTEE - BLACK
62679 PUNK DRUNKERS (パンクドランカーズ) サスペンダーTEE - ORANGE
58841 NieR (ニーア) 超BIG SILHOUETTE CUTSEW 彼岸花水色
60463 NieR (ニーア) BACK RABBIT CHECKERED CUTSEW 【RED PINK】
65536 NieR (ニーア) NieRちゃん×CROSS×LOGO総柄CUTSEW
68306 NieR (ニーア) SUPER OVER SIZE CUTSEW
69071 NieR (ニーア) 超BIG SILHOUETTE CUTSEW【WHITE CRASH】
69096 NieR (ニーア) 迷彩ミケ 超BIG SILHOUETTE CUTSEW
69097 NieR (ニーア) 超BIG SILHOUETTE RED CUTSEW 【WHITE×RED】
67643 PUNK DRUNKERS(パンクドランカーズ)コミカルブラザーズBIG.TEE - BLACK
67644 PUNK DRUNKERS(パンクドランカーズ)コミカルブラザーズBIG.TEE - S.PURPLE
69884 PUNK DRUNKERS(パンクドランカーズ) サメンチュの休日BIG.TEE - WHITE
69888 PUNK DRUNKERS(パンクドランカーズ) 毒キノコTEE - D.BLUE
69889 PUNK DRUNKERS(パンクドランカーズ) 毒キノコTEE - S.PINK
70992 【予約商品】PUNK DRUNKERS NONフィクションBIG.TEE - WHITE
54433 THRASHER OUTLINED CRACK S/S T-SHIRTS BLACK
58838 NieR (ニーア) 総柄 CUTSEW butterfly
63328 Meltyglow (メルティグロウ) 総柄半袖PARKA【Fall melty】
65539 NieR (ニーア) 超OVERSIZE SILHOUETTE CUTSEW【FIRE×HEART】
68041 NieR (ニーア) フード付き半袖PARKA【ぐれまる】
68892 FACT101(ファクト・イチマルイチ) 「SMG」 Tシャツ_Black
68893 FACT101(ファクト・イチマルイチ) 「SMG」 Tシャツ_White
55735 Anti Social Social Club ASHTON BLACK TEE
68358 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) HELLO KITTY x MxMxM “スケボー” TEE White
68359 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) HELLO KITTY x MxMxM “ともだち” TEE Mint
68360 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) HELLO KITTY x MxMxM “ともだち” TEE Black
14114 SLIPKNOT SICKNESS TEE
17730 METALLICA KILL EM ALL ALL OVER TEE
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
27639 ANIMALIA AN16A-TE02 AA FLAG WHITE
35669 BULLET FOR MY VALENTINE Werewolf all over print t-shirt
36268 THRASHER THSR-SST01 BLK
53032 SABBAT13 FRIEND T PURPLE
53033 SABBAT13 FRIEND T WHITE
53040 SABBAT13 PARADISE T BLACK
53041 SABBAT13 PARADISE T BURGANDY
53042 SABBAT13 CASKET T BLACK
53044 SABBAT13 SKATE HAND T BLACK
53051 SABBAT13 PENNYWISE T YELLOW
53052 SABBAT13 PENNYWISE T BLACK
53053 SABBAT13 PENNYWISE T WHITE
53099 PUNK DRUNKERS [PDS×仮面ライダー]仮面ライダーゼロワンTEE INDIGO
53102 PUNK DRUNKERS [PDS×仮面ライダー]仮面ライダーゼロワンTEE WHITE
54064 PUNK DRUNKERS [PDSxくっきー!]ミスティTEE - BLACK
54065 PUNK DRUNKERS [PDSxくっきー!]ミスティTEE - KHAKI
54111 SABBAT13 SKATE HAND T WHITE
54112 SABBAT13 CASKET T LAVENDER
54113 SABBAT13 BLESSING T BLACK
54114 SABBAT13 BLESSING T TURQUOISE
55309 NieR (ニーア) BIG SIZE YELLOW OFF-SHOULDER TOPS【リボン付き】
56664 PUNK DRUNKERS グレイトフルマッポ刺繍TEE - GREEN
56665 PUNK DRUNKERS グレイトフルマッポ刺繍TEE - PURPLE
57135 SABBAT13 SPOOK INSIDE T BLACK
57137 SABBAT13 SPOOK INSIDE T TURQUOISE
57143 SABBAT13 HIDE&SEEK T MINT
57144 SABBAT13 GHOSTLY T BLACK
57145 SABBAT13 GHOSTLY T WHITE
57146 SABBAT13 GHOSTLY T GOLD
57149 SABBAT13 CREEPY BIG T BLACK
57150 SABBAT13 CREEPY BIG T WHITE
57236 BRING ME THE HORIZON UNISEX TEE: HEX PHSH COVER (BACK PRINT)
57237 BRING ME THE HORIZON UNISEX TEE: LOVE (BACK PRINT)
57238 BRING ME THE HORIZON UNISEX TEE: THE END (BACK PRINT)
57239 BRING ME THE HORIZON UNISEX TEE: WIPE THE SYSTEM (BACK PRINT)
57270 BRING ME THE HORIZON UNISEX TEE: FLOWERS (BACK PRINT)
58063 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT
58064 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TILT
58065 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TAPED
58066 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT PHOTO
58183 PUNK DRUNKERS [PDSxぷよぷよ]あいつぷよTEE - BLACK
58184 PUNK DRUNKERS [PDSxぷよぷよ]あいつぷよTEE - A.GREEN
58551 SABBAT13 AMBITION T ブラック
58552 SABBAT13 AMBITION T ホワイト
58554 SABBAT13 MALUS T ホワイト
58556 SABBAT13 SUPPER T ブラック
58558 SABBAT13 SUPPER T オリーブ
58561 SABBAT13 LOST PARADISE T ブラック
58563 SABBAT13 GLUTTONY T ブラック
58564 SABBAT13 GLUTTONY T ホワイト
58791 HYPER CORE ぴえん。Tシャツ WHITE
58792 HYPER CORE PINK MAID RABBIT Tシャツ BLACK
58806 HYPER CORE ぴえん。Tシャツ BLACK
58807 HYPER CORE PINK MAID RABBIT Tシャツ WHITE
58816 HYPER CORE デスメンタルTシャツ WHITE
58817 HYPER CORE デスメンタルTシャツ PURPLE
58818 HYPER CORE デスメンタルTシャツ RED
60953 PUNK DRUNKERS [PDSx太鼓の達人]太鼓マスターTEE - D.GREEN
60954 PUNK DRUNKERS [PDSx中華蕎麦とみ田]衣食TEE - BLACK
60955 PUNK DRUNKERS [PDSx中華蕎麦とみ田]衣食TEE - SLATE
60956 PUNK DRUNKERS [PDSxチャーミーちゃん]チャーミーちゃんとアイツBIG.TEE - BLACK
60957 PUNK DRUNKERS [PDSxチャーミーちゃん]チャーミーちゃんとアイツBIG.TEE - LT.PINK
62661 【予約商品】PUNK DRUNKERS[PDSxデヴィ・スカルノ]夫人からあいつTEE - BLACK
62662 PUNK DRUNKERS (パンクドランカーズ) [PDSxデヴィ・スカルノ]夫人からあいつTEE - M.GREEN
62666 PUNK DRUNKERS[PDSxCOCALERO]八福神TEE - D.GREEN
63186 ANIMALIA (アニマリア) SLUB Tee S/S - logo WHITE
64914 ANIMALIA (アニマリア) SCRIPT WHITE
64915 ANIMALIA (アニマリア) SCRIPT BLACK
64916 ANIMALIA (アニマリア) TITLE WHITE
64917 ANIMALIA (アニマリア) TITLE BLACK
65518 NieR (ニーア) FRILLED SLEEVES TEE
68238 TOY MACHINE (トイマシーン) SLING SHOT SS TEE WHITE
68239 TOY MACHINE (トイマシーン) SLING SHOT SS TEE BLACK
68240 TOY MACHINE (トイマシーン) SLING SHOT SS TEE PURPLE
68241 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE BLACK
68242 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE L. YELLOW
68243 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE WHITE