Drupal db select IN, group by count need a bit of help please, when i write my query like this it works fine

    $query = db_query('select * from form_submissions where address in (select address from form_submissions group by address having count(address) &gt; 1 ');
    $submissions = $query-&gt;execute();


but when i write it with drupal it should work like this? but it dont

    $query = db_select('form_submissions', 'sfs')-&gt;fields('sfs', array());
    $subquery = db_select('form_submissions', '')-&gt;fields('address', array())-&gt;groupBy('address')-&gt;having('count(address) &gt; 1');
    $query-&gt;condition('address', $subquery, 'in');

    $submissions = $query-&gt;execute();


can someone see what im doing wrong?
$query = db_select('form_submissions', 'sfs')-&gt;fields('sfs', array());
    $subquery = db_select('form_submissions', 'sfs')-&gt;fields('sfs', array('address'))-&gt;groupBy('address')-&gt;having('count(address) &gt; 1');
    $query-&gt;condition('address', $subquery, 'in');

    $submissions = $query-&gt;execute();