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 =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-20 07:47:10')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 490)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
58760 SILLENT FROM ME EYE WHITE
58762 SILLENT FROM ME HURT WHITE
58763 SILLENT FROM ME HURT BLACK
58767 SILLENT FROM ME FILLM -Pocket- BLACK
58766 SILLENT FROM ME FILLM -Pocket- WHITE
58761 SILLENT FROM ME EYE BLACK
58764 SILLENT FROM ME WORDS WHITE
58765 SILLENT FROM ME WORDS BLACK
58486 SILLENT FROM ME SPELL -Patterned Cutsew-BLACK/BLACK
58485 SILLENT FROM ME SPELL -Patterned Cutsew-BLACK/WHITE
58487 SILLENT FROM ME SPELL -Patterned Cutsew-WHITE
20221 SILLENT FROM ME CRYPTIC BLK
20222 SILLENT FROM ME CRYPTIC WHT
20223 SILLENT FROM ME VOICE BLK
20224 SILLENT FROM ME VOICE WHT
20226 SILLENT FROM ME ARTIFICIAL WHT
20227 SILLENT FROM ME ARTIFICIAL BLK
20228 SILLENT FROM ME SPELL BLK
20229 SILLENT FROM ME SPELL WHT
20453 SILLENT FROM ME QUIET BLACK
20454 SILLENT FROM ME QUIET WHITE
20455 SILLENT FROM ME DIVISION BLACK
20456 SILLENT FROM ME DIVISION WHITE
23721 SILLENT FROM ME NORM-Tereko Long Tee- WHITE
23907 SILLENT FROM ME ANACHRONIC BLACK
23908 SILLENT FROM ME ANACHRONIC WHITE
24331 SILLENT FROM ME D&C BLACK
24332 SILLENT FROM ME D&C WHITE
24427 SILLENT FROM ME CIRCLE BLACK
24428 SILLENT FROM ME CIRCLE WHITE
24430 SILLENT FROM ME TRIANGLE BLACK
24431 SILLENT FROM ME TRIANGLE WHITE
24433 SILLENT FROM ME SQUARE WHITE
24546 SILLENT FROM ME DEPRESSED BLACK
24547 SILLENT FROM ME DEPRESSED WHITE
24548 SILLENT FROM ME 771#-Pocket- BLACK
24549 SILLENT FROM ME 771#-Pocket- WHITE
24569 SILLENT FROM ME CREST BLACK
24570 SILLENT FROM ME CREST WHITE
24573 SILLENT FROM ME RITUAL WHITE
24574 SILLENT FROM ME RITUAL BLACK
24840 SILLENT FROM ME "20"MINOR LEAGUE Collaboration BLACK
24841 SILLENT FROM ME "20"MINOR LEAGUE Collaboration WHITE
24845 SILLENT FROM ME "20" -Pocket- MINOR LEAGUE Collaboration BLACK
24847 SILLENT FROM ME "20" -Pocket- MINOR LEAGUE Collaboration WHITE
25469 SILLENT FROM ME HOOKY -Wide Half Sleeve- BLACK
25471 SILLENT FROM ME HOOKY -Wide Half Sleeve- WHITE
25472 SILLENT FROM ME LOSE BLACK
25474 SILLENT FROM ME LOSE WHITE
25475 SILLENT FROM ME CRYPTIC -Drape Tee- BLACK
25477 SILLENT FROM ME CRYPTIC -Drape Tee- WHITE
26220 SILLENT FROM ME DROUGHT BLACK
26221 SILLENT FROM ME DROUGHT WHITE
26224 SILLENT FROM ME ICON-Pocket- BLACK
26225 SILLENT FROM ME ICON-Pocket- WHITE
28434 SILLENT FROM ME ENCRYPTION WHT
28435 SILLENT FROM ME ENCRYPTION BLK
28436 SILLENT FROM ME TEAR WHT
28437 SILLENT FROM ME TEAR BLK
28684 SILLENT FROM ME DENSE BLACK