gistfile1.txt

sqlite> select count(1) as t, a.raw as c, b.myclean as d from exif a, exif b where a.id=b.id and a.tag='Model' and b.tag in ('Focal Length') group by c, d order by t desc limit 10;
973|Canon DIGITAL IXUS 30|5.8 mm
664|Canon DIGITAL IXUS 65|5.8 mm
627|Canon EOS 350D DIGITAL|105 mm
317|Canon EOS 400D DIGITAL|60 mm
198|Canon EOS 350D DIGITAL|55 mm
191|Canon DIGITAL IXUS 30|17.4 mm
181|Canon EOS 400D DIGITAL|105 mm
137|Canon EOS 400D DIGITAL|24 mm
134|Canon EOS 300D DIGITAL|55 mm
123|Canon EOS 300D DIGITAL|50 mm

sqlite> select count(1) as t, a.raw as c, b.myclean as d from exif a, exif b where a.id=b.id and a.tag='Model' and b.tag in ('Aperture') group by c, d order by t desc limit 10;
746|Canon DIGITAL IXUS 30|f/2.8
651|Canon EOS 350D DIGITAL|f/8.0
615|Canon DIGITAL IXUS 65|f/2.8
442|K800i|f/2.8
242|Canon EOS 400D DIGITAL|f/5.6
235|Canon EOS 350D DIGITAL|f/5.6
227|Canon DIGITAL IXUS 30|f/5.6
218|Canon EOS 400D DIGITAL|f/2.8
203|Canon EOS 300D DIGITAL|f/8.0
189|Canon EOS 350D DIGITAL|f/2.8

sqlite> select count(1) as t, a.raw as c, b.myclean as d from exif a, exif b where a.id=b.id and a.tag='Model' and b.tag in ('Exposure') group by c, d order by t desc limit 10;
298|Canon EOS 350D DIGITAL|0.005 sec (1/200)
250|Canon DIGITAL IXUS 30|0.017 sec (1/60)
190|BlackBerry 8900|
180|Canon DIGITAL IXUS 65|0.017 sec (1/60)
111|Canon EOS 350D DIGITAL|0.004 sec (1/250)
110|Canon DIGITAL IXUS 65|0.001 sec (1/1500)
100|Canon EOS 350D DIGITAL|0.006 sec (1/180)
94|Canon EOS 350D DIGITAL|0.002 sec (1/500)
91|Canon EOS 350D DIGITAL|0.008 sec (1/125)
83|Canon DIGITAL IXUS 30|0.003 sec (1/400)