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 en php mysql, optimization jobs, n query, night jobs, mysql query optimization software, jobs for html programmer, jobs at night, html programmer jobs, html 5 dev, get job as a php programmer, optimize mysql query, optimize mysql query software, programmer en c, it programmer jobs, dev mysql com, Query optimization, programmer en php, optimize mysql, optimisation of php, mysql query, jobs board , optimize html, mysql specific

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 [login to view URL] 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 [login to view URL] to give us one opportunity. We have a strong team in webapps' [login to view URL] 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)