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 10:13:52')
AND pc.price02 > 909
AND price02 <= 2727
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
58764 SILLENT FROM ME WORDS WHITE
56050 SILLENT FROM ME CULTISM -Socks- BLACK&WHITE
52979 SILLENT FROM ME SHEARS -Acrylic Pendant- CLEAR
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
20230 SILLENT FROM ME CRYPTIC -Snapback- BLK
20231 SILLENT FROM ME CRYPTIC -Snapback- WHT
20232 SILLENT FROM ME ICON -Beanie-
20233 SILLENT FROM ME MEOW -Shoulder Bag-
20453 SILLENT FROM ME QUIET BLACK
20454 SILLENT FROM ME QUIET WHITE
20455 SILLENT FROM ME DIVISION BLACK
20456 SILLENT FROM ME DIVISION WHITE
20459 SILLENT FROM ME ALEX -Sunglass- BLACK/CLEAR
20460 SILLENT FROM ME ALEX -Sunglass- BLACK/BLACK
20461 SILLENT FROM ME ALEX -Sunglass- WHITE/BLACK
21305 SILLENT FROM ME D&C -Snapback- White
21306 SILLENT FROM ME D&C -Snapback- Black
21517 SILLENT FROM ME CRYPTIC -Beanie- WHITE
21518 SILLENT FROM ME CRYPTIC -Beanie- BLACK
21855 SILLENT FROM ME NORM -Waffle- BLACK
21856 SILLENT FROM ME NORM -Waffle- WHITE
21858 SILLENT FROM ME QUIET -Snapback- BLACK
21859 SILLENT FROM ME QUIET -Snapback- WHITE
21860 SILLENT FROM ME NORM -Bucket Hat- BLACK
21861 SILLENT FROM ME NORM -Bucket Hat- WHITE
21862 SILLENT FROM ME QUIET -Shoulder Bag-
22043 SILLENT FROM ME SHHH -iphone6/6s Case-
22205 SILLENT FROM ME NORM -Beanie- BLACK/WHITE
22207 SILLENT FROM ME NORM -Beanie- BLACK/BLACK
22883 SILLENT FROM ME VOICE-Beanie- BLACK/BLACK
22884 SILLENT FROM ME VOICE-Beanie- BLACK/WHITE
22946 SILLENT FROM ME D&C-Beanie- WHT
22947 SILLENT FROM ME D&C-Beanie- BLK/WHT
22948 SILLENT FROM ME D&C-Beanie- BLK.BLK
23425 SILLENT FROM ME LOSE-Beanie- WHITE
23809 SILLENT FROM ME VOICE-Snapback- WHITE
23810 SILLENT FROM ME VOICE-Snapback- BLACK
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
24380 SILLENT FROM ME LOSE-Snapback- BLK
24381 SILLENT FROM ME LOSE-Snapback- 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
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
24850 SILLENT FROM ME "20" -Snapback- MINOR LEAGUE Collaboration BLACK
24851 SILLENT FROM ME "20" -Snapback- MINOR LEAGUE Collaboration 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
25478 SILLENT FROM ME ANACHRONIC -Dolman Onepiece-
25480 SILLENT FROM ME ICON -Charm-
26220 SILLENT FROM ME DROUGHT BLACK
26221 SILLENT FROM ME DROUGHT WHITE
26222 SILLENT FROM ME SPELL -Snapback- WHITE
26223 SILLENT FROM ME SPELL -Snapback- BLACK
26224 SILLENT FROM ME ICON-Pocket- BLACK
26225 SILLENT FROM ME ICON-Pocket- WHITE
26619 SILLENT FROM ME CRYPTIC -Neck Strap-
28434 SILLENT FROM ME ENCRYPTION WHT
28435 SILLENT FROM ME ENCRYPTION BLK
28436 SILLENT FROM ME TEAR WHT
28437 SILLENT FROM ME TEAR BLK
28438 SILLENT FROM ME ENCRYPTION -Snapback- WHT
28439 SILLENT FROM ME ENCRYPTION -Snapback- BLK/BLK
28441 SILLENT FROM ME ENCRYPTION -Snapback- BLK
28442 SILLENT FROM ME WHISPER -Polo Cap- WHT
28443 SILLENT FROM ME WHISPER -Polo Cap- BLK
28684 SILLENT FROM ME DENSE BLACK
28685 SILLENT FROM ME DENSE WHTE
28806 SILLENT FROM ME EPITAPH -5 Panel- BLACK
29135 SILLENT FROM ME MARTYR -Side Slit- BLACK
29136 SILLENT FROM ME MARTYR -Side Slit- WHITE
29855 SILLENT FROM ME WHISPER -Beanie-
31810 SILLENT FROM ME SPELL -Cord Cap-
32330 SILLENT FROM ME BILLOW -Polo Cap- BLK
32333 SILLENT FROM ME BILLOW -Polo Cap- WHT
32501 SILLENT FROM ME HUMANE -Beanie- WHT
32502 SILLENT FROM ME HUMANE -Beanie- BLK
33921 SILLENT FROM ME CRYPTIC -W Cord Belt- BLACK
34207 SILLENT FROM ME HUMANE -Snapback- BLACK
34208 SILLENT FROM ME HUMANE -Snapback- WHITE
35047 SILLENT FROM ME SCRIBBLE BLK
35048 SILLENT FROM ME SCRIBBLE WHT
35058 SILLENT FROM ME POSER BLK
35059 SILLENT FROM ME POSER WHT
35060 SILLENT FROM ME CRYPTIC -Beret- BLK/BLK
35061 SILLENT FROM ME CRYPTIC -Beret- BLK/WHT
35062 SILLENT FROM ME Sunglass
35495 SILLENT FROM ME MOAN TEE BLK
35496 SILLENT FROM ME MOAN TEE WHE
35497 SILLENT FROM ME BLACK LOCK -Key Ring-
35498 SILLENT FROM ME BLACK BOX -Aluminium Wallet-
35499 SILLENT FROM ME BILLOW -Polo Cap- BLK
35500 SILLENT FROM ME BILLOW -Polo Cap-
35592 SILLENT FROM ME SELMA -Sunglass- BLK/BLK
35593 SILLENT FROM ME SELMA -Sunglass- BLACK/CLEAR
35595 SILLENT FROM ME TALISMAN -Charm-
36044 SILLENT FROM ME RICH -Coin Case- BLACK
36045 SILLENT FROM ME RICH -Coin Case- WHITE