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-05-20 06:53:48')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 349)
AND pc.del_flg = 0
GROUP BY p.product_id
LIMIT 0, 60
53162 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE BLACK
53163 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE ORANGE
53970 TOY MACHINE SKATE DATE SST (BIG SIZE) - WHITE
53971 TOY MACHINE SKATE DATE SST (BIG SIZE) - BLACK
54206 TOY MACHINE PRINT POCKET SST (BIG SIZE) - WHITE
54207 TOY MACHINE PRINT POCKET SST (BIG SIZE) - BLACK
54208 TOY MACHINE SKATE SECT TIE-DYE SST - BLAST
54209 TOY MACHINE SKATE SECT TIE-DYE SST - PINK
54210 TOY MACHINE SKATE SECT TIE-DYE SST - SATURN
58033 TOY MACHINE MONSTER 3/4 SLEEVE TEE-WHITE
58034 TOY MACHINE MONSTER 3/4 SLEEVE TEE-BLACK
58035 TOY MACHINE SECT MARK PRINT SS TEE - WHITE
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
58153 TOY MACHINE (トイマシーン) PYLAMID SECT T-Shirt WHITE
58154 TOY MACHINE (トイマシーン) PYLAMID SECT T-Shirt BLACK
58155 TOY MACHINE (トイマシーン) TURTLEBOY T-Shirt WHITE
58156 TOY MACHINE TURTLEBOY T-Shirt BLACK
58157 TOY MACHINE MONSTER T-Shirt BLACK
58158 TOY MACHINE MONSTER T-Shirt BLUE
58159 TOY MACHINE MONSTER T-Shirt WHITE
58587 TOY MACHINE OG MONSTER SS WIDE TEE WHITE
58588 TOY MACHINE (トイマシーン) OG MONSTER SS WIDE TEE BLACK
58589 TOY MACHINE (トイマシーン) TOYMONSTER EMB SS TEE WHITE
58590 TOY MACHINE (トイマシーン) TOYMONSTER EMB SS TEE BLACK
58591 TOY MACHINE CHARACTERS SS TEE PINK
58592 TOY MACHINE (トイマシーン) CHARACTERS SS TEE WHITE
58781 TOY MACHINE (トイマシーン) DESIGN PRINT TEE LEMON
58782 TOY MACHINE (トイマシーン) DESIGN PRINT TEE PINK
58784 TOY MACHINE (トイマシーン) DESIGN PRINT TEE FUNNEL CAKE
58785 TOY MACHINE (トイマシーン) DESIGN PRINT TEE COTTON CANDY
62535 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE TOYMONSTER - WHITE
62536 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE TOYMONSTER - BLACK
62609 TOY MACHINE (トイマシーン) ERIC FOUNTAIN HEAVY WEIGHT BIG SS TEE - WHITE
62610 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - BLACK
62611 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - L. BLUE
62612 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - WHITE
63004 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - WHITE
63005 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - YELLOW
63006 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - BLACK
63007 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - WHITE
63008 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - SAND
63009 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - BLACK
63211 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE MOHAWK - WHITE
63212 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE MOHAWK - BLACK
63227 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - WHITE
63228 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - BLACK
63229 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - WHITE
63230 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - BLACK
63231 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - L.BLUE
63232 TOY MACHINE (トイマシーン) AXEL SS TEE - WHITE
63233 TOY MACHINE (トイマシーン) AXEL SS TEE - BLACK
63234 TOY MACHINE (トイマシーン) AXEL SS TEE - PURPLE
63674 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - WHITE
63675 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - ORANGE
63676 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - BLACK
64212 TOY MACHINE×PUNK DRUNKERS AITSU AND THE CHARACTERS SS TEE - WHITE
64213 TOY MACHINE×PUNK DRUNKERS AITSU AND THE CHARACTERS SS TEE - BLACK
64214 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG SS TEE - WHITE
64215 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG SS TEE - MINT
64216 TOY MACHINE×PUNK DRUNKERS AITSU AND TOYMONSTER IN TURTLE HEAD SS TEE - WHITE