Need a quick MySQL query fix -- 2

Completado Publicado Aug 11, 2015 Pagado a la entrega
Completado Pagado a la entrega

I have a quick MySQL query fix that I need help with. First part is an issue with a left join and second part is optimizing a subquery to execute faster. I have attached an excel workbook with the problem.

1. The left join is returning null on all values when the right table does not have a corresponding key. I need the values in the left table what am I doing wrong.

2. The subqueries ex:IFNULL(unit_sales1 - prev_unit_sales1,(SELECT IFNULL(max(datetimesql),'NS') FROM storeCheckRecords WHERE store_id=@storeid AND upc=855555000019)) as diff_unit_sales1...... are slowing down the query significantly. This query is currently at 10 secs and less than 1 sec without the max(datetimesql)... subqueries. How can I optimize for speed?

Please let me know if you need anything else and I hope you are available. Thanks!

Excel JavaScript Joomla PHP WordPress

Nº del proyecto: #8245737

Sobre el proyecto

14 propuestas Proyecto remoto Activo Aug 11, 2015

Adjudicado a:

angnut

Hi, please send me attached excel and complete queries to fix. Do you use these queries into stored procedure, code (PHP), sql shell? You can find my skills and references on linkedin (angnut) Thanks. Angelo

$30 USD en 3 días
(15 comentarios)
4.4

14 freelancers están ofertando un promedio de $23 por este trabajo

harshatilva

Hi, I hope you are doing fine. I am new to freelancing but I have 4 to 5 year experience in designing and developing. I read your project description and would like to work with you. I will provide you 100% sa Más

$29 USD en 1 día
(492 comentarios)
7.9
Webicules

Hi, There is no attachment in the job description. Please share the snapshots if any. I am available to fix the issue within few hours. Please message me to discuss the details. I am expert in Joomla and have Más

$30 USD en 1 día
(271 comentarios)
8.3
technovation1

Hi there !! I can fix both the query efficiently. I can solve the table problem and the subqueries. I am expert in PHP,myql,and and have over 6 years of experienced. Message me in my personal message box so Más

$24 USD en 0 días
(279 comentarios)
7.2
mrbacklink

I am Omprakash and have 12+ developer and 7 SEO Expert with 5+ year work experienced in thier skill's, my portfolio will express my work quality that is very important for every deal between you and me, and my miss Más

$15 USD en 1 día
(139 comentarios)
6.3
kotharigaurav90

Hello, i have checked your project and would like to have your project. I am confident to fulfill your requirements in timely manner, along with quality work. Please check your pmb.

$25 USD en 1 día
(53 comentarios)
5.8
Corbusllp

We have team to peform these kind of job, please award this project so that we can start and fix the problem

$25 USD en 1 día
(1 comentario)
1.9
RitaParikh

I read your requirement I can start work and complete work within your time limit message me to start work

$25 USD en 1 día
(0 comentarios)
0.0
logiccodersx

Please send us the attachment with full details. We will tune and fix the query to execute faster as you are expecting.

$25 USD en 1 día
(0 comentarios)
1.8