Sql query posts category wordpressdela

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

Website seems to be broken , can access it but new posts through word press not happening . Its not allowing me to post new contents. I need to fix this so i can continue add content.

I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...

...have a Figma design that I would like converted into a highly animated functional website prototype. The goal of this project is to create a user-friendly, interactive representation of the design that can be used for testing and demonstration. Key Requirements: - The prototype should be developed using both Framer and Webflow. - The level of interactivity should fall under the intermediate category, including animations and transitions that enhance the user experience. Ideal Skills and Experience: - Proficiency in Figma, Framer, and Webflow. - Experience in creating interactive and functional prototypes. - A good eye for design and understanding of user experience principles. - Strong animation and transition skills. - Ability to work efficiently and meet deadlines. Please ...

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

Prosimo, vpišite se ali se prijavite za več podrobnosti.

...expert who can help me boost my sales through social media platforms. In particular, I'm looking for someone who can create engaging image posts to capture the attention of my target audience. Key Responsibilities: - Devise and execute strategies to promote sales effectively on social media - Create compelling image posts that resonate with my target audience - Regularly analyze and report on the success of the sales-boosting campaign Ideal Skills and Experience: - Proven track record of successful sales campaigns - Strong understanding of social media platforms and their nuances - Proficiency in creating engaging visual content, particularly image posts - Excellent analytical skills to measure campaign performance If you have a knack for sales, a passion f...

I need an experienced social media graphic designer to help me create 200 posts for LinkedIn, Facebook, and Instagram. These posts are intended to target the Saudi market and should focus on Saudi public holidays, patriotism, and similar themes. Key Responsibilities: - Develop 200 visually appealing and culturally relevant social media posts - Tailor content to suit LinkedIn, Facebook, and Instagram - Ensure all designs align with the Saudi market's interests and sensibilities Ideal Skills and Experience: - Proven track record in creating engaging social media graphics - Strong understanding of the Saudi market - Ability to work with themes like public holidays, patriotism, etc. - Proficiency in design tools and software - Excellent communication skills to unde...

I'm in need of a professional who can help me with a detailed cost estimation on concrete, rebar, and form work for a construction project. Key deliverables: - Detailed cost estimation: I'm looking for an itemized breakdown of costs by category. This will help me understand the expenses involved and make informed decisions. Skills and experience required: - Concrete, rebar, and formwork expertise: You should have a solid background in these areas to accurately estimate the costs involved. - Construction cost estimation: Experience in creating detailed cost estimations for construction projects is highly preferred. - Proficiency in Excel: The final document is expected to be provided in Excel format, so familiarity with using Excel for such purposes is a must.

I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...

I'm in need of an experienced social media manager and content writer who can help me boost my online presence. Key Responsibilities: - Manage social media accounts (platforms to be determined) - Develop and write engaging content including blogs, social media posts, and articles I'm looking for someone who can work closely with me to produce content that reflects the voice and tone of my brand. I am open to suggestions for content topics, but expect the freelancer to be able to create content that is engaging, relevant, and shareable. Ideal Skills and Experience: - Prior experience in social media management - Proven track record in content writing - Understanding of SEO and online marketing - Creative thinker with the ability to generate new ideas for content - Good...

I'm looking someone to writet to write content for my website blog. - The topics should revolve around fashion. - The posts are required to be suited for a general audience, so should avoid excessive jargon. - I'm looking for 1-5 blog posts in total. Ideal candidates for this job will have a passion for fashion and a talent for writing engaging blog content. It would be a plus if you have experience in the fashion industry.

I am seeking a skilled graphic designer with experience in creating attention-grabbing social media posts. The primary goal is to increase product promotion for my range of physical products. Key Responsibilities and Requirements: - Design visually engaging graphics for social media platforms - Create designs that effectively communicate and promote the features of the physical products - Ability to align designs with brand aesthetics - Prior experience in promotional material design will be immensely beneficial. The ideal freelancers for this project will be creative, experienced in marketing-focused graphic design, and have a solid understanding of social media trends. Please showcase your previous work in a similar domain during bidding. The company is nowfuture

Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should specifically target restaurants that have a phone number but *without* a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (meters) - Restaurant Type (including catch all types in the "Food and Drink" category) Key Data to Retrieve, output in a .CSV: - Name - Address - Phone Number - Google Maps URL Ideal skillset: - Proficient in Python - Strong experience with Google Maps/Places API - Ability to deliver results promptly and efficiently - Attention to detail to ensure accurate data retrieval

I'm seeking a blog writer to create content focused on different types of bras and their benefits, mainly targeting a female audience. The tone should be informative and educational. Key Requirements: - In-depth knowledge and understanding of various types of bras. - Proficiency in creating engaging, SEO-friendly content. - Prior experience in writing for a female audience, particularly on the subject of lingerie or fashion, is highly desirable.

I require a SketchUp professional to accurately and efficiently create structural, electrical, and plumbing diagrams for an existing multi-family residential building. This is primarily for use in building permit applications. Specifi...documentation for successful commercial multifamily residential permit applications will be highly regarded. In addition to the floor plan (in attached file) there is a crawlspace underneath with the electrical and plumbing connections. The initial contract will be for (1) the building exterior (walls, walkways, windows, doors, roof, parking, and decks), (2) the building crawlspace (support posts, plumbing, electrical [main building panel with connections to the 10 subpanels only]), (3) detail plumbing, electrical, and floorplan work in a single ...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

...experienced social media manager who can help me in creating and scheduling 200 posts for LinkedIn, Facebook, and Instagram. The posts will aim to target the Saudi market, focusing on Saudi public holidays, patriotism, and more. The requirements for this job are as follows: - Create 200 posts: The posts should be engaging, creative, and tailored for a Saudi audience. They should include high-quality, royalty-free stock photos and be bilingual in both English and Arabic. - Schedule posts: Utilizing Odoo Social Marketing, the successful candidate will be responsible for scheduling these posts for optimal times to reach the target audience. - Target Saudi Market: Understanding the Saudi culture and market is crucial. The posts should resona...

...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...

As the owner of a WordPress powered website, I find myself beset by an issue related to the appearance of my homepage on mobile devices. First, it appears the layout of the mobile version differs significantly from the desktop version. I'm looking for someone who can troubleshoot this and ensure consistency across both versions. Your first task will involve ensuring the same layout for both desktop and mobile versions, mirroring the successful desktop version's layout. Next, there's a glitch with the content display on my mobile homepage. It seems to be displaying content incorrectly, and I need you to rectify this. Essentially, your role here will be to fix any errors that cause incorrect content display on mobile, making sure all elements appear as they should. L...

...app: Dashboard gallery - has a + button that creates a post (see screenshot) - displays rows of 5 thumbnails (similar to Instagram) (see screenshot) Post A post can take 3 forms: - static weight text (ie. 71.3, ^0.5 - where the latter is the weight gained compared to the previous logged weight) (see screenshot) - a photo (see screenshot) - date (ie May 19) (see screenshot) Post interaction - Posts can be deleted or be created Gallery conditions - Displays rows of 5 thumbnails (see screenshot) - If it is the first post of the day, the gallery adds a thumbnail of today's date before adding the actual post (see screenshot) Post condition static weight text - If the weight is equal to the previous logged weight (or if it is the first weight), give it an orange background co...

I'm in need of a skilled crowdfunding promoter who can help amplify a critical GoFundMe campaign. After my business suf...critical GoFundMe campaign. After my business suffered severe damage due to a roof collapse, insurance failed to cover the costs. Here's what I'm looking for: - Expertise in promoting GoFundMe campaigns, specifically for crisis situations. - A strong grasp of social media platform algorithms (Facebook, Instagram, Twitter) to increase campaign visibility. - Ability to craft compelling social media posts that will inspire donations. - Understanding of insurance claims and disputes would be a bonus. This job requires empathy, excellent communication skills, and a knack for social media strategy. Your support will make a tangible difference in helpin...

...content creation tasks. This project encompasses three main areas: blog articles, website content, and social media posts. Here's a breakdown of what the project entails: - Blog Articles: I'm looking for creative writers who can generate engaging and informative content for my blog. This includes conducting research on relevant topics and producing high-quality articles. - Website Content: The ideal candidate should be able to help me develop compelling and SEO-friendly content for my website. This may involve writing product descriptions, service pages, or general information about my business. - Social Media Posts: I require assistance in crafting catchy and shareable posts for my social media channels. This will involve understanding my brand voice...

...content creation tasks. This project encompasses three main areas: blog articles, website content, and social media posts. Here's a breakdown of what the project entails: - Blog Articles: I'm looking for creative writers who can generate engaging and informative content for my blog. This includes conducting research on relevant topics and producing high-quality articles. - Website Content: The ideal candidate should be able to help me develop compelling and SEO-friendly content for my website. This may involve writing product descriptions, service pages, or general information about my business. - Social Media Posts: I require assistance in crafting catchy and shareable posts for my social media channels. This will involve understanding my brand voice...

...also assist with data entry and social media management tasks. Key Responsibilities: - Email management: Organize my inbox, flag important emails, and respond to non-critical messages - Appointment scheduling: Use my calendar to book meetings, calls, and other engagements - Data entry: Inputting various information into spreadsheets or databases - Social media management: Assist in scheduling posts, engaging with followers, and monitoring metrics I need someone who is: - Proficient in using computers - Highly organized and proactive - Excellent at following instructions - Skilled in communication - Experienced in a similar role, especially in email and appointment management This is a long-term role, and the selected individual should be available for more than 20 hours per ...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...

As the project owner, I am encountering various indexing problems on my WordPress website. These issues specifically stem from noindex tags and canonical errors. To elaborate, certain sections of my website, including the homepage, blog posts, and product pages, are experiencing these technical glitches. I require an expert with proficiency in the following: - In-depth knowledge of WordPress SEO - Proficiency in handling technical SEO components, specifically noindex tags and canonical errors - Experience in indexing website pages Your task will be to: - Effectively remove the noindex tags from the specified pages - Accurately fix canonical errors on these pages Ive literally tried EVERYTHING and nothing will get my website indexed properly This job entails deal...

...on social media. - SEO: Primarily aimed at Google - Enhancing keyword strategy - On-page and off-page optimization - Regular monitoring and reporting - SMO: Focused on brand awareness - Creative and engaging social media content - Consistent posting schedule - Interaction with audience to build engagement Currently, I have a variety of content formats available for your use: blog posts and articles, images and infographics, as well as videos and animations. Your job will be to leverage these assets effectively to meet the SEO and SMO goals. The ideal candidate for this job should have: - Proven experience in successful SEO and SMO campaigns - Strong understanding of Google's search algorithm and social media trends - Excellent content creation and curation sk...

I'm looking for a skilled content creator to help manage my cosmetic brand's online presence. Key Responsibilities: - Create engaging social media posts for Instagram, Facebook, and Twitter that resonate with our female audience - Develop and produce informative and visually appealing video tutorials for our products Ideal Skills: - Proven track record in creating engaging social media content - Ability to produce high-quality video content - Understanding of the beauty and cosmetics industry, particularly as it pertains to women This is a long-term project, so I'm looking for someone who can consistently deliver high-quality, on-brand content. A passion for beauty and cosmetics would be a bonus.

...creation, and infographics. Key Responsibilities: - Craft engaging and SEO-optimized articles that resonate with industry professionals - Develop compelling social media posts for Facebook, Twitter, and LinkedIn -Build LAnding Pages to help funnel customers into further engagement. - Design visually appealing infographics that tell our brand story and catch the eye of potential customers Ideal Candidate: - Experience in creating marketing content for a B2B audience - Proficient in SEO techniques and keyword research - Ability to create aesthetically pleasing infographics - Skilled in writing and formatting engaging social media posts - Prior experience in lead generation content creation is a plus Your work will be pivotal in increasing our brand recognition and drivin...

I'm looking for an expert in Microsoft Power Apps to develop...the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functional solution w...

I'm in need of a data entry clerk who will be working with text data and will organize it by category. The data doesn't require validation or verification, just simple categorization. Ideal candidate should: - Possess excellent attention to detail - Be proficient in data entry - Have experience working with text data - Be able to categorize information effectively This is a fairly straightforward task that requires precision and organization. I'm looking forward to working with someone who is reliable and meticulous in their work.

I'm looking for a skilled and creative content writer who can deliver engaging and high-quality content across various platforms. The content will be varied, covering blog posts, website copy, and social media posts. The chosen writer must have a good understanding of different writing styles and be able to adapt their tone and voice to suit each individual platform. Key Requirements: - Experience in writing for blog posts, websites, and social media - Proficient in writing for the fashion, technology, and travel industries - Ability to create content that is informative, promotional, and educational - A strong portfolio demonstrating previous work in these fields Ideal Skills: - Excellent research and writing skills - Ability to meet deadlines and produce quali...

I'm in need of an enthusiastic and creative content creator with a focus on technology. Your tasks will primarily revolve around generating blog posts, video scripts, and social media posts. You'll be assisting me on a daily basis to deliver fresh and engaging content to my audience. Key Responsibilities: - Crafting compelling blog posts on various tech topics - Scripting engaging videos that resonate with our audience - Formulating concise and captivating social media posts Ideal Candidate: - Proficient in the technology industry, with a solid understanding of current trends and developments - Proven ability in creating high-quality, engaging written content - Experience in scripting for video content - Skilled in tailoring content for different p...

We are seeking a virtual assistant to assist with daily job posts on LinkedIn. Key Responsibilities: - Daily job post on LinkedIn, once a day at the time slot of your preference. The ideal candidate for this role should be well-versed with LinkedIn and have excellent organizational skills to ensure the job posts are made consistently and timely. A creative individual who understands the dynamics of job postings and can present them in a professional yet engaging manner will be highly preferred. This role need no experiance so anyone can apply, this may be a perfect fit for you.

I need a Python Selenium application that can scrape blog posts from Site A and post them on Site B. Key Requirements: - The Python app should be built using Selenium for web scraping and automation. - It should be able to extract blog posts from Site A, specifically. - The extracted data must be posted on an existing blog section of Site B. Ideal Skills & Experience: - Proficient in Python, with experience in building web scrapers. - Strong knowledge of Selenium for web automation. - Previous experience with data extraction and manipulation. - Understanding of web protocols and site structures. - Familiarity with blog post formatting and publishing is a plus.

Looking for an innovative content creator who's skilled in developing engaging social media posts and videos. Given that our target audience spans both B2B and B2C markets, experience in crafting cross-market content is essential. The ultimate goal of the campaign is threefold: - Amassing greater brand recognition - Bolstering website traffic - Sumptuously generating leads Thus, a track record in successfully achieving these objectives would be a huge bonus. Applicants need to possess an understanding of market-specific appeals and be proficient in embracing a variety of social media platforms and video creation tools.

I'm in need of a skillful social media savant with extensive experience in managing Facebook and Instagram platforms. The primary aim of this project is to generate leads, thus beneficial conversions for my business. For this role, the perfect fit would be someone who: - Is adept at curating and generating engaging product-promotion posts - Is proficient at managing and encouraging user-generated content - Can align content strategy and posts with our lead generation goal - Has a broad range of experience in increasing visibility and follower engagement - Is knowledgeable in social media analytics to track performance and conversion rates. Ultimately, I hope to leverage the power of social media to tap into new markets and attract potential leads.

I'm looking for a talented designer to create an eye-catching feature wall for our children's birthday party venue that's perfect for Instagram posts. Key Requirements: - Bright and Vibrant Design: The wall should be designed in bright and vibrant colors to attract both kids and parents. - LED Lighting: The addition of LED lighting will make it stand out and create a fun and lively atmosphere. - Wallpaper: Incorporating wallpaper will add texture and depth to the wall. - LED Balloons: I'd like to include LED balloons to add an extra element of fun and excitement. - 'Happy Birthday' Text: The wall should also incorporate this text in a creative way. Theme: - The wall design should reflect a nature-inspired theme, focusing on elements like the sky, clo...

I'm looking for a talented designer to help me with a 3D redesign of the drinks area in a supermarket. Key Points: - Your primary task will be to rearrange the shelving layout in a 3D model. - I'm looking for a layout that enhances customer flow and maximizes product exposure. - There's no specific product category to prioritize at this stage, but your layout should be flexible enough to accommodate different products. I'll provide you with the current layout, and any other needed details. Ideal skills and experience for this project: - 3D modeling and design experience. - Retail or supermarket layout design experience would be a big plus. - A good understanding of customer behavior in a retail environment. Your design should be practical, visually appeal...

I'm looking for a seasoned writer to assist me with a dual project: a business report and a series of blog posts. Responsibilities: - The business report should be well-researched, focusing on key areas such as marketing strategies, financial analysis, and industry trends. - The blog posts should be engaging and informative, tailored for a specific target audience which may include business professionals, entrepreneurs, and the general public. Ideal Skills and Experience: - Proven experience in business writing, with an emphasis on reports and blog posts. - Ability to conduct thorough market research and competitor analysis. - Strong understanding of sales forecasting and how to present this data in a clear and impactful way. This project is an excellent op...

...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...

v2 - user can find merchant and register in their user account. after admin approve, Merchant can create shop and promotion. User will get 0.1% of their total sales, check v3. - shop field (brand name, address, website, whtasapp, facebook, description, category, City, how many brands, open for agency?(radio button)) - promotion field (title, normal price, now selling price, description, expire date, point weight - V4 user can follow shop to see their promotion in feed, also can apply to be their agent. - agent can share the promotion with uniqic referral link which will earn 2% v3 - point system- user purpose any thing will get point same as the price, usd 23.12, will get 23.12 points. if point weight is 2, then he will get 46.24 point. - when userB purchase, user A will get 1% pr...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

...setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on

...high-quality backlinks to my website. Key Responsibilities: - Build DA30+ backlinks: The primary goal of this project is to improve my website's search engine ranking. To accomplish this, I need someone who can acquire backlinks from websites with a Domain Authority of 30 or higher. - Diverse portfolio: I am looking for a freelancer who can provide a diverse portfolio of backlinks, including guest posts, niche edits, and other effective strategies. Ideal Candidate: - Experienced in SEO: The ideal candidate should have a strong background in search engine optimization and be familiar with white-hat link building techniques. - Proven track record: I am looking for someone with a proven track record of improving website rankings through backlink building. - Communication sk...