Showing data from multiple related tables

Using Rails 2.3.8. I wanna show data from complicated relationship.

These are in my models:

shop.rb

has_many :city_shops

id | name 
3  | Good Cafe

city_shop.rb

belongs_to :city
belongs_to :shop

id | city_id | shop_id | notes
2  |    4    |    3    | Delicious food in Paris

city.rb

belongs_to :article
has_many :city_shops
has_many :shops, :through => :city_shops

id | article_id
4  |    5

article.rb

has_many :shops, :through => :shop_articles
has_many :cities, :dependent => :destroy

id | user_id | name
5  |    6    | Favorite shops in France

user.rb

has_many :articles

id | login
6  | victor

The scenario is this (may not be logical): A user with ID 6 creates many articles. Let's say he creates this article called Favorite shops in France. In this article, there are c开发者_JAVA百科ities. In each city, there are city_shops where in it there are details shop and notes from city_shops.

I also have individual shop page. I want the visitors to know what notes have been left by users, where the note is and the link to that user's article.

In the shop page, it should read:

Notes by users "Delicious food in Paris" by "victor", shared in "link to favorite shops in France".

I hope this question is clearer than previous. Thank you very much.

Notes by users:<br />
<% @shop.city_shops.each do |city_shop| %>
  "<%= city_shop.notes %>" by "<%= city_shop.city.article.user.login%>", shared in <%= link_to city_shop.city.article.name, "#{url}" %><br />
<% end >

You have to provide the url in the link and you have to add this also to your Article model:

belongs_to :user

<% @shop.city_shops.each do |city_shop| %>
   city_shops notes: <%= city_shop.notes %>
   users: <%= city_shop.city.country.user.username %>
   country_id: <%= city_shop.city.country_id %>
<% end %> 

There is something strange with your models.