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-04-28 08:58:48')
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 MAX(price02)
LIMIT 0, 120
58764 SILLENT FROM ME WORDS WHITE
20226 SILLENT FROM ME ARTIFICIAL WHT
20227 SILLENT FROM ME ARTIFICIAL BLK
20228 SILLENT FROM ME SPELL BLK
20229 SILLENT FROM ME SPELL WHT
20455 SILLENT FROM ME DIVISION BLACK
20456 SILLENT FROM ME DIVISION WHITE
23907 SILLENT FROM ME ANACHRONIC BLACK
23908 SILLENT FROM ME ANACHRONIC WHITE
24573 SILLENT FROM ME RITUAL WHITE
24574 SILLENT FROM ME RITUAL BLACK
25472 SILLENT FROM ME LOSE BLACK
25474 SILLENT FROM ME LOSE 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
20453 SILLENT FROM ME QUIET BLACK
20454 SILLENT FROM ME QUIET 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
26220 SILLENT FROM ME DROUGHT BLACK
26221 SILLENT FROM ME DROUGHT WHITE
24548 SILLENT FROM ME 771#-Pocket- BLACK
24549 SILLENT FROM ME 771#-Pocket- WHITE
24841 SILLENT FROM ME "20"MINOR LEAGUE Collaboration 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
35047 SILLENT FROM ME SCRIBBLE BLK
35048 SILLENT FROM ME SCRIBBLE WHT
35058 SILLENT FROM ME POSER BLK
35059 SILLENT FROM ME POSER WHT
35495 SILLENT FROM ME MOAN TEE BLK
35496 SILLENT FROM ME MOAN TEE WHE
36452 SILLENT FROM ME DIVINITY BLACK
36453 SILLENT FROM ME DIVINITY WHITE
36454 SILLENT FROM ME GAZE WHITE
36455 SILLENT FROM ME GAZE BLACK
40829 SILLENT FROM ME BOYHOOD BLACK
40830 SILLENT FROM ME BOYHOOD WHITE
40831 SILLENT FROM ME CRY BLACK
40832 SILLENT FROM ME CRY WHITE
40833 SILLENT FROM ME MESS BLACK
40834 SILLENT FROM ME MESS WHITE
42750 SILLENT FROM ME ILLNESS BLACK
42751 SILLENT FROM ME ILLNESS WHITE
47372 SILLENT FROM ME QUERY BLACK
47373 SILLENT FROM ME QUERY WHITE
48106 SILLENT FROM ME FEEL BLACK
48107 SILLENT FROM ME FEEL WHITE
24845 SILLENT FROM ME "20" -Pocket- MINOR LEAGUE Collaboration BLACK
24847 SILLENT FROM ME "20" -Pocket- MINOR LEAGUE Collaboration WHITE
26224 SILLENT FROM ME ICON-Pocket- BLACK
26225 SILLENT FROM ME ICON-Pocket- WHITE
36048 SILLENT FROM ME PYRAMID -Pocket- BLACK
36049 SILLENT FROM ME PYRAMID -Pocket- WHITE
21855 SILLENT FROM ME NORM -Waffle- BLACK
21856 SILLENT FROM ME NORM -Waffle- WHITE
21167 SILLENT FROM ME CIRCLE -Longsleeve- WHITE
22383 SILLENT FROM ME SPELL -Longsleeve- WHT
22384 SILLENT FROM ME SPELL -Longsleeve- BLK
22944 SILLENT FROM ME BRAIN -Long Sleeve- BLK
22945 SILLENT FROM ME BRAIN -Long Sleeve- WHT
32340 SILLENT FROM ME WHISPER -Long Sleeve w/Pocket- BLK
32341 SILLENT FROM ME WHISPER -Long Sleeve w/Pocket- WHT
58765 SILLENT FROM ME WORDS BLACK
58766 SILLENT FROM ME FILLM -Pocket- WHITE
58767 SILLENT FROM ME FILLM -Pocket- BLACK
28901 SILLENT FROM ME HUNGED -Long Sleeve- BLK
28902 SILLENT FROM ME HUNGED -Long Sleeve- WHT
33606 SILLENT FROM ME DREAMS -Long Sleeve- BLACK
33607 SILLENT FROM ME DREAMS -Long Sleeve- WHITE
34205 SILLENT FROM ME HUMANE -Long Sleeve- WHITE
34206 SILLENT FROM ME HUMANE -Long Sleeve- BLACK
40639 SILLENT FROM ME SACRIFICE -Long Sleeve- BLACK
40640 SILLENT FROM ME SACRIFICE -Long Sleeve- WHITE
42976 SILLENT FROM ME METAPHOR -Long Sleeve- White
42977 SILLENT FROM ME METAPHOR -Long Sleeve- Black
47062 SILLENT FROM ME STIGMA -Long Sleeve- WHITE
32337 SILLENT FROM ME BALANCE -Long Sleeve- BLK
32339 SILLENT FROM ME BALANCE -Long Sleeve- WHT
58488 SILLENT FROM ME FILLM -Loose Long Sleeve- BLACK
20457 SILLENT FROM ME ARTIFICIAL -Broad Shirts- WHITE
20458 SILLENT FROM ME ARTIFICIAL -Broad Shirts- BLACK
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
32040 SILLENT FROM ME NORM -Waffle Pullover- BLACK
22879 SILLENT FROM ME VOICE-Crew Sweat- BLACK
22880 SILLENT FROM ME VOICE-Crew Sweat- WHITE
29137 SILLENT FROM ME SPELL -Crew Sweat- BLACK
29138 SILLENT FROM ME SPELL -Crew Sweat- WHITE
31808 SILLENT FROM ME ENCRYPTION -Crew Sweat- BLACK
31809 SILLENT FROM ME ENCRYPTION -Crew Sweat- WHITE
32499 SILLENT FROM ME TEAR -Crew Sweat- BLK
32500 SILLENT FROM ME TEAR -Crew Sweat- WHT
33601 SILLENT FROM ME EPITAPH -Crew Sweat- BLACK
33602 SILLENT FROM ME EPITAPH -Crew Sweat- WHITE
37118 SILLENT FROM ME RUBRIC -Crew Sweat- WHITE
37625 SILLENT FROM ME PYRAMID -Crew Sweat- BLACK
39101 SILLENT FROM ME DIVINITY -Crew Sweat- BLACK
39102 SILLENT FROM ME DIVINITY -Crew Sweat- WHITE
39845 SILLENT FROM ME ALEXIA -Crew Sweat- White
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
21854 SILLENT FROM ME MEOW -Pullover-