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-04-28 11:59:37')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 77)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
66793 Subciety (サブサエティ) DUCK ANORAK CAMEL
66794 Subciety (サブサエティ) DUCK ANORAK BLACK
66795 Subciety (サブサエティ) DUCK ANORAK OFF WHITE
66301 Subciety 2023 福袋 -NEW YEAR BAG-
45379 Subciety 2019 福袋 -NEW YEAR BAG-
50321 Subciety 2020 福袋 -NEW YEAR BAG-
56066 Subciety 2021 福袋 -NEW YEAR BAG-
60561 Subciety 2022 福袋 -NEW YEAR BAG-
56458 Subciety (サブサエティ) SOUVENIR PARKA- KHAKI
56459 Subciety SOUVENIR PARKA- PINK
69755 Subciety (サブサエティ) Pieta PARKA MULTI
69756 Subciety (サブサエティ) Pieta PARKA BLACK
25714 Subciety LONG LENGTH PARKA-GLORIOUS- BLACK
13802 Subciety TIE DYE ZIP PARKA-EMOTION- NAVY
13803 Subciety TIE DYE ZIP PARKA-EMOTION- GRAY
34595 Subciety (サブサエティ) BOA PARKA BLACK
50670 Subciety (サブサエティ) BOA PARKA IVORY
56020 Subciety (サブサエティ) HALF ZIP BOA PARKA BLACK
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
57332 Subciety×仮面ライダードライブ MACH PARKA WHITE
58450 Subciety (サブサエティ)×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA BLACK
58451 Subciety ×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA GRAY
59014 Subciety (サブサエティ) PIGMENT PARKA - RED
60501 Subciety (サブサエティ) Layered PARKA BLACK
60502 Subciety (サブサエティ) SEA OTTER PARKA BEIGE
66676 Subciety (サブサエティ) SIDE BLEACH PARKA BLACK
66677 Subciety (サブサエティ) SIDE BLEACH PARKA GREEN
66678 Subciety (サブサエティ) SIDE BLEACH PARKA PURPLE
13799 Subciety TIE DYE PARKA-GLORIOUS- GRAY
13801 Subciety TIE DYE PARKA-GLORIOUS- GREEN
25675 Subciety (サブサエティ) TIE-DYE PARKA-GLORIOUS- BLACK
25676 Subciety (サブサエティ) TIE-DYE PARKA-GLORIOUS- BLUE
25677 Subciety (サブサエティ) TIE-DYE PARKA-GLORIOUS- PINK
25678 Subciety (サブサエティ) TIE-DYE PARKA-GLORIOUS- RAINBOW
25679 Subciety (サブサエティ) TIE-DYE PARKA-SALOON- BLACK
25680 Subciety (サブサエティ) TIE-DYE PARKA-SALOON- BLUE
25681 Subciety (サブサエティ) TIE-DYE PARKA-SALOON- PINK
25682 Subciety (サブサエティ) TIE-DYE PARKA-SALOON- RAINBOW
25708 Subciety REFLECTOR PRINT PARKA-GLORIOUS- WHITE
25709 Subciety REFLECTOR PRINT PARKA-GLORIOUS- BLACK
29200 Subciety (サブサエティ) PAISLEY PARKA-GLORIOUS- WHITE
29201 Subciety (サブサエティ) PAISLEY PARKA-GLORIOUS- BLACK
45301 Subciety (サブサエティ) Daisy PARKA WHITE
45302 Subciety (サブサエティ) Daisy PARKA BLACK
45303 Subciety (サブサエティ) Daisy PARKA YELLOW
50217 Subciety (サブサエティ) EMBROIDERY PARKA-kid- WHITE
50223 Subciety (サブサエティ) EMBROIDERY PARKA-kid- BLACK
50878 Subciety CUTOFF PARKA WHITE
50879 Subciety CUTOFF PARKA GRAY
50880 Subciety CUTOFF PARKA ORANGE
54264 Subciety A-2PARKA BLACK
54266 Subciety A-2PARKA BEIGE
57277 Subciety (サブサエティ) PARKA-PROVIDENCE- BLACK
57278 Subciety (サブサエティ) PARKA-PROVIDENCE- GRAY/BURGUNDY
57279 Subciety (サブサエティ) PARKA-PROVIDENCE- NAVY
61237 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション Compac Drive PARKA KHAKI
61238 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション Compac Drive PARKA GRAY
61837 Subciety (サブサエティ) EMBROIDERY PARKA BLACK
61838 Subciety (サブサエティ) EMBROIDERY PARKA BLACK/BLACK
65382 Subciety (サブサエティ) BLEACH PARKA-THE BASE- GRAY
65383 Subciety (サブサエティ) BLEACH PARKA-THE BASE- PURPLE
65384 Subciety (サブサエティ) BLEACH PARKA-THE BASE- BLACK
65460 Subciety (サブサエティ) CHENILLE COLLEGE PARKA-BLUE
65461 Subciety (サブサエティ) CHENILLE COLLEGE PARKA-GREEN
65464 Subciety (サブサエティ) RAGLAN PARKA-BLACK
65491 Subciety (サブサエティ) CHENILLE COLLEGE PARKA-ORANGE
65492 Subciety (サブサエティ) CHENILLE COLLEGE PARKA-BLACK
69391 Subciety (サブサエティ) PIGMENT PARKA BLACK
69392 Subciety (サブサエティ) PIGMENT PARKA GRAY
69395 Subciety (サブサエティ) PIGMENT PARKA GREEN
69397 Subciety (サブサエティ) PIGMENT PARKA NAVY
69760 Subciety (サブサエティ) PARKA-PROVIDENCE- GRAY/BLACK
41401 Subciety (サブサエティ) UNDONE PARKA-THE BASE BLACK
16503 Subciety PARKA-Parantica sita- BURGUNDY
16508 Subciety PARKA-LARGE GLORIOUS- BLACK
16510 Subciety PARKA-LARGE GLORIOUS- CHARCOAL
16689 Subciety PARKA-PATTERNED ALL OVER- GRAY
25711 Subciety PARKA-SALOON- BLACK
25712 Subciety PARKA-SALOON- GRAY
27583 Subciety X ANDSUNS PARKA BLACK
27584 Subciety X ANDSUNS PARKA WHITE
29924 Subciety (サブサエティ) Subciety×MarkGonzales PARKA BLACK
29925 Subciety (サブサエティ) Subciety×MarkGonzales PARKA RED
29926 Subciety (サブサエティ) Subciety×MarkGonzales PARKA GRAY
41388 Subciety (サブサエティ) PARKA-CLASS- NAVY
45147 Subciety (サブサエティ) Rewind PARKA WHITE
45148 Subciety (サブサエティ) Rewind PARKA BLACK
50887 Subciety (サブサエティ) PARKA-Venus- WHITE
50888 Subciety (サブサエティ) PARKA-Venus- BLACK
54251 Subciety LOOP TIE PARKA BLACK
54252 Subciety LOOP TIE PARKA GRAY
54253 Subciety LOOP TIE PARKA BEIGE
56450 Subciety VANDALIZE PARKA- GRAY
56451 Subciety (サブサエティ) VANDALIZE PARKA- KHAKI
56455 Subciety (サブサエティ) BREAK PARKA- YELLOW
60859 Subciety (サブサエティ) PAISLEY BOX PARKA BLACK
60860 Subciety (サブサエティ) PAISLEY BOX PARKA GRAY
61399 Subciety (サブサエティ) PAISLEY PARKA BLACK
61400 Subciety (サブサエティ) PAISLEY PARKA NAVY
65496 Subciety (サブサエティ) PAISLEY PARKA-GRAY
65498 Subciety (サブサエティ) PAISLEY PARKA-BLACK
65499 Subciety (サブサエティ) PAISLEY PARKA-NAVY
69382 Subciety (サブサエティ) HALF ZIP PARKA BLACK
69383 Subciety (サブサエティ) HALF ZIP PARKA GREEN
69969 Subciety (サブサエティ) GIANT SIZE PARKA BLACK
69970 Subciety (サブサエティ) GIANT SIZE PARKA MUSTARD
70744 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident PARKA WHITE
70746 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident PARKA BLACK
70748 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident PARKA GRAY
20715 Subciety PARKA-CAMOUFLAGE SALOON- WHITE
20716 Subciety PARKA-CAMOUFLAGE SALOON- BLACK
25689 Subciety PARKA-MELT GLORIOUS- WHITE-RED
25690 Subciety PARKA-MELT GLORIOUS- BLACK-GREEN
25691 Subciety PARKA-MELT GLORIOUS- BLUE-WHITE
25692 Subciety (サブサエティ) PARKA-Amploud- WHITE