Ukończone

Need a quick MySQL query fix -- 2

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!

Umiejętności: Excel, JavaScript, Joomla, PHP, WordPress

Zobacz więcej: i need help with excel, php query mysql html drop select, php select drop list query mysql, asp query mysql html, query mysql con ajax, parent child query mysql, remote query mysql, bash script query mysql database, create update query mysql, query mysql data php entries, query mysql database information

O pracodawcy:
( 15 ocen ) Half Moon Bay, United States

Numer ID Projektu: #8245737

Przyznany użytkownikowi:

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 w ciągu 3 dni
(1 Ocena)
0.4

15 freelancerów złożyło ofertę na kwotę $23 do tego projektu

naveedmanzoor21

Dear Customer, Greetings from Dreamrun Technologies Private Limited. My name is micky. I have understood your issue and can fix it immediately. I couldnot see the attached file since there is no attachment. Więcej

$19 USD w ciągu 1 dnia
(31 Oceny)
7.0
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 Więcej

$24 USD w ciągu 0 dni
(155 Oceny)
6.5
angelsofttech

Hello Sir I have skills in PHP, Mysql, Jquery, Javascript, Ajax, HTML5, CSS5 and many more.. I am working since last 6 years. I have developed many custom websites for all above skills. Portfolio : http://www Więcej

$24 USD w ciągu 1 dnia
(51 Oceny)
5.8
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 Więcej

$30 USD w ciągu 1 dnia
(25 Oceny)
5.2
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 w ciągu 1 dnia
(44 Oceny)
5.7
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 Więcej

$29 USD w ciągu 1 dnia
(39 Oceny)
4.7
Webbleu

Greetings, We have gone through your requirement and would to take this opportunity to work on this project. Can you send a detailed requirement about your project. Please check few work done by us: Feel Więcej

$24 USD w ciągu 1 dnia
(13 Oceny)
3.5
khanf7854

Hello Thank you for posting this project.I am highly interested to do this app project.I can help you for done 100% satisfied work. I don't need any payment now. payment me when you are happy. I want long term work h Więcej

$25 USD w ciągu 0 dni
(7 Oceny)
3.2
barkatmulani

Although new to this freelance website, I have a well reputed freelancer profile on ELance ([login to view URL]). I have been working with database designing, programming and data migration projec Więcej

$19 USD w ciągu 1 dnia
(4 Oceny)
2.5
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 Więcej

$15 USD w ciągu 1 dnia
(7 Oceny)
2.7
enigmaitsolution

Hi There, I am Gourav from Enigma IT Solution, the Web and Mobile App design and development company registered in UK and INDIA. We completely understood your all requirements and looking to commence the job ASAP Więcej

$25 USD w ciągu 1 dnia
(2 Oceny)
0.6
ravindraji

Dear Sir I am Ravindra Gehlot Senior Php developer of dreamsoft Solution .. We have 8+ year experince in Php and all CMS related to php like Joomla wordpress and other framwork like zend ,codeignitor , and cakephp, Więcej

$10 USD w ciągu 1 dnia
(1 Ocena)
0.7
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 w ciągu 1 dnia
(0 Oceny)
0.0
RitaParikh

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

$25 USD w ciągu 1 dnia
(0 Oceny)
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 w ciągu 1 dnia
(0 Oceny)
0.0