diff options
| author | Jonathan Prykop <jonathan@freeside.biz> | 2015-01-29 20:38:23 -0600 |
|---|---|---|
| committer | Jonathan Prykop <jonathan@freeside.biz> | 2015-01-30 22:13:17 -0600 |
| commit | e52c755594893c7998def6b930e715bf19021ff5 (patch) | |
| tree | ec6c3108f2a724a54618cfc4e40950b4b20fc9e2 /httemplate/browse | |
| parent | 25815dac9892ef0c4fe020ecd6229bd112bb5954 (diff) | |
RT#15413 (Duplicate rating prefixes)
Diffstat (limited to 'httemplate/browse')
| -rw-r--r-- | httemplate/browse/rate_region.html | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/httemplate/browse/rate_region.html b/httemplate/browse/rate_region.html index 962841d91..bbe213693 100644 --- a/httemplate/browse/rate_region.html +++ b/httemplate/browse/rate_region.html @@ -40,7 +40,7 @@ if ( driver_name =~ /^Pg/ ) { " THEN npa ". " ELSE npa || '-' || nxx ". " END"; - my $prefixes_sql = "SELECT $prefix_sql $fromwhere AND npa IS NOT NULL"; + my $prefixes_sql = "SELECT $prefix_sql $fromwhere AND npa IS NOT NULL ORDER BY npa"; $select .= "( SELECT '+'||countrycode $fromwhere LIMIT 1 ) AS ccode, ARRAY_TO_STRING( ARRAY($prefixes_sql), ', ' ) AS prefixes"; } elsif ( driver_name =~ /^mysql/i ) { |