Build mysql query työt

...moitteettomasti päivityksen jälkeen (3 eri). Apache-järjestelmä on käytössä. ## Työnkuvaus: - Ubuntu version päivittäminen 20.04 LTS -> 22.04 LTS - Tarkista ja varmista, että nettisivuserveri toimii päivityksen jälkeen: - PHP laajennukset - Turvallisuusliitännäiset - MYSQL - PHPmyadmin - Raportoi mahdollisista ongelmista minulle ja tee parhaasi ratkaistaksesi ne ## Edellytykset: Odotan sinun olevan perehtynyt seuraaviin taitoihin ja kokemukseen: - Ubuntu LTS -käyttöjärjestelmän päivitykset - Apache-web-serverit - PHP, MYSQL, PHPmyadmin laajennusten, optimoinnin ja ylläpidon - Serverin turvallisuuteen liittyvät tekijät - Kyky kommunikoida s...

Tehtäväpohjainen työajanseuranta. (php mysql html5) Käyttäjät puhelimella (selainpohjainen) - tehtävien vastaanotto ja työajan kirjaus (kellokortti) - tehtävien kuittaus Pääkäyttäjät tehtävien lisäys ja tuntien seuranta. - Koosteraportit tunneista - tehtävien priorisointilistaus (esim 3 luokkaa vanhemmuusjärjestykseen) Sopivan henkilön löydettyä tarkempi käyttöliittymäsuunnittelu jonka pohjalta arvioidaan projektin kesto ja kustannukset.

...HTML5 as a page, where the game area is a canvas area and the game has three different colored coins that come down along a predetermined path. The database is a MySQL database, which is pre-coded. Player makes bitcoin transfer us, and the transfer is calculated to 20-digit binary number which determines a coin shop. 0 = right and 1 = left. Binary and bitcoin transfer calculation are encoded completed, but the playing area and mainsite should be encoded bit in the same style as has been done site. This would be good to manage HTML5, Canvas Advanced Animation Toolkit, jQuery, Windows animateframe, maybe socket open. Mysql database is complete, 20-digit binary number and the database is ready, but the game on the site is not yet as a PSD file. The coin must looking good whe...

as agreed Custom help java + mysql Custom help java + mysql Custom help java + mysql Custom help java + mysql

Hei, Sen verran hyvät meriitit löytyi Sinun freelancer.com esittelystä, että oli pakko ottaa välittömästi yhteyttä! Meillä on Wordpress pohjalla oleva laajennus, joka palvelee käyttäj...oli pakko ottaa välittömästi yhteyttä! Meillä on Wordpress pohjalla oleva laajennus, joka palvelee käyttäjiä tallentamaan monenlaista sisältöä oman profiilin alle ja näitä voi sitten toiset käyttäjät tutkia&vertailla. Ikävä kyllä valmis pohja kovin puutteellinen ja tarvitsisi useilta kohdin muokkauksia ja parannuksia. Muokkaukset tehtävä niin wordpressin puolella, kuin myös tietokannan puolella (mysql). Alkuun varmaan usealle p&au...

Php, joomla, drupal, wordplus mysql

c/c++ | c# | java | mysql | ngxin

Moikka, huomasin profiilisi ja ajattelin kysyä olisiko sinulla kiinnostusta tehdä etätyönä PHP/MySQL/JS koodia erilaisiin projekteihin jotka on tehty Yii Frameworkin päälle? Yst. Terv. Mika Saarinen Puh. 040 480 6791 mika@

Java Mysql Project

Etsimme pitkäaikaiseen yhteistyöhön suomenkiltä osaavan koodarin. Tarvittavia taitoja on php, mysql, html ja wordpress osaaminen.

...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...

We have an existing PHP/QuickBooks Online application designed to sync QuickBooks invoices to a MySQL database. The application works correctly when executed but we have an issue where the security token needs to be refreshed manually every 24 hours. We need to devise a way for this application to run with no requirement for refreshing the token manually. The program syncs orders in real-time so manual token refresh is not an acceptable way to do this. A developer is required with experience working with QBO applications and working with the QBO token refresh system so this refresh is done automatically.

...tables. The script should be optimized to avoid system slowdowns and long processing times. Script to Parse Product XML Files: The second script. This script will run continuously and parse XML product files located in a specified folder and its subfolders. Mapping of data: Correct mapping between products and relevant categories will be established using XML data and existing PrestaShop MySQL tables. As we have large amount of products and the feature data. We dont want the filter to read all the data while loading. for example TV category filter should only load and read filter data where products belongs to TV categoeiry. This will speed up filter load. Adding Filter Button for Mobile Display: This task involves modifying the mobile layout to include a filter ...

...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...

I'm seeking a professional with deep experience in MySQL and Linux OS to carry out an installation. * Desired Proficiency and Experience: - Linux Operating System: You need to be familiar with Linux as the installation has to happen on this platform. - MySQl 5.7: The installation is specifically for MySQL 5.7 and you should have experience with this exact version. * Task Overview: - Install MySQL 5.7 on my Linux machine following the Development Machine Settings. * Configuration: - MySQL should be configured to run optimally on a development machine setting. - Your skills should extend to understanding the unique configuration needs of a development system and apply those effectively. Looking forward to your bids, please feel free ...

I require an expert in Asterisk and FreeSWITCH development, along with experienced system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voi...system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voice Response) - CTI - Skill group base call routing to agents. Apart from these, the implementation of Asterisk and FreeSWITCH clustering as well as Call Center Reporting is required. The technology stack should be Linux, PHP, MySQL along with postgresql and API knowledge. The freelancer should have considerable experience in these to meet the project's specifi...

I am ...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 does not return any records. I think addCustomView makes rest call and pass all filters in URL. and this URL is too big. Are you able to investigate / fix thi...

I need a basic web application for maintaining an efficient inventory of automotive spares. The key elements to be tracked include the part number, description, supplier information, purchaser details, condition, make, model etc. In the current scheme, we anticipate less than 100 spares in our inventory system. This is a very basic php/mysql application. I have created a rough up of the requirements using MS Access. I anticipate that the application will have; 4-8 tables. Main tables are - Contacts - Parts - Events 6-10 pages - Search Parts based on any field. - Search contacts - View/Create Contact with image upload - View/Create part with Image Upload and ability to print label - Create event associated with Part - Show all events related to part. Application needs to im...

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 will share my screen through te...

I'm 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, Prod...- 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 SQL and MySQL. - Experience in creating and optimizing database tables. - Strong understanding of relational databases. - Ability to write effective and efficient SQL queries. - Excellent c...

I'm in need of a seasoned .NET developer who possesses the following expertise: - Skilled in developing Web API - Knowledgeable in MySQL as a database system - Need 5+ Years Experience This is a personal project and I'm seeking someone reliable, efficient, and with a firm grasp on these skills to ensure successful implementation. If you have the experience and are keen on a unique personal project, I encourage you to bid.

I'm 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, Prod...- 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 SQL and MySQL. - Experience in creating and optimizing database tables. - Strong understanding of relational databases. - Ability to write effective and efficient SQL queries. - Excellent c...

...by xxxxx Design. xxxxxx have done updates for us over the years, including more recently a new checkout, mobile optimisation and SEO (2022). System Overview Our current developers have answered the below questions (their responses are in Yellow) 1. What are the current versions of software being used? OpenCart, PHP, MySQL etc in the various systems used?  Opencart V1.52 PHP Version 5.6.40 (any other newer version won’t be supported by the platform) MySQL - 10.4.28-MariaDB Laravel V5 … custom interface Active cron jobs running   2. What is the server spec & software versions? RAM, CPU, disk space etc. Full Software list here:  https://xxxxxxxxx/ We run a dedicated machine and resources can be allocated on demand… as minim...

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.

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.

We're in need of an advanced Python programmer well-versed in creating PDF reports from MYSQL and InfluxDB, capable of not only capturing numerical data but transforming it into Graphical Trends and Text-Based Analysis. Key Role: * Develop logics for data interpretation and representation * Create a Professional and Formal UI/UX design for the report generator * Deliver finalized, error-free reports Ideal Experience: * Python expertise * In-depth knowledge of MYSQL and InfluxDB * Proven experience in creating dynamic PDF reports * A keen eye for formal and professional UI/UX design * Strong abilities in abstract reasoning and complex logic writing. Your role will translate our complex database information into understandable, well-structured and professional-looking...

I'm looking for a PHP script expert who can create a real-time data retrieval system for my MySQL database. The script will connect to the BeachesMLS Matrix RETS Server and download all the properties into my database as soon as they are sold. Key Requirements: - Real-time Data Retrieval: The script should constantly monitor the BeachesMLS Matrix RETS Server and instantly download all the sold properties into my MySQL database. - Comprehensive Property Details: The script should specifically download details like price, location, size, agent information, property status, listing date, amenities, property type and the number of bedrooms for each sold property (all fields available) Ideal Skills and Experience: - Proficient in PHP: You should have a strong understanding...

With a pressing need to secure our Laravel and MySQL voting system, we are looking for a skilled professional who can rectify the voting manipulation issue we are currently experiencing. Here's what we need: - Expert in Laravel and MySQL - Experience in securing web voting systems - Proficiency in server request handling is crucial. We have already introduced a new security measure related to server request handling, but our voting results are still being tampered with. We need an expert to identify the lacunae in the existing system and beef it up to prevent any future breaches. In addition to a strong technical skill-set, your knack for problem-solving would be greatly valued on this mission to restore integrity to our online voting system.

...attached .docx it's better explained. * For this project, this is just meant to run on any given localhost machine as a project. I'm in need of a skilled developer to build an application for a project. The main focus will be on exploiting the 'Academic World' dataset, incorporating relational (MySQL), document (MongoDB), and graph databases (Neo4j) which will be provided. Key Functionalities: - See .docx (My Approach) Section This is a project-based task, so I don't think there's a need to implement complex user authentication or intricate access control. Candidates with experience in web-based application development using MySQL, MongoDB, Neo4j will be ideal for this project. Understanding of library management systems and datase...

WordPress site WordPress / MySQL / AJAX / jQuery / PHP / React.js / JavaScript Project Overview This is a simple data driven WordPress site. User 1 registers as a member of “Class 1” User 1 enters a number into class 1 User 2, is also a member of class 1 User 2 searches that number entered by User 1 and is provided instant AJAX search results. User 1 can edit and delete data in his history. User 2 who is a member of class 1, 2 and 3 can view data entered into class 1, 2 and 3. (The chosen classes chosen in the profile. Users can register for up to 3 classes) User 3 who is only registered in class 4 can only view data entered into class 4 I’m needing a bid on the cost and time required to build out this project. If you will be available to provide cont...

I need a highly skilled NODE (puppeteer) expert to undertake a database integration task with my Aviator Game. The game requires MySQL database inclusion and specific features. Key Duties: - Incorporate MySQL database into Aviator Game - Set up the game as needed Essential Features: - Creation of User profiles within the game - Implementation of Leaderboards system Skills and Experience Required: - Proficiency in NODE (puppeteer) language - Extensive experience in MySQL database integration - Familiarity with custom PHP programming

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...

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:

...as well as vector databases to store the index. All ingested documentation is cleaned up and divided into smaller chunks and 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 r...

We are seeking a team of Database Engineers who can combine multiple sources of data into an Azure MySQL database on an automated basis. The operation must comply with HIPAA regulations under an organizational development environment (VDE). All VM's and databases will be deployed through Azure.

I'm in immediate need of an in-app SEO professional to configure my webapp. When shared on WhatsApp, Twitter, Telegram or any other third-party platforms, the content must appear...Twitter, Telegram or any other third-party platforms, the content must appear with a thumbnail. The perfect candidate for this task has: - Expertise and a strong understanding of in-app SEO, and how different social platforms display shared content. - Experience with webapp configuration. - An immediate availability, due to my requirement for swift project completion. The webapp was build with backend php laravel, MySQL, frontend tailwin css vue.js Remember, the more detailed your proposal, the more likely I am to consider it. Including some examples of your past work would be advantageous. ...

...(Marshmallow) em diante. IOS: Suporte a iOS 13.0 em diante. Web: Compatibilidade com os principais navegadores modernos (Chrome, Firefox, Safari, Edge). Linguagens de Programação e Frameworks: Front-end Mobile: React Native para desenvolvimento cross-platform. Back-end: Node.js, para a API do servidor. Front-end Web: React, Angular, ou Vue.js. Banco de Dados: Relacional: PostgreSQL ou MySQL para armazenamento de dados estruturados. NoSQL: MongoDB ou Firebase Firestore para dados semiestruturados e escalabilidade horizontal Ferramentas de Desenvolvimento e Colaboração: Git para controle de versão, com GitHub para repositórios. Docker para containerização e Jenkins ou GitHub Actions para ci/cd (integraç&...

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'm looking for a professional who can help me deploy my Spring Boot Maven with MySQL and React app to Google Cloud Platform. Key Responsibilities: - Deploy Spring Boot Maven with MySQL and React app to Google Cloud Platform - Ensure the deployment is running smoothly and is accessible Ideal Skills and Experience: - Strong experience in deploying Spring Boot applications - Familiarity with React app deployments - Prior experience with Google Cloud Platform - Knowledge of CI/CD pipelines is a plus, although not required in this case - Proficiency with Git for version control Looking forward to your bids!

I need a comprehensive web application that can handle various data-related tasks, from generating PDFs to processing scannable sheets, creating data visualizations, and interactive reports. The ideal candidate for this job should have experience with PHP, MYSQL/MariaDB, and an understanding of data processing and visualization. Key features and requirements: - PDF Generation: The application should be able to take XLSX files, and based on the uploaded data, generate PDFs. - Scannable Sheets: The system must be able to process bulk uploads of scannable sheets, interpret the data (including pencil bubbles), and translate it into tables. - Error Reporting: I need the system to either prompt users to fix any errors or flag errors for later attention, ensuring data integrity. - Data Vi...

...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 provi...

I have MySQL running on my Linux system and I'm looking for a professional to help me install Kannel and set it up as an SMS Gateway with fake dlr

In my ongoing project, I'm facing a thorny issue. Some numeric data is missing from the transaction data table in our MySQL database report. In order to move forward with my work, I need a professional to: - Diagnose the source of this missing data - Fix the issue to ensure all numeric data is correctly pulled into the report from the transaction data table The successful candidate should have: - Extensive familiarity with MySQL databases, specifically in generating and troubleshooting reports - Sound understanding of database architectures and data tables relation - Proven problem-solving abilities I look forward to your proposals and getting our report up to speed.

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 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...

Knowledge of technology required -> Frontend: ReactJS or Vue.js or AngularJS Backend Language: PHP Framework: Laravel Database Modeling: MongoDB, PostgreSQL, MySQL We want to create a CRM app with MERN/MEAN stack or Laravel and JS.

...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`.`customer_lastname`, `o`.`status`, `o`.`created_at`, GROUP_CONCAT(oi.product_id) AS `products`, `billing_address`.`city` AS `billing_city`, `billing_address`.`company` AS `billing_company`, `billing_address`.`postcode` AS `billin...