1 CREATE VIEW frs_file_vw AS
3 frs_filetype.name AS filetype,
4 frs_processor.name AS processor,
5 frs_dlstats_filetotal_agg.downloads AS downloads
6 FROM frs_filetype,frs_processor,
7 frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
9 frs_filetype.type_id=frs_file.type_id
10 AND frs_processor.processor_id=frs_file.processor_id;