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-19 21:53:51')
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 MAX(price02)
LIMIT 0, 120
44920 SANTA CRUZ HANDS ALLOVER SOCKS PINK[B]
39906 SANTA CRUZ Classic Dot S/S T-Shirt Black
46318 SANTA CRUZ CLASSIC DOT TANK BLACK
47642 SANTA CRUZ CLASSIC DOT REGULAR S/S T-SHIRT WHITE
47630 SANTA CRUZ CLASSIC DOT MAGNET
54728 SANTA CRUZ SCREAMING HAND S/S TEE GOLD
39913 SANTA CRUZ Hand Socks Black
39914 SANTA CRUZ Hand Socks Gray
39915 SANTA CRUZ Hand Socks White
39916 SANTA CRUZ OGSC Mini Socks Black
44035 SANTA CRUZ SPANGLE SOCKS BLACK
44036 SANTA CRUZ SPANGLE SOCKS GRAY
44054 SANTA CRUZ SCREAMING VACATION SOCKS BLACK
44055 SANTA CRUZ SCREAMING VACATION SOCKS KAHKI
44056 SANTA CRUZ HANDS ALLOVER SOCKS BLACK
44057 SANTA CRUZ HANDS ALLOVER SOCKS PINK
46305 SANTA CRUZ SPILL DOT CREW SOCKS MILTI
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
47629 SANTA CRUZ SCREAMING HAND KEYCHAIN
39900 SANTA CRUZ Opus Dot S/S T-Shirt White
39909 SANTA CRUZ Classic Dot S/S T-Shirt Green (Neon Yellow)
39927 SANTA CRUZ Classic Dot L/S Regular T-Shirt White
39929 SANTA CRUZ Classic Dot Belt Charchoal
39930 SANTA CRUZ Classic Dot Belt Black
46319 SANTA CRUZ WALL HAND SS TEE WHITE
46809 SANTA CRUZ WALL HAND SS TEE BLACK
47627 SANTA CRUZ WALL HAND CREW SOCKS BLACK
47628 SANTA CRUZ WALL HAND CREW SOCKS WHITE
49483 SANTA CRUZ CRUZ SOCKS CREW WHITE
49484 SANTA CRUZ CRUZ SOCKS CREW BLACK
44025 SANTA CRUZ THE SCREMING HAND LUNCH BOX
9116 SANTA CRUZ CLASSIC DOT LONG SHOREMAN BEANIE BK/OR
9118 SANTA CRUZ MERCIFUL DOT SS T SHIRT WHITE
9119 SANTA CRUZ MERCIFUL DOT SS T SHIRT BLACK
9123 SANTA CRUZ SKATE BRAIN S/S T SHIRT BLUE
9342 SANTA CRUZ OTHER DOT TRUCKER MESH WHITE/BLACK
9343 SANTA CRUZ OPUS TRUCKER MESH HAT WHT/BLK
44022 SANTA CRUZ MINI BEANIE BLACK
44023 SANTA CRUZ MINI BEANIE MAROON
49480 SANTA CRUZ CLASSIC DOT BEANIE BLACK
39894 SANTA CRUZ Hissing Hand S/S T-Shirt Black
39895 SANTA CRUZ Hissing Hand S/S T-Shirt White
39896 SANTA CRUZ Arch Strip T-Shirt White
39897 SANTA CRUZ Arch Strip T-Shirt Black
39898 SANTA CRUZ Arch Strip T-Shirt Burgundy
39899 SANTA CRUZ Opus Dot S/S T-Shirt Black
39901 SANTA CRUZ Opus Dot S/S T-Shirt DK Chocolate
39902 SANTA CRUZ Gremlin Patrol Hand S/S T-Shirt Black
39903 SANTA CRUZ Gremlin Patrol Hand S/S T-Shirt White
39904 SANTA CRUZ Gremlin Patrol Hand S/S T-Shirt Royal
39905 SANTA CRUZ Classic Dot S/S T-Shirt White
39907 SANTA CRUZ Classic Dot S/S T-Shirt Charcoal
39908 SANTA CRUZ Classic Dot S/S T-Shirt Silver
44043 SANTA CRUZ WAVE DOT SS BURGUNDY
44044 SANTA CRUZ WAVE DOT SS SPIDER BLACK
44049 SANTA CRUZ SCREAMING HAND BEANIE BLACK
44050 SANTA CRUZ SCREAMING HAND BEANIE GRAY
44058 SANTA CRUZ WAVE DOT SS BLUE
46307 SANTA CRUZ SPILL DOT REGULAR SS TEE WHITE
46308 SANTA CRUZ SPILL DOT REGULAR SS TEE BLACK
46309 SANTA CRUZ SPILL DOT REGULAR SS TEE CORAL
46310 SANTA CRUZ WAVE SLASHER SS TEE H.BLUE
46311 SANTA CRUZ WAVE SLASHER SS TEE BLACK
46315 SANTA CRUZ OTHER DOT SS TEE BLACK/FOREST GREEN
46316 SANTA CRUZ OTHER DOT SS TEE CORAL
46317 SANTA CRUZ CLASSIC DOT TANK WHITE
46324 SANTA CRUZ OPUS DOT SS TEE BLACK/WHITE
46325 SANTA CRUZ OPUS DOT SS TEE GOLD
46816 SANTA CRUZ OTHER DOT SS TEE TAR/NEON GREEN
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
49475 SANTA CRUZ SCREAMING HAND S/S REGULAR T-SHIRT ROYAL BLUE
49476 SANTA CRUZ SCREAMING HAND S/S REGULAR T-SHIRT BLACK
49477 SANTA CRUZ SCREAMING HAND S/S REGULAR T-SHIRT WHITE
39910 SANTA CRUZ Rewind S/S T-Shirt Black
44045 SANTA CRUZ SCREAMING HAND HAT BLACK
44046 SANTA CRUZ SCREAMING HAND HAT WHITE×BLACK
47633 SANTA CRUZ CLASSIC DOT HIGH PROFILE MESH TRUCKER HATS BLACK
47634 SANTA CRUZ CLASSIC DOT HIGH PROFILE MESH TRUCKER HATS BLACK/WHITE
44033 SANTA CRUZ STREET SLANT CAP BLACK
44034 SANTA CRUZ STREET SLANT CAP KHAKI
44047 SANTA CRUZ STRIP HATS BLACK
44048 SANTA CRUZ STRIP HATS NAVY
46326 SANTA CRUZ SCREAMING HAND TEE NEON MANGO
47632 SANTA CRUZ CLASSIC MID PROFILE SNAPBACK HATS BLACK
47635 SANTA CRUZ DOT BLOCKER SNAPBACK UNSTRUCTURED HATS BLACK
39919 SANTA CRUZ Screaming Hand L/S Regular T-Shirt Black
39920 SANTA CRUZ Screaming Hand L/S Regular T-Shirt White
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
9339 SANTA CRUZ CLASSIC DOT FLEXFIT FITTED STRETCH BLK
9340 SANTA CRUZ CLASSIC DOT FLEXFIT FITTED STRETCH B/G
9346 SANTA CRUZ SC Block 2 Flex Fit Hat BLK
44030 SANTA CRUZ GATEWAY HAND LS BLACK
44031 SANTA CRUZ GATEWAY HAND LS WHITE
44032 SANTA CRUZ GATEWAY HAND LS BLUE
44042 SANTA CRUZ Screaming Hand L/S T-Shirt Celadon
49478 SANTA CRUZ CLASSIC DOT S/S REGULAR T-SHIRT SPIDER BLACK
36753 SANTA CRUZ KEN TAYLOR HAND WHITE
36754 SANTA CRUZ KEN TAYLOR HAND BLACK
36756 SANTA CRUZ FOS HAND WHITE
36757 SANTA CRUZ SKINNER HAND BLACK
36758 SANTA CRUZ SKINNER HAND GREEN
39911 SANTA CRUZ Multi Cruz L/S T-Shirt Black
39912 SANTA CRUZ Multi Cruz L/S T-Shirt White
39918 SANTA CRUZ OGSC Mini Snapback
39921 SANTA CRUZ Screaming Hand L/S T-Shirt Navy
39922 SANTA CRUZ Screaming Hand L/S T-Shirt Navy
39925 SANTA CRUZ Classic Dot 7/S T-Shirt Black x Gray
39926 SANTA CRUZ Classic Dot Regular L/S T-Shirt Black
39928 SANTA CRUZ Classic Dot L/S T-Shirt Burgundy
39931 SANTA CRUZ Screaming Hand L/S T-Shirt White2