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-05-01 22:45:12')
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
LIMIT 0, 60
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