MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tbl_status (
  id_status int(1) NOT NULL,
  description varchar(80)
  ,PRIMARY KEY (id_status)
);

CREATE TABLE tbl_test (
  id_test int(10),
  test varchar(80),
  id_type int(11),
  id_status int(1),
  year int(11)
);
insert  into tbl_status(id_status,description) values (1,'status1'),(2,'status2');


insert  into tbl_test(id_test,test,id_type,id_status,year) values (1,'dddd',1,1,2019);
SELECT 
            IFNULL(MAX(a.test), 0),
	    IFNULL(b.description,'')
FROM
	tbl_test a 
        JOIN tbl_status b USING(id_status)	
WHERE 	
        a.id_type='1'
	AND a.id_status = 2
	AND a.year = YEAR(NOW())	
	


IFNULL(MAX(a.test), 0)
IFNULL(b.description,'')


0