cameras.txt

sqlite> select substr('     '||count(1),-5,5) as c, coalesce(value, '-No Exif-') as x from photos e1 left outer join exif e2 on e1.id=e2.id where e2.tag='Model' or e2.tag is null group by x order by 0+c desc ;

 1382 Canon EOS 350D DIGITAL
 1328 Canon DIGITAL IXUS 30
  953 -No Exif-
  911 Canon DIGITAL IXUS 65
  831 Canon EOS 400D DIGITAL
  590 Canon EOS 300D DIGITAL
  442 K800i
  190 BlackBerry 8900
  151 K850i
  133 CYBERSHOT
  114 EOS 400D DIGITAL
   61 W800i
   11 PENTAX Optio SVi
   10 NIKON D40
    7 DX-10
    2 C830L,D340R
    2 EOS 300D DIGITAL
    1 FinePixA201
    1 KODAK DX4900 ZOOM DIGITAL CAMERA
    1 Kodak CLAS Digital Film Scanner / HR200