summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGreg Roach <fisharebest@webtrees.net>2019-03-03 19:17:07 +0000
committerGreg Roach <fisharebest@webtrees.net>2019-03-03 19:17:07 +0000
commit8305ac84b7e3866af1e1db4853682c1788001c88 (patch)
tree296ea1565b0927d3794af947570206cd25fb36b3
parent25e6882f384fba8dfce6d347d3fbd3f1d24e8cff (diff)
downloadwebtrees-8305ac84b7e3866af1e1db4853682c1788001c88.tar.gz
webtrees-8305ac84b7e3866af1e1db4853682c1788001c88.tar.bz2
webtrees-8305ac84b7e3866af1e1db4853682c1788001c88.zip
Revert "#2296 - improve performance of first-marriage-month query"
This reverts commit 25e6882f384fba8dfce6d347d3fbd3f1d24e8cff.
-rw-r--r--app/Statistics/Repository/FamilyRepository.php5
1 files changed, 4 insertions, 1 deletions
diff --git a/app/Statistics/Repository/FamilyRepository.php b/app/Statistics/Repository/FamilyRepository.php
index dc17e979d3..0893bc5fec 100644
--- a/app/Statistics/Repository/FamilyRepository.php
+++ b/app/Statistics/Repository/FamilyRepository.php
@@ -1698,7 +1698,10 @@ class FamilyRepository
}
return $query
- ->select(['f_id AS fams', 'f_husb', 'f_wife', 'd_julianday2 AS age', 'd_month AS month', 'i_id AS indi']);
+ ->select(['f_id AS fams', 'f_husb', 'f_wife', 'd_julianday2 AS age', 'd_month AS month', 'i_id AS indi'])
+ ->orderBy('f_id')
+ ->orderBy('i_id')
+ ->orderBy('d_julianday2');
}
/**