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
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.
32 freelance font une offre moyenne de $22 pour ce travail
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 c Plus
Hi, I would like to solve the syntax error in this query. Get in touch to discuss more. Available to start now. Regards, Manish
Hi, Hope you will be doing well!! Looking forward to discuss the project with you in detailed and get started. Thanks!!
Hi there. I see an error in your query and I know how to fix it. Message me - I'm online and can do that now. Regards.
Fixed query --------------------------------------------- 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 Plus
I am experienced in web development using PHP, CODEIGNITER, MYSQL, MYSQLI, POSTGRE, GIT, API, WEB SCRAPING, CAKE PHP, CUSTOM FRAMEWORKS ,YII2, Nodejs, Angularjs , Laravel and also added Paypal, [login to view URL], ccavenue, Plus
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, look Plus
Hi, Didn't you missing the ) in the end of line 6 of your sql command image... Let me know if you have still issue... Regards
Hello my friend, give me your phpmyadmin credentials and i’ll help you really quick. I’m an expert mysql dev
Senior database administrator is here with vast experience in mysql database.I can resolve your issue that you are facing right now with my expertise. Ping me back to get quickly [login to view URL] forward to hear from Plus
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 there. I am an expert SQL programmer and I can help you without hesitation and shortly. Please contact me for help. Regards.