So far I've got this:

```
SELECT connections.id,
       connections.word_id,
       connections.order_id,
       connections.top,
       connections.deleted,
       (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(connections.modified)) AS modified_ago,
       words_en.word,
       (CASE WHEN words_en.user_id = 1 THEN "You" ELSE words_en.user_id END) AS created_by
FROM connections, words_en
WHERE connections.word_id = words_en.id AND connections.user_id = 1
ORDER BY connections.order_id

```

I want to add few things, but I can't get syntax correct.

1. `(CASE WHEN words_en.user_id = 1 THEN "You" ELSE words_en.user_id END)` here, when ELSE, instead of ID i'd like to get `name_surname` column of this user from users table. So I need to do another join? But since it is within case, how would I do that?
2. `connections.word_id` from the SELECT. besides ID, I also want to know how many times this word\_id is present in connections table. But excluding current user from the list.

I hope explanation was clear enough.