diff options
| author | Greg Roach <fisharebest@gmail.com> | 2014-03-12 21:59:48 +0000 |
|---|---|---|
| committer | Greg Roach <fisharebest@gmail.com> | 2014-03-12 22:00:07 +0000 |
| commit | f2c9be7922a0bb5f4315cc137c7f02d2eb94975c (patch) | |
| tree | 3c0a1d4a19f73a37e0a73b7de9472628bf862be2 | |
| parent | ea8c08f50405ae76808bf12413ef698f6ded84b5 (diff) | |
| download | webtrees-f2c9be7922a0bb5f4315cc137c7f02d2eb94975c.tar.gz webtrees-f2c9be7922a0bb5f4315cc137c7f02d2eb94975c.tar.bz2 webtrees-f2c9be7922a0bb5f4315cc137c7f02d2eb94975c.zip | |
Stats - marriage age by sex does not show females. Fix by wooc
| -rw-r--r-- | library/WT/Stats.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/library/WT/Stats.php b/library/WT/Stats.php index 4b2eba17d1..1f9d83f745 100644 --- a/library/WT/Stats.php +++ b/library/WT/Stats.php @@ -2386,9 +2386,9 @@ class WT_Stats { " married.d_julianday1>birth.d_julianday1 AND birth.d_julianday1<>0 ". "UNION ALL ". "SELECT ". - " ROUND(AVG(married.d_julianday2-birth.d_julianday1-182.5)/365.25,1) AS age, ". - " FLOOR(married.d_year/100+1) AS century, ". - " 'F' AS sex ". + " fam.f_id, ". + " birth.d_gid, ". + " married.d_julianday2-birth.d_julianday1 AS age ". "FROM `##dates` AS married ". "JOIN `##families` AS fam ON (married.d_gid=fam.f_id AND married.d_file=fam.f_file) ". "JOIN `##dates` AS birth ON (birth.d_gid=fam.f_wife AND birth.d_file=fam.f_file) ". |