// 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 salesrule.rule_id as id, name, from_date, to_date, salesrule_coupon.code as cupom, is_active from evonutriprod.salesrule join evonutriprod.salesrule_coupon on evonutriprod.salesrule_coupon.rule_id = evonutriprod.salesrule.rule_id where evonutriprod.salesrule.rule_id not in (select rule_id from evonutridev.salesrule) and to_date > CURDATE();
+-----+-----------------------------------------------+------------+------------+------------------+-----------+
| id  | name                                          | from_date  | to_date    | cupom            | is_active |
+-----+-----------------------------------------------+------------+------------+------------------+-----------+
| 109 | Vivi Teixeira                                 | 2019-08-20 | 2025-08-21 | EVOVIVIANE20     |         1 |
| 133 | Adriana A ribeiro Rangel                      | 2019-10-08 | 2025-10-08 | EVOADRIANA20     |         1 |
| 137 | Denise De Sousa Silva Leão                    | 2019-10-09 | 2025-10-09 | EVODENISE20      |         1 |
| 138 | Gustavo Leme de Carvalho                      | 2019-10-09 | 2025-10-09 | EVOGU20          |         1 |
| 139 | Jean da Conceição Almeida Alves               | 2019-10-09 | 2025-10-09 | EVOJEAN20        |         1 |
| 140 | Guilherme Galli Larrubia                      | 2019-10-09 | 2025-10-09 | EVOLOSBRABOS20   |         1 |
| 141 | ALTAIR DE OLIVEIRA SILVA                      | 2019-10-10 | 2025-05-10 | EVOALTAIR20      |         1 |
| 142 | Bruno Alves Boaventura                        | 2019-10-10 | 2025-10-10 | EVOBRUNO20       |         1 |
| 143 | Geova Vanderlei da Silva Filho                | 2019-10-10 | 2025-10-10 | EVOJEOVA20       |         1 |
| 147 | EVO Frete Grátis                              | 2019-10-14 | 2025-10-14 | EVOFRETEGRATIS   |         1 |
| 148 | Recompra Site 20%                             | 2019-10-14 | 2025-10-14 | RECOMPRA         |         1 |
| 149 | Pietro Amadio                                 | 2019-10-14 | 2025-10-14 | EVOPIETROA20     |         1 |
| 150 | Rafael Alves de Oliveira                      | 2019-10-14 | 2025-10-14 | EVORPACIFC20     |         1 |
| 151 | Tiago Souza de Ávila                          | 2019-10-14 | 2025-10-14 | EVOTIAGO20       |         1 |
| 153 | Fabio Bittencourt Racamora                    | 2019-10-14 | 2025-10-14 | EVOFABIO20       |         1 |
| 154 | Primeira Compra 20%                           | 2019-10-15 | 2025-10-15 | PRIMEIRACOMPRA20 |         1 |
| 155 | Vitor tavares ferrucio                        | 2019-10-15 | 2025-10-15 | EVOVITOR20       |         1 |
| 156 | Carolina Silva Ferreira                       | 2019-10-15 | 2025-10-15 | EVOCAROLINA20    |         1 |
| 157 | Ana Paula de Almeida                          | 2019-10-15 | 2025-10-15 | EVOANA20         |         1 |
| 158 | Sammia Smirna Freitas Teixeira                | 2019-10-16 | 2025-10-16 | EVOSAMMIA20      |         1 |
| 159 | Roberto de Oliveira Monteiro                  | 2019-10-17 | 2025-10-17 | EVOROBERTO20     |         1 |
| 160 | Felipe Nascimento                             | 2019-10-17 | 2025-10-17 | EVOFELIPE20      |         1 |
| 161 | Ingrid Caroline Duchnicky                     | 2019-10-21 | 2025-10-21 | EVOINGRIDC20     |         1 |
| 162 | Elisangela Costa Cantos                       | 2019-10-23 | 2025-10-23 | EVOELISANGELA20  |         1 |
| 163 | Luan Mário Fernandes de Lima                  | 2019-10-23 | 2025-10-23 | EVOLUAN20        |         1 |
| 164 | FELIPE GALDINO MACHADO DE OLIVEIRA            | 2019-10-23 | 2025-10-23 | EVOFELIPEG20     |         1 |
| 165 | Desconto de 20%                               | 2019-10-24 | 2025-10-24 | EVO20            |         1 |
| 166 | Kaique Hostalácio Terra                       | 2019-10-24 | 2026-10-24 | EVOKAIQUE20      |         1 |
| 168 | Nayna Almeida                                 | 2019-10-28 | 2025-10-28 | EVONAYNA20       |         1 |
| 170 | Leandro Sousa Lopes                           | 2019-10-28 | 2025-10-28 | EVOLESOUSA20     |         1 |
| 171 | Reginaldo Sampaio Santana                     | 2019-10-29 | 2025-10-29 | EVOREGINALDO20   |         1 |
| 172 |  Andréa Capitulino                            | 2019-10-29 | 2025-10-29 | EVOANDREIA20     |         1 |
| 173 | Kevin Klaws Ghiraldello                       | 2019-10-30 | 2025-10-30 | EVOKEVIN20       |         1 |
| 174 | Liliane de Jesus Magalhães                    | 2019-10-30 | 2025-10-30 | EVOLILIANE20     |         1 |
| 175 | Malhando a Língua                             | 2019-10-31 | 2019-11-30 | malhandoalingua  |         1 |
| 176 | Paulo Gelatti                                 | 2019-10-31 | 2025-10-31 | EVOGELATTI20     |         1 |
| 178 | Allan do Nascimento Leite                     | 2019-11-04 | 2025-11-04 | EVOALLAN20       |         1 |
| 179 | Caio Matos Fonseca                            | 2019-11-04 | 2025-11-04 | EVOCAIO20        |         1 |
| 180 | Desconto Novembro Influencer 500              | 2019-11-01 | 2019-11-30 | timeevo500nov19  |         1 |
| 181 | Desconto Novembro Influencer 750              | 2019-11-01 | 2019-11-30 | timeevo750nov19  |         1 |
| 182 | Desconto Novembro Influencer 1000             | 2019-11-01 | 2019-11-30 | timeevo1000nov19 |         1 |
| 183 | André Luiz Passaglia Guimarães Montes Leite   | 2019-11-05 | 2025-11-05 | EVOANDRE20       |         1 |
| 184 | Rennan Vieira Matos                           | 2019-11-05 | 2025-11-05 | EVORENNAN20      |         1 |
| 185 | Beatriz Kathleen de Souza                     | 2019-11-05 | 2025-11-05 | EVOBEATRIZ20     |         1 |
| 186 | Kaique Luiz Camara                            | 2019-11-06 | 2025-11-06 | EVOKAIQUEC20     |         1 |
| 187 | Ananda Maria Lustosa da Silva                 | 2019-11-08 | 2025-11-08 | EVOANANDA20      |         1 |
| 188 | Fernanda Cristina Figueiredo                  | 2019-11-08 | 2025-11-08 | EVOFERNANDA20    |         1 |
+-----+-----------------------------------------------+------------+------------+------------------+-----------+
47 rows in set (0.02 sec)