I have written SQL:

SELECT title, COUNT( cf.rid )
FROM `l10n_community_release` cr
LEFT JOIN `l10n_community_file` cf ON cr.rid = cf.rid
LEFT JOIN `l10n_community_line` cl ON cf.fid = cl.fid
WHERE cr.pid =1
GROUP BY title
/*  A string per release. cr.pid =1 (Drupal) */

Result:

title 	COUNT( cf.rid )
5.3 	3441
5.4 	3442
5.5 	20412
6.0-beta1 	4035
6.0-beta2 	43666
6.0-beta3 	35577
6.0-beta4 	26640
6.0-rc1 	13790

Where errors?
1) Potx (potx.info,v 1.1.2.4 2007/11/12 20:17:18)
2) In the my SQL SELECT
3) In the my DataBase
4) ?

Comments

meba’s picture

meba commented
Category: bug » support

What is your problem? I don't get it...

pvasili’s picture

pvasili commented

Very different quantity of lines in different versions of the project :(

psicomante’s picture

psicomante commented
Title: Where a error? » Deep Differences of lines in different versions of the project

Title changed.

pvasili’s picture

pvasili commented

I have cleared all old files and 4 tables (http://drupal.org/node/203658). Has made full re-scan. The problem is closed.
Probably it is a problem of the old versions.
Now:

title 	COUNT( cf.rid )
5.5 	3442
5.6 	3448
6.0-rc1 	4642
6.0-rc2 	4690

I shall look statistics further :).

pvasili’s picture

pvasili commented
Status: Postponed (maintainer needs more info) » Closed (fixed)