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 =588
)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-01 14:48:59')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 360, 120
45934 RUDIE'S COLLEGE HALFZIPHOOD SWEAT BLACK
45935 RUDIE'S COLLEGE HALFZIPHOOD SWEAT GRAY
45936 RUDIE'S COLLEGE HALFZIPHOOD SWEAT BLUE
49657 MISHKA MAW190471 HOOD SAX
49776 MISHKA MAW190444 Pullover Purple
49777 MISHKA MAW190444 Pullover Black
50286 HEDWiNG Cross Cut Hoodie type C
50287 HEDWiNG Cross Cut Hoodie type D
50376 Zephyren(ゼファレン) DOLMAN BIG PARKA BLACK
50384 Zephyren(ゼファレン) DOLMAN BIG PARKA WHITE
50386 Zephyren(ゼファレン) TAPE BIG PARKA NAVY
50387 Zephyren(ゼファレン) TAPE BIG PARKA WHITE
50670 Subciety (サブサエティ) BOA PARKA IVORY
50750 LILWHITE(dot) LW-19AW-S01 "TM" HOODIE (LIME)
50751 LILWHITE(dot) LW-19AW-S01 "TM" HOODIE (PPL)
50752 LILWHITE(dot) LW-19AW-S04 "FATALITY" HOODIE (ORG)
51296 DOPE Core-Teck Pleated Pullover S.Green
51297 DOPE Core-Teck Pleated Pullover BLACK
51868 Zephyren(ゼファレン) SWITCHING PARKA BLACK / WHITE
51869 Zephyren(ゼファレン) SWITCHING PARKA NAVY / RED
52495 SALUTE REMADE HOODIE
52496 SALUTE DOUBLE LAYER HOODIE
52583 REBEL8 Your Enemies Are Mine Pullover Hoodie
52957 RIPNDIP Catch Em All Hoodie (Tan)
55015 Zephyren(ゼファレン)LINE PARKA - Resolve - BLACK
55017 Zephyren(ゼファレン)LINE PARKA - Resolve - MUSTARD
55019 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - BLACK
55020 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - GREEN
55021 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - MUSTARD
56020 Subciety (サブサエティ) HALF ZIP BOA PARKA BLACK
56118 SILLENT FROM ME EVIDENCE Plain Parka BLK
56119 SILLENT FROM ME EVIDENCE Plain Parka WHT
56178 MISHKA(ミシカ) MAW200406 HOODIE BLACK
56179 MISHKA(ミシカ) MAW200406 HOODIE WHITE
56180 MISHKA(ミシカ) MAW200405 HOODIE BLACK
56181 MISHKA(ミシカ) MAW200405 HOODIE BEIGE
56829 Subcietyx攻殻機動隊 CONNECT PULLOVER PARKA BLACK
56830 Subcietyx攻殻機動隊 SECTION9 PULLOVER PARKA BLACK
56833 Subcietyx攻殻機動隊 SECTION9 PULLOVER PARKA GRAY
56834 Subcietyx攻殻機動隊 CONNECT PULLOVER PARKA GRAY
56836 Subcietyx攻殻機動隊 SECTION9 PULLOVER PARKA KHAKI
56837 Subcietyx攻殻機動隊 CONNECT PULLOVER PARKA KHAKI
56855 ANIMALIA AN20A-SW09 Cross-Neck Heavy Oz Hoodie BLACK
56856 ANIMALIA AN20A-SW09 Cross-Neck Heavy Oz Hoodie GRAY
56912 RUDIE'S 2021 NEW YEAR PACK
57332 Subciety×仮面ライダードライブ MACH PARKA WHITE
58327 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO INDIGO
58328 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO L.BLUE
58450 Subciety (サブサエティ)×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA BLACK
58451 Subciety ×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA GRAY
59014 Subciety (サブサエティ) PIGMENT PARKA - RED
59517 Zephyren(ゼファレン) DOLMAN BIG PARKA BLUE / Creux
59518 Zephyren(ゼファレン) DOLMAN BIG PARKA RED / Creux
60501 Subciety (サブサエティ) Layered PARKA BLACK
60502 Subciety (サブサエティ) SEA OTTER PARKA BEIGE
60507 ANIMALIA AN21A-SW04 CROSS-NECK HEAVY OZ HOODIE GRAY
60508 ANIMALIA AN21A-SW04 CROSS-NECK HEAVY OZ HOODIE NAVY
60559 MISHKA M61000418 HOODE BEIGE
61276 LONELY論理 3EMBROIDERY HOODIE GRAY
61635 STAPLE×Sesame Street Crew Hoodie
61636 STAPLE×Sesame Street Oscar Hoodie
62119 STAPLE×Hello Kitty Friends Hoodie GRAY
63557 glamb (グラム) Bizarre Cord Hoodie - Black
66203 ANIMALIA (アニマリア) CUT-OFF HOODIE BLACK
66204 ANIMALIA (アニマリア) CUT-OFF HOODIE GRAY
66676 Subciety (サブサエティ) SIDE BLEACH PARKA BLACK
66677 Subciety (サブサエティ) SIDE BLEACH PARKA GREEN
66678 Subciety (サブサエティ) SIDE BLEACH PARKA PURPLE
66723 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise PARKA OATMEAL
66725 Zephyren (ゼファレン)×優里×原 愛梨 約束 / Promise PARKA BLACK
66856 RIPNDIP (リップンディップ) Ripnlit Hoodie Charcoal Faded Wash
68060 プランクスターズ×GALFYコラボ・パーカー BLACK
68061 プランクスターズ×GALFYコラボ・パーカー WHITE
68098 プランクスターズ×GALFYコラボ・パーカー PURPLE
68526 RIPNDIP (リップンディップ) Shock Hoodie BLACK
68534 RIPNDIP (リップンディップ) Rubber Logo Hoodie PACIFIC BLUE
69519 SABBAT13(サバトサーティーン) DEATH HAWK HOODIE BLACK
69520 SABBAT13(サバトサーティーン) DEATH HAWK HOODIE ASH
69521 SABBAT13(サバトサーティーン) DEATH HAWK HOODIE SAND
69593 RIPNDIP (リップンディップ) SUSHI NERM HOODIE (SANDSTONE)
69594 RIPNDIP (リップンディップ) VAN NERMAL HOODIE (BLACK)
70368 Appare!×GALFY×GEKIROCK CLOTHING コラボ・パーカー
70570 RIPNDIP (リップンディップ) IN LOVING MEMORY HOODIE
70571 RIPNDIP (リップンディップ) NERVOUS SYSTEM HOODIE
70582 over print (オーバープリント) Rebirth shirts etc A-2
70593 over print (オーバープリント) Rebirth shirts etc A-3
71452 【予約商品】 椎名 立希×AILE VIVANTES コラボ限定プルオーバーパーカー
44882 RIPNDIP Money Talks Hoodie (Light Pink)
44883 RIPNDIP Won't Be Ok Hoodie (Navy)
25422 SQUARE (スクエア) ALOHA 13 4/3 HOODY NAVY
25423 SQUARE (スクエア) ALOHA 13 4/3 HOODY GREY
27361 SQUARE SAINT&SINNER 4/3 HOODY
28764 VIRGO CARPE DIEM ZIP PARKA NAVY
40557 SABBAT13 S-BONE BIG HOODIE ORANGE
40558 SABBAT13 S-BONE BIG HOODIE BLACK
51239 SAMURAI CORE SR-PK-07-B PUNK侍 pk white
51240 SAMURAI CORE SR-PK-07-B PUNK侍 pk black
51241 SAMURAI CORE SR-PK-07-B PUNK侍 pk turquoise
51242 SAMURAI CORE SR-PK-07-B PUNK侍 pk pink
51243 SAMURAI CORE SR-PK-07-B PUNK侍 pk yellow
51245 SAMURAI CORE SR-PK-08-B BURST CITY pk pink
51246 SAMURAI CORE SR-PK-08-B BURST CITY pk yellow
53110 SAMURAI CORE 夜露死苦哀愁 HOODIE BLACK
53111 SAMURAI CORE 夜露死苦哀愁 HOODIE WHITE
53112 SAMURAI CORE 夜露死苦哀愁 HOODIE RED
54744 Dezzn Oversized Hooded T-Shirt Black
58369 WASTED PARIS Hoodie Essential Black
59418 SUPPLIER (サプライヤー) Fire Logo Hoodie BEIGE
59419 SUPPLIER (サプライヤー) Fire Logo Hoodie BLACK
67437 TRAVAS TOKYO【トラバストーキョー】 Lil bear hoodie BLACK
69238 THRASHER (スラッシャー) Inferno Hoodie NAVY BLUE
69239 THRASHER (スラッシャー) Jake Dish Hoodie BLACK
69240 THRASHER (スラッシャー) Outlined Chest Logo Hoodie GRAY
60586 RIPNDIP Bubble Sherpa Hoodie (Pink)
47322 RIPNDIP Taped Hoodie (Tan)
47324 RIPNDIP Rubber Logo Hoodie (Orange)
47325 RIPNDIP Multi Hoodie (White)
47649 RIPNDIP RIPNTAIL Hoodie (Royal Blue)
70383 chuLa × scene tokyo コラボ・パーカー MINT
70384 chuLa × scene tokyo コラボ・パーカー BLUE