SELECT c_users.fullname, c_users.name, c_schools.name FROM `c_users`, c_submits, c_schools WHERE c_submits.userId = c_users.ID AND c_submits.verdict = 1 and c_submits.submitTime > '2018-01-01 00:00:00' AND c_submits.submitTime < '2019-01-01 00:00:00' AND c_users.idSchool = c_schools.ID UNION SELECT c_users.fullname, c_users.name, c_schools.name FROM `c_users`, c_submits, c_schools WHERE c_submits.userId = c_users.ID AND c_submits.verdict = 1 and c_submits.submitTime > '2018-01-01 00:00:00' AND c_submits.submitTime < '2019-01-01 00:00:00' AND c_users.idSchool = c_schools.ID