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-30 21:40:06')
AND pc.classcategory_id1 IN( 159)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 365)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 75
63295 Anti Social Social Club Playboy x ASSC Bunny Logo White Hoodie
63294 Anti Social Social Club Playboy x ASSC Bunny Logo Black Hoodie
63298 Anti Social Social Club ASSC x retaW Black Hoodie
60154 Anti Social Social Club BORED GAMES YELLOW FLANNEL
60153 Anti Social Social Club BORED GAMES PURPLE FLANNEL
60155 Anti Social Social Club BORED GAMES BROWN FLANNEL
60156 Anti Social Social Club WOODY WHITE BUTTON UP
60160 Anti Social Social Club THE REAL ME BLACK HOODIE
60162 Anti Social Social Club I SEE PINK SPLASH BLACK HOODIE
60161 Anti Social Social Club I SEE BLUE SPLASH BLACK HOODIE
60163 Anti Social Social Club I SEE GREEN BLACK TEE
60164 Anti Social Social Club I SEE GRAPE BLACK TEE
60165 Anti Social Social Club THE REAL ME WHITE TEE
56202 Anti Social Social Club True Colors Purple Camo
56204 Anti Social Social Club Headrush All Over White Hoodie
56205 Anti Social Social Club Don’T Black Hoodie
56207 Anti Social Social Club Sweeter Then You Think Black Hoodie
56209 Anti Social Social Club Read Receipts Black Tee
56210 Anti Social Social Club Enrique White Vneck Tee
56213 Anti Social Social Club Headrush All Over White Tee
56214 Anti Social Social Club Goodbye Summer Black Tank
55735 Anti Social Social Club ASHTON BLACK TEE
55736 Anti Social Social Club ASHTON WHITE TEE
55630 Anti Social Social Club BAT EMOJI WHITE HOODIE
55626 Anti Social Social Club THE GROVE BLACK TEE
55627 Anti Social Social Club THE GROVE BLACK HOODIE
55632 Anti Social Social Club FRANTIC RED FLANNEL
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
55635 Anti Social Social Club MIND GAMES BLACK HOODIE
55639 Anti Social Social Club TONE DEF SAND HOODIE
9197 BLACK CRAFT Lucipurr T-Shirt
11268 BLACK CRAFT Lone Wolf Hooded Pullover Sweater
11290 BLACK CRAFT Death To Gods T-Shirt
11373 BLACK CRAFT Lucipurr Tank top BLACK
11375 BLACK CRAFT One Nation No God Tank Top BLACK
15812 BLACK CRAFT Lucipurr - Hooded Pullover Sweater
15913 BLACK CRAFT One Nation No God
15922 BLACK CRAFT Protection Moth
16367 BLACK CRAFT Baphomet 666 - Hooded Pullover Sweater
21149 BLACK CRAFT Crowley's Moth
21159 BLACK CRAFT Aquarius
21160 BLACK CRAFT Pisces
21161 BLACK CRAFT Taurus
21281 BLACK CRAFT Believe In Yourself T-Shirt
21282 BLACK CRAFT Aries
36232 REBEL8 Risen Longsleeve Tee
36233 REBEL8 Dusty Longsleeve tee
37012 REBEL8 Serramonte Longsleeve Tee Black
37013 REBEL8 Serramonte Longsleeve Tee White
37095 REBEL8 Death Proof Longsleeve Tee
37096 REBEL8 Coney Longsleeve Mens Tee White
37718 DOGTOWN 2WSDOCLOG WORK SHIRTS BLK
39289 REBEL8 DEFILER PULLOVER
39293 REBEL8 HOSTILE PREMIUM TEE ARMY
39294 REBEL8 HOSTILE PREMIUM TEE BLACK
39296 REBEL8 MYERS EMBROIDERED TEE BLACK
39297 REBEL8 MYERS EMBROIDERED TEE BURGUNDY
39298 REBEL8 MYERS EMBROIDERED TEE MULTI
41042 OBEY x Misfits Satin Jacket BLACK
41044 OBEY x Misfits Teenagers From Mars Denim Jacket
41045 OBEY x Misfits Fiend Club Denim Jacket
41055 OBEY x Misfits 7'' Cover Basic Tee WHITE
41056 OBEY x Misfits 7'' Cover Basic Tee BLACK
41057 OBEY x Misfits 7'' Cover Basic Tee PINK
41060 OBEY x Misfits Legacy of Phenome Pullover Hood BLACK
41061 OBEY x Misfits Legacy of Phenome Pullover Hood GREEN
41062 OBEY x Misfits Legacy of Phenome Pullover Hood WHITE
41063 OBEY The OBEY Fiend Club Pullover Hood PINK
41064 OBEY The OBEY Fiend Club Pullover Hood BLACK
41065 OBEY The OBEY Fiend Club Pullover Hood GRAY
41220 REBEL8 Relegate Tee Blue
41221 REBEL8 Relegate Tee Peach
41222 REBEL8 24 Hr Longsleeve Tee Powder Blue
41224 REBEL8 Ceremony Tee Black
41225 REBEL8 Ceremony Tee White