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 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-05-01 20:53: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)
LIMIT 120, 120
21533 ROLLING CRADLE ROUGHLY KNIT CAP / Navy
21534 ROLLING CRADLE ROUGHLY KNIT CAP / Black
28675 ROLLING CRADLE RC CLASSIC LOGO KNIT CAP MUSTARD
28676 ROLLING CRADLE RC CLASSIC LOGO KNIT CAP BURGUNDY
32098 ROLLING CRADLE RC MOBILE BATTERY CASSETE
32272 ROLLING CRADLE (ロリクレ) Donut of Heart TOTE / Natural
32274 ROLLING CRADLE (ロリクレ) Donut of Heart TOTE / Black
37356 ROLLING CRADLE ASAGONIA KNIT CAP / Black
37357 ROLLING CRADLE ASAGONIA KNIT CAP / Navy
37358 ROLLING CRADLE ASAGONIA KNIT CAP / Blue
37359 ROLLING CRADLE ASAGONIA KNIT CAP / Gray
37515 ROLLING CRADLE CLASSIC B.B LOGO KNIT CAP / Black
37516 ROLLING CRADLE CLASSIC B.B LOGO KNIT CAP / Blue
37517 ROLLING CRADLE CLASSIC B.B LOGO KNIT CAP / Mastard
37518 ROLLING CRADLE CLASSIC B.B LOGO KNIT CAP / Beige
43425 ROLLING CRADLE RLNGCRDL KNIT CAP / Red
43426 ROLLING CRADLE RLNGCRDL KNIT CAP / Blue
43427 ROLLING CRADLE RLNGCRDL KNIT CAP / Navy
43428 ROLLING CRADLE RLNGCRDL KNIT CAP / Black
43520 ROLLING CRADLE RC KNIT CAP / Burgundy
43521 ROLLING CRADLE RC KNIT CAP / Black
46360 ROLLING CRADLE i Phone CASE-011- / 7&8[Orange]
46361 ROLLING CRADLE i Phone CASE-011- / X[Purple]
46362 ROLLING CRADLE i Phone CASE-KAWAII GIRL- / 7&8[White]
46363 ROLLING CRADLE i Phone CASE-KAWAII GIRL- / X[Black]
50256 ROLLING CRADLE CANVAS BAG / Red
50257 ROLLING CRADLE CANVAS BAG / Black
50440 ROLLING CRADLE LOGO KNIT CAP / Neon-Yellow
50441 ROLLING CRADLE LOGO KNIT CAP / Purple
50442 ROLLING CRADLE LOGO KNIT CAP / Black
54639 ROLLING CRADLE LOGO MOBILE CHARGER BLACK
60715 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / BLACK
62775 ROLLING CRADLE CNS TEE / WHITE
62777 ROLLING CRADLE CNS TEE / BLACK
49067 ROLLING CRADLE PILE SHORTS / Black
54201 ROLLING CRADLE NYLON SHORT PANTS / BLACK
60251 ROLLING CRADLE COSPLAY GIRL-MOON- TEE / BEIGE
47727 ROLLING CRADLE ROLICLE TUMBLR / Lime
47728 ROLLING CRADLE ROLICLE TUMBLR / Orange
47729 ROLLING CRADLE ROLICLE TUMBLR / Black
28893 ROLLING CRADLE BELL HAT / Green
62132 ROLLING CRADLE SMILE LONG SLEEVE WHITE
32005 ROLLING CRADLE RC iQOS COVER / RC-ALL STARS
32006 ROLLING CRADLE RC iQOS COVER / Enough
50560 ROLLING CRADLE RUBBER LOGO NECKLACE / Purple
39381 ROLLING CRADLE RC STANDARD TWILL SHORTS BEIGE
46941 ROLLING CRADLE RC NYLON SHORTS / Gray
60543 ROLLING CRADLE COSPLAY GIRL-MOON- LONG SLEEVE / WHITE
69476 ROLLING CRADLE (ローリングクレイドル) LOGO CAP WHITE
69945 ROLLING CRADLE (ローリングクレイドル) HEART CRADLE CAP CHARCOAL
5546 ROLLING CRADLE DOT×DOT NECK WARMER Turquoise
7692 ROLLING CRADLE Gizmobies THE 100t BURGER
22034 ROLLING CRADLE RC SOCKS 3PACK / A-set
22035 ROLLING CRADLE RC SOCKS 3PACK / B-set
22036 ROLLING CRADLE RC SOCKS 3PACK / C-set
22191 ROLLING CRADLE CYCLOPS SHOUT MAG&DRIPPER SET / WHT
22192 ROLLING CRADLE CYCLOPS SHOUT MAG&DRIPPER SET / BLK
24894 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Clear-White
24896 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Clear-Black
24897 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Black
25050 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Blue
25051 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Green
25052 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Pink
25053 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Yellow
29499 ROLLING CRADLE (ロリクレ) CYCLOPS SHOUT NECK WARMER / Gray-Black
34269 ROLLING CRADLE RC GLASSES -ROMA- / Orange
34270 ROLLING CRADLE RC GLASSES -ROMA- / Blue
34271 ROLLING CRADLE RC BATH TOWL HOODIE / Black
37180 ROLLING CRADLE 6090 GLASSES -Lyla- / Black
37604 ROLLING CRADLE THE UFO BEAM NECK WARMER / Green
37605 ROLLING CRADLE THE UFO BEAM NECK WARMER / Red
37606 ROLLING CRADLE THE UFO BEAM NECK WARMER / Black
48554 ROLLING CRADLE ROLICLE LUNCH BOX / Silver
52746 ROLLING CRADLE KAWAII SACOCHE BAG / BLACK
46226 ROLLING CRADLE WAPPEN SHIRT / Beige
48448 ROLLING CRADLE APPLE SHORTS / White
8754 ROLLING CRADLE 6090 GLASSES SERIES-MYAGE- Brown
19902 ROLLING CRADLE CYCLOPS SHOUT POUCH / Blue
28679 ROLLING CRADLE 6090 GLASSES-DOG OUT- BLACK
28680 ROLLING CRADLE 6090 GLASSES-DOG OUT- BROWN
32007 ROLLING CRADLE RC iPhone Case Note Type / Enough
32008 ROLLING CRADLE RC iPhone Case Note Type / RC-ALL STARS
34200 ROLLING CRADLE iPhone Case Note Type / SHOUT
34201 ROLLING CRADLE iPhone Case Note Type / RC ALL STARS
37077 ROLLING CRADLE 6090 GLASSES -Closer- / Bekko
37078 ROLLING CRADLE 6090 GLASSES -Closer- / Black
37432 ROLLING CRADLE CYCLOPS SHOUT MINI POUCH / Orange
37433 ROLLING CRADLE CYCLOPS SHOUT MINI POUCH / Green
37434 ROLLING CRADLE CYCLOPS SHOUT MINI POUCH / Blue
37435 ROLLING CRADLE CYCLOPS SHOUT MINI POUCH / Black
40926 ROLLING CRADLE RC-A1557 RC SMARTPHONE CASE VAGABOND HOOP Multi
45923 ROLLING CRADLE CYCLOPS HOLIDAY SHOULDER / Black
48546 ROLLING CRADLE COMPACT POUCH / Pink
48547 ROLLING CRADLE COMPACT POUCH / Purple
48548 ROLLING CRADLE COMPACT POUCH / Blue
55996 ROLLING CRADLE FLIGHT LOGO HAT / BLACK
37601 ROLLING CRADLE CRAZY COLOR BOA SHORTS / Charcoal-Purple
41694 ROLLING CRADLE FLORAL SHORTS / White
48382 ROLLING CRADLE OXFORD SHIRT / Blue
49138 ROLLING CRSDLE NEO TOKYO SHORTS / Black
56106 ROLLING CRADLE WOOL CARDIGAN / BROWN
58313 ROLLING CRADLE BIG CHECK SHORTS / BLACK
10535 ROLLING CRADLE UNREASONABLE MONSTER White
10536 ROLLING CRADLE UNREASONABLE MONSTER Indigo
10537 ROLLING CRADLE UNREASONABLE MONSTER Black
10539 ROLLING CRADLE Pillkn NEVER DIE Tee Black
12213 ROLLING CRADLE BiG CYCLOPS-Dr.J- Blue
12351 ROLLING CRADLE STOP! CYCLO-KN Lightblue
12368 ROLLING CRADLE MISSILE Pillkn Gray
12370 ROLLING CRADLE MISSILE Pillkn Black
13715 ROLLING CRADLE RCxMR SCREAMING NOIZE
13720 ROLLING CRADLE MASTER CYCLOPS BLUE
13721 ROLLING CRADLE MASTER CYCLOPS OLIEVE
13722 ROLLING CRADLE MASTER CYCLOPS RED
13891 ROLLING CRADLE RC OFFICIAL T-MONSTER-WHITE
13892 ROLLING CRADLE RC OFFICIAL T-MONSTER-BLACK
17376 ROLLING CRADLE Pill-kn MIXER Tee / White
17377 ROLLING CRADLE Pill-kn MIXER Tee / Gray
17378 ROLLING CRADLE Pill-kn MIXER Tee / Blue
17379 ROLLING CRADLE Pill-kn MIXER Tee / Black