added some queries for the frontend