Optimize MySQL Query

I need someone to optimize a PHP/MySQL query which is slowing down my board software. It should get rid of "SELECT DISTINCT", just like described at [url removed, login to view]

For the specific query, see the attachment.

If I'm satisfied with the successful bidders job, there night be more optimisation jobs to come.

Budget is limited to $15 as this is a rather quick job for a experienced programmer.

Skills: PHP

See more: software programmer jobs, programmer mysql, programmer php mysql, optimization jobs, n query, night jobs, mysql query optimization software, jobs html programmer, jobs night, html programmer jobs, html dev, get job php programmer, optimize mysql query, optimize mysql query software, query optimization, programmer php, optimize mysql, optimisation php, mysql query, jobs board , optimize html, mysql specific, php mysql optimize, quot php mysql, mysql query php

About the Employer:
( 3 reviews ) Düsseldorf, Germany

Project ID: #206099

7 freelancers are bidding on average $30 for this job


Ready for it, please consider me and also see my php MYSQL work in pmb Thanks

$30 USD in 0 days
(34 Reviews)

Hello,I am ready to work now.Thank you.

$30 USD in 0 days
(51 Reviews)

view PM, thanks!

$30 USD in 1 day
(20 Reviews)

its an easy job.

$30 USD in 0 days
(40 Reviews)

You should view "show processlist" first. But I'm sure if you'll use STRIGHT_JOIN just after SELECT it'll optimize your query in ten times :)

$30 USD in 0 days
(24 Reviews)

dear floid, We have looked through your information and are interested in your project.Eager to give us one opportunity. We have a strong team in webapps' development.So we assure to comply with your deadline. We w More

$30 USD in 1 day
(1 Review)

this is a quick job! we can do this instantly.. lets start.. please check PMB for actual bid.

$30 USD in 1 day
(0 Reviews)