| CARVIEW |
Select Language
HTTP/2 200
date: Fri, 10 Oct 2025 18:51:21 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=8d045af9db99219c1e7e60ebc2800f63016d242d368fd76d34b993318897cdf2a%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22agrVd9Fi0bP_5sYrciOKeFxWqamiaec1%22%3B%7D; HttpOnly; Path=/
cf-ray: 98c84f02db02741b-BLR
Search SIMILARITY() - Pastebin.com
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ----------------------- FORMS 1-2A DATA TAGGING ANALYSIS -------------
- SELECT
- bp.id_code AS "IC",
- CASE
- WHEN v.is_kbbl IS TRUE THEN ' ✓'
- ELSE ''
- END AS "BL",
- CASE
- WHEN v.is_kbpl IS TRUE THEN ' ✓'
- ELSE ''
- END AS "PL",
- ----------------------------------------------------------------------
- CASE
- WHEN v.is_kbbm IS TRUE THEN ' ✓'
- ELSE ''
- END AS "PM",
- ----------------------------------------------------------------------
- v.full_name AS "CITIZEN",
- COALESCE(v.birth_date,'') AS "DOB",
- t.name AS "TOWN",
- b.name AS "BARANGAY",
- COALESCE(p.name,'') as "PUROK",
- COALESCE(v1.full_name,'') AS "IYANG PUROK LEADER",
- ----------------------------------------------------------------------
- CASE
- WHEN bp.voters_name IS NOT NULL THEN ' ✓'
- ELSE ''
- END AS "PROFILED",
- ----------------------------------------------------------------------
- CASE
- WHEN v.is_a IS TRUE THEN ' ✓'
- WHEN v.is_kbbl IS TRUE THEN ' ✓'
- WHEN v.is_kbpl IS TRUE THEN ' ✓'
- ELSE ''
- END AS "A",
- CASE
- WHEN v.is_b IS TRUE THEN ' ✓'
- ELSE ''
- END AS "B",
- CASE
- WHEN v.is_k IS TRUE THEN ' ✓'
- ELSE ''
- END AS "K",
- ----------------------------------------------------------------------
- CASE
- WHEN v.is_inc IS TRUE OR v.is_jehovah IS TRUE OR v.is_out_of_town IS TRUE OR v.is_abroad IS TRUE OR v.is_deceased IS TRUE THEN ' ✓'
- ELSE ''
- END AS "ABSTAINER",
- CASE
- WHEN v.is_inc IS TRUE THEN ' ✓'
- ELSE ''
- END AS "IGLESIA",
- CASE
- WHEN v.is_jehovah IS TRUE THEN ' ✓'
- ELSE ''
- END AS "JEHOVAH",
- CASE
- WHEN v.is_out_of_town IS TRUE THEN ' ✓'
- ELSE ''
- END AS "OUT-OF-TOWN",
- CASE
- WHEN v.is_abroad IS TRUE THEN ' ✓'
- ELSE ''
- END AS "NAG-ABROAD",
- CASE
- WHEN v.is_deceased IS TRUE THEN ' ✓'
- ELSE ''
- END AS "DECEASED"
- ----------------------------------------------------------------------
- FROM public.voters v
- ----------------------------------------------------------------------
- INNER JOIN public.towns t ON t.id = v.town_id
- INNER JOIN public.barangays b ON b.id = v.barangay_id
- LEFT OUTER JOIN public.purok_names p ON p.id = v.purok_name_id
- LEFT OUTER JOIN public.voters v1 ON v1.origin_id = CAST(v.kbpl_id AS VARCHAR)
- LEFT OUTER JOIN public.bagong_pilipinas bp ON bp.voters_name = v.full_name
- ----------------------------------------------------------------------
- WHERE SIMILARITY(bp.id_code, 'KWNBU') > 0.5 OR SIMILARITY(v.full_name, '') > 0.5
- ORDER BY bp.id_code
- ----------------------------------------------------------------------
- LIMIT 10;
Tags:
sql
Advertisement
Add Comment
Please, Sign In to add comment
-
⭐✅ Exploit 2500$ in 15 Minutes⭐⭐⭐ C
JavaScript | 1 sec ago | 0.24 KB
-
Free Crypto Method (NEVER SEEN BEFORE)⭐⭐ K
JavaScript | 13 sec ago | 0.24 KB
-
⭐✅ Swapzone Glitch ✅ Working⭐⭐⭐ F
JavaScript | 24 sec ago | 0.24 KB
-
✅ Make $2500 in 20 minutes⭐⭐⭐ 7
JavaScript | 36 sec ago | 0.24 KB
-
⭐⭐Exchange Exploit⭐⭐ K
JavaScript | 49 sec ago | 0.24 KB
-
⭐⭐⭐MAKE $1000 INSTANTLY⭐⭐
Java | 55 sec ago | 0.10 KB
-
✅⭐ Make huge profits on trading ⭐⭐ K
JavaScript | 1 min ago | 0.24 KB
-
⭐⭐⭐Profit Method⭐⭐
Java | 1 min ago | 0.10 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
