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-27 22:23:08')
AND pc.classcategory_id1 IN( 159)
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
24546 SILLENT FROM ME DEPRESSED BLACK
24547 SILLENT FROM ME DEPRESSED WHITE
26220 SILLENT FROM ME DROUGHT BLACK
26221 SILLENT FROM ME DROUGHT 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
36048 SILLENT FROM ME PYRAMID -Pocket- BLACK
36049 SILLENT FROM ME PYRAMID -Pocket- 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
58765 SILLENT FROM ME WORDS 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
32339 SILLENT FROM ME BALANCE -Long Sleeve- WHT
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
29137 SILLENT FROM ME SPELL -Crew Sweat- BLACK
29138 SILLENT FROM ME SPELL -Crew Sweat- WHITE
31808 SILLENT FROM ME ENCRYPTION -Crew Sweat- BLACK
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
21854 SILLENT FROM ME MEOW -Pullover-
22175 SILLENT FROM ME DIVISION -Pullover- WHT
22176 SILLENT FROM ME DIVISION -Pullover- BLK
23421 SILLENT FROM ME LOSE-Pullover- BLACK
23422 SILLENT FROM ME LOSE-Pullover- WHITE
36709 SILLENT FROM ME DREAMS -Ziphood- BLACK
38715 SILLENT FROM ME SILLENT FROM ME GAZE -Pullover-
39556 SILLENT FROM ME CRY -Pullover- WHITE
39557 SILLENT FROM ME CRY -Pullover- BLACK
39980 SILLENT FROM ME MESS -Pullover- White
43263 SILLENT FROM ME STIGMA -Pullover- BLACK
44300 SILLENT FROM ME ILLNESS -Pullover- WHITE
21170 SILLENT FROM ME SQUARE -Ziphood- BLACK
21171 SILLENT FROM ME SQUARE -Ziphood- WHITE
21309 SILLENT FROM ME FU-Ziphood- White
21311 SILLENT FROM ME FU-Ziphood- Black
23807 SILLENT FROM ME RITUAL-Ziphood- BLACK
23808 SILLENT FROM ME RITUAL-Ziphood- WHITE
28802 SILLENT FROM ME DROUGHT -Ziphood- BLACK
28803 SILLENT FROM ME DROUGHT -Ziphood- WHITE
31807 SILLENT FROM ME EPITAPH -Pullover- BLACK
32041 SILLENT FROM ME HUNGED -Pullover- BLACK
32042 SILLENT FROM ME HUNGED -Pullover- WHITE
32327 SILLENT FROM ME ENCRYPTION -Ziphood- BLK
37621 SILLENT FROM ME KEEK -Pullover- BLACK
37622 SILLENT FROM ME KEEK -Pullover- WHITE
38713 SILLENT FROM ME PYRAMID -Ziphood- Black
44301 SILLENT FROM ME SACRIFICE -Ziphood- BLACK