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-28 14:38:25')
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 12,44)
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 DESC
LIMIT 0, 120
70131 ROLLING CRADLE (ローリングクレイドル) FLEECE JKT BLACK
69948 ROLLING CRADLE (ローリングクレイドル) NYLON JKT BLACK
69951 ROLLING CRADLE (ローリングクレイドル) NYLON WIDE PANTS BLACK
69472 ROLLING CRADLE (ローリングクレイドル) OSHI HOODIE BLACK
69272 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE BLACK
68079 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / BLACK
67770 ROLLING CRADLE (ローリングクレイドル) GOKU-BUTO GARA CARGO PANTS LEOPARD
66707 ROLLING CRADLE(ローリングクレイドル) 2023 NEW YEAR LOGO HOODIE BLACK
65804 ROLLING CRADLE(ローリングクレイドル) YF LONG SLEEVE BLACK
64962 ROLLING CRADLE RC x KUDAN LOGO TEE / BLACK
64971 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / MONO
64973 ROLLING CRADLE RC x KUDAN PANTS / MONO
63885 ROLLING CRADLE (ローリングクレイドル) 2TONE KUNG-FU SHIRT / BLACK
63349 ROLLING CRADLE (ローリングクレイドル) CYCLOPS TOY PACKAGE TEE / BLACK
62777 ROLLING CRADLE CNS TEE / BLACK
62773 ROLLING CRADLE CNS HOODIE / BLACK
63655 ROLLING CRADLE (ローリングクレイドル) RC WIDE PANTS / BLACK
62588 ROLLING CRADLE BURNED LOGO LONG SLEEVE / BLACK
62133 ROLLING CRADLE SMILE LONG SLEEVE BLACK
62117 ROLLING CRADLE Mjolnir TEE / BLACK
60813 ROLLING CRADLE COSPLAY GIRL-THUNDER- HOODIE / BLACK
60765 ROLLING CRADLE LOGO ROSE HOODIE / BLACK
60703 ROLLING CRADLE LOGO ROSE LONG SLEEVE / BLACK
60715 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / BLACK
60625 ROLLING CRADLE CORDUROY GOKU-BUTO PANTS / BLACK
60546 ROLLING CRADLE HOOD CHECK SHIRT / BLACK
60254 ROLLING CRADLE OTAKU-SHOJO TEE / BLACK
59283 ROLLING CRADLE PEEPS TEE / BLACK
59226 ROLLING CRADLE TV STATIC SHIRT BLACK
59227 ROLLING CRADLE TV STATICGOKU-BUTO PANTS BLACK
59142 ROLLING CRADLE LOGO LOGO TEE BLACK
59145 ROLLING CRADLE LIP RINGER TEE BLACK
58769 ROLLING CRADLE STEP TEE / BLACK
57789 ROLLING CRADLE 天使と悪魔 LONG SLEEVE / BLACK
58311 ROLLING CRADLE BIG CHECK SHIRT / BLACK
58313 ROLLING CRADLE BIG CHECK SHORTS / BLACK
58043 ROLLING CRADLE RIP-STOP JACKET BLACK
58046 ROLLING CRADLE RIP-STOP PANTS BLACK
57803 ROLLING CRADLE LMS HOODIE / BLACK
56539 ROLLING CRADLE FLIGHT JACKET / BLACK
56796 ROLLING CRADLE MODS COAT BLACK
56797 ROLLING CRADLE SUEDE TRACK JACKET BLACK
56800 ROLLING CRADLE SUEDE TRACK PANTS BLACK
56062 ROLLING CRADLE THUNDER CYCLOPS RAGLAN SLEEVE / BLACK
55994 ROLLING CRADLE FLIGHT LOGO TEE / BLACK
56022 ROLLING CRADLE HONESTY HOODIE / BLACK
55992 ROLLING CRADLE MENEKI-NEKO LONG SLEEVE / PEPPER
13715 ROLLING CRADLE RCxMR SCREAMING NOIZE
14719 ROLLING CRADLE PYRAMID POWER FLEECE JKT / Black
15366 ROLLING CRADLE FAT STRIPE SLIM PANTS /Black
15789 ROLLING CRADLE SD ROLICLE HOODIE / Black
15843 ROLLING CRADLE SWALLOW TAIL SHIRTL / Black/Yellow
16667 ROLLING CRADLE POP-ART LONG T-SHIRT / Black
17600 ROLLING CRADLE CHAMBER BORDER SHORTS / Black
17858 ROLLING CRADLE BiG CYCLOPS-SB / Black
21190 ROLLING CRADLE RC REFLECTION HOODIE / Black
21231 ROLLING CRADLE RLCR-PATCH ZIP HOODIE / Black
21232 ROLLING CRADLE RC EXPEDITION SWEAT / Black
21299 ROLLING CRADLE ROLLCRDL SWEAT / Black
21301 ROLLING CRADLE STONED SWEAT / Black
21523 ROLLING CRADLE RC×Mark Gonzales ANGEL HOODIE / BLK
21529 ROLLING CRADLE RC×Mark Gonzales CLOUD HOODIE / BLK
21731 ROLLING CRADLE OVERLOUD POCKET SHIRT / Black
21734 ROLLING CRADLE WAVELET SHIRT / Black
21868 ROLLING CRADLE THUNDER GATE DENIM 1st type /Indigo
21980 ROLLING CRADLE SHOUT STADIUM JUMPER / Black
22007 ROLLING CRADLE Sotrm trooper Sweat BLK
22009 ROLLING CRADLE Troopers Hoodie BLK
22013 ROLLING CRADLE Trooper T-shirt BLK
22014 ROLLING CRADLE Darth Vader Sweat / Black
22015 ROLLING CRADLE Darth Vader T-shirt / Black
22784 ROLLING CRADLE AIN’T 2 PROUD SWEAT / Black
22850 ROLLING CRADLE UNREASONABLE MONSTER SWEAT / Black
22951 ROLLING CRADLE BOX FOAM LOGO HOODIE / Black
23399 ROLLING CRADLE 16BIT YXBA CARDIGAN / Black
23400 ROLLING CRADLE 16BIT CROSS-KEY KNIT / Black
23401 ROLLING CRADLE CYCLOPS SHOUT SWEAT / Black
23740 ROLLING CRADLE FREAK OUT LONG Tee / Black
23889 ROLLING CRADLE FLUFFY HALF HOODIE / Navy
24270 ROLLING CRADLE FUCKshima’s OVERALL / Hickory
24592 ROLLING CRADLE VAGABOND CYCLOPS Tee / Black
24597 ROLLING CRADLE SD ROLICLE Tee / Black
24888 ROLLING CRADLE RCxTHRASHER -PUSH ON FACE!- / Black
24891 ROLLING CRADLE GOOD MORNING NASTY / Black
25498 ROLLING CRADLE OVER GROW SHIRT / Black
25501 ROLLING CRADLE OVER GROW SHORTS / Black
26335 ROLLING CRADLE ONE BEER WORK SHIRT / Black
26339 ROLLING CRADLE AZTECA SHORTS / Gray
27476 ROLLING CRADLE AIN’T 2 PROUD BIG Tee / Black
28391 ROLLING CRADLExMONSTER ROCK COLLABORATION MAD NOISE!! -怒りのデスステージ- Black
28520 ROLLING CRADLE CHIDORI SHORTS / Charcoal
28528 ROLLING CRADLE RCxSESAMI STREET T-SHIRT / Black
28534 ROLLING CRADLE KERMIT T-SHIRT / Black
28673 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT BLACK
28872 ROLLING CRADLE (ロリクレ) 80s 3D LOGO LONG T-SHIRTS / Black
28895 ROLLING CRADLE LOOSE SWEAT / Black
28970 ROLLING CRADLE KANJI LOGO HOODIE / Black
28974 ROLLING CRADLE ROLLCRDL-PAINT- SWEAT / Black
28976 ROLLING CRADLE KANJI SWEAT PANTS / Black
29081 ROLLING CRADLE 8BIT CYCLOPS-SB COACH JKT / Black
29085 ROLLING CRADLE GOOD MORNING NASTY HOODIE / Black
29088 ROLLING CRADLE CYCLOPS SHOUT SWEAT / Black
29091 ROLLING CRADLE RC SKINNY PANTS / Black
29494 ROLLING CRADLE (ロリクレ) CYCLO-TIGER SUKAJAN / Black-Yellow
29495 ROLLING CRADLE (ロリクレ) MYSTERY OF MARS HOODIE / Black
29498 ROLLING CRADLE (ロリクレ) VAGABOND CYCLOPS -USA- KNIT / Navy
29596 ROLLING CRADLE RC SHAEL COVERALL / Black
29597 ROLLING CRADLE RC×SESAMI STREET HOODIE / Navy
29599 ROLLING CRADLE RC×SESAMI STREET HOODIE / Black
29600 ROLLING CRADLE RC×KERMIT HOODIE / Black
29746 ROLLING CRADLE (ロリクレ) SHOUT LINE COACH JKT / Black
29941 ROLLING CRADLE RC DUFFLE COURT Black
32130 ROLLING CRADLE RISING SUN DENIM
32209 ROLLING CRADLE MAGIC BALL COACH JKT BLK
32212 ROLLING CRADLE RCxTHRASHER -GO!GO!GO!- HOODIE BLACK
32215 ROLLING CRADLE MAGIC BALL SWEAT BLACK
32421 ROLLING CRADLE R-kn BEACH ZIP HOODIE / Black
32428 ROLLING CRADLE (ロリクレ) 6090 ALL STAR HOODIE BLACK
32543 ROLLING CRADLE PINEAPPLE ALOHA BIG SHIRT Black
32545 ROLLING CRADLE R-kn BEACH LONG T-SHIRT / Black