SELECT film_id, amount FROM efis_film_physical_description WHERE classificator_code2='FILM_PHYSICAL_TYPE_FILE_FILE_DURATION' ORDER BY film_id LIMIT 20; SELECT title FROM efis_film_type INNER JOIN efis_film_type_translation ON efis_film_type_translation.film_type_id=efis_film_type.id WHERE classificator_code='TYPE'; SELECT STR_TO_DATE("1:23", "%i:%s"); SELECT film_id, SEC_TO_TIME(sum(TIME_TO_SEC(STR_TO_DATE(amount, "%i:%s")))) FROM efis_film_physical_description WHERE classificator_code2='FILM_PHYSICAL_TYPE_FILE_FILE_DURATION' ORDER BY film_id LIMIT 20;