(SELECT * FROM t_unitati AS u INNER JOIN t_statiuni AS s ON u.u_s_id=s.s_id INNER JOIN t_unitati_tipuri AS ut ON u.u_ut_id=ut.ut_id inner join t_zone z on s.s_z_id=z.z_id WHERE u_keyword='sara-campus-lake-view-apartament-17-mamaia' AND s_keyword='mamaia' and z.z_tara=1)