SELECT SQL_CALC_FOUND_ROWS 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 dtb_products AS p
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-20 12:51:41')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 85)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
21980 ROLLING CRADLE SHOUT STADIUM JUMPER / Black
29941 ROLLING CRADLE RC DUFFLE COURT Black
38597 ROLLING CRADLE RC MELTON RIDERS / Navy
38150 ROLLING CRADLE RC MODS COAT / Olive
38152 ROLLING CRADLE RC MODS COAT / Black
37794 ROLLING CRADLE GEGEGE NO SUKAJAN / White-Black
37795 ROLLING CRADLE GEGEGE NO SUKAJAN / Black-White
56796 ROLLING CRADLE MODS COAT BLACK
29494 ROLLING CRADLE (ロリクレ) CYCLO-TIGER SUKAJAN / Black-Yellow
29940 ROLLING CRADLE RAIGYO M-65 JKT Indigo
21894 ROLLING CRADLE MP-LOPS N3B JKT / Camo
14727 ROLLING CRADLE THE UMA COMPLETE DOWN JKT / Black
46812 ROLLING CRADLE CANVAS NEON OVERALL / Brown
46813 ROLLING CRADLE CANVAS NEON OVERALL / Black
38168 ROLLING CRADLE RC BIG HOODIE JKT / Indigo
38169 ROLLING CRADLE RC BIG HOODIE JKT / Black
44248 ROLLING CRADLE RCxDRAGON BALL Z DENIM JACKET / Blue
56538 ROLLING CRADLE FLIGHT JACKET / DENIM
56539 ROLLING CRADLE FLIGHT JACKET / BLACK
56799 ROLLING CRADLE CHECK HOOD JACKET BLUE
60818 ROLLING CRADLE 4POCKET JACKET / BLACK
60819 ROLLING CRADLE 4POCKET JACKET / BROWN
45979 ROLLING CRADLE RC NYLON ANORAK / Orange-Black
45982 ROLLING CRADLE RC NYLON ANORAK / Black-Gray
44919 ROLLING CRADLE GEGEGE NO SUKAJAN / Black-White[B]
14601 ROLLING CRADLE HALF COACH JKT / Indigo
15149 ROLLING CRADLE ROLLING THUNDER!? JKT / Olive
15150 ROLLING CRADLE ROLLING THUNDER!? JKT / Navy
24269 ROLLING CRADLE FUCKshima’s OVERALL / Indigo
24270 ROLLING CRADLE FUCKshima’s OVERALL / Hickory
29495 ROLLING CRADLE (ロリクレ) MYSTERY OF MARS HOODIE / Black
29745 ROLLING CRADLE (ロリクレ) SHOUT LINE COACH JKT Red
29746 ROLLING CRADLE (ロリクレ) SHOUT LINE COACH JKT / Black
38155 ROLLING CRADLE ROUNDED OVER ALL / White
38158 ROLLING CRADLE ROUNDED OVER ALL / Indigo
39840 ROLLING CRADLE SWING CATOP / Purple
39841 ROLLING CRADLE SWING CATOP /Balck
40913 ROLLING CRADLE RC-OW1496 CHECK GOWN Green-Red
44260 ROLLING CRADLE RCxDr.スランプ アラレちゃん JUMPER / Black
51179 ROLLING CRADLE ROLICLE SUKAJAN / Green
51181 ROLLING CRADLE ROLICLE SUKAJAN / Purple
51291 ROLLING CRADLE FLEECE JACKET / Black
51292 ROLLING CRADLE FLEECE JACKET / White
56798 ROLLING CRADLE SUEDE TRACK JACKET BEIGE
62114 ROLLING CRADLE SKAJAN JERSEY / BLUE
70130 ROLLING CRADLE (ローリングクレイドル) FLEECE JKT WHITE
70131 ROLLING CRADLE (ローリングクレイドル) FLEECE JKT BLACK
70132 ROLLING CRADLE (ローリングクレイドル) FLEECE JKT CRAZY
14719 ROLLING CRADLE PYRAMID POWER FLEECE JKT / Black
14720 ROLLING CRADLE PYRAMID POWER FLEECE JKT / Navy
14721 ROLLING CRADLE PYRAMID POWER FLEECE JKT / Beige
14722 ROLLING CRADLE MYSTERIOUS PATTERN HOODIE / Black
14723 ROLLING CRADLE MYSTERIOUS PATTERN HOODIE / COSMO
14724 ROLLING CRADLE MYSTERIOUS PATTERN JKT / Black
14725 ROLLING CRADLE MYSTERIOUS PATTERN JKT / Cosmo
29496 ROLLING CRADLE (ロリクレ) ROLLING-BAR HOODIE / White
29497 ROLLING CRADLE (ロリクレ) ROLLING-BAR HOODIE / Gray
29595 ROLLING CRADLE RC SHAEL COVERALL / Navy
29596 ROLLING CRADLE RC SHAEL COVERALL / Black
38599 ROLLING CRADLE RC BLANKET JKT / Red
38600 ROLLING CRADLE RC BLANKET JKT / Black
40914 ROLLING CRADLE RC-S1497 MAJESTIC BASEBALL SHIRT Black
60547 ROLLING CRADLE FLUFFY CREWNECK / BLACK
60548 ROLLING CRADLE FLUFFY CREWNECK / BLUE
60549 ROLLING CRADLE FLUFFY CREWNECK / BEIGE
62179 ROLLING CRADLE GLEN CHECK SHIRT-1st type- / ORANGE
62180 ROLLING CRADLE GLEN CHECK SHIRT-1st type- / GRAY
65910 ROLLING CRADLE(ローリングクレイドル) CORDUROY WIDE PANTS / BROWN
65911 ROLLING CRADLE(ローリングクレイドル) CORDUROY WIDE PANTS /ORANGE
66304 幽遊白書×ROLLING CRADLE DENIM JACKET / BLUE
67770 ROLLING CRADLE (ローリングクレイドル) GOKU-BUTO GARA CARGO PANTS LEOPARD
67771 ROLLING CRADLE (ローリングクレイドル) GOKU-BUTO GARA CARGO PANTS CAMO
69946 ROLLING CRADLE (ローリングクレイドル) NYLON JKT RED
69947 ROLLING CRADLE (ローリングクレイドル) NYLON JKT BLUE
69948 ROLLING CRADLE (ローリングクレイドル) NYLON JKT BLACK
21868 ROLLING CRADLE THUNDER GATE DENIM 1st type /Indigo
21897 ROLLING CRADLE SUKA-JERSEY:TIGER / Red
22151 ROLLING CRADLE THUNDER GATE 2nd type / Indigo(W)
22316 ROLLING CRADLE THUNDER GATE DENIM 3rd type IndigoW
32435 ROLLING CRADLE (ロリクレ) THUNDER GATE WIDE DENIM ICEBLUE
35029 ROLLING CRADLE KUNG FU CAT SHIRT / White
35030 ROLLING CRADLE KUNG FU CAT SHIRT / Red
47718 ROLLING CRADLE RCx東京幻想 CHAMPLOO SHIRT -KAMINARIMON GENSO- / Gray
47719 ROLLING CRADLE RCx東京幻想 CHAMPLOO SHIRT -KAMINARIMON GENSO- / Red
58044 ROLLING CRADLE RIP-STOP JACKET BLUE
58121 ROLLING CRADLE THUNDER GATE BAGGY DENIM / INDIGO
60626 ROLLING CRADLE CORDUROY GOKU-BUTO PANTS / GREEN
60627 ROLLING CRADLE CORDUROY GOKU-BUTO PANTS / PURPLE
63884 ROLLING CRADLE (ローリングクレイドル) 2TONE KUNG-FU SHIRT / YELLOW
64972 ROLLING CRADLE RC x KUDAN PANTS / COLOR
64973 ROLLING CRADLE RC x KUDAN PANTS / MONO
66305 幽遊白書×ROLLING CRADLE 集合 HOODIE / BLACK
66465 ROLLING CRADLE (ローリングクレイドル) FLOWER DYED DENIM PAINTER PANTS / INDIGO
66708 ROLLING CRADLE(ローリングクレイドル) 2023 NEW YEAR THUNDER GATE BAGGY DENIM
21729 ROLLING CRADLE OVERLOUD POCKET SHIRT / White
21730 ROLLING CRADLE OVERLOUD POCKET SHIRT / Turquoise
21731 ROLLING CRADLE OVERLOUD POCKET SHIRT / Black
23618 ROLLING CRADLE THUNDER GATE WIDE DENIM / Indigo
32130 ROLLING CRADLE RISING SUN DENIM
32433 ROLLING CRADLE (ロリクレ) THUNDER GATE WIDE DENIM INDIGO
37792 ROLLING CRADLE THUNDER GATE DENIM 2nd type / Indigo
39701 ROLLING CRADLE RCxEVANGELION BIG SHIRT "Give me back... ...Ayanami" Black
44249 ROLLING CRADLE RCxDRAGON BALL Z BIG SHIRT / Navy
46230 ROLLING CRADLE THUNDER GATE BAGGY DENIM / Blue
50248 ROLLING CRADLE 2TONE HOODED SHIRT / Navy-White
50249 ROLLING CRADLE 2TONE HOODED SHIRT / Blue-Green
50638 ROLLING CRADLE SWITCHING SWEAT / Navy
50639 ROLLING CRADLE SWITCHING SWEAT / Yellow
52742 ROLLING CRADLE CHECK CROPPED PANTS BROWN
52743 ROLLING CRADLE CHECK CROPPED PANTS BLUE
54412 ROLLING CRADLE THUNDER GATE SAROUEL DENIM / INDIGO
54414 ROLLING CRADLE THUNDER GATE SAROUEL DENIM / BLACK
56022 ROLLING CRADLE HONESTY HOODIE / BLACK
56800 ROLLING CRADLE SUEDE TRACK PANTS BLACK
56801 ROLLING CRADLE SUEDE TRACK PANTS BEIGE
57803 ROLLING CRADLE LMS HOODIE / BLACK
58015 ROLLING CRADLE FIRE HOODIE / PURPLE
59226 ROLLING CRADLE TV STATIC SHIRT BLACK
59227 ROLLING CRADLE TV STATICGOKU-BUTO PANTS BLACK
60546 ROLLING CRADLE HOOD CHECK SHIRT / BLACK