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-20 22:22:15')
AND pc.price03 IS NOT NULL
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 240, 120
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
63184 RUDIE'S (ルーディーズ) HELLO-T BLACK
61918 glamb (グラム) Collaged Posters T - Black
61919 glamb (グラム) Collaged Posters T - White
60083 NieR (ニーア) GRAPHIC CUTSEW【NieRちゃん】
63661 Gluttonous Slaughter THE MONARCH OF UNHOLY CAT T-shirt / 邪悪なる猫の君主
64853 Wall Of Graphic(ウォールオブグラフィック)Ash Tシャツ
53145 SAMURAI CORE 地震ー雷ー火事ーオヤジ TEE BLACK
54528 SAMURAI CORE SR-TE-004C GIVE IT こけしTEE BLACK
54158 GoneR Thunderbird T-Shirts Black
55555 PSYCHOLOGICAL METAMORPHOSIS WIRE SS TE BURGANDY
57983 GoneR GR28CT001 Rose Hand T-Shirts Dark Chocolate
59064 Subciety (サブサエティ) cardinal S/S - WHITE
59099 PSYCHOLOGICAL METAMORPHOSIS BOX LOGO TEE TURQUOISE
59100 PSYCHOLOGICAL METAMORPHOSIS BOX LOGO TEE BLACK
59113 MAGICAL MOSH MISFITS ポちゃんバーガー TEE REAL
59114 MAGICAL MOSH MISFITS ポちゃんバーガー TEE PINK
59309 PSYCHOLOGICAL METAMORPHOSIS INVERSION LOGO TEE OLIVE
59866 PSYCHOLOGICAL METAMORPHOSIS NOT TEE PURPLE
63134 【予約商品】PSYCHOLOGICAL METAMORPHOSIS CS RINGER TEE - BLACK
63246 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) TOY TOY どろ~ん TEE RED
63249 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) マジカルドットキノコ TEE RED
63874 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) メラメラモッシュミスフィッツ TEE PURPLE
63876 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL 工具 MISFITS TEE (DRY) GREEN
60762 ガリュウホンポ 四角オーバーサイズカットソー
53029 SABBAT13 HODGE PODGE T BLACK
54186 Subcietyx攻殻機動隊SAC_2045 Major S/S WHITE
54423 【BTS着用モデル】 FILA FFM9357 T-shirts Turquoise
54427 【BTS着用モデル】 FILA FFM9357 T-shirts Navy
56326 NineMicrophones NM/CS S/S BURGUNDY
57323 Subciety×仮面ライダードライブ DRIVE S/S RED
58034 TOY MACHINE MONSTER 3/4 SLEEVE TEE-BLACK
58464 NARUTO-ナルト- 疾風伝 ×Subciety SASUKE S/S BLACK
58573 MISHKA(ミシカ) M21000005 T-Shirt
60171 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE BLACK
60172 MISHKA X DENNIS THE MENACE DENNIS TEE WHITE
60602 RIPNDIP Logo Embroidered Tee (Natural Speckle)
61816 MISHKA (ミシカ) M21100053 T-SHIRT BLACK
62121 STAPLE×Hello Kitty Worldwide Tee HEATHER GRAY
65314 ZERO EVOKE Spider Tee 【WHITE】
60234 NieR (ニーア) LOGO刺繍CUTSEW【BEIGE】
58325 THRASHER (スラッシャー) TH91291 40TH T-SHIRT BEIGE
58661 MAGICAL MOSH MISFITS おすし TEE ドクロ
63094 MAGICAL MOSH MISFITS MxMxM DOKURO TEE
60241 acOlaSia FRIDAY BACK PRINT TEE BLACK
60243 acOlaSia I DON'T GIVE A SHIT TEE BLACK
60244 acOlaSia I DON'T GIVE A SHIT TEE WHITE
60248 acOlaSia NEXT IS YOU TEE WHITE
61718 HEDWiNG Crayon Flower Pocket T-shirt Oatmeal
59282 ROLLING CRADLE PEEPS TEE / EMERALD
60716 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / EMERALD
63778 DXMOUVE(ドゥモーヴェ) 臓器の観客柄 半袖カットソー グレー
35581 BRING ME THE HORIZON SHADOW MOSES
36659 FOO FIGHTERS OUTLINED
55901 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS WHITE
56422 Subciety (サブサエティ) LABO. S/S - WHITE
58743 アマツカミ 伽話/FIGMENT T-shirts
58764 SILLENT FROM ME WORDS WHITE
61700 Subciety (サブサエティ) BOOTLEG BRAND S/S BLACK
62172 KILL STAR Deimos T-Shirt
63203 Subciety (サブサエティ) DOUGH BOY TEE BLACK
63204 Subciety (サブサエティ) TAG S/S WHITE
63206 Subciety (サブサエティ) TAG S/S BLACK/ORANGE
63207 Subciety (サブサエティ) CAN TEE WHITE