I need someone freelancer to help me to fix the query below:
select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on

The Appointment Setter will be working close call with the Sales Representative responsible for generating appointments by contacting potential clients following property listings, sales, events, promotions, and by pursuing inquiries and information requests as well as other means of outbound contact such as cold calling.

I have a account on [kirjaudu nähdäksesi URL:n]
Need export the data, to XLS o CVS format. whit a picture from each properties.
Im using [kirjaudu nähdäksesi URL:n]
If U know how to export, contact!
Please, DOnt waste my time. Need this asap!

I need you to write 2 articles seo friendly articles.
One for websites and then the other one is to go in our newsletter to increase upsell our products to offices only using 1 or 2 of our products. Most of the research done already.
One will be for the benefit of using all our products vs using multiple software’s, the other would be top reasons to use purpose built real estate websites wit...

Project Duration: 1 Hour
Project Overview
When trying to run this query:
SET `description` = REPLACE(`description`, 'â€™', '&#39;')
WHERE `description` like 'â€™%'
We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...

I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of

Scrape from a google spreadsheet into a database on Azure or EC2, and create a UI for non-technical people to query.
Make sure certain users can add but cannot delete data from the db. Also the UI should sanitize and validate the data before entering it int the database.

Our team is currently drafting a business plan to be proposed to the State for medical licensing approvals. Its a highly competitive licensing procedure and requires strong seasoned writers familiar with government technical writing such as RFPs, requests for proposals, grant writing, and license application writing. This will require a quick turnaround

Hello, We have a pitch deck created by a company in Massachusetts. We will need the pitch deck duplicated and changed to fill with information from New Jersey. The researcher must find all info regarding the cannabis market in New Jersey and be confident they can duplicate the powerpoint deck effectively.

I have a quick issue I just need some advice on Fixing or a slight change of code.
JSON Response is being presented to the app however, it won't append to the Dictionary that I'm trying to use.
Paying a maximum of $30AUD for this as it is a quick code fix. Just needs a simple fix.

Select rows to display the columns: name of product/service assign alias as “ProductService”, quantity sold of
product (invoice detail), employeeID who is assigned to the invoice; where the employee ID equals 1; sort by
name of product/service ascending.

I need a web researcher! I need someone who can search contacts from various departments in USA using linkedin, state directory, departments website and ofcourse google. You need to be good in finding business emails using keywords. Only a complete lead will be paid and emails for that is most important. Please share some previous work of this kind

I have a request table I need a few queries done on.
This is an excel sheet. I need to find out quick analytics on our user behavior.
It would be excellent to get the %, numbers and graphs depicting results.

This work involves a pdf file of shipping labels with multiple pages that needs to be sorted based on a reference number in a text file that matches a label/page within a pdf file.. ie A list of alpha numeric letters/numbers are given vertically in a text file that need to be searched within the pdf file and as the pdf file finds the queries within its pages (which is one per page), it creates a n...

I need an expert programmer who can help me with the following:
I have a client with an MLS service for Real State. Which I need to integrate into a wordpress.
I was looking at plugin possibilities and I got one called Estatik premium, which allows me to import the properties with their characteristics, but this is pay, and cant pay for that.
If you

I NEED A APP APP IN DIFFRENT PRIZE . EVERY DAY WIN A PRIZE.
PRIZE IN WINNER GURANTED IN PUBLIC
PRIZE TICKET PRIZE COST DIVIDED IN ADMIN OPTION
APP REGISTRATION EVERY PERSON WITH GOOGLE EMAIL OR FACBOOK OR MOBILE NO
IF ANY PERSON SHARE APP GET AND JOIN ANY PERSON PER PERSON 10 POINT WIN
IF JOIN 10 PERSON GET 100 POINT MEAN RS 2 & USE IN NUMBER IN PRIZE TICKET
ADD MONEY FEAUTRE ...

I have a query in place and would like to create a form with drop down boxes that allows the user to run the query based on the criteria they select. I have started the form but am struggling with linking the combo boxes to the query.

I usually create different types of reporting within Google Sheets but since it has a limit for th...analysis. I need a 2 scripts created in Javascript, that will create a connection between a Sheet and a Query already built and saved in BigQuery layer. 1 for uploading and appending new information and the 2nd for downloading the results of the query.

You must be able to communicate with multiple clients and have a good English grammar skills. You must have an understand of our values at our company and have knowledge in the area of business.. This is an on going project.

...create Mongodb query. It's maybe not the most complex query you ever find but we have not too much experience in MongodDB and how to use all this features.
The query will cover all the basis filters and the use of the geospatial feature (just a simple search of maxdistance usign coordinates, we already have this).
Basically, the query has to:
Search

This project is for a replica Washington State drivers license. It should be done in PhotoShop. I will provide the data and any images required to complete. The holographic layer needs to be kept separate.
This should be quick work for the experienced. I just lack the skill and time to learn how to do this myself.

This project is for a replica Washington State drivers license. It should be done in PhotoShop. I will provide the data and any images required to complete. The holographic layer needs to be kept separate.
This should be quick work for the experienced. I just lack the skill and time to learn how to do this myself.

Hi Data Entry People,
We need more than 10 people for data entry (condo property + HDB property + Commercial Property) of our newly launched real state portal.
The task is very simple and straightforward, one website contains all the info like property name, price and Unit etc. and you have to search another website with the name for Room Types

...newest car titles from every state, front and back. The copies can come from online forums, websites, etc, but cannot contain any watermarks from the site you get them from. They have to be clean copies/images. I would like all of these in jpg format and named in following format "name of state-title-front" and "name of state-title-back" example color...

Hi Data Entry People,
We need more than 10 people for data entry (condo property + HDB property + Commercial Property) of our newly launched real state portal.
The task is very simple and straightforward, one website contains all the info like property name, price and Unit etc. and you have to search another website with the name for Room Types

Do you know how to build a website similiar to these TWO SITES BELOW however our site will handle 3-4 USA states only not all 50 states
We will be local only
and will have 15-20 different types of entertainers CATERGORIES
take a look at
[kirjaudu nähdäksesi URL:n]
www,[kirjaudu nähdäksesi URL:n]

Hi I have a query which I use in SSRS report builder 2016 to display results in a chart.
Query is ok but I would like a column being pivot in the query and have never done this before.
Should be less than an hours work and your need to work via Any Desk on my system to change the query.
Get in touch if you can help.
Thanks, John