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 01:04:37')
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 1080, 120
41804 ROLLING CRADLE RCxGEGEGE "THREE EYES" White
41805 ROLLING CRADLE RCxGEGEGE "THREE EYES" Black
41806 ROLLING CRADLE RCxGEGEGE "NURIKABE" White
41807 ROLLING CRADLE RCxGEGEGE "NURIKABE" Black
41808 ROLLING CRADLE RCxGEGEGE "HYAKUME" White
41809 ROLLING CRADLE RCxGEGEGE "HYAKUME" Black
41897 ROLLING CRADLE RC VULGAR SHIRT Green
41898 ROLLING CRADLE RC CUTESY SHIRT Stripe
41899 ROLLING CRADLE RC VULGAR BIG T-SHIRT Green
41900 ROLLING CRADLE RC VULGAR BIG T-SHIRT Blue
41901 ROLLING CRADLE RC VULGAR PANTS Green
41903 ROLLING CRADLE RC VULGAR BELL HAT Green-Blue
43142 ROLLING CRADLE RCxMR 10th ANNIVERSARY ALL STARS PARTY / White
43143 ROLLING CRADLE RCxMR 10th ANNIVERSARY ALL STARS PARTY / Black
43237 ROLLING CRADLE FLORIDA HOODIE / Yellow
43238 ROLLING CRADLE FLORIDA HOODIE / Black
43239 ROLLING CRADLE RC RUGBY JERSEY / Blue
43240 ROLLING CRADLE RC RUGBY JERSEY / Black
43277 ROLLING CRADLE FLORIDA HOODIE / Orange
43331 ROLLING CRADLE RAKURAI NEL / Green
43332 ROLLING CRADLE RAKURAI NEL / Blue
43333 ROLLING CRADLE CYCLOPS HOLIDAY -JURASSIC- / Purple
43334 ROLLING CRADLE CYCLOPS HOLIDAY -JURASSIC- / Black
43335 ROLLING CRADLE CYCLOPS HOLIDAY -PAINT- / Blue
43336 ROLLING CRADLE CYCLOPS HOLIDAY -PAINT- / Black
43337 ROLLING CRADLE BORDER LONG T-SHIRT / Yellow
43338 ROLLING CRADLE BORDER LONG T-SHIRT / Orange
43362 ROLLING CRADLE BONBON VNECK SHIRT / Gray
43363 ROLLING CRADLE BONBON VNECK SHIRT / Green
43364 ROLLING CRADLE RLNGCRDL TRACK PANTS / Black
43421 ROLLING CRADLE COMBINATION BIG SHIRT / Navy
43422 ROLLING CRADLE COMBINATION BIG SHIRT / Black
43423 ROLLING CRADLE VERTICAL LINE SWEATER / Purple
43424 ROLLING CRADLE VERTICAL LINE SWEATER / Black
43425 ROLLING CRADLE RLNGCRDL KNIT CAP / Red
43426 ROLLING CRADLE RLNGCRDL KNIT CAP / Blue
43427 ROLLING CRADLE RLNGCRDL KNIT CAP / Navy
43428 ROLLING CRADLE RLNGCRDL KNIT CAP / Black
43429 ROLLING CRADLE RCxMAJESTIC BACKPACK / Black
43430 ROLLING CRADLE RC PINS / Logo
43431 ROLLING CRADLE RC PINS / Florida
43432 ROLLING CRADLE RC PINS / Dragon
43433 ROLLING CRADLE RC PINS / Golira
43517 ROLLING CRADLE RLGCDL HOODIE / Oatmeal
43518 ROLLING CRADLE RLGCDL HOODIE / Black
43519 ROLLING CRADLE SWEAT JOGGER PANTS / Black
43520 ROLLING CRADLE RC KNIT CAP / Burgundy
43521 ROLLING CRADLE RC KNIT CAP / Black
43755 ROLLING CRADLE 011 BIG HOODIE / Black
43756 ROLLING CRADLE DRAGON BIG SWEAT / Green
43757 ROLLING CRADLE DRAGON BIG SWEAT / Black
43758 ROLLING CRADLE COMFY POUCH / Navy
43759 ROLLING CRADLE COMFY POUCH / Camo
43760 ROLLING CRADLE COMFY POUCH / Black
43761 ROLLING CRADLE WIDE CROPPED PANTS / Black
44125 ROLLING CRADLE LOVE HOODIE / White
44169 ROLLING CRADLE LOVE HOODIE / Black
44248 ROLLING CRADLE RCxDRAGON BALL Z DENIM JACKET / Blue
44249 ROLLING CRADLE RCxDRAGON BALL Z BIG SHIRT / Navy
44250 ROLLING CRADLE RCxDRAGON BALL Z LONG SLEEVE SHIRT / Gray
44251 ROLLING CRADLE RCxDRAGON BALL Z LONG SLEEVE SHIRT / Orange
44252 ROLLING CRADLE RCxDRAGON BALL Z LONG SLEEVE SHIRT / Blue
44253 ROLLING CRADLE RCxDRAGON BALL Z LONG SLEEVE SHIRT / Black
44254 ROLLING CRADLE RCxDRAGON BALL Z T-SHIRT / White
44255 ROLLING CRADLE RCxDRAGON BALL Z T-SHIRT / Green
44256 ROLLING CRADLE RCxDRAGON BALL Z T-SHIRT / Navy
44257 ROLLING CRADLE RCxDRAGON BALL Z T-SHIRT / Black
44258 ROLLING CRADLE RCxDRAGON BALL Z SOX / Orange
44259 ROLLING CRADLE RCxDr.スランプ アラレちゃん SOX / Pink
44260 ROLLING CRADLE RCxDr.スランプ アラレちゃん JUMPER / Black
44261 ROLLING CRADLE RCxDr.スランプ アラレちゃん LONG SLEEVE SHIRT / White
44262 ROLLING CRADLE RCxDr.スランプ アラレちゃん LONG SLEEVE SHIRT / Yellow
44263 ROLLING CRADLE RCxDr.スランプ アラレちゃん LONG SLEEVE SHIRT / Orange
44264 ROLLING CRADLE RCxDr.スランプ アラレちゃん LONG SLEEVE SHIRT / Black
44265 ROLLING CRADLE RCxDr.スランプ アラレちゃん T-SHIRT / White
44266 ROLLING CRADLE RCxDr.スランプ アラレちゃん T-SHIRT / Red
44267 ROLLING CRADLE RCxDr.スランプ アラレちゃん T-SHIRT / Purple
44268 ROLLING CRADLE RCxDr.スランプ アラレちゃん T-SHIRT / Black
44269 ROLLING CRADLE RCxDr.スランプ アラレちゃん POUCH / Green
44270 ROLLING CRADLE RCxDr.スランプ アラレちゃん POUCH / Pink
44272 ROLLING CRADLE RCxDr.スランプ アラレちゃん POUCH / Red
44919 ROLLING CRADLE GEGEGE NO SUKAJAN / Black-White[B]
44921 ROLLING CRADLE RLIG CDLE PIGMENT HOODIE / Turquoise[B]
45363 ROLLING CRADLE RC CHECKER WIDE PANTS Black
45744 ROLLING CRADLE MARBLE WIDE CROPPED PANTS / Blue
45745 ROLLING CRADLE KAWAII GIRL LONG SLEEVE / Black
45746 ROLLING CRADLE ARIZONA CAP / Red
45747 ROLLING CRADLE ARIZONA CAP / Black
45918 ROLLING CRADLE CYCLOPS HOLIDAY-DONUTS- / Black
45919 ROLLING CRADLE CYCLOPS HOLIDAY-WORLD TOUR- / Maroon
45920 ROLLING CRADLE CYCLOPS HOLIDAY-WORLD TOUR- / Navy
45921 ROLLING CRADLE CYCLOPS HOLIDAY-ICECREAM- / Natural
45922 ROLLING CRADLE CYCLOPS HOLIDAY-ICECREAM- / Pink
45923 ROLLING CRADLE CYCLOPS HOLIDAY SHOULDER / Black
45979 ROLLING CRADLE RC NYLON ANORAK / Orange-Black
45982 ROLLING CRADLE RC NYLON ANORAK / Black-Gray
45984 ROLLING CRADLE TAPERED CHINO PANTS / Black
46191 ROLLING CRADLE CHECK!CHECK!CHECK! SHIRT / Yellow-White
46192 ROLLING CRADLE CHECK!CHECK!CHECK! SHIRT / Red-Yellow
46224 ROLLING CRADLE RC RUGBY JERSEY / Berry
46225 ROLLING CRADLE RC RUGBY JERSEY / Smokeblue
46226 ROLLING CRADLE WAPPEN SHIRT / Beige
46227 ROLLING CRADLE WAPPEN SHIRT / Black
46230 ROLLING CRADLE THUNDER GATE BAGGY DENIM / Blue
46231 ROLLING CRADLE WAPPEN TOTE / Stripe
46232 ROLLING CRADLE WAPPEN TOTE / Black
46359 ROLLING CRADLE Mathilda LONG SLEEVE / Navy
46360 ROLLING CRADLE i Phone CASE-011- / 7&8[Orange]
46361 ROLLING CRADLE i Phone CASE-011- / X[Purple]
46362 ROLLING CRADLE i Phone CASE-KAWAII GIRL- / 7&8[White]
46363 ROLLING CRADLE i Phone CASE-KAWAII GIRL- / X[Black]
46812 ROLLING CRADLE CANVAS NEON OVERALL / Brown
46813 ROLLING CRADLE CANVAS NEON OVERALL / Black
46814 ROLLING CRADLE ROLLCRDL LOGO T-SHIRT / White
46815 ROLLING CRADLE ROLLCRDL LOGO T-SHIRT / Black
46941 ROLLING CRADLE RC NYLON SHORTS / Gray
46942 ROLLING CRADLE RC NYLON SHORTS / Black
46943 ROLLING CRADLE CYCLOPS HOLIDAY -SMILE- / White
46944 ROLLING CRADLE CYCLOPS HOLIDAY -SMILE- / Black
47715 ROLLING CRADLE CHECK PANTS / Gray