SELECT w.id_w, p.id_p, rs.id_s, w.word, w.MainWord, w.comments, rs.rep_date, rs.position, rs.url_result, p.sape_project_id, w.sape_url_id, rd.sape_url_incoming, rd.sape_price, rd.sape_anchors, rd.google_analytics_refer FROM (((pozitron_words as w LEFT JOIN pozitron_reports_daily_sengines as rs ON w.id_w=rs.id_w) LEFT JOIN pozitron_reports_daily_word AS rd ON rs.id_w = rd.id_w AND rs.rep_date = rd.rep_date) LEFT JOIN pozitron_projects as p ON p.id_p=w.id_p) WHERE rs.rep_date >= '2019-12-27' AND rs.rep_date <= '2020-01-20' AND p.id_p= '83' ORDER BY rs.rep_date DESC Генерация выполнена, обновите страницу для регенерации
Скачать positronHirudo.xlsx

Скачать adwordsHirudo.xlsx