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 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-20 07:24:26')
AND pc.classcategory_id1 IN( 11)
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, 120
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
58488 SILLENT FROM ME FILLM -Loose Long Sleeve- BLACK
58489 SILLENT FROM ME FILLM -Loose Long Sleeve- WHITE
57827 SILLENT FROM ME WORDS -Crew Sweat- WHITE
57825 SILLENT FROM ME EYE -Pullover- WHITE
57826 SILLENT FROM ME EYE -Pullover- BLACK
57828 SILLENT FROM ME WORDS -Crew Sweat- BLACK
43265 SILLENT FROM ME STIGMA -Pullover- WHITE
37626 SILLENT FROM ME PYRAMID -Crew Sweat- WHITE
39981 SILLENT FROM ME MESS -Pullover- Black
39846 SILLENT FROM ME ALEXIA -Crew Sweat- Black
56748 SILLENT FROM ME 沈黙・不穏 -Loose Pullover- BLACK
56749 SILLENT FROM ME 沈黙・不穏 -Loose Pullover- WHITE
56750 SILLENT FROM ME 沈黙・秘密 -Loose Crew Sweat- WHITE
56751 SILLENT FROM ME 沈黙・秘密 -Loose Crew Sweat- BLACK
56051 SILLENT FROM ME COVER -Pullover- BLACK
56052 SILLENT FROM ME COVER -Pullover- WHITE
53126 SILLENT FROM ME PHILOSOPHY -Crew Sweat- BLACK
56053 SILLENT FROM ME PHILOSOPHY -Crew Sweat- WHITE
55986 SILLENT FROM ME 沈黙・不穏 -Loose Long Sleeve- BLACK
55987 SILLENT FROM ME 沈黙・不穏 -Loose Long Sleeve- 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
20457 SILLENT FROM ME ARTIFICIAL -Broad Shirts- WHITE
20458 SILLENT FROM ME ARTIFICIAL -Broad Shirts- BLACK
21167 SILLENT FROM ME CIRCLE -Longsleeve- WHITE
21170 SILLENT FROM ME SQUARE -Ziphood- BLACK
21171 SILLENT FROM ME SQUARE -Ziphood- WHITE
21303 SILLENT FROM ME D&C -Coach Jkt- Black
21304 SILLENT FROM ME D&C -Coach Jkt- White
21309 SILLENT FROM ME FU-Ziphood- White
21311 SILLENT FROM ME FU-Ziphood- Black
21511 SILLENT FROM ME QUIET -Pullover- BLACK
21512 SILLENT FROM ME QUIET -Pullover- WHITE
21513 SILLENT FROM ME D&C -Pullover- BLACK
21514 SILLENT FROM ME D&C -Pullover- WHITE
21515 SILLENT FROM ME CRYPTIC -Coach Jkt- BLACK
21516 SILLENT FROM ME CRYPTIC -Coach Jkt- WHITE
21653 SILLENT FROM ME DIVISION -NylonJkt-
21850 SILLENT FROM ME CRYPTIC -Crew Sweat- BLACK
21851 SILLENT FROM ME CRYPTIC -Crew Sweat- WHITE
21852 SILLENT FROM ME VOICE -Crew Sweat- BLACK
21853 SILLENT FROM ME VOICE -Crew Sweat- WHITE
21854 SILLENT FROM ME MEOW -Pullover-
21855 SILLENT FROM ME NORM -Waffle- BLACK
21856 SILLENT FROM ME NORM -Waffle- WHITE
22175 SILLENT FROM ME DIVISION -Pullover- WHT
22176 SILLENT FROM ME DIVISION -Pullover- BLK
22201 SILLENT FROM ME DOPE -Ziphood- BLACK
22203 SILLENT FROM ME DOPE -Ziphood- WHITE
22383 SILLENT FROM ME SPELL -Longsleeve- WHT
22384 SILLENT FROM ME SPELL -Longsleeve- BLK
22532 DEADHEARTZ X SILLENT FROM ME ZIP HOODIE BLACK
22533 DEADHEARTZ x SILLENT FROM ME ZIP HOODIE DARK
22877 SILLENT FROM ME DEPRESSED-Pullover- BLACK
22878 SILLENT FROM ME DEPRESSED-Pullover- WHITE
22879 SILLENT FROM ME VOICE-Crew Sweat- BLACK
22880 SILLENT FROM ME VOICE-Crew Sweat- WHITE
22881 SILLENT FROM ME BRAIN-Coach Jkt- BLACK
22882 SILLENT FROM ME BRAIN-Coach Jkt- WHITE
22944 SILLENT FROM ME BRAIN -Long Sleeve- BLK
22945 SILLENT FROM ME BRAIN -Long Sleeve- WHT
23421 SILLENT FROM ME LOSE-Pullover- BLACK
23422 SILLENT FROM ME LOSE-Pullover- WHITE
23807 SILLENT FROM ME RITUAL-Ziphood- BLACK
23808 SILLENT FROM ME RITUAL-Ziphood- 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
24378 SILLENT FROM ME BRAIN-Hood Shirts- BLK
24379 SILLENT FROM ME BRAIN-Hood Shirts- WHT
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
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
25472 SILLENT FROM ME LOSE BLACK
25474 SILLENT FROM ME LOSE 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
28685 SILLENT FROM ME DENSE WHTE
28802 SILLENT FROM ME DROUGHT -Ziphood- BLACK
28803 SILLENT FROM ME DROUGHT -Ziphood- WHITE
28804 SILLENT FROM ME VOICE -Coach Jkt- BLACK
28805 SILLENT FROM ME VOICE -Coach Jkt- WHITE