How to join 3 tables in sql with where clause jobs
...designer to create a sleek and modern 3-page brochure targeting homeowners. This brochure will be used to inform potential clients about our custom home building design process. Key elements for the brochure include: - A visually appealing, modern and sleek design that resonates with the target audience - A detailed explanation of our custom home building process in a clear and engaging manner Ideally, you are someone who: - Has a strong portfolio showcasing modern and sleek design aesthetic - Has experience in designing brochures or marketing materials for the real estate or home building industry - Can come up with creative solutions and engaging visuals to communicate complex concepts in a simple manner This project i...
...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...
I want to rank in the TOP THIRTY google results on average for the following keyword phrases Target Country is USA 1 - Accident Lawyers 2 - Truck Accident Lawyers 3 - Car Accident Lawyers 4 - Boat Accident Lawyers 5 - Construction Accident Lawyers 6 - Lyft Accident Lawyers 7 - Uber Accident Lawyers 8 - Pool Accident Lawyers 9 - Personal Injury Lawyers 10 - Motor Vehicle Accident Lawyers 11 - Personal Injury Lawyer Near Me 12 - Lawyer For Car Accident 13 - Personal Accident Lawyer 14 - Car Lawyer Accident 15 - Attorney Personal Injury Near Me 16 - Accident Lawyers Car 17 - Personal Injury Lawyer Attorney 18 - Car Accident Attorney Lawyer 19 - Accident Lawyer Near Me 20 - Lawyer For Auto Accident This is for the website The ranking must hold for 1 month before escro...
I'm looking for someone to help me create a list of 2000 business contacts from specific websites, particularly names, company names, position, location information, event information, number of events, current events, past events in 2024, and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling a list of business contacts - Ensuring all email addresses are verified and duplicates removed. Note: The focus should be on getting accurate, up-to-date information.
I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.
Hi Semi786, I noticed your profile and would like to offer you my project. We can discuss any details over chat.
...professional to format my entire scientific thesis in Microsoft Word. The document needs to be formatted to a high academic level. This will require the following: - Ensuring the entire document is formatted consistently for a professional and cohesive look. This includes font, headings, and spacing. - Creating and formatting a Table of Contents - Setting up headings and subheadings in the document according to the specified style. - Ensuring font, spaces and tables are properly formatted ensuring a professional look. The preferred formatting details are as follows: - Font: 12pt Times New Roman - Headings and Subheadings: Italicized with the same font size Ideal candidates for this job should have: - Solid experience in ...
I'm in need of a skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. You...
Hi Haider A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Hi Cesar S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
...are the right candidate and agree with the salary. Automated bids will be ignored. About the Role: Are you a passionate WordPress enthusiast who loves design and development? We are looking for a Remote Part-Time WordPress Developer / Publisher to join our dynamic team. This role offers the flexibility to work from anywhere in Pakistan, collaborating with team members to create and maintain stunning WordPress websites. Responsibilities: Design & Development: Crafting visually appealing and fully functional WordPress websites. Content Management: Publishing and updating content across WordPress sites efficiently. Blog Management: Editing, publishing, and maintaining high-quality blog posts. Team Collaboration: Working closely ...
I'm in search of a skilled data analyst with expertise in health and medicine for a comprehensive meta-analysis project - Focusing on the health and medicine subject area - Including data sources from peer-reviewed journals - Presenting the results in graphical charts, statistical tables, and a narrative summary Ideally, you should have experience in: - Meta-analysis, especially within the health and medicine domain - Working with various data sources, particularly from peer-reviewed journals - Proficiency in creating and interpreting graphical charts and statistical tables - Crafting a concise and informative narrative summary from the analysis This project requires attention to detail, critical thinking, and t...
Hi, thank you for joining me :) im looking for a an ONLY Flutter Developer to improve loading time - SPLASH SCREEN thanks you :) <3
I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration
...for a seasoned Python developer who can assist in two main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python...
I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.
...frontend developer to create a cross-platform desktop application for Windows and MacOS using Electron.js. The application will manage audio, text, and video data, and will utilize websockets for backend data transfer. Key Responsibilities: Develop a responsive and efficient desktop application using , JavaScript, HTML, and CSS. Implement and integrate features to manage audio, text, and video data. Ensure smooth and secure data transfer using websockets. Conduct thorough testing to ensure the application is robust and bug-free. Work closely with stakeholders to gather requirements and iterate based on feedback. Provide comprehensive and clear code documentation. Requirements: Proven experience in developing desktop applications with ...
I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Management: Agents should be able to edit and manage their profiles. - Commission Tracking: The system should track and calculate commissions for each agent. The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management...
...Developer to assist with several microservices projects. Your role will involve: - Implementing small to medium-sized features - Fixing bugs - Developing internal tools - Enhancing test coverage Key Responsibilities: - Collaborate with our team to understand project requirements and specifications. - Implement new features and improve existing functionalities in our microservices. - Identify and fix bugs to ensure the stability and reliability of the services. - Develop and maintain internal tools to streamline development processes. - Increase test coverage to maintain high-quality code standards. Requirements: - Strong proficiency in TypeScript and Node.js. - Experience with microservices architecture. - F...
I'm seeking a skilled Laravel developer to bring to life a custom web application that is designed to enhance user experiences through engaging interfaces and real-time functionality. The right candidate for this job will help create a system not only high in performance but also secure and user-friendly. Registry is working, OTP is working, 2fa is working, KYC is working, deposit and withdraw is also working. Overall it's about 1 week of work to fully accomplish this project. Link and details will be shared via chat
I am in need of a knowledgeable SharePoint developer to create a fully functional and aesthetically pleasing site template for my SharePoint online platform. My site is ready, just need to create a template that can be available when I click new site in SharePoint admin centre Please see link below The primary features required for the template include: - Collaboration tools implementation: I would like the site template to have features that facilitate team collaboration such as chat functionality, task management, and calendar integration. - Branding: The template should reflect my brand identity by incorporating my logo and color scheme. In terms of site template preference, I would like the developer to create a template that ca...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "P...
I'm seeking a skilled content writer to craft a detailed and informative article about coffee tables. The piece should be around 1,200 to 1,500 words and cover various aspects of coffee tables, including their history, different styles and designs, and material options. Moreover, I need the article to highlight the distinctions between residential and commercial coffee tables. Key points to consider: - Research and include the origin and history of coffee tables - Discuss popular styles and designs in the contemporary market - Elaborate on the differences between residential and commercial coffee table considerations - Write in a style that's accessible and engaging for a general audience - Must contain 3...
...Google Ads and Facebook Ads Specialist to join our dynamic marketing team. The ideal candidate will have a proven track record in managing and optimizing paid advertising campaigns on Google and Facebook to generate high-quality leads. You will be responsible for strategizing, executing, and analyzing ad campaigns to drive conversions and achieve business goals. Responsibilities: Campaign Strategy and Planning: Develop and implement comprehensive lead generation strategies using Google Ads and Facebook Ads. Conduct market research to identify target audiences and create detailed customer personas. Set clear objectives and KPIs for each campaign to measure success. Ad Creation and Management: Design, write, and test compelling ad copy ...
...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...
...professional and reliable commercial cleaning service that can maintain my premise three days a week. The exact square footage of the commercial space was not provided, hence a site visit may be required to assess the area. You should have: - Proven experience in commercial cleaning - The ability to set and adhere to a cleaning schedule - The ability to handle a wide range of commercial cleaning tasks - Exceptional attention to detail The ideal candidate is someone consistent in delivering top-notch service and understands the unique concerns in cleaning commercial spaces. Looking forward to a sparkling clean working environment! I will supply my own cleaning products for this contract...
We are in need of a Software Engineer to implement the EtherCAT SEMI profile (ETG5003) in a bare-metal ARM microcontroller environment. The target device firmware is written in C and runs on an ARM Cortex-M3 processor. The Anybus CompactCom B40 module is used to interface between the software and the EtherCAT network. You will join a very small team of software developers working on this project. Ideal experience: - C programming - EtherCAT (especially EtherCAT SEMI) - Anybus CompactCom - Bootloaders/Firmware Updates - File Handling
...that introduces the reader to the world of large conference tables. This article should be between 1,200 and 1,500 words, and provide a mix of information and benefits that really sells the concept of these tables. Key Points to Cover: - Introduction to different types of large conference tables available in the market - Factors to consider when choosing the right large conference table - Benefits and advantages of utilizing large conference tables in a professional setting - Article needs to reference l3-5 links which will be provided upon awarding the project The target audience for this article is general, so the content should be approachable and informative to all readers. The tone should be profe...
...skilled writer to draft an informative article about round conference tables. The piece will be aimed at a general audience, therefore, it's imperative that the content is engaging and easy to understand. Key Points: - The primary focus should be on educating readers about the unique benefits and features of round conference tables. - The article should highlight the distinctive qualities of round tables in comparison to other shapes, particularly emphasizing how these tables promote communication and collaboration, and their versatility in seating arrangements. - Article should be between 1,000 to 1,200 words - Article needs to contain 3 to 5 references to certain websites, w...
...content writer to produce an engaging and informative article about square conference tables. The article will serve as an informative resource for a general audience. Key points that should be covered in the article include: - Different designs and styles: The writer should explore the various design options available for square conference tables, discussing contemporary, minimalist, classic, or any other popular styles in the market. - Benefits and features: The article should highlight the practical and aesthetic benefits of choosing a square conference table over other shapes. This could include space-saving benefits, visual symmetry, or ease of communication between participants. - General information: The writer should provide a comprehensive ov...
...developer to join our team and help finalize our ride-hailing application. The app is nearly complete, but we need assistance in implementing and refining our two-way communication system within the match-making component. The ideal candidate will have a strong background in Flutter, Bloc state management, and Node.js APIs. **Responsibilities:** - Debug and enhance the two-way communication functionality in our ride-hailing app. - Collaborate with our backend team to ensure seamless integration with Node.js APIs. - Implement and optimize Bloc state management for efficient state handling. - Ensure the app’s match-making system works reliably and efficiently. - Conduct thorough testing to identify and fix any bugs or ...
...Digital Marketing Specialist to join our team. The ideal candidate will have a strong background in digital marketing strategies, including SEO, SEM, social media marketing, email marketing, and content creation. The candidate should demonstrate a proven track record of successful digital campaigns and possess excellent analytical skills to measure and report on campaign performance. Responsibilities: Develop and implement digital marketing strategies to drive online traffic to the company website Manage all digital marketing channels such as SEO, SEM, social media, and email marketing Create and execute engaging content for online platforms Monitor and analyze the performance of digital marketing campaigns Stay up-to-date with t...
I'm in need of an experienced Web3 developer to join our team and help us with crucial tasks related to our project on the Binance Smart Chain. Key responsibilities include: - Smart contract development: You should be skilled and knowledgeable in Solidity. - DApp development: We're looking for someone who can translate our vision into a user-friendly decentralized application. - Web3 integration: You should have a thorough understanding of and be able to seamlessly integrate our project with the blockchain. Your expertise in and node.js will be a valuable asset in this role. Experience in blockchain development is also essential. If you're keen to be part of an exciting project and ca...
...seeking a highly organized and tech-savvy Virtual Assistant to join our team for a 6-month fixed contract, with the possibility of renewal in 2025 based on performance. The ideal candidate will have experience with content creation and management, using tools such as ChatGPT, WordPress, and social media platforms. This role is perfect for someone who is passionate about technology, fashion, beauty, lifestyle, and the metaverse. Responsibilities: -Assist in planning and executing a comprehensive content calendar for our blog, podcast, and social media channels (LinkedIn, Instagram, TikTok). -Create engaging and high-impact content, including blog posts, social media updates, and podcast summaries. -Conduct thorough research on current trends ...
In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Setting up ActiveMQ for JMS messaging - Configuring it to handle synchronous and asynchronous messaging effectively Furthermore, I plan to utilize SOAPUI Open Source for automated testing of these messages. Your role will be essential in ensuring that the system works seamlessly with this tool. I will be expecting below: Create a framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and...
Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database
...floral designers to join our team and assist with wedding productions. As a floral designer, your main responsibility will be to create stunning floral arrangements that enhance the overall wedding decor. You should have a strong understanding of different flower types, colors, and arrangements, as well as a keen eye for design. Attention to detail, the ability to work under tight deadlines as well as to follow instructions and work well with others on a team are essential. If you are a creative individual with a passion for floral design and have experience in the wedding industry, we would love to hear from you. Skills required: - Proficiency in floral design techniques - Knowledge of different flower...
...who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide ...
...via global free-to-play mobile games. Our mission is to championing social good and the sustainability of our ecosystems through games. Want to join a small but experienced and passionate game dev team as a full stack developer? Develop and manage code and infrastructure such as cloud server, backend databases, APIs, and automation scripts. Help build powerful game ops tools with simple frontend UI. - - - Job Specs: - Create backend solutions and integrate with cloud platforms like AWS and Digital Ocean. - Design and deploy modern frontend user interfaces using the latest UI technologies. - Build secure and scalable mobile app REST APIs. - Manage databases using MySQL and NoSQL. - Use DevOps tools to monitor and scale applications. L...
...digital advertising company based in Israel, seeking a talented and creative freelancer to join our team. We need a skilled copywriter and designer to create compelling ad banners in English for various advertising campaigns. Responsibilities: Write engaging and persuasive copy for advertising banners. Design visually appealing and effective ad banners. Collaborate with our marketing team to ensure the ads align with our branding and campaign goals. Meet deadlines and manage multiple projects simultaneously. Requirements: Proven experience as a copywriter and banner designer. Strong portfolio showcasing previous work in advertising. Excellent command of the English language. Proficiency in design software such as ...
Armenian to English Translator Required for translation
...seeking a talented and passionate Front-End Web Developer to join my team and contribute to the development of Bayard, an AI research assistant web application. As a Front-End Web Developer, you will be responsible for creating and maintaining a user-friendly web interface for Bayard, enhancing the accessibility and usability of the application. Responsibilities: - Collaborate with the Bayard development team to design and implement a responsive and intuitive web interface for the AI research assistant. - Develop clean, maintainable, and efficient front-end code using modern web technologies such as HTML, CSS, and JavaScript. - Integrate the front-end with the back-end API endpoints to enable seamless communication and data exchange. ...
...cutting-edge technology company specializing in web and mobile apps and digital solutions. We are passionate about creating innovative mobile applications that provide exceptional user experiences. Our team is dedicated to pushing the boundaries of technology to deliver top-notch solutions to our clients. Job Description: We are seeking a talented and motivated Part-Time iOS Mobile App Swift Developer to join our team. In this role, you will work closely with our development team to design, develop, and maintain iOS applications using the Swift programming language. This position offers the flexibility of working part-time, making it ideal for candidates looking to balance work with other commitments. Key Res...
To create a precise 3D model of a small-sized charging case for the AirPods Pro 2 in Blender, here's a detailed plan based on your specifications. Specifications Recap: PCB and Battery Dimensions: 33 x 40 x 10 mm AirPods Pro 2 Dimensions: Height (H): 30.9 mm Width (W): 21.8 mm Depth (D): 24.0 mm Design Requirements: The case should connect to the top and be formed like a butterfly. The two circular charging metals at the bottom should be positioned to the left and right. The part of the AirPods Pro 2 that goes into the ears should stick up 15 mm above the case. Steps to Create the 3D Model in Blender: Set Up Blender: Open Blender and delete the default cube. Model the Charging Case: Create the Main Body: Press Shift + A to add a new ...
...designer to join our team immediately. The role involves creating daily orders from templates, designing new product images, and assisting with branding efforts. Responsibilities: Utilize Adobe Illustrator to create and modify designs based on provided templates. Generate new product images for our online listings on platforms like Amazon and eBay. Assist in branding projects to enhance our company's visual identity. Work with provided files and access resources to fulfill daily orders. Input information from spreadsheets into AI templates, adjust text, and save the files as needed. Requirements: Proficient in Adobe Illustrator with a strong understanding of the software. Experience in creating product ...
I need someone to extract the data from a PDF file and build it into a Word document. The purpose of this is to make the content editable. - The PDF is simple, with only text and no complicated layouts, images or tables. - I would like the extracted text in the Word document to have a specific formatting style applied where headings are large, words are small. Ideal candidates should have experience with PDF to Word conversion, and possess skills in editing and formatting. Being detail-oriented is a major plus. Please note that the extracted content must be accurate and the final Word document should maintain a professional finish. Do NOT deliver this as a simple export because I could easily do that. Run grammar che...
Hi OweBest Technologies Pvt., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
PLEASE DO NOT SEND AI DESIGNS A 2D PLAN IS A MUST Seeking a talented interior designer to create a modern and stylish residential bedroom. Key Requirements: - Proficiency in residential interior design - Strong understanding of modern design principles - Experience in creating bedroom interiors The room will have the following 1. King size bed with 2 side tables 2. Large him/her walk-in closet 3. Desser table, for him/her 4. Tv unit – to be opposite to bed Please note 1. room height is 300cm, there is a concrete slab in the middle, the height from floor is 250cm 2. the room has 3 windows, any of these windows can be canceled to make a use of the space
...WordPress Developer to join our team. As a WordPress Developer, you will be responsible for both the frontend and backend development of our WordPress websites. Your main tasks will include creating and editing custom themes and plugins, optimizing website performance, and implementing new features (such as translating plugin language, or overwriting some existing AI features). The ideal candidate should have strong knowledge of WordPress, PHP, MySQL, and frontend technologies such as HTML, CSS, and JavaScript. Responsibilities: - Develop and maintain WordPress websites - Create custom themes and plugins - Optimize website performance - Implement new features and functionalities Requirements: - Proven work experience as a WordPress Developer - Strong prof...
