Endpoint · otherGETsaylorinnovations.com /api/kb/sql-joins-pitfalls-left-join-where-fanout-anti-join-not-in-null
SQL join bugs - WHERE after LEFT JOIN drops rows, count(*) vs count(col), fan-out inflates sums, NOT IN with NULL, safe anti-joins
Overview
Grade?
UNRATED
0 of 30 paid calls toward a letter
Price
$0.01 per call
Paid calls
none yet
delivery unknown until someone pays
More info
Seller?
URL
https://saylorinnovations.com/api/kb/sql-joins-pitfalls-left-join-where-fanout-anti-join-not-in-null
MCP server on this host: com.saylorinnovations/data
Seen
first 28 days ago · last 20 days ago
17 free handshakes
Payment
Pays through
x402
Offered on?
Polygon, Arbitrum, Base USDC, Solana
Listed on?
Polygon, Arbitrum, Base, Solana
Score, from free handshakes onlyweights 2026.09.6
UN
RATED
RATED
0.279 liveness verified, no letter
To a letter · 30 paid calls
0 of 30
Held down by liveness · gap to 1.000 is 0.721: 0.231 uncertain ? + 0.491 short ? · 0.171 to D
| Component | Weight | Measured | Lower bound ? | Adds | Short ? | Uncertain ? | |
|---|---|---|---|---|---|---|---|
| livenesscosts the most it answered at all |
0.60 | 0.50 | 0.131 | 0.079 | −0.301 | −0.220 | |
| latency p95 it answered as fast as its class |
0.20 | 0.05 | 0.000 | 0.000 | −0.189 | −0.011 | |
| price stability the price stayed where it was listed |
0.20 | 1.00 | 1.000 | 0.200 | 0 | 0 | |
| Composite | 1.00 | 0.279 | gap to 1.000 = 0.721 · 0.491 short · 0.231 uncertain | 0.279 | −0.491 | −0.231 |
Not measured: correctness · nobody paid; honesty · nobody paid; schema conformance · no answer had a published shape to check
The multiplication, written out
0.600 × 0.131 liveness
+ 0.200 × 0.000 latency p95
+ 0.200 × 1.000 price stability
= 0.279 → UNRATED: 17 of 30 paid calls weights 2026.09.6 · 17 samples · seed cap_01M5EFT2W9S5XDGFGSBFWPCX50|2026-10-06T22:56:46.777Z|2026.09.6
Verify it yourself
npx teppi-check https://saylorinnovations.com/api/kb/sql-joins-pitfalls-left-join-where-fanout-anti-join-not-in-nullcurl -s https://api.teppi.xyz/v1/trust/cap_01M5EFT2W9S5XDGFGSBFWPCX50