univ_getdegrees MySQL ERROR: Column 'degreeid' in where clause is ambiguous
univ_getdegrees SQL:
                SELECT DISTINCT
                        '' as cipcode
                        , ud.degreeid
                        , ud.deglev as 'degreelevel'
                        , concat(ui.name,'
',udl.`dldesc`,'
',ud.`degname`, if(length(ud.degspec)>0,concat('
', ud.degspec),'')) as 'name'
                        , udd.name as 'title'
                        , ud.degdesc as 'descr'
                        , ud.degspec
                        , ud.instuid
                        , degwebaddr
                        , ud.`numdegs`
                        , ud.`acadyr`
                        , ui.name as 'instnm'
                        , ui.state as 'stabbr'
                        , ude.`altname`
                        , ui.`param00`
                        , ud.`degname`
                        , udl.`dldesc`
                        , ud.fk_productid as 'productid'
                        , ude.`datatype`
                        , substring_index(ude.`datatype`,'.',1) as 'schtyp'
                        , if(ISNULL(ud.`deldate`),'Y','N') as 'forsale'
                        , 'univ' as 'sourcetables'
                        , false as clientschool
                        , ude.image_x
                        , ude.image_y
                        , ud.prghrs
                        , isdistlearn
                        , udd.programid
                        , ude.altname
                        , ud.deguid
                        , false as descgeneric
                        , 0 as orderby
        
                FROM
                        univ_degrees ud INNER JOIN `univ_degrees_edited` ue ON ud.instuid = ue.instuid LEFT JOIN `univ_degreeLevels` udl ON ud.deglev = udl.dlid
                LEFT JOIN `univ_degree_desc` udd ON udd.`degreeid` = ud.`degreeid`
                LEFT JOIN `univ_degreesext` ude ON ude.`deguid` = ud.`deguid`
                INNER JOIN `univ_institutes` ui ON ui.`instuid` = ud.`instuid`
                INNER JOIN `univ_categories_dynamic` uc ON uc.`deguid` = ud.`deguid`         WHERE 1 AND ui.instuid = 169248 AND (degreeid = 2146) AND ud.deglev = '5' AND ISNULL(ud.`deldate`) ORDER BY ud.deglev, ui.name, udl.`dldesc`, ud.`degname`

---