// CONSULTA RETORNANDO AS REGRAS DE PRECO DE CARRINHO QUE ESTÃO EM PRODUCAO E NÃO ESTAO NA BASE DE DEV
// evonutriprod -> nome do banco de producao
// evonutridev -> nome do banco do dev

mysql> select rule_id, name, from_date, to_date from evonutriprod.salesrule where evonutriprod.salesrule.rule_id not in (select rule_id from evonutridev.salesrule);
+---------+-----------------------------------------------+------------+------------+
| rule_id | name                                          | from_date  | to_date    |
+---------+-----------------------------------------------+------------+------------+
|     109 | Vivi Teixeira                                 | 2019-08-20 | 2025-08-21 |
|     133 | Adriana A ribeiro Rangel                      | 2019-10-08 | 2025-10-08 |
|     137 | Denise De Sousa Silva Leão                    | 2019-10-09 | 2025-10-09 |
|     138 | Gustavo Leme de Carvalho                      | 2019-10-09 | 2025-10-09 |
|     139 | Jean da Conceição Almeida Alves               | 2019-10-09 | 2025-10-09 |
|     140 | Guilherme Galli Larrubia                      | 2019-10-09 | 2025-10-09 |
|     141 | ALTAIR DE OLIVEIRA SILVA                      | 2019-10-10 | 2025-05-10 |
|     142 | Bruno Alves Boaventura                        | 2019-10-10 | 2025-10-10 |
|     143 | Geova Vanderlei da Silva Filho                | 2019-10-10 | 2025-10-10 |
|     147 | EVO Frete Grátis                              | 2019-10-14 | 2025-10-14 |
|     148 | Recompra Site 20%                             | 2019-10-14 | 2025-10-14 |
|     149 | Pietro Amadio                                 | 2019-10-14 | 2025-10-14 |
|     150 | Rafael Alves de Oliveira                      | 2019-10-14 | 2025-10-14 |
|     151 | Tiago Souza de Ávila                          | 2019-10-14 | 2025-10-14 |
|     153 | Fabio Bittencourt Racamora                    | 2019-10-14 | 2025-10-14 |
|     154 | Primeira Compra 20%                           | 2019-10-15 | 2025-10-15 |
|     155 | Vitor tavares ferrucio                        | 2019-10-15 | 2025-10-15 |
|     156 | Carolina Silva Ferreira                       | 2019-10-15 | 2025-10-15 |
|     157 | Ana Paula de Almeida                          | 2019-10-15 | 2025-10-15 |
|     158 | Sammia Smirna Freitas Teixeira                | 2019-10-16 | 2025-10-16 |
|     159 | Roberto de Oliveira Monteiro                  | 2019-10-17 | 2025-10-17 |
|     160 | Felipe Nascimento                             | 2019-10-17 | 2025-10-17 |
|     161 | Ingrid Caroline Duchnicky                     | 2019-10-21 | 2025-10-21 |
|     162 | Elisangela Costa Cantos                       | 2019-10-23 | 2025-10-23 |
|     163 | Luan Mário Fernandes de Lima                  | 2019-10-23 | 2025-10-23 |
|     164 | FELIPE GALDINO MACHADO DE OLIVEIRA            | 2019-10-23 | 2025-10-23 |
|     165 | Desconto de 20%                               | 2019-10-24 | 2025-10-24 |
|     166 | Kaique Hostalácio Terra                       | 2019-10-24 | 2026-10-24 |
|     167 | Evo Me Veste                                  | 2019-10-28 | 2019-10-29 |
|     168 | Nayna Almeida                                 | 2019-10-28 | 2025-10-28 |
|     170 | Leandro Sousa Lopes                           | 2019-10-28 | 2025-10-28 |
|     171 | Reginaldo Sampaio Santana                     | 2019-10-29 | 2025-10-29 |
|     172 |  Andréa Capitulino                            | 2019-10-29 | 2025-10-29 |
|     173 | Kevin Klaws Ghiraldello                       | 2019-10-30 | 2025-10-30 |
|     174 | Liliane de Jesus Magalhães                    | 2019-10-30 | 2025-10-30 |
|     175 | Malhando a Língua                             | 2019-10-31 | 2019-11-30 |
|     176 | Paulo Gelatti                                 | 2019-10-31 | 2025-10-31 |
|     178 | Allan do Nascimento Leite                     | 2019-11-04 | 2025-11-04 |
|     179 | Caio Matos Fonseca                            | 2019-11-04 | 2025-11-04 |
|     180 | Desconto Novembro Influencer 500              | 2019-11-01 | 2019-11-30 |
|     181 | Desconto Novembro Influencer 750              | 2019-11-01 | 2019-11-30 |
|     182 | Desconto Novembro Influencer 1000             | 2019-11-01 | 2019-11-30 |
|     183 | André Luiz Passaglia Guimarães Montes Leite   | 2019-11-05 | 2025-11-05 |
|     184 | Rennan Vieira Matos                           | 2019-11-05 | 2025-11-05 |
|     185 | Beatriz Kathleen de Souza                     | 2019-11-05 | 2025-11-05 |
|     186 | Kaique Luiz Camara                            | 2019-11-06 | 2025-11-06 |
|     187 | Ananda Maria Lustosa da Silva                 | 2019-11-08 | 2025-11-08 |
|     188 | Fernanda Cristina Figueiredo                  | 2019-11-08 | 2025-11-08 |
+---------+-----------------------------------------------+------------+------------+