SELECT SQL_CALC_FOUND_ROWS 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-20 12:14:20')
AND FIND_IN_SET(1, 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 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
69945 ROLLING CRADLE (ローリングクレイドル) HEART CRADLE CAP CHARCOAL
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
62135 ROLLING CRADLE CIRCLE LOGO BAG 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
60544 ROLLING CRADLE COSPLAY GIRL-MOON- LONG SLEEVE / NAVY
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
59228 ROLLING CRADLE TV STATIC HAT BLACK
59229 ROLLING CRADLE TV STATIC BAG 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
58017 ROLLING CRADLE FIRE SOX / BLACK
57803 ROLLING CRADLE LMS HOODIE / BLACK
57805 ROLLING CRADLE LMS HAT / BLACK
57792 ROLLING CRADLE LMS SOX / 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
55995 ROLLING CRADLE NEW ERA CAP 59FIFTY-CIRCLE LOGO- / NAVY
56022 ROLLING CRADLE HONESTY HOODIE / BLACK
55992 ROLLING CRADLE MENEKI-NEKO LONG SLEEVE / PEPPER
12365 ROLLING CRADLE roll-ING CAN BADGE Black
12367 ROLLING CRADLE SUPER LIKE BEER CAN BADGE Black
13715 ROLLING CRADLE RCxMR SCREAMING NOIZE
14719 ROLLING CRADLE PYRAMID POWER FLEECE JKT / Black
14729 ROLLING CRADLE THE UMA COMPLETE DOWN MUFFLER / BLK
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
21534 ROLLING CRADLE ROUGHLY KNIT CAP / Black
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
24600 ROLLING CRADLE RC LOGO NEW ERA CAP -CLASSIC- / Navy
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
26334 ROLLING CRADLE RC RESORT HAT / 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
28535 ROLLING CRADLE VAGABOND CYCLOPS -USA- CAP / Black
28539 ROLLING CRADLE BiG CYCLOPS DAY BAG / Black
28673 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT BLACK
28679 ROLLING CRADLE 6090 GLASSES-DOG OUT- BLACK
28872 ROLLING CRADLE (ロリクレ) 80s 3D LOGO LONG T-SHIRTS / Black
28894 ROLLING CRADLE BELL HAT / 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