diff options
| author | Greg Roach <fisharebest@gmail.com> | 2013-08-25 11:51:05 +0100 |
|---|---|---|
| committer | Greg Roach <fisharebest@gmail.com> | 2013-08-25 11:51:05 +0100 |
| commit | 3de56c0ee5e7d0b74e10645c887f319cda363ee5 (patch) | |
| tree | 88395fc7f3763403281ff623e6209500baa3825f /library/WT/Stats.php | |
| parent | b8e620d8b2a7047970e7346ae44e426683c6fab9 (diff) | |
| download | webtrees-3de56c0ee5e7d0b74e10645c887f319cda363ee5.tar.gz webtrees-3de56c0ee5e7d0b74e10645c887f319cda363ee5.tar.bz2 webtrees-3de56c0ee5e7d0b74e10645c887f319cda363ee5.zip | |
Remove unnecessary LEFT JOIN
Diffstat (limited to 'library/WT/Stats.php')
| -rw-r--r-- | library/WT/Stats.php | 16 |
1 files changed, 7 insertions, 9 deletions
diff --git a/library/WT/Stats.php b/library/WT/Stats.php index 84e3a3e32e..6e0cfaf67a 100644 --- a/library/WT/Stats.php +++ b/library/WT/Stats.php @@ -2838,15 +2838,13 @@ class WT_Stats { $sizes = explode('x', $size); $max = 0; $rows=self::_runSQL( - " SELECT SQL_CACHE ROUND(AVG(f_numchil),2) AS num, FLOOR(married.d_year/100+1) AS century". - " FROM `##families` AS fam". - " LEFT JOIN `##dates` AS married ON married.d_file = {$this->_ged_id}". - " WHERE". - " married.d_gid = fam.f_id AND". - " fam.f_file = {$this->_ged_id} AND". - " d_julianday1<>0 AND". - " married.d_fact = 'MARR' AND". - " married.d_type IN ('@#DGREGORIAN@', '@#DJULIAN@')". + " SELECT SQL_CACHE ROUND(AVG(f_numchil),2) AS num, FLOOR(d_year/100+1) AS century". + " FROM `##families`". + " JOIN `##dates` ON (d_file = f_file AND d_gid=f_gid)". + " WHERE f_file = {$this->_ged_id}". + " AND d_julianday1<>0". + " AND d_fact = 'MARR'". + " AND d_type IN ('@#DGREGORIAN@', '@#DJULIAN@')". " GROUP BY century". " ORDER BY century"); if (empty($rows)) return ''; |