') AS previousProduct FROM ".DBGOCPD.".ReportAnnotCPDOldNew LEFT JOIN Genomic_Object G2 ON GO_id_old=G2.GO_ori_id AND G2.GO_update='current' LEFT JOIN Genomic_Object G1 ON GO_id_new=G1.GO_ori_id AND G1.GO_update='current' WHERE CPD_pbm = 'multiple_hit' AND S_id_new=$Sid AND Stop_coord is NULL GROUP BY GO_id_new, G1.GO_id "; } # #8877: modified for ONLY_FULL_GROUP_BY; add issue_type in group by if ($sqlName == "getCPDOldNewcreated") { $sql = "SELECT GROUP_CONCAT( GO_id_old order by GO_id_old) AS listGO_id_old, GROUP_CONCAT(G2.GO_label order by G2.GO_ori_id) AS listInfoGO_labelCPD2, if(CPD_pbm='multiple_hit','Same object','Overlap') AS issue_type, Stop_coord FROM ".DBGOCPD.".ReportAnnotCPDOldNew LEFT JOIN Genomic_Object G2 ON GO_id_old=G2.GO_ori_id AND G2.GO_update='current' WHERE S_id_new=$Sid AND GO_id_new is NULL AND Stop_coord is not NULL GROUP BY Stop_coord,issue_type"; } if ($sqlName == "getCPDOldtoofragmented") { $sql = "SELECT S_id_new, S_id_old, GO_id_old, G2.GO_label as InfoGO_labelCPD2, CONCAT(G2.GO_evidence,'/',G2.GO_status) AS Evidence_previous, G2.GO_product AS previousProduct FROM ".DBGOCPD.".ReportAnnotCPDOldNew LEFT JOIN Genomic_Object G2 ON GO_id_old=G2.GO_ori_id AND G2.GO_update='current' LEFT JOIN Genomic_Object G1 ON GO_id_new=G1.GO_ori_id AND G1.GO_update='current' WHERE CPD_pbm = 'area too fragmented' AND S_id_new=$Sid "; } if ($sqlName == "Version") { $sql = "SELECT AS_version, SUBSTRING(WF_date, 1, 10) as WF_date, WF_version FROM Sid_update WHERE S_id_new=$Sid LIMIT 1"; } return(commonSwitchSQL($sqlName,$sql)); } ?>