Completed

mySQL Query Help

We are looking for an experienced mySQL writer to help us out from time to time on various projects.

In this project, our beginner query writers have written an query as an illustration of what we are looking to output. As detailed within the project documents linked, you will see that the query is not efficient at all and we need to a learn a better way to write it.

We use the UNION ALL function to aggregate the results of many very similar queries together into a single table output, and are hoping you can help us find a more efficient way of creating our desired outcome.

See our Scope of Work document for more details here:

[login to view URL]

Thanks for taking the time to look at our project!

Skills: MySQL, PHP

About the Employer:
( 6 reviews ) Plymouth, United States

Project ID: #24716770

Awarded to:

mmarovic

Hello, I looked at your query, and it is pretty clear to me how to make it faster: 1. you need an index on gpspushhistories consisting of vehicle_id and created_at (in that order). 2. condition DATE(gpspushhistories More

$25 USD / hour
(4 Reviews)
3.4

54 freelancers are bidding on average $33/hour for this job

omairusaf

Hi, I am an experienced mysql developer and avilable to help you with various mysql related projects. Please initaite chat so we can discuss peoject in detail. Best Regards, U-Y.

$50 USD / hour
(93 Reviews)
8.3
enok7128

Hi there, I have gone through google document and read scope of works. I have 8 years of experience in Database management, PHP, Mysql, HTML, SQL. waiting for your reply. Thank you

$25 USD / hour
(120 Reviews)
7.1
Brightinfotech3

Dear Sir/Mam, I Hope you are doing well..!!! I have gone through your project detail as per my understanding we need develop website based on your requirement. For more discussion kindly send me message on Freelancer More

$25 USD / hour
(229 Reviews)
7.2
sagarwal3005

Hi,I can start immediately and work as required to create the optimized SQL queries for faster results. I am a highly motivated professional expert in programming and design. I will go with you until the queries are a More

$38 USD / hour
(117 Reviews)
6.8
kailasamir

Hi there, We can certainly calculate the mileage.. using the queries.. subject to availability of certain information. I wont be discussing every aspect publicly. I request to open chat and discuss further. await More

$30 USD / hour
(61 Reviews)
6.6
bindmission

Hello Hope you are doing well. I have 7 years of experience in MySQL and PHP. I can handle this project. Regards VishnuLal*

$25 USD / hour
(229 Reviews)
6.5
schoudhary1553

Hello, I can help you with your project - mySQL Query Help I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projec More

$40 USD / hour
(61 Reviews)
6.3
siteshopping

Hello. I am an experienced mySQL writer to help us out from time to time on various projects. I have rich experience with MySQL, PHP which are the skills required to get this job done. For over 7 years, I have mastered More

$30 USD / hour
(12 Reviews)
6.0
Zeeshan0489

I WILL HELP YOU AM EXPERT IN PHP AND MYSQL Hi there! I've read the project details and ready to start making but can you message me i want to ask some questions about that. I am new to freelancer but i have an experi More

$30 USD / hour
(96 Reviews)
6.0
alkajain2906

Hi, I have 5+years Experience in Website/Software Design & Website Development. I'm an Expert in: -Frontend & Backend Development
-Zend
-Cake PHP -Python -Data Science -Machine Learning -JVM technologies -Jquery, PHP More

$38 USD / hour
(47 Reviews)
5.7
XD12jalandhar

Hello Client! I am a Highly Skilled freelancer with web design and development skills. Having more than 200+ clients with more than 3000+ websites over the globe with top quality profile.I found my self very eligible More

$33 USD / hour
(97 Reviews)
6.0
ImmortalStas

Hi, are you looking for Real MySQL Expert? Then WELCOME to the right place! High-quality and Fast-delivery is promised! As a highly skilled full stack developer, I have rich experience in writing mysql queries and db More

$35 USD / hour
(18 Reviews)
6.2
ahmadmtii

Hi,I'm Full Stack Developer. Developed many similar applications. I read your query optimization project description and very confident to handle this project perfectly as I have developed many similar applications in More

$25 USD / hour
(53 Reviews)
5.7
rakamarjan2020

Dear client. I'm expert at mysql query so I can surely do your task. I checked your google doc and no worry about complete task. Let's start. thanks.

$35 USD / hour
(21 Reviews)
5.2
IvanCoder204

Hi, thanks for your posting project. I am Ivan from Spain. I have read your job description carefully. I have over 10 years of Database development. I am sure I can help you as you want. Please contact me. If you hire More

$38 USD / hour
(17 Reviews)
5.0
Raf3Ddev

Hi, Here is classy web developer who are very familiar with MySQL query. I have worked on companies with Database manager and there was nothing impossible for me even very complex query requirements. If you give me an More

$30 USD / hour
(9 Reviews)
5.0
cuczoran

Hi, as a well-experienced MySQL expert, I can do this project perfectly as well as you want. I have ever designed, developed, and managed databases using MySQL on lots of websites like hospitals, shops, restaurants, co More

$38 USD / hour
(6 Reviews)
5.2
Nehag510

Hello, Warm Greetings!!     I read your job description completely and I found my skills relevant to your project. I am a professional web developer with 4+ years of programming experience for a multitude of different More

$28 USD / hour
(3 Reviews)
4.7
dilshadbukhari

Hello Sir, I have review the link and ready to do that. I am working in different platforms. (.NET Development, PHP (Core php, Codeigniter, Laravel, Opencart, WordPress), Android Development, Graphic Designing, Front-E More

$25 USD / hour
(29 Reviews)
4.8
KECHANKRISNA

Hello, how are you? I've read your job description carefully and I'm very interested in your job. I'm a senior developer with rich experiences of MySQL for 8+ years. I'm very good at MySQL queries so I can help you. If More

$25 USD / hour
(3 Reviews)
4.4