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 19:08:33')
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 p.update_date
LIMIT 0, 120
7871 ROLLING CRADLE BIG TOOTH GUM T Charcoal
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
11860 ROLLING CRADLE STREET RC FIGHTERS XV White
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
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
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
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
17601 ROLLING CRADLE POP-ART Tee / White
17602 ROLLING CRADLE POP-ART Tee / Black
17857 ROLLING CRADLE BiG CYCLOPS-SB / White
17858 ROLLING CRADLE BiG CYCLOPS-SB / Black
17859 ROLLING CRADLE CYCLOPS SKATE IN THE DARKNESS / WHT
17862 ROLLING CRADLE RC×STETCH ROCKAWAY BEACHERS / Black
17865 ROLLING CRADLE KO-RI KO-RI Tee / White
17966 ROLLING CRADLE CYCLOPS SHOUT-BEACH- / White
17967 ROLLING CRADLE CYCLOPS SHOUT-BEACH- / Black
18292 ROLLING CRADLE 22[TWO-FU] FOOTBALL Tee / Navy
18294 ROLLING CRADLE ROLLCRDL Tee / Green
18295 ROLLING CRADLE ROLLCRDL Tee Black/RED
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
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
19168 ROLLING CRADLE 6090PICXIE / Black
19956 ROLLING CRADLE RCxGREMLINS MOHAWK / White
19957 ROLLING CRADLE RCxGREMLINS MOHAWK / Gray
19958 ROLLING CRADLE RCxGREMLINS MOHAWK / Black
19959 ROLLING CRADLE RCxGREMLINS FLASHER / Black
20104 ROLLING CRADLE CATTEL MUTILATION BIG Tee / Turquoi
20105 ROLLING CRADLE CATTEL MUTILATION BIG Tee / White
20475 RC×MONSTER ROCK JUST DO WHAT YOU WANT! WHITE
20476 RC×MONSTER ROCK JUST DO WHAT YOU WANT!! BLACK
21191 ROLLING CRADLE MP-LOPS POCTee / Black
21192 ROLLING CRADLE MP-LOPS POCTee / Gray
21193 ROLLING CRADLE MP-LOPS POCTee / White
22010 ROLLING CRADLE Storm trooper T-shirt WHT
22011 ROLLING CRADLE Storm trooper T-shirt BLK
22012 ROLLING CRADLE Trooper T-shirt WHT
22013 ROLLING CRADLE Trooper T-shirt BLK
22015 ROLLING CRADLE Darth Vader T-shirt / Black
24204 ROLLING CRADLE ROLLCRDL BIG Tee / White
24205 ROLLING CRADLE ROLLCRDL BIG Tee / Red
24206 ROLLING CRADLE ROLLCRDL BIG Tee / Charcoal
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
24595 ROLLING CRADLE SD ROLICLE Tee / Pruple
24596 ROLLING CRADLE SD ROLICLE Tee / Blue
24597 ROLLING CRADLE SD ROLICLE Tee / 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
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
26340 ROLLING CRADLE PEEPING CYCLOPS / White
26341 ROLLING CRADLE PEEPING CYCLOPS / Orange
26342 ROLLING CRADLE PEEPING CYCLOPS / Navy
26615 ROLLING CRADLE PROUD 2 RC BIG POCKET Tee / Pink
26616 ROLLING CRADLE PROUD 2 RC BIG POCKET Tee / Yellow
27474 ROLLING CRADLE AIN’T 2 PROUD BIG Tee / White
27476 ROLLING CRADLE AIN’T 2 PROUD BIG Tee / Black
28239 ROLLING CRADLE RCxTHRASHER THRASHE'M ALL!! TEE WHT
28390 ROLLING CRADLExMONSTER ROCK COLLABORATION MAD NOISE!! -怒りのデスステージ- White
28391 ROLLING CRADLExMONSTER ROCK COLLABORATION MAD NOISE!! -怒りのデスステージ- 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