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 01:10:12')
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 360, 120
36459 SILLENT FROM ME CHAOSTIAN -Braid Cap- BLACK
36460 SILLENT FROM ME ICHABOD -Sunglass-
36709 SILLENT FROM ME DREAMS -Ziphood- BLACK
36710 SILLENT FROM ME DOLAN -Sunglass- BLACK/CLEAR
36711 SILLENT FROM ME DOLAN -Sunglass- BLACK/BLACK
36712 SILLENT FROM ME MATILDA Sunglass- BLACK
36713 SILLENT FROM ME MATILDA Sunglass- CLEAR
36714 SILLENT FROM ME CRYPTIC -W Cord Belt-
36920 SILLENT FROM ME CRYPTIC -Outsize Long Sleeve- BLACK
36921 SILLENT FROM ME CRYPTIC -Outsize Long Sleeve- WHITE
36922 SILLENT FROM ME MALCOLM -Zip Wide Shirts- BLACK
36923 SILLENT FROM ME MALCOLM -Zip Wide Shirts- BLACK CHECK
36924 SILLENT FROM ME HAUBERK -Net Cutsaw- BLACK
36925 SILLENT FROM ME HAUBERK -Net Cutsaw- WHITE
37118 SILLENT FROM ME RUBRIC -Crew Sweat- WHITE
37120 SILLENT FROM ME LISBETH -Flip Day Pack- WHITE
37317 SILLENT FROM ME SICK -Modified Pullover- BLACK
37318 SILLENT FROM ME SICK -Modified Pullover- WHITE
37319 SILLENT FROM ME KINETIC -Anorac- BLACK
37320 SILLENT FROM ME KINETIC -Anorac- WHITE
37321 SILLENT FROM ME KINETIC -Anorac- BLACK/WHITE
37322 SILLENT FROM ME HOOKY -Legging Pants- BLACK/WHITE
37337 SILLENT FROM ME HOOKY -Legging Pants- BLACK
37467 SILLENT FROM ME GAZE -Coach Jkt- BLACK
37468 SILLENT FROM ME GAZE -Coach Jkt- WHITE
37469 SILLENT FROM ME BILLOW -Beanie- BLACK
37470 SILLENT FROM ME BILLOW -Beanie- WHITE
37621 SILLENT FROM ME KEEK -Pullover- BLACK
37622 SILLENT FROM ME KEEK -Pullover- WHITE
37623 SILLENT FROM ME SHELTER -Stand Collar Coat- BLACK
37624 SILLENT FROM ME SHELTER -Stand Collar Coat- BLEACHED BLACK
37625 SILLENT FROM ME PYRAMID -Crew Sweat- BLACK
38164 SILLENT FROM ME SHEARS -Wide Blouson- BLACK/BLACK
38166 SILLENT FROM ME SHEARS -Wide Blouson- BLACK/WHITE
38167 SILLENT FROM ME SHEARS -Wide Blouson- WHITE
38170 SILLENT FROM ME AVA -Trooper Cap- WHITE
38171 SILLENT FROM ME AVA -Trooper Cap- BLACK
38172 SILLENT FROM ME AVA -Trooper Cap- BLACK/WHITE
38176 SILLENT FROM ME CHAOSTIAN - Beanie- WHITE
38177 SILLENT FROM ME CHAOSTIAN - Beanie- BLACK
38713 SILLENT FROM ME PYRAMID -Ziphood- Black
38714 SILLENT FROM ME PYRAMID -Ziphood- White
38715 SILLENT FROM ME SILLENT FROM ME GAZE -Pullover-
38768 SILLENT FROM ME CHAOSTIAN -Beret- BLK/WHT
38769 SILLENT FROM ME CHAOSTIAN -Beret- BLK/BLK
38770 SILLENT FROM ME CRYPTIC -Tactical Scarves BLK
38771 SILLENT FROM ME CRYPTIC -Tactical Scarves WHT
38772 SILLENT FROM ME CHAOSTIAN -Web Belt- BLK/WHT
38773 SILLENT FROM ME CHAOSTIAN -Web Belt- BLK/BLK
38774 SILLENT FROM ME DIVINITY -Coach Jacket- BLK
38775 SILLENT FROM ME DIVINITY -Coach Jacket- WHT
39003 SILLENT FROM ME GAZE -Big Flight Jacket-
39004 SILLENT FROM ME CRYPTIC -Outsize Long Sleeve-
39005 SILLENT FROM ME CHAOSTIAN -Jeep Cap- BK/WH
39006 SILLENT FROM ME CHAOSTIAN -Jeep Cap- BK/BK
39007 SILLENT FROM ME REDEEM -Glove-
39101 SILLENT FROM ME DIVINITY -Crew Sweat- BLACK
39102 SILLENT FROM ME DIVINITY -Crew Sweat- WHITE
39103 SILLENT FROM ME HIDDEN -Ziphood- GYFT by H>FRACTAL COLLABORATION
39104 SILLENT FROM ME SHEARS -Cushion-
39105 SILLENT FROM ME SCRIBBLE -Outsize Pullover- BLACK
39106 SILLENT FROM ME SCRIBBLE -Outsize Pullover- WHITE
39551 SILLENT FROM ME MARCIE -Sunglass- CLR
39552 SILLENT FROM ME MARCIE -Sunglass- BLK
39553 SILLENT FROM ME VALKYRIE -Light MA1- GLASS
39554 SILLENT FROM ME VALKYRIE -Light MA1- BLACK
39555 SILLENT FROM ME VALKYRIE -Light MA1- WHITE
39556 SILLENT FROM ME CRY -Pullover- WHITE
39557 SILLENT FROM ME CRY -Pullover- BLACK
39843 SILLENT FROM ME ALEXIA -Coach Jkt-
39844 SILLENT FROM ME ALEXIA -Coach Jkt- White
39845 SILLENT FROM ME ALEXIA -Crew Sweat- White
39980 SILLENT FROM ME MESS -Pullover- White
40626 SILLENT FROM ME CLIQUE -Track Jacket- White
40627 SILLENT FROM ME CLIQUE -Track Jacket- Black
40639 SILLENT FROM ME SACRIFICE -Long Sleeve- BLACK
40640 SILLENT FROM ME SACRIFICE -Long Sleeve- WHITE
40641 SILLENT FROM ME CLIQUE -Track Pants- 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
40835 SILLENT FROM ME OLIVER -Sunglass- BLACK
40836 SILLENT FROM ME OLIVER -Sunglass- CLEAR
41016 SILLENT FROM ME FALLEN -Wide S/S Shirts- BLACK
41017 SILLENT FROM ME FALLEN -Slacks- CHECK
41018 SILLENT FROM ME FALLEN -Wide S/S Shirts- CHECK
42746 SILLENT FROM ME HOLE WHITE
42747 SILLENT FROM ME HOLE BLACK
42748 SILLENT FROM ME SMILE BLACK
42749 SILLENT FROM ME SMILE WHITE
42750 SILLENT FROM ME ILLNESS BLACK
42751 SILLENT FROM ME ILLNESS WHITE
42755 SILLENT FROM ME STIGMA -Snapback- BLACK
42756 SILLENT FROM ME STIGMA -Snapback- WHITE
42757 SILLENT FROM ME SHEARS -Smart Phone Case-
42758 SILLENT FROM ME SACRIFICE -Mobile Battery-
42976 SILLENT FROM ME METAPHOR -Long Sleeve- White
42977 SILLENT FROM ME METAPHOR -Long Sleeve- Black
42978 SILLENT FROM ME SMILE -Polo Cap- BLACK
42979 SILLENT FROM ME SMILE -Polo Cap- WHITE
43103 SILLENT FROM ME MIST -Wide Mesh Pullover- BLACK
43104 SILLENT FROM ME MIST -Wide Mesh Pullover- WHITE
43105 SILLENT FROM ME ECHO -Zip Wide Shirts- BLACK
43106 SILLENT FROM ME ECHO -Zip Wide Shirts- GRAY
43107 SILLENT FROM ME RICH -Card Case- BLACK/BLACK
43108 SILLENT FROM ME RICH -Card Case- BLACK/WHITE
43109 SILLENT FROM ME RICH -Card Case- WHITE/BLACK
43110 SILLENT FROM ME RICH -Card Case- WHITE/WHITE
43261 SILLENT FROM ME SMILE -Crew Sweat- BLACK
43262 SILLENT FROM ME SMILE -Crew Sweat- WHITE
43263 SILLENT FROM ME STIGMA -Pullover- BLACK
43267 SILLENT FROM ME VEXED -Nylon Pullover- BLACK
43268 SILLENT FROM ME VEXED -Nylon Pullover- BLACK/WHITE
43269 SILLENT FROM ME VEXED -Nylon Pullover- WHITE
43273 SILLENT FROM ME EBONY -Side Zip Skinny- BLACK
43274 SILLENT FROM ME EBONY -Damaged Side Zip Skinny- BLACK
43540 SILLENT FROM ME GEMINAL -Reversible Boa Jacket- BLACK