Sql query posts category wordpress punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
Hi, I am interested in a web site similar to this one in the link I attached to this description. The changes are likely to be from this web site are the colors and it's the Recent Posts section, their form being something more elegant.
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
I'm in need of a talented content writer that can create engaging, short-form content for my audience. Key Requirements: - Ability to craft high-quality content that is less than 500 words in length - Understanding of how to engage an audience through writing - Strong grasp of the English language and grammar - Previous experience in creative writing, blog posts, or similar content The ideal candidate will be able to make my readers want to dive into the content and keep them interested in every piece. This content should be concise and captivating, designed to get the reader to react or respond. If you can bring these skills to the table, please get in touch with me.
I'm in need of a talented designer who can create realistic mockups of various tables for my home decor line. Key Responsibilities: - Designing and creating mockups for tables - Ensuring the mockups are of high quality and look realistic - Providing a variety of ...Providing a variety of designs that align with my brand Ideal Skills & Experience: - Proficiency in design software such as Adobe Photoshop, Illustrator, or others - Experience in creating mockups, particularly for home decor items - A good understanding of my brand and design aesthetic - Strong attention to detail and ability to deliver high-quality, realistic designs %d7%a9%d7%95%d7%9c%d7%97%d7%a0%d7%95%d7%aa-%d7%a1%d7%9c%d7%95%d7%9f this is reference for the type of design I'm looking for
...drive traffic and conversions. Key Points: - Development of an E-commerce website - Tailoring the design and layout for UAE market - A well-structured backend for easy management - Implementation of SEO to boost search engine rankings - Setting up Google AdSense for ad monetization Marketing: - Promoting the website on Facebook, Instagram, and Twitter - Crafting engaging content for social media posts - Running targeted ads to reach potential customers - Implementing effective SEO strategies to improve website's visibility The products I plan to sell on the website will vary, including both physical goods and digital products. So, experience in creating similar e-commerce websites, coupled with a solid understanding of social media marketing, SEO, and ad monetization, e...
...and motivated Virtual Assistant to join our team at Ni Hao Babe, a rapidly growing skincare brand. The ideal candidate will be proficient in using ChatGPT, Shopify, research, copywriting, and various social media platforms to help us execute our comprehensive content and marketing plan. Responsibilities: -Content Creation and Management: -Develop and schedule daily posts for Instagram, TikTok, and Twitter. -Write weekly blog posts and newsletters. -Manage and create content for our YouTube channel, including weekly AMA (Ask Me Anything) sessions. Event Coordination: -Assist in organizing and promoting monthly influencer events -Engagement and Community Building: -Engage with followers and respond to comments and messages. -Organize and manage giveaways for followers Res...
? Seeking Web & Social Media Pro! ? Attention wizards of the web and Instagram aficionados! We're a carpet company in need of your skills. Can you whip up a killer website and craft Insta posts and reels that turn heads? If you're up for the challenge, let's chat! DM us your portfolio.
We are seeking a skilled tech writer and content editor who can independently research and create content to support our business by writing Medium posts and creating marketing materials . Key Responsibilities 1. Edit and refine Medium posts to ensure they are engaging, informative, and SEO-friendly. 2. Review and improve marketing materials to align with our company's brand voice and messaging. 3. Source appropriate images for the content. The Ideal Candidate: - Proficient in tech writing and editing. - Good understanding of on-premise and SaaS solutions. - Experience in editing blog posts and marketing materials. - Able to work closely with the marketing team and deliver high-quality, error-free text. Example Topics: - Can AI Really Boost Your Work Eff...
I'm in need of an experienced photo/video editor passionate about minimalistic aesthetics. My project involves creating engaging content for social media posts with a simple, minimalistic touch. In particular, I'm looking for: - Ability to correct or enhance color if and as needed, although I did not originally specify color correction or retouching as requirements. - Expertise in adding smooth video transitions. - Nudging creativity and an eye for minimalism, for an attractive and professional output. - Gaining value-added insights into social media trends and aesthetics would be an added advantage. Your experience working with similar social media projects and your ability to capture a unique but consistent minimalistic style will be key to this project.
...Responsibilities: Ability to assign responsible parties for each state or stage of the report. Notifications: Automatic notifications to the reporter about the progress and state changes of their report. Task History: Complete log of all actions and state changes for each report. Business Intelligence (BI) Panel General Statistics: Total number of reports received, in process, and resolved. Category Analysis: Statistics by type of report, department, severity, etc. Temporal Trends: Graphs of monthly, quarterly, and yearly trends. Customizable Dashboard: Customizable widgets for different views and levels of detail. Security and Confidentiality Anonymity: Options to submit reports anonymously. Data Protection: Compliance with data protection regulations (GDPR). Secu...
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...
I'm a registered Amazon seller in the Home & Kitchen category and I'm looking for someone to help me register my brand on Amazon. Key Requirements: - Amazon Expertise: A thorough understanding of Amazon's brand registration process is essential. - Legal Knowledge: While a trademark isn't compulsory, experience with intellectual property law and trademark registration would be a plus. - Communication Skills: Ability to communicate clearly and efficiently is important as you'll need to liaise with Amazon support on my behalf. The ideal candidate should possess a mix of legal, Amazon, and communication skills to effectively help me through this process.
I need your help in listing approximately 2300 products from my eBay store to my website. Here's what I'm looking for: - **Product Listing**: You will be responsible for manually copying and pasting the product details from my eBay store to my website. This will include images, descriptions, prices, SKUs, etc. - **Category Structure**: I do not have a specific category structure in mind. You will be responsible for organizing the products in a logical and user-friendly manner on my website. Ideal freelancer for this job would have: - Strong attention to detail to ensure accurate data transfer. - Proficient in data entry and working with online platforms. - Good organizational skills to structure the products effectively. - Prior experience in eCommerce product li...
...attention to detail is paramount, ensuring accuracy in data collection and entry. Additionally, demonstrating respect for privacy laws and guidelines, including GDPR, is essential. Experience with spreadsheets and CRM systems would be advantageous. Gyms must be privately owned only, non franchise. Offer Personal Training. Boutique Exclude: Category - Fitness Equipment Category - Community Health Centres & Services Category - Community Health Centres Category - Fitness Instructor Courses Mentions of - Gov Mentions of - Council Mentions of - Leisure Centre Mentions of - Aquatic Centre Mentions of - University Mentions of - College Mentions of - RSL Mentions of - Pool Mention of - Workers Club / Worker's Club Mentions of - Gymnastics Mentions of - Tai...
I need assistance to forge a new design for a specific product in the SPM category. Your task, if selected, would involve the conception of a superior product layout with clear focus on innovation and usability. Key areas of discussion would be: * Layout Design: Designing a unique and easy-to-use layout. * Specifications: Discussing and implementing the specific requirements based on user needs. Ideal skills and experience: * Experience in mechanical product design, with a particular focus on Specific Product Manufacturing (SPM). * Innovative thinker with a knack for deciphering product usability needs and implementing the same in design. * Previous working experience in SPM design will be an added advantage.
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
...on Google. I have recently upgraded my site and my important keyword rankings are falling far beyond what they were previously despite similar content. I would previously rank above 10 and now up to 59 and it continues to fall. I have installed yoast premium and wincher to monitor. I require deep expertise in improving my SEO. Needs to be executed within a week. Website size is 34 pages and 35 posts roughtly. There are circa 10 main keywords. Key Focus Areas: - In-depth SEO audit and improvement proposal - Keyword research and optimization - On-page and off-page SEO - Contribution to improved user experience Ideal Candidate: - Expert in Google specific SEO strategies - Adept at keyword research tools - Proven track record in improving website ranking - Understanding of th...
I'm looking for a skilled digital marketer who can revamp and manag...responsible for creating regular company newsletters. Key Responsibilities: - Develop and manage our Instagram account with the aim of increasing leads. This includes creating engaging content, managing posts and interacting with followers. - Create company newsletters with a primary focus on providing updates about our products. Ideal candidate should have: - Proven track record in digital marketing and understanding of lead generation strategies on Instagram. - Strong copywriting skills, particularly in creating product-centric email content. - Good design sense to create visually appealing Instagram posts. - Ability to adhere to a posting schedule, ensuring a steady stream of content for both Inst...
...presence. The goal is to keep my Instagram account engaging, showcasing our service quality, and attracting potential customers and build an engaging follower base. Key Responsibilities: - Develop a content (including themes for stories) calendar, considering a mix of vehicle showcases, before and after photos, and customer testimonials. The calendar should be designed for posts 2-3 times a week in a mix of reels and posts. The grid calendar should show a sample photos of what the post/reel cover should look like and a theme fot the post. The stories should be general ideas for daily stories (5 days per week) - Implement a balance between thematic content planning and random content. I am open to a mix of both approaches if you believe this will help improve our engagemen...
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.
...levels, and that the product information is up-to-date. - **Sales and Traffic Generation**: Your focus will be on eBay. You should have a proven track record of driving traffic and generating sales on eBay. Experience in leveraging the platform's promoted listings and other advertising tools is a plus. - **Product Listing**: You will be listing electronics and gadgets. Experience in this product category is highly desirable. - **General Management**: I'll need you to manage the stores, handle customer queries, and process orders if necessary. Ideal Skills: - Proficiency in setting up and managing Amazon, eBay, and Spotify stores. - Experience in selling electronics and gadgets. - Proven track record in driving traffic and generating sales on eBay. - Familiarity with eB...
I am looking for a professional to support with my LinkedIn Page. - The first phase of the project will involve creating and optimizing the page to ensure it is set up for success. - I then need assistance in managing content and posts, with daily updates to be posted. - Finally, the freelancer should be able to analyze performance metrics of the page to ensure that it is effectively generating leads and conversions. Ideal skills and experience include: - Proven experience in managing successful LinkedIn pages for business purposes - Strong content creation and social media management skills - Proficiency in analyzing performance metrics on LinkedIn - Prior experience in lead generation would be a significant asset. I aim to build a strong professional presence on LinkedIn th...
I'm seeking the expertise of a seasoned designer to create engaging Instagram templates representing my mining and emergency services company. The overall aesthetic should be simple yet captivating, mainly focusing on blue, white, and black palettes. Watermarked images are encouraged. Posts will be focused heavily on photos. I have attached some examples below as well as our company name and graphic to possibly be included on posts. We would like to have an overall theme for every post. Key Elements: - Despite the user not selecting any specific template designs, your creative acumen to propose a diverse mix of templates is welcome. - The templates should effectively communicate our company's values and mission, depict the benefits of our products and services, and...
I'm in need of an engaging PowerPoint presentation for a home economics assessment, focusing specifically on mocktails. The ideal candidate would have a sound understanding of: - The principles of home economics, particularly relating to beverage preparation. - Different types of mocktails and their ingredients. More specifically, the presentation should center around the sub-category I've chosen, fruit-based mocktails. Key skills required: - PowerPoint proficiency - Understanding of beverage-making (particularly mocktails) - Ability to convey information clearly and engagingly. This will be for teaching purposes; thus, it's essential the presentation is informative, comprehensive, and easy to understand for students. Any prior experience in education or teaching ...
...report on marketing campaigns to measure effectiveness and ROI. Market Research: Conduct market research to identify opportunities and trends within the digital signage and SaaS industries. Collaboration: Work closely with sales, product development, and customer service teams to ensure alignment and support company goals. Content Creation: Oversee the creation of marketing materials, including blog posts, whitepapers, case studies, and press releases. SEO/SEM: Develop and implement SEO/SEM strategies to improve organic search rankings and drive paid search performance. Lead Generation: Develop and manage lead generation strategies and activities. Budget Management: Manage the marketing budget to maximize ROI. Requirements: Experience: Minimum of 3 years of experience in marketin...
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 in need of a WordPress expert who can assist me with migrating my blog articles and enhancing my blog page. Key tasks include: - Moving all blog articles from their current location to a new one on the blog page - Ensuring all URLs are properly redirected (301) to avoid broken links and maintain SEO - Updating internal links in the articles to reflect the new URLs - Implementing a dropdown menu for blog categories - Adding functionality to filter blog posts by category The ideal candidate should have: - Extensive experience with WordPress - Strong SEO understanding - Proven track record of improving blog performance - Expertise in UI/UX design - Familiarity with The Retailer theme If you are creative, detail-oriented, and can take my blog to the next...
Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.
...attracting travelers on Reddit is a must. Specific Tasks: - Subreddit Targeting: You should be able to identify and engage with the relevant travel subreddits. - Traffic Generation: Your main task will be to be active on the subreddits, giving advices of hotels and travel activities using a specific referral link ( , Viator, GetYourGuide) through Reddit. This may involve creating engaging posts, participating in discussions, or any other strategies you recommend. Budget: The salary is ONLY commission based. I'm willing to offer a big commission based on the traffic you generate, giving a 30% of each successful referral completed. Based on your ability, you can easily make more that 1,000$ per month. If you think you're the right person for this job, please reach ...
We at "A Song For You" are looking for a Wordpress and Divi pro for monthly updates for our website. Every month, we'll be needing new artists & posts added, our events info updated, and other tweaks & updates to be made current. This is an ongoing project and would ideally suit someone who is passionate about the arts since we're a nonprofit in that niche working at the intersection of music and service. This is an ongoing role, but to start only about 2 hours a month of work will be required. Key tasks include: --Monthly updates - publishing blog posts - Updating event data and artist roster as well as hospital listings --Connecting socials with website A solid understanding and proficiency in Wordpress and Divi is necessary f...
• Description I'm looking for a part-time administrator to assist with data entry and VAT calculations for half an hour per month initially. Initially, we need monthly half-hour administration support to: 1) Copy and paste the Revolut bank statement into a spreadsheet. Then, select the appropriate category for the item. You also have to copy and paste or calculate the VAT for the item. 2) Copy and paste the bank statements (an estimated 6 bank accounts) and select the appropriate category for each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will be working online remotely. • Experience Please show us your detailed related work e...
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 ...
• Description I'm looking for a part-time administrator to assist with data entry and VAT calculations for half an hour per month initially. Initially, we need monthly half-hour administration support to: 1) Copy and paste the Revolut bank statement into a spreadsheet. Then, select the appropriate category for the item. You also have to copy and paste or calculate the VAT for the item. 2) Copy and paste the bank statements (an estimated 6 bank accounts) and select the appropriate category for each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will be working online remotely. • Experience Please show us your detailed related work e...
...growth strategies - Strong understanding of lead generation strategies. - Demonstrated ability to increase customer engagement via email marketing. Job Requirements: - Develop an email marketing strategy to generate leads. - Create engaging content targeted towards our existing customers. - Continuously analyze and improve our email marketing strategy as the project progresses. - Edit and schedule posts for instagram, tik tok, facebook, and maps - Track engagement and continuously analyze and improve our social media marketing strategy as the project progresses Within this crucial role, your ability to think creatively, solve problems and work closely with our team will affect the company’s overall performance. Your experience and expertise in marketing can help us reach ...
...competently. - Back-end Development: You will be tasked with adding new search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities will include: - Implementing new search criteria: Specifically, I need the addition of a new category search criterion using the Smyles Plugin on the back-end. - Ensuring a smooth integration: You must make sure that all changes and additions are fully integrated with the existing system without causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. Th...
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 func...
I'm seeking a skilled developer to revamp or given me a new design for my existing WordPress website, , by migrating it to NextJS. This project encompasses several key aspects: - Redesign: I envision a clean, minimalist interface for the website. This would involve simplifying the layout, enhancing user experience, and ensuring a modern look and feel. - Performance Optimization: The upgraded website should significantly improve in terms of speed and performance. The transition to NextJS should play a key role in enhancing the overall performance of the site. - Additional Functionalities: I aim to introduce new features to the website, specifically: - User Registration and Profiles: The new website should have a seamless user registration process, allowing visitors to creat...
I'm looking for a skilled social media scheduler who can manage and schedule posts on Facebook, Instagram, Youtube, and Tiktok. Key Requirements: - Must be proficient at scheduling posts on Facebook, Instagram, Youtube, and Tiktok. - I will provide the posts, reels and shorts. - You schedule, edit titles, captions, etc. This role would suit someone with social media experience who is particularly adept at scheduling content and managing multiple platforms. The key focus will be on efficiency and consistency in posting the provided text content at the optimal times across all platforms. These are Christian Channels (two). We will start with one and grow. Bonus: Since we are dealing with the Bible and scripture, your knowledge of the Bible will come in handy.
I am in need of a talented app developer who can design and create a mobile application compatible with both iOS and Android platforms. The primary objective of this app will be to aid with the tracking of a game. This must consist of a few specific features: - Allows player to input total points for each category - Ability to track and deduct cost from the players inputted total "points" for the category - Output purchased skills / spells into a final screen with buttons for each skill or spell purchased that when pressed are marked as "used" - Reset button which takes all current purchased skills or spells back to unused state - Ability to save "battle board" - the final screen of selected skills / spells - to be loaded later or switched with...
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...
Description: We are seeking a proficient product sourcing agent based in China who is adept at navigating and platforms. The objective of this project is to identify three verified suppliers for a specific product category and provide comprehensive details, including supplier contact information, lead time, and DDP (Delivery Duty Paid) pricing. Key Responsibilities: 1. Supplier Identification: Utilize and to search for reputable suppliers specializing in the specified product category. 2. Supplier Verification: Conduct thorough due diligence to verify the credibility and reliability of potential suppliers, ensuring they meet our standards for quality and reliability. 3. Supplier Contact Information: Provide accurate contact details for the selected
I'm seeking an expert in Python for a Natural Language Processing project focusing on text classification of social media posts. Key Project Features: - The goal is to build a Python coding notebook that can efficiently classify different types of text within social media posts. This will require a deep understanding of NLP principles and techniques. - The project primarily demands the use of Python for its implementation. Ideal Skills and Experience: - Expertise in Python programming is a must. - A strong background in NLP, particularly in the area of text classification, will be highly beneficial. - Prior experience working with social media text data would be a plus. If you're confident in your Python and NLP skills and have experience in text classificati...
I need an iOS app designed for college recruitment information and news. This app will cater to ...recruitment information and news. This app will cater to a target audience interested in college recruitment. It should be easy to navigate and provide informative blog posts. Key elements must include: - Smooth navigation for ease of use - Engaging and rich content writing for blog posts - 3 Pages: College Coaches Needs Blog Post, New Trends, College Tools and attachments to download from there. - Constant updates about college recruitment news Ideal Skills: - Experience with iOS App development - Understanding of the education sector – specifically, college recruitment - Strong writing skills for blog posts - Ability to ensure secure and private us...
...Part-Time WordPress Designer / Publisher ? Please read the entire project and respond only if you are the right candidate and agree with the salary. Automated bids will be ignored. About the Role: Are you a passionate WordPress enthusiast who loves design and development? We are looking for a Remote Part-Time WordPress Developer / Publisher to join our dynamic team. This role offers the flexibility to work from anywhere in Pakistan, collaborating with team members to create and maintain stunning WordPress websites. Responsibilities: Design & Development: Crafting visually appealing and fully functional WordPress websites. Content Management: Publishing and updating content across WordPress sites efficiently. Blog Management: Editing...
...for my business across various social media platforms. Key Requirements: - Experience with designing for Facebook, Instagram, Twitter, and LinkedIn - Proficiency in creating minimalistic graphics - Ability to work with specific colour schemes and branding guidelines Your role will involve: - Understanding the provided colour schemes and branding guidelines - Creating a variety of visuals for posts, stories, and ads on the specified social media platforms - Ensuring all designs are modern and minimalistic in line with the overall theme Ideal candidates would be able to take the provided colour and branding guidelines and translate them into engaging and effective social media content. Experience in creating visual content for multiple platforms would be a big plus. Looking for...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
