API tools faq
paste
Advertisement
kuroshan1104

consulta de bajas autovaluo amnistia 40% V2

kuroshan1104
May 26th, 2025
397
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.00 KB | Source Code | 0 0
raw download clone embed print report
  1. SELECT
  2.     gp.nomcompleto,
  3.     GROUP_CONCAT(DISTINCT p.codigo
  4.                  ORDER BY p.codigo ASC
  5.                  SEPARATOR ', ') AS codigos
  6. FROM
  7.     (
  8.       /* 1) Solo deudas válidas */
  9.       SELECT
  10.         ideuda,
  11.         idpersona
  12.       FROM d_deuda
  13.       WHERE
  14.         idconcepto = 8
  15.         AND estado    IN ('DE','OK')
  16.         /* Excluir igualdades en los extremos */
  17.         AND saldo     > cargo * 0.38
  18.         AND saldo     < cargo * 0.405
  19.     ) AS df
  20.   /* 2) A partir de esas deudas, levantar puestos */
  21.   JOIN d_deuda_puesto dp
  22.     ON dp.ideuda = df.ideuda
  23.   JOIN p_puesto p
  24.     ON p.idpuesto = dp.idpuesto
  25.    AND p.activo   = 1
  26.   /* 3) Y solo los puestos realmente vinculados al socio */
  27.   JOIN p_puesto_socio pps
  28.     ON pps.idpuesto = p.idpuesto
  29.    AND pps.idsocio  = df.idpersona
  30.    AND pps.activo   = 1
  31.   /* 4) Para mostrar el nombre */
  32.   JOIN g_persona gp
  33.     ON gp.idpersona = df.idpersona
  34. GROUP BY
  35.     df.idpersona, gp.nomcompleto
  36. ORDER BY
  37.     gp.nomcompleto;
  38.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!