SELECT 'goods' AS table, count(*) FROM goods
union
SELECT 'food',           count(*) FROM food
union
SELECT 'supplier',       count(*) FROM supplier
union
SELECT 'recipe',         count(*) FROM recipe
;
