FuelPHP Forums

it would be better when ORDER in own find be on end of query ?
bacause with relation with wheres isnt sorting correctly (i think) example from eshop

$return = Model_Products::find('all', array(
                    'related' => array(
                        'categories',
                        'marks',
                        'variants' => array(
                            'where' => array(
                                array( 'variants.active', 1 ),
                            ),
                            //'order_by' => array( 't0.id' => 'desc' )
                         )
                    ),
                    'where' => array(
                        array( 'active', '=', 1 ),
                        array( 'category_id', 'IN', Model_Products::categories_in($category_id) ),
                    ),
                    'limit' => $limit,
                    'offset' => $offset,
                    'order_by' => array( 'id' => 'desc' )
                ));

i need sort product from newest but in this case dont work (because order is in subselect - this is right for related queries)
(i must hack it with //commented line) IDEA - order by in main find = main table will be on end of query and sorting will be ok - i think in all cases
I think it would not be a problem of any case where the order at the end what we think about it ? //sry for bad english