Untitled

mail@pastecode.io avatar
unknown
mysql
19 days ago
1.5 kB
1
Indexable
Never
UPDATE whatsapp_template_statistic wts
    INNER JOIN whatsapp_template_reject_statistic wtrs ON wts.tracker_id = wtrs.tracker_id
        AND wts.date = wtrs.date
        AND wts.whatsapp_template_id = wtrs.whatsapp_template_id
        AND wts.custom_flow_id = wtrs.custom_flow_id
        AND wts.custom_flow_element_id = wtrs.custom_flow_element_id
SET
    wts.remote_rejected_unhandled = wtrs.unhandled,
    wts.remote_rejected_throttled = wtrs.throttled,
    wts.remote_rejected_missing_params = wtrs.missing_params,
    wts.remote_rejected_invalid_params = wtrs.invalid_params,
    wts.remote_rejected_invalid_template = wtrs.invalid_template,
    wts.remote_rejected_internal_error = wtrs.internal_error,
    wts.remote_rejected_invalid_message = wtrs.invalid_message,
    wts.remote_rejected_too_many_send_requests = wtrs.too_many_send_requests,
    wts.remote_rejected_number_blocked_by_carrier = wtrs.number_blocked_by_carrier,
    wts.remote_rejected_message_blocked_by_provider = wtrs.message_blocked_by_provider,
    wts.remote_rejected_not_suitable_device = wtrs.not_suitable_device,
    wts.remote_rejected_unknown = wtrs.unknown,
    wts.remote_rejected_provider_error = wtrs.provider_error,
    wts.remote_rejected_invalid_message_type = wtrs.invalid_message_type,
    wts.remote_rejected_invalid_client_reference = wtrs.invalid_client_reference,
    wts.remote_rejected_daily_message_limit_exceeded = wtrs.daily_message_limit_exceeded
Leave a Comment