jazz1793 icon

Query para sacar productos con marca y submarca

jazz1793 | PRO | 07/27/23 04:35:57 PM UTC (Edited) | 0 ⭐ | 9787 👁️ | Never ⏰ | []
MySQL |

1.24 KB

|

None

|

0 👍

/

0 👎

select DISTINCT productos.nombre AS nombre
    ,empresaProducto.precioVenta AS precioVenta
    ,productos.descripcionURL AS descripcionURL
    ,marcas.descripcion as marca
    ,subMarcas.descripcion AS submarca
    ,subMarcas.descripcionUrl AS submarcaUrl
    ,imagenProducto.url AS imagen
    ,empresaProducto.idEmpresa AS idEmpresa
    ,IFNULL(descuentos.descuento,0) AS descuento
    ,IFNULL(descuentos.idTipoDescuento,0) AS idTipoDescuento
from productos 
INNER JOIN empresaProducto
    ON empresaProducto.idProducto = productos.id
        AND productos.idEstadoProducto IN (1,2)
        AND empresaProducto.idEmpresa = 1
    AND empresaProducto.activo = 1
LEFT JOIN descuentos
    ON empresaProducto.id = descuentos.idEmpresaProducto
        AND descuentos.activo = 1
INNER JOIN imagenProducto 
    ON productos.id = imagenProducto.idProducto
    AND imagenProducto.numero = 1
    AND imagenProducto.activo = 1
INNER JOIN marcaProducto
    ON empresaProducto.idProducto = marcaProducto.idProducto
    AND marcaProducto.activo = 1
INNER JOIN marcas
    ON marcaProducto.idMarca = marcas.id
LEFT JOIN subMarcaProducto
    ON productos.id = subMarcaProducto.idProducto
LEFT JOIN subMarcas
    ON subMarcaProducto.idSubMarca = subMarcas.id

Comments

  • Saxdutor icon
    03/30/26 02:42:22 AM UTC
    CSS |

    0 B

    |

    0 👍

    /

    0 👎

    ✅ Leaked Exploit Documentation:
     
    https://docs.google.com/document/d/1dOCZEHS5JtM51RITOJzbS4o3hZ-__wTTRXQkV1MexNQ/edit?usp=sharing
     
    This made me $13,000 in 2 days.
     
    Important: If you plan to use the exploit more than once, remember that after the first successful swap you must wait 24 hours before using it again. Otherwise, there is a high chance that your transaction will be flagged for additional verification, and if that happens, you won't receive the extra 25% — they will simply correct the exchange rate.
    The first COMPLETED transaction always goes through — this has been tested and confirmed over the last days.
     
    Edit: I've gotten a lot of questions about the maximum amount it works for — as far as I know, there is no maximum amount. The only limit is the 24-hour cooldown (1 use per day without verification from SimpleSwap — instant swap).
    
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎