50,526
社区成员
发帖
与我相关
我的任务
分享
SELECT
COUPON_DEFINITION_ID AS ID
, count(1) AS MEMBER_RECEIVED_COUNT
FROM
ssp_coupon_entity
WHERE
(
COUPON_DEFINITION_ID = 1077012258384646144
OR COUPON_DEFINITION_ID = 989348700281253888
OR COUPON_DEFINITION_ID = 1089779469570408448
)
AND TENANT_ID = 512825572674899968
AND (`IS_VOID` IS NULL OR `IS_VOID` = 0)
AND `IS_DELETED` = 0
GROUP BY
COUPON_DEFINITION_ID
SELECT
COUPON_DEFINITION_ID AS ID
, count(1) AS MEMBER_RECEIVED_COUNT
FROM
ssp_coupon_entity
WHERE
(
COUPON_DEFINITION_ID = 1077012258384646144
OR COUPON_DEFINITION_ID = 989348700281253888
OR COUPON_DEFINITION_ID = 1089779469570408448
)
AND TENANT_ID = 512825572674899968
AND (`IS_VOID` IS NULL OR `IS_VOID` = 0)
AND `IS_DELETED` = 0
GROUP BY
COUPON_DEFINITION_ID