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-18 06:43:11')
AND pc.classcategory_id1 IN( 159)
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
LIMIT 0, 75
53099 PUNK DRUNKERS [PDS×仮面ライダー]仮面ライダーゼロワンTEE INDIGO
53101 PUNK DRUNKERS PDS×仮面ライダー]滅亡迅雷.net ロンTEE BLACK
53102 PUNK DRUNKERS [PDS×仮面ライダー]仮面ライダーゼロワンTEE WHITE
53103 PUNK DRUNKERS PDS×仮面ライダー]滅亡迅雷.net ロンTEE WHITE
53104 PUNK DRUNKERS あいつピエロンTEE BLACK
53105 PUNK DRUNKERS あいつピエロンTEE WHITE
53991 PUNK DRUNKERS ダブルベッドTEE BLACK
53992 PUNK DRUNKERS ダブルベッドTEE PURPLE
53996 PUNK DRUNKERS 聞こえないTEE'20 / REVIVAL - BLACK
54003 PUNK DRUNKERS ゲーマー少年TEE'20 / REVIVAL - D.PURPLE
54004 PUNK DRUNKERS ゲーマー少年TEE'20 / REVIVAL - SLATE
54005 PUNK DRUNKERS ステッカーTEE'20 / REVIVAL - WHITE
54006 PUNK DRUNKERS ステッカーTEE'20 / REVIVAL - M.GREEN
54062 PUNK DRUNKERS [PDSxくっきー!]歯ポケロンTEE - BLACK
54063 PUNK DRUNKERS [PDSxくっきー!]歯ポケロンTEE - N.ORANGE
54064 PUNK DRUNKERS [PDSxくっきー!]ミスティTEE - BLACK
54065 PUNK DRUNKERS [PDSxくっきー!]ミスティTEE - KHAKI
54287 PUNK DRUNKERS[PDSx片桐仁]片桐あいつTEE - SUMI
54288 PUNK DRUNKERS[PDSx片桐仁]片桐あいつTEE - PURPLE
54541 PUNK DRUNKERS [PDSxデラべっぴん]デラぱんくどTEE WHITE
54542 PUNK DRUNKERS [PDSxデラべっぴん]デラぱんくどTEE BLACK
54543 PUNK DRUNKERS REAL MONSTER.TEE BLACK
54544 PUNK DRUNKERS REAL MONSTER.TEE LIME
54545 PUNK DRUNKERS ポケットから女TEE BLACK
54546 PUNK DRUNKERS ポケットから女TEE LT.PINK
54751 PUNK DRUNKERS イギリス人TEE BLACK
55550 PUNK DRUNKERS AITSU.TEE WHITE
55551 PUNK DRUNKERS AITSU.TEE BLACK
54861 PUNK DRUNKERS [PDSxTHUNDERBOX]NOW TOKYOロンTEE - WHITE
54862 PUNK DRUNKERS [PDSxTHUNDERBOX]NOW TOKYOロンTEE - BLACK
55809 PUNK DRUNKERS 顔コンペTEE'20 - WHITE
55810 PUNK DRUNKERS 顔コンペTEE'20 - SAND.KHAKI
54857 PUNK DRUNKERS [PDSxPAC-MAN]逃げロンTEE - BLACK
54858 PUNK DRUNKERS [PDSxPAC-MAN]逃げロンTEE - N.YELLOW
54832 PUNK DRUNKERS メニメニプリントパーカ - BLACK
54854 PUNK DRUNKERS あいつに変身トレーナー - WHITE
54855 PUNK DRUNKERS あいつに変身トレーナー - LT.PINK
54856 PUNK DRUNKERS あいつに変身トレーナー - D.YELLOW
54865 PUNK DRUNKERS 唐揚げおじさんロンTEE - ASH
54866 PUNK DRUNKERS 唐揚げおじさんロンTEE - LT.PINK
56637 PUNK DRUNKERS スピーカーパーカ - BLACK
56638 PUNK DRUNKERS スピーカーパーカ - M.GRAY
56649 PUNK DRUNKERS 反区怒飯店ロンTEE - WHITE
56650 PUNK DRUNKERS 反区怒飯店ロンTEE - D.YELLOW
56609 PUNK DRUNKERS 大統領TEE - WHITE
56645 PUNK DRUNKERS [PDSxGODZILLA]ゴジラからあいつロンTEE - BLACK
56646 PUNK DRUNKERS [PDSxGODZILLA]ゴジラからあいつロンTEE - KHAKI
56653 PUNK DRUNKERS [PDSxLAND by MILKBOY]ブラザーズTEE - BLACK
56654 PUNK DRUNKERS [PDSxLAND by MILKBOY]ブラザーズTEE - ASH
56655 PUNK DRUNKERS [PDSxLAND by MILKBOY]ブラザーズTEE - LT.GREEN
56681 PUNK DRUNKERS PT.TEE - BLACK
58206 PUNK DRUNKERS 人間大砲ポケTEE - BLACK
58183 PUNK DRUNKERS [PDSxぷよぷよ]あいつぷよTEE - BLACK
58184 PUNK DRUNKERS [PDSxぷよぷよ]あいつぷよTEE - A.GREEN
58187 【予約商品】PUNK DRUNKERS [PDSxなかやまきんに君]パワーTEE - WHITE
58188 【予約商品】PUNK DRUNKERS [PDSxなかやまきんに君]パワーTEE - BLACK
59125 PUNK DRUNKERS[PDSxPAC-MAN]GAMER.TEE - C.BEIGE
59135 PUNK DRUNKERS 鮫人パジャマTEE - A.GREEN
59134 PUNK DRUNKERS 鮫人パジャマTEE - D.YELLOW
59129 PUNK DRUNKERS[PDSx鬼越トマホーク]鬼越トマホーク刺繍TEE - M.PURPLE
59128 PUNK DRUNKERS[PDSx鬼越トマホーク]鬼越トマホーク刺繍TEE - WHITE
59124 PUNK DRUNKERS[PDSxPAC-MAN]GAMER.TEE - WHITE
59935 【予約商品】PUNK DRUNKERS 反抗期ロンTEE - BLACK
59933 PUNK DRUNKERS ダブロンTEE - BLACK
59934 PUNK DRUNKERS ダブロンTEE - D.GREEN
59931 PUNK DRUNKERS ウーロンTEE - BLACK
59932 PUNK DRUNKERS ウーロンTEE - ASH
59940 PUNK DRUNKERS [PDSxGreatMUTA]タッグTEE - D.H.NAVY
59939 PUNK DRUNKERS [PDSxGreatMUTA]タッグTEE - SUMI
59907 PUNK DRUNKERS [PDSxCOCALERO]コカボムあいつパーカー - BLACK
59877 PUNK DRUNKERS [PDSxGreatMUTA]グレート・ムタ スカジャン / BLACK - BLACK/GREEN
59876 PUNK DRUNKERS [PDSxGreatMUTA]グレート・ムタ スカジャン / BLUE - BLUE/BLACK
60955 PUNK DRUNKERS [PDSx中華蕎麦とみ田]衣食TEE - SLATE
60943 PUNK DRUNKERS マスクメロンTEE - D.GREEN
60942 PUNK DRUNKERS マスクメロンTEE - BLACK