Решить простую задачу SQL

Technical assignment (TA) for comprehensive update, repair, and configuration of the website Website: elektrik.zp.ua Stage 1. Restoring access and repairing the websiteRestore access to the website control panel (Joomla!).Conduct a scan and complete cleaning of the website from viruses, malware, shells, and backdoors.Clean the database from spam users, remnants of deleted modules, and unnecessary files.Stage 2. Updating CMS and protectionUpdate CMS Joomla (current 3.9.15), PHP (current 7.3.33), and all modules to the latest versions (or create a clean version of the website based on the old one with data transfer).Set up basic protection for the website against viruses, repeated hacking, and spam attacks.Unlocking hosting: Contact support at ukraine.com.ua to check the website and remove restrictions/blockages from the hosting account.Stage 3. Fixing email and improvementsSet up correct email sending from the forms "Request a call" and "Submit a request" to email elektrik.zp.ua @ gmail.com (via SMTP).Check and fix other errors and technical shortcomings on the website.Install a module/script for auto-updating the current year in the footer: 2026© Electrician services in Zaporizhzhia.Stage 4. Setting up analytics and advertisingProperly configure and link services for the account elektrik.zp.ua @ gmail.com: Google Tag Manager (GTM) Google Analytics 4 (GA4) Google Search ConsoleIn GTM and GA4, set up conversion tracking: Submission of the "Request a call" form Submission of the "Submit a request" form Clicks on the phone numberLink GA4 with Google Ads and import configured goals into the advertising account.Stage 5. Speed optimizationOptimize the website loading speed and bring the metrics into the green zone PageSpeed Insights (for mobile and PC).

A plugin needs to be developed. The goal is a convenient table for quick selection and purchasing of goods by wholesale buyers. Functionality Front: Columns - Product selection (check), Name, Category, Warehouse, Delivery, Price, Quantity selection, Add to cart, Clear filters search products in a list filter by categories filter by warehouses filter by delivery product quantity selection adding to cart Back: bulk price increase and decrease by % per warehouse

It is required to refine a WordPress plugin that performs analytics functions. The plugin scans data and displays it on its website. The work can be divided into stages. Main tasks: Analysis and optimization of the current architecture of the plugin. Enhancement of the module for collecting and processing data from external sources. Improvement of performance when working with large volumes of information. Implementation of additional settings in the admin panel. Optimization of storage and display of results on the website. Correction of identified errors and increasing stability of operation. Requirements: Experience working with WordPress. Confident knowledge of PHP, MySQL, JavaScript. Understanding of working with APIs and automated data processing. Ability to understand someone else's code. A detailed technical assignment will be provided to the selected performer after preliminary discussion.

We need a Laravel Backend Developer for the development and maintenance of server logic, databases, and core APIs for our web application. Responsibilities include developing and maintaining server logic and databases for our web application based on Laravel. The work involves integrating frontend frameworks with our server infrastructure and includes designing database architecture and executing queries on relational databases such as MySQL. Professional experience in Laravel development with at least three years of work in this field is required. Experience with integrating frontend frameworks with server infrastructure is also preferred.

We are looking for support for a project based on Yii , we need to make edits and improvements to the database, there is partially a connection with the previous contractor .....................