Нужно зделать запрос MySQL для вычисление рейтинга

Need to: Create a website – online store in Ukrainian (subsequently multilingual). The engine is not critical, the most important thing is that the admin panel is user-friendly.Consists of: - Main page- Catalog with categories, subcategories, and product cards (with the ability to add both categories and subcategories): - Blog- Text (purely informational) pages:“Who we are” or “ABOUT US”Payment and delivery, Exchange and returns, Privacy policy, Public offer, Warranty.Contacts+ Admin panel 2. Register hosting 3. Purchase and link a domain4. Install a favicon5. Register Google Analytics and add the website 6. Create and connect a Telegram chatbot for order notification. 7. SEO. It is necessary to provide fields for each category and product: HTML title, meta keywords, meta description, h1, SEO text. The design can be template-based.

We are looking for an experienced WordPress developer or a small team for a comprehensive modernization of the existing website of the construction company TERZI — terzi.biz. It is necessary to transform the existing website into a modern interactive sales platform: develop a premium responsive UX/UI design; improve the frontend and backend of WordPress; create managed sections for services, materials, equipment, projects, and case studies; implement a cost calculator, quiz, forms with photo uploads, and B2C/B2B scenarios; integrate KeyCRM, Telegram, GA4, GTM, Meta Pixel, Google Ads, and Ringostat; implement Ukrainian and Russian versions; maintain existing SEO positions, set up redirects, Schema.org, and Core Web Vitals; conduct migration, testing, and launch of the website. The website does not necessarily need to be created completely from scratch: usable code and modules from the existing WordPress should be reused. There is a detailed technical specification of 50 pages with page structure, functionality, design system, and acceptance requirements. In your response, please indicate: Examples of similar WordPress projects. Who will be responsible for design, frontend, and backend. Preliminary timeline and cost. Proposed development stages and warranty conditions.

Need a specialist with knowledge of PHP, HTML, CSS, and WordPressTechnical Task Project: refinement of the WordPress site Main site: https://podohealth.pl/ Backup site with implementation examples: https://podolog-wroclaw.com.pl/ All changes need to be implemented directly in the site code or through the appropriate mechanisms of WordPress, WooCommerce, and installed plugins. It is important that the changes made do not disappear after updating the theme or plugins. If necessary, a child theme should be used. All points of the technical task have already been implemented on the backup site. Changes were made there before transferring to the main site. Unfortunately, before starting work on the backup hosting, the current version of the main site was not deployed. Because of this, transferring the completed changes to the main version turned out to be impossible due to bugs with site speed, etc. Therefore, it is now necessary to copy all files responsible for the changes, raise the current version of the site, implement these changes, and fix bugs (the site speed has dropped) and then raise the current version of the site on the main hosting, or re-implement them directly on the current version of the site in such a way that it does not interfere with users and does not crash the site. Technical task here https://docs.google.com/document/d/1SoHMhTDEwsrSzul3JmAWZy5htCbBbUnolezaicFaJlA/edit?usp=sharing Ideally, we would like to find a specialist for long-term cooperation. We have two WordPress sites that we are constantly developing and refining. The second project is an online store. Main requirements for cooperation: confident knowledge of PHP, HTML, CSS, WordPress, and WooCommerce; ability to work with the existing theme, plugins, and custom code; availability for short phone or video calls occasionally to agree on details; responsible attitude towards backups and transferring changes; willingness to work through a secure agreement; interest in ongoing collaboration. Since we have many projects, in case of successful cooperation, we will be able to regularly provide new tasks. This can also help the contractor to quickly improve their rating on the platform. Regarding the budget, we are considering an affordable specialist, but for us, responsibility, normal communication, and the ability to complete tasks are important.

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.