UPDATE role_rights
    LEFT JOIN roles on (role_rights.role_id = roles.id)
    LEFT JOIN rights on (role_rights.right_id = rights.id)
  SET permission = 1
WHERE roles.name = "reseller" AND (
(rights.controller = "providers" AND rights.action = "list") OR
(rights.controller = "providers" AND rights.action = "index") OR
(rights.controller = "providers" AND rights.action = "hide") OR
(rights.controller = "providers" AND rights.action = "new") OR
(rights.controller = "providers" AND rights.action = "create") OR
(rights.controller = "providers" AND rights.action = "edit") OR
(rights.controller = "providers" AND rights.action = "update") OR
(rights.controller = "providers" AND rights.action = "destroy") OR
(rights.controller = "providers" AND rights.action = "server_add") OR
(rights.controller = "providers" AND rights.action = "provider_rules") OR
(rights.controller = "providers" AND rights.action = "provider_rule_add") OR
(rights.controller = "providers" AND rights.action = "provider_rule_destroy") OR
(rights.controller = "providers" AND rights.action = "provider_rule_edit") OR
(rights.controller = "providers" AND rights.action = "provider_rule_update") OR
(rights.controller = "providers" AND rights.action = "provider_rule_change_status") OR
(rights.controller = "stats" AND rights.action = "providers_calls")
);