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:


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)

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


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)

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)

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)

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)

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)

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)

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)

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)

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)

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

$38 USD / hour
(47 Reviews)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)