Sql stuff group by jobs

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

...Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. This job will part-time as a test period, after that it will be full-time. First, there is a task I’ll give as a test. Payment for part-time during trial period: Fee: 250 USD Performance bonus: 50 USD (how many times you make mistakes, how much time it takes to do stuff, etc) Results bonus: 50 USD (how many of X, Y, and Z do you deliver successfully) Commissions: 100 to 300 (after the first month) If your work complies with my quality requirements, and you give more than asked, a 110% you’ll get performance and results bonuses each month. After a two-month period, your fee will increase to 350 (plus the same bonuses and comi...

...into a distinct group photo. I require precise merging skills to blend the person naturally into the intended image. Specifics Include: - I do possess both the images that need to be worked upon. - The critical change is to incorporate an individual from one picture into a group photo in an unnoticeable and flawless technique. - I want the person from the first image to be precisely positioned next to a specific individual in the group photograph. The ideal freelancer for this project must have extensive experience in photoshop or equivalent photo editing software, a keen eye for detail, and a strong understanding of lighting and shading to match the added person within the group setting. Additionally, patience and meticulousness to accurately place the pe...

...with the most customers. Pie Chart of Customer Age Groups: Illustrates the distribution of customers by age group. Map of National Customer Reach: Highlights the states from which customers visit. I need a comprehensive geo-targeting report for a US-based business. The report will primarily focus on a specific city, state, and country, delving into neighborhood-level and county-level details. Key Requirements: - **Geo-Targeting:** The report should provide a detailed understanding of the demographics and market behavior of the specified locations. - **Competitor Analysis:** This will involve a thorough investigation of the market, outlining the competitive landscape and the strategies employed by competing businesses. - **Customer Behavior Data:** I would like the...

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.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

As an owner of a Wordpress site, I'm currently looking for an Elementor specialist who can assist me in overcoming some issues I'm experiencing with the Elementor plugin. After updating a group of plugins, Elementor has been struggling to work as intended. Specifically, here's an overview of the challenge: - Elementor Edit fails to load properly While I'm not getting any explicit error messages, I need someone who can help with troubleshooting the problem and get Elementor back on track. Desired Skills: - Proven experience with Wordpress - Strong skills and experience in troubleshooting Elementor plugin - Solid problem-solving capacities Your task will involve analyzing the problem, troubleshooting, and ultimately fixing the issue that's causing this...

I'm looking for a creative individual who can craft engaging social media posts for my business targeting individuals aged 18 to 45. The primary platforms are Instagram and TikTok, but content will also be shared on Facebook and Twitter. Key Responsibilities: - Develop content for Instagram and TikTok that resonates with our target demographic - Create posts ...Strong creative writing skills with an understanding of different social media platforms - Ability to tailor content for different target audiences - Understanding of how to drive traffic from social media to a website This role is perfect for a content creator who understands the nuances of social media, can adapt to different platforms, and knows how to create engaging posts for a broad age group. My website

I'm seeking an experienced AI specialists to develop AI models specialized in some rules in object detection and tracking 3 cameras at restaurants. Your task will be creating AI models with some rules: In the restaurant, there are three areas with cameras: 1) kitchen: staffs must wear hat, food drop on the floor, and food dropped on the floor and pick up for customers 2) cashier: stuff cash into pocket 3) at the door: customers walk in and the time they are seated. - Alerting staff when any tasks compliance aboved (ex: people with no hat, food is dropped, dropped food is put back on dishes to serve customers. Each AI model should provide an immediate visual notification, aiming for rapid response times. Additionally, the system should automatically notify the manager to ensur...

I'm looking for a skilled social media manager to help me grow my Facebook group specifically targeting local community members in the United States. Key Responsibilities: - Implementing strategies to increase the group's membership - Engaging with the audience and fostering a sense of community - Delivering a regular flow of content that is relevant to the local community I'm specifically interested in a freelancer who: - Has a solid background in social media management and growth - Possesses experience in creating and curating engaging content - Understands the nuances of community building on Facebook Ideal Deliverables: - A noticeable increase in the group's membership within a specified timeframe - A boost in the group's engagement levels - Consis...

...convey is about the importance of inclusivity and kindness towards others. Key Points: - Target Audience: The book is aimed at preschoolers, so the language, tone and story complexity should be suitable for this age group. - Theme: The central theme should revolve around inclusiveness and kindness. - Character: I want the story to be told through children as characters. This will help young readers relate to the story better and understand the importance of the message. I'm looking for a writer who has experience in writing children's books, especially for the preschool age group. It's important that the language is simple, engaging and age-appropriate. The ideal candidate should be able to craft a story that is not only entertaining but also educational,...

I'm currently seeking a skilled developer to create an e-commerce platform, named "yuk pencet", tailored towards young adults aged between 18 and 35. The primary feature that I'm looking to include in this platform is product customization. Key Requirements: - Develop an intuitive, sleek e-commerce platform that aligns with the preferences of the specified age group - Implement the product customization feature in a user-friendly way, ensuring it's engaging and easy to use Ideal Skills and Experience: - Proficient in e-commerce platform development - Prior experience in creating platforms for young adult audiences - Expertise in integrating complex customization features - Strong UI/UX design skills - Knowledge of best practices for e-commerce SEO This p...

...Insta-Icon and red "bubble" can be hard coded in template * Page Template Footer ** hard coded button: "Jetzt Kontakt aufnehmen" with link to "contact" page in page tree ** hard coded link: "Impressum" with link to "impressum" page in page tree (hidden in menu) * Content Elements: ** Please style the "Text with media" appropriatly (see ""): Image, Headline etc ** Element "Card Group" to display a variable amount of Elements "Card" (preferred Extension: b13/container). In FE it should (for Desktop) display 3 Cards and if more than 3 Crads avauilable: left/right arrows to slide through the cards (see "") ** Element "Card Image" (1 Image, Link; see left element in"&q...

I'm looking for a Turkish language specialist to improve the phrases and sentences used in my language game. The goal is to make the language more natural and engaging for teenagers, the primary age group of my game. This is to be done specifically for written dialogues or subtitles, to help players develop their language skills as they play. Ideal skills and experience include: - Proficiency in Turkish language, both written and spoken, with a strong understanding of the nuances and idiomatic expressions used by teenagers - Prior experience in localizing or adapting content for language learning purposes - Understanding of game mechanics and how language affects player immersion Key responsibilities will include: - Reviewing and revising the existing Turkish language ...

I'm in need of a highly-skilled translator, with native Spanish proficiency, to assist with the translation of a legal document. Key Requirements: - Native Spanish Speaker: I require someone who is a native Spanish speaker to ensure the translated text is both accurate and culturally appropriate. - Legal Expertise: Ideally, you should have experience translating legal documents, or a background in legal studies to ensure the translation is precise and legally sound. It's important for me that the translator is able to stay true to the original meaning of the document while ensuring a high level of accuracy. The successful candidate should be able to provide a professional and polished translation that captures the legal terminology accurately. Please provide examples of simila...

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

I need English speakers from across the globe for a two-month recording project aiming to record scripts through a conversation. Scripts to record regard many subjects like healthcare, business, games, law and tourism. Recordings will be performed through an app between two peoples forming a group, so teams of many english speakers are welcome, but if you are not a team and you have a person like a friend or a brother with whom you can record, you are still welcome to apply. Check the form joined below to know more about the project.

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quick...the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task on Cypress Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress Test Cases Immediately Required. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...

...Specifically, the mother's presence in the photo needs to be completely erased. She is in the floral dress second from the left. - Rearrange group: Following the removal, I'd like the remaining group members to be slid closer together to maintain an aesthetically pleasing and balanced composition. - Enhance visual elements: Lastly, an augmentation of the skin tone and texture for the father and children in the photograph should be performed to bring out their best features. Someone with expertise in photo manipulation and facial retouching software such as Photoshop or Lightroom would be an ideal candidate for this task. An understanding of group composition techniques would also be beneficial. Previous experience in family photography editing is highl...

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 4 Send the new URL of the subpage change to the created group through the telegram machine

...My primary goal is to drive traffic to my website through engaging content that's appealing to young adults aged 18-24, my target audience. Key Requirements: - Create entertaining Instagram reels: The content should be captivating and fun, encouraging viewers to interact and visit my website. - Understand the target audience: Having a good grasp of what appeals to young adults in the 18-24 age group is crucial. - CTA integration: The content should creatively integrate calls-to-action that prompt viewers to visit my website. Ideal Skills and Experience: - Proven experience in creating engaging Instagram content. - Strong understanding of young adults' behavior and preferences. - Ability to create content that drives actions and conversions. If you're a creati...

...My primary goal is to drive traffic to my website through engaging content that's appealing to young adults aged 18-24, my target audience. Key Requirements: - Create entertaining Instagram reels: The content should be captivating and fun, encouraging viewers to interact and visit my website. - Understand the target audience: Having a good grasp of what appeals to young adults in the 18-24 age group is crucial. - CTA integration: The content should creatively integrate calls-to-action that prompt viewers to visit my website. Ideal Skills and Experience: - Proven experience in creating engaging Instagram content. - Strong understanding of young adults' behavior and preferences. - Ability to create content that drives actions and conversions. If you're a creati...

I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.

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

Hi SEO Solutions Group, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates property listings between these two platforms. Ideal Skills: &bull...

I'm creating a personal prom short film and require a filmmaker that can create a pre-prom montage focusing on family and relationship. In this short social media film, a distinctive scene needs to be included featuring my friends and taking group photos. It’s important to capture not just the final pose but a mixture of both the process of taking photos and the final image. Consequently, the freelancer ideally should have experience with event-based filmmaking, specifically capturing candid moments and cool editing into an instagram video. Proven ability to tell a clear and compelling visual narrative is required.

hey there! I am working on a project with audio narration of the Bible stories that Jesus told (also called parables). The audio would be sent over and would be a straight reading of the text. Looking for someone to create a general vibe and color palette and have a lot of fun and bring their style into it and we could...working on a project with audio narration of the Bible stories that Jesus told (also called parables). The audio would be sent over and would be a straight reading of the text. Looking for someone to create a general vibe and color palette and have a lot of fun and bring their style into it and we could do potentially 10 of these stories together. They are around 30-45 seconds long each. Some stuff I have done with other animators is up at :)

I'm running a Node.js website where the last user's data is mi...promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and able to work efficiently to resolve this issue. Please refer to the attached video for better understanding of the issue. Your prompt attention to this ...

Job Title: Full-Stack Developer for WordPress, .NET Middleware, Azure Integration, and SDK Development Job Overview: We are seeking an experienced Full-Stack 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 functionali...

...mind for the design. It's vital that the chosen colors align with the theme and message of our brand. - Focus on User Navigation: The most important aspect of the website for me is ensuring user-friendly navigation and ease of use. The design should be intuitive for our target audience. - Target Audience: Our target demographic consists of real estate investors. The design should appeal to this group and facilitate their ease of use and understanding of the interface. Ideal Skills/Experience: - Proficiency in UI/UX design - Experience with real estate industry interfaces - Familiarity with KV Core or similar platforms - Strong understanding of color theory and its impact on user experience Your role will be pivotal in providing a smooth and engaging experience for our user...

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 ...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 shoul...

I am looking for a SEO friendly AI Website Content writer who has strong knowledge over US English and can research and write AI related content. The website is for a new Company which will help in Management and technical consultancy to companies. Something like a mix of Mckinsey and BCG group sandwiched with something like a cognizant or Accenture. This is a company that does management consultancy this is a technical consultancy Also I want to include Gen Ai services in the same. This is a Gen Ai company example : it should look like a management consultancy as well as technical consultancy website with a flavor of Gen AI incorporated Initially 7 to 10 pages would be descent No blogs as of now. just core

I'm seeking a seasoned web designer to curate a service-based website for both B2B (Business-to-Business) and B2C (Business-to-Consumer) audiences requires a strategic approach to address the distinct needs of each target group. Medical Staffing Agency primarily located in the Midwest current Base Website Custom Design: Includes up to 4 unique page designs. Responsive Layout: Mobile-friendly design that adapts to various screen sizes and devices. CMS Integration: WordPress installation and setup, allowing for easy content management. Content Strategy Session: Session to outline the site’s content needs and SEO goals. Contact Form: Integration of a basic contact form which stores records in the CMS system. Google Analytics Setup: Integration of Google Analytics for tracki...

...videos will be used to promote a specific product or service across multiple platforms. Platforms: - The final products will be optimized for social media, web and also suitable for email marketing campaigns. Audience: - Specifically targeting age group 36-45 and above. Therefore, the design, tone, and messaging of the videos should be relatable and appealing to this demographic. Ideal Skills: - Proficiency in video editing softwares - Solid understanding of digital marketing and social media trends - Experience in creating content for age group 36+ - Ability to deliver on time, maintaining the high quality. Should you have any additional questions or need more details, please feel free to ask. I'm looking forward to seeing your creative vision come to life thro...

Fix pine script code send alert to telegram group too many signals with to dirction i need it to send once per entry only until the next signal came the code already wrote the message already wrote need to fix the issue only Pine script i dont need any1 full staked and dont know what i need i need it asap if more question what u dont understand will not accept the project its small fix dont request high the pinecoder know that ?? type 2233 if u read this

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

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.

I am seeking a creative ad designer who specialises in Facebook advertising. The aim is to produce an a...languages to target different countries. The ad is for a downloadable video course, for those whose native language is not English, teaching what to say in a job interview in English. Predominantly my market would be working professionals aged between 25 and 50 who are likely to have to attend job interviews in English. Main tasks would be : - Creating an engaging Facebook ad - zeroing in on target group of potential customers (possible later task) - designing an effective landing page for ad clicks current page (in Italian) can be found at I can provide a translation in English later on

I'm in nee...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, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is requ...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I'm in need of a professional with expertise in WhatsApp and Facebook development. I require the implementation of various features in these platforms, including but not limited to: - Chatbot integration - Group messaging functionality - User authentication and security I'm open to additional suggestions or features that could enhance the usability and user experience of these social media platforms. Successful candidates should have a strong portfolio with examples of past work in similar projects. Please include this in your application. Please note that there is no strict deadline for the completion of this project.

I am looking for a SEO friendly AI Website Content writer who has strong knowledge over US English and can research and write AI related content. The website is for a new Company which will help in Management and technical consultancy to companies. Something like a mix of Mckinsey and BCG group sandwiched with something like a cognizant or Accenture. This is a company that does management consultancy this is a technical consultancy Also I want to include Gen Ai services in the same. This is a Gen Ai company example : it should look like a management consultancy as well as technical consultancy website with a flavor of Gen AI incorporated Initially 7 to 10 pages would be descent No blogs as of now. just core

I'm in need of an experienced Email Marketing Specialist to help me roll out and manage a consistent email ...increase sales of Product A. However, I am also looking to use this campaign to build brand awareness and drive traffic to my website. The ideal candidate for this position should have a strong background in email marketing, especially in relation to e-commerce. They should have experience in: - Building and executing successful email marketing campaigns - Promoting products to a similar age group - Increasing sales and overall brand awareness - Utilizing email marketing to drive traffic to websites Understanding of the principles behind consumer behaviour, purchasing habits and user experience in e-commerce would be an advantage. Please share your experience in yo...

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: - Set...framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability to deliver on...

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

I've already secured a location where I aim to establish a comprehensive soft play and swimming area. The site is all set to accommodate ...Understanding of safety regulations and standards pertaining to kids' play areas and swimming pools - Expertise in utilising space effectively to cater to both indoor and outdoor activities Your Role: - Come up with creative ideas for the play area and swimming pool layout - Ensure safety standards are met at every step - Help design areas that are fun, engaging and suitable for the age group - Assist in selecting the right equipment for the soft play area and swimming pool - Provide guidance on the best indoor/outdoor setup The ideal candidate would have previously successfully implemented similar projects and be able to...

I'm looking for a freelancer who's great at web scraping to help with a project in...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 source code, documentation and deployment information and be on hand to help with deployment. You will also walk me through code step b...

...effective with simple Bootstrap and jQuery - Strong skills with MySQL and NoSQL (Firebase, MongoDB) - Good english communication skills in Slack and in meetings - Availability to work ~20hrs per week between 9AM-6PM PST - A passion for coding and an interest in gaming is a big plus! What We Offer: - Chance to make a big impact on a small, passionate team - Be part of a creative and innovative startup group and culture - Remote and flexible work environment - no management, no crunch - Working on innovative games and tech with founding team How to Apply: - Send us your resume/CV - Include a brief cover letter explaining why you'd be a great fit - Share any relevant portfolio or code samples - We will contact qualified candidates within 3 days Skills Needed: LAMP, PHP, MyS...

need the website for online inquries , booking for our activies and hotels. budget is 20k need a website like this the website needs to be dynamic so that we can change, put up offers and stuff.