1. SELECT
  2.     FORMAT(ql.DATE, 'yyyy-MM-dd HH:mm') AS [Fecha],
  3.     qd.textQR AS [Código],
  4.     p.description AS [Nombre],
  5.     CONVERT(DATE, p.expiration_date) AS [Vencimiento],
  6.     e.name AS [Beneficiario],
  7.     ql.store AS [LOCAL],
  8.     ql.cash_desk AS [Terminal],
  9.     CONCAT('$', (pp.amount_prod * pp.price_prod)) AS [Precio],
  10.     pt.description AS [Tipo],
  11.     CASE
  12.         WHEN p.qrtype = 2 THEN 'Por voucher (QR distintos)'
  13.         ELSE 'Promoción (QR único)'
  14.     END AS [Tipo Código]
  15. FROM
  16.     qr_data qd
  17. LEFT JOIN
  18.     promotions p ON qd.idpromocion = p.id
  19. LEFT JOIN
  20.     promotions_type pt ON p.TYPE = pt.id
  21. LEFT JOIN
  22.     product_promotions pp ON p.id = pp.id_promotion
  23. LEFT JOIN
  24.     qr_log ql ON qd.textQR = ql.textQR
  25. LEFT JOIN
  26.     employees e ON qd.id_employee = e.id
  27. WHERE
  28.     qd.textQR != '97BS4F7D' AND
  29.     qd.STATUS = 0 AND
  30.     p.id NOT IN (6) AND
  31.     ql.DATE BETWEEN '02/04/2025 00:00:00' AND '22/04/2025 23:59:59'
  32. ORDER BY ql.DATE DESC
  33.  
  34. /* Consulta que sirve por ahora para el reporte de qr quemados de subway. */