Sql how to get all the items when you just store change jobs

...designer to create a fresh and modern design for my personal brand "The Truckin' Techie." I am a logistics consultant specializing in transforming small to mid-sized trucking companies through the blend of technology and systems. Ideal Skills and Experience: 1. Logo Design 2. Graphic Design 3. Creativity 4. Understanding of Industry Trends Deliverables: • A logo that seamlessly integrates elements of trucking and technology in a modern style. • Preferred colors are gold and mustard yellow. Please note, no specific symbols or imagery has been identified for inclusion, hence I leave it to your creative discretion to propose what best signifies "The Truckin' Techie". Your understanding of the...

I am seeking a highly skilled visual artist who specializes in logo refinement. For this project, you will need to: Eliminate the Dollar signs and the arrows. Create buildings in the background. Change the lettering to Archangel Investments. Where it appears to say "anni" make it more clear and then on the opposite side in roman numerals, put this year 2024.

...crown, and wings, all with varying thickness of lines. I'm looking for a talented designer who can transform this logo to a minimalist style with the following specifics: - Simplify the design: The current logo is too busy to be used effectively. I need a designer who can simplify the design while keeping the key elements intact. - Change the color to black: The logo is currently in color, which is distracting and not suitable for all use cases. I want the logo to be in a single color - black, to give it a more professional and cohesive look. - Unify the lines: Currently, the design has varying thicknesses in the lines of the dove, crown, and ...

I've got a Shopify store that needs an SEO upgrade. I'm looking for a competent freelancer to handle: - Keyword Research: I need my products to rank competitively in search results. Your task will involve identifying high-ranking keywords that fit my store's niche. - On-Page Optimization: This includes meta descriptions, title tags, image optimization and other on-page elements to boost the store's SEO. - Link Building: Build quality backlinks that will drive traffic to my store. It's necessary to have familiarity with Shopify SEO; I believe it is key to implement this task effectively. Please ensure to include details of your past work in this realm in your application. Let's optimize th...

I'm looking for a skilled professional to help me visualize how the building's exterior would look using a specific color I want. This will entail changing the current exterior paint in 3 images of the building. Key Requirements: - Change exterior paint in 3 building images - Ensure the change is realistic and high-quality Ideal Skills: - Proficiency in image editing software - Strong attention to detail - Experience in architectural visualization or similar projects - Understanding of how color appears in different lighting conditions

As a recruit for the navy, I am searching for an AI technology developer who can help create a picture capture and portrait maker and morph the faces of my face on to my brother face and change it into the navy instead of Air Force. This tool will aid me in capturing and immortalizing moments even though I was never there. It has to sell good and be realistic. Key Features: - Automatic Face Recognition: The AI should be capable of recognizing faces in the images automatically. - Real-time Image Editing: The solution should allow for instant adjustments and improvements to the captured images. - Customized Backgrounds: The ability to alter and customize the background as per our liking. ...

...inherited piece of real estate for which there are no existing records. This has created an urgent need for a reliable professional who has valuable contacts in the Prime Minister's establishment. The core objective of this project will be to sort out this missing land issue. To dive a bit deeper into the problem: - The land was inherited, however, the records are lost. - Previous attempts to address this issue via the local land registry haven't yielded any success. For this project, the ideal candidate should have: - Experience in dealing with land record issues. - Strong contacts within the Prime Minister's establishment. - A proven ability to navigate and resolve complex property is...

I'm looking for an experienced .NET developer to assist with a project. This project requires someone who has a strong background in .NET technology, particularly in C# programming, ASP.NET development, and SQL database management. Ideal candidates should have experience in developing web applications, creating software solutions, and improving existing systems. The key functionalities to be implemented by the .NET developer in this project include user authentication, data encryption, and payment integration. If you're a .NET developer with a solid understanding of the above technologies and functionalities, please reach out to discuss the project further.

...patterns to Museums, Aquariums, and Zoos, in the United States. We are seeking assistance in collecting reported visit counts for the year 2019 from 500 museums, 100 zoos, and 100 aquariums across the United States. We will send you an excel spreadsheet with the name and state of each location we would like visits counts for. Note that these ~700 locations have been pre-selected. Task: - Search the internet for reported visits to each location in 2019 - If you can find the number of visits, please enter that number in the "visits" column AND paste the link to the website / source from which you obtained that number in the "link" column - If you...

I'm searching for a...for a Shopify expert who can seamlessly import reviews into my Shopify store from another Shopify store via a specific plugin. Subtle Points: - You should have prior experience in not only importing reviews but doing so specifically through the plugin. - Please be knowledgeable about the different formats reviews could be stored in, although in this case, it's specifically via a plugin. Skills and Experience: - Extensive experience with Shopify, particularly in importing/exporting data - Proficient with plugins and their utilization for data transfer - Specific prior experience with the concerned plugin - Excellent problem-solving skills for any unexpected issues during import - Diligent attention to detai...

As an eager recruiter of beginner and junior developers, I'm offering a chance to hone your skills and add real-world experience to your portfolio. Key Deliverables: * Full-Stack Development * Frontend and Backend Developments * Mobile Development * Artificial Intelligence (AI) * Machine Learning (ML) Expected Skills: * Proficiency in Python, JavaScript, C++ * Versatility in tackling diverse IT tasks Experience: * Entry level/ Junior but with a strong grasp of the mentioned programming languages and IT sectors This opportunity is particularly aimed at those looking to secure jobs swiftly. While the primary focus of the project has been left open, it'll be a mix of various IT tasks. A challenge-loving mindset is a must-have.

I'm in need of an hacker to perform a thorough black-box penetration testing on my WordPress website. Key Responsibilities Include: - Testing the security from an outsider's perspective. - Identifying and using hacking techniques including SQL injections, cross-site scripting attacks, and brute force attacks to hack website as outsider so that we can plug the vulnerability. Ideal candidates should have: - Proven experience in website vulnerability testing. - A strong understanding of WordPress. - Exceptional problem-solving skills. - In-depth knowledge of SQL injections, cross-site scripting attacks, and brute force attacks. My objective is to ensure my website's robust security, and your expertise can help me to ...

I'm seeking a skilled programmer to meticulously test and subsequently deploy my Flutter application on both iOS and Android platforms. I need deep functionality checks and performance testing to ensure that my Flutter-based app operates smoothly and as intended. There are no big issues. The app was working well not long ago. This task demands a clean, concise, and detailed proposal that outlines your approach towards achieving the requisite testing and deployment. Requirements: - FIXED PRICE PROPOSALS ONLY - Proficient in Flutter software development - Android and iOS app experience - Works fast - Meticulous testing methods and Exceptional attention to detail - Able to re-write/de-bug my code and provide back to client - Experience ...

NO ...NOTE: I'M PAYING $2 PER HOUR FOR THIS JOB. DO NOT APPLY IF YOU ARE NOT OKAY WITH THAT RATE I want you to look at this personal portfolio site. Your job will be to evaluate the entire site and tell me any design issues, bug issues, UI or Flow problems, that need to be fixed. If you are a WordPress-Elementor developer, I can hire you to do the fixes as well. I'm looking for someone that can work immediately. REQUIRED: In your application tell me: 1. What computer & mobile devices do you own? Tell me the versions of the devices 2. What is the hourly rate I'm paying for this job? Are you okay with it? 2. Look at the site Tell me 2 problems you...

Greetings! I am looking for a talented graphic designer to create a unique logo and YouTube banner image for my you tube channel "Journey With Jia." My channel is committed to exploring the world and offering valuable information for individuals interested in relocating and settling abroad. Requirements: Logo: It should be visually appealing, professional, and memorable. The logo should be versatile enough to be used across various platforms and promotional materials. YouTube Banner Image: The banner image should complement the logo and represent the theme of the channel effectively. It should be engaging and visually striking. Guidelines: Authenticity: I value originality and creativity. Please refrain fr...

I am a writer currently seeking a skilled researcher to uncover Puerto Rican newspaper articles about an incident that took place on May 30th, 1999. On that day, Francis Reyes, a 34-year-old guide, was leading a group on a commercial caving expedition in Cueva Angeles. The group encountered a sudden rise in water levels within the cave's stream passage. Elba Vasquez Gonzales, one of the clients, was unable to escape to safety and got trapped by the floodwaters. Reyes heroically attempted to rescue her and managed to save her life, but tragically, he was carried away by the strong current and lost his life. This event was covered by several news outlets, with one article titled ‘Era un experto en las Cuevas&rs...

Part-time recruitment for fashion store tracking in NY/LA/BOSTON/ORLANDO. Take photos of local chain offline fashion stores, mainly focusing on shelves and product images. Photos are only for project analysis and will not be used for any commercial purposes. Payment will be settled directly upon completion of the photos.

I'm seeking an experienced packer who can efficiently package a range of electronics into boxes and apply shipping labels accurately. Key Tasks: - Packaging a variety of electronic items into boxes, ensuring their safety and security. - Applying shipping labels to all boxes, following correct placement and guidelines. Required Skills: - Familiarity with electronics and their packaging needs. - Experience with applying shipping labels on packages. - Attention to detail, accuracy, and adherence to packaging guidelines.

I urgently need a Lithu...urgently need a Lithuanian TELIA Prepaid SIM card to be shipped to India. (I can provide you with all the documents required for the SIM purchase) I have an immediate requirement, so quick delivery is paramount. The project is pretty straightforward, but it does need someone who can ensure the SIM card reaches me in India as soon as possible. Ideal skills and experience for this job: - Proven experience in international shipping, particularly with delicate items like SIM cards - Familiarity with purchasing prepaid SIM cards in Lithuania - Excellent communication skills to keep me updated on the purchase and delivery process Please bear in mind the urgency of this project when...

As the client is requesting, I copy and paste his request into the quote. 'd like to request a quote for "I need a 15nsecond video logo intro for my podcast. I already have a logo just need it turned into an intro animation for my podcast. I had an idea of the logo being 3D and maybe the camera following the edge of the logo before panning out to see it. Not sure how complex that is or if it is too much for my budget maybe around 100$ on the high end. ". My budget is $30 - 250USD. Here are some items I want in the quote:

I'm in need of a medium-sized banner creation for my gaming shop, "The Gaming Village". The theme I'm looking for is a traditional cowboy vibe, which will serve to set the tone for my store. Key Requirements: - Banner Size: 4 ft x 8 ft. - Design Theme: Traditional Cowboy. - Primary Colors: Red, Black, and White. - Urgency: I'm looking for this project to be completed in an hour. The ideal freelancer for this job should have: - A strong portfolio in graphic design, preferably with experience in banner creation. - Understanding of traditional cowboy aesthetics and its adaptation into a contemporary context. - Ability to work under tight deadlines without compromising on quality.

...developer console to assist with app distribution and app management. Key responsibilities include: - Managing app distribution process, ensuring smooth functioning and accessibility - Overseeing version updates and securing necessary permissions Please note there has been a slight snag. My app was removed from the store, which needs addressing. Although I'm uncertain of the exact reason for removal, your role will involve diving into this and clarifying the issue. Ideal Skills - In-depth knowledge and experience in Google Play Store development and operations - Skilled in managing app distribution and updates - Capable of strategizing and implementing plans to boost app performance - Problem-solving skills to identify and ...

I'm in need of a vibrant and engaging banner to represent my gaming shop; "The Gaming Village". The theme I'd like to go for is a traditional cowboy vibe, blending the old west with modern gaming aesthetics. The banner design should prominently feature: - The text "The Gaming Village" - Elements like playstation consoles and virtual reality equipment - Traditional cowboy motifs, ensuring it's a seamless fusion of both worlds Design requirements: - Color Scheme: Violet and Black Ideal candidates for this job would have: - Proficiency in graphic design and the ability to blend diverse aesthetics - A portfolio showcasing previous work in thematic and bold banner designs - Excellent com...

I am in need of a fashion model for fitting purposes. The primary use of the photos will be to help with designing and creating fashionable clothing items. Requirements: -- chest width required 99-102 cm , height 180 Please provide your portfolio and any relevant experience when applying.

I'm looking for a female candida...content for my girls fashion retail store. The content will be used to increase brand awareness on Instagram Note- candidate strictly should be from Bangalore, preferred nearby electronic city Key Responsibilities: - Crafting engaging and trendy video content that resonates with our target audience - Ensuring all content is in line with our brand image and messaging The ideal candidate should have: - A keen sense of fashion and trends - Experience in creating video content for social media - A strong understanding of Instagram's algorithm and audience preferences - Excellent communication skills - A creative mindset to produce vibrant and unique content If you're a creative and trendy content cr...

will log on with me via team viewer, or other remote app and configure now please

I'm looking for a writer with legal experience to write the terms & conditions and privacy policy of my web app. They need to be applicable to both Canada and the US.

...instructive videos, each less than 5 minutes, showcasing individual tasks via the online tool The ideal freelancer will be skilled in creating clean, engaging video guides like the one seen here - Each video needs to: - Feature one specific task per video - Adopt a step-by-step guide approach - Have professional English language voiceover explaining each step Experience in creating 'how-to' videos specifically for software or online tool usage will be preferred. Knowledge of video editing tools and comfortable narrating in clear, concise English is essential. It would also be advantageous if you have previously created content related to transcription or notetaking apps, though this is not a strict requirement

I am in need of a Point of Sale (POS) system for my pizza store, catering to in-store purchases only. The system primarily needs to support cash transactions - making it easy for my team to process orders and handle cash transactions. Key requirements include: - Generating sales reports: I would like the system to provide insights into daily sales, popular items, and revenue trends. - Inventory management capabilities: The system should help in tracking stock levels and provide alerts when inventory is running low. Ideal candidates will have experience in developing POS systems, particularly focusing on single-location businesses. Previous experience in the F&B industry or with pizza stores will be...

As a business owner of an online store, I am looking for a proficient software developer to build a comprehensive web application. Primary Features: - User accounts and authentication: our customers will need to have user profiles. Secure authentication is a must. - E-commerce features: the online store should allow customers to browse products, add them to cart and securely make purchases. Ideal Freelancer: - Significant experience in web application development, specifically for e-commerce platforms. - Proficiency in implementing secure user authentication methods. - High attention to detail and commitment to delivering robust, user-friendly e-commerce solutions.

I have a series of Malayalam entertainment audio files that need to be transcribed into SRT format. The project requires detailed timestamps at every speaker change. Ideal Skills and Experience: - Proficiency in Malayalam language - Experience in transcription work - Familiarity with SRT format - Ability to provide detailed timestamps - Attention to detail and accuracy - Timely delivery of transcribed files Please let me know if you're able to take on this project.

...skilled Data Engineer to assist in a large-scale data project that involves data cleaning and preprocessing. Key Responsibilities: - Integrate and process data from various sources including Databases, CSV files, and APIs - Handle a high volume of data (more than 10GB) efficiently - Implement data cleaning and preprocessing techniques to ensure quality and consistency Ideal Skills: - Proficiency in handling large-scale data sets - Strong experience with integrating and processing data from diverse sources - Expertise in data cleaning and preprocessing techniques - Knowledge of relevant tools and frameworks for data engineering Prior experience in similar large-scale data cleaning projects and proficiency in SQL, Python, and ETL tools would be highly advantageous....

I am in need of a SharePoint expert who will be on hand for 4 hours daily to assist with various tasks relating to my SharePoint site. The selected individual will be primarily tasked with: - Document management: The organization, updating, and safeguarding of crucial documents. - Workflow automation: Streamlining business processes to improve effectiveness. - SharePoint site customization: Tailoring the site to suit our specific needs. At the moment, the specific SharePoint version being utilized is unspecified, so a basic understanding of multiple versions is beneficial. There's also a need to integrate Power Automate, so experience with this tool is essential. Ideal candidates must be proficient with SharePoi...

I'm looking for a skilled Shopify developer to create a modern and professional online store for me. The main goal of the store will be to sell products, but it will also be used to display services. The target audience for the store is young adults, so it's essential that the design is appealing and engaging for this demographic. Key requirements: - E-commerce setup: The store should be set up for selling products online. - Services display: It's important for the store to be able to effectively display services alongside products. - Appealing design: Design should be modern and targeted towards young adults. - Product range: The store will ...

I want to develop a website similar to and https://www.abasteo.mx. The goal is to automate daily updates of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology produc...

Configure SMTP, move icons, add a button, change a timer etc. As related to that, the website is for escorts, people who have no problem with that type of website.

I'm in need of a diligent researcher with experience in i...need of a diligent researcher with experience in investment and buyer sourcing, to identify potential angel investors for two projects in Colombia. Simultaneous research for both projects is required. The first project is an all-natural personal care product manufacturing company. The company is located in the Colombian Amazon and produces items such as shampoo, soap, skin creme etc. The second project is a 50-acre eco-tourism project, situated in the same geographic area. Skills and experience desirable: - Investment research - Knowledge of angel investment - Experience with buyers sourcing - Understanding of personal care product industry and eco-tourism sector - Fa...

...a skilled designer and copywriter to enhance the look and description of the Saarey Music app store listing on Google Play Store. The current Store Listing Conversion Rate is 30%. The goal is to be >60%. See: The engaged freelancer must: - Enhance the existing app description with more captivating and engaging text which aligns well with the audience of South Asian classical music. - Create new, exciting promotional banners, graphics that illustrate the essence of Saarey Music and South Asian classical music. - Redesign the app screenshots, making them more attractive and appealing to capture the interest of potential users. - Make any other changes necessary to...

Hello, I am encountering a problem with my store, particularly on the LCP. Loading is very slow on mobile and a little on computer. I did some optimsiation like : - Cloud hosting - WPRocket + RocketCDN - All images .webp But I still have this LCP problem which slows down my pages.I am looking for a professional to help me resolve this problem and ensure proper operation in the long term. Regards

I'm currently dealing with an issue in my iOS React Native application. The change mode callback isn't triggering properly. I am looking for a seasoned React Native developer to step in and add additional functionality to fix this issue. Main requirements: - Excellent knowledge in React Native specifically for iOS - Proven experience in debugging and enhancing callback functions - History of adding new features to existing code You can expect to: - Diagnose the issue where the change mode callback isn't triggering properly - Add additional functionality to the callback, ensuring its functionality - Enhance the overall performance of the change mode callback function. ...

It seems people do not read the requirements and conditions and once I start the trial, people are failing to perform. Also, too many bids from countries I do not desire; Pakistan, Bangladesh, India, etc. I need a freelancer from LATIN AMERICA only. I need close to EST time!! Furthermore, I need a BILINGUAL freelancer!! So READ before biding. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: PR Outreach Social media Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must b...

Design Shopify Store Product Page and set layout

...integrates the Livedrive Reseller API into my WooCommerce store. The primary aim of this integration is to automatically create a new user on Livedrive when a new order is placed in WooCommerce and the payment is received. Key Features: - **Automated User Creation**: When there's a new order with payment in WooCommerce, the plugin should automatically generate a new user on Livedrive. The plugin should use the customer's email and order details to create this new Livedrive user. - **Welcome Email**: The plugin should also automatically send a welcome email to the newly created Livedrive user. This email should contain the login details for Livedrive. Ideal Skills and E...

I am quite an experienced developer however, I am caught up with a few things right now so I cannot do this. Here are the issues and what I need for my Wordpress site. 1. The navigation on mobile mode button is dead, not working. I need it centered with the template and the hamburger dropdown menu items to function. Problem is the hamburger button does not function when pressing it. 2. I need the website converted to a static site. I already have the plugin, so you can simply generate the static files and fix it accordingly. *** The navigation fix MUST be done via Elementor NOT code***

...proficient python developer to help in enhancing a Telegram PHP bot. With your skills and experience in bot programming, I am confident we can have this bot become even better. As part of this project, you need to: 1. Customize Bot Commands: - Add new commands as per the specific requirements I will share. 2. Change Chatbot Responses: - Modify existing responses in a way that improves the user engagement. - Delete some responses that are no longer relevant. 3. Integrate Third-Party APIs: - This integration will help the bot offer more utilities and functionalities. The ideal candidate for this project should have extensive knowledge in Telegram bot development, PHP, Python, and experience in third-party API int...

...skilled individual to help with creating and updating listings for my fashion brand, 14FOX, on Amazon, WooCommerce, and Flipkart. Key Responsibilities: - Create high-quality listings for our clothing products on Amazon, WooCommerce, and Flipkart - Implement SEO strategies to enhance the visibility of the listings - Ensure that all listings are up-to-date and accurately represent our products Ideal Skills and Experience: - Proven experience in creating and optimizing listings on Amazon, WooCommerce website, and Flipkart - A strong understanding of SEO techniques and how they can be applied to product listings - Prior experience working with fashion brands and clothing products is a plus - Excellent attention to engaging cu...

I have an already functioning WordPress website that needs a Stripe integration. Although I do not have specific functionalities laid out, I'm open to suggestions on how to utilize Stripe's capabilities. Requirements: - Implementing Stripe's payyment processing functionality - Customizing the payment forms to provide a seamless experience for users - Setting up two-way payments for efficient transaction management Ideal skills and experience: - Proven experience in integrating Stripe with WordPress - Knowledge of different Stripe functionalities - Ingenuity in proposing smooth, user-friendly payment solutions

...looking for someone with a knack for emulating the western style in a modern way. The task is to revamp my current logo for my clothing brand, Outback Western. I would like it to incorporate elements of Cattle, Mustering dogs, fences, barn, horses cowboys cactus and even a maybe Helicopter not set on it - symbols that represent the heart of our brand Outback Western. It's essential that the final design be cool and fresh yet able to be vinyl printed and embroidered on various clothing items. The color palette is open-ended. I prefer shades of Brown and Black; however, the freelancer should feel free to recommend and introduce other colors if they add to the design's overall appeal and...

I'm looking to implement a multiplex pricing strategy for all my items, including bundles. This strategy focuses on providing differentiated price lists between pickup and shipping. Therefore, I seek someone with exceptional expertise in pricing strategy and e-commerce. We want to use the pick-up and shipping radial button to create a pick price in our system that currently includes shipping in the prices. Please find the attached video with an example of what we need. Ideally, you should: - Have experience creating price lists in various e-commerce platforms - Be adept at understanding customer behavioral trends concerning pickup and shipping - Be proficient in analyzing market trends and aligning them with my busine...

I'm seeking a freelancer to rigorously test the functionality of my app on a REAL LG webOS TV with a resolution of 1280 X 720. This role requires: - Checking the load time for the content on your TV. Evaluating video streaming performance - Checking the smoothness of user interface navigation Please note this MUST be a genuine LG TV with the specified resolution, not a simulator. Testing parameters will be discussed once the project commences. Experience in app testing and possession of the LG webOS TV with Res:1280 X 720 TV model is essential. YOU CANNOT COMPLETE THE JOB WITHOUT A LG TV WITH RESOLUTION 1280 X 720. THE MOST IMPORTANT PART OF THE PROJECT TO UNDERSTAND Our team have many LG TV...