[411832] Stats and Recent pages do not show Orion in project dropdown
list
diff --git a/html/recent.php b/html/recent.php
index a6acb30..d212d84 100644
--- a/html/recent.php
+++ b/html/recent.php
@@ -8,7 +8,8 @@
  *
  * Contributors:
  *    Eclipse Foundation - Initial API and implementation
- *    Kit Lo (IBM) - patch, bug 261739, Inconsistent use of language names
+ *    Kit Lo (IBM) - [261739] Inconsistent use of language names
+ *    Kit Lo (IBM) - [411832] Stats and Recent pages do not show Orion in project dropdown list
 *******************************************************************************/
 include("global.php");
 
@@ -58,8 +59,13 @@
 $USERID		= getHTTPParameter("userid");
 $SUBMIT 	= getHTTPParameter("submit");
 
-$sql = "SELECT DISTINCT pv.project_id, pv.version FROM project_versions AS pv INNER JOIN map_files as m ON pv.project_id = m.project_id AND pv.version = m.version INNER JOIN project_source_locations as psl ON pv.project_id = psl.project_id AND pv.version = psl.version WHERE pv.is_active ORDER BY pv.project_id ASC, pv.version DESC";
-$rs_p_list = mysql_query($sql, $dbh);
+$sql = "SELECT DISTINCT pv.project_id, pv.version FROM project_versions AS pv INNER JOIN map_files as m ON pv.project_id = m.project_id AND pv.version = m.version WHERE pv.is_active ORDER BY pv.project_id ASC, pv.version DESC";
+$rs_p_list_map_files = mysql_query($sql, $dbh);
+
+$sql = "SELECT DISTINCT pv.project_id, pv.version FROM project_versions AS pv INNER JOIN project_source_locations as psl ON pv.project_id = psl.project_id AND pv.version = psl.version WHERE pv.is_active ORDER BY pv.project_id ASC, pv.version DESC";
+$rs_p_list_project_source_locations = mysql_query($sql, $dbh);
+
+$rs_p_list = $rs_p_list_map_files + $rs_p_list_project_source_locations;
 
 $sql = "SELECT language_id, IF(locale <> '', CONCAT(CONCAT(CONCAT(name, ' ('), locale), ')'), name) as name FROM languages WHERE is_active AND iso_code != 'en' ORDER BY name";
 $rs_l_list = mysql_query($sql, $dbh);
diff --git a/html/stats.php b/html/stats.php
index 3847f51..2d8b611 100644
--- a/html/stats.php
+++ b/html/stats.php
@@ -8,7 +8,8 @@
  *
  * Contributors:
  *    Eclipse Foundation - Initial API and implementation
- *    Kit Lo (IBM) - patch, bug 261739, Inconsistent use of language names
+ *    Kit Lo (IBM) - [261739] Inconsistent use of language names
+ *    Kit Lo (IBM) - [411832] Stats and Recent pages do not show Orion in project dropdown list
 *******************************************************************************/
 include("global.php");
 
@@ -34,8 +35,13 @@
 $LANGUAGE_ID= getHTTPParameter("language_id");
 $SUBMIT 	= getHTTPParameter("submit");
 
-$sql = "SELECT DISTINCT pv.project_id, pv.version FROM project_versions AS pv INNER JOIN map_files as m ON pv.project_id = m.project_id AND pv.version = m.version INNER JOIN project_source_locations as psl ON pv.project_id = psl.project_id AND pv.version = psl.version WHERE pv.is_active ORDER BY pv.project_id ASC, pv.version DESC";
-$rs_p_list = mysql_query($sql, $dbh);
+$sql = "SELECT DISTINCT pv.project_id, pv.version FROM project_versions AS pv INNER JOIN map_files as m ON pv.project_id = m.project_id AND pv.version = m.version WHERE pv.is_active ORDER BY pv.project_id ASC, pv.version DESC";
+$rs_p_list_map_files = mysql_query($sql, $dbh);
+
+$sql = "SELECT DISTINCT pv.project_id, pv.version FROM project_versions AS pv INNER JOIN project_source_locations as psl ON pv.project_id = psl.project_id AND pv.version = psl.version WHERE pv.is_active ORDER BY pv.project_id ASC, pv.version DESC";
+$rs_p_list_project_source_locations = mysql_query($sql, $dbh);
+
+$rs_p_list = $rs_p_list_map_files + $rs_p_list_project_source_locations;
 
 $sql = "SELECT language_id, IF(locale <> '', CONCAT(CONCAT(CONCAT(name, ' ('), locale), ')'), name) as name FROM languages WHERE is_active AND iso_code != 'en' ORDER BY name";
 $rs_l_list = mysql_query($sql, $dbh);