FuelPHP Forums

Hi guys, This is quite tough to explain so I'll try as best I can. Given the following code:

$tweets = Model_Tweet::find()->related( "buckets", array( 'where' => array( 'id' => $id ) ) ->order_by( 'tweet_datetime', 'desc' )->limit( $this->limit )->offset( $this->offset )->get();

I was expecting to get back 20 Tweets which belonged to Bucket 2. The problem is, the results I'm getting back are varied and after following through the SQL generation, it seems that specifying an Offset and a Limit is causing the problem. In this example, my offset was 0 and limit was 20 but if I removed that, I got the expected data back which was 37 Tweets which belonged to Bucket 2. It seems that specifying an offset/limit tells the ORM to use a subquery, which seems to be the problem. This is the SQL thats generated, as you can see, it does a subquery for the sole purpose of adding a limit and offset but that's not what I intended. This is the SQL I was hoping for, just simply appending a Limit and Offset to the end of the query. I'm not sure if this is a bug or something wrong with my implementation but I appreciate any guidance/help. For now, I'm just using the amended query with the Query Builder class to get the results I need.