← Back to branch summary

~dpm/lp-get-ul10nstats/distro-support

« back to all changes in this revision

Viewing changes to lp-get-ul10nstats.py

  • Committer: David Planella
  • Date: 2015-02-02 12:46:40 UTC
  • Revision ID: david.planella@ubuntu.com-20150202124640-6b96lze3n3fefyyj
Fixed issue with 'missing FROM-clause entry for table distribution'

Show diffs side-by-side

added added

removed removed

Lines of Context:
lp-get-ul10nstats.py
65
65
    potemplate.messagecount AS total
66
66
  from potemplate
67
67
  join sourcepackagename on sourcepackagename=sourcepackagename.id
68
 
  join distroseries on distroseries=distroseries.id
 
68
  join distribution on distroseries.distribution=distribution.id
69
69
  join pofile on pofile.potemplate=potemplate.id
70
70
  join language on pofile.language=language.id
71
71
  where
72
72
    (potemplate.iscurrent or sourcepackagename.name='openoffice.org') and
73
73
    distribution.name='{0}' and
74
 
    distroseries.distribution=distribution.id and
75
74
    distroseries.name='{1}'
76
75
  order by language.code,
77
76
           sourcepackagename.name,
90
89
    potemplate.date_last_updated
91
90
  from potemplate
92
91
  join sourcepackagename on sourcepackagename=sourcepackagename.id
93
 
  join distroseries on distroseries=distroseries.id
 
92
  join distribution on distroseries.distribution=distribution.id
94
93
  where
95
94
    distribution.name='{0}' and
96
 
    distroseries.distribution=distribution.id and
97
95
    distroseries.name='{1}'
98
96
  order by sourcepackagename.name,
99
97
           potemplate.name;'''