# Embedded SQL request

**URL:** <https://www.ruby-forum.com/t/embedded-sql-request/153549>\
**Category:** Rails\
**Created:** [November 18, 2008, 5:14pm UTC](https://www.ruby-forum.com/t/embedded-sql-request/153549 "2008-11-18T17:14:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vpredoehl](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/67e7ee/32.png) [@vpredoehl](https://www.ruby-forum.com/u/vpredoehl)\
**Post date:** [November 18, 2008, 5:14pm UTC](https://www.ruby-forum.com/t/embedded-sql-request/153549/1 "2008-11-18T17:14:17Z")

</div>

Hello,

I’m trying to create a Rails like embedded request like that (it is  
working, I’m selecting projects ordered by number of contributors) :

SELECT projects.id AS id,  
project\_topic,  
(SELECT count(\*) FROM project\_users WHERE projects.id =  
project\_users.project\_id) AS contributors  
FROM projects  
ORDER BY contributors DESC

I didn’t find any resource to create it in a Rails way :  
Projects.find(…, :order =\> ‘contributors’) and do a sub-request  
somewhere.

Is there anyone who could give me some links or help?

Thanks !  
Vincent