-- 已使用
SELECT count(cacwo.id)
FROM carlife_order co
LEFT JOIN carlife_activity_commodity_write_off cacwo ON cacwo.carlife_order_id = co.id
WHERE cacwo.id != '' AND cacwo.type = '1' AND cacwo.carlife_commodity_id = '1'
--已购买
SELECT count(co.id)
FROM carlife_order co
LEFT JOIN carlife_commodity cc ON cc.id = co.carlife_commodity_id
WHERE cc.id = '1'
SELECT cc.name ,cc.id
FROM carlife_commodity cc
LEFT JOIN carlife_activity_commodity cac ON cac.carlife_commodity_id = cc.id
LEFT JOIN carlife_activity ca ON ca.id = cac.carlife_activity_id
WHERE ca.id = '1'