Php sql admin panel jobs

I am looking for a Laravel expert to develop 11 pages for my website. The pages require comprehensive functionality and integration. Key Requirements: - User Registration and Login: I need a system that supports multiple user roles, including admin, user, and guest. - Database Integration: The pages need to be connected to a database for smooth data handling and storage. - Payment Gateway Integration: I am specifically looking to integrate crypto payments into the system. - Header and Footer Pages: Each page needs to have well-structured, reusable header and footer components for consistency. Ideal Experience: - Proficient in Laravel framework - Strong understanding of database management - Extensive experience in payment gateway integration - Previous work on multi-role user ...

Development a human anatomy VR application for oculus platform. When player in the app, they can choose a male or female anatomy. Then, choose the system function. Subsequently, anatomy of the system function will appear. Then player can click expand to isolate the parts with info panel to show name of organ. Then, player can close and choose other system or choose to see system of another gender. Arabic text of organ name and system name is to be provided prior or during development. Final delivery in apk.

I'm looking for a skilled WooCommerce developer with expertise in PHP and shipping API integration to help me implement a shipment tracking feature for my online store. Ideal skills and experience would include: - Strong proficiency in PHP and WooCommerce - Extensive experience in integrating shipment tracking APIs - Familiarity with Royal Mail / ParcelForce shipping services - Good understanding of customer satisfaction strategies in an e-commerce setting Key responsibilities include: - Integrating the shipment tracking feature into my WooCommerce site - Ensuring the feature is seamless, user-friendly, and integrates well with the existing site - Making sure that the tracking feature is reliable and accurately reflects the status of the shipments - Offering suggestio...

I'm in need of an experienced web app developer to create a Food Finder application. This app aims to help users discover nearby food spots and make informed decisions based on peer reviews. Key Features: - L...bars, and cafes. - Users can click on map markers to view more details about each restaurant, including menus. 4. Restaurant Signup and Management: - Restaurants will have the option to sign up and create listings for their establishments. - Once signed up, restaurants can manage their listings, including updating menu items and other details. 5. Admin Dashboard: - The admin (you) will have access to a dashboard to manage restaurant listings. - Admin functionalities include verifying restaurant information, editing details if necessary, and deleting listin...

I just need one task to be done I'm in need of a PHP Developer for a new project. The parameters and required skills are fairly open, as I've not declared any specific frameworks or preferences. Ideal candidates include those who possess: - Broad knowledge of PHP across various frameworks. Although Laravel, CodeIgniter, and WordPress were the options given, these indications were not selected, thus creating an open space for any skilled PHP professional to apply. - Experience in both website and web application development. There's an opportunity to work on several PHP development projects, potentially ranging from website building, application creation, to API integrations. - An impressive design eye. I've left the space open for any desig...

...website. Here's what I need: - **Migration Issue:** The problem I'm experiencing is related to theme and plugin compatibility following the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP, theme and plugin compatibility issues. Your ability to troubleshoot and resolve migration issues will be crucial. I&...

...professional web developer to upgrade my PHP-based website (CodeIgniter). The current website front end is outdated and the PHP version needs to upgraded too. Key Requirements: - Modernize the User Interface: I want the design to look fresh, modern, and appealing to visitors. We will provide the HTML design for all the pages. - Improve User Experience - Incorporate New Branding Elements - Upgrade the CI/ PHP version to the latest version - The site has a sub login area where the profiles of users are listed. - The users submit their listing info from the front end which creates the profiles. - There is a search function to filter profiles - Ensure the contact forms and all the functions of the site are functional Skills and Experience: - Proficient in PHP...

I need a developer to swiftly convert Figma designs into Next Admin panel pages using Tailwind CSS and TypeScript. The urgency of this project cannot be understated. Therefore, I'm looking for someone who can start immediately and is comfortable working with these specific technologies. Key Requirements: - Proficiency in , Tailwind CSS, and TypeScript - Experience with Figma to web development workflow - Ability to deliver results within a tight timeframe Please provide examples of similar projects you've worked on and a brief overview of your process when converting Figma designs. Here is my figma url: The budget is flexible.

...important tasks, mainly focused on data analysis, process automation, and digital marketing. Key Responsibilities: - Develop and implement an autonomous agent platform with Libraries of tasks, agents, tools to be organized by a user into Crews. - Ensure the agents are capable of accessing and interpreting data from a variety of sources, including databases, APIs, and websites. - Create a user-friendly Panel front end for the CrewAI platform that presents the user insights and controls of Crews in a clear and intuitive manner. Ideal Skills and Experience: - Proven experience in developing autonomous agents. Previous experience with AI, data analysis, process automation, and digital marketing would be highly desirable. - Proficiency in working with databases, APIs, and web scrapi...

...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mo...

I need to change the way my web site updates schedules for tv channels. Right now my site scrapes external sites and pickle dumps and returns data to the site. I want a json or csv to upload to updates all channels manually or we can use my admin to update with file.

...particularly in the area of order tracking and user account functionality. Key Requirements: - User Registration and Login: Users should be able to sign up and log in using their Gmail or email id in addition to setting up a password. - Order Tracking: I need a custom dashboard that allows users to track the status of their orders. This feature should also enable manual entry of order updates by admin. - Downloadable Reports: Once a project is completed, users should be able to download a report related to the service they ordered. The ideal freelancer for this project should have: - Proficiency in Wordpress development - Experience with custom dashboard creation - Strong understanding of user account management and order tracking systems - Excellent communication and problem-...

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...

I need someone with a lot of experience in server configuration, I have a vps and I need to configure it with the HestiaCP panel, configure the server and leave the optimized panel complete

Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...

I am looking for a skilled developer to create a system that can manage and sell chatbots with AI. The main components include: Control Panel Features: Ability to activate or deactivate chatbots Update chatbots with new responses or features Manage clients and their chatbots effectively Display statistics about chatbots usage Provide access to chatbots' configurations Include a client database with their contact information The system should enable me to sell, update, and manage chatbots with ease. On the flip side, my clients should be able to access their chatbots through a login and utilize them effectively in both English and Spanish. Additionally, it is essential that the chatbot can integrate and be used on social media platforms like Facebook, Instagram, or WhatsApp. It...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...

...smooth user experience. I need a skilled Core PHP Developer to build a custom web application with database management capabilities, using MySQL as the preferred database management system. The application should be well-structured and efficient with an emphasis on data handling. Key Requirements: - Extensive experience working with Core PHP. - Proven track record of developing dynamic, secure, and efficient web applications. - Strong understanding and experience with MySQL database management. - Ability to ensure the application is well-structured and follows best practices for data handling. - Strong problem-solving skills and the ability to work independently. ?️ Key Responsibilities: Design and develop the backend system using Core PHP, ensuring high perfor...

We need a skilled PHP developer who can build a SaaS platform based on the functionality and features of and The project has a set deadline. Critical requirements include: - Expertise in PHP development - Experience in building a SaaS platforms - Google My Business API on the server to fetch review data. - API on the server to fetch review data from other platform like Trustpilot, Facebook, Yelp and Amazon review - Ability to replicate similar functionality and features from a reference website Main functionalities required: - Platform formation from scratch - Comprehensive platform construction - User Registration and Login - Product Rating and Review - API Integration We aim to replicate similar features and functionality from the reference

Im going to start a marketing agency on telegram using multiple telegram accounts to forward customers personal group message to x amount of other groups. Installing a subscription based plan with certain amount of groups to choose from. It needs a user panel with a GUI for me to work with Example: Subscription plan A: forward message to 500 groups Subscription plan B: forward message to 1000 groups Subscription plan C: forward message to 2000 groups Step 1) make the program login to telegram accounts through web Step 2) join groups with the account Step 3) forward automated messages from my channel to other groups with interval every 20minutes to 1hour simultaneously functionalities: - option with interval from 20minutes to 1 hour - ability to add multiple telegram account to ...

We are looking for a skilled freelancer to quickly customize an admin UI template for our project. The template has already been installed on the server and customization has already begun, we just need help finalizing the designs for the remaining pages. The template needs to be modified to match our design requirements which will be provided to you upon request. The ideal candidate should have experience in UI customization and be proficient in HTML, CSS, and JavaScript. PHP experience is a PLUS since the entire site is programmed in PHP using a custom framework. Attention to detail and the ability to work efficiently are essential. The main tasks include using existing template elements to create and design the needed pages for our back office or using yo...

Before applying for the task, please read the following: - I will include a code word at the end of the text to ensure you have read it thoroughly. When you apply, please start with this code word; I will ignore everything else. - The price and time you provide will be considered fixed, so please adhere to them as I will not negotiate. - I will explain the task as precisely as possible and provide the necessary login credentials. Here is the task: My website is a multi-vendor platform where sellers list their products. When sellers upload products, they had to specify product images and gallery images separately for image uploads. I asked the previous freelancer to automate this so that the product image would automatically become a gallery image as well. Unfortunately, they messed it...

...features in core PHP. - **Fixing:** The project needs to address some bugs and issues. - **New Features:** I'm looking to add a partners portal enhancement, scheduling options for cron jobs, and a mail campaign scheduling feature. - **Partners Portal Enhancement:** The focus of this project is on enhancing the partners' portal, such as: - Improving the user interface to make it more user-friendly. - Adding additional features for partner management that will make the portal more functional and useful for our partners. - Integrating with third-party systems to enhance the capability and reach of our portal. Your previous experience in core PHP projects and adding new features will be a big plus for this project. The ideal candidate should have a s...

I am looking for a PHP and WordPress Expert to fix a small issue with my current CAPTCHA, which is written in PHP. I also need to add another CAPTCHA to my wordpress website. If you think you can work on these tasks, please let me know. Ideal Skills and Experience: - Proficient in PHP and WordPress. - Expertise in CAPTCHA integration.

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...

I am currently seeking a video editor for my website, electrosmm.com. I am looking for an editor who is proficient in creating videos in the style of Instagram trending memes or songs. The primary goal of these videos is to promote and attract users to my website, which is a social media marketing panel offering various social media services.

I'm looking for a highly skilled WordPress and IT professional to execute various tasks on my website. The scope of work includes: - Setting up user registration and login functionality. ...should be available to any user who chooses to register. - Making specific edits on the website – this could involve changing the theme, customizing the layout, or adding new content. - Assisting with IT tasks such as connecting my Namecheap URL to my cyber panel. Your job will be to establish the initial setup, ensuring a seamless connection between both platforms. Ideal candidates should have substantial WordPress experience, specifically with user registration and website modification. Familiarity with Namecheap and cyber panel is a plus, as is a solid understanding of in...

I'm looking for an experienced PHP developer who is well-versed with MySQL to help me with editing the search module of my website. The primary focus of this project is on modifying the way images are retrieved then displayed in the search results. Key Requirements: - Modify the retrieval of images in the search results to use URLs for specific sizes as opposed to the current methodology of storing images locally and then displaying. - No specific enhancements are needed for the image thumbnails, just an adjustment in the retrieval and subsequent display methodology. Ideal Skills: - Proficiency in PHP and MySQL - Experience with implementing search modules in web development - Familiarity with retrieving and displaying images in various sizes - Strong problem-solving ...

ALL PHP script of the configurations and parameters of the site /////CONFIG AND INSTALL SCRIPT //// I want a complete configuration of all parameters URL DEMO SCRIPT. 7437.Cj0KCQiA5rGuBhCnARIsAN11vgR0IAOeV3fZLehJ28mJeOVeC35qXrrXFJfbYhlUK8e9nraqPybSIxUaAic2EALw_wcB .................................................. ................ ......... I want a complete script setup with all systems working. CREATION OF ACCOUNTS AND EMAIL ADDRESSES TO MAKE THE WHOLE SCRIPT WORK example add: :add languages EUROPE AND ENGLISH : account creation, facebock, instagram, twitter X, (create an email address on the domain)

...resources. Training Process: Each employee will access pre-recorded training videos. I will personally upload the videos as well as the quiz questions with their respective selection options. Successful completion of the quiz should generate a PDF diploma. Additional Requirements: The platform must be responsive and developed using technologies such as PHP and HTML5, allowing full customization from the control panel. It must include a panel or dashboard from which I can upload more information, options, or videos in a personalized manner. Additionally, the exams should have a set maximum time. The platform must be scalable to add more training as needed. Ideal Skills and Experience: Experience with Learning Management Systems (LMS) or similar platforms Familiarity...

Looking for php laravel developer for small modification on home page of my movie website. 1. Latest movie section is not showing on Home page, show that section again. 2. Fix a small bugs on movies or series option clicking first time showing sometimes Loading only. 3. Lates data of series are not showing. Here is the website:

I'm in need of a talented Unity developer who can readymade Rummy game for Android and iOS. Also there should be feature in admin panel from I can host tournaments. - Development for both Android & iOS: - The game should be developed for both these platforms, ensuring that it's optimized and functions seamlessly on both. - Target Audience: - The main demographic is young adults aged between 20-35. The game should cater to this group in terms of design, features, and overall user experience. - Game Type: - The Rummy game I'm looking to develop is based on Indian Rummy. Players should be able to enjoy the complexities and strategies that come with this variant. Ideal skills for this project include: - Proficiency in Unity - Strong knowledge of ga...

... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...

...it work for our team - Integrate Odoo with 3CX phone system API to bring in phone records, create new leads or contact when a call is received, if possible also bring in call recordings from 3CX and put in contacts record, and call stats for each user of 3CX - Help create accurate reports in Odoo from sales, google ads, integration to Stripe payments, able to refund payments from witin Odoo for admin users/specific roles - Setup reports and dashboards that give insight into business and KPIs - The selected freelancer should have significant expertise in customizing Odoo's to fit a specific need. - Thorough knowledge of Python and Odoo Framework is required to undertake this task. - Develop custom module if needed Therefore, the ideal freelancer should have extensive experie...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...

I would like a Network Admin to configure the router of an internet network to allow the transmission of video signals from an RTP/RTSP-RTMP encoder, installed on a PC with a router equipped with a dynamic IP address in OFFICE A, to the recipient OFFICE B , which is connected to a server with a router with a static IP address. Reception/decoding in OFFICE B must take place via an RTP/RTSP-RTMP decoder or via VLC. We are also evaluating the possibility of implementing a CDN or a VPN to further optimize signal transmission.

I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: -...considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existing. Required: Experience with ER Models architecture Experience with MS SQL server 2017 express as DBMS Experience with Python 3.8.3 and Tkinter GUI toolkit Experience with Powe...

We are looking for a web designer who has minimum 3 years of experience in Full Stack Development. Tech for backend can be python/node.js and for frontend react.js. We have the UI for what we want to build, we need backend and frontend to be developed for the same. Our website is a m...are looking for a web designer who has minimum 3 years of experience in Full Stack Development. Tech for backend can be python/node.js and for frontend react.js. We have the UI for what we want to build, we need backend and frontend to be developed for the same. Our website is a marketplace, where publishers can register and add their offerings and advertiser can purchase it and place orders, admin panel UI is also available. You should know how to follow structured approach and keeping sca...

I'm in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities for large data sets.

...profiles. • Tools for managing job applications include sorting, filtering, and communicating with applicants. • An analytics dashboard is used to track the performance of job postings and applicant metrics. 3.4 Communication Tools: • Integrated messaging system for communication between job seekers and employers. • Notifications for new messages, job applications, and other relevant updates. 3.5 Admin Panel: • Administrative dashboard for managing user accounts, job postings, and overall site content. • Tools for monitoring and moderating user activity, including content moderation and user support. 4. Non-Functional Requirements: 4.1 Performance: • The website should load quickly and efficiently, even during peak traffic periods. &bull...

More details: What specific coding issue are you experiencing on your website? Functionality not working as expected Which functionality on your website is not working as expected? Footer How soon do you need your project completed? ASAP

I'm seeking an experienced developer to create a minimum viable product (MVP) of a rent payment system with a reward component. The project involves building a user app, a landlord app, and an admin portal. Specifically, the user app should: - allow tenants to make rent payments through the app - provide a reward system for timely payments The landlord app should include: - functionality for managing rent payments - tools for monitoring the reward system The admin portal must have: - user management features - landlord management capabilities - transaction tracking functionality I'm looking for a developer who is not only skilled in app development, but also understands the dynamics of rent payment systems and reward programs. Experience with both front-end and...

Current project is built on Laravel for both front and backend. Need to build React frontend to replace Laravel frontend side. All the pages inside...is built on Laravel for both front and backend. Need to build React frontend to replace Laravel frontend side. All the pages inside current pages should be moved to React with new template UI and all same functionalities. Main Laravel frontend back end Login this saas/superadmin version (include All modules) USE THIS Admin TEMPLATE FOR Frontend Current system making this stacks - Laravel, MySQL, VueJS, JQuery & Bootstrap, DOCUMENTATION API DOC

Please note that this is not a Website development requirement. I'm in need of a professional who's skilled in both Lotus Notes administration and development. The primary goal of the project is to conduct a code review and implement mild enhancements, primarily focusing on the user interface. Should have a bit of experience in migration. Experience level - 3 to 5 yrs Key Responsibilities: - Review the current codebase - Identify areas for improvement within the user interface - Implement enhancements to the user interface Ideal Skills and Experience: - Proficiency in Lotus Notes administration and development - Experience with conducting code reviews - Strong expertise in enhancing user interfaces - Excellent problem-solving abilities I'm looking for a self-driven i...

I'll create android app with below details: Customer (Android App) - order dessert - choose variation - track order - give review rating - get rewards (points) Admin (Seller) (Android Java) - input dessert - input dessert’s variation - track new order - update order - view rating

I have an old design source code that I need to be converted to a new React template for my SaaS website. Requirements: - Convert the existing design to a new React template - Ensure all current functionalities are maintained - Optimize the template for performance Ideal Skills: - Proficiency in React and JavaScript - Experience in web design and development - Kn...Requirements: - Convert the existing design to a new React template - Ensure all current functionalities are maintained - Optimize the template for performance Ideal Skills: - Proficiency in React and JavaScript - Experience in web design and development - Knowledge in optimizing website performance - Understanding of SaaS platforms and their functionalities React Theme to be used -

...academic project Transport Management Android App for the college. Admin Functionality: - You'll need to create a platform where the admin can manage bus routes and schedules. This involves adding, modifying, or deleting routes and schedules as needed. - The app should have a feature for the admin to generate reports and statistics related to transportation. This could include data on bus usage, frequency of stops, and times of heaviest usage. Student Functionality: - Students should be able to access the app, view the bus routes and schedules easily. - They should receive relevant notifications such as schedule changes and general announcements. Incorporate the following features: - Include the option for both student and admin login. - The app sho...

...developer to create a digital product ecommerce store. The store will exclusively sell digital products. The aim of the store is to provide a seamless process for customers to purchase and access the products. Key Requirements: - The payment process should involve a manual payment form. Once a user fills in the form, I should receive a notification and manually confirm the payment through an admin panel. - Once the payment is confirmed, the customer should receive an email with a download link to access the product. Ideal Skills and Experience: - Proficiency in ecommerce development, specifically for digital products - Experience with manual payment processing integration - Understanding of email delivery systems for digital product access If you have relevant experienc...

I'm looking to create an Android app primarily for use by my distribution staff. The app will serve as a tool for them to order products and for me to monitor their movements. Key Features: - Product Catalog: The app should contain a list of products available for ordering. This would ensure that my staff have a clear understanding of what's in stock. - Order Placement: The ...track the movements of my distribution staff in real-time. This feature is crucial for me to ensure efficient delivery and to track their performance. The ideal candidate for this project will have experience in Android app development, especially when it comes to building apps that involve live tracking features. Experience in designing intuitive interfaces for ordering systems would be a plus. admin...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?