Написать SQL запрос

Refinement of the working landing page - configurator created in AI is required. Almost all visualizations and options have been created. We will provide the archive. Everything needs to work well, be displayed properly, and be adaptive for mobile and PC. A screenshot of the landing page is attached.

Description: I am looking for a specialist in end-to-end analytics. We have a business in transport branding, two websites on WordPress. Currently, advertising is running, there are applications, but we do not see which channel brings clients. This needs to be fixed. Our websites (please check before submitting a proposal): https://revoltbranding.com https://revolt.com.ua What we have: Two websites on WordPress (forms on Contact Form 7) CRM: KeyCRM Telephony: Binotel Advertising: Google Ads Application channels: calls, forms on the website, Telegram, Viber, OLX, email What needs to be done (final result):End-to-end analytics works on both websites, and each application goes into the CRM with the source from which the client came. Then one dashboard where the number of applications and their cost by each channel is visible. Specific tasks: Organize GA4 and Google Tag Manager on both websites (consolidate into one system, unified events) Set up call tracking in Binotel: number substitution depending on the channel (separate number for Google Ads, separate for organic), so that it is visible in the CRM where the call came from Set up the transfer of UTM tags from forms to KeyCRM (we will install the plugin for forms) Set up tracking of applications from Telegram and Viber Separate conversions in Google Ads so that real applications are counted, not clicks on buttons Gather a dashboard in Looker Studio: GA4 + Google Ads + application data Important: Experience specifically with KeyCRM is not mandatory, but you will need to understand it (documentation is available, integrations are built-in). Experience with GA4, GTM, call tracking, and setting up end-to-end analytics is mandatory It is preferable that all containers and codes are connected via GTM, rather than inserted directly into the website code We have a freelance front-end developer on our side who can be involved for code adjustments on the websites if needed Work format: one-time turnkey task. We will provide all access (websites, GA4, Google Ads, KeyCRM, Binotel). In your response, please write: Have you previously done end-to-end analytics with the connection of telephony + CRM Estimated time and cost A couple of examples of similar projects

Project Overview We are looking for an experienced Make.comautomation specialist to help us build one additional automation for our existing workflow. Our business already has several Make.com automations connected with Monday.com, so the overall system is already in place. We only need assistance with this specific automation, ensuring it integrates smoothly with our current setup.Workflow When a client reaches a specific status in Monday.com: Detect the new client in Monday.com. Read the following fields from the board: Client Name Email Address Client Portal URL (Notion) Populate our existing HTML welcome email template with those dynamic values. Automatically send the personalized email to the client. (Optional) Update the Monday.com item to indicate that the Welcome Email has been sent.Current Setup We already have: Monday.com CRM Make.com automations Client Portal links stored in Monday.com Existing email template We only need help creating this single automation and integrating it into our existing automation ecosystem.Tech Stack Make.com Monday.com MailchimpDeliverables Fully functional Make.com scenario Dynamic mapping of all fields Error handling for missing information Duplicate email preventionRequirements Strong experience with Make.com Experience building Monday.com automations Good English communication Estimated Timeline 2–4 hours

TECHNICAL TASK Update of the online store bp.ua About the project An active online perfume store on OpenCart 2.x. It needs to be migrated to OpenCart 4.x, the design and functionality updated, while preserving all data, integrations, and SEO. The site is bilingual (Ukrainian + Russian). We are looking for a performer (or team) for backend and frontend. You can respond to one part or both.Part 1. Backend (OpenCart 4)Migration Deployment of a clean OpenCart 4.x (latest stable branch), PHP 8.1+. Data transfer: products, categories, attributes, options, brands, customers, orders, reviews, content pages. Preservation of SEO-URL (pretty URLs) one-to-one; a map of 301 redirects from old addresses. No direct upgrade from 2.x → 4.x: only clean deployment + controlled transfer.API integration with the supplier (priority) Porting existing custom exchange modifications with the supplier's server (prices + stock). Automatic synchronization on schedule (cron), error log, manual launch. Hiding/status for items that are out of stock. Support for a catalog of 2,000+ items.Modules Nova Poshta: selection of branches/parcel lockers, auto-generation of shipping documents from the admin panel. Payment: integration of payment system (LiqPay / Fondy / WayForPay — to be agreed), cash on delivery. Checkout: server logic, guest order, statuses, customer notifications. Mass import/update of products from the price list (xlsx/csv), linking photos by article/barcode.Bilingualism (uk / ru) Two languages of the store: uk-UA (main) and ru-RU. Bilingual fields for products, categories, content pages, meta tags. Separate SEO-URLs for each language, hreflang tags, canonical URLs. 301 redirects from old URLs of both languages (check the current scheme: /ru/, subdomain or parameter). Emails to the customer — in the client's session language.Blog Preserve the existing articles section https://blog.bp.ua/. Transfer existing articles (uk/ru) while preserving URLs and 301 redirects where necessary. Bilingualism, correct SEO markup of articles. The blog section must remain editable from the admin panel.SEO (server-side) Replacing third-party SEO module with native OC4 mechanism. Generating sitemap.xml (separate language branches), correct robots.txt. Microdata Schema.org (Product, Offer, BreadcrumbList, Article for the blog).Performance and security Cache (OPcache + built-in OC4), query optimization, gzip/brotli, HTTP/2. Images: WebP, resize with caching. HTTPS, 2FA in the admin panel, current patches, daily backups. Core Web Vitals in the "green" zone on mobile.Work order All work is conducted on staging. The old site operates until full testing of the new one. Switching to production — with the possibility of rollback for 30 days. Part 2. Frontend (design + layout)Design Style: minimalist, premium, lots of "air", focus on product photos. Mobile-first approach (most traffic is mobile). Design system in Figma: palette, typography, components, states. Mockups of key screens (desktop + mobile): homepage, catalog, product card, brand page, cart, checkout, search, blog, and article page.Layout Semantic HTML5, clean CSS, responsive (mobile-first). Integration into twig templates of OpenCart 4 (not static), working with live data. Images: WebP, lazy-load, srcset. Font with full Cyrillic (uk/ru). Cross-browser compatibility: Chrome, Safari, Firefox, Edge + iOS/Android. Core Web Vitals: LCP < 2.5 s, CLS < 0.1, INP < 200 ms (mobile).Interface functionality Facet filters for the catalog: brand, type, volume, note, gender, price. Product card: photo, description, notes, format/volume, reviews, "people also buy". Quick view, wishlist, comparison, badges (new, hit, limited quantity). Responsive checkout with minimal steps, auto-fill for Nova Poshta. Blog section: list of articles and article page in the site's style.Bilingualism (uk / ru) Language switcher in the header, correct on mobile. Layout considers different line lengths in both languages. All theme text — through language variables of OC4 (no "hardcoded" text). Acceptance and collaborationWhat to deliver upon completion Backend: access (server, DB, admin panel, repository), brief documentation on modifications and cron, deployment/rollback instructions, list of third-party modules. Frontend: Figma file with design system and screens, theme code (twig + CSS/JS), instructions for changing banners/content.Acceptance criteria (brief)

Good day, there is a feed with products in the following format: we need to upload them to the website and ensure that the maximum number of products are indexed by Google. I will send the details privately.