Sql query tree structure records jobs
I need a freelancer who can conduct a comprehensive background check for pre-employment purposes. The task involves: - Conducting a thorough check on the candidate's criminal records - Verifying the candidate's employment history - Confirming the candidate's educational qualifications The ideal freelancer for this project should be well-versed with background checks, have access to reliable databases and be able to compile the information accurately and efficiently. Please note that the privacy and confidentiality of the candidate's information is of utmost importance.
I need an adept freelancer with loads of experience in WordPress site design. The job involves updating my current website for a more refreshed look and primarily to modify its content. Despite skipping my preferences regarding design improvement, I'm open to a radical transformation. The ideal candidate would pay rapt attention to: • Website layout and structure: Reorganize contents and make navigation user-friendly. • Colours and fonts: Use appealing, easy-to-read text color and font-size. • Images and visuals: High definition images and engaging visuals are necessary to make the project outstanding. It is important that freelancers provide proof/details of experience in their job application. Creativity, timeliness, and previous experiences with Wo...
I have a Uniswap Swap Widget integrated on my web platform built using React. The widget is currently facing connectivity problems that need to be addressed. Uniswap Swap Widget It use Metamask and Wallet Connect , I want change it Rainbowkit connector It need to complete in few hrs Ideal Skills and Experience: - Proficiency with React and Uniswap - Experience in fixing connectivity issues in web platforms - Understanding of how to integrate and troubleshoot widgets The task mainly involves identifying the root cause of the connectivity issue, and implementing a reliable fix that ensures the widget functions correctly. Experience with similar projects or Uniswap integration will be a
I'm searching for a skilled and creative book editor who can assist with editing a range of professional textbooks across various subjects ...Your task will be to: - Edit and enhance the text of professional textbooks. - Ensure the content is engaging and clear for the reader. - Implement changes that will help to improve the overall quality of the textbooks. To be successful in this role, you must be familiar with finance and taxation subjects. Your editing should not only correct grammar and punctuation but also enhance the overall structure, clarity, and style of the content. Experience in textbook editing is a plus. If you're an editor with a creative flair and experience in textbook editing, I would love to hear from you. Please provide examples of your previous wo...
I'm looking for an experienced hacker who specializes in database scraping to assist with lead generation. My main aim is to get detailed contacts to grow my business. - Specific Tasks: - Database scraping - Extract contact details - Contact Information: - Email addresses - Phone numbers Idea...get detailed contacts to grow my business. - Specific Tasks: - Database scraping - Extract contact details - Contact Information: - Email addresses - Phone numbers Ideal candidates should have previous experience in the field. Proficiency in data mining and scraping is a must, along with an understanding of lead generation strategies. Strong grips and successful track records on obtaining accurate contact details are key to perform this j...
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
...hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Perso...
I am in need of an expert who can proficiently implement DMARC, DKIM and SPF records to improve my email deliverability and security level. I'm currently using GoDaddy as my email service provider, hence, hands-on experience with GoDaddy will be crucial for this project. Key Requirements: - In-depth understanding of implementing DMARC, DKIM and SPF records - Expertise in email security - Experience with GoDaddy and Klaviyo - Ability to complete the task ASAP Only bid if you are confident you can meet these criteria. This is a priority for me and should be handled with the utmost professionalism.
I am seeking an individual or team with extensive experience on Shopify platform. Our website is on Shopify platform and we need to make some modifications, details mentioned below: - We need to have different pricing structure, different offers and different shipping rates for international customers. - Interlocking conditions for different transactions. example: discount code can be applied only to prepaid orders - auto play video on the home page - improve overall speed of the mobile site
Hi Ishaq A., My Printer says that The logo file in one of the rewind bag artwork files for Mulberry Tree brand is too small. Can you please fix the logo and change to the two coloured versions used in the artwork
I need a professional resume reviewer to go through my resume. The ideal candidate should be able to focus on a few key areas: - Grammar and spelling errors - Content and structure - Formatting and design I am looking to transition into a new tech role and my resume should reflect and appeal to this industry specifically. Please complete the review within a week.
...seasoned SEO expert specialised in the wedding/event photography space with a knack for improving search engine rankings, significantly increasing website traffic, and amplifying online visibility. Specifically tailored to target local customers in Sydney Australia only, the primary objectives of this role entail: - Conducting a comprehensive website SEO analysis - Optimizing website content and structure to appeal to our local customer base - Ensuring consistent online visibility across various search engines - Successfully generate organic leads There's no set deadline for this project. The perfect individual for this role would possess: - Proven experience in wedding photography SEO projects - A strong understanding of local SEO tactics for Sydney, Australia - Exceptio...
...guide on migraine management primarily targeted towards adults. It will be a blend of scientific data and personal experiences adding a more humane touch. Key Points: - The book should intertwine scientific analysis and real-world experiences to give readers a sound understanding of migraine, its causes, symptoms, and remedies, as well as coping with it on a daily basis. - I imagine a mixed structure format combining sections and chapters to provide a flow that leads the reader through understanding, managing, and living with migraines. Ideal Candidate: - Proficiency in health/medical writing. - Familiarity or personal experience with migraine would be a plus. - Ability to understand and translate medical jargon into easy and engaging content. - Previous experience in writin...
I'm in need of a professional who can help me set up a website with the primary goal of raising awareness and seeking justice. The website will essentially be a platform for presenting evidence and sharing my story with the general public. Key details and...of the wrongdoing and telling my story in a compelling manner. - The target audience for this website is the general public. Ideal skills for this project: - Proficiency in website design and development - Experience in setting up platforms for advocacy or social justice - Ability to present complex information in a clear and engaging way. I'm open to suggestions and ideas on how best to structure the content and present the information effectively. The right candidate will have a strong commitment to integrity, e...
I need 7 products set up on my WooCommerce store immediately. If I can not find someone to assist in the next couple of hours, I will handle this time-sensitive project myself. Again, to be clear, if you are not available right now to work on this project for the next couple of hours, please do not bid. This site is a development environment and we are working on a new version of the s...Small Beanbag Wedge Large 3 Beanbag Round Small Beanbag Round Medium Beanbag Round Large 4 Beanbag Armchair Small Beanbag Armchair Medium 5 Beanbag Luxury Lounger 6 Beanbag Dog Bed Small Beanbag Dog Bed Large 7 Beanbag Ottoman Some of the older products will require the product descriptions to be reorganized. I will give you an example to follow so that all of the products have a consistent stru...
I'm looking for a skilled app developer with expertise in both iOS and Android platforms. The primary function of the app is car service booking. It should have a clean, intuitive interface and be secure to ensure use...booking. It should have a clean, intuitive interface and be secure to ensure user trust. Ideal Skills and Experience: - Expertise in developing apps for both iOS and Android - Experience in developing service booking apps - Knowledge of secure app development - Strong UI/UX skills Features to Include: - Users should be able to book and pay for services - The app should store previous service records for easy rebooking - Should have a system to compare prices from different service providers. Your proposal should include a timeline and cost estimates f...
I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)
I need an expert in construction and steel design to create a model for a mild steel mezzanine. The primary purpose of this structure is storage, and it's intended for storing warehouse goods. Key Requirements: - Familiarity with mild steel construction - Ability to design a sturdy and durable mezzanine suited for storing warehouse goods - Knowledge of safety regulations and requirements for storage mezzanines - Experience in designing ship ladder access routes The final deliverable should include detailed specifications for construction. Please, include examples of similar works completed in your bid.
I'm in need of a skilled SEO expert to enhance my app's user engagement specifically targeting individuals. The app already has a dedicated in-house team managing content. Key Requirements: - Experience with app SEO - Proven record of improving user engagement - Ability to tailor strate...specifically targeting individuals. The app already has a dedicated in-house team managing content. Key Requirements: - Experience with app SEO - Proven record of improving user engagement - Ability to tailor strategies to individual target audience Ideal candidate will be able to provide clear strategies for enhancing user engagement, including: - Appropriate keywords - Effective content structure - User experience improvement - Utilizing existing content effectively Looking forwar...
...---------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game.
I'm dealing with a critical issue related to fake accounts on Ins...uncover these identities for Court purposes. I am already involved in an open lawsuit with the one believed to be the source for obvious reasons, but need solid evidence to prove harassment of these fake accounts. Your Experience: • You should present your experience in tracking down fake profiles. • Familiarity and skill in dealing directly with these platforms is a must. - Able to produce records for legal purposes. Project Expectations: • Leverage your past experience to track down the IP address and identity behind these profiles. • I emphasis on performing the task via direct communication with the relevant platforms. Don't just bring your experience - bring solutions. It�...
...expected outcome will be a two-lane track device, with the ability to dictate the start and end of races, as well as display grades systematically. Key Features Needed: - Start Line Servo: To exhibit a complete rotation signaling the race's commencement. - Finish Line Infrared Sensors: These will be strategically positioned to detect the end of the competition. - Two-Lane Implementation: The structure should accommodate a dual lane setup. - Display: 7-Segment LED HT16K33 Backpack above each lane to show timing results. - Winner Identification Feature: An 8x8 matrix screen for indicating 1st and 2nd place finishes. Ideal Skills and Qualifications: - Working knowledge of Arduino programming language. - In-depth understanding of microcontroller-based systems. - Hands-on exper...
...Management System for lawyers and law students. The LMS should feature effective user management, course management, assessment mechanisms and more. Key functionalities I'm looking for: - User Management: The ability to manage students' details, track their progress, and handle subscriptions effectively. - Course Management: Essential for organizing and dispensing courses efficiently. The structure should be clear and easy to navigate. - Assessment Tools: Ability to create and manage assessments, tests, quizzes etc. from within the system. Although I may have missed specifying some features, I expect the chosen freelancer to have deep understanding of LMS platforms and to suggest features that could improve user-experience and efficiency. Strong programming skills...
...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...
I'm in need of a talented illustrator who can create a hand-drawn family tree in a minimal style. The end product should be a beautiful, simple illustration that stands out for its elegant, uncluttered design. Key Details: - Style: Minimal - Size: Medium (up to 18x24 inches) - Content: The tree should be detailed enough to cover 7 generations, but without the names of the family members. I'll be filling in the names myself post-completion. - I need in PDF/illustrator format. Ideal Skills and Experience: - Proficient in hand illustration, with a portfolio that showcases a minimalistic style. - Experience in creating intricate, multi-generational family trees or similar illustrations. - Ability to communicate and work collaboratively to ensure the final product meet...
...graphics are welcome but not mandatory. If you use images, ensure they are properly licensed and provide the license information below the image and again collectively at the end of the script. AI Expertise: While using AI tools for content generation, you must have a solid understanding of AI to proofread and ensure accuracy, as AI-generated content can sometimes contain significant errors. Book Structure: Each ebook should be 15-25 pages long, depending on the topic. Aim for approximately 4,000 words per ebook. Each ebook should have around 15 chapters, divided into 2-4 main sections to give users a clear overview. Deliverables: 15 scripts, formatted and proofread, ready for audiobook conversion. Your Tasks - Timeline - Workflow 1. Content Overview of the Books When we start, y...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...
I need a professional to scrape names and email addresses from specific public websites. I'm looking to populate a database with details from a range of public websites. This data will be used for lead generation and market research purposes. Ideal skills and experience: - Proficient in web scraping - Familiar with public data extraction - Able to structure data effectively
Develop an interactive website: 1) clean structure and fast loading (who, what, how, process, product cat.) 2) data management (input and format conversion to pdf format) 3) automatic language conversion based on geographic location 4) ai chat messenger 5) Interactive design a) slider banners b) animated (wave length or video background) 6) integrate stripe gateway. All information is ready, details will be provided once confirmed and website must be finalized/deployed within June 5. Thank you!
I'm seeking professional guidance for customizing WIX design specifically on layout design aspects. Over the course of a dedicated 2-hour consultation, our focus will be on creating a multi-page layout reflecting my brand’s identity. Key areas include: - Expert advice on multi-page layout strategies - Tips on optimizing layout structure to enhance user experience - Discussions about best practices in layout design Ideal candidates should preferably have: - Comprehensive experience in WIX design customization - Proficiency in creating efficient multi-page layouts - Good track record for providing actionable consultation.
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78,...
...web-scraping expert to retrieve both images and text from a specific website for research purposes. The text data will need to be structured and saved in a CSV file, including paths to saved images. Key details to consider: - Knowledge of web scraping tools and techniques is essential to accomplish this task. - Quality control to ensure accurate data extraction and image quality is critical. - Structure page information and freeform descriptions should be made available in a CSV file. - The images should be saved in their original resolution and quality settings. Please provide any relevant experience you have in web scraping, including free and paid services you have used before to help with your work. I would like the project to be completed in the next week. Let's di...
...ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience in creating admin dash...
I'm currently in need of a skilled engineer with experience in structural analysis,...particularly with steel structures, to help optimize the design of my project. Project involves suggesting furnace column, beams , plates etc sizes as per Australian standard, and material sizes available in Australian market. Key Responsibilities: - Conduct a comprehensive structural analysis of the steel structure - Analyze and interpret the results for optimization recommendations - Make design suggestions based on the analysis - Ensure the structural integrity of the steel structure Ideal Skills: - Proficiency in AutoCAD - Previous experience in structural analysis and design - Knowledge of steel structures - Ability to provide actionable design suggestions based on analysis - St...
We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.
...focus on the thematic narration of my inner journey and self-discovery. • Biography Type: The script should be based around a personal biography, concentrating on my personal experiences rather than professional accomplishments. This biography will serve as a means to convey my deeper self-exploration and development. • Storytelling Approach: I favor a thematic over chronological narration. The structure of the biography should play around themes derived from my inner journey and the continuous path of self-discovery I have undergone. The storytelling should effectively weave the themes from my life experiences throughout the script instead of a time-based sequence. Ideal candidate: • Have experience in writing engaging personal biographies. • Understand th...
Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.
...Purchase date Invoice number Vendor name Product (inventory name) Product quantity Rate Amount SGST CGST IGST Freight charge Gross amount The task involves creating a TDL (Tally Definition Language) or TCP (Tally Compiled Program) file that will facilitate the extraction of this data from the Tally database using ODBC Requirements: Strong knowledge and experience with Tally and its database structure. Proficiency in TDL or TCP file creation. Familiarity with ODBC for database connectivity. Ability to automate the extraction process to ensure seamless and accurate data retrieval. Deliverables: A functional TDL or TCP file that successfully extracts the specified data fields. Documentation and instructions on how to use the provided solution. Support for initial setup and trouble...
I am looking for an experienced CodeIgniter developer to upgrade my existing CodeIgniter 3 project to CodeIgniter 4. The project is currently live and needs to maintain the same database structure and functionality. The key tasks include: Upgrade CodeIgniter Version: Migrate the entire project from CodeIgniter 3 to CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. ...
...enhance and optimize my existing content. This could include, for example, improving keyword utilization, refining metadata, and ensuring that the content is user-friendly and engaging. - Off-page SEO: I'd like to see a strategy in place that can help me acquire relevant, high-quality backlinks. These should come from reputable sources and drive traffic to my site. - Technical SEO: My site structure needs to be reviewed and refined. This includes optimizing for mobile, improving the navigation, and ensuring that loading times are efficient. In essence, I'm looking for an SEO expert who can further boost the traffic to my websites. This should involve a combination of content, backlinking, and technical optimization. Ideal Skills and Experience: - Proven track recor...
...only apply if you have build something like this before! More info: Key Features: - Rights Management: Implement a secure and reliable mechanism for managing music rights within the system. This should ensure that artists' intellectual property is protected and that comprehensive records of who has the rights to play specific songs are maintained. - Royalty Tracking: Enable the tracking of royalties in an efficient and transparent manner. This could involve integrating royalty payment calculations based on playtime, as well as the ability to generate detailed reports on royalty distribution. - Catalog Management: Develop a feature-rich catalog management system. This should include
I'm seeking a professional to convert my PDF file into a Word document. Key Requirements: - The final output should be a fully editable Word file. - It's crucial that the text conversion is accurate, with no room for errors. - While the tex...Word file. - It's crucial that the text conversion is accurate, with no room for errors. - While the text itself is of utmost importance, an identical formatting to the original PDF is not necessary. Ideal Skills and Experience: - Proficiency in PDF to Word conversion. - Attention to detail to ensure accurate text transfer. - Strong grasp of English to maintain the text's original meaning and structure. - Ability to maintain a professional and consistent format in the Word document. Please provide your relevant experience...
I need a highly functional booking and appointment website specifically designed to fit the needs of my clinic. As an essential feature, it must effectively manage detailed patient records. Key integration encompasses live chat support, a contact form, and both audio/video online consultation features. Ideal skills and experiences: - Proficiency in creating medical/clinic-based websites - Experience in implementing effective booking and appointment features - Experience with patient record management systems - Expertise in integrating communication features such as live chat, contact form, and online consultation tools on a platform - Strong history of data security to ensure patient details are safely stored and processed.
looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from S...
I'm looking for an experienced web developer who can address a few key issues on my WordPress website. - **Theme Fixes**: The primary issue I'm facing is related to theme functionality. This is affecting the overall display of the website. The solution will involve manually uploading the latest version of the theme. - ...inspect the navigation menu layout on the blog page. If necessary, you will need to fix any structural issues that may be present. Ideal candidates for this project should have: - Proven experience with WordPress, especially in troubleshooting theme-related issues. - Proficiency in improving Core Web Vitals, specifically in loading performance and visual stability. - A keen eye for design and structure, particularly in inspecting and resolving issues wi...
...Development: Develop mobile apps for both iOS and Android platforms, ensuring users can access the marketplace via smartphones and tablets. - **Multi-Language Support**: Support for multiple languages, including English and Arabic (RTL), across all platforms. **Key Deliverables:** - A fully functional multi-vendor marketplace platform. - Mobile apps for iOS and Android, supporting the specified menu structure.- - Backend web application for management. - Integration with support and ticketing systems and chat. - Full source code. - Installation on the provided domain and app stores (iOS App Store and Google Play Store). - Payment integration. - One year of support and maintenance post-launch and helping in publishing multi Frontend apps. - Contract covering initial setup and ...
