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-04-27 22:12:52')
AND FIND_IN_SET(3, p.color)
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
57793 ROLLING CRADLE LMS SOX / WHITE
60713 ROLLING CRADLE FLOWER SOX / WHITE
60253 ROLLING CRADLE OTAKU-SHOJO TEE / WHITE
15940 ROLLING CRADLE RC LOGO KEY HOLDER / White
35196 ROLLING CRADLE RC PINS RC SOXS WHITE
41361 ROLLING CRADLE CYCLOPS SOX / White
50558 ROLLING CRADLE ROLICLE SOX / White
54522 ROLLING CRADLE DRAW LOGO SOX
54523 ROLLING CRADLE LOGO SOX
32425 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Black-White
58016 ROLLING CRADLE FIRE SOX / WHITE
62116 ROLLING CRADLE Mjolnir TEE / WHITE
28239 ROLLING CRADLE RCxTHRASHER THRASHE'M ALL!! TEE WHT
21530 ROLLING CRADLE ROUGHLY KNIT CAP / White
32272 ROLLING CRADLE (ロリクレ) Donut of Heart TOTE / Natural
46362 ROLLING CRADLE i Phone CASE-KAWAII GIRL- / 7&8[White]
62775 ROLLING CRADLE CNS TEE / WHITE
62132 ROLLING CRADLE SMILE LONG SLEEVE WHITE
32005 ROLLING CRADLE RC iQOS COVER / RC-ALL STARS
60543 ROLLING CRADLE COSPLAY GIRL-MOON- LONG SLEEVE / WHITE
69476 ROLLING CRADLE (ローリングクレイドル) LOGO CAP WHITE
24894 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Clear-White
24896 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Clear-Black
48448 ROLLING CRADLE APPLE SHORTS / White
32008 ROLLING CRADLE RC iPhone Case Note Type / RC-ALL STARS
34201 ROLLING CRADLE iPhone Case Note Type / RC ALL STARS
41694 ROLLING CRADLE FLORAL SHORTS / White
24593 ROLLING CRADLE SD ROLICLE Tee / White
24889 ROLLING CRADLE GOOD MORNING NASTY / White
28390 ROLLING CRADLExMONSTER ROCK COLLABORATION MAD NOISE!! -怒りのデスステージ- White
33929 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT White
34192 ROLLING CRADLE SQUARE CYCLOPS / White
34267 ROLLING CRADLE CYCLOPS SHOUT -ALL STAR- / White
35023 ROLLING CRADLE RC HATE -All Flavor- / White
35026 ROLLING CRADLE RC HATE -BIKELOPS- / White
35028 ROLLING CRADLE RC HATE -Donut of Heart- / White
36943 ROLLING CRADLE MONSTER ROCK COLLABORATION MEGA MONSTER BURGER WHITE
41010 ROLLING CRADLE RC-T1517 ROLLCRDL -PAINT- White
43142 ROLLING CRADLE RCxMR 10th ANNIVERSARY ALL STARS PARTY / White
46943 ROLLING CRADLE CYCLOPS HOLIDAY -SMILE- / White
47722 ROLLING CRADLE CYCLOPS SHOUT -FOOD- / White
47838 ROLLING CRADLE LUNCH BOX TEEE / White
47844 ROLLING CRADLE LIKE A ROBBIE TEE / White
48190 ROLLING CRADLE CYCLOPS HOLIDAY -COFFEE BREAK- / White
50039 ROLLING CRADLE MONSTER TEE/White
50043 ROLLING CRADLE SHOUT TEE/White
50135 ROLLING CRADLE RCxMR SURVIVE! MADNESS BROS. / White
54106 ROLLING CRADLE CIRCLE LOGO TEE / WHITE
63351 ROLLING CRADLE (ローリングクレイドル) CYCLOPS TOY PACKAGE TEE / WHITE
69087 ROLLING CRADLE (ローリングクレイドル) Re:STEP TEE / WHITE
69089 ROLLING CRADLE (ローリングクレイドル) Re:LIKE A ROBBIE TEE / WHITE
11860 ROLLING CRADLE STREET RC FIGHTERS XV White
26340 ROLLING CRADLE PEEPING CYCLOPS / White
39416 ROLLING CRADLE SUPER ROLLING CRADLE CAP WHITE
47724 ROLLING CRADLE FIRE CAP / Red-Royal
47725 ROLLING CRADLE FIRE CAP / Red-Black
28524 ROLLING CRADLE RCxSESAMI STREET T-SHIRT / White
28530 ROLLING CRADLE KERMIT T-SHIRT / White
34262 ROLLING CRADLE RCxTM paint -MVP- / White
34265 ROLLING CRADLE RCxTM paint -BOOTLEG FAMILY- / White
34460 ROLLING CRADLE Pooh&Piglet T-SHIRT / White
34915 ROLLING CRADLE RCxXEVIOUS -CYCLOPS SHOUT- / White
34917 ROLLING CRADLE RCxPAC-MAN -CYCLOPS SHOUT- / White
36524 ROLLING CRADLE RCxSpongeBob -ROLLCRDL- White
36527 ROLLING CRADLE RCxSpongeBob -Bob&Patrick- White
37173 ROLLING CRADLE RCxE.T. E.T.ELLIOT T-SHIRT / White
37176 ROLLING CRADLE RCxE.T. ELLIOT BMX T-SHIRT / White
39394 ROLLING CRADLE RC×B&B Tee "TITTY TWISTER" WHITE
39707 ROLLING CRADLE RCxEVANGELION T-SHIRT "Rei & Shinji" / White
39708 ROLLING CRADLE RCxEVANGELION CYCLOPS SHOUT T-SHIRT "EVANGELION:2.0" / White
40460 ROLLING CRADLE RC×B&B Tee "BEAVIS CORNHOLIO" / White
41267 ROLLING CRADLE RCxDEVILMAN CYCLOPS SHOUT -DEVILMAN crybaby- / White
41268 ROLLING CRADLE RCxDEVILMAN "DEVILMAN crybaby" / White
41270 ROLLING CRADLE RCxDEVILMAN "The DEVILMAN Birth" / White
41273 ROLLING CRADLE RCxDEVILMAN "AKIRA to MIKI" / White
41275 ROLLING CRADLE RCxDEVILMAN "SATAN to DEVILMAN" / White
41696 ROLLING CRADLE DISNEY T-SHIRT "Alice in Wonderland" / White
41699 ROLLING CRADLE DISNEY T-SHIRT "Peter Pan" / White
41702 ROLLING CRADLE DISNEY T-SHIRT "Snow White and the Seven Dwarfs" / White
41800 ROLLING CRADLE CYCLOPS SHOUT YOUKAI -FOREST BLUE- White
41802 ROLLING CRADLE CYCLOPS SHOUT YOUKAI -FOREST PINK- White
41804 ROLLING CRADLE RCxGEGEGE "THREE EYES" White
41806 ROLLING CRADLE RCxGEGEGE "NURIKABE" White
41808 ROLLING CRADLE RCxGEGEGE "HYAKUME" White
46814 ROLLING CRADLE ROLLCRDL LOGO T-SHIRT / White
48446 ROLLING CRADLExワンパンマン"ジェノス" / White
33683 ROLLING CRADLE 80s 3D LOGO T-SHIRT / White
41636 ROLLING CRADLE RC LOGO T-SHIRT / White
24201 ROLLING CRADLE MP-LOPS RAGLAN / Red
24202 ROLLING CRADLE MP-LOPS RAGLAN / Navy
24203 ROLLING CRADLE MP-LOPS RAGLAN / Black
26333 ROLLING CRADLE RC RESORT HAT / White
44254 ROLLING CRADLE RCxDRAGON BALL Z T-SHIRT / White
44265 ROLLING CRADLE RCxDr.スランプ アラレちゃん T-SHIRT / White
56062 ROLLING CRADLE THUNDER CYCLOPS RAGLAN SLEEVE / BLACK
59144 ROLLING CRADLE LOGO LOGO TEE WHITE
59281 ROLLING CRADLE PEEPS TEE / WHITE
60249 ROLLING CRADLE MAGAZINE TEE / WHITE
69474 ROLLING CRADLE (ローリングクレイドル) CREAM LONGSLEEVE WHITE
16668 ROLLING CRADLE POP-ART LONG T-SHIRT / White
23737 ROLLING CRADLE FREAK OUT LONG Tee / White
28668 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT WHITE
32544 ROLLING CRADLE R-kn BEACH LONG T-SHIRT White
35678 ROLLING CRADLE All Flavor of RC BELL HAT Black/White
39377 ROLLING CRADLE RC HEAVY COTTON BIG POCKET TEE WHITE
50250 ROLLING CRADLE YUUUTSU GIRL LONG SLEEVE / White
54413 ROLLING CRADLE DRAW LOGO SUPER BIG TEE / WHITE
55993 ROLLING CRADLE FLIGHT LOGO TEE / WHITE
57788 ROLLING CRADLE 天使と悪魔 LONG SLEEVE / WHITE
37520 ROLLING CRADLE RCxE.T. GERTY KISS LONG T-SHIRT / White
37522 ROLLING CRADLE RCxE.T. MOON LIGHT LONG T-SHIRT / White
39391 ROLLING CRADLE RC×B&B LONG Tee "TITTY TWISTER" WHITE
48443 ROLLING CRADLExワンパンマン"虎鬼竜神" / White
24204 ROLLING CRADLE ROLLCRDL BIG Tee / White
37798 ROLLING CRADLE GEGEGE NO BACK BEARD LONG T-SHIRT / White
39702 ROLLING CRADLE RCxEVANGELION LONG T-SHIRT "Shikinami Asuka Langley" / White
44261 ROLLING CRADLE RCxDr.スランプ アラレちゃん LONG SLEEVE SHIRT / White
54081 ROLLING CRADLE ICEE LONG SLEEVE / WHITE
58118 ROLLING CRADLE RIDER LONG SLEEVE / WHITE
64963 ROLLING CRADLE RC x KUDAN LOGO TEE / WHITE