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 05:43:19')
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 480, 120
25502 ROLLING CRADLE RC OFFICIAL T / Red-Blue
25503 ROLLING CRADLE RC OFFICIAL T / Blue-Red
25504 ROLLING CRADLE WAIKIKI BASE BALL-SHIRT / Blue
25505 ROLLING CRADLE WAIKIKI BASE BALL-SHIRT / Tropical
26328 ROLLING CRADLE VAGABOND CYCLOPS -SKATE- Tee / White
26329 ROLLING CRADLE VAGABOND CYCLOPS -SKATE- Tee / Red
26330 ROLLING CRADLE VAGABOND CYCLOPS -SKATE- Tee / Black
26331 ROLLING CRADLE BIRD WREATH SHORTS / Bird-Navy
26332 ROLLING CRADLE BIRD WREATH SHORTS / Camo-Green
26335 ROLLING CRADLE ONE BEER WORK SHIRT / Black
26337 ROLLING CRADLE AZTECA SHORTS / Beige
26338 ROLLING CRADLE AZTECA SHORTS / Navy-Red
26339 ROLLING CRADLE AZTECA SHORTS / Gray
26340 ROLLING CRADLE PEEPING CYCLOPS / White
26341 ROLLING CRADLE PEEPING CYCLOPS / Orange
26342 ROLLING CRADLE PEEPING CYCLOPS / Navy
26613 ROLLING CRADLE PROUD 2 RC BIG SHIRT / Pink
26614 ROLLING CRADLE PROUD 2 RC BIG SHIRT / Green
26615 ROLLING CRADLE PROUD 2 RC BIG POCKET Tee / Pink
26616 ROLLING CRADLE PROUD 2 RC BIG POCKET Tee / Yellow
27474 ROLLING CRADLE AIN’T 2 PROUD BIG Tee / White
27476 ROLLING CRADLE AIN’T 2 PROUD BIG Tee / Black
28239 ROLLING CRADLE RCxTHRASHER THRASHE'M ALL!! TEE WHT
28390 ROLLING CRADLExMONSTER ROCK COLLABORATION MAD NOISE!! -怒りのデスステージ- White
28391 ROLLING CRADLExMONSTER ROCK COLLABORATION MAD NOISE!! -怒りのデスステージ- Black
28517 ROLLING CRADLE CHIDORI SHORTS / Gray
28520 ROLLING CRADLE CHIDORI SHORTS / Charcoal
28524 ROLLING CRADLE RCxSESAMI STREET T-SHIRT / White
28527 ROLLING CRADLE RCxSESAMI STREET T-SHIRT / Red
28528 ROLLING CRADLE RCxSESAMI STREET T-SHIRT / Black
28530 ROLLING CRADLE KERMIT T-SHIRT / White
28532 ROLLING CRADLE KERMIT T-SHIRT / Gray
28534 ROLLING CRADLE KERMIT T-SHIRT / Black
28667 ROLLING CRADLE RAKURAI NEL NAVY
28668 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT WHITE
28669 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT RED
28670 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT BLUE
28671 ROLLING CRADLE RAKURAI NEL RED
28673 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT BLACK
28865 ROLLING CRADLE (ロリクレ) RAKURAI LONG NEL / Red
28866 ROLLING CRADLE (ロリクレ) RAKURAI LONG NEL / Navy
28867 ROLLING CRADLE (ロリクレ) HEXAGON CHANGER / Turquoise
28868 ROLLING CRADLE (ロリクレ) HEXAGON CHANGER / Navy
28869 ROLLING CRADLE (ロリクレ) HEXAGON CHANGER / Black
28870 ROLLING CRADLE (ロリクレ) 80s 3D LOGO LONG T-SHIRTS / Gray
28871 ROLLING CRADLE (ロリクレ) 80s 3D LOGO LONG T-SHIRTS / Red
28872 ROLLING CRADLE (ロリクレ) 80s 3D LOGO LONG T-SHIRTS / Black
28895 ROLLING CRADLE LOOSE SWEAT / Black
28896 ROLLING CRADLE LOOSE SWEAT / White
28897 ROLLING CRADLE GRAVY BIG SHIRTS / Black
28898 ROLLING CRADLE (ロリクレ) GRAVY BIG SHIRTS / Rainbow
28969 ROLLING CRADLE KANJI LOGO HOODIE / White
28970 ROLLING CRADLE KANJI LOGO HOODIE / Black
28972 ROLLING CRADLE ROLLCRDL-PAINT- SWEAT / Navy
28974 ROLLING CRADLE ROLLCRDL-PAINT- SWEAT / Black
28976 ROLLING CRADLE KANJI SWEAT PANTS / Black
29079 ROLLING CRADLE 8BIT CYCLOPS-SB COACH JKT / Navy
29080 ROLLING CRADLE 8BIT CYCLOPS-SB COACH JKT / Green
29081 ROLLING CRADLE 8BIT CYCLOPS-SB COACH JKT / Black
29082 ROLLING CRADLE BURGER SHIRT / Navy-Black
29083 ROLLING CRADLE GOOD MORNING NASTY HOODIE / Gray
29084 ROLLING CRADLE GOOD MORNING NASTY HOODIE / Green
29085 ROLLING CRADLE GOOD MORNING NASTY HOODIE / Black
29086 ROLLING CRADLE CYCLOPS SHOUT SWEAT / Turquoise
29087 ROLLING CRADLE CYCLOPS SHOUT SWEAT / White
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
29496 ROLLING CRADLE (ロリクレ) ROLLING-BAR HOODIE / White
29497 ROLLING CRADLE (ロリクレ) ROLLING-BAR HOODIE / Gray
29498 ROLLING CRADLE (ロリクレ) VAGABOND CYCLOPS -USA- KNIT / Navy
29595 ROLLING CRADLE RC SHAEL COVERALL / Navy
29596 ROLLING CRADLE RC SHAEL COVERALL / Black
29597 ROLLING CRADLE RC×SESAMI STREET HOODIE / Navy
29598 ROLLING CRADLE RC×SESAMI STREET HOODIE / Oatmeal
29599 ROLLING CRADLE RC×SESAMI STREET HOODIE / Black
29600 ROLLING CRADLE RC×KERMIT HOODIE / Black
29601 ROLLING CRADLE RC×KERMIT HOODIE / White
29602 ROLLING CRADLE RC SAROUEL PANTS / Indigo
29745 ROLLING CRADLE (ロリクレ) SHOUT LINE COACH JKT Red
29746 ROLLING CRADLE (ロリクレ) SHOUT LINE COACH JKT / Black
29940 ROLLING CRADLE RAIGYO M-65 JKT Indigo
29941 ROLLING CRADLE RC DUFFLE COURT Black
32130 ROLLING CRADLE RISING SUN DENIM
32209 ROLLING CRADLE MAGIC BALL COACH JKT BLK
32210 ROLLING CRADLE MAGIC BALL COACH JKT NVY
32211 ROLLING CRADLE MAGIC BALL COACH JKT GRN
32212 ROLLING CRADLE RCxTHRASHER -GO!GO!GO!- HOODIE BLACK
32213 ROLLING CRADLE RCxTHRASHER -GO!GO!GO!- HOODIE NAVY
32214 ROLLING CRADLE RCxTHRASHER -GO!GO!GO!- HOODIE GRAY
32215 ROLLING CRADLE MAGIC BALL SWEAT BLACK
32216 ROLLING CRADLE MAGIC BALL SWEAT WHT
32217 ROLLING CRADLE MAGIC BALL SWEAT GRAY
32418 ROLLING CRADLE GRAVY CHECK BIG SHIRT / Blue
32419 ROLLING CRADLE GRAVY CHECK BIG SHIRT / Brown
32420 ROLLING CRADLE R-kn BEACH ZIP HOODIE / Burgundy
32421 ROLLING CRADLE R-kn BEACH ZIP HOODIE / Black
32427 ROLLING CRADLE (ロリクレ) 6090 ALL STAR HOODIE NAVY
32428 ROLLING CRADLE (ロリクレ) 6090 ALL STAR HOODIE BLACK
32429 ROLLING CRADLE (ロリクレ) 6090 ALL STAR HOODIE GRAY
32430 ROLLING CRADLE (ロリクレ) 6090 ALL STAR HOODIE RED
32433 ROLLING CRADLE (ロリクレ) THUNDER GATE WIDE DENIM INDIGO
32435 ROLLING CRADLE (ロリクレ) THUNDER GATE WIDE DENIM ICEBLUE
32542 ROLLING CRADLE PINEAPPLE ALOHA BIG SHIRT White
32543 ROLLING CRADLE PINEAPPLE ALOHA BIG SHIRT Black
32544 ROLLING CRADLE R-kn BEACH LONG T-SHIRT White
32545 ROLLING CRADLE R-kn BEACH LONG T-SHIRT / Black
33426 ROLLING CRADLE (ロリクレ) RC×RESORTLOVER COCOYASHI SHORTS / Purple
33427 ROLLING CRADLE (ロリクレ) RC×RESORTLOVER COCOYASHI SHORTS / Black
33679 ROLLING CRADLE (ロリクレ) RC STANDARD SHORTS / Beige
33680 ROLLING CRADLE (ロリクレ) RC STANDARD SHORTS / Burgundy
33681 ROLLING CRADLE (ロリクレ) RC STANDARD SHORTS / Blue
33682 ROLLING CRADLE 80s 3D LOGO T-SHIRT / Gray
33683 ROLLING CRADLE 80s 3D LOGO T-SHIRT / White
33684 ROLLING CRADLE 80s 3D LOGO T-SHIRT / Black
33927 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT Orange
33928 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT Sumiblack
33929 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT White
33930 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT Burgundy