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 15:11:45')
AND pc.price02 > 4545
AND price02 <= 9090
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
17857 ROLLING CRADLE BiG CYCLOPS-SB / White
17858 ROLLING CRADLE BiG CYCLOPS-SB / Black
24885 ROLLING CRADLE RCxTHRASHER -Go! Go! Go!- / White
24886 ROLLING CRADLE RCxTHRASHER -Go! Go! Go!- / Black
24887 ROLLING CRADLE RCxTHRASHER -PUSH ON FACE!- / White
24888 ROLLING CRADLE RCxTHRASHER -PUSH ON FACE!- / Black
54480 【バンドリ!×ゲキクロ第1弾復刻】ROLLING CRADLE×山吹沙綾コラボ 限定 キャップ
41901 ROLLING CRADLE RC VULGAR PANTS Green
46192 ROLLING CRADLE CHECK!CHECK!CHECK! SHIRT / Red-Yellow
50556 ROLLING CRADLE LOOSE HOODIE / Crazy
11860 ROLLING CRADLE STREET RC FIGHTERS XV White
14294 ROLLING CRADLE DOT SNAKE WALLET COAD / White
14296 ROLLING CRADLE DOT SNAKE WALLET COAD / Orange
14300 ROLLING CRADLE DOT SNAKE WALLET COAD / Green
17747 ROLLING CRADLE B X W NAPZAC / Black
21191 ROLLING CRADLE MP-LOPS POCTee / Black
21192 ROLLING CRADLE MP-LOPS POCTee / Gray
21193 ROLLING CRADLE MP-LOPS POCTee / White
26340 ROLLING CRADLE PEEPING CYCLOPS / White
26341 ROLLING CRADLE PEEPING CYCLOPS / Orange
26342 ROLLING CRADLE PEEPING CYCLOPS / Navy
28535 ROLLING CRADLE VAGABOND CYCLOPS -USA- CAP / Black
28536 ROLLING CRADLE VAGABOND CYCLOPS -USA- CAP / Indigo
28542 ROLLING CRADLE CYCLOPS SHOUT SACOCHE / Blue-Orange
28543 ROLLING CRADLE CYCLOPS SHOUT SACOCHE / Yellow-Purple
28544 ROLLING CRADLE CYCLOPS SHOUT SACOCHE / Charcoal-Purple
29747 ROLLING CRADLE (ロリクレ) RC LOGO PIERCE / SILVER 925
34919 ROLLING CRADLE NEKO CAP / Pink
34920 ROLLING CRADLE NEKO CAP / Black
35031 ROLLING CRADLE PPkn SNAPBACK / Navy-Red
35032 ROLLING CRADLE PPkn SNAPBACK / Blue
37602 ROLLING CRADLE RCxMU MU CAP / Black-Red
37603 ROLLING CRADLE RCxMU MU CAP / Black-Black
38598 ROLLING CRADLE RC LOGO PIERCE / SILVER 925
39413 ROLLING CRADLE RC CYCLOPS TERROR CAP BLACK
39414 ROLLING CRADLE RC CYCLOPS TERROR CAP NAVY
39415 ROLLING CRADLE SUPER ROLLING CRADLE CAP BLACK
39416 ROLLING CRADLE SUPER ROLLING CRADLE CAP WHITE
39417 ROLLING CRADLE RC CHEMICAL TOTE BAG GREEN
39418 ROLLING CRADLE RC CHEMICAL TOTE BAG RED
45746 ROLLING CRADLE ARIZONA CAP / Red
45747 ROLLING CRADLE ARIZONA CAP / Black
47724 ROLLING CRADLE FIRE CAP / Red-Royal
47725 ROLLING CRADLE FIRE CAP / Red-Black
47726 ROLLING CRADLE FIRE CAP / Navy-Gold
47849 ROLLING CRADLE HANDWRITING LOGO CAP / Red
47850 ROLLING CRADLE HANDWRITING LOGO CAP / Black
48549 ROLLING CRADLE RING BELT / Pink
48550 ROLLING CRADLE RING BELT / Purple
48551 ROLLING CRADLE RING BELT / Blue
57804 ROLLING CRADLE LMS HAT / GRAIGE
57805 ROLLING CRADLE LMS HAT / BLACK
60455 ROLLING CRADLE CHECK NELSHIRT / BLUE
60550 ROLLING CRADLE THUNDER GATE BAGGY DENIM -2nd- / INDIGO
60765 ROLLING CRADLE LOGO ROSE HOODIE / BLACK
54107 ROLLING CRADLE SUPER BIG POLO / PURPLE
59279 ROLLING CRADLE BORDER TURTLE NECK / BLUE
65804 ROLLING CRADLE(ローリングクレイドル) YF LONG SLEEVE BLACK
19142 ROLLING CRADLE RC×Mark Gonzales ANGEL White
19161 ROLLING CRADLE RC×Mark Gonzales CLOUD / White
19162 ROLLING CRADLE RC×Mark Gonzales CLOUD / Gray
19163 ROLLING CRADLE RC×Mark Gonzales CLOUD / Black
19164 ROLLING CRADLE RC×Mark Gonzales SKATE / Black
19165 ROLLING CRADLE RC×Mark Gonzales ANGEL / Black
19166 ROLLING CRADLE RC×Mark Gonzales ANGEL / Gray
19956 ROLLING CRADLE RCxGREMLINS MOHAWK / White
19957 ROLLING CRADLE RCxGREMLINS MOHAWK / Gray
19958 ROLLING CRADLE RCxGREMLINS MOHAWK / Black
19959 ROLLING CRADLE RCxGREMLINS FLASHER / Black
22010 ROLLING CRADLE Storm trooper T-shirt WHT
22011 ROLLING CRADLE Storm trooper T-shirt BLK
22012 ROLLING CRADLE Trooper T-shirt WHT
22015 ROLLING CRADLE Darth Vader T-shirt / Black
28524 ROLLING CRADLE RCxSESAMI STREET T-SHIRT / White
28527 ROLLING CRADLE RCxSESAMI STREET T-SHIRT / Red
28528 ROLLING CRADLE RCxSESAMI STREET T-SHIRT / Black
28530 ROLLING CRADLE KERMIT T-SHIRT / White
28532 ROLLING CRADLE KERMIT T-SHIRT / Gray
28534 ROLLING CRADLE KERMIT T-SHIRT / Black
34261 ROLLING CRADLE RCxTM paint -MVP- / Black
34262 ROLLING CRADLE RCxTM paint -MVP- / White
34263 ROLLING CRADLE RCxTM paint -MVP- / Gray
34264 ROLLING CRADLE RCxTM paint -BOOTLEG FAMILY- / Black
34265 ROLLING CRADLE RCxTM paint -BOOTLEG FAMILY- / White
34266 ROLLING CRADLE RCxTM paint -BOOTLEG FAMILY- / Gray
34454 ROLLING CRADLE Mickey T-SHIRT / White
34455 ROLLING CRADLE Mickey T-SHIRT / Black
34456 ROLLING CRADLE Mickey&Minnie T-SHIRT / White
34457 ROLLING CRADLE Mickey T-SHIRT / Black
34458 ROLLING CRADLE Donald&Daisy T-SHIRT / Black
34459 ROLLING CRADLE Donald&Daisy T-SHIRT / White
34460 ROLLING CRADLE Pooh&Piglet T-SHIRT / White
34461 ROLLING CRADLE Pooh&Piglet T-SHIRT / Black
34915 ROLLING CRADLE RCxXEVIOUS -CYCLOPS SHOUT- / White
34916 ROLLING CRADLE RCxPAC-MAN -CYCLOPS SHOUT- / Black
34917 ROLLING CRADLE RCxPAC-MAN -CYCLOPS SHOUT- / White
34918 ROLLING CRADLE RCxXEVIOUS -CYCLOPS SHOUT- / Black
36524 ROLLING CRADLE RCxSpongeBob -ROLLCRDL- White
36525 ROLLING CRADLE RCxSpongeBob -ROLLCRDL- Blue
36526 ROLLING CRADLE RCxSpongeBob -ROLLCRDL- Black
36527 ROLLING CRADLE RCxSpongeBob -Bob&Patrick- White
36528 ROLLING CRADLE RCxSpongeBob -Bob&Patrick- Blue
36529 ROLLING CRADLE RCxSpongeBob -Bob&Patrick- Black
37173 ROLLING CRADLE RCxE.T. E.T.ELLIOT T-SHIRT / White
37175 ROLLING CRADLE RCxE.T. E.T.ELLIOT T-SHIRT / Black
37176 ROLLING CRADLE RCxE.T. ELLIOT BMX T-SHIRT / White
37178 ROLLING CRADLE RCxE.T. ELLIOT BMX T-SHIRT / Black
39394 ROLLING CRADLE RC×B&B Tee "TITTY TWISTER" WHITE
39395 ROLLING CRADLE RC×B&B Tee "TITTY TWISTER" BLACK
39396 ROLLING CRADLE RC×B&B Tee "TITTY TWISTER" LIGHT BLUE
39407 ROLLING CRADLE S. N Tee "TOP OF GLORY"
39408 ROLLING CRADLE S. N Tee "STRONG STYLE HAS ARRIVED" BLACK
39706 ROLLING CRADLE RCxEVANGELION T-SHIRT "Rei & Shinji" / Black
39707 ROLLING CRADLE RCxEVANGELION T-SHIRT "Rei & Shinji" / White
39708 ROLLING CRADLE RCxEVANGELION CYCLOPS SHOUT T-SHIRT "EVANGELION:2.0" / White
39709 ROLLING CRADLE RCxEVANGELION CYCLOPS SHOUT T-SHIRT "EVANGELION:2.0" / Black
40460 ROLLING CRADLE RC×B&B Tee "BEAVIS CORNHOLIO" / White
40461 ROLLING CRADLE RC×B&B Tee "BEAVIS CORNHOLIO" / Black
41266 ROLLING CRADLE RCxDEVILMAN CYCLOPS SHOUT -DEVILMAN crybaby- / Black
41267 ROLLING CRADLE RCxDEVILMAN CYCLOPS SHOUT -DEVILMAN crybaby- / White