SELECT year(date_of_reg) as jyear,pdate as date1,year as year1,setdefault,url,regtype,id as userid,first_name,last_name,image,facebook,instagram,twitter,youtube,awardee,nationalwinner,status,statewinner,citywinner,ptitle1,ptitle2,ptitle from registration where (status=1 or status=3) and verification=1 and suspended=0 and completion >=75 and regtype='9' order by rand() desc LIMIT 0,20