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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =17
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-18 21:21:47')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 333)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
16件見つかりました
1ページ中1ページ目
1
完売
¥5,500
SANTA CRUZ
Cap
完売
¥5,500
SANTA CRUZ
Cap
完売
¥4,290
SANTA CRUZ
Cap
完売
¥4,290
SANTA CRUZ
Cap
完売
¥5,500
SANTA CRUZ
Cap
完売
¥5,720
SANTA CRUZ
Cap
完売
¥5,280
SANTA CRUZ
Cap
完売
¥5,280
SANTA CRUZ
Cap
完売
¥5,060
SANTA CRUZ
Cap
完売
¥5,060
SANTA CRUZ
Cap
完売
¥5,280
SANTA CRUZ
Cap
完売
¥5,280
SANTA CRUZ
Cap
完売
¥5,280
SANTA CRUZ
Cap
完売
¥5,060
SANTA CRUZ
Cap
完売
¥5,060
SANTA CRUZ
Cap
完売
¥5,280
SANTA CRUZ
Cap
16件見つかりました
1ページ中1ページ目
1
9339 SANTA CRUZ CLASSIC DOT FLEXFIT FITTED STRETCH BLK
9340 SANTA CRUZ CLASSIC DOT FLEXFIT FITTED STRETCH B/G
9342 SANTA CRUZ OTHER DOT TRUCKER MESH WHITE/BLACK
9343 SANTA CRUZ OPUS TRUCKER MESH HAT WHT/BLK
9346 SANTA CRUZ SC Block 2 Flex Fit Hat BLK
39918 SANTA CRUZ OGSC Mini Snapback
44033 SANTA CRUZ STREET SLANT CAP BLACK
44034 SANTA CRUZ STREET SLANT CAP KHAKI
44045 SANTA CRUZ SCREAMING HAND HAT BLACK
44046 SANTA CRUZ SCREAMING HAND HAT WHITE×BLACK
44047 SANTA CRUZ STRIP HATS BLACK
44048 SANTA CRUZ STRIP HATS NAVY
47632 SANTA CRUZ CLASSIC MID PROFILE SNAPBACK HATS BLACK
47633 SANTA CRUZ CLASSIC DOT HIGH PROFILE MESH TRUCKER HATS BLACK
47634 SANTA CRUZ CLASSIC DOT HIGH PROFILE MESH TRUCKER HATS BLACK/WHITE
47635 SANTA CRUZ DOT BLOCKER SNAPBACK UNSTRUCTURED HATS BLACK