Mysql query script isnare jobs

I am interested in hiring a creative and insightful graphic designer to develop detailed, illustrative graphics for my cyber security channel, "Loop Script." This project includes the creation of a: 1. YouTube banner, 2. Instagram logo, and 3. Twitter logo. Objective: My channel's primary purpose revolves around educating users on existing cyber security threats. Therefore, I am looking for someone who can effectively use design as a storytelling tool to reflect this objective visually. Tone: Though we deal with serious topics, our brand wishes to project a tone that is friendly and approachable. Applicants should therefore have the ability to translate this friendly and approachable tone into their design. Skills/Experience: ideally, I would prefer someone with p...

Please Sign Up or Login to see details.

...channels integration. Experience in working with webhooks for real-time data processing. Proficient in data mapping and transformation techniques. Strong problem-solving skills and attention to detail, especially in error handling and data integrity. Excellent English communication skills, with the ability to document the integration process. Project Deliverables A fully functional integration script or application that automates order updates to Shopify. Comprehensive documentation detailing the integration setup and data mapping guide. I am looking for detailed proposals that highlight your approach to this project, including any similar past projects. If you have the expertise and are interested in developing a streamlined integration for our e-commerce operations, Please re...

I need a captivating 30-second video advertisement for my window cleaning business. The script is shown below: (Open with shots of a nice two-story home with large windows/skylights) Keeping those hard-to-reach windows sparkling clean is a real challenge. (Showcase a video of a woman struggling to clean a high window.) Ladders are dangerous and inefficient for second-story cleaning. (Concerned looks watching the precarious ladder work) Until now...Introducing water fed pole window cleaning. [Setting up purification system, pumping, extending poles] Pressurized purified water powers extendable poles to easily reach up high. [Pole brushes smoothly cleaning high windows from the ground] Reach the unreachable with pure cleaning power from the safety of your yard. [Beautifu...

I'm looking for a proficient Excel expert with extensive experience in data cleaning to assist with a key task. Your primary responsibilities will include: - Identifying and removing duplicate data entries in Excel, Data cleaning - Creating Pivot tables and data aggregati...experience in data cleaning to assist with a key task. Your primary responsibilities will include: - Identifying and removing duplicate data entries in Excel, Data cleaning - Creating Pivot tables and data aggregations - Efficient dashboard and visuals that showcases trends and patterns via graphical data representation. Please only bid if you are seasoned in creating pivot tables, using Power query and generating visually appealing data insights. Precision and attention to detail are essential skills fo...

I'm in need of an experienced Power BI developer to help with a particular project. Key Areas of Work - DAX - Power Query - Power View - Power BI Services - Power Pivot You will be expected to provide insightful data visualizations using Power BI. A deep understanding of DAX,Power Query, Power View, Power BI Services, and Power Pivot is mandatory for this task. Ideal Candidate The ideal candidate should be proficient in using these tools, enabling swift execution of the project. An in-depth understanding of creating visual representations of our data sets is essential. Deadline The project needs to be completed within a month. If you're a thorough professional familiar with these tools and possess the ability to meet deadlines, your expertise is required.

Hello,...processing. I came across a promising script on Codecanyon (Affiliate Management System: ) that seems like a good fit. However, I need someone to assess its compatibility with WarriorPlus. Ideally, the script should offer features tailored for both vendors and affiliates. As a vendor, I would like to: Display the SaaS applications I have listed on WarriorPlus and Recruit affiliates to promote the products and give them necessary tools and resources to promote the products. It's important to note that I want to use WarriorPlus exclusively for all payment processing. Please let me know if you're interested in this project and have the expertise to evaluate and potentially customize the script for my needs.

I am in need of a MySQL/MariaDB professional who can efficiently optimize my current database setup for larger queries. As the main area needing improvement is speed, the successful candidate will be those who can increase efficiency with minimal disruption. Key responsibilities will include, but are not limited to: * Enhancing database structure; this may include revisions in indexing or query optimization techniques. * Utilizing past experience and success stories in database speed optimization to further benefit this project. In your application, please include examples of past work where speed was dramatically improved through your interventions. This task demands significant MySQL/MariaDB experience, with a strong focus on developing and implementing strategies...

I'm in need of a skilled Python developer who can build a web scraper to extract data from a map-based website. Here's a high-level rundown of the project: - Develop a Python scraper that can pull geographic coordinates from a map-centric site. - Clean and organize this data so it can be exported in CSV format. - The script must be well-structured and well-documented for future reference or modification. Your skills and experience: - Proficient in Python, with a deep understanding of web scraping practices. - Knowledge of various data structures and understanding of handling data in CSV format. - Experience with GIS, map data, and geographic coordinates would be a significant plus. - Prior experience with large-scale data extraction projects. Detailed requirements (incl...

...searching for a skilled coder knowledgeable in PHP and MySQL databases to build a custom PHP class. We are currently using an old PEAR class and need a custom class written so we do not need to edit all the calls through the entire application. I have attached an example of a query call so you can see exactly how it is handled. So the class would need to support running this code. This class will need the following operations: - Connection to the MySQL database - Execution of SQL queries - Reading, writing, modifying, and deleting data - Creating and dropping tables - Fetching query results - Handling errors and exceptions Your background should include not only experience in PHP and MySQL, but a deep understanding of database operations and SQL q...

...need of a professional who can assist in changing the database configuration of my Android app from PHPMyAdmin to Eclipse MySQL. This project will involve: - Understanding the current PHPMyAdmin settings in my application and migrating it to suit the MySQL Eclipse environment. - Providing me with the necessary .sql file for the Eclipse platform. Ideal Skillset: - Proficiency in Android app development and database configuration. - In-depth understanding of MySQL and Eclipse platform. - Excellent problem-solving skills and attention to detail. - Proficiency in PHPMyAdmin settings might be beneficial as you need to understand and migrate the existing setup. Note: The MySQL version in use is currently unknown, and additional details about the existing config...

...but also several modifications to the game's existing setup. Key Tasks: - Setting up the Astonia 3 game server on my Linux dedicated server. Previous experience with game server setup is an absolute must for this task. - Implementing modifications or making edits to the established game server to customize for my specific needs. Within the scope of these tasks, a sound understanding of Linux, MySQL, and familiarity with game server architecture will be required. Prior experience with Astonia 3 would be a significant asset. Please provide examples of similar projects and detail your experience with game server setups in your bid. This project requires precise, meticulous execution, and I am eager to collaborate with a professional who can deliver to these standards. spec...

We have a requirement to work with Excel Power Pivot, Power Query Editor and prepare a Report. Very normal report and can be completed within couple of hours by an expert. I can pay maximum of INR1500/2000 for this first project but I will ensure, all my future work will be assigned to you. Looking for someone whom I can bank on for future. Thank you!

...adjust the timing, for example, to every 6 hours. The Java project must include Docker and MongoDB to enable deployment on a hosting service with Docker support. While not required, documenting the project with Swagger will be viewed favorably. technical definitions of the gateway api. 2 main endpoints: -idealista -fotocasa Query param: -String operation (sale|rent). Path parameters: -String id (optional) -String location (required) Examples: GET idealista/valencia Query parameter: alquiler Return all rental properties in valencia GET idealista/valencia/1 must return the property in valencia with id 1 otherwise 404 will be returned. We can discus later some small things about the development, if you need the hosting to do some tests, dont worry, tell me the hosting ...

I'm in search of a capable developer who can competently copy part of my script on Website A and move it to another website. This task should be relatively straightforward as the script is already there; it's merely a case of transferring it. Specifically, the features to be cloned from are the 'Select All' button function located in locations part. The perfect fit for this job would be a freelancer with: -Significant experience in cloning scripts from one site to another -Ability to recreate the 'Select All' button for location selection as featured on the site -Detailed understanding of website structure and a proven track record in script implementation In your proposal, please demonstrate how you've accomplished similar pr...

I'm searching for male and female voiceover artists that naturally have a standard American accent to deliver these commercial script readings I will need 2x Male VO and 2x Female VO I will need line reading samples of provided scripts to send to client before proceeding with project. Thank you!

For days I have been trying to migrate a database (MSSQL to MySQL) using ODBC Datasource Administrator unfortunately this is not successful I get error 1822 "Missing index for constraint". I'm just doing it as an exercise, it's not a business project. I wanted to know if anyone here could help me with this. I also tried with AWS the problem is the same (constraints), it doesn't work.

...existing website based on a template using XHTML, PHP and CSS. The task is to migrate the existing site content, with a new domain name, onto an already purchased WordPress theme and make new links, upgrades and create some additional pages. A variety of WordPress plug-ins are required. Some are to replace existing functions, while others will add new features to the site. In addition, any End-of-Life MySQL and PHP is to be replaced for current versions and new data bases created. All web-pages should use the templates pre-installed in the WordPress theme, including the additional new web pages. The extra pages will enable site visitors to view up to 10 videos, each showcasing a single room or feature, which provide virtual tours of rooms and locations in the property and have ac...

...Components: Searcher 1. Search Query via Twitter, Reddit, Telegram API by links, tags, @, manually search terms 2. Filter settings for search: date (exact, range); type of object ("user", "tweet", etc); number of outputs 3. Trigger settings for searching: manual launch, interval, webhook 4. Scrape objects and their properties 5. Scraper objects validation options: select properties of object 6. Put into db Reply composer 1. Get selected objects and their properties 2. Select integration: API AI selection (OpenAi, Gemini) + their endpoints 3. Editable fields for a particular AI Api query (temperature, max tokens, prompt, etc); fields retrieve defaults values. 4. Compose a ai query 5. Query AI API 6. Get response from AI API 7. Format re...

...ward - Outputting the final product as a video The purpose of the video is for visualization, with a focus on showing the process of using an application, from a patient room, then nurse station, then migration to server room, then monitoring the process at monitoring and control room. The setting is compelling and we aim to create a narrative that highlights these areas accordingly. I have a script ready for a voice-over and would require the freelancer to incorporate it into the animation. Therefore, good understanding of timing and animation synchronization is crucial. The voice would be partly by male voice and part by female voice. Ideal skills and experience would include: - Proven record in 3D animation - Proficiency in 3D animation software - Ability to accurately in...

I require an expert PHP developer with deep knowledge in Shopify API and MySQL. The project will entail connecting to the Shopify API to extract the following information from all paginations in the API into a MySQL DB: - ID - Status - Body HTML (Boolean - if no content, then 0) - Inventory item ID - SKU - Inventory quantity - Images (Boolean - if no images, then 0) - Option 1 - Option 2 - Price - Compare at price This task needs to be completed urgently as time is of the essence. Ideal candidates should have a track record for rapid delivery without compromising on the quality. Previous experience in similar projects will be an added advantage. I look forward to your proposals.

I am looking for a professional with extensive knowledge in selfhosted...premise (you maybe help to fix issues) - we pay (basically the rules of freelancer) Closed book vs open book? We work only on open book. Closed book means you are unwilling to define a WBS for the work and you add only a price tag to the task. We are sorry we will not hire you in such a case! Deliveries? - in our on premise git (access will be granted to you) - full sources (., script or markdown documents for installing gitlab runners) - libs, need prior confirm and we prefer to use mostly latest stable versions - your code is working on our end too - you may require to help us here on setup - we require, depending on availability and on complexity 2-4 weeks test time per milestone. Usually clearly less

I'm facing an issue with my Google Firebase Cloud Function, written in Node.JS. While trying to query a Firebase document collection via document reference from another collection, the function is producing incorrect results. I need this function to execute successfully and return the matching documents. The snag seems to originate while querying the document collection with following kind of scenario: fetch all blogs of an author. So we are running a query in blog document with document reference of AuthorId Skills necessary for this project include: - Proficiency in Google Firebase - Strong understanding of Node.JS - Experience in debugging and fixing code - Proficient in querying document collections I look forward to collaborating with a developer experienced in ...

I need a MySQL database created for my Android recipe app. The database should support the following: - Storing complete recipes - User data For the complete recipes, I want to store the following specifics: - Recipe title - Ingredients - Preparation instructions - Cooking time The ideal freelancer for this project should have prior experience in creating databases for Android apps, a solid understanding of MySQL, and appreciate the importance of structuring data efficiently for high user quality experience.

I am in need of an experienced PHP developer with extensive knowledge in backend development and proficiency with PHP 8. The right fit for this role will have a deep understanding of: - PHP 8: Thorough understanding and proven experience with PHP 8. Your task will primarily involve backend development, to ensure seamless functionality of my project. - MySQL Management: You should be well-versed with MySQL, as you will also be handling the database management system of the project. As a developer for this project, you will handle a lot of responsibility, hence previous work experience in these specific areas is a must-have. Looking forward to your bids!

As someone seeking a more effective way to convey an in-depth understanding of drilling fluids, solids control, waste management and the benefits of digitizing the process, I am in need of a hand-drawn whiteboard animation. The animation will be drawn from an approximately 800-word script, that may be slimmed down if appropriate. - The subject matter is technical, so knowledge or a quick understanding in the drilling industry would be preferable. - Including the provided images of drilling machinery into the animation will be necessary to align with the concept. - This project will require the animation to be 5+ minutes in length to ensure all important points are covered. This role will ideally suit animators with experience creating engaging and detailed whiteboard animation...

I'm in need of a script that is capable of performing two functions: 1. Monitoring the careers page of a specific company 2. Alerting me whenever a new job posting is added. The script is intended to run on an hourly basis, with alerts emailed directly to me each time a new listing is identified. To ensure the script is functioning as expected, it must be able to identify new postings, however the criteria for recognizing 'new' postings has not been defined yet and may be discussed upon hiring. Ideal candidates should possess: - Strong script-writing skills - Web scraping techniques understanding - Experience with automation and email systems When pitching to me, freelancers should include: - A brief outline of their plan to meet the...

I'm urgently seeking a proficient PHP/MySQL developer to tackle several key tasks for my project. Although I chose to skip specifying the exact functionalities, the developer should anticipate working on tasks such as: Work on 45 pages, each very simple. There are 3 main page features: 1. View table from DB 2. Create new record in that table 3. Edit record in that table Most the pages are the same, just a different table. A few tables have some other functionality but it's all very easy. All html design has been done already, you just have to add some PHP/MySQL code to make the pages work with the database. You also need to create the DB, table and records. I also need a script page with the web services to connect the DB to our mobile app. Give...

I need to dockerize the latest version stable and compatible with Dockers and integrated with CAS (latest compatible) for SSO (Google). It 'll works on MySQL Cluster you have already created. 3-4 days to close the task included docs.

Build 2 script one for trading view.

I'm in need of assistance to create a powershell script which will allow me to download a CSV file from a public website that requires authentication. Specifically, there will be the need for an interaction with the webpage - clicking on a specific button to trigger the download. Ideal Skills: - Proficiency in PowerShell scripting - Experience with web automation and interactions, especially button clicks. - Strong understanding of web authentication processes. - Experience in dealing with CSV files

I am looking for a professional with extensive knowledge in selfhoste...premise (you maybe help to fix issues) - we pay (basically the rules of freelancer) Closed book vs open book? We work only on open book. Closed book means you are unwilling to define a WBS for the work and you add only a price tag to the task. We are sorry we will not hire you in such a case! Deliveries? - in our on premise git (access will be granted to you) - full sources (., script or markdown documents for installing gitlab runners) - libs, need prior confirm and we prefer to use mostly latest stable versions - your code is working on our end too - you may require to help us here on setup - we require, depending on availability and on complexity 2-4 weeks test time per milestone. Usually clearly less

As a burgeoning project in demand, we're in need of a Full Stack PHP Developer with a good command of both frontend and backend development. For our backend development, we prioritize: - Proficiency in PHP, MySQL & Laravel When it comes to the frontend, we value: - Experience with Javascript & Web Designing using HTML & CSS. Knowledge on VueJs will be Plus. We're specifically looking for someone at an intermediate level, who has: - A solid grasp of Javascript & PHP. We're excited to welcome a competent, committed developer to our team. Bring your A-game, and let's create something great together.

I'm seeking a video editor with expertise in enriching videos with dynamic transitions and icon animations. The videos will be approximately between 1 to 3 minutes long. These will be used to enhance the appeal of my Kickstarter campaign. I have a provisional script and recorded voice, but I'm open to your suggestions and expert recommendations. - Expertise Required: * Proficient in motion effects. * Skilled in creating engaging, effective Kickstarter campaign videos. Working experience with Kickstarter or similar crowdfunding videos would be an added advantage. Your role will be crucial in making the campaign compelling to potential backers. Looking forward to viewing your portfolio that showcases your skills in the specified areas.

...of an experienced Python developer who can help me with some bugs in a Python script which is a branch of the "" Python script. The script is used to fetch real-time stock data from Yahoo Finance's WebSocket (wss://) for different tickers (eg AAPL, MSFT, etc) that are dynamically changing (a ticker may be added or removed at any given time). Please read what this script does from github in order to be able to understand if you can help. The specific issues which need rectifying include: - Disconnection issues - The script is not refreshing the tickers for which the stock price needs to be downloaded - After a period of time, the script stops downloading the stock data and it acts as if there is no ticker to download

...seeking a talented script writer, proficient in Hindi, to translate English educational modules into engaging and easy-to-understand scripts in colloquial Hindi. The project involves close translation with minimal changes to maintain the integrity of the original content. The main focus will be on corporate training modules. I want script to be converted to natural conversational hindi. Not just using google translate to directly convert English to hindi. The final hindi script should be in colloquial hindi like how we naturally speak while explaining. I want output to be something like this () I can pay upto Rs.10,000 of one hour script Skills and Experience: - Proficiency in Hindi and English - Previous experience in script writing, particularly

Looking for an experienced Telegram bot coder to build a Telegram Bot for Android. Can customise open source script like or others. 1. To read messages from few public channels as per setting. 2. To identify messages meeting the criteria setting to be forwarded. 3. To copy and forward one field to the channel set. 4. Setting i. Add / Pause / Delete Receiving Channel Telegram ID ii. Add / Pause / Delete Forwarding Channel Telegram ID iii. Set the matching criteria and field to be forwarded. Preference for bidder who have built similar bot or experience in using ready open source.

I have ongoing work related to our previous project 'PHP Script Installation for Database Management'

The ideal candidate would: - Have experience in creating custom menu options in Gmail What I Need: - Customize my Gmail scripts to include an icon in the side panel that redirects to my link on clicking. Add 'Approval' and 'Not Approval' buttons, replacing the existing links. These buttons should function as follows: - Mark the email as approved once the 'Approval' button is clicked - Send an email to the approver on marking an email as approved - Add an 'Approval' tag to the email - Notify the approver of the approval Please note, no specific actions are needed for the 'Not Approval' button at this time. Looking forward to working with professionals who can fulfill these requirements efficiently.

I'm in need of a Python programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requirements: - Extensive experience in Python and specifically Python librari...mostly text-based PDF files. Requirements: - Extensive experience in Python and specifically Python libraries for web scraping. - Should deliver the extracted text content in an Excel file. Ideal Skills: - Experience in PDF scraping, especially text-based. - Strong Python programming skills. - Excel file formatting. This will involve working with mostly text-based PDFs and programming a Python script to scrape the text content, and subsequently placing that data into an Excel file. Experience with similar projects will be highly advantageous. The ability to meet deadl...

I'm in need of an expert who can optimize my PHP website for better performance. Currently, a heavy SQL query runs every time a user visits the site, retrieving data about the pages they have visited. This is considerably slowing down my site. I would like the query to be cached into the database and generated every 1 hour through a cron job url. Afterward, the site should pull data from this cached database. Ideal Skills: - Strong understanding and experience with PHP and SQL. - Experience with implementing cron jobs url. - Knowledge of caching strategies, especially within a database. Your main goal will be to improve website performance and ensure user data is accurately retrieved and updated every hour.

I am looking for a developer to create a multilingual WhatsApp chatbot. The chatbot must be built on Twilio, and should be capable of answering user queries promptly and effectively in both Arabic and English. Skills and experience needed for this project: - Proficiency in chatbot development, specifically on the Twilio platform - Experience in designing chatbots that excel in query resolution - Strong command of both Arabic and English in a development context Please make sure to highlight any similar projects you've completed in your proposal, with specific details on chatbot functionality and multilingual support.

...yet functional tool for scraping images from the Google search engine based on user input. The project focuses on providing a user-friendly interface to search for and download images, with additional features for organizing and managing the downloaded images effectively. Search Functionality: Users can input the object they want to search for in the provided search box. The system will then query the Google search engine to retrieve images related to the specified object. Image Quantity Selection: Users have the option to specify the number of images they want to download, with a maximum limit set to 50 images. This feature provides flexibility to users based on their specific requirements and constraints. Image Format Selection: Users can choose the desired format (PNG, JPG...

I am looking to create a 40-50 second HIGH QUALITY animation video within 4 days for urgent presentation need. The animation video will be based on a technical script I have created (for a programming course) that is inspired by the cartoon Avatar the last airbender intro sequence () story board *Opening Shot*: The screen fades in to show a serene landscape with a computer screen in the center, symbolizing the realm of software engineering. *YAGNI - You Aren’t Gonna Need It*: A character representing YAGNI principle emerges. They hold a magnifying glass, inspecting lines of code, and confidently deleting unnecessary features. The background shifts to depict cluttered code fading away. *KISS - Keep It Super Simple*: Another character appears

...minutes, i need introduction and conclusion too. I will provide a google docs script with my short story at the top of the page (this is for context no need for your to put that up), towards the end it says titled script (when you click onto the highlighted text that is where you need to put the full quote which is in the comments on the power point slide). I do not want any water marks thank you. Create a video/ power point presentation with animations, transitions between slides, pop in images, symbols relating to the script. Add my voice over and accordingly add all the aesthetics you must read my script to understand what to include. Add peaceful background music to keep it interesting and not dry. Every time the script is highlighted you must cr...

I am in need of an experienced developer proficient in Pine Script to create a custom alert script for trading view. The alert will be triggered under either of the following conditions: - A price fluctuation greater than 1%, either an increase or decrease(from close of the previous candle), within a 5-minute time frame. This should be applicable to all symbols on my watchlist (over 200). - When the overall size (from low to high) of the current 5-minute candle is twice or larger than its previous candle. I also want the code to calculate the quantity that i should buy or sell if I define the risk. SL will always be below or high of the recent candle body formed. Also I want you to help me understand the code, how i can do the following edits 1. modifying %age 2. modify...

...experience in developing social networking applications for both iOS and Android platforms. I will need the APK file. And I will need you to upload to Google Play store and the Apple App store. Key Features: - The primary functionality of the app will be social networking, sharing relevant content among users and enabling communication and engagement. Plus Live video and audio. The original script that I purchased has both a website and mobile apps, but the mobile apps have bugs and errors and so I want to create our own custom app that works flawlessly. My point is that YOU MAY BE ABLE TO USE SOME OF THE CODE from either the website and/or mobile app scripts. But I am completely frustrated with the current app and it is keeping us from begin successful. Social Media Inte...

We are a rapi...Identify bottlenecks and bugs, and devise solutions to these problems. Help maintain code quality, organization, and automatization. Requirements: Proven experience as a backend developer in Laravel framework. Please include examples of past work or projects. Solid understanding of object-oriented programming and Laravel best practices. Familiarity with SQL/NoSQL databases and their declarative query languages. Proficient understanding of code versioning tools, such as Git. Experience with front-end technologies (such as JavaScript, HTML5, CSS3 and Angular) is a plus. Strong problem solving and critical thinking skills. Excellent communication skills and ability to work effectively in a team environment. Self-motivated and able to work independently with minimal su...

fix server problem. Mysql disk full.

...project, which is approximately 70-75% complete. The project involves a native Android application integrated with a Laravel backend, supported by MySQL. However, there remains a crucial 25-30% of functionality and features that require implementation. Regrettably, due to unforeseen circumstances, we find ourselves unable to finalize the project within the agreed timeframe, placing us at risk of not meeting our client's expectations. To avoid any further setbacks and financial losses, we are reaching out to skilled freelancers like you for your expertise and assistance. If you possess experience in Android development, Laravel framework, and MySQL databases, we urge you to consider joining our efforts to complete this project. Your expertise could be instrumental in...