' GROUP BY a.artifact_id) x, artifact a, users WHERE a.artifact_id=x.artifact_id AND users.user_id=a.submitted_by ORDER BY group_artifact_id ASC, rank DESC, a.artifact_id ASC') ;
}
} else {
- if ($sys_database_type == "mysql") {
- $qpa = db_construct_qpa ($qpa,
- 'SELECT DISTINCT a.group_artifact_id,a.artifact_id,a.summary,a.open_date,users.realname ') ;
- } else {
- $qpa = db_construct_qpa ($qpa,
- 'SELECT DISTINCT ON (a.group_artifact_id,a.artifact_id) a.group_artifact_id,a.artifact_id,a.summary,a.open_date,users.realname ') ;
- }
+ $qpa = db_construct_qpa ($qpa,
+ 'SELECT DISTINCT ON (a.group_artifact_id,a.artifact_id) a.group_artifact_id,a.artifact_id,a.summary,a.open_date,users.realname ') ;
$qpa = db_construct_qpa ($qpa,
'FROM artifact a LEFT OUTER JOIN artifact_message am USING (artifact_id), users WHERE a.group_artifact_id=$1 AND users.user_id=a.submitted_by AND ((',
array ($this->artifactId)) ;
$qpa = db_construct_qpa () ;
- if ($sys_database_type == "mysql") {
- $qpa = db_construct_qpa ($qpa,
- 'SELECT DISTINCT a.group_artifact_id, a.artifact_id') ;
- } else {
- $qpa = db_construct_qpa ($qpa,
- 'SELECT DISTINCT ON (a.group_artifact_id,a.artifact_id) a.group_artifact_id, a.artifact_id') ;
- }
+ $qpa = db_construct_qpa ($qpa,
+ 'SELECT DISTINCT ON (a.group_artifact_id,a.artifact_id) a.group_artifact_id, a.artifact_id') ;
$qpa = db_construct_qpa ($qpa,
' FROM artifact a WHERE a.group_artifact_id=$1 AND a.artifact_id=$2',
array ($this->artifactId,