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-04-28 05:44:45')
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 0, 120
24595 ROLLING CRADLE SD ROLICLE Tee / Pruple
50040 ROLLING CRADLE MONSTER TEE/Mintgreen
60253 ROLLING CRADLE OTAKU-SHOJO TEE / WHITE
60254 ROLLING CRADLE OTAKU-SHOJO TEE / BLACK
17859 ROLLING CRADLE CYCLOPS SKATE IN THE DARKNESS / WHT
22013 ROLLING CRADLE Trooper T-shirt BLK
44266 ROLLING CRADLE RCxDr.スランプ アラレちゃん T-SHIRT / Red
59282 ROLLING CRADLE PEEPS TEE / EMERALD
60716 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / EMERALD
48271 ROLLING CRADLE SUPER BIG TEE / Charcoal
62116 ROLLING CRADLE Mjolnir TEE / WHITE
28239 ROLLING CRADLE RCxTHRASHER THRASHE'M ALL!! TEE WHT
54125 ROLLING CRADLE JUDGEMENT BIG TEE
59145 ROLLING CRADLE LIP RINGER TEE BLACK
59146 ROLLING CRADLE LIP RINGER TEE GRAIGE
60715 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / BLACK
62775 ROLLING CRADLE CNS TEE / WHITE
62777 ROLLING CRADLE CNS TEE / BLACK
60251 ROLLING CRADLE COSPLAY GIRL-MOON- TEE / BEIGE
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
17865 ROLLING CRADLE KO-RI KO-RI Tee / White
17966 ROLLING CRADLE CYCLOPS SHOUT-BEACH- / White
17967 ROLLING CRADLE CYCLOPS SHOUT-BEACH- / Black
18298 ROLLING CRADLE COFFEE BRAKE Tee / Burgundy
18299 ROLLING CRADLE ROLL CAKE BRAKE Tee / Pink
18300 ROLLING CRADLE ROLL CAKE BRAKE Tee / Black
18967 ROLLING CRADLE CYCLOPS SHOUT-TIEDYE- / White
18968 ROLLING CRADLE CYCLOPS SHOUT-TIEDYE- / Black
18970 ROLLING CRADLE CYCLOPS SHOUT-DUNK- / White
18971 ROLLING CRADLE CYCLOPS SHOUT-DUNK- / Black
19168 ROLLING CRADLE 6090PICXIE / Black
20475 RC×MONSTER ROCK JUST DO WHAT YOU WANT! WHITE
20476 RC×MONSTER ROCK JUST DO WHAT YOU WANT!! BLACK
24590 ROLLING CRADLE VAGABOND CYCLOPS Tee / White
24591 ROLLING CRADLE VAGABOND CYCLOPS Tee / Gray
24592 ROLLING CRADLE VAGABOND CYCLOPS Tee / Black
24593 ROLLING CRADLE SD ROLICLE Tee / White
24594 ROLLING CRADLE SD ROLICLE Tee / Red
24596 ROLLING CRADLE SD ROLICLE Tee / Blue
24597 ROLLING CRADLE SD ROLICLE Tee / Black
12081 ROLLING CRADLE I’LL PAINT IT White
12082 ROLLING CRADLE I’LL PAINT IT Gray
12083 ROLLING CRADLE I’LL PAINT IT Black
12084 ROLLING CRADLE SUMMER FEELING White
12085 ROLLING CRADLE SUMMER FEELING Blue
12086 ROLLING CRADLE SUMMER FEELING Black
12088 ROLLING CRADLE HOUSE ROCKIN’ Pink
12089 ROLLING CRADLE HOUSE ROCKIN’ Black
12096 RC x MONSTER ROCK x MONSTER ENERGY T-Shirt
14697 ROLLING CRADLE TURTLES-COWABUNGA- Black
14709 ROLLING CRADLE BIG TURTLOPS-MICHELANGELO-
17370 ROLLING CRADLE ROLLCRDL Tee / White
17372 ROLLING CRADLE ROLLCRDL Tee / Yellow
17373 ROLLING CRADLE ROLLCRDL Tee / Red
17375 ROLLING CRADLE ROLLCRDL Tee / Black
17862 ROLLING CRADLE RC×STETCH ROCKAWAY BEACHERS / Black
18294 ROLLING CRADLE ROLLCRDL Tee / Green
18295 ROLLING CRADLE ROLLCRDL Tee Black/RED
24889 ROLLING CRADLE GOOD MORNING NASTY / White
24890 ROLLING CRADLE GOOD MORNING NASTY / Green
24891 ROLLING CRADLE GOOD MORNING NASTY / Black
25044 ROLLING CRADLE CYCLOPS SHOUT-RC BIT WORLD- / White
25045 ROLLING CRADLE CYCLOPS SHOUT-RC BIT WORLD- / Black
25046 ROLLING CRADLE CYCLOPS SHOUT-BURGER- / Black
25047 ROLLING CRADLE CYCLOPS SHOUT-BURGER- / White
25502 ROLLING CRADLE RC OFFICIAL T / Red-Blue
25503 ROLLING CRADLE RC OFFICIAL T / Blue-Red
26328 ROLLING CRADLE VAGABOND CYCLOPS -SKATE- Tee / White
26329 ROLLING CRADLE VAGABOND CYCLOPS -SKATE- Tee / Red
26330 ROLLING CRADLE VAGABOND CYCLOPS -SKATE- Tee / Black
28390 ROLLING CRADLExMONSTER ROCK COLLABORATION MAD NOISE!! -怒りのデスステージ- White
28391 ROLLING CRADLExMONSTER ROCK COLLABORATION MAD NOISE!! -怒りのデスステージ- Black
33927 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT Orange
33928 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT Sumiblack
33929 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT White
33930 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT Burgundy
34192 ROLLING CRADLE SQUARE CYCLOPS / White
34193 ROLLING CRADLE SQUARE CYCLOPS / Black
34194 ROLLING CRADLE SQUARE CYCLOPS / Apricot
34195 ROLLING CRADLE SQUARE CYCLOPS / Lavender
34196 ROLLING CRADLE VAGABOND CYCLOPS -Delicious- / White
34197 ROLLING CRADLE VAGABOND CYCLOPS -Delicious- / Black
34198 ROLLING CRADLE VAGABOND CYCLOPS -Delicious- / Orange
34199 ROLLING CRADLE VAGABOND CYCLOPS -Delicious- / Green
34267 ROLLING CRADLE CYCLOPS SHOUT -ALL STAR- / White
34268 ROLLING CRADLE CYCLOPS SHOUT -ALL STAR- / Black
35023 ROLLING CRADLE RC HATE -All Flavor- / White
35024 ROLLING CRADLE RC HATE -All Flavor- / Black
35025 ROLLING CRADLE ROLLING CRADLE RC HATE -BIKELOPS- / Black
35026 ROLLING CRADLE RC HATE -BIKELOPS- / White
35027 ROLLING CRADLE RC HATE -Donut of Heart- / Black
35028 ROLLING CRADLE RC HATE -Donut of Heart- / White
36942 ROLLING CRADLE MONSTER ROCK COLLABORATION MEGA MONSTER BURGER BLACK
36943 ROLLING CRADLE MONSTER ROCK COLLABORATION MEGA MONSTER BURGER WHITE
40922 ROLLING CRADLE RC-T1515 CYCLOPS SHOUT -WATERMELON- White
40923 ROLLING CRADLE RC-T1515 CYCLOPS SHOUT -WATERMELON- Black
41010 ROLLING CRADLE RC-T1517 ROLLCRDL -PAINT- White
41011 ROLLING CRADLE RC-T1517 ROLLCRDL -PAINT- Orange
41012 ROLLING CRADLE RC-T1517 ROLLCRDL -PAINT- Black
41083 ROLLING CRADLE CYCLOPS SHOUT -BLUE JERSEY- / Black
41084 ROLLING CRADLE CYCLOPS SHOUT -BLUE JERSEY- / White
41160 ROLLING CRADLE CYCLOPS HOLIDAY -CYCLINGLOPS- / Black
41161 ROLLING CRADLE CYCLOPS HOLIDAY -CYCLINGLOPS- / Red