Ar One-To-Many Order By

[alarcl]

Hi,

i describe what i have and what want to receive here (cant paste link so paste all text):

CREATE TABLE tbl_Order (id INT, info VARCHAR(200));

CREATE TABLE tbl_OrderStatus (

id INT AUTO_INCREMENT

order_id INT,

STATUS INT,

update_time INT

);

INSERT INTO tbl_Order(id) VALUES (1, ‘info1’);

INSERT INTO tbl_Order(id) VALUES (2, ‘info2’);

INSERT INTO tbl_OrderStatus(order_id,update_time) VALUES (1,100);

INSERT INTO tbl_OrderStatus(order_id,update_time) VALUES (1,200);

INSERT INTO tbl_OrderStatus(order_id,update_time) VALUES (2,300);

INSERT INTO tbl_OrderStatus(order_id,update_time) VALUES (2,400);

INSERT INTO tbl_OrderStatus(order_id,update_time) VALUES (1,500);

INSERT INTO tbl_OrderStatus(order_id,update_time) VALUES (2,600);

// what i need IN RESULT (ONLY 2 ROWS !!!!!ordered BY update_time!!!!!):

id, info, update_time

---

2, info2, 600

1, info1, 500

i need this for my order/index.

now i receive this data via such SQL:

SELECT o.id, o.info, oh_status.update_time

FROM

  tbl_order o

  INNER JOIN

  (

    SELECT order_id,update_time  FROM tbl_order_status WHERE (order_id,update_time) IN

    (SELECT order_id, MAX(update_time) max_update_time FROM tbl_order_status GROUP BY order_id)

  ) oh_status

  ON (o.id = oh_status.order_id)

order by oh_status.update_time desc

i want to know how make this via AR ?

i start learn yii and start work with AR and it is looks very nice when work with one table, but complicated when try to work with two or more tables.

[alarcl]

i learn yii2 AR, but think nobody now can answer about yii2 AR, so ask here and if receive answer will try find equivalent in yii2. ty.