# Trouble finding the right records

**URL:** <https://www.ruby-forum.com/t/trouble-finding-the-right-records/139593>\
**Category:** Rails\
**Created:** [June 5, 2008, 9:27am UTC](https://www.ruby-forum.com/t/trouble-finding-the-right-records/139593 "2008-06-05T09:27:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![harryvermeulen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/eb9ed0/32.png) [@harryvermeulen](https://www.ruby-forum.com/u/harryvermeulen)\
**Post date:** [June 5, 2008, 9:27am UTC](https://www.ruby-forum.com/t/trouble-finding-the-right-records/139593/1 "2008-06-05T09:27:01Z")

</div>

Hello, I’m creating a multilingual blog, where a translator would  
translate single posts into several languages. I’m having some trouble  
searching and comparing records.

My database is set up like this:  
Posts: id, body, original\_id, language\_id  
Languages: id, name

A single post, translated into several languages is grouped by the  
number in ‘original\_id’, like this:

[http://www.harryvermeulen.nl/database.jpg](http://www.harryvermeulen.nl/database.jpg)

I’m looking for a way to find all the posts in (for example) english,  
that do not have a translation in (for example) japanese yet.

I hope I’m making sense. I’m fairly new at web development, I hope I’m  
in the right place to ask this question.

Kind regards,  
Harry