jazz1793

Query para sacar productos con marca y submarca

Jul 27th, 2023 (edited)
10,061
0
Never
2
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.24 KB | None | 0 0
  1. select DISTINCT productos.nombre AS nombre
  2.     ,empresaProducto.precioVenta AS precioVenta
  3.     ,productos.descripcionURL AS descripcionURL
  4.     ,marcas.descripcion as marca
  5.     ,subMarcas.descripcion AS submarca
  6.     ,subMarcas.descripcionUrl AS submarcaUrl
  7.     ,imagenProducto.url AS imagen
  8.     ,empresaProducto.idEmpresa AS idEmpresa
  9.     ,IFNULL(descuentos.descuento,0) AS descuento
  10.     ,IFNULL(descuentos.idTipoDescuento,0) AS idTipoDescuento
  11. from productos
  12. INNER JOIN empresaProducto
  13.     ON empresaProducto.idProducto = productos.id
  14.         AND productos.idEstadoProducto IN (1,2)
  15.         AND empresaProducto.idEmpresa = 1
  16.     AND empresaProducto.activo = 1
  17. LEFT JOIN descuentos
  18.     ON empresaProducto.id = descuentos.idEmpresaProducto
  19.         AND descuentos.activo = 1
  20. INNER JOIN imagenProducto
  21.     ON productos.id = imagenProducto.idProducto
  22.     AND imagenProducto.numero = 1
  23.     AND imagenProducto.activo = 1
  24. INNER JOIN marcaProducto
  25.     ON empresaProducto.idProducto = marcaProducto.idProducto
  26.     AND marcaProducto.activo = 1
  27. INNER JOIN marcas
  28.     ON marcaProducto.idMarca = marcas.id
  29. LEFT JOIN subMarcaProducto
  30.     ON productos.id = subMarcaProducto.idProducto
  31. LEFT JOIN subMarcas
  32.     ON subMarcaProducto.idSubMarca = subMarcas.id
Advertisement
Comments
  • Saxdutor
    212 days
    # CSS 0.85 KB | 0 0
    1. ✅ Leaked Exploit Documentation:
    2.  
    3. https://docs.google.com/document/d/1dOCZEHS5JtM51RITOJzbS4o3hZ-__wTTRXQkV1MexNQ/edit?usp=sharing
    4.  
    5. This made me $13,000 in 2 days.
    6.  
    7. 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.
    8. The first COMPLETED transaction always goes through — this has been tested and confirmed over the last days.
    9.  
    10. 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).
  • User was banned
Add Comment
Please, Sign In to add comment