How to join two tables in mysql with where clause jobs

I'm seeking exp...seeking experienced Javascript and Jquery developers to help create several interactive features on a web platform. The project involves: - Developing dynamic content loading: The platform will require the ability to dynamically load content, including tables, charts, and other visual elements. - Implementing real-time notifications: The system will need to push notifications to users in a dynamic, real-time fashion. - Ensuring full responsiveness: It's crucial that the project be fully responsive across all devices. The ideal candidate will have a proven track record of web development, particularly in Javascript and Jquery, and a strong understanding of user experience and responsive design. You should be able...

...some amendments made to my website Font loading issue At the moment I have a font loading issue with several different fonts being loaded before the final one is loaded. I need one font instantly loaded rather than how it appears currently. I’m happy for this to be a different font (such as one that sits on Google), if it will load instantly, however I want the font still looking good, Lead Form capture not working The form capture isn’t working correctly. Originally it was sending through to my email address when someone filled out a form, however I had my email moved from GoDaddy to Google and it hasn’t worked since. Additionally the form capture doesn’t have the capability to actually see the responses wi...

...and detail-oriented Paralegal to join our team. The successful candidate will assist with responding to complaints, drafting legal documents, and providing administrative support to our legal department. Responsibilities: - Respond to complaints and draft legal documents such as answers, motions, and discovery responses - Organize and maintain legal files and documents - Conduct legal research and provide support to attorneys - Assist with document review and production - Provide administrative support to the legal department Requirements: - Associate's degree in Paralegal Studies or related field - 1-2 years of experience as a Paralegal - Strong knowledge of legal procedures and terminology - Excellent organ...

...User Face Image with Clothing Overlay I am looking for a freelancer who can utilize AI technology and image processing to create a single image that combines a user's face image with clothing overlay. The specific requirements for this project are as follows: AI Technology: - The freelancer should have expertise in image processing techniques to achieve the desired result. API Preferences: - There are no specific API preferences, and the freelancer can use their discretion in selecting the most suitable API for the task. Final Output: - The final output should be a single image that contains the user's face image with clothing overlay. - The clothing overlay should include a t-shirt from a second image and pants from a third...

I'm looking for a legal professional with experience in drafting contracts, specifically wholesale distribution agreements. Your task will involve: - Defining the rights and obligations of all concerned parties, to maintain clarity and avoid any potential disputes in our business relationship. - Including key terms in the agreement like a termination clause, an exclusivity clause, and a liability clause in order to secure our company's interests and limit potential risks. - Providing an open-ended duration without any specific term limit, allowing for indefinite continuation until either party chooses to terminate. This is a vital document for our business, so accuracy, attention to detail...

Focus Edumatics is seeking online tutors to join our growing freelance tutor community across Math, English, Language Arts, and Science. In this role, you will have the opportunity to closely collaborate with K-12 students in the United States, delivering personalized instruction, providing academic support, and creating a nurturing environment. Strong time management, problem-solving, technical proficiency, and exceptional English communication skills are essential for success in this position. COMPENSATION AND BENEFITS -- Rs 200 per completed session-hour. Earn Rs 40,000+ per month based on volume and performance. -- Training, retention, and performance-based bonuses based on quality, volume, and peak hour coverage. -- Teach from home ...

Please Sign Up or Login to see details.

...developer to join our team and help develop a smart contract for a wallet application. The ideal candidate should have experience with Tron blockchain development and be familiar with BIP 39 or BIP 44 for address generation. Responsibilities: 1) Develop a smart contract on the Tron blockchain for a wallet application. 2) Implement functionality for address generation using BIP 39 or BIP 44. 3) Ensure that fees for all wallet transactions, including sending TRX or any ERC10 or ERC20 tokens, are deducted from a specified multiple accounts assigned in the smart contract, and not from user. 4) Also user need to pay the fees to the contract as an escrow, i.e. user will not pay the transaction fee, the transaction fee will be paid by the ass...

We have built a customized website in core php and need another experienced developer to join the team to fix some bugs, We are looking for a very experienced php developer for our project, you must have at least 12-15 years of experience with a good reference . Must have experience in multi-user programming, must know how to do quality coding, fix sql injections Conditions: You must be a independent freelancer. and share with some of your customized applications that u have worked on.

...cinnamon, tea, spices, and coffee – and we're seeking enthusiastic Sales Associates to collaborate with us in finding new wholesale buyers. What you'll do: 1. Find potential wholesale buyers in your region or target markets and build lasting relationships. 2. Discuss product details, ensuring buyers are informed and engaged. We'll provide all necessary resources and documentation to support you. 3. Facilitate seamless communication between buyers and our company. We handle shipping, banking, and cargo, so you can focus on sales. Why join us? 1. Lucrative Commission Structure: Enjoy generous commissions on every sale, with the potential for high earnings. 2. Bonuses and Incentives: Be rewarded for your success ...

I need a PHP script to update an existing PDF file with data from a form. - The purpose is to update information in the PDF file, not generate new ones. - The edited PDF will be displayed once, not saved for future reference. - The data that I'll be entering into the form is a bit more complex than just text. It includes text, images, tables, etc. The ideal freelancer for this project should have: - Strong understanding of PHP. - Experience with PDF manipulation in PHP. - Ability to work with various data types in PDFs. - Attention to detail to ensure the PDF retains its original style, font, spacing, etc.

...who is also proficient in editing to join our team. As a Native Spanish Speaker and Editor, you will play a crucial role in ensuring the quality and accuracy of our Spanish language content. We are seeking someone with excellent language skills, attention to detail, and a passion for delivering high-quality work. **Responsibilities:** - Proofreading and editing Spanish language content for grammar, punctuation, spelling, and style consistency. - Ensuring that all content adheres to linguistic standards and guidelines. - Providing feedback and suggestions to writers to improve the quality of their Spanish language content. - Collaborating with the content team to maintain consistency in tone, style, and ...

I'm looking for a professional who can scrape specific tables on a government website for insurance claim statistics. Key Requirements: - Web Scraping: You should have prior experience in web scraping and can navigate through the website's structure to extract relevant data. - Data Extraction: The main focus will be on compiling data related to insurance claim statistics. The final deliverable should be a well-organized dataset with accurate claim statistics. Please share your experience in similar projects.

...specializes in creating classic rings. We are a Shanghai-based company specializing in jewelry and packaging manufacturing, collaborating with premier factories across China to deliver top-quality products. Currently, we are seeking skilled 3D designers to join us in a collaborative venture. Beyond design creation, we invite you to collaborate closely with us, leveraging your expertise and industry connections to enhance our offerings. Together, we'll craft outstanding designs and provide unparalleled value to our clients. Requirements: - Proficiency in 3D modeling and rendering software - CAD skills - Excellent attention to detail - Commitment to fostering a mutually beneficial part...

I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions based on the respons...

I need a comprehensive and professional formatting of a government project report. This report is aimed at analyzing the effectiveness of current government program...is aimed at analyzing the effectiveness of current government programs, identifying areas for further improvements and suggesting recommendations for future initiatives. The needed formatting requirements include: - Font style and size - Heading styles - Margins and spacing - Including images, tables etc. Ideally, you possess a keen eye for detail and an understanding of government report structures. A background in preparing and formatting formal documents or reports is a plus. The project has to be completed ASAP, so time management skills are crucial. Please bid, outlining your relevant skills and es...

...Microsoft Word Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, ...

Need 2 hours tutoring. I have a wix website and I want to understand how to add and remove blogs on the wix website. please let me know the price for 2 hours tutoring.

...experience with JavaScript frontend frameworks such AngularJS, Stenciljs or React. -Strong Experience with NodeJS and Electron. -Strong knowledge of Relational Database Servers such as MySQL or PostgreSQL. -Some experience with C#. -Experience with microservice based architecture. -Strong coding skills, ability to use BDD and TDD where needed. -Experience and confidence developing RESTful APIs and high-load apps. -Proficiency with fundamental front end languages such as HTML, CSS and JavaScript. -Ability to switch between languages and frameworks. -Knowledge of Agile and Scrum. -Fluent in English. -Nice to have: Google Cloud...

I'm in need of a talented designer who can create realistic mockups of various tables for my home decor line. Key Responsibilities: - Designing and creating mockups for tables - Ensuring the mockups are of high quality and look realistic - Providing a variety of designs that align with my brand Ideal Skills & Experience: - Proficiency in design software such as Adobe Photoshop, Illustrator, or others - Experience in creating mockups, particularly for home decor items - A good understanding of my brand and design aesthetic - Strong attention to detail and ability to deliver high-quality, realistic designs %d7%a9%d7%95%d7%9c%d7%97%d7%a0%d7%95%d7%aa-%d7%a1%d7%9c%d7%95%d7%9f this is reference for the type of design I'm l...

...are seeking a highly skilled and motivated Virtual Assistant to join our team at Ni Hao Babe, a rapidly growing skincare brand. The ideal candidate will be proficient in using ChatGPT, Shopify, research, copywriting, and various social media platforms to help us execute our comprehensive content and marketing plan. Responsibilities: -Content Creation and Management: -Develop and schedule daily posts for Instagram, TikTok, and Twitter. -Write weekly blog posts and newsletters. -Manage and create content for our YouTube channel, including weekly AMA (Ask Me Anything) sessions. Event Coordination: -Assist in organizing and promoting monthly influencer events -Engagement and Community Building: -Engage with followers and respond to comments...

We are seeking a skilled and versatile Multilingual Translator to join our team. As a Multilingual Translator, you will be responsible for accurately translating a variety of documents and content from English into multiple European languages. This role requires fluency in English and proficiency in at least one European language, with the ability to translate effectively while maintaining the original meaning, tone, and style of the content. Fluency in English and proficiency in at least one European language (e.g., Spanish, French, German, Italian, Portuguese, Dutch, etc.). If you are a talented translator with a passion for languages and cultures, we encourage you to apply for this exciting opportunity to jo...

...Needed for Live Video with Advanced Group Chat and Community Feature for Description: We are looking for an experienced developer to create and integrate a new feature into our existing news platform, Medunews.com. This feature will include a live video functionality with group chat, advanced community/group creation options, and a temporary email address blocking system. The design and structure of this new feature must align with the current design of our website, which is built using the CodeIgniter 4 framework and running on AlmaLinux v8.9.0. The web server is Nginx. Project Requirements: Live Video with Group Chat: Implement a live video streaming feature that allows users to broadcast and watch live videos. Integrate a real-time grou...

...a skilled freelancer to develop a Procurement Management App using PowerApps. This comprehensive app will streamline various aspects of procurement, including sales, purchases, offer comparison, offer creation, order recording, item creation, and purchase analysis. Offer Comparator: The app should allow users to upload supplier offers, compare them against existing database entries, and identify the best offers based on configurable conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, and generating...

...Webinars Are you a skilled salesperson with a knack for engaging audiences and driving conversions through webinars? We are looking for a dynamic and experienced individual to join our team and help us sell our 100% job-guaranteed Medical Billing and Coding course. About Us: We offer a comprehensive Medical Billing and Coding course designed to provide students with the skills and knowledge needed to secure a job in the healthcare industry. Our course is backed by a 100% job guarantee, making it a highly attractive option for prospective students. Position: Experienced Salesperson for Webinars Responsibilities: Conduct engaging and informative webinars to promote our Medical Billing and Coding course. Effectively communicate the...

...Microsoft Word Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, ...

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

I'm seeking an individual with excellent typing skills to convert a text-only PDF file into a Word document. The content is not complex; it consists of plain text without images or tables. Key Requirements: - Complete the task within 3-5 days - Ensure the content is accurately typed - Deliver the Word document in a standard text format Ideal skills: - Proficient in typing and data entry - Familiar with Word processing software - Attention to detail in maintaining accuracy - Ability to meet deadlines

...Development with Payment and WhatsApp Integration 1. Website Development (Exclude Content) Overview: Develop a survey website that allows users to register, upload documents, make payments, and track the status of their submissions using a unique tracking number. Additionally, integrate a WhatsApp or chatbot for customer support. Frontend Development 1. User Interface Design: • Create a responsive and user-friendly design that works on all devices (desktops, tablets, mobile phones). 2. Components: • Homepage: • Engaging visuals and clear messaging to capture visitor attention. • User registration, login, and payment links. • Introduction to the service. • About Us Page: • Detailed information about the company's backgro...

...innovative company in need of a Jr. Flutter Developer with 1-2 years of experience, we are seeking a capable individual to join our team on a monthly basis. The successful candidate will work on mobile application projects. Key Responsibilities: - Development of mobile applications utilizing Flutter - Incorporation of high-quality UI/UX Design and seamless User Experience - Efficient integration of third-party APIs - Proper State Management to ensure the application runs smoothly Extra: - Previous experience with Audio Video Call projects will be a plus The ideal candidate must have: - 1-2 years of experience in Flutter development - Strong understanding of UI/UX design principles - Proven experience in API integration - Solid ...

Here is your rare opportunity to make Good Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision a...

...an expert to help configure my Cyclecloud HPC cluster. This is a specific project with the following requirements: - Configuring the cluster for machine learning and simulations tasks - Ensuring the cluster can handle large data processing in a timely manner - Implementing efficient resource utilization strategies - Validating the performance of the cluster with real-world workloads The ideal candidate for this role should have: - Proven experience in configuring Cyclecloud HPC clusters - A strong understanding of machine learning and simulation requirements - The ability to optimize resource utilization and improve scalability - Excellent communication and problem-solving skills read the specs: What I would like to do is to...

I'm in search of a talented individual who can create a series of GIPHY designs catering to two separate businesses. The ultimate goal is to offer a range of animated logos, product animations, and custom illustrations. Business one- body composition and metabolic testing business. showcase the brand and products etc Business 2- breathwork, mindset Key Points: - You'll be working on GIPHY designs for two distinct businesses - The designs should encompass a mix of animated logos, product animations, and custom illustrations - The animated logos should carry elements of modernity, playfulness, and professionalism Ideal Skills and Experience: - Proficiency in GIPHY design and animation - A strong portfolio showcasing a diverse range ...

Hello, I am in need of a skilled technical writer to create a comprehensive user manual. The target audience is "end-users" with an advanced level of technical knowledge and experience. Key Responsibilities: - Develop user-friendly content that meets the needs of the target audience. - Explain complex information in a clear and concise manner. -Diagrams related to logic gates/tables/timing to be drawn Skills and Proficiencies: - Proven technical writing experience in producing user manuals. - Ability to take complex, technical information and translate it for colleagues and consumers who have non-technical backgrounds. - Excellent attention to detail and ability to adhere to style guidelines....

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

TOST is an easy-to-use platform where users can get large quantitative benefits with 10 minutes of work a day. The system ensures the protection of financial data and personal information while enabling risk-free deposits and withdrawals. A deposit of only 30 USDT is required to join, and the compound interest calculation model allows users to increase their account balance with commissions earned by working daily. The purpose of team building is to increase sales and help each other if a problem arises in a WhatsApp group.

I have a PDF file that I need converted into a Word document. The purpose of this conversion is to enable editing of the contents within the file. The layout of the PDF file is quite complex as it contains various images and tables. I would appreciate if the Word document could be formatted in a standard business format. Ideal Candidate: - Proficient in converting PDFs to Word - Experience with complex layout conversions - Attention to detail in formatting - Understanding of standard business formatting

Please Sign Up or Login to see details.

I'm currently in need of a talented Java backend developer who has a strong understanding of databases, particularly MySQL and PostgreSQL. Key Responsibilities: - API Development: The primary focus of the project is on developing APIs that are efficient, secure, and capable of handling high traffic. - Code Modification: The project requires some modification of existing code to ensure seamless integration of the APIs. - Reporting: The backend developer should be able to generate insightful reports based on the data stored in the databases. Ideal Skills: - Proficiency in Java: Excellent understanding of Java is a must. - Strong Database Skills: Prior experience with MySQL and PostgreSQL is necessary. - API Development: A proven ...

...project has some bugs that need to be addressed. The app is crashing on startup and experiencing database retrieval issues. Your task would be to resolve these errors and make the application functional again. - Database Update: You'll need to shift from the current WebSQL database to MySQL and ensure smooth data storage and retrieval. New Features to Add: - User Authentication System: Incorporate a new authentication system to enhance user privacy and security. - Game Timer: Implement a game timer to bring an additional level of challenge and excitement to the gameplay. - Animations & Interactivity: Enhance user experience with engaging animations and interactive elements. Ideal skills for this project: - ...

...developer to make specific improvements to my existing PHP application and enhance its integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom ...

Please Sign Up or Login to see details.

I am urgently in need of an expert in Docparser. I have several PDF documents from which I need to extract specific information in the form of both text and tables. Therefore, the successful candidate must have: - Extensive experience with Docparser - Strong ability to identify and extract specific text and tables from PDF files - Proven track record of delivering tasks promptly Given the urgent nature of this project, applicants who can start and deliver this project ASAP will be highly appreciated. If you are proficient in Docparser and can handle this task accurately and quickly, please bid. ~~~ I have 4 different vendors that we buy from, each having different invoice styles and details. I have all of the pdfs most are ...

I'm seeking a professional web developer, extremely proficient in PHP and MySQL who can upgrade sales and users modules in our POS system. - Abilities: You should have substantial experience and demonstrated proficiency in building complex, user-friendly websites. Your PHP and MySQL skills must be exemplary. - Preferred Framework: I don't have a particular PHP framework preference. You can use the one you're comfortable with.

...company is seeking an experienced Online Marketing Research Specialist to join our team. Here’s what we’re looking for: Product Research: Dive deep into online products, gathering essential details about features, specifications, and availability. Manufacturers and Suppliers: Identify reliable manufacturers and suppliers, ensuring access to top-quality products. Pricing Insights: Analyze pricing trends to empower informed decision-making. Market Understanding: With a sharp eye for product marketing, provide valuable insights into positioning and promotion strategies. Qualifications: Bachelor’s degree in Marketing, Business, or related field. Proficiency in data analysis tools. Excellent communication skills. Join...

We need a versatile designer to join our team with skills across various platforms. Web assets, print, fb/google ads, newsletters, and more. Need skills in both beautiful visual design, but also functional design that will increase conversion rates (CRO) Please provide 1-2 examples of past work that is your best work.

...highly skilled and experienced Salesforce freelancer to join our team and provide up to 12 hours a week of exceptional support for a variety of Salesforce Clouds, including: Sales Cloud Service Cloud Financial Services Cloud Experience Cloud Responsibilities: Manage and resolve incoming Salesforce support tickets with a focus on efficiency and accuracy. Diagnose issues across various Salesforce Clouds and recommend solutions. Leverage your expertise in Lightning Web Components (LWC), Flows, and Automation tools to streamline processes and improve functionality. Collaborate closely with internal teams to ensure seamless ticket resolution and customer satisfaction. Maintain a comprehensive understanding of Salesforce best practices...

I’m seeking a skilled developer to convert my existing PortVB Desktop App into an iOS/Mac Desktop App. It a small tool that runs on a Windows PC and reads some flat XML files and inserts/updates a mySQL database. We need the same program to be able run on a iOS/Mac desktop. I have all the VB Project files/ Source code. - Skills in app development for iOS/Mac, ideally with previous experience in app conversion - Knowledge of data syncing, user authentication, and offline access, in case these features need to be incorporated - Familiarity with contacts management, communication, scheduling, calendar integration, and file/document management functionalities for potential focus areas - Creative design skills to...

...commitment to transparency and professional service. Key Features: - The template needs to have individual fields for 'Client Name', 'Financial Summary', and 'Tax Advice Tips' & a 'performance graph'. - The design should embody a modern and minimalist aesthetic, reflecting our firm's expertise and reliable standing. - We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receives a personalised brochure. It is a tax summary page, with tax saving tips, performance graphs, overall tax positions, etc. - The main thing is having fields we can ...

...Developer to spearhead the development and integration of key system components within our e-commerce platform. The successful candidate will lead initiatives to enhance user interactions by developing a WordPress plugin, building a robust .NET middleware API, and integrating advanced Azure-based messaging services. Additionally, the role involves creating an SDK to facilitate easy integration for third-party AI bot services. This position is crucial for ensuring that our platform not only meets current technological standards but also adapts to future advancements and user needs, enhancing both the scalability and functionality of our services. Responsibilities: WordPress Plugin Development - Design, develop, and maintain a WordPress plugin that integrate...