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

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.

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 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...