Wirte SQL querry for Prestashop DB Manager for CSV export with desired information; make sitemap with categories contain products between parantheses for each category and sub-category

I need proffesional database programmer who is familiar with Prestashop DB schema and it's DB manager in back-office. Task: 1. Create query in DB manager and save it so it can generate CSV file with following information: a) Product reference b) Product name c) Product description d) Product short-description e) Product picture link (as is in export products from products tab in back-office) to determine status; if a product has picture(s) or not f) Product attachment status (same as picture link or, if possible, I preffer to receive a simple "Yes" or "No" situation) g) Product active or inactive h) Category where product belongs 2. Modify sitemap from footer of website so that it will display next to each category and sub-category, between parantheses, how many products are inside that category. Ex: Root (total product count) - > Parent category (total products counts inside all of its sub-categories) -> Child 1 (total products count inside all of it's child categories, if available, if not, then all products from this child category) -> Child 2 (total products count from inside this subcategory and from deeper subcategories, if available), etc. Practical example: Main Category (30 products) -> Subcategory 1A (10 prod.) -> Subcategory 2A (10 prod.) -> Subcategory 1B (20 prod.) -> Subcategory 2B (10 prod.) -> Subcategory 2C (10 prod.)