Помогите пожалуйста, как используя Объект Query составить ORM подзапрос с JOIN типо такого:
SEL ECT i_reviews.ID, services_tb.ID as servcie_id, services_tb.NAME, services_tb.REVIEWS_CNT, services_tb.AVG_MARKfrom i_reviews
LEFT JOIN (
SELECT i_stores.ID, i_stores.NAME, count(i_reviews.ID) as REVIEWS_CNT, avg(i_reviews.MARK) as AVG_MARK
FR OM i_stores
LEFT JOIN i_reviews ON i_reviews.STORE_ID = i_stores.ID
GROUP BY i_stores.ID
) services_tb ON i_reviews.STORE_ID = services_tb.ID
SEL ECT i_reviews.ID, services_tb.ID as servcie_id, services_tb.NAME, services_tb.REVIEWS_CNT, services_tb.AVG_MARKfrom i_reviews
LEFT JOIN (
SELECT i_stores.ID, i_stores.NAME, count(i_reviews.ID) as REVIEWS_CNT, avg(i_reviews.MARK) as AVG_MARK
FR OM i_stores
LEFT JOIN i_reviews ON i_reviews.STORE_ID = i_stores.ID
GROUP BY i_stores.ID
) services_tb ON i_reviews.STORE_ID = services_tb.ID