Simon Willison’s Weblog

Finding Lookup Items that Are Not Used. How to do left outer joins (and other custom SQL) using the Django ORM.

Posted 13th August 2007 at 5:08 pm

Recent articles

The last six months in LLMs, illustrated by pelicans on bicycles - 6th June 2025
Tips on prompting ChatGPT for UK technology secretary Peter Kyle - 3rd June 2025
How often do LLMs snitch? Recreating Theo's SnitchBench with LLM - 31st May 2025

django 573 orm 40 sql 102 michael-trier 4 python 1155

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe