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 18:14:52')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 365)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 1440, 120
51478 KONUS K-400490 Fully Fashioned Oversize Sweater with Pocket GREEN
51480 KONUS K-80616 Mock Collar Bomber Jacket with Pockets GREEN
51481 KONUS K-400492 Sweatshirt with Reflective Tape BLACK
51482 KONUS K-400492 Sweatshirt with Reflective Tape ORANGE
52495 SALUTE REMADE HOODIE
52496 SALUTE DOUBLE LAYER HOODIE
52497 SALUTE CORDUROY PANTS
52498 SALUTE PANTS CHAIN
52499 SALUTE BUTTERFLY BRACELET
52528 FAR★STAR SKULL ロンT BLACK×WHITE
52529 FAR★STAR SKULL BIGパーカー BLACK×WHITE
52530 FAR★STAR 蟻地獄-ANT HELL HOTEL- BLACK×BLUE
52531 FAR★STAR 目豹BIG T BLACK×WHITE
52532 FAR★STAR ピンストロゴ ロンT BLACK×WHITE
52533 FAR★STAR ピンストロゴ BIGパーカー BLACK×WHITE
52560 Evae mob *EVAE+ Smiley Necklace Green
52561 SALUTE BUTTERFLY NECKLACE
52582 REBEL8 No Bad Daze Longsleeve Tee
52583 REBEL8 Your Enemies Are Mine Pullover Hoodie
52584 REBEL8 Your Enemies Are Mine Longsleeve Tee
52661 REBEL8×Slayer Slayer Jacket
52666 REBEL8×SLAYER Slayer Army Pullover Hoodie
52667 REBEL8×SLAYER South Of Heaven Pullover Hoodie
52668 REBEL8×SLAYER Slayer Army Sweatpant
52669 REBEL8×Slayer Slayer Army Longsleeve Tee
52670 REBEL8×SLAYER South Of Heaven Longsleeve Tee
52671 REBEL8×SLAYER Black Magic Tee
52672 REBEL8×SLAYER Show No Mercy Tee
52673 REBEL8×SLAYER God Hates Us All Snapback
52674 REBEL8×Slayer Slayer LP Snapback
53955 KONUS Sweatshirt With Zipper chest pocket BLACK
53956 KONUS Sweatshirt With Zipper chest pocket WHITE
53957 KONUS Color Blocked Oversized Short Sleeve BLACK
53958 KONUS Color Blocked Oversized Short Sleeve TEAL
53959 KONUS Color Blocked Cotton Twill Oversized Shirt BLACK
51479 KONUS K-80616 Mock Collar Bomber Jacket with Pockets BLACK