SQL query with three joinme?

I greet the inhabitants of this website. I have a problem, need your help. In Google I went to find unfortunately nothing could appeal to you.
In General, request all working, except for the section of code:
WHERE
 ekwords.task_id = etask.id


The fact that he does not find etask.id which is chosen outside the parentheses, which is the query.. How to make it visible for this subquery?

SELECT
elist.*,
ekwords.*,
etask.*,
elist.id
FROM
 ebay_list elist
LEFT JOIN ebay_task etask ON
 etask.id = elist.task_id
LEFT JOIN(
SELECT
ekwords.keyword
ekwlog.*
FROM
 ebay_kwords ekwords
 LEFT JOIN ebay_kwords_log ekwlog ON
 ekwords.id = ekwlog.keyword_id
WHERE
 ekwords.task_id = etask.id
) ekwords
ON
 DATE_FORMAT(elist.datatime, '%Y-%m-%d %H') = DATE_FORMAT(ekwords.datatime, '%Y-%m-%d %H')
WHERE
 etask.uid = 263230606984
ORDER BY
elist.id
DESC
June 10th 19 at 14:33
2 answers
June 10th 19 at 14:35
Solution
In the inner select to add the sample etask to everything else.
June 10th 19 at 14:37
MB someone when something will be useful. Jonom resolved the issue :)

SELECT
elist.*,
ekwords.*,
etask.*,
elist.id
FROM
 ebay_list elist
LEFT JOIN ebay_task etask ON
 etask.id = elist.task_id
LEFT JOIN(
SELECT
ekwords.keyword
ekwlog.*
FROM
 ebay_kwords ekwords
 LEFT JOIN ebay_kwords_log ekwlog ON
 ekwords.id = ekwlog.keyword_id
 LEFT JOIN ebay_task etask
 ON ekwords.task_id = etask.id
) ekwords
ON
 DATE_FORMAT(elist.datatime, '%Y-%m-%d %H') = DATE_FORMAT(ekwords.datatime, '%Y-%m-%d %H')
WHERE
 etask.uid = 263230606984
ORDER BY
elist.id
DESC

Find more questions by tags SQLMySQL