|
|
|
|
SELECT klctoeic_test_info.name AS name, klctoeic_test_info.mark_total AS mark_total, klctoeic_schedule.inx AS inx_schedule, klctoeic_schedule.inx_school AS inx_school FROM klctoeic_test_info LEFT JOIN klctoeic_schedule ON (klctoeic_test_info.inx_schedule=klctoeic_schedule.inx) WHERE klctoeic_schedule.ox_result='1' AND klctoeic_schedule.date_start_result<'1600607219' AND klctoeic_test_info.date_test >= '1598886000' AND klctoeic_test_info.date_test <= '1601477999' ORDER BY klctoeic_test_info.mark_total DESC LIMIT 0,10 |
|
|
|
|
|
|
|
