Report: Media statistics
Ir a la navegación
Ir a la búsqueda
Description: Media statistics
Copy and paste the text between the lines into the reports section below "OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here:" and give it the title you think is appropriate
SELECT mediatypeID AS Media_Type, COUNT(*) AS Number FROM tng_media GROUP BY mediatypeID UNION SELECT "Total" AS Media_Type, COUNT(*) AS Number FROM tng_media