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-03-30 00:56:38')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 518)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 25
48481 GoneR GR21AC001 Bat Rose Key Holder Black
52607 GoneR -La Neta- Chemical Wash Denim Jacket INDIGO
52608 GoneR -La Neta- One Wash Denim Jacket BLACK
52645 GoneR × LESSTRESS GR24ACW001 GoneR × LESSTRESS Key Holder White
36522 GoneR Dread Skull T-Shirts BLACK
52606 GoneR -La Neta- Agave Pocket T-Shirts BLACK
52604 GoneR -La Neta- Agave Pocket T-Shirts MAROON
55885 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Baige
55886 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Black
55876 GoneR GR26ZP001 Rose Photo Zip Parka Heather gray
57991 GoneR GR28LS001 Rainbow Rose L/S T-Shirts Sand
58726 GoneR -La Neta- GRL04CT002 LUZ Y SOL T-Shirts Black
58724 GoneR -La Neta- GRL04CT002 LUZ Y SOL T-Shirts Light Purple
59297 GoneR GR29CTW001 GoneR × PICTURE MOUSE Collavoration T-Shirts Gardenal Red
59295 GoneR GR29CTW001 GoneR × PICTURE MOUSE Collavoration T-Shirts Pistachio
58719 GoneR -La Neta- GRL04CT001 Mexican Flag T-Shirts Light Purple
58698 GoneR GR29CT002 Square Mexican Skull T-Shirts Stone Blue
60404 GoneR -La Neta- GRL05PK001New York Logo Parka Red
60407 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Orange
60406 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Red
60372 GoneR GR30PK001 Chalice Parka White
60371 GoneR GR30PK001 Chalice Parka Sand Beige
60370 GoneR GR30PK002 Circle Rose Parka Black
60366 GoneR GR30PK002 Circle Rose Parka Sand Beige
55872 GoneR GR26LS003 Mexican Goods Skull L/S T-ShirtsBlack