SELECT a.*, f.name as floor, t.name as type, s.name as state FROM iweb_appartments_rooms a 
JOIN iweb_appartments_states s ON s.id = a.id_iweb_appartments_states 
JOIN iweb_appartments_types t ON t.id = a.id_iweb_appartments_types 
JOIN iweb_appartments_floors f ON f.id = a.id_iweb_appartments_floors 