Sql query slow loading website jobs

...have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this query d...

I am currently struggling with slow loading speed on my WordPress website, causing less-than-optimal user experience. The issue started appearing after I added new plugins and uploaded large media files, which now need troubleshooting and resolution. Key tasks include: • Identify and resolve issues causing slow website loading • Optimize large media files without losing quality • Evaluate and optimize newly added plugins performance The ideal freelancer for this project will be an experienced WordPress developer with a strong understanding of how to optimize WordPress site speed. Knowledge and experience with plugins and large media file optimization are essential. While I am unable to provide a list of the recently added plugins,...

I'm seeking a skilled Python developer who can handle all aspects of SNMP for my project. Key Responsibilities: - Implementing SNMP query and data retrieval - Efficiently managing SNMP trap handling and notification - Developing a robust SNMP agent Your role will be crucial in ensuring that our system effectively communicates using SNMP across multiple versions. Ideal Skills and Experience: - Proficiency in Python - Extensive experience with SNMP (versions 1, 2c, and 3) - Strong understanding of network communication - Previous work on SNMP trap handling and agent development is a major plus If you have the right skillset and experience, I look forward to seeing your proposal.

I am looking for someone who has worked with Elementor Queries before to write a query that does the following ... Our posts have an ACF field called prsona, which is shared with the posts. When posts are created they are created with that ACF field of the creator. Now we want to display posts where the posts prsona field matches the users prsona field.

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I wil...

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...

...interesting vlog. Creatively enhance the footage with colorful grading, engaging text, seamless transitions, captivating sound effects, and stunning VFX; add a playful touch - all to make the final product truly entertaining. Ideal Skills: - Proficiency in video editing software like Adobe Premiere Pro, Final Cut Pro etc. - Strong ability to incorporate effects such as color grading, graphics, and slow-motion - Experience in creating playful and entertaining vlogs targeted at a toddler audience - Impressive portfolio of previous video editing work Requirements: - Incorporate chosen effects following specified themes - Maintain the playful tone throughout the vlog - Provide samples of previous edited videos for review Your talent in converting ordinary footage into an appeal...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

...whom we target. I'm keen on expanding the system to accommodate a referral program. I envision this program to be multi-faceted, with the capability to track referrals, assign rewards and incentives to referrers, and provide benefits to referred customers. The system should also be able to manage and monitor the referral process with ease. There are other smaller improvements required to the website and the database we use to run our suppliers prices. Our stock database was designed by me and built by our then developers. We also link into accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially i...

Develop Website - Description: Create a comprehensive website called with functionalities similar to , incorporating an integrated database where vendors can list their car parts and customers can search for parts using their vehicle's VIN number. Requirements: 1. **Vendor Listing System**: - Implement a user-friendly interface for vendors to register and list their car parts. - Allow vendors to upload images, specify details, and set prices for each listed part. - Ensure secure login and registration functionalities for vendors. 2. **Vehicle Identification via VIN**: - Develop a VIN lookup feature enabling customers to input their vehicle's VIN number and retrieve a list of parts compatible with their vehicle. - Utilize

Please Sign Up or Login to see details.

check attached pic UPDATE : I DO NOT NEED AN APP !!! I NEED A SOFTWARE THAT GENERATE APPS !!! i need a software for windows that can generate an app on the fly it should make an app on the fly with these 3 settings only : app icon app title app WebView address (the website it should open in WebView on loading ) at the end the general idea is to make a soft that can make an the app that will simply open the website in a WebView . YOUR BID MUST START WITH THE WORDS "IM NOT A BOT" - OR ELSE I JUST DELETE BID

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

check attached pic UPDATE : I DO NOT NEED AN APP !!! I NEED A SOFTWARE THAT GENERATE APPS !!! i need a software for windows that can generate an app on the fly it should make an app on the fly with these 3 settings only : app icon app title app WebView address (the website it should open in WebView on loading ) at the end the general idea is to make a soft that can make an the app that will simply open the website in a WebView . YOUR BID MUST START WITH THE WORDS "IM NOT A BOT" - OR ELSE I JUST DELETE BID

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.

As a Magento based business owner, I'm looking to significantly enhance the loading times of my website's pages. Key Project Goals: - Minimize the load time of my website's pages which are currently exceeding 4 seconds. After improvements, I'd like the pages to load as quickly as possible. - Specifically focus on optimizing the Product, Checkout, and Category pages as I'm facing the most loading time issues there. To achieve the above-mentioned goals, it is important to optimize the three crucial aspects of the website: - Image optimization – Utilize appropriate compression techniques for optimized image sizing. - Caching Improvements – Enhance the caching mechanisms to make the website extremely responsive. - Code...

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.

...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....

Create a JS-based WYSIWYG Editor integrated into WordPress Website run a WordPress-based website that is a UGC (User Generated Content) platform. I want users to be able to format their blog posts before publishing. WordPress core and TinyMCE are too heavy and too expensive respectively. I want to implement the same functionality of TinyMCE 7 (free version) via custom code in my site. Requirements of the WYSIWYG Editor: - Support for bold, italics, underline, link insert, link remove, align, highlight, font size, font-family, tables, and more. - Support to format HTML tags automatically. Auto add/remove tags to make programmatic sense. Auto format text pasted from WordPress - Proper functions so that I can programmatically insert content in the editor. - Quickbar to show...

I need a ...time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in PHP or a similar back-end programming language - Strategic problem-solving skills and attention to detail The success of this project requires not just technical expertise, but also a clear understanding of travel agency operations and the importance of efficient booking management. If you have relevant experience and the right skill set, I look forward to...

...are Flipsi Puzzles, an e-commerce store specializing in creative and original double-sided jigsaw puzzles. We're seeking a skilled Shopify expert with a strong background in website performance optimization. Our goal is to enhance our site's overall performance and loading speed and improve user experience. Responsibilities: Conduct a comprehensive performance audit of our current Shopify website. Identify and rectify bottlenecks affecting site speed, such as image optimization, code inefficiencies, and redundant apps. Implement SEO and mobile responsiveness improvements. Advise on best practices for content loading strategies and hosting/CDN solutions. Monitor site performance and provide ongoing maintenance to ensure optimal speed and efficien...

...accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Chennai, Tamil Nadu, India • Has a camera or phone/tablet of quality with a camera, internet access Please see the attached file for the site visit guideline. You are only required to deliver the pictures, video & observations and are not expected to put together...

I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managing the f...

... website is currently experiencing two primary issues - broken links and slow loading speed. Key Requirements: - Fix all broken links: I need a professional to thoroughly check all links on the website and repair those that are broken. This is crucial for maintaining the website's user experience and SEO ranking. - Optimize loading speed: The website currently loads quite slowly, and I would like to significantly speed it up. This may involve reducing image sizes, improving server response times and leveraging browser caching among other strategies. Ideal Skills and Experience: - Proficient in WordPress: The freelancer should have a strong understanding of WordPress to effectively troubleshoot and rectify the issues at hand. - Experience...

...search engine optimization on Google. Key Tasks: - Website Speed Optimization: My website's speed is a key aspect that needs improvement. Your role will be to make various adjustments to enhance the loading times of the website. - Keyword Research and Optimization: Your primary task will involve researching and identifying local community-specific keywords that we can use to optimize our website's content and improve search engine ranking. - Backlink Building: Building high-quality backlinks that are relevant to our business and location is another key task. These backlinks should help improve our website's authority and visibility on Google. Ideal Candidate: - Proficient in Google SEO: You should have prior experience in enhancing website sp...

...and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) AL DAWWASA, NINEVEH, IRAQ. • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Note: Milestone will be released the following week after the site visit to give us time to ...

...time a change is detected. Freelancers with experience in creating similar systems or possessing a deep understanding of the workings of Windows OS will be preferred. Additional Details: Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, send mail to a group, in case of change not applied through Service. 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local database. POST JSON - { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { ...

I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and carrying out dat...

...defect locations on the plan. --- Add new construction plans: capture photo, enter plan name, and select plan type. -- Defect data saving. -- Data submission options on exiting the app or through an in-app menu. Key Features: - Voice Input: Enable voice-based input for defect names and comments to enhance usability. - Offline Functionality: -- The app should be capable of loading project data and operating offline. -- Sync capabilities to upload defect data. - Image Compression: -- Compress images before sending to save bandwidth. -- Store full-resolution images locally on the device. - Individual Photo Submission: Send photos to the server individually rather than in batches to manage data flow and server load effectively. - Persistent Project Interact...

We developed a web portal using PHP and MySQL to be used at places where Internet speed is slow, but it is taking long. We have about 20,000 records and they will quickly grow to a million and more. Here is the PHP code and MySQL database:

Looking to create a graphic similar to the reference file. I'd like fabric texture on the hat and embroidery texture on logo I will provide you with a clips and you place the 3d model hat over the video and manipulate its movement. Looking to have tor...video and manipulate its movement. Looking to have tornados placed around an existing monument Mavs Texas Twist View of the building with tornadoes swirling around and multiple hats (like 30) flying around in the air. One hat fly's close to the camera as soon as it gets close shows a slow motion 360 shot of the hat. Rangers Texas Twist View of the Stadium with tornadoes swirling around and multiple hats (like 30) flying around in the air. One hat fly's close to the camera as soon as it gets close shows a slo...

...labeled by source. We then use the GPT embedding API to generate a vector representation of each chunk and store it in the vector db index. When a user asks a question, we convert it to an embedding, and perform an advanced semantic search for closest matches to the user's query. Then we take the most relevant chunks, included them as context along with the original question, and use the ChatGPT API to generate a response in markdown format that we then convert to HTML and display to the user. This is from website. They provide a similarity percentage from the sources they use for the generated answer, we can use that similarity percentage for the remuneration of the content creators. At this stage I need the overall architecture, then additional help to detail the...

I'm looking for a Shopify expert to help improve the loading speed of my online store. The areas of focus will be on the overall site performance, particularly in relation to complex scripts which are currently slowing down the site. Key tasks for this project include: - Identifying and optimizing complex scripts: The primary issue affecting the site speed is complex scripts running in the background. Your role will involve assessing these scripts and making necessary modifications to streamline their performance. - Implementing image optimization: While the primary concern is on the script side, there is also a need for image optimization. In this regard, we are looking for a solution that can automate this process for us while still maintaining image quality. The ideal ca...

As an online entrepreneur, I'm struggling with the slow loading speed of my WordPress website. This is exacerbated by high server resource usage and poor caching and optimization. More worryingly, I'm dealing with an excessively large Document Object Model (DOM) that further hinders the performance of my site. However, I'm unable to pinpoint specific issues caused by this. I require a skilled professional with in-depth knowledge of WordPress performance optimization to address these problems. The right person should be able to streamline my site for faster loading speed and lower server resource usage. They should also have experience in proper site caching and optimization, and have technical know-how to handle DOM size reduction and enhancemen...

...WooCommerce expert to create a website for my online store. REFERENCE1: REFERENCE2: (main reference, notice the main page and the sliding menu) REFERENCE3: MAIN FOCUS: mobile-first / customer experience / under 2 seconds load time PAGES: - store page - single product - wc related - billing,checkout,order completion page - order tracking - contact - terms and conditions (only prep the page, content will be provided) - privacy policy and gdpr (only page prep, content will be provided) - return policy (same as previous two points) - order return form (pdf download, pdf will be provided) FUNCTIONALITY: - GDPR popup in overall style of the website - small banner above menu

...for jobs, and managing profiles and portfolios. - Build an admin portal with role-based access for monitoring user activity, managing complaints, and generating reports on job listings and user satisfaction. Preferred Tech Stack: - Front End: TypeScript framework with Server Side Rendering (React.js or Vue.js for web, React Native or Flutter for mobile) - Back End: Utilize GCP services (Cloud SQL, Cloud Functions, etc.) - Payment Gateway: Midtrans Indonesia. This work is going to be divided into 6 major stages, corresponding to 6 milestones: 1. Planning 2. Designing (Software design) 3. Developing 4. Testing 5. Implementation & Integration 6. Maintenance Details upon each stage will be discussed through online meeting If you're passionate about creating innovati...

I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.

We developed a web portal using PHP and MySQL to be used at places where Internet speed is slow, but it is taking long. We have about 20,000 records and they will quickly grow to a million and more. Attached is the requirements document, PHP Code and MySQL Database. This is quite urgent. PHP Code and MySQL is here:

I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of these modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide ex...

I need a CDN expert who can specifically work with Cloudflare for image acceleration. The project involves ensuring my images load instantly on my site. This is a crucial requirement for me. Key Requireme...CDN expert who can specifically work with Cloudflare for image acceleration. The project involves ensuring my images load instantly on my site. This is a crucial requirement for me. Key Requirements: - Proficiency in working with Cloudflare for CDN acceleration, specifically for image optimization. - Ability to guarantee instant image loading on the site. Ideal Candidate: - Experience with Cloudflare CDN, especially in an e-commerce or image-heavy website. - Proven track record in optimizing images for high-speed delivery. - Able to work on a tight timeline and deliver ...

I'm in need of a publishing expert in book publishing services, specifically for non-fiction genres. I have a fully-completed manuscript and I'm looking for someone to critically fine-tune my query letter and book proposal. Your role would involve: - Review and edit query letter and book proposal for UK and US agents - Offer constructive feedback and direction on improving the overall readability and marketability of the book proposal and letter Ideal candidates should have: - Proven experience in non-fiction book publishing with traditional publishers - Significant experience in the book proposal process - Solid understanding of what works in non-fiction book proposals to secure a literary agent Overall, your expertise will play a pivotal role in the overall su...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm currently experiencing some problems with SQL Server 2019 regarding a synchronization error in my Snapshot Replication model. Present issue: - Synchronization process follows an error. Desired solution: - Ability to correct the synchronization errors to allow for smooth data replication. Ideal Skills: - SQL Server 2019 expertise - Solid understanding of Snapshot Replication model - Proven experience in troubleshooting synchronization errors. I'm seeking assistance from someone with these expertise, who can provide a quick and efficient resolution to this problem.

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...

I am seeking a talented website developer experienced in WordPress to build a website for a restaurant. This project requires in-depth knowledge of WordPress and excellent web designing capabilities. The envisioned website should consist of the following sections/pages: - Home - About - Menu (will be in PDF version) - Restaurant - Beach Club - Members Club - Gallery - News (for the blog, events, etc. types of articles) The page layout prototype is attached, along with the logo and fonts. You can use pictures from 3d interior and outdoor render, or you can use any suitable pictures from any photo stock. You are free to choose a suitable design template (after agreeing with me in advance). The main condition is that the final website should be no wors...

I am seeking a proficient front-end web developer who is keen to work on improving the performance of my website. Your expertise should predominantly lie in front-end development, with a focus on optimizing loading times, enhancing the user experience with smooth navigation, and ensuring overall better performance. - Excellent knowledge of HTML, CSS, JavaScript and other relevant front-end languages are required. - Additional experience in web performance metrics and testing tools will be beneficial. - The primary aim of this project is to notably improve website performance. - The successful candidate should have strong problem-solving skills and a track record of improving website speed and reliability.

...Experience: - Proven experience with Magento 2 development - Strong understanding of cron jobs and how they work within Magento 2 - Familiarity with debugging and resolving SQL integrity constraint violations Please note that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, `o`.`customer_id`, `o`.`billing_address_id`, `o`.`customer_email`, `o`.`customer_firstname`, `o`....