demo_mysql_left_join.py:
➜ begtut>python demo_mysql_left_join.py
('John', 'Chocolate Heaven')
('Peter', 'Chocolate Heaven')
('Amy', 'Tasty Lemon')
('Hannah', None)
('Michael', None)