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-01 20:28:11')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 4560, 120
49720 Survive Said The Prophet NEW SCHOOL TEE (BLACK)
52941 Survive Said The Prophet VERTICAL LOGO TEE
54615 Survive Said The Prophet TAPED LOGO TEE WHITE
54616 Survive Said The Prophet TAPED LOGO TEE BLACK
54618 Survive Said The Prophet EMBRONDERY COMFORT TEE GREEN
54619 Survive Said The Prophet EMBRONDERY COMFORT TEE GRAY
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
53239 【予約商品】Zephyren(ゼファレン)SWITCHING SHIRT S/S WHITE / RED
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
52942 Survive Said The Prophet MIA TOUR TEE
52946 Survive Said The Prophet CONCRETE COACH JKT WHITE
52948 Survive Said The Prophet UNBALANCE TEE LIGHT BLUE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
52951 Survive Said The Prophet UNBALANCE TEE YELLOW
55042 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
52439 STAPLE Supernova Bubble Jacket
52447 STAPLE Neo Sport Nylon Crew
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
46450 Zephyren(ゼファレン)BIG TANKTOP BLACK / 如意宝珠
56555 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-BGN
56570 ICECREAM IC13H255 Beanie RED
56572 NineMicrophones 9MC Crew S/S Blue
16679 【ゲキクロ限定カラー】lynch. ツアーTシャツ BLUE
16682 【ゲキクロ限定カラー】lynch. ツアーTシャツ GRAY
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL
37046 MARILYN MANSON×KILL STAR CLOTHING Cryptorchid Harness Dress