SELECT sf.id AS id_flat, sf.id_bud,sf.code AS num_apart,sb.name AS name_bud,sf.meters,
                    sb.floors_no ,sf.rooms ,sf.price ,sf.status ,srt.id,srt.name,srt.slug
                    FROM jn7g_buildings AS sb
                    LEFT JOIN jn7g_flats AS sf ON
                    sb.id = sf.id_bud
                    LEFT JOIN 	jn7g_room_type AS srt on
                    srt.id = sf.type_id 
                    WHERE sb.id_inv = 46
                    AND sf.id_bud NOT LIKE  306 
                    AND sf.status != 0  ORDER BY sf.meters
                LIMIT 45, 15