#length of UPC fields. Disc ID's are 18
select length(upc), count(*) from DVDPROFILER_dvd group by length(upc);
select formataspectratio, count(*) from DVDPROFILER_dvd group by formataspectratio;
select title from DVDPROFILER_dvd where formatletterbox = 0 and format16x9 = 1;
select title,formataspectratio from DVDPROFILER_dvd where formatletterbox = 0 and formataspectratio != '1.33' and formataspectratio != '';
select substr(title,1,40),fullname,role from DVDPROFILER_dvd x,DVDPROFILER_dvd_actor a where x.id=a.id and role like '%(as %' order by sorttitle;
