Need a quick MySQL query fix -- 2

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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

ID Проекту: #8245737

Про проект

14 заявок(-ки) Дистанційний проект Остання активність Aug 11, 2015

Доручено:

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 за 3 дні(-в)
(15 відгуків(-и))
4.4

14 фрілансерів(-и) готові виконати цю роботу у середньому за $23

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 Більше

$29 USD за 1 день
(492 відгуків(и))
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 Більше

$30 USD за 1 день
(271 відгуків(и))
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 Більше

$24 USD за 0 дні(-в)
(279 відгуків(и))
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 Більше

$15 USD за 1 день
(139 відгуків(и))
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 за 1 день
(53 відгуків(и))
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 за 1 день
(1 відгук)
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 за 1 день
(0 відгуків(и))
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 за 1 день
(0 відгуків(и))
1.8