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 02:40:43')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 300)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
65633 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) x VANS “MAGICAL VANS MISFITS”HOODIE MINT
65628 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) x VANS “MAGICAL VANS GIRL” HOODIE BLACK
65626 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) x VANS “MAGICAL VANS GIRL” HOODIE GRAY
65631 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) x VANS “MAGICAL VANS MISFITS”HOODIE BLACK
7934 VANS APPAREL Classic Patch Hat Wht/Blk
8222 VANS APPAREL Elite Beanie Classic BLUE
8224 VANS APPAREL Elite Beanie Classic WHITE
10442 VANS APPAREL BOYS VANS BLASTER T-Shirt
11021 VANS APPAREL INDY TOOLS OF THE TRADE T-Shirt BLACK
11022 VANS APPAREL INDY RAGLAN WHT/BLK
11023 VANS APPAREL DAY TRIPPING T-Shirt BLACK
11024 VANS APPAREL MIDWAY SKATE DUFFLE BLACK
11028 VANS APPAREL iPad CASE
11039 VANS APPAREL CLASSIC LOW 3 PACK SOCKS BLACK
11053 VANS APPAREL Spicoli 4 Shades CLEAR BROWN
11058 VANS APPAREL BIDWELL TANK TOP RED
11059 VANS APPAREL RUSDEN IKAT S/S SHIRT LIVING CORAL
11060 VANS APPAREL RUSDEN IKAT S/S SHIRT NAVY
11061 VANS APPAREL CHECKED OUT S/S WOVEN SHIRT BLUE
11062 VANS APPAREL CHECKED OUT S/S WOVEN SHIRT RED
11063 VANS APPAREL BURKE TANK TOP BALTIC GRAVEL
11064 VANS APPAREL BURKE TANK TOP GREY
13173 VANS APPAREL DAY TRIPPING TANK TOP GREY
13175 VANS APPAREL OFF THE WALL BREWED TANK TOP WHITE
13179 VANS APPAREL OFF THE WALL BREWED T-Shirt WHITE