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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =97
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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 20:34:31')
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, 60
69952 ROLLING CRADLE (ローリングクレイドル) STRAWBERRY BORDER LONGSLEEVE BROWN
69953 ROLLING CRADLE (ローリングクレイドル) STRAWBERRY BORDER LONGSLEEVE BURGUNDY
69954 ROLLING CRADLE (ローリングクレイドル) STRAWBERRY BORDER LONGSLEEVE PURPLE
69474 ROLLING CRADLE (ローリングクレイドル) CREAM LONGSLEEVE WHITE
69475 ROLLING CRADLE (ローリングクレイドル) CREAM LONGSLEEVE EMERALD
65801 ROLLING CRADLE(ローリングクレイドル) R LONG SLEEVE BURGUNDY
65802 ROLLING CRADLE(ローリングクレイドル) R LONG SLEEVE NAVY
65803 ROLLING CRADLE(ローリングクレイドル) YF LONG SLEEVE BURGUNDY
65804 ROLLING CRADLE(ローリングクレイドル) YF LONG SLEEVE BLACK
62587 ROLLING CRADLE BURNED LOGO LONG SLEEVE / YELLOW
62588 ROLLING CRADLE BURNED LOGO LONG SLEEVE / BLACK
62132 ROLLING CRADLE SMILE LONG SLEEVE WHITE
62133 ROLLING CRADLE SMILE LONG SLEEVE BLACK
60704 ROLLING CRADLE LOGO ROSE LONG SLEEVE / PINK
60703 ROLLING CRADLE LOGO ROSE LONG SLEEVE / BLACK
60543 ROLLING CRADLE COSPLAY GIRL-MOON- LONG SLEEVE / WHITE
60544 ROLLING CRADLE COSPLAY GIRL-MOON- LONG SLEEVE / NAVY
57789 ROLLING CRADLE 天使と悪魔 LONG SLEEVE / BLACK
58120 ROLLING CRADLE RIDER LONG SLEEVE / BROWN
58118 ROLLING CRADLE RIDER LONG SLEEVE / WHITE
58119 ROLLING CRADLE RIDER LONG SLEEVE / GREEN
57788 ROLLING CRADLE 天使と悪魔 LONG SLEEVE / WHITE
56260 ROLLING CRADLE CIRCLE LOGO LONG SLEEVE / NAVY
56261 ROLLING CRADLE CIRCLE LOGO LONG SLEEVE / EMERALD
56174 ROLLING CRADLE SF FAMILY LOGO SLEEVE / BLUE
56175 ROLLING CRADLE SF FAMILY LOGO SLEEVE / WHITE
55991 ROLLING CRADLE MENEKI-NEKO LONG SLEEVE / BERRY
55992 ROLLING CRADLE MENEKI-NEKO LONG SLEEVE / PEPPER
13890 ROLLING CRADLE MANEATERS LONG T-SHIRT GRAY
16667 ROLLING CRADLE POP-ART LONG T-SHIRT / Black
16668 ROLLING CRADLE POP-ART LONG T-SHIRT / White
23737 ROLLING CRADLE FREAK OUT LONG Tee / White
23738 ROLLING CRADLE FREAK OUT LONG Tee / Gray
23739 ROLLING CRADLE FREAK OUT LONG Tee / Red
23740 ROLLING CRADLE FREAK OUT LONG Tee / Black
28668 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT WHITE
28669 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT RED
28670 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT BLUE
28673 ROLLING CRADLE RCxTHRASHER LONG T-SHIRT BLACK
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
32544 ROLLING CRADLE R-kn BEACH LONG T-SHIRT White
32545 ROLLING CRADLE R-kn BEACH LONG T-SHIRT / Black
37168 ROLLING CRADLE DELICIOUS TACOS LONG T-SHIRT / Orange
37169 ROLLING CRADLE DELICIOUS TACOS LONG T-SHIRT / Green
37170 ROLLING CRADLE DELICIOUS TACOS LONG T-SHIRT / Blue
37171 ROLLING CRADLE DELICIOUS TACOS LONG T-SHIRT / Black
37349 ROLLING CRADLE SAMURAI BOP LONG T-SHIRT / Pink
37351 ROLLING CRADLE SAMURAI BOP LONG T-SHIRT / Gray
37352 ROLLING CRADLE SAMURAI BOP LONG T-SHIRT / Black
37353 ROLLING CRADLE SAMURAI BOP LONG T-SHIRT / Yellow
37519 ROLLING CRADLE RCxE.T. GERTY KISS LONG T-SHIRT / Black
37520 ROLLING CRADLE RCxE.T. GERTY KISS LONG T-SHIRT / White
37521 ROLLING CRADLE RCxE.T. MOON LIGHT LONG T-SHIRT / Black
37522 ROLLING CRADLE RCxE.T. MOON LIGHT LONG T-SHIRT / White
37798 ROLLING CRADLE GEGEGE NO BACK BEARD LONG T-SHIRT / White