A. INNER JOIN                                O01=2
B. LEFT JOIN, conditions in WHERE            O01=2
C. LEFT JOIN, COUNT(*)                       O01=2  O02=1  O03=1
D. LEFT JOIN, conditions in ON, COUNT(b.id)  O01=2  O02=0  O03=0
