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-26 01:05:00')
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 600, 120
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
26333 ROLLING CRADLE RC RESORT HAT / White
26334 ROLLING CRADLE RC RESORT HAT / Black
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
26343 ROLLING CRADLE PROUD 2 RC BELL HAT / Indigo-Yellow
26344 ROLLING CRADLE PROUD 2 RC BELL HAT / Red-Pink
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
26617 ROLLING CRADLE PROUD 2 RC DUFFLE BAG / Pink
26618 ROLLING CRADLE PROUD 2 RC DUFFLE BAG / 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
28535 ROLLING CRADLE VAGABOND CYCLOPS -USA- CAP / Black
28536 ROLLING CRADLE VAGABOND CYCLOPS -USA- CAP / Indigo
28537 ROLLING CRADLE BiG CYCLOPS DAY BAG / Crazy
28538 ROLLING CRADLE BiG CYCLOPS DAY BAG / Navy
28539 ROLLING CRADLE BiG CYCLOPS DAY BAG / Black
28542 ROLLING CRADLE CYCLOPS SHOUT SACOCHE / Blue-Orange
28543 ROLLING CRADLE CYCLOPS SHOUT SACOCHE / Yellow-Purple
28544 ROLLING CRADLE CYCLOPS SHOUT SACOCHE / Charcoal-Purple
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
28675 ROLLING CRADLE RC CLASSIC LOGO KNIT CAP MUSTARD
28676 ROLLING CRADLE RC CLASSIC LOGO KNIT CAP BURGUNDY
28679 ROLLING CRADLE 6090 GLASSES-DOG OUT- BLACK
28680 ROLLING CRADLE 6090 GLASSES-DOG OUT- BROWN
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
28893 ROLLING CRADLE BELL HAT / Green
28894 ROLLING CRADLE BELL HAT / 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
28978 ROLLING CRADLE CYCLOPS SHOUT PEN CASE / Beige
28981 ROLLING CRADLE CYCLOPS SHOUT CIRCLE POUCH / Beige
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
29499 ROLLING CRADLE (ロリクレ) CYCLOPS SHOUT NECK WARMER / Gray-Black
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
29747 ROLLING CRADLE (ロリクレ) RC LOGO PIERCE / SILVER 925
29940 ROLLING CRADLE RAIGYO M-65 JKT Indigo
29941 ROLLING CRADLE RC DUFFLE COURT Black
32005 ROLLING CRADLE RC iQOS COVER / RC-ALL STARS
32006 ROLLING CRADLE RC iQOS COVER / Enough
32007 ROLLING CRADLE RC iPhone Case Note Type / Enough
32008 ROLLING CRADLE RC iPhone Case Note Type / RC-ALL STARS
32098 ROLLING CRADLE RC MOBILE BATTERY CASSETE
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
32272 ROLLING CRADLE (ロリクレ) Donut of Heart TOTE / Natural