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-18 18:42:09')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 333)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 120, 120
46323 SANTA CRUZ WAVE SLASHER LS TEE YELLOW
46324 SANTA CRUZ OPUS DOT SS TEE BLACK/WHITE
46325 SANTA CRUZ OPUS DOT SS TEE GOLD
46326 SANTA CRUZ SCREAMING HAND TEE NEON MANGO
46327 SANTA CRUZ SCREAMING HAND TEE WILD SPIDER
46328 SANTA CRUZ SCREAMING HAND TEE SPIDER BLACK
46809 SANTA CRUZ WALL HAND SS TEE BLACK
46816 SANTA CRUZ OTHER DOT SS TEE TAR/NEON GREEN
47627 SANTA CRUZ WALL HAND CREW SOCKS BLACK
47628 SANTA CRUZ WALL HAND CREW SOCKS WHITE
47629 SANTA CRUZ SCREAMING HAND KEYCHAIN
47630 SANTA CRUZ CLASSIC DOT MAGNET
47631 SANTA CRUZ CLASSIC DOT TOWEL BLACK
47632 SANTA CRUZ CLASSIC MID PROFILE SNAPBACK HATS BLACK
47633 SANTA CRUZ CLASSIC DOT HIGH PROFILE MESH TRUCKER HATS BLACK
47634 SANTA CRUZ CLASSIC DOT HIGH PROFILE MESH TRUCKER HATS BLACK/WHITE
47635 SANTA CRUZ DOT BLOCKER SNAPBACK UNSTRUCTURED HATS BLACK
47636 SANTA CRUZ POCKET HAND POCKET S/S T-SHIRT BLACK
47637 SANTA CRUZ POCKET HAND POCKET S/S T-SHIRT WHITE
47638 SANTA CRUZ SCREAMING HAND PREMIUM REGULAR S/S T-SHIRT BLACK
47639 SANTA CRUZ SCREAMING HAND PREMIUM REGULAR S/S T-SHIRT WHITE
47640 SANTA CRUZ CLASSIC DOT CHEST REGULAR S/S T-SHIRT BLACK
47641 SANTA CRUZ CLASSIC DOT CHEST REGULAR S/S T-SHIRT WHITE
47643 SANTA CRUZ CLASSIC DOT HEAVYWEIGHT P/O HOODED SWEATSHIRT BLACK
49463 SANTA CRUZ CHECK OGSC SOCKS BLACK
49464 SANTA CRUZ CHECK OGSC SOCKS WHITE
49465 SANTA CRUZ DOT REFLECTION SOCKS BLACK
49466 SANTA CRUZ DOT REFLECTION SOCKS WHITE
49467 SANTA CRUZ PINLINE CREW NECK 1/2 ZIP SWEATSHIRT FOREST
49468 SANTA CRUZ DOT EMBROIDERY CREW NECK MIDWEIGHT SWEATSHIRT BLACK
49469 SANTA CRUZ DOT EMBROIDERY CREW NECK MIDWEIGHT SWEATSHIRT GREY HEATHER
49470 SANTA CRUZ Screaming Hand L/S T-Shirt ROYAL BLUE
49471 SANTA CRUZ CLASSIC DOT L/S REGULAR T-SHIRT GOLD
49472 SANTA CRUZ CLASSIC DOT L/S REGULAR T-SHIRT CHARCOAL HEATHER
49475 SANTA CRUZ SCREAMING HAND S/S REGULAR T-SHIRT ROYAL BLUE
49478 SANTA CRUZ CLASSIC DOT S/S REGULAR T-SHIRT SPIDER BLACK
49480 SANTA CRUZ CLASSIC DOT BEANIE BLACK
49482 SANTA CRUZ ALLOVER DOT BACKPACK BLACK
49483 SANTA CRUZ CRUZ SOCKS CREW WHITE
51334 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” LONG TEE DOKU
52287 SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” STADIUM JKT BLUE
52288 SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” STADIUM JKT DOKU
52289 SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” STADIUM JKT BLACK
52297 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL DRIP DOT” HOODIE BLACK
52298 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL DRIP DOT” HOODIE GRAY
52299 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL DRIP DOT” HOODIE RED