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-25 10:05:19')
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, 60
50395 SILLENT FROM ME SMILE -Ziphood- BLACK
22886 SILLENT FROM ME ELEMENTS -IC Card Sticker-
24215 SILLENT FROM ME×激ロック COLLABORATION BADGE ROCK BLK
24213 SILLENT FROM ME×激ロック COLLABORATION BADGE DEPRESSED WHT
24214 SILLENT FROM ME×激ロック COLLABORATION BADGE DEPRESSED BLK
24216 SILLENT FROM ME×激ロック COLLABORATION BADGE ROCK WHT
25481 SILLENT FROM ME RAY -Compact Mirror-
22885 SILLENT FROM ME BRAIN -Bandana- BLACK
20234 SILLENT FROM ME MEOW -Bandana-
20235 SILLENT FROM ME LIP -Bandana-
35497 SILLENT FROM ME BLACK LOCK -Key Ring-
35498 SILLENT FROM ME BLACK BOX -Aluminium Wallet-
26619 SILLENT FROM ME CRYPTIC -Neck Strap-
52979 SILLENT FROM ME SHEARS -Acrylic Pendant- CLEAR
20233 SILLENT FROM ME MEOW -Shoulder Bag-
35595 SILLENT FROM ME TALISMAN -Charm-
58764 SILLENT FROM ME WORDS WHITE
20232 SILLENT FROM ME ICON -Beanie-
21517 SILLENT FROM ME CRYPTIC -Beanie- WHITE
21518 SILLENT FROM ME CRYPTIC -Beanie- BLACK
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
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-
29855 SILLENT FROM ME WHISPER -Beanie-
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
35499 SILLENT FROM ME BILLOW -Polo Cap- BLK
35500 SILLENT FROM ME BILLOW -Polo Cap-
36714 SILLENT FROM ME CRYPTIC -W Cord Belt-
37469 SILLENT FROM ME BILLOW -Beanie- BLACK
38772 SILLENT FROM ME CHAOSTIAN -Web Belt- BLK/WHT
38773 SILLENT FROM ME CHAOSTIAN -Web Belt- BLK/BLK
46199 SILLENT FROM ME QUERY -Beanie- BLACK
46200 SILLENT FROM ME QUERY -Beanie- 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