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 tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '30') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '188'), products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id
and
(case
when [login to view URL] = '1'
then (s.specials_new_products_price+(s.specials_new_products_price *(REPLACE(tr.tax_description, '%', '') /100)))
else (p.products_price+(p.products_price *(REPLACE(tr.tax_description, '%', '') /100))
end) >= '112.639')
and tr.tax_class_id = p.products_tax_class_id and p.products_id in (257,258,259,260,261,1,6,57,117,5,90,275,278,279)
obs.: the error message follows on attachment.
hello,
i understand your requirements...
please contact me or accept my bid so that we can discuss more and start soon... i m expert in this type of projectInfo...
u can also see my portfolio... please, give me a chance to fulfil your requirements..
hope u will do
i m waiting for your response..
thank you.. :)
I am having experience from past 9+ years
& completed 120+ projects in PHP & MTSQL development.
I can easily achieve the results that you are asking for.
Looking forward from your end.
Thanks
Hi, I can help you with your query. It looks like you have an extra paren ")". Also, need to check the formula, something seems ambiguous...
Hope we can work together...
EDIT: I think I have it done. Indeed, looks like a paren issue... I would like you to test the fix...
I am a Data Scientist with 3+ years of experience. I am comfortable in SQL along with various other tech. I can help you with this and provide full explanation of the fixes done.
Relevant Skills and Experience
SQL
Data Scientist
Hello dear contractor,
I have plenty experience working with mysql queries,
Just by looking at the image with the error, I'm pretty sure I can fix the error you have in your query in no time.
It'd be good if I could connect to your computer or have access to the tables (could be a demo with sample data) so I can test what I think will fix the issue.
If you're interested let me know so we can fix this ASAP.
Looking forward to your positive response.
Regards,
Hi sir,
you just simply misplaced ) sign.
Please let me contact me sir, i will give you correct SQL query.
I have finished correcting your SQL query...
Hi, I got the problem and I can help you to fix it. Because something got mixed up, It only requires a minute to solve it. Please contact me in private for the solution.