Sql query find last order date jobs
...Key Responsibilities: - Managing Email Communication: You'll be required to handle my inbox efficiently, prioritizing messages, drafting responses, and flagging important correspondence. - Scheduling Appointments: You'll handle my calendar, scheduling meetings, calls, and appointments as needed. - Researching Information: I often require quick, reliable research on various topics. Your ability to find accurate and relevant information will be crucial. Other Requirements: - Daily Availability: I need someone who can assist me daily, so please only apply if this suits your schedule. - Communication Tools: I prefer to communicate through email, instant messaging apps, and sometimes video calls, so proficiency in these tools is essential. Ideal candidates for this role w...
I'm looking for a proficient Solidworks expert ready to perform several design modifications in a current project. Since the specifics were not provided, the freelancer should be prepared to handle potential changes such as: - see attachment -Same design as last time, with paddle thickness increased to 1.5mm, and square paddle edge length of 2.5cm. The junction diameter may need to be increased by 2mm. As last time, both files types STL and SLDPRT, thanks!! All the best, -original design is 1mm thick and 2cm its a real quick job for experienced person
We're looking for a talented graphic designer to create a unique and compelling logo for BWC Senior Living Placement, a company that specializes in helping seniors find the perfect living arrangements. Our aim is to make the search for senior housing feel caring, compassionate, and warm, adding a touch of sweetness to this significant life transition. Project Details: Business Name: BWC Senior Living Placement Colors: Black, Yellow, and White, reflecting a classic and sophisticated look. Design Elements: Bumble bee We’d like to incorporate a bumble bee into the logo. This is part of our marketing campaign to create a "buzz" about our services. Additionally, we're tying this in with a Cheerios cereal giveaway, capitalizing on its recognition and nostalgia...
We are looking for women to model our products. Experience is NOT required but is a perk if you have some! Don’t worry about a specific date for the photoshoot. If we choose you, we will pick out a date together! You will be able to keep all of the products that you model and photos will be sent to you incase you want to post them on your personal social media pages! All sizes and races are welcome, we are looking for diversity!
This job will be on a per project basis where you will have 2-4 projects per month. You will only be asked to edit specific scenes where we need VFX/ motion graphics (Not entire videos). We will agree on time and date for deliverables and you can work on your own schedule. Must have experience and should share 1 2 videos
...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...
...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...
...Pages and a Blog * Homepage: Main landing page * Job Board (leverages WP Job Openings plugin) * 4 subpages: 1 for each of our services 1. Employers seeking permanent placement candidates 2. Companies seeking consultants 3. Executive Search 4. Job Seekers * Blog page * Standard blog functionality * Acts as an index * Can add blog posts via Wordpress * Searchable by date, keyword, category, etc. The menu will include links for the homepage, “Our Services,” Job Board page and blog page. The 4 subpages will be linked in a submenu under the “Our Services” heading. The blog menu entry can be removed from the menu so as not to be accessed until I choose to turn it on. Homepage should highlight our 4 services and include royalty f...
...sports professionals, one male and one female. The selected candidates will participate in a content creation project to produce educational photo and video materials for our app. This freelance opportunity offers a chance to showcase your expertise and contribute to a growing fitness community. Key Details: Location: Filming will take place in Cyprus in May. Duration: The shooting period will last for 10 days. Content: The content will focus on basic gym exercises, predominantly without audio instructions. Responsibilities: - Demonstrate proper exercise techniques for filming. - Collaborate with the app's instructors to ensure high-quality content. - Adapt and adjust based on feedback during filming. Requirements: - Proficiency in gym training techniques. ...
Hey, I'm looking for a virtual assistant who is fast and efficient, to help me be more productive. Specifically you will help me with content creation and translation of a website. In order for me to select the best person, here is my tiny hiring process: - Sign up at (this is the tool I'm using for my website) - Create a new website (the content can be totally random) - At the end of the website, add an FAQ section in "Classical" style and add two questions and their responses: "How much do I charge per hour", "A fun fact about me". Answer the questions with your real personal answers - Publish the website and share it with me when you apply for the project This should take you 5-10m max depending on how quickly you understand how to u...
...for responsiveness so the ads show in mobile devices as well or a second option for mobile ads. The buyer or winner of the gig will have a meeting with a specified maximum time as decided by the gig creator. The meeting will be online via video chat (which will need to be incorporated) or meet in person (location must be specified). All payments will be via crypto and admin getting a % of each order. Site will have a referral program which will be in the member panel with unique links and banners. All details given to winning bidder....
...accounting software is at an intermediate level. I'm open to learning from a professional who can help me elevate my understanding particularly in Invoice Management. This one-on-one training session should cover best practices, tips, and crucial functions for efficient use of the Invoice Management feature in Xero. I'm looking to deepen my understanding of how to operate this system effectively, in order to streamline my operations and financial reporting. Freelancers interested in bidding for this project should have: - Extensive experience with the Xero Accounting Software - Proven expertise in training others to use the Invoice Management function - Strong communication skills, with an ability to explain complex concepts in an easy-to-understand manner By the end...
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
I need a tech-savvy freelancer to create a custom thank you page for my Wo...you page for my WooCommerce website. The page should have a particular focus on: - Presenting order details effectively. These details must be displayed within a detailed table, allowing for a comprehensive overview of the purchase made. Ideal skills and experience: - Experience in programming and website development. - Familiarity with WooCommerce and creating custom pages. - A knack for clean, efficient code and attention to detail. - Knowledge in creating user-friendly, intuitive layouts and designs. Please note the client has opted not to include any interactive elements within the detailed table on the thank you page. Therefore, ensuring factual accuracy and perfect presentation of order deta...
...Goodtax. I want to help you reframe your tax experience. Tax may be a burden, but it's a reality. Let's help you change it into a simple compliance matter. Once that your are prepared for. I believe that planning ahead can change the way you pay tax. I can help you stay tax compliant and avoid those last minute deadline blues. You may be any one (or more) of the following: An employee with a side-hussle, investment property, private medical aid membership wanting to get your tax affairs in order. Independent contractor whose salary is subject to PAYE deductions, but incurs trade expenses to get the job done. A sole proprietor responsible for paying all your taxes. A freelancer who has only ever earned a salary but now you’re told that you have to sor...
I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.
Scope of work, SureCart (high level). SureCart, SureTrigger, and S...networking, collaboration, and growth opportunities for SMB- and large corporations, investors, and professional consultants. Mission: Our mission is to empower entrepreneurs, investors, and consultants by providing a platform that fosters collaboration, facilitates meaningful connections, and accelerates business growth. Vision: We envision a vibrant ecosystem where startups thrive, investors find promising opportunities, and consultants contribute their expertise to drive collective success. By implementing the above scope of work, Improve Growth Platform will offer a comprehensive solution for startups, scaleups, investors, and professional consultants to connect, collaborate, and grow their businesses eff...
I have a website which allows customers to order food online but need to make an app from it for Android Google Play and Apple IOS Hybrid seems to be the most cost effective choice NO RIP OFF MERCHANTS PLEASE I CAN SMELL YOU FROM ANDROMEDA GALAXY NO MIDDLEMEN SCAMMERS I WORK DIRECTLY WITH DEVELOPERS ONLY DO NOT BID ON MY JOBS IF I HAVE REFUSED YOU BEFORE No time wasters Serious skilled workers only a meeting call will be absolutely essential to go over the details of the job. Note i have multiple apps needing done but all follow the exact same website structure only the name /address and icon will change basic details
...alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional formatting. I thought making a cell in the below row for the date was the only option - any other options to achieve this? Column A, Row 3 contains Client Name (code), Columns B-K, Row 3 contains th...
...and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over 12 hours. Overtime is paid at 1x between 06.30 and 18.30 Mon-Fri and 1.5x between 18.30 and 06.30 and on weekends. Overtime is paid at 2x on bank holidays and if urgently required last minute. Ideal Skills and Experience: - Proficiency in Excel with a strong understanding of complex calculations and formulas - Previous experience in creating similar spreadsheets for payroll or HR purposes would be highly advantageous - Attention to detail is crucial to ensure the correctness of the calculations The successful candidate will need to provide a user-friendly templ...
We are looking for women to model our products. Experience is NOT required but is a perk if you have some! Don’t worry about a specific date for the photoshoot. If we choose you, we will pick out a date together! You will be able to keep all of the products that you model and photos will be sent to you incase you want to post them on your personal social media pages! All sizes and races are welcome, we are looking for diversity!
Hi Yash K., I've prepared the next page and a document describing it all like the last one.
...application will cater to both iOS and Android platforms, emphasizing a seamless user-experience across all devices. Key Features: - For the admin dashboard, it should facilitate detailed inventory management, effective order tracking, comprehensive sales reports, and a seamless payment/checkout integration. - The app should incorporate a third-party payment gateway for a smooth, secure transaction process. Ideal Skills and Experience: - Proficiency in iOS and Android app design and development. - Comprehensive knowledge of inventory management, sales reporting, and order tracking integration. - Specific experience in designing apps within the grocery sector would be advantageous. - Solid expertise in integrating third-party payment gateways. I'm looking forward ...
...have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this ...
I'm seeking a skilled Python developer who can handle all aspects of SNMP for my project. Key Responsibilities: - Implementing SNMP query and data retrieval - Efficiently managing SNMP trap handling and notification - Developing a robust SNMP agent Your role will be crucial in ensuring that our system effectively communicates using SNMP across multiple versions. Ideal Skills and Experience: - Proficiency in Python - Extensive experience with SNMP (versions 1, 2c, and 3) - Strong understanding of network communication - Previous work on SNMP trap handling and agent development is a major plus If you have the right skillset and experience, I look forward to seeing your proposal.
I am looking for someone who has worked with Elementor Queries before to write a query that does the following ... Our posts have an ACF field called prsona, which is shared with the posts. When posts are created they are created with that ACF field of the creator. Now we want to display posts where the posts prsona field matches the users prsona field.
...recommendations to users, enhancing their shopping experience. Key Features: - Personalized Recommendations: The website should utilize AI to analyze user's browsing behavior, purchase history, demographic info, and other relevant data to suggest tailored products. - Whatsapp Business Integration: A key part of the project is integrating with WhatsApp Business to provide seamless customer support and order processing. - Merchant Dashboard: The platform will incorporate a dashboard for merchants to track sales, manage stock, and oversee their online store. The ideal candidate for this project is a developer with experience in e-commerce and AI integration. Proficiency with WhatsApp Business API and merchant platforms would be highly valued. A strong understanding of fabric ...
As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately....
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
Hello, I need to add a function to this free add-on, the add-on allows to add a start and end date, but I need that start date to be set automatically when I buy it and the end date as well. I need to create 3 options for 3 types of products. - Monthly option (30 days from product purchase). - Quarterly option (90 days from product purchase). - Yearly option (365 days from product purchase). It is quite simple, just add a checkbox to enable these options and the start and end date is calculated automatically when the product is purchased. Plugin for check the code: Thanks a lot. Best Regards.
I'm seeking an entry-level candidate for a full-time customer service, data entry, and sales & marketing role. Key Responsibilities: - Providing top-notch customer service, handling inquiries and resolving any issues that may arise - Accurately entering data, ensuring the maintenance of up-to-date and correct records - Assisting in sales and marketing efforts to drive business growth Ideal Candidate: - Entry-level professional eager to learn and grow in the industry - Strong communication and problem-solving skills - Proficient in data entry and customer service systems - Basic understanding of sales and marketing principles This role offers a competitive salary range of Rp1.500.000- Rp3.500.000 per month and the opportunity to work full-time. If you're a dedicated ...
We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...
I require a professional data scraper, ideally with experience in handling image retrieval. The task will involve sourcing and scraping image data from various undisclosed sources. The type of images to be scraped has not been spec...handling image retrieval. The task will involve sourcing and scraping image data from various undisclosed sources. The type of images to be scraped has not been specified, providing an open spectrum for data collection. However, previous experience dealing with diverse image types is highly beneficial. The deadline for this project has not been outlined, indicating flexibility on the completion date. Ideal Skills: - Expertise in data scraping - Strong experience handling image data - Ability to source from various platforms - Flexibility with time m...
I need someone skilled in search engine optimization, particularly for Google, to enhance the visibility of my study abroad website. I'm targeting a diverse spectrum of users, from high-school students to college students, to professionals who may be interested in international education opportunities. Here's what the project involves: - Developing and implem...in attracting more visitors but also in making sure those visitors take the action we want them to - in this case, engaging with our study abroad opportunities. The successful candidate should have a successful portfolio of similar SEO projects. Any experience within the educational field or knowledge about international studies will be a plus. Solid understanding of Google algorithms and up-to-date SEO pract...
...principles, and security best practices. - Effective communication skills and a collaborative approach to project management, including regular updates, feedback sessions, and milestone reviews. - Demonstrated ability to deliver high-quality projects on time and within budget, with a commitment to customer satisfaction and continuous improvement. **Project Timeline:** - Start Date: [Today] - Expected Completion Date: [end of the week ] **How to Apply:** Please submit your proposal outlining your experience, relevant skills, and approach to building the Crypto Host platform for Bitcoin transactions. Include examples of previous work or portfolios that demonstrate your expertise in cryptocurrency development, particularly with a focus on Bitcoin (BTC). Additionally, provid...
...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...
...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...
...system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart version. The business we operate in is parts for coal and wood fires, this is a business that is reducing overtime, due to environment issues, however, the stove market has recently had a mini boom due to gas prices being high with a record number of new stoves being sold over the last 3 years (we do not sell new stoves, just the parts for these stoves). We expect to see at least another 5 years from this business. We have been told by our current developers we should look at a google shopping program, however, we are concerned the margins are not in the products to compete in this market. We believe there is another way of increasing our business which is to i...
I'm looking for a skilled Python developer who is well-versed in machine learning and GANs to implement a conditional GAN primarily for image generation as a part of my school project. Key Responsibilities: - Utilize Python to develop a conditional GAN. - Find an academic paper from the last 5 years that enhances the vanilla conditional GAN using a simple approach and use this incorporate their approach to this one. - Find a dataset suitable for the task. It's up to you to choose one. Requirements: - Proficiency in Python. Experience using PyTorch machine learning library. - Understanding of GANs and how they can be applied to image generation.
I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in creating dynamic das...
I am looking for a detail-oriented professional to assist me in transcribing text data from Word Documents into an Excel sheet in alphabetical order. Specifically, you will be: - Handling text data from Word Documents - Accurately typing this data into an Excel sheet - Organizing this data alphabetically to aid in easy referencing Experience with data entry and a strong grasp of Microsoft Word and Excel is mandatory. I expect high attention to detail to ensure accuracy in data transcription and organization. Please submit your proposals detailing your relevant experience.
...products brand "COSRAAN". The logo will be applied across various platforms, particularly our e-commerce store. Here are some specifics: - Color Scheme: Incorporate the color blue predominantly in the design. - Style: Unique - Given the brand's emphasis on "unveiling the beauty within your walls", the logo should encapsulate this spirit. - Symbols: No specific symbols are requested given the last question was skipped by the client. However, creativity with incorporating relevant elements affiliated with home and kitchen are encouraged. - Deliverables: Please provide a source file with all relevant fonts and design elements. Please DM me if you have any questions or require further guidance. Ideal freelancers for this job will have a portfolio demon...
...Client must provide written notice to Developer specifying the reason for withholding payment. 7. Termination This Agreement may be terminated by either party upon 30 days written notice to the other party. In the event of termination by Client due to Developer's failure to fulfill their obligations under this Agreement, Client shall only be responsible for payment of services rendered up to the date of termination. 8. Confidentiality Both parties agree to keep all confidential information obtained during the course of this Agreement confidential. 9. Entire Agreement This Agreement constitutes the entire agreement between the parties with respect to the subject matter hereof and supersedes all prior or contemporaneous communications, representations, or agreements, whe...
...comprehensive business analysis report focusing on the following aspects: - **Main Objective**: The primary goal of this report is to identify our business needs, define the scope of analysis, and understand our current business context. - **Audience**: The report will mainly serve our project stakeholders, hence it should be tailored to meet their expectations. I believe that the stakeholders will find the following information most valuable: - **Market Trends and Analysis**: This will help them understand the external factors that may influence our business and its competitiveness. - **Competitor Analysis**: Insights into our competitors are crucial for making strategic decisions and staying ahead in the market. - **Customer Insights and Preferences**: Understanding customer...
...Client must provide written notice to Developer specifying the reason for withholding payment. 7. Termination This Agreement may be terminated by either party upon 30 days written notice to the other party. In the event of termination by Client due to Developer's failure to fulfill their obligations under this Agreement, Client shall only be responsible for payment of services rendered up to the date of termination. 8. Confidentiality Both parties agree to keep all confidential information obtained during the course of this Agreement confidential. 9. Entire Agreement This Agreement constitutes the entire agreement between the parties with respect to the subject matter hereof and supersedes all prior or contemporaneous communications, representations, or agreements, whe...
...efficiently displayed. 4. **Forum Section**: - Create a forum section where users can discuss various topics related to auto parts, repairs, and vehicle maintenance. - Implement user registration, post creation, and commenting functionalities. 5. **Local Car Rental Search**: - Integrate a local car rental search feature allowing users to find nearby car rental services. - Utilize APIs or databases to provide accurate and up-to-date rental options. 6. **Classified Page**: - Develop a classified page where users can post advertisements for buying or selling vehicles, parts, or related services. - Include features such as image uploads, description fields, and contact information. 7. **Responsive Design**: - Ensure the website is mobile...
As a private family office, I need an advanced household budget and expense tracker. The system should possess the following capabilities: - Expense Categorization: Feature to categorize my expenses effectively. (Invoices and cash expense) Suppliers names vertical line and date and all other horizontal. - Budget Forecasting: Capability to forecast budget accurately, helping in forward planning. - Monthly Tracking: Preferably, the system should facilitate monthly tracking of budget and expenses. - Single User Access: The tool will be used by me, so it should support only single-user access. The ideal freelancer for this project should have a strong background in finance technology, as well as experience developing budgeting and expense tracking tools. Particularly, experience with...
Please Sign Up or Login to see details.
...around $3.05 - 4.30 CAD but I would be okay with it being as high as $5.00 CAD per lead. I was previously running two campaigns that were providing me ads close to this cost, however I accidentally deleted one and have not been able to acquire USA-based leads at a price that low since then. Regarding the other international campaign, the lead cost has slowly increased by close to 50% over the last few days despite my not having made any adjustments. Ideal candidates will have stellar records in Facebook ad optimization and experience. However, simply hearing you talk about your expertise is not enough, I need examples of previous work and other proofs to verify. You will be compensated a bonus of 50 cents CAD for every lead acquired under $4 CAD, and $1 CAD for every lead a...
