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-28 21:25:17')
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 DESC
LIMIT 100, 25
55874 GoneR GR26OT001 Mexican Design Drivers jacket Black
55875 GoneR GR26ZP001 Rose Photo Zip Parka White
55877 GoneR GR26ZP001 Rose Photo Zip Parka Olive
55878 GoneR GR26ZP001 Rose Photo Zip Parka Burgundy
55879 GoneR GR26ZP001 Rose Photo Zip Parka Black
60840 GoneR Ska Sweat Parka Black
60841 GoneR Ska Sweat Parka Sand Beige
60842 GoneR Ska Sweat Parka Mix Grey
60843 GoneR Ska Sweat Parka Stone Blue
60849 GoneR Christian Crew Sweat Hether Grey
60852 GoneR Christian Crew Sweat Black
60853 GoneR Warm Shall Rose Parka Coyote Brown/Black
60854 GoneR Warm Shall Rose Parka Coyote Olive/Black
60367 GoneR GR30PK002 Circle Rose Parka White
60366 GoneR GR30PK002 Circle Rose Parka Sand Beige
60370 GoneR GR30PK002 Circle Rose Parka Black
60397 GoneR GR30CP001 Basic Logo Knit Cap Black/White
60398 GoneR GR30CP001 Basic Logo Knit Cap Black/Red
60371 GoneR GR30PK001 Chalice Parka Sand Beige
60372 GoneR GR30PK001 Chalice Parka White
60374 GoneR GR30PK001 Chalice Parka Hether Grey
60373 GoneR GR30PK001 Chalice Parka Orange
60376 GoneR GR30PK001 Chalice Parka Black
60402 GoneR -La Neta- GRL05OT001 Embroidery Coverall Jacket Black
60399 GoneR -La Neta- GRL05OT001 Embroidery Coverall Jacket Safari Beige