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-05-21 19:38:17')
AND pc.classcategory_id1 IN( 12,44)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 664)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 120, 120
64283 RIPNDIP (リップンディップ) Nikola Basketball Shorts (Black/Blue)
64272 RIPNDIP (リップンディップ) Summer Break Long Sleeve (Light Blue Mineral Wash)
64270 RIPNDIP (リップンディップ) Heaven And Heck Battle Long Sleeve (Purple Mineral Wash)
64276 RIPNDIP (リップンディップ) Nerm Cruiser Hoodie (Ash Heather)
64277 RIPNDIP (リップンディップ) Nerms Diner Hoodie (Peach)
64275 RIPNDIP (リップンディップ) Blaze Hoodie (Black/Peach/Purple Tie Dye)
64282 RIPNDIP (リップンディップ) Abduction Coaches Jacket (Black)
64281 RIPNDIP (リップンディップ) Nerm Doodle Work Jacket (Chocolate)
60599 RIPNDIP Not Today Embroidered Crewneck (Light Blue)
60591 RIPNDIP Childs Play Hoodie (Black Mineral Wash)
60588 RIPNDIP Far Far Away Hoodie (Black)
60587 RIPNDIP OG Prisma Embroidered Hoodie (Red Tie Dye)
60589 RIPNDIP Stellar Hoodie (Purple/Blue Spiral Dye)
60595 RIPNDIP Peeking Nermal Embroidered Hoodie (Purple Mineral Wash)
60586 RIPNDIP Bubble Sherpa Hoodie (Pink)
60600 RIPNDIP Day Tripper Long Sleeve (Black)
60597 RIPNDIP Embroidered Logo Long Sleeve (Black Mineral Wash)
60606 RIPNDIP Lord Nermal Pocket Long Sleeve (Cherry Red)
60605 RIPNDIP Lord Nermal Pocket Long Sleeve (Dusty Rose)
60603 RIPNDIP Lord Nermal Pocket Long Sleeve (Light Lime)
60604 RIPNDIP OG Prisma Embroidered Tee (Red Tie Dye)
60602 RIPNDIP Logo Embroidered Tee (Natural Speckle)
60596 RIPNDIP Not Today Tee White
60598 RIPNDIP Far Far Away Tee (Black/Pink/Blue Spiral Dye)
60592 RIPNDIP Lord Nermal Pocket Tee Mist Grape
60594 RIPNDIP Lord Nermal Pocket Tee Cotta Orange
60593 RIPNDIP Lord Nermal Pocket Tee Slate
60607 RIPNDIP Ripntail Sweatshorts (Blue Mineral Wash)
60608 RIPNDIP Beverly Nylon Cargo Shorts (Blue)
55710 RIPNDIP Catch Em All Tee (Blue Spiral Dye)
55711 RIPNDIP Besties L/S (Black Mineral Wash)
55712 RIPNDIP Embroidered Logo L/S (Multi)
55713 RIPNDIP Rock & Nerm Tee (Black)
52957 RIPNDIP Catch Em All Hoodie (Tan)
52958 RIPNDIP Peek A Nermal Sweat Shorts (Multi Tie Dye)
52959 RIPNDIP Rock N Nermal Sweat Shorts (Multi)
52960 RIPNDIP Peek A Nermal Sweat Shorts (Black)
52961 RIPNDIP Nermhog Tee (Black)