How to use multiple select statements in sql jobs
I need a skilled logo designer to create a unique, eye-catching logo for my music brand called 'Mazzter'. This brand represents multiple music genres, but quality is our top priority. - The logo should represent the diversity of the music genre yet maintaining a common thread of quality. - Please incorporate the color purple into the design, as it is closely associated with the brand image I want to create. The ideal freelancer for this project should have: - Proven experience in logo design and brand development - Excellent color theory knowledge, especially with the color purple - Ability to interpret and express music genre diversity through visual design.
Product Description: - FamPe is a platform that enables viewers to interact with their influencers through messages and monetary contributions. Adding a monetary contribution prioritizes and highlights their comments/messages. Brand Name: FamPe Brand Values:- - Innovation - Reliability - Efficiency - User-Friendly Logo Style Preferences:- - Audience: YouTube streamers and viewers, ages 15-45, worldwide demographic - Type: Wordmark logo, modern and minimalist - Feel: Exclusive, Professional, trustworthy, cutting-edge - Color Palette: Primary: #EC6A5E, #5156D4, Accent: #EC6A5E (given color palette is preferable, can use any other if you wish) - Typography: Clean and modern sans-serif fonts; should be easy to read - Logo Elements: An element of exclusivity such as a s...
I'm seeking a professional interior designer to help me revamp my living room, kitchen, and bedroom into a traditional/modern style. Key Requirements: - Proven experience with residential interior design - Strong portfolio showcasing traditional design aesthetics - Knowledge of creating cohesive designs across multiple rooms You should be able to: - Understand my vision and translate it into a traditional style - Recommend and source appropriate furniture and decor - Create a design that is both aesthetically pleasing and functional.
I am in search of a talented designer who can navigate through a few uncertainties. Unfortunately, I skipped some essential questions, leaving some ambiguity in specific aspects of the project. Your job: - Adaptable enough to handle logo, brochure, or flyer design since the service needed wasn't defined - Skilled at multiple graphic design styles because a specific theme wasn't selected - Able to derive the best decisions for the goals of the project as the purpose wasn't specified Skills & Experience: - Proficient in modern, vintage, and minimalistic design styles - Experience with brand identity, marketing, and informational designs is a plus - Problem-solving ability and creativity to fill in the information...
I am looking for a photographer with experience in product photography. There are two aspects to this project - 1. educate me on the art of product photography using the equipment I have available to me and 2. photographing products. The applicant should be highly creative and able to suggest original ways to photograph products to be eye-catching and appealing to shoppers in a highly competitive market. Initially this will be a one or two-session project at my location however there is ample opportunity for future work taking photographs for me when I either 1. don't have time or 2. just don't want to do it. The option to take photos offsite is acceptable. This person should be able to capture the ...
Find a solution that does a screenshot from real chrome device to a url and if the URL is not loaded successfully for some reason it will send an alert via SMS. * The device has to be real one and not emulator. VM can be used here. * There will be multiple urls. * The job will be launched every few second. Please provide me a detailed solution how you will plan to do it.
I'm in need of a skilled Swift Engineer to work on a variety of projects with me on a long-term basis. Your primary tasks will be centred around mobile app development, particularly for iOS devices, and will involve using the latest Swift and XCode versions. Key requirements include: - Solid understanding of Swift programming and XCode - Experience with pushing apps to the App Store - Willingness to work during EST time for at least 3 - 5 hours The apps created will have a diverse range of functionalities, including user authentication, push notifications, and in-app purchases. They will cater to a broad audience, ranging from the general public to business professionals. The ideal candidate for this position will have: - Proven ex...
I require a comprehensive set of engineering plans for a...design) The ideal freelancer must have prior experience developing commercial engineering plans and 3D interior designs. Proficiency in relevant software for engineering and design is a must. Strong communication skills are also important as we'll need to discuss the project details and adaptations. Will need engineering plans in 2 days( I have all plumbing , electrical and mechanical information ready) Must be a certified architect. 25% payment will be made after job complete and draft shared, 25% will pay after the city approval, 50% payment will be made after completion of 3D design and rendering. Must communicate and revise any City comments, will need multiple revisions and corrections for ...
I'm currently seeking a talented logo designer who can create a minimalist logo that will be used across my website, printed materials, and social media. The primary color scheme for the logo should be black and white. This is to ensure the logo is versatile and can be easily incorporated into various mediums. Experience in creating versatile, minimalist logos that can be used in a variety of digital and print formats is a plus. In summary, the requirements for this project are as follows: - A minimalist logo design - Suitable for website, printed materials and social media - Primary color scheme should be black and white
I am in need of an experienced Electrical Engineer with a specialty in Combinational Logic. The key tasks for this project will be: - Circuit design with emphasis on combinational logic - System integration capabilities - Comfortable undertaking troubleshooting Your primary role will be implementing Boolean expressions with advanced complexity. You should be experienced with large circuits including multiple components. Ideal Skills: - Circuit Design - System Integration - Troubleshooting - Proficient with advanced Boolean expressions - Experienced with large circuits This project will require a niche set of skills in dealing with combinational logic. If you believe you're a right fit, I encourage you to submit a bid.
...experienced interior architect to design and visualize four 2-storey townhouses, each 100 sqm. These will be let partially furnished to middle-income tenants. Key Requirements: - The design should be modern, purist and minimalist, with a focus on functionality and upmarket style. - The design should create a cozy and warm ambiance while maximizing space utilisation. - The design shall include drawings of the kitchen (excluding appliances which the tenants bring), the stores, the bedroom wardrobes and beds, the L-shaped study desk, the bathroom vanity and the shelf in the upstairs passage (corridor). The design shall also include the patio and the balcony. - The design shall be at a level of detail and including a BoM, allowing bespoke furniture vendors to ...
I'm seeking a seasoned furniture designer to create modern furniture models for multiple rooms in my newly constructed home. Specifically, the project involves designing furniture for the five bedrooms, foyer, living room, dining room, entertainment room and one lounge Ideal Skills and Experience: - Previous experience with furniture design. - Strong knowledge of contemporary, modern styles. - Familiarity with designing furniture for bedrooms, living rooms, and dining rooms. Project Goals: - Ultra Luxury furniture design required - To create unique, practical, and modern furniture designs for a bedroom, living room, and dining room. - To have preliminary sketches within two weeks. Please, include a portfolio of past projects. Looking forward ...
I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has ...
I am in need of an experienced React Native developer to create an e-commerce app compatible with both iOS and Android platforms. The project is expected to: - Transform my existing design into a functioning - Implement necessary features and functionalities for a seamless shopping experience - Ensure smooth compatibility and performance on both iOS and Android Your primary responsibility in this project will be to bring my design to life, with a focus on delivering a high-quality e-commerce app that is efficient, user-friendly, and visually appealing. Experience with e-commerce app development, React Native, and the ability to work across multiple platforms is a must. You need to create a project from scratch You've ...
I'm looking for a professional website developer to create a straightforward e-commerce platform for my business. The site will primarily serve as a virtual store for my products and services. Key Requirements: - The website should have a user-friendly layout that appeals to customers - It should incorporate a simple checkout system that supports multiple payment methods - I plan to initially list between 1-10 products, so the site should accommodate this range - The payment gateway should be capable of handling diverse payment methods including Credit Card, PayPal, Bank Transfer, and UPI - The design should be minimalist but engaging, prioritizing product display and secure payment options Ideal Experience: - Proficient in e-commerce website devel...
...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 image. Ideal Skills and Experience: - Proficiency in image processing algorithms and techniques. - Familiarity wit...
I'm looking for a skilled designer to create a design of my 8 dogs faces and 1 cat with a title above their faces that says “Mistress of the” and then all their faces scattered like a collage on the bottom of the baseball cap that will be used for both digital print and embroidery. Attached are the pictures of the 8 dogs and 1 cat Key Requirements: - Design Style: The design should be artistic and illustrative, rather than text-focused or logo-centric. - Placement: The design is intended for both the front and side of the baseball cap. Ideal Skills: - Strong artistic and illustrative design abilities. - Experience with designing for print and embroidery, particularly on clothing items. - Understanding of how to optimize a design for placement on a b...
...seeking a skilled freelancer to help me connect them for a home automation project. Key Responsibilities: - Implement a system that can control lighting, monitor temperature and provide security surveillance - Ensure the system can be powered using solar, wind, battery and be connected to the internet. The ideal candidate should have experience in: - Arduino and BBC Micro:bit programming - Home Automation projects - Solar and wind energy integration - Internet of Things (IoT) connectivity - Strong understanding of security surveillance systems Your role will involve setting up a reliable, efficient and user-friendly home automation system. The ability to integrate multiple power sources and ensure the system is internet-connected is important. My g...
NO PLACEHOLDER BIDS! I am looking for a freelancer who can set up a perfect system for me to maintain wordpress sites. Existing plugins can of course be used. Requirements: - Automated updates of plugins and CMS of Wordpress pages after connection - Automatic backups of websites before updates. It is important that the websites do not have access to each other's backups. - Automatic uptime check - Automatic malware check (if possible, e.g. by Ninja Firewall) We currently use MainWP and also have Pro versions for this. Likewise for BackWPUp. It is important to me that the freelancer has experience with this and provides me with precise solution proposals.
I'm in need of a mechanism design expert who can assist me in creating a small mechanism. The purpose of this mechanism is to move objects, and it will be operated manually. Key Responsibilities: - Detailed force analysis: An important aspect of this project is a comprehensive force analysis to ensure the mechanism functions as intended. Hand calculations to be included. - CAD Model: The CAD model should be of intermediate complexity with multiple components and moderate detailing. - Concept Sketches: Creating detailed concept sketches which will guide the design process. - Materials & BOM: Selection of materials suitable for the mechanism and creating a Bill of Materials. - FEA: Performing Finite Element Analysis to evaluate the p...
...proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of incom...
1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page
...developer to create an AI customer service chatbot for my business. You will be using OpenAi api. You will need to extract all email from our gmail account to train the model. The model should be able to create response to customer queries using the training data. This will be a chrome extensions. The primary functionality I need is for it to be able to effectively respond to frequently asked questions (FAQs). Key Project Details: - Platform: The chatbot should be developed specifically for my business - Functionality: The primary function of the chatbot should be to accurately answer customer's FAQs. - Language Support: I am not sure if multiple languages will be required at this stage, but the ability ...
...marketer to help me achieve multiple goals for my business. Your focus will be on increasing website traffic, generating leads, and boosting brand awareness across local, national, and international customer bases. My budget for this project is between $500 - $1000. Key Responsibilities: - Develop and execute a strategic digital marketing plan focused on increasing website traffic, generating leads, and improving brand awareness. - Tailor the marketing strategies to effectively target local, national, and international customer segments. Key Requirements: - Proven experience in driving website traffic, lead generation, and brand awareness through digital marketing. - An understanding of how to effectively target and engage multiple cust...
I'm in need of a professional Magento 2 developer to finalize a payment module for my e-commerce store. The module is intended to provide the following key functionalities: - Payment processing: The module should be able to effectively process payments for products purchased on the site. - Seamless checkout experience: I'm looking to ensure a smooth and hassle-free checkout experience for my customers. - Support for multiple payment gateways: The module should particularly include TakePayments, but also be adaptable to integrate with other gateways in the future. The ideal candidate for this project should have: - Proven experience and expertise in Magento 2 development - Previous experience with implementing and c...
I'm in need of a seasoned professional who can expertly run Google Ads campaigns targeting active pharmaceutical ingredient (API) marketing at multiple exhibitions. Key Requirements: - Proficiency in running location-based Google Ads: You should have a proven track record of running successful campaigns at pharmaceutical trade shows, industry-specific exhibitions, and across various countries. - Understanding of the pharmaceutical industry: Knowledge of the industry is a must, especially in relation to marketing APIs. - Worldwide targeting expertise: You will be tasked with targeting countries like the United States, China, Germany, MENA regions (Gulf Cooperation Council (GCC) and North Africa) and Latam regions (Mexico, Brazil, and Argentina). Y...
...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 assigned accounts...
I need a skilled developer to create a robust e-commerce website that caters to my business needs and has the ability to scale as my business grows. Key Features: - E-commerce Focus: The primary goal of this project is to create a fully functional e-commerce platform. - Payment Integration: I'm looking to integrate credit card and cryptocurrency payment options. These should be secure, reliable, and user-friendly. - Scalability: The website should be designed to accommodate a growing product base. Although the exact number of products isn't defined, the website should be built with the potential for a large inventory. Ideal Skills and Experience: - Proven track record in building e-commerce websites, preferably with scalable fea...
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.
...talented graphic designer to create a unique logo, which will be primarily used for print materials. Key Responsibilities: - Designing a professional, eye-catching logo that suits the print medium - Incorporating my specific color scheme into the logo Ideal Skills and Experience: - Extensive experience in graphic design, particularly with logos - Strong understanding of color theory and how it applies to print materials - Ability to create visually appealing and memorable designs - Strong portfolio showcasing previous logo designs, particularly those used for print - Good communication skills to understand and incorporate my color scheme, and to provide multiple options if needed. Please include a link to your portfolio ...
We have a selection of AI images that need to have a transparent background to enable use within our business. Standard removal tools in Photoshop remove too much of the actual image.
Global Sales Opportunity! Do you love food? Do you love sales? We're a Sri Lankan company crafting exquisite Ceylon 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 sal...
Hi Hossein, I enjoyed our phone call and clearly you know what you are doing. I like your idea of producing a cloned Vue 3 component that received the same input variables as the existing component, that is a _child_ of the existing component. That way you can do the development of the ...enjoyed our phone call and clearly you know what you are doing. I like your idea of producing a cloned Vue 3 component that received the same input variables as the existing component, that is a _child_ of the existing component. That way you can do the development of the new component, without interfering with existing functionality. I would like you to implement this for me in my app as proof-of-principle. I know you are busy with multiple projects so I am flexible on timing...
I'm in need of a skilled web developer to create a web3 crypto sports betting website for me. The site should have the following features: - User registration and login system - Real-time odds for different sports like Football, Basketball, Tennis, and Cricket - Support for multiple cryptocurrencies for betting Additionally, I'd like the site to have the functionality to: - Offer a cash-out option - Seamlessly integrate with social media platforms Ideal candidate should have experience in developing betting websites, be knowledgeable in web3 and cryptocurrency integration, and have a good understanding of the sports betting world. Your design should be user-friendly and secure. Looking forward to your bids.
...looking for a talented native Spanish speaker 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 ...
We are looking for a talented UX/UI designer to create a simple mobile app. The main function of the app is to receive notifications, similar to emails or SMS. A total of 12 layouts need to be designed. The logo and colors are already finalized, and there is an existing old design in Figma. Requirements: Experience: Proven experience in UX/UI design for mobile apps. Design: Simple, intuitive, and user-friendly layouts based on the existing Figma design. Compatibility: Designs should be suitable for both iOS and Android. Components: The layouts must include all necessary components for notifications, such as: Sender logo Sender verification status Timestamp formatting Title and short description of the notification Notification category Required L...
Preparing financial statements for the year 2023 typically involves gathering data from various sources such as income statements, balance sheets, and cash flow statements. This data is then organized, analyzed, and compiled into the appropriate financial statement formats following accounting principles and standards. Additionally, any necessary adjustments or reconciliations are made to ensure accuracy and compliance with regulatory requirements.
I'm seeking an experienced WordPress developer to craft an e-commerce website primarily using Easy Digital Downloads. Here's what I'm looking for: - Create an intuitive and seamless e-commerce experience. - Integrate Easy Digital Downloads as the core marketplace plugin. - Set up multiple Indian payment gateways, such as Net Banking, BHIM, GPay, and Phone Pay, ensuring security and ease of use. - Optimize site for performance, scalability, and SEO. Ideal Skills: - Proficiency in WordPress & Easy Digital Downloads - Experience with payment gateway integration - Strong portfolio with e-commerce examples - SEO and performance optimization expertise The successful freelancer will demonstrate a strong understanding of e-commerce strategies, part...
We have a custom plugin that integrates with a MVNO (mobile phone company) to activate mobile phone plans. Currently there is a bug that at checkout, the plugin charges the CC (reserves the money) and then it should activate a phone line and create a PDF with QrCode and then capture the money but it doesn't activate the phone line or send the pdf. We also want to integrate a few new suppliers via their API so we need new functionalities added to the plugin. -woocommerce plugin FIX - linux management - deploy on linux, create new features - long term maintenance Gitlab version control - create pipeline to our staging server and do version control RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of ...
...designer who can adjust my logo to fit specific dimensions of 50.8mm (height) and 20mm (width) with high density, suitable for both print and digital use. The final version of the logo should be available in JPEG, PNG, SVG, and ai formats. Key Requirements: - Adjust the size of the logo to 50.8mm (height) and 20mm (width) while maintaining visual integrity and enhancing the density for crisp display. - Deliver the adjusted logo in high resolution, suitable for both print and digital use. - Provide the final logo in JPEG, PNG, SVG, and ai file formats. - Ensure the logo is visually appealing and professional, reflecting the original branding. Ideal skills and experience for this job include: - Proficient in graphic design software...
I'm looking for a skilled iOS developer to create a billing app using SwiftUI and Combine. The Android app's development build will be provided, which includes a screen showing a list of the APIs with details like requests, headers, etc. There are multiple modules in the app, such as Accounts, Customers, Stock, etc. We can set milestones based on these modules. The project is already set up, and some functionalities are already working, including the API layer. The code is very clean and easy for any developer to understand. Further details will be given on a call. We need a productive developer who creates pixel-perfect code. Experience does not matter; you must test the features you create.
I'm looking for a talented developer to create an online examination platform for my educational organization. Here are the main features and requirements: - Support for multiple question types: The system should be able to handle various question types such as multiple choice, true or false, and fill in the blanks. - Extensive subject coverage: The examination will cover more than 10 subjects or topics. - Automatic grading: The platform should have a robust automatic grading feature that can handle all types of questions, not just multiple choice and true or false. The ideal candidate is someone with a strong background in web development and experience in creating online examination systems. The ability to create a ...
...company committed to providing high-quality educational cartoon videos for children worldwide. Our mission is to foster learning and development in young minds by delivering engaging content in multiple languages. Currently, we offer educational materials in six languages, including English, Arabic, Pashto, Persian, Urdu, and Dari, with plans to expand to encompass 100 languages in the future. - The main purpose of the site will be to showcase our educational cartoon videos. There won't be nursery and childcare services offered through the website, it's strictly for displaying our work. - Visitors should be able to interact with the site in a way similar to the YouTube Kids platform. Th...
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.
We want to distribute our OpenGL-Based media server software via Linux. Appimage looks like a usable way to deploy on multiple distributions. We target solely x64 architectures. The software uses OpenGL, video capture, audio output and input and connects to IO devices via USB. We already have a working .deb workflow and it would be great if you could create an appimage workflow for us that we can introduce into our deployment.
I require data entry services targeting both English and Malayalam languages for a medium volume of content sourced from digital files. As such, potential bidders sh...targeting both English and Malayalam languages for a medium volume of content sourced from digital files. As such, potential bidders should have the following: - Proficiency in written Malayalam and English to ensure accurate and efficient data entry. - Basic IT skills to navigate and extract data from digital files. - Attention to detail, ensuring data is properly entered without errors. - Experience in the field of data entry, especially if done in multiple languages. Your role will primarily involve transferring data from digital files into our designated format. Please s...
I'm seeking a professional auditor to conduct a comprehensive annual financial audit for my company in Vancouver, Canada. The primary goal of this audit is to validate financial statements, with a keen focus on the balance sheet, income statement, equity, and cash flow statement. Ideal Skills/Experience: - Proven experience in financial auditing, particularly annual audits - Excellent knowledge of financial regulatory compliance - Skilled at identifying financial irregularities - Proficient in reviewing and validating balance sheet, income statement, and cash flow statement. This engagement will require a meticulous individual who can handle the complexities of a comprehensive financial audit while upholding the highest degrees of pr...
I'm in need of a skilled web scraping expert who can help me compile a database of local businesses. The data I need should include company name, physical address, email, phone numbers and their social media profiles. Key requirements: - Data extraction from multiple websites: I'm looking to collect this information from a variety of sources, not just a single site. This will require the ability to navigate various structures and formats, so experience with diverse web scraping is a must. - Targeting local businesses: The focus of this project is to gather data specifically from local businesses. This implies you should have the know-how to identify and extract data from these specific types of entities. - Data fields: The most c...
In essence, you'll be taking materials from me and uploading them to multiple TikTok accounts. That's the job in a nutshell. I'll provide you with instructions on setting up the phone and explain everything in detail. It's not a difficult job to understand. YOU MUST HAVE AN IPHONE.
