SELECT user.*, order.*, SUM((order_album.price)*order_album.quantity) AS price
FROM order_album
LEFT JOIN order ON order_album.order_id = order.id
LEFT JOIN user ON order.user_id = user.id
GROUP BY order_album.order_id
ORDER BY order.id DESC
i have this :
User $table='user'; $has_many = array('order');
Order var $table = 'order'; var $has_one = array('user'); var $has_many = array('order_album');
Order_album var $table = 'order_album'; var $has_one = array('order');
Code:
$obj = new Order_album();
$obj->include_related('order', '*');
//$obj->include_related('user', '*'); // this join order_album with user, i need order with user
$obj->select('price * quantity AS price');
$obj->group_by('order_id');
$obj->order_by('order.id', 'DESC');
$obj->get();
this works
but i dont know how i join (in this "query") order.user_id with user.id - and dont order_album with user ...