How to retrieve data from 4 tables in sql jobs

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Deliver...

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

I'm looking for a ticket reservation system to help manage vehicle bookings at my car repair workshop. Key Features: - Customers should be able to specify the type of repairs they need by describing it in a text field. - The system should capture this information, along with the basic details like their name, contact information, and the time they'd like to come in for the repair. Skills and Experience Required: - Experience in building ticketing systems, ideally for a service-oriented business like a workshop or a customer support center. - Familiarity with implementing text fields for user input. - Good understanding of user experience and interface design for a seamless customer journey. - Knowledge in database management ...

...files from a consistent source with a similar layout, containing text, tables, and images. I need someone to efficiently extract this data and compile it into an Excel sheet for easier analysis and management. Key Components: - Extraction: The data extraction process will include obtaining text, tables, and images from the PDF files. - Formatting: The extracted data needs to be accurately placed in an organized and understandable format in Excel. - Consistency: As the PDFs are from a consistent source, it's crucial that the freelancer ensures the extraction is consistent across all files. Skills and Experience: - Proficient in PDF data extraction tools and techniques. - Strong fami...

I'm in need of a Magento 2 specialist to refine the integration of my current TakePayments gateway. In particular, there is a necessity for additional features to be incorporated to optimize my e-commerce operations. Key Responsibilities: - Integration of multi-currency support with the TakePayments gateway in Magento 2. Ideal Candidate: - A freelancer with strong practical knowledge and experience in Magento 2. - Someone who has worked with the TakePayments gateway before and has successfully implemented similar features, particularly multi-currency support. - A conscientious professional who can deliver the task promptly and efficiently. In your application, please focus on your relevant experience — especially wit...

I'm in need of a skilled website designer and content creator to assist with the creation of a detailed, interactive product information guide for our exciting Pontoon Boat company and high-performance aluminum bass boat division. Key Requirements: - The guide will be in the form of a website with interactive features, allowing users to retrieve model information quickly on an iPhone or android phone. - The website must include detailed model specifications, covering dimensions and weight, engine specifications, seating capacity, fuel capacity, as well as standard and optional features - The guide should be comprehensive, showcasing the brand, series, and individual models with specifications, standards, and options Key Skills: - Website design and...

I want to design a car wash, and I want to import the goods from China, but I do not know what is the method, the best quality, and the method of communication. I want boxes for electric tanks that are made of carbon fiber, I want washing materials, I want water pumps, vacuum cleaners, all cleaning tools, and some other things. Ideal Skills: - Proficiency in Chinese - Experience with online dispute resolution - Strong communication skills - Understanding of international commerce and refund procedures

I am in need of a professional photographer who specializes in furniture photography. I have an apartment that I plan to host on Airbnb and require detailed, high-resolution photos of various furniture including chairs, tables, and sofas. This is a 1-2 rooms apartment, and it's essential to have photographs of every area, including the kitchen and bathroom. • Proven photography experience, especially in furniture photography • Ability to create attractive shots that capture the details • Experience in editing photos will be advantageous. • Responsibility to care for the furniture while working around it. • Proficient in effectively utilizing lighting to accentuate the aesthetics of...

I'm looking to leverage Azure document intelligence prebuilt models and train models to extract data from a variety of tax and financial documents. The extracted data needs to be exported into a Google spreadsheet. Additionally, I need an interface for users to easily upload these documents. Key Requirements: - Extract data from various financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balance...

Hi Adrian, Hiring you for Pivotal so I can pay you the $300

PDF File converted to MS WORD File more than 300 pages Need ASAP

I'm searching for a skilled individual who can help me scrape data from a website. The data I'm interested in is text content and tables, specifically contact information. Ideal Skills: - Proficiency in web scraping tools - Strong experience with scraping text content and tables - Expertise in extracting specific information - Familiarity with structured data formats The contact information on the website is in a structured format. Your ability to navigate this and provide me with a clean, organized dataset will be crucial. Looking forward to collaborating with a detail-oriented and reliable professional. Attached is a sample format. The site is: Final file must contain all records for all sch...

As the project owner, I'm looking to transform an image file of a 2D floor plan into a to-scale outline floor plan. For this project, the digitized floor plan should include room measurements. While I didn't specify a preferred software, utilizing a program adept at architectural design, such as AutoCAD or SketchUp, would be beneficial. The ideal freelancer would possess: - Proficiency in architectural drafting software - Experience transforming image files into digital floor plans - Attention to detail, specifically regarding accurate room measurements.

...searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please on...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database per...

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?

Hi Muhammad N., I noticed your profile and would like to offer you my project. 10 videos

Need to copy a powerpoint presentation from a video all the slides theres about 30-40 slides some just images and some some text

I have full code flutter app I want using firebase database 1 -Experience https://console.agora. video and call streaming Also 2- Update app to stores Apple store Android store

...need a skilled Wordpress expert to address a migration issue I'm facing with my website. Here's what I need: - **Migration Issue:** The problem I'm experiencing is related to theme and plugin compatibility following the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep unders...

I'm looking for a skilled professional to create a Web Assembly prototype, , using a small Delphi application that primarily showcases an interactive user interface. The aim is to target the prototype for web browsers. Key Requirements: - Creation of a Web Assembly prototype utilizing a Delphi application. - Focus on showcasing a simple interactive user interface The Prototype: - The user interface for the prototype is envisioned to be simple, consisting of basic elements. - The primary focus should be on the seamless integration of the Delphi application's functionality into a web browser environment.

I need a data studio expert to create a comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversions per key word The report should cover the last 30 days. I prefer a report that represents data in tables and numbers rather than through charts and graphs. Skills required: - Proficiency in Google Data Studio - Strong understanding of Google Ads and meta data - Ability to work with large data sets and visualize information effectively in tables and numbers - Strong analytical skills to draw insights from the data presented

Spain Spanish Recording Project We have a project, that needs Native Spain Spanish speakers, we will give you the text, and you need to record 90 short sentences. you just need to open the platform link, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 5$ for 90 short sentences record. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in...

We need to get service contract of passenger car from authorized 3S dealers. We just need the proper quotation. No need to purchase anything. In total 6 contact.

...need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in...

I'm looking for an expert to take the text from my Word document and incorporate it into my Canva slides. The slides are for a presentation, so it's crucial that the information is presented clearly and with a professional touch. Key Tasks: - Transferring text from a Word document to Canva slides - Ensuring all text is appropriately sized, formatted and positioned within each slide - Adapting the text to fit the existing layout and design of the slides - Keeping the information clear and engaging for a presentation audience Ideal Skills and Experience: - Proficiency with Canva - Excellent attention to detail - Prior experience with creating or modifying presentations - Ability to adapt existing layouts to fit new content ...

I'm seeking an Airtable expert to assist me with a number of tasks, including data entry and organization, building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experience working with Airtable, including data entry and organization, workflow creation, and complex formula design - A strong understanding of how to make the most of the tool, including its integrations and automations Please note that while my exact requirements in terms of the number of tables and views in my Airtable base, as well as specific integrations I need, have not been stated, I expect the freelancer to be able to adapt to my needs and work in an agile manner.

Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people ...

Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuri...

...professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring AD...

...seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this proj...

- Size: 36" high by 48" wide - Plotting and vector cut line - 2 files one with dimensions displayed other with artwork and cut contour lines. - Should be able to change color of each element in file with just click and fill. - Text if there should be editable (words, font and color)

I need someone who knows about monorepo and angular , the application was in angular 10 and I transferred it to angular 17 (dependencies, code, etc.) now it seems to compile but it throws an error NG0908 .I just need them to make me work (run well in ngserve). Please write ragnar to see you read the post.

have anyone can help me to install the Laravel system which buy from themeforest, thanks i will provide the domain and also the login of the hosting, thanks

I have an existing Laravel-based ecommerce application that requires a series of modifications and additions. Key Tasks: - **New Tables & Conditions**: I'm looking to add several new tables and conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience with ecommerce applications. The ideal candidate should be highly proficient in Laravel framework and comfortable creating new tables and conditions within the application. - **Database Management**: A solid grasp on database management is crucial to successfully add and integrate these new tables. Experience with MySQL or other relational databases is desirable.

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

Small update to the android app. Change the payment gateway "cryptomus" to stripe. After that. Compile the code to obtain the apk version and an .aab version that will be used in the Google Play Store. In turn, upload the updated code to the app server. Send me the updated source code as well. The app is made on react Native, and the backend is Python. All the API's are made on Python. This may require modification in FrontEnd. in that case. You must be able to complete the project. Maximum budget $300

...developer to create a solution that automatically plays videos from a website. The software should be designed to work specifically on Windows OS and be compatible with the Edge and 360 browsers. Key Requirements: - The software should automatically play videos from a website, ensuring continuous playback to complete the viewing mission. Ideal Skills and Experience: - Proficiency in software development, particularly for Windows OS. - Experience in web automation tools and techniques. - Familiarity with Edge and 360 browsers. - Understanding of video streaming and autoplay functionalities. If you have previously developed similar software or have relevant experience, please share your portfolio or previous projects in your bid....

Hello, i need help for a Update from Contao 3.5 to the newest version. We must Update PHP 5.6 to the PHP 8.x Version. Thanks

...Analytics specialist who could coach me in the areas of Data Analysis and Data Visualization. The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for t...

I'm a looking for a freelance Flutter developer to assist with my mobile app project. The app is aimed at the general public and requires a few key features: - User Authentication: The app should have a secure user login/signup system. - Push Notifications: Implement a system to send push notifications to app users. - Integration with Databases: The app should be able to store and retrieve data from a database. The primary goal of this project is to create a fully functional mobile app. I'm looking for an experienced Flutter developer with expertise in these specific areas. The ideal candidate should have a solid understanding of mobile app development, particularly with Flutter, and have experience with database in...

...business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be consider...

I require transcription services for English audio or video recordings. I need a skilled transcriber with a good command of English to accurately transcribe audio or video files into text. The quality of the transcription must be high. This job is critical to me and I need someone with a keen ear for detail and a fast turnaround. Key Requirements: - Proficiency in English - Experience in transcribing audio or video files - Attention to detail - Reliability and timeliness - Previous experience with sensitive content is a plus Please bid if you are confident in your transcription abilities and can deliver top-quality work within a reasonable timeframe.

As a student in my final year of Computer Science, I'm seeking a skilled freelancer to help me develop a web application. The project is a web based Pathalogy lab appointment booking system. In terms of the project's key functionalities, I'd like the web application to include: - User login and registration: The application should allow users to create accounts and log in. - Database integration: It is crucial for the system to store and retrieve data efficiently. - Responsive design: The application should be user-friendly and adjust well to different device screen sizes. Moreover, the application should have (CORE FEATURES OF WEBSITE):- - User Profile Dashboard: It should provide a personalized experi...

I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: - Inventory management: Ensuring that the software effectively tracks the inventory of returned products - Reporting & Analytics: Enhancing the software's capability to generate insightful reports about warranty returns. - User access control: Improving the control measures for different user permissions within the software. - Ticket creation, Data Import and Export: Aptitude in handling these features are considered a plus. The overriding purpose of this software is to...

...intensive, manual work project that will take at least 4 hours of dedicated effort of searching through Linkedin / Google/ general web search. Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be sourced from databases such as Apollo.io. Please do not waste your valuable time trying to do either. The criteria are: 1. Top 100 companies which are listed on this webpage : 2. Top 100 companies which are listed on this webpage : The data you will need to fill in are: 1. Name of company 2. Name of founder 3. Company's main website 4. Founder's Linkedin profile URL 5. Founder's emai...

I seek for 20 CAD for the entire project which will be delivered in an hour upon receiving files.

I'm in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities for large data sets.

...prompt/require for Document-URL: and extract all the short abbreviations inner in (....) from entire document(with PDF,...extensions). The report/result will like this table with 2 columns: sentence | terms-founded | string of terms | check-selection | button "do-it" Then I will select the terms by checking and then I will press the button "do-it" and the selected terms founded between (...) will be savet into MysQl Table. So for Document-URL: this is simple example of line from this report -sentence: "With the deployment of the fifth generation (5G) mobile network systems and