Faça parte de nosso marketplace!
Cadastre-se aqui.
ou até 10x de R$ 60,05 (com juros)
ou até 3x de R$ 50,26 (com juros)
ou até 3x de R$ 46,24 (com juros)
ou até 3x de R$ 46,24 (com juros)
ou até 3x de R$ 46,24 (com juros)
ou até 3x de R$ 46,24 (com juros)
ou até 3x de R$ 46,24 (com juros)
ou até 3x de R$ 46,24 (com juros)
ou até 3x de R$ 46,24 (com juros)
ou até 3x de R$ 46,24 (com juros)
ou até 3x de R$ 46,24 (com juros)
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
select * from `cad_category` where `cad_category`.`deleted_at` is null and `slug` = 'livros' and `status` = '1' order by `sequence` asc limit 11.81mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('36') order by `sequence` asc2.57mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('128', '76', '77', '78', '79', '80', '81', '82', '83', '84', '85', '117', '124', '125', '126', '127') order by `sequence` asc6.56mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('118', '150') order by `sequence` asc1.34mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_banner_group` where `cad_banner_group`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_category_banner_group` on `cad_category`.`id` = `cad_category_banner_group`.`category_id` where `cad_category_banner_group`.`banner_group_id` = `cad_banner_group`.`id` and `id` = '36' and `cad_category`.`deleted_at` is null) >= 1 and `status` <> '0' order by `created_at` desc1.97mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select `cad_product`.`id` from `cad_product` inner join `cad_store` on `cad_product`.`store_id` = `cad_store`.`id` inner join `cad_sku` on `cad_product`.`id` = `cad_sku`.`product_id` inner join `cad_price_table_sku` on `cad_sku`.`id` = `cad_price_table_sku`.`sku_id` where `cad_product`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_product_category`.`product_id` = `cad_product`.`id` and `category_id` in ('36') and `cad_category`.`deleted_at` is null) >= 1 and (`cad_product`.`publish` = '1' and `cad_product`.`deleted_at` is null) and (select count(*) from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_product_category`.`product_id` = `cad_product`.`id` and `status` = '1' and `cad_category`.`deleted_at` is null) >= 1 and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1 and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `status` = '1' and `percent` >= '6.5' and `cad_store`.`deleted_at` is null) >= 1 and `cad_sku`.`status` = '1' and (`cad_price_table_sku`.`retail` > '0' or `cad_price_table_sku`.`wholesale` > '0') group by `cad_sku`.`product_id` order by
(SELECT -sequence from cad_product_category where category_id = 36 and product_id = cad_product.id LIMIT 1)
desc,
CASE
WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail > 0)
THEN cad_price_table_sku.sale_retail
WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail <= 0)
THEN cad_price_table_sku.retail
WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale > 0)
THEN cad_price_table_sku.sale_wholesale
WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale <= 0)
THEN cad_price_table_sku.wholesale
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail > 0)
THEN cad_price_table_sku.sale_retail
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail <= 0 AND cad_price_table_sku.retail > 0)
THEN cad_price_table_sku.retail
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale > 0)
THEN cad_price_table_sku.sale_wholesale
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale <= 0 AND cad_price_table_sku.wholesale > 0)
THEN cad_price_table_sku.wholesale
END
desc100.5mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `id`, `name`, `parent_id`, `slug`, `sequence` from `cad_category` where `cad_category`.`deleted_at` is null and (select count(*) from `cad_product` inner join `cad_product_category` on `cad_product`.`id` = `cad_product_category`.`product_id` where `cad_product_category`.`category_id` = `cad_category`.`id` and `product_id` in ('588', '589', '262', '266', '269', '272', '587', '1979', '4754', '6487', '6165', '6147', '6148', '6149', '6150', '6151', '6152', '6153', '6154', '6155', '6156', '6157', '6158', '6159', '6160', '6161', '6162', '1700', '4546', '5087', '4628', '4998', '6335', '6350', '747', '1255', '1256', '1257', '1258', '1259', '1260', '749', '6332', '4850', '6492', '646', '746', '6356', '6496', '6497', '3045', '4825', '6365', '1980', '2350', '2669', '622', '1639', '2581', '5665', '631', '638', '648', '2965', '531', '2398', '2399', '2582', '2583', '3286', '1790', '2004', '3696', '5973', '5974', '3669', '525', '530', '751', '6341', '2673', '5614', '5615', '5616', '6030', '798', '1984', '2670', '4777', '4778', '4879', '4880', '4881', '5091', '5734', '6073', '6490', '6495', '6498', '256', '568', '628', '756', '1165', '4554', '6115', '6340', '6358', '644', '5733', '6357', '2353', '271', '273', '528', '753', '755', '1160', '1162', '4211', '6344', '6347', '6354', '3667', '338', '1395', '4470', '4851', '5372', '6072', '6146', '6488', '6489', '6494', '6500', '868', '1161', '4210', '2671', '261', '265', '268', '529', '758', '6352', '1987', '2189', '752', '6359', '527', '549', '570', '6361', '6362', '6364', '2177', '6336', '6342', '6351', '331', '332', '333', '335', '799', '1978', '1983', '2188', '2191', '2960', '4376', '4444', '4449', '4544', '6491', '6493', '1483', '255', '257', '264', '533', '534', '569', '618', '621', '627', '630', '632', '633', '637', '640', '882', '1158', '6334', '6346', '6360', '3915', '645', '270', '274', '523', '748', '571', '6333', '1989', '1992', '2046', '2047', '2049', '4658', '5090', '1164', '2352', '6339', '1974', '1982', '1985', '2190', '4448', '4466', '6499', '2172', '546', '572', '634', '2349', '636', '750', '6337', '1977', '1986', '1988', '1990', '1991', '2048', '2176', '2178', '2187', '4445', '4446', '4447', '4471', '4545', '4873', '4874', '4875', '4876', '4877', '4878', '5092', '5408', '4214', '4217', '6260', '1157', '1993', '917', '629', '647', '2110', '862', '3226', '3227') and `cad_product`.`deleted_at` is null) >= 1 and `status` = '1'58.47mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select distinct `id`, `name` from `cad_brand` where `cad_brand`.`deleted_at` is null and (select count(*) from `cad_product` where `cad_product`.`brand_id` = `cad_brand`.`id` and `id` in ('588', '589', '262', '266', '269', '272', '587', '1979', '4754', '6487', '6165', '6147', '6148', '6149', '6150', '6151', '6152', '6153', '6154', '6155', '6156', '6157', '6158', '6159', '6160', '6161', '6162', '1700', '4546', '5087', '4628', '4998', '6335', '6350', '747', '1255', '1256', '1257', '1258', '1259', '1260', '749', '6332', '4850', '6492', '646', '746', '6356', '6496', '6497', '3045', '4825', '6365', '1980', '2350', '2669', '622', '1639', '2581', '5665', '631', '638', '648', '2965', '531', '2398', '2399', '2582', '2583', '3286', '1790', '2004', '3696', '5973', '5974', '3669', '525', '530', '751', '6341', '2673', '5614', '5615', '5616', '6030', '798', '1984', '2670', '4777', '4778', '4879', '4880', '4881', '5091', '5734', '6073', '6490', '6495', '6498', '256', '568', '628', '756', '1165', '4554', '6115', '6340', '6358', '644', '5733', '6357', '2353', '271', '273', '528', '753', '755', '1160', '1162', '4211', '6344', '6347', '6354', '3667', '338', '1395', '4470', '4851', '5372', '6072', '6146', '6488', '6489', '6494', '6500', '868', '1161', '4210', '2671', '261', '265', '268', '529', '758', '6352', '1987', '2189', '752', '6359', '527', '549', '570', '6361', '6362', '6364', '2177', '6336', '6342', '6351', '331', '332', '333', '335', '799', '1978', '1983', '2188', '2191', '2960', '4376', '4444', '4449', '4544', '6491', '6493', '1483', '255', '257', '264', '533', '534', '569', '618', '621', '627', '630', '632', '633', '637', '640', '882', '1158', '6334', '6346', '6360', '3915', '645', '270', '274', '523', '748', '571', '6333', '1989', '1992', '2046', '2047', '2049', '4658', '5090', '1164', '2352', '6339', '1974', '1982', '1985', '2190', '4448', '4466', '6499', '2172', '546', '572', '634', '2349', '636', '750', '6337', '1977', '1986', '1988', '1990', '1991', '2048', '2176', '2178', '2187', '4445', '4446', '4447', '4471', '4545', '4873', '4874', '4875', '4876', '4877', '4878', '5092', '5408', '4214', '4217', '6260', '1157', '1993', '917', '629', '647', '2110', '862', '3226', '3227') and `cad_product`.`deleted_at` is null) >= 1 order by `name` asc4.11mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('588', '589', '262', '266', '269', '272', '587', '1979', '4754', '6487', '6165', '6147', '6148', '6149', '6150', '6151', '6152', '6153', '6154', '6155', '6156', '6157', '6158', '6159', '6160', '6161', '6162', '1700', '4546', '5087', '4628', '4998', '6335', '6350', '747', '1255', '1256', '1257', '1258', '1259', '1260', '749', '6332', '4850', '6492', '646', '746', '6356', '6496', '6497', '3045', '4825', '6365', '1980', '2350', '2669', '622', '1639', '2581', '5665', '631', '638', '648', '2965', '531', '2398', '2399', '2582', '2583', '3286', '1790', '2004', '3696', '5973', '5974', '3669', '525', '530', '751', '6341', '2673', '5614', '5615', '5616', '6030', '798', '1984', '2670', '4777', '4778', '4879', '4880', '4881', '5091', '5734', '6073', '6490', '6495', '6498', '256', '568', '628', '756', '1165', '4554', '6115', '6340', '6358', '644', '5733', '6357', '2353', '271', '273', '528', '753', '755', '1160', '1162', '4211', '6344', '6347', '6354', '3667', '338', '1395', '4470', '4851', '5372', '6072', '6146', '6488', '6489', '6494', '6500', '868', '1161', '4210', '2671', '261', '265', '268', '529', '758', '6352', '1987', '2189', '752', '6359', '527', '549', '570', '6361', '6362', '6364', '2177', '6336', '6342', '6351', '331', '332', '333', '335', '799', '1978', '1983', '2188', '2191', '2960', '4376', '4444', '4449', '4544', '6491', '6493', '1483', '255', '257', '264', '533', '534', '569', '618', '621', '627', '630', '632', '633', '637', '640', '882', '1158', '6334', '6346', '6360', '3915', '645', '270', '274', '523', '748', '571', '6333', '1989', '1992', '2046', '2047', '2049', '4658', '5090', '1164', '2352', '6339', '1974', '1982', '1985', '2190', '4448', '4466', '6499', '2172', '546', '572', '634', '2349', '636', '750', '6337', '1977', '1986', '1988', '1990', '1991', '2048', '2176', '2178', '2187', '4445', '4446', '4447', '4471', '4545', '4873', '4874', '4875', '4876', '4877', '4878', '5092', '5408', '4214', '4217', '6260', '1157', '1993', '917', '629', '647', '2110', '862', '3226', '3227') and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) as `exists`5.34mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('588', '589', '262', '266', '269', '272', '587', '1979', '4754', '6487', '6165', '6147', '6148', '6149', '6150', '6151', '6152', '6153', '6154', '6155', '6156', '6157', '6158', '6159', '6160', '6161', '6162', '1700', '4546', '5087', '4628', '4998', '6335', '6350', '747', '1255', '1256', '1257', '1258', '1259', '1260', '749', '6332', '4850', '6492', '646', '746', '6356', '6496', '6497', '3045', '4825', '6365', '1980', '2350', '2669', '622', '1639', '2581', '5665', '631', '638', '648', '2965', '531', '2398', '2399', '2582', '2583', '3286', '1790', '2004', '3696', '5973', '5974', '3669', '525', '530', '751', '6341', '2673', '5614', '5615', '5616', '6030', '798', '1984', '2670', '4777', '4778', '4879', '4880', '4881', '5091', '5734', '6073', '6490', '6495', '6498', '256', '568', '628', '756', '1165', '4554', '6115', '6340', '6358', '644', '5733', '6357', '2353', '271', '273', '528', '753', '755', '1160', '1162', '4211', '6344', '6347', '6354', '3667', '338', '1395', '4470', '4851', '5372', '6072', '6146', '6488', '6489', '6494', '6500', '868', '1161', '4210', '2671', '261', '265', '268', '529', '758', '6352', '1987', '2189', '752', '6359', '527', '549', '570', '6361', '6362', '6364', '2177', '6336', '6342', '6351', '331', '332', '333', '335', '799', '1978', '1983', '2188', '2191', '2960', '4376', '4444', '4449', '4544', '6491', '6493', '1483', '255', '257', '264', '533', '534', '569', '618', '621', '627', '630', '632', '633', '637', '640', '882', '1158', '6334', '6346', '6360', '3915', '645', '270', '274', '523', '748', '571', '6333', '1989', '1992', '2046', '2047', '2049', '4658', '5090', '1164', '2352', '6339', '1974', '1982', '1985', '2190', '4448', '4466', '6499', '2172', '546', '572', '634', '2349', '636', '750', '6337', '1977', '1986', '1988', '1990', '1991', '2048', '2176', '2178', '2187', '4445', '4446', '4447', '4471', '4545', '4873', '4874', '4875', '4876', '4877', '4878', '5092', '5408', '4214', '4217', '6260', '1157', '1993', '917', '629', '647', '2110', '862', '3226', '3227') and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) as `exists`4.48mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `id`, `name`, `main_id` from `cad_variant` where `cad_variant`.`deleted_at` is null and (select count(*) from `cad_sku` inner join `cad_sku_variant` on `cad_sku`.`id` = `cad_sku_variant`.`sku_id` where `cad_sku_variant`.`variant_id` = `cad_variant`.`id` and `cad_sku`.`product_id` in ('588', '589', '262', '266', '269', '272', '587', '1979', '4754', '6487', '6165', '6147', '6148', '6149', '6150', '6151', '6152', '6153', '6154', '6155', '6156', '6157', '6158', '6159', '6160', '6161', '6162', '1700', '4546', '5087', '4628', '4998', '6335', '6350', '747', '1255', '1256', '1257', '1258', '1259', '1260', '749', '6332', '4850', '6492', '646', '746', '6356', '6496', '6497', '3045', '4825', '6365', '1980', '2350', '2669', '622', '1639', '2581', '5665', '631', '638', '648', '2965', '531', '2398', '2399', '2582', '2583', '3286', '1790', '2004', '3696', '5973', '5974', '3669', '525', '530', '751', '6341', '2673', '5614', '5615', '5616', '6030', '798', '1984', '2670', '4777', '4778', '4879', '4880', '4881', '5091', '5734', '6073', '6490', '6495', '6498', '256', '568', '628', '756', '1165', '4554', '6115', '6340', '6358', '644', '5733', '6357', '2353', '271', '273', '528', '753', '755', '1160', '1162', '4211', '6344', '6347', '6354', '3667', '338', '1395', '4470', '4851', '5372', '6072', '6146', '6488', '6489', '6494', '6500', '868', '1161', '4210', '2671', '261', '265', '268', '529', '758', '6352', '1987', '2189', '752', '6359', '527', '549', '570', '6361', '6362', '6364', '2177', '6336', '6342', '6351', '331', '332', '333', '335', '799', '1978', '1983', '2188', '2191', '2960', '4376', '4444', '4449', '4544', '6491', '6493', '1483', '255', '257', '264', '533', '534', '569', '618', '621', '627', '630', '632', '633', '637', '640', '882', '1158', '6334', '6346', '6360', '3915', '645', '270', '274', '523', '748', '571', '6333', '1989', '1992', '2046', '2047', '2049', '4658', '5090', '1164', '2352', '6339', '1974', '1982', '1985', '2190', '4448', '4466', '6499', '2172', '546', '572', '634', '2349', '636', '750', '6337', '1977', '1986', '1988', '1990', '1991', '2048', '2176', '2178', '2187', '4445', '4446', '4447', '4471', '4545', '4873', '4874', '4875', '4876', '4877', '4878', '5092', '5408', '4214', '4217', '6260', '1157', '1993', '917', '629', '647', '2110', '862', '3226', '3227') and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 138.09mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `id`, `name` from `cad_variant` where `cad_variant`.`deleted_at` is null and `cad_variant`.`id` in ('14', '337')1.25mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select * from `cad_attribute` where `cad_attribute`.`deleted_at` is null and (select count(*) from `cad_attribute` as `self_5e6477808354d1305c13645ce4c59648` where `cad_attribute`.`deleted_at` is null and `self_5e6477808354d1305c13645ce4c59648`.`main_id` = `cad_attribute`.`id` and (select count(*) from `cad_product` inner join `cad_product_attributes` on `cad_product`.`id` = `cad_product_attributes`.`product_id` where `cad_product_attributes`.`attribute_id` = `self_5e6477808354d1305c13645ce4c59648`.`id` and `product_id` in ('588', '589', '262', '266', '269', '272', '587', '1979', '4754', '6487', '6165', '6147', '6148', '6149', '6150', '6151', '6152', '6153', '6154', '6155', '6156', '6157', '6158', '6159', '6160', '6161', '6162', '1700', '4546', '5087', '4628', '4998', '6335', '6350', '747', '1255', '1256', '1257', '1258', '1259', '1260', '749', '6332', '4850', '6492', '646', '746', '6356', '6496', '6497', '3045', '4825', '6365', '1980', '2350', '2669', '622', '1639', '2581', '5665', '631', '638', '648', '2965', '531', '2398', '2399', '2582', '2583', '3286', '1790', '2004', '3696', '5973', '5974', '3669', '525', '530', '751', '6341', '2673', '5614', '5615', '5616', '6030', '798', '1984', '2670', '4777', '4778', '4879', '4880', '4881', '5091', '5734', '6073', '6490', '6495', '6498', '256', '568', '628', '756', '1165', '4554', '6115', '6340', '6358', '644', '5733', '6357', '2353', '271', '273', '528', '753', '755', '1160', '1162', '4211', '6344', '6347', '6354', '3667', '338', '1395', '4470', '4851', '5372', '6072', '6146', '6488', '6489', '6494', '6500', '868', '1161', '4210', '2671', '261', '265', '268', '529', '758', '6352', '1987', '2189', '752', '6359', '527', '549', '570', '6361', '6362', '6364', '2177', '6336', '6342', '6351', '331', '332', '333', '335', '799', '1978', '1983', '2188', '2191', '2960', '4376', '4444', '4449', '4544', '6491', '6493', '1483', '255', '257', '264', '533', '534', '569', '618', '621', '627', '630', '632', '633', '637', '640', '882', '1158', '6334', '6346', '6360', '3915', '645', '270', '274', '523', '748', '571', '6333', '1989', '1992', '2046', '2047', '2049', '4658', '5090', '1164', '2352', '6339', '1974', '1982', '1985', '2190', '4448', '4466', '6499', '2172', '546', '572', '634', '2349', '636', '750', '6337', '1977', '1986', '1988', '1990', '1991', '2048', '2176', '2178', '2187', '4445', '4446', '4447', '4471', '4545', '4873', '4874', '4875', '4876', '4877', '4878', '5092', '5408', '4214', '4217', '6260', '1157', '1993', '917', '629', '647', '2110', '862', '3226', '3227') and `cad_product`.`deleted_at` is null) >= 1 and `cad_attribute`.`deleted_at` is null) >= 1 and `main_id` is null order by `name` asc4.06mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select count(*) as aggregate from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('588', '589', '262', '266', '269', '272', '587', '1979', '4754', '6487', '6165', '6147', '6148', '6149', '6150', '6151', '6152', '6153', '6154', '6155', '6156', '6157', '6158', '6159', '6160', '6161', '6162', '1700', '4546', '5087', '4628', '4998', '6335', '6350', '747', '1255', '1256', '1257', '1258', '1259', '1260', '749', '6332', '4850', '6492', '646', '746', '6356', '6496', '6497', '3045', '4825', '6365', '1980', '2350', '2669', '622', '1639', '2581', '5665', '631', '638', '648', '2965', '531', '2398', '2399', '2582', '2583', '3286', '1790', '2004', '3696', '5973', '5974', '3669', '525', '530', '751', '6341', '2673', '5614', '5615', '5616', '6030', '798', '1984', '2670', '4777', '4778', '4879', '4880', '4881', '5091', '5734', '6073', '6490', '6495', '6498', '256', '568', '628', '756', '1165', '4554', '6115', '6340', '6358', '644', '5733', '6357', '2353', '271', '273', '528', '753', '755', '1160', '1162', '4211', '6344', '6347', '6354', '3667', '338', '1395', '4470', '4851', '5372', '6072', '6146', '6488', '6489', '6494', '6500', '868', '1161', '4210', '2671', '261', '265', '268', '529', '758', '6352', '1987', '2189', '752', '6359', '527', '549', '570', '6361', '6362', '6364', '2177', '6336', '6342', '6351', '331', '332', '333', '335', '799', '1978', '1983', '2188', '2191', '2960', '4376', '4444', '4449', '4544', '6491', '6493', '1483', '255', '257', '264', '533', '534', '569', '618', '621', '627', '630', '632', '633', '637', '640', '882', '1158', '6334', '6346', '6360', '3915', '645', '270', '274', '523', '748', '571', '6333', '1989', '1992', '2046', '2047', '2049', '4658', '5090', '1164', '2352', '6339', '1974', '1982', '1985', '2190', '4448', '4466', '6499', '2172', '546', '572', '634', '2349', '636', '750', '6337', '1977', '1986', '1988', '1990', '1991', '2048', '2176', '2178', '2187', '4445', '4446', '4447', '4471', '4545', '4873', '4874', '4875', '4876', '4877', '4878', '5092', '5408', '4214', '4217', '6260', '1157', '1993', '917', '629', '647', '2110', '862', '3226', '3227')6.2mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('588', '589', '262', '266', '269', '272', '587', '1979', '4754', '6487', '6165', '6147', '6148', '6149', '6150', '6151', '6152', '6153', '6154', '6155', '6156', '6157', '6158', '6159', '6160', '6161', '6162', '1700', '4546', '5087', '4628', '4998', '6335', '6350', '747', '1255', '1256', '1257', '1258', '1259', '1260', '749', '6332', '4850', '6492', '646', '746', '6356', '6496', '6497', '3045', '4825', '6365', '1980', '2350', '2669', '622', '1639', '2581', '5665', '631', '638', '648', '2965', '531', '2398', '2399', '2582', '2583', '3286', '1790', '2004', '3696', '5973', '5974', '3669', '525', '530', '751', '6341', '2673', '5614', '5615', '5616', '6030', '798', '1984', '2670', '4777', '4778', '4879', '4880', '4881', '5091', '5734', '6073', '6490', '6495', '6498', '256', '568', '628', '756', '1165', '4554', '6115', '6340', '6358', '644', '5733', '6357', '2353', '271', '273', '528', '753', '755', '1160', '1162', '4211', '6344', '6347', '6354', '3667', '338', '1395', '4470', '4851', '5372', '6072', '6146', '6488', '6489', '6494', '6500', '868', '1161', '4210', '2671', '261', '265', '268', '529', '758', '6352', '1987', '2189', '752', '6359', '527', '549', '570', '6361', '6362', '6364', '2177', '6336', '6342', '6351', '331', '332', '333', '335', '799', '1978', '1983', '2188', '2191', '2960', '4376', '4444', '4449', '4544', '6491', '6493', '1483', '255', '257', '264', '533', '534', '569', '618', '621', '627', '630', '632', '633', '637', '640', '882', '1158', '6334', '6346', '6360', '3915', '645', '270', '274', '523', '748', '571', '6333', '1989', '1992', '2046', '2047', '2049', '4658', '5090', '1164', '2352', '6339', '1974', '1982', '1985', '2190', '4448', '4466', '6499', '2172', '546', '572', '634', '2349', '636', '750', '6337', '1977', '1986', '1988', '1990', '1991', '2048', '2176', '2178', '2187', '4445', '4446', '4447', '4471', '4545', '4873', '4874', '4875', '4876', '4877', '4878', '5092', '5408', '4214', '4217', '6260', '1157', '1993', '917', '629', '647', '2110', '862', '3226', '3227') order by FIELD(id, 588,589,262,266,269,272,587,1979,4754,6487,6165,6147,6148,6149,6150,6151,6152,6153,6154,6155,6156,6157,6158,6159,6160,6161,6162,1700,4546,5087,4628,4998,6335,6350,747,1255,1256,1257,1258,1259,1260,749,6332,4850,6492,646,746,6356,6496,6497,3045,4825,6365,1980,2350,2669,622,1639,2581,5665,631,638,648,2965,531,2398,2399,2582,2583,3286,1790,2004,3696,5973,5974,3669,525,530,751,6341,2673,5614,5615,5616,6030,798,1984,2670,4777,4778,4879,4880,4881,5091,5734,6073,6490,6495,6498,256,568,628,756,1165,4554,6115,6340,6358,644,5733,6357,2353,271,273,528,753,755,1160,1162,4211,6344,6347,6354,3667,338,1395,4470,4851,5372,6072,6146,6488,6489,6494,6500,868,1161,4210,2671,261,265,268,529,758,6352,1987,2189,752,6359,527,549,570,6361,6362,6364,2177,6336,6342,6351,331,332,333,335,799,1978,1983,2188,2191,2960,4376,4444,4449,4544,6491,6493,1483,255,257,264,533,534,569,618,621,627,630,632,633,637,640,882,1158,6334,6346,6360,3915,645,270,274,523,748,571,6333,1989,1992,2046,2047,2049,4658,5090,1164,2352,6339,1974,1982,1985,2190,4448,4466,6499,2172,546,572,634,2349,636,750,6337,1977,1986,1988,1990,1991,2048,2176,2178,2187,4445,4446,4447,4471,4545,4873,4874,4875,4876,4877,4878,5092,5408,4214,4217,6260,1157,1993,917,629,647,2110,862,3226,3227) limit 20 offset 09.03mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('588', '589', '262', '266', '269', '272', '587', '1979', '4754', '6487', '6165', '6147', '6148', '6149', '6150', '6151', '6152', '6153', '6154', '6155') order by `sequence` asc2.19mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select `cad_sku`.* from `cad_sku` inner join `cad_product` on `cad_sku`.`product_id` = `cad_product`.`id` inner join `cad_store` on `cad_product`.`store_id` = `cad_store`.`id` inner join `cad_price_table_sku` on `cad_sku`.`id` = `cad_price_table_sku`.`sku_id` where `cad_sku`.`deleted_at` is null and `cad_sku`.`product_id` in ('588', '589', '262', '266', '269', '272', '587', '1979', '4754', '6487', '6165', '6147', '6148', '6149', '6150', '6151', '6152', '6153', '6154', '6155') and `cad_sku`.`status` = '1' and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 order by
cad_price_table_sku.retail = 0, cad_price_table_sku.wholesale = 0,
CASE
WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail > 0)
THEN cad_price_table_sku.sale_retail
WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail <= 0)
THEN cad_price_table_sku.retail
WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale > 0)
THEN cad_price_table_sku.sale_wholesale
WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale <= 0)
THEN cad_price_table_sku.wholesale
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail > 0)
THEN cad_price_table_sku.sale_retail
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail <= 0 AND cad_price_table_sku.retail > 0)
THEN cad_price_table_sku.retail
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale > 0)
THEN cad_price_table_sku.sale_wholesale
WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale <= 0 AND cad_price_table_sku.wholesale > 0)
THEN cad_price_table_sku.wholesale
END
asc5.24mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select * from `cad_product` where `cad_product`.`deleted_at` is null and `cad_product`.`id` in ('588', '589', '1979', '262', '269', '272', '266', '587', '6148', '6155', '6154', '6153', '6152', '6151', '6150', '6149', '6147', '6165', '6487', '4754')1.91mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('113', '296', '866', '604')1.86mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_price_table_sku` where `cad_price_table_sku`.`deleted_at` is null and `cad_price_table_sku`.`sku_id` in ('789', '790', '2723', '325', '332', '335', '329', '788', '8084', '8091', '8090', '8089', '8088', '8087', '8086', '8085', '8083', '8101', '8515', '6430')2.15mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` in ('588', '589', '262', '266', '269', '272', '587', '1979', '4754', '6487', '6165', '6147', '6148', '6149', '6150', '6151', '6152', '6153', '6154', '6155')2.61mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('296', '113', '866', '604')1.34mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_show_case` where `cad_show_case`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_category_show_case` on `cad_category`.`id` = `cad_category_show_case`.`category_id` where `cad_category_show_case`.`show_case_id` = `cad_show_case`.`id` and `category_id` = '36' and `cad_category`.`deleted_at` is null) >= 1 and `status` = '1' order by `sequence` asc2.85mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` is null limit 11.09mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Hints |
|
select * from `cad_payment_installment_settings` where `cad_payment_installment_settings`.`deleted_at` is null and `cad_payment_installment_settings`.`id` = '3' limit 11.94mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '588'1.56mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '296' and `cad_payment_recipient`.`store_id` is not null1.11mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '589'1.36mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '262'1.27mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '113' and `cad_payment_recipient`.`store_id` is not null1.11mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '266'1.42mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '269'1.55mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '272'1.29mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '587'1.36mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '1979'1.1mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '866' and `cad_payment_recipient`.`store_id` is not null930μssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4754'1.14mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '604' and `cad_payment_recipient`.`store_id` is not null1.3mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6487'1.45mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6165'1.4mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6147'1.47mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6148'1.45mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6149'1.67mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6150'1.74mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6151'1.61mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6152'1.4mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6153'1.59mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6154'1.31mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '6155'1.53mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` = 'cssEditor' and `attribute` = '' limit 1850μssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'1.09mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc1.28mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_menu_items` where `cad_menu_items`.`deleted_at` is null and `active` = '1'1.19mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_social_media` where `status` = '1' order by `sequence` asc1.42mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'1.87mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'1.46mssmp_mercadoblackmoney| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|