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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =588
)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-04-19 15:31:33')
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
69470 ROLLING CRADLE (ローリングクレイドル) OSHI HOODIE ICEBLUE
69471 ROLLING CRADLE (ローリングクレイドル) OSHI HOODIE YELLOW
69472 ROLLING CRADLE (ローリングクレイドル) OSHI HOODIE BLACK
66707 ROLLING CRADLE(ローリングクレイドル) 2023 NEW YEAR LOGO HOODIE BLACK
66305 幽遊白書×ROLLING CRADLE 集合 HOODIE / BLACK
62774 ROLLING CRADLE CNS HOODIE / YELLOW
62773 ROLLING CRADLE CNS HOODIE / BLACK
60813 ROLLING CRADLE COSPLAY GIRL-THUNDER- HOODIE / BLACK
60814 ROLLING CRADLE COSPLAY GIRL-THUNDER- HOODIE / PINK
60765 ROLLING CRADLE LOGO ROSE HOODIE / BLACK
60766 ROLLING CRADLE LOGO ROSE HOODIE / RED
58015 ROLLING CRADLE FIRE HOODIE / PURPLE
57803 ROLLING CRADLE LMS HOODIE / BLACK
56022 ROLLING CRADLE HONESTY HOODIE / BLACK
15789 ROLLING CRADLE SD ROLICLE HOODIE / Black
21188 ROLLING CRADLE RC REFLECTION HOODIE / Blue
21189 ROLLING CRADLE RC REFLECTION HOODIE / Burgundy
21190 ROLLING CRADLE RC REFLECTION HOODIE / Black
21523 ROLLING CRADLE RC×Mark Gonzales ANGEL HOODIE / BLK
21527 ROLLING CRADLE RC×Mark Gonzales CLOUD HOODIE / WHT
21528 ROLLING CRADLE RC×Mark Gonzales CLOUD HOODIE / GRY
21529 ROLLING CRADLE RC×Mark Gonzales CLOUD HOODIE / BLK
22008 ROLLING CRADLE Troopers Hoodie WHT
22009 ROLLING CRADLE Troopers Hoodie BLK
22951 ROLLING CRADLE BOX FOAM LOGO HOODIE / Black
22952 ROLLING CRADLE BOX FOAM LOGO HOODIE / Blue
22953 ROLLING CRADLE BOX BOX FOAM LOGO HOODIE / Red
22954 ROLLING CRADLE BOX FOAM LOGO HOODIE / White
23886 ROLLING CRADLE FLUFFY HALF HOODIE / Gray
23887 ROLLING CRADLE FLUFFY HALF HOODIE / Red
23889 ROLLING CRADLE FLUFFY HALF HOODIE / Navy
28969 ROLLING CRADLE KANJI LOGO HOODIE / White
28970 ROLLING CRADLE KANJI LOGO HOODIE / 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
29496 ROLLING CRADLE (ロリクレ) ROLLING-BAR HOODIE / White
29497 ROLLING CRADLE (ロリクレ) ROLLING-BAR HOODIE / Gray
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
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
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
34452 ROLLING CRADLE FAKE LAYERED HOODIE / White
34453 ROLLING CRADLE FAKE LAYERED HOODIE / Navy
37346 ROLLING CRADLE RC CYCLOPS TERROR HOODIE / Black
37347 ROLLING CRADLE RC CYCLOPS TERROR HOODIE / Burgundy
37348 ROLLING CRADLE RC CYCLOPS TERROR HOODIE / Navy
37592 ROLLING CRADLE RLIG CDLE PIGMENT HOODIE / Pink
37593 ROLLING CRADLE RLIG CDLE PIGMENT HOODIE / Turquoise
37594 ROLLING CRADLE RLIG CDLE PIGMENT HOODIE / Red