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