Conider this simple query:

```
$this->db->join('bids','bids.bid_for = request_quote.quoteid','left');

```

Is there any way possible to alter it, so instead of joining the result, it would instead join the COUNT of all bids it find?

I could rewrite this in plain SQL, but it is a part of bigger query, which I dont want to rewrite in SQL