|
|
|
|
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<'1614383746' AND klctoeic_test_info.date_test >= '1612105200' AND klctoeic_test_info.date_test <= '1614524399' ORDER BY klctoeic_test_info.mark_total DESC LIMIT 0,10 |
|
|
|
|
|
|
|