Completed

Help with mysql query

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.

Compétences : Administration de Bases de données, MySQL, PHP, Architecture Logicielle, SQL

en voir plus : edit csv mysql query, outsource help mysql database, asp mysql query, mysql commands, mysql select where, mysql help, mysql query commands, mysql syntax, mysql help forum, mysql experts online, mysql tutorial, mysql, database development, 2013 lost connection mysql query, mysql query parent child, mysql query report, php mysql query table, mysql query record bash, mysql query csv file, write mysql query

Concernant l'employeur :
( 45 commentaires ) Brasília, Brazil

Nº du projet : #17566468

Décerné à:

renjith007

Hi 112.639 is a number not string Remove quotes from it

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(5 Commentaires)
2.8

32 freelance font une offre moyenne de $22 pour ce travail

devikagupta

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(439 Commentaires)
7.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(215 Commentaires)
7.1
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(261 Commentaires)
6.6
softcarve

Hi, I would like to solve the syntax error in this query. Get in touch to discuss more. Available to start now. Regards, Manish

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(84 Commentaires)
5.8
sharmarahulraman

Hi, Hope you will be doing well!! Looking forward to discuss the project with you in detailed and get started. Thanks!!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(72 Commentaires)
6.0
cestis

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(63 Commentaires)
5.6
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
4.4
ziyaindia78

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(41 Commentaires)
4.5
infoshemeer

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(53 Commentaires)
4.3
jboo7

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 [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(17 Commentaires)
4.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(14 Commentaires)
3.9
carlamorillo2

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
3.4
xiongjiezhao222

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
3.3
davisuli

Hello my friend, give me your phpmyadmin credentials and i’ll help you really quick. I’m an expert mysql dev

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
3.1
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
2.7
Barrybk

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)
2.9
ankitbagre2000

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
2.7
achrafchiboub

Hi, I can do this work, ping me for more details...

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
2.8
shopshoppy

can do

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(18 Commentaires)
4.6
limillion819

Hi there. I am an expert SQL programmer and I can help you without hesitation and shortly. Please contact me for help. Regards.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
2.0