| CARVIEW |
Select Language
HTTP/2 200
date: Sun, 12 Oct 2025 17:43:17 GMT
content-type: text/html; charset=UTF-8
server: cloudflare
x-frame-options: DENY
x-content-type-options: nosniff
x-xss-protection: 1;mode=block
vary: accept-encoding
cf-cache-status: DYNAMIC
content-encoding: gzip
set-cookie: _csrf-frontend=7c82179586ab7f5d203d1b5d62101b730fd05b9c7087f15a4414079e1b3476a5a%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22j84L3T0V6rknKjsvohGF0shzMRzPspl-%22%3B%7D; HttpOnly; Path=/
cf-ray: 98d8660daab8af3d-BLR
Reporte clientes para DiHola - Pastebin.com
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* Con esta consulta obtenemos nombre, telefono y fecha de ultima compra de todos aquellos clientes que compraron en el ultimo año (2025) y como telefono tienen celular */
- SELECT
- c.nombre,
- c.telefono1,
- MAX(ch.cierre) AS primera_compra
- FROM clientes c
- JOIN cheques ch ON c.idcliente = ch.idcliente
- WHERE ch.cancelado = 0
- AND ch.impreso = 1
- AND ch.pagado = 1
- AND ch.cierre >= '2025-01-01'
- AND (c.telefono1 LIKE '+598%' OR c.telefono1 LIKE '09%')
- GROUP BY c.idcliente, c.nombre, c.telefono1
- ORDER BY nombre
Advertisement
Add Comment
Please, Sign In to add comment
-
💡 EASY MONEY GUIDE ✅ Working
JavaScript | 5 sec ago | 0.24 KB
-
⭐✅ Exploit 2500$ in 15 Minutes⭐⭐⭐ 5
JavaScript | 9 sec ago | 0.25 KB
-
🔥 Exchange profit method
JavaScript | 17 sec ago | 0.24 KB
-
📝 EASY MONEY GUIDE ✅ Working A
JavaScript | 18 sec ago | 0.25 KB
-
📌 Instant BTC Profit Method ✅ Working V
JavaScript | 27 sec ago | 0.25 KB
-
✅ Make $2500 in 20 minutes⭐ T
JavaScript | 36 sec ago | 0.25 KB
-
💵 Make 3000$ in 20 minutes 💵
JavaScript | 36 sec ago | 0.24 KB
-
📌 Swapzone +37% glitch ⭐ 5
JavaScript | 44 sec ago | 0.25 KB
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
