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 =1
)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-28 06:12:07')
AND FIND_IN_SET(1, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 371)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 120, 120
45183 PUNK DRUNKERS あいつヴァーナTEE BLACK
45184 PUNK DRUNKERS あいつヴァーナ ドルマンチュニック CHARCOAL
46967 PUNK DRUNKERS [PDSxガチャピン・ムック]あいつと仲良しTEE BLACK
46968 PUNK DRUNKERS [PDSxガチャピン・ムック]コントロールTEE SUMI
46973 PUNK DRUNKERS [PDSx丸山ゴンザレス]まるゴンTEE BLACK
46977 PUNK DRUNKERS [PDSxCOCALERO]コカレロドランカーズTEE BLACK
46985 PUNK DRUNKERS 双子BIG TEE BLACK
46990 PUNK DRUNKERS 鮫人シールTEE BLACK
46992 PUNK DRUNKERS パンクドヒーローズTEE BLACK
46993 PUNK DRUNKERS 仙人あいつTEE BLACK
47003 PUNK DRUNKERS ぽっちゃいつレディースワイドTEE BLACK
48498 【PDS×まあたそ×ゲキクロ】まあたそとあいつTEE BLACK
49676 PUNK DRUNKERS 21周年TEE BLACK
49688 PUNK DRUNKERS アダルトトイズTEE / 復刻シリーズ BLACK
49690 PUNK DRUNKERS [PDSx野性爆弾くっきー]くっきードランカーズTEE'02 BLACK
49994 PUNK DRUNKERS ダラダラロゴBIG.TEE / O.Fシリーズ BLACK
50174 PUNK DRUNKERS [PDSxPEACEMAKER]あいつトライバルTEE BLACK
50464 PUNK DRUNKERS [PDSx日野日出志]アイツ地獄変TEE BLACK
52718 PUNK DRUNKERS [PDS×クレヨンしんちゃん]ケツだけ星人ズTEE SUMI
52720 PUNK DRUNKERS [PDSxクレヨンしんちゃん]サトーココノカドーTEE BLACK
52721 PUNK DRUNKERS 89F.TEE BLACK
54064 PUNK DRUNKERS [PDSxくっきー!]ミスティTEE - BLACK
54542 PUNK DRUNKERS [PDSxデラべっぴん]デラぱんくどTEE BLACK
54543 PUNK DRUNKERS REAL MONSTER.TEE BLACK
54545 PUNK DRUNKERS ポケットから女TEE BLACK