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-27 09:33:58')
AND FIND_IN_SET(14, 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
70132 ROLLING CRADLE (ローリングクレイドル) FLEECE JKT CRAZY
70130 ROLLING CRADLE (ローリングクレイドル) FLEECE JKT WHITE
69947 ROLLING CRADLE (ローリングクレイドル) NYLON JKT BLUE
69950 ROLLING CRADLE (ローリングクレイドル) NYLON WIDE PANTS BLUE
69470 ROLLING CRADLE (ローリングクレイドル) OSHI HOODIE ICEBLUE
69466 ROLLING CRADLE (ローリングクレイドル) VIBRANT EASY PANTS BLUE
69271 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE MINT
68078 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / SAX
66708 ROLLING CRADLE(ローリングクレイドル) 2023 NEW YEAR THUNDER GATE BAGGY DENIM
64970 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / COLOR
65802 ROLLING CRADLE(ローリングクレイドル) R LONG SLEEVE NAVY
64975 ROLLING CRADLE RC x KUDAN LOGO SOX / BLUE
64972 ROLLING CRADLE RC x KUDAN PANTS / COLOR
63884 ROLLING CRADLE (ローリングクレイドル) 2TONE KUNG-FU SHIRT / YELLOW
63347 ROLLING CRADLE (ローリングクレイドル) HI-NECK SWEAT TEE / NAVY
63345 ROLLING CRADLE (ローリングクレイドル) BIG CHECK SHIRT / NAVY
63346 ROLLING CRADLE (ローリングクレイドル) RC CHECK WIDE PANTS / NAVY
63816 ROLLING CRADLE (ローリングクレイドル) VVV TEE / BLUE
63888 ROLLING CRADLE (ローリングクレイドル) RC STAR SOX / ICEBLUE
62114 ROLLING CRADLE SKAJAN JERSEY / BLUE
60712 ROLLING CRADLE LMS SOX / BLUE
60455 ROLLING CRADLE CHECK NELSHIRT / BLUE
60457 ROLLING CRADLE CHECK FLARE PANTS / BLUE
59279 ROLLING CRADLE BORDER TURTLE NECK / BLUE
56608 ROLLING CRADLE THUNDER GATE DENIM -1st damage type- / BLUE
58044 ROLLING CRADLE RIP-STOP JACKET BLUE
58045 ROLLING CRADLE RIP-STOP PANTS BLUE
58013 ROLLING CRADLE THUNDER GATE SKINNY DENIM / INDIGO
58014 ROLLING CRADLE THUNDER GATE SKINNY DENIM / CHEMICAL
57806 ROLLING CRADLE RCxHigh-Me TOKYO "PIERCE -HEART-" / A-TYPE
57807 ROLLING CRADLE RCxHigh-Me TOKYO "PIERCE -HEART-" / B-TYPE
57808 ROLLING CRADLE RCxHigh-Me TOKYO "EARRING -HEART-" / A-TYPE
57809 ROLLING CRADLE RCxHigh-Me TOKYO "EARRING -HEART-" / B-TYPE
56538 ROLLING CRADLE FLIGHT JACKET / DENIM
56799 ROLLING CRADLE CHECK HOOD JACKET BLUE
12213 ROLLING CRADLE BiG CYCLOPS-Dr.J- Blue
12221 ROLLING CRADLE ALIEN CAN BADGE Blue
14587 ROLLING CRADLE FAT STRIPE SLIM SHIRT /Blue
16663 ROLLING CRADLE POP-ART CRAZY SHIRT / BigCrazy
20570 ROLLING CRADLE WARM UP SWEAT PANTS / Blue
21188 ROLLING CRADLE RC REFLECTION HOODIE / Blue
21730 ROLLING CRADLE OVERLOUD POCKET SHIRT / Turquoise
21733 ROLLING CRADLE WAVELET SHIRT / Iceblue
21866 ROLLING CRADLE CYCLOPS SHOUT KNIT / Blue
22316 ROLLING CRADLE THUNDER GATE DENIM 3rd type IndigoW
22777 ROLLING CRADLE SHOCKING SMILE COACH JKT / Blue
22781 ROLLING CRADLE CYCLOPS SHOUT SWEAT / Blue
22952 ROLLING CRADLE BOX FOAM LOGO HOODIE / Blue
24596 ROLLING CRADLE SD ROLICLE Tee / Blue
24601 ROLLING CRADLE RC LOGO NEW ERA CAP -CLASSIC- / Blue-Red
25048 ROLLING CRADLE WAIKIKI SHORTS / Blue
25500 ROLLING CRADLE OVER GROW SHORTS / Blue
25503 ROLLING CRADLE RC OFFICIAL T / Blue-Red
25504 ROLLING CRADLE WAIKIKI BASE BALL-SHIRT / Blue
28670 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT BLUE
28867 ROLLING CRADLE (ロリクレ) HEXAGON CHANGER / Turquoise
29082 ROLLING CRADLE BURGER SHIRT / Navy-Black
29086 ROLLING CRADLE CYCLOPS SHOUT SWEAT / Turquoise
29602 ROLLING CRADLE RC SAROUEL PANTS / Indigo
29940 ROLLING CRADLE RAIGYO M-65 JKT Indigo
32418 ROLLING CRADLE GRAVY CHECK BIG SHIRT / Blue
32422 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Yellow-Blue
32423 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Blue-Pink
32435 ROLLING CRADLE (ロリクレ) THUNDER GATE WIDE DENIM ICEBLUE
32503 ROLLING CRADLE THUNDER GATE DENIM 1st type / Indigo(W)
33681 ROLLING CRADLE (ロリクレ) RC STANDARD SHORTS / Blue
34187 ROLLING CRADLE CATTLE MUTILATION SHIRT / Blue
34270 ROLLING CRADLE RC GLASSES -ROMA- / Blue
34462 ROLLING CRADLE RC BANDANA / Blue-Red
35032 ROLLING CRADLE PPkn SNAPBACK / Blue
35198 ROLLING CRADLE RC PINS RC SOXS TURQUCISE
36338 ROLLING CRADLE (ロリクレ) RC QUICK POCKET POACH / Blue
36528 ROLLING CRADLE RCxSpongeBob -Bob&Patrick- Blue
37167 ROLLING CRADLE RAKURAI NEL / Blue
37170 ROLLING CRADLE DELICIOUS TACOS LONG T-SHIRT / Blue
37345 ROLLING CRADLE RAKURAI LONG NEL / Navy-White
37358 ROLLING CRADLE ASAGONIA KNIT CAP / Blue
37426 ROLLING CRADLE SHOUT COACH JKT / Navy
37431 ROLLING CRADLE GAUDY RUGBY SHIRT / Navy-Pink
37433 ROLLING CRADLE CYCLOPS SHOUT MINI POUCH / Green
37434 ROLLING CRADLE CYCLOPS SHOUT MINI POUCH / Blue
37516 ROLLING CRADLE CLASSIC B.B LOGO KNIT CAP / Blue
37589 ROLLING CRADLE BIG SHOUT DENIM SHIRT / Bleach
37590 ROLLING CRADLE BIG SHOUT DENIM SHIRT / Chemical
37591 ROLLING CRADLE BIG SHOUT DENIM SHIRT / Indigo
37593 ROLLING CRADLE RLIG CDLE PIGMENT HOODIE / Turquoise
37595 ROLLING CRADLE RLIG CDLE PIGMENT HOODIE / Blue
37599 ROLLING CRADLE RLIG CDLE PIGMENT SWEAT PANTS / Blue
37601 ROLLING CRADLE CRAZY COLOR BOA SHORTS / Charcoal-Purple
37605 ROLLING CRADLE THE UFO BEAM NECK WARMER / Red
37793 ROLLING CRADLE THUNDER GATE DENIM 2nd type / Indigo(W)
37796 ROLLING CRADLE GEGEGE NO GASHADOKURO KNIT / Red
39396 ROLLING CRADLE RC×B&B Tee "TITTY TWISTER" LIGHT BLUE
39417 ROLLING CRADLE RC CHEMICAL TOTE BAG GREEN
39418 ROLLING CRADLE RC CHEMICAL TOTE BAG RED
40924 ROLLING CRADLE RC-C1546 RC LOGO NEW ERA CAP SNAPBACK Navy
41264 ROLLING CRADLE CORDUROY SHORTS / Blue
41631 ROLLING CRADLE FLASHY BIG SHIRT / Crazy
41643 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Blue
41697 ROLLING CRADLE DISNEY T-SHIRT "Alice in Wonderland" / Mint
41778 ROLLING CRADLE CREAM SODA SHIRT Green
41779 ROLLING CRADLE CREAM SODA SHIRT Blue
41798 ROLLING CRADLE CREAM SODA SHORTS Mix
41900 ROLLING CRADLE RC VULGAR BIG T-SHIRT Blue
43239 ROLLING CRADLE RC RUGBY JERSEY / Blue
43332 ROLLING CRADLE RAKURAI NEL / Blue
43421 ROLLING CRADLE COMBINATION BIG SHIRT / Navy
43424 ROLLING CRADLE VERTICAL LINE SWEATER / Black
43426 ROLLING CRADLE RLNGCRDL KNIT CAP / Blue
43431 ROLLING CRADLE RC PINS / Florida
43432 ROLLING CRADLE RC PINS / Dragon
44248 ROLLING CRADLE RCxDRAGON BALL Z DENIM JACKET / Blue
44252 ROLLING CRADLE RCxDRAGON BALL Z LONG SLEEVE SHIRT / Blue
45744 ROLLING CRADLE MARBLE WIDE CROPPED PANTS / Blue
46225 ROLLING CRADLE RC RUGBY JERSEY / Smokeblue
46230 ROLLING CRADLE THUNDER GATE BAGGY DENIM / Blue
47843 ROLLING CRADLE M2K TEKNO GIRL TEE / Blue-jean
48382 ROLLING CRADLE OXFORD SHIRT / Blue
48447 ROLLING CRADLExワンパンマン"戦慄のタツマキ" / Blue-jean
48542 ROLLING CRADLE 3WAY DRUM BAG / Blue