|------|------------|
|  id  |   nombre   |
|------|------------|
|  1   |  lo q sea  |
|  2   |  lo q sea  |
|  3   |  lo q sea  |
|  4   |  lo q sea  |
|------|------------|

|------|-----------------|----------------|
|  id  |   category_id   |   item_title   |
|------|-----------------|----------------|
|   1  |       2         |   lo q sea..   |
|   2  |       1         |   lo q sea..   |
|   3  |       3         |   lo q sea..   |
|   4  |       2         |   lo q sea..   |
|------|-----------------|----------------|

|----|-----------|
| id |  item_id  |
|----|-----------|
| 1  |     2     |
| 2  |     3     |
| 3  |     3     |
| 4  |     1     |
| 5  |     1     |
| 6  |     2     |
| 7  |     1     |
|----|-----------|

|--------------------------|-----------------------|---------------------|
|   nombre_de_categorias   |   cantidad_de_items   |       visitas       |
|--------------------------|-----------------------|---------------------|
|  lo q sea                |         1             |         3           |
|  lo q sea                |         2             |         2           |
|  lo q sea                |         1             |         2           |
|--------------------------|-----------------------|---------------------|

SELECT DISTINCT c.name,
    (SELECT COUNT(*) FROM items i
    WHERE c.id = i.category_id) AS catidad,
    (SELECT COUNT(*) FROM views_unique vu
    WHERE i.category_id = c.id ) AS visitas
    FROM categories c
    ORDER BY name;