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 13:45:10')
AND pc.classcategory_id1 IN( 11)
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
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
62133 ROLLING CRADLE SMILE LONG SLEEVE BLACK
62116 ROLLING CRADLE Mjolnir TEE / WHITE
60704 ROLLING CRADLE LOGO ROSE LONG SLEEVE / PINK
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
54201 ROLLING CRADLE NYLON SHORT PANTS / BLACK
60251 ROLLING CRADLE COSPLAY GIRL-MOON- TEE / BEIGE
62132 ROLLING CRADLE SMILE LONG SLEEVE WHITE
39381 ROLLING CRADLE RC STANDARD TWILL SHORTS BEIGE
60543 ROLLING CRADLE COSPLAY GIRL-MOON- LONG SLEEVE / WHITE
41694 ROLLING CRADLE FLORAL SHORTS / White
49138 ROLLING CRSDLE NEO TOKYO SHORTS / Black
58313 ROLLING CRADLE BIG CHECK SHORTS / BLACK
13715 ROLLING CRADLE RCxMR SCREAMING NOIZE
13891 ROLLING CRADLE RC OFFICIAL T-MONSTER-WHITE
13892 ROLLING CRADLE RC OFFICIAL T-MONSTER-BLACK
17379 ROLLING CRADLE Pill-kn MIXER Tee / Black
17966 ROLLING CRADLE CYCLOPS SHOUT-BEACH- / White
17967 ROLLING CRADLE CYCLOPS SHOUT-BEACH- / 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
20475 RC×MONSTER ROCK JUST DO WHAT YOU WANT! WHITE
20476 RC×MONSTER ROCK JUST DO WHAT YOU WANT!! BLACK
24592 ROLLING CRADLE VAGABOND CYCLOPS Tee / Black
24593 ROLLING CRADLE SD ROLICLE Tee / White
24597 ROLLING CRADLE SD ROLICLE Tee / Black
41897 ROLLING CRADLE RC VULGAR SHIRT Green
51183 ROLLING CRADLE TRACK PANTS Black
58311 ROLLING CRADLE BIG CHECK SHIRT / BLACK
12096 RC x MONSTER ROCK x MONSTER ENERGY T-Shirt
14697 ROLLING CRADLE TURTLES-COWABUNGA- 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
28390 ROLLING CRADLExMONSTER ROCK COLLABORATION MAD NOISE!! -怒りのデスステージ- White
28391 ROLLING CRADLExMONSTER ROCK COLLABORATION MAD NOISE!! -怒りのデスステージ- Black
33928 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT Sumiblack
33929 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT White
34192 ROLLING CRADLE SQUARE CYCLOPS / White
34193 ROLLING CRADLE SQUARE CYCLOPS / Black
34196 ROLLING CRADLE VAGABOND CYCLOPS -Delicious- / White
34197 ROLLING CRADLE VAGABOND CYCLOPS -Delicious- / Black
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
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
41162 ROLLING CRADLE CYCLOPS HOLIDAY -CYCLINGLOPS- / Mint
41163 ROLLING CRADLE CYCLOPS HOLIDAY -WHO YA GONNA CALL?- / Apricot
43142 ROLLING CRADLE RCxMR 10th ANNIVERSARY ALL STARS PARTY / White
43143 ROLLING CRADLE RCxMR 10th ANNIVERSARY ALL STARS PARTY / Black
46943 ROLLING CRADLE CYCLOPS HOLIDAY -SMILE- / White
46944 ROLLING CRADLE CYCLOPS HOLIDAY -SMILE- / Black
47720 ROLLING CRADLE CYCLOPS SHOUT -BEAUTIFUL- / Navy
47721 ROLLING CRADLE CYCLOPS SHOUT -BEAUTIFUL- / Black
47722 ROLLING CRADLE CYCLOPS SHOUT -FOOD- / White
47723 ROLLING CRADLE CYCLOPS SHOUT -FOOD- / Black
47838 ROLLING CRADLE LUNCH BOX TEEE / White
47839 ROLLING CRADLE LUNCH BOX TEEE / Black
47840 ROLLING CRADLE ZOMBIE LAND ROLICLE / Red
47841 ROLLING CRADLE ZOMBIE LAND ROLICLE / Black
47842 ROLLING CRADLE M2K TEKNO GIRL TEE / Neon-pink
47843 ROLLING CRADLE M2K TEKNO GIRL TEE / Blue-jean
47844 ROLLING CRADLE LIKE A ROBBIE TEE / White
47845 ROLLING CRADLE LIKE A ROBBIE TEE / Black
47846 ROLLING CRADLE MIGOS CAT TEE / Banana
47847 ROLLING CRADLE MIGOS CAT TEE / Apricot
47848 ROLLING CRADLE MIGOS CAT TEE / Limegreen
48187 ROLLING CRADLE CYCLOPS HOLIDAY -FU-TEN- / Purple
48188 ROLLING CRADLE CYCLOPS HOLIDAY -FU-TEN- / NAVY
48189 ROLLING CRADLE CYCLOPS HOLIDAY -THRILLER- / Black
48190 ROLLING CRADLE CYCLOPS HOLIDAY -COFFEE BREAK- / White
48191 ROLLING CRADLE CYCLOPS HOLIDAY -COFFEE BREAK- / Black
50039 ROLLING CRADLE MONSTER TEE/White
50041 ROLLING CRADLE MONSTER TEE/Black
50042 ROLLING CRADLE SHOUT TEE/Black
50043 ROLLING CRADLE SHOUT TEE/White
50134 ROLLING CRADLE RCxMR SURVIVE! MADNESS BROS. / Black
50135 ROLLING CRADLE RCxMR SURVIVE! MADNESS BROS. / White
54105 ROLLING CRADLE CIRCLE LOGO TEE / BLACK
54106 ROLLING CRADLE CIRCLE LOGO TEE / WHITE
58622 ROLLING CRADLE SAIKYOU TEE / BLACK
58623 ROLLING CRADLE SAIKYOU TEE / WHITE
62117 ROLLING CRADLE Mjolnir TEE / BLACK
63349 ROLLING CRADLE (ローリングクレイドル) CYCLOPS TOY PACKAGE TEE / BLACK
63350 ROLLING CRADLE (ローリングクレイドル) CYCLOPS TOY PACKAGE TEE / SAND
63351 ROLLING CRADLE (ローリングクレイドル) CYCLOPS TOY PACKAGE TEE / WHITE
68077 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / WHITE
68078 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / SAX
68079 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / BLACK
69086 ROLLING CRADLE (ローリングクレイドル) Re:STEP TEE / RED