laravel 5 eloquent expert to rewrite Eloquent scope function

Please read carefully. I have a vehicle listing page with filters. I have created a scope for applying some filters to the vehicles listing. The scope function has eloquent whereHas method. But it has serious performance issues while executing query because I see each whereHas is converted to subqueries. I need you to convert the whereHas to Joins.

See my function here

[url removed, login to view]

Only experts may apply after going through code. Will not be paying for half work, need to convert all whereHas to join for increased performance.

Skills: Laravel, MySQL, PHP

See more: translate english to xhosa dad if you don t want to see me then i will just go to my lawyer i need my car fixed, laravel eloquent rules, laravel eloquent orm, laravel eloquent, laravel eloquent model validation, url rewrite expert, metatrader4 api pdf download function windows free mq4 expert, htaccess rewrite rule ajax function, function gmtoffset expert metatrader, htacess rewrite expert, drupal easy website build, alibaba website build, handicapping website build service design, joomla commerce website build, full website build, copy exitsing website build site, hire yahoo store mod rewrite expert, mod rewrite expert, drag drop website build bracelet, teacher rating website build

About the Employer:
( 5 reviews ) Ernakulam, India

Project ID: #11883117

3 freelancers are bidding on average ₹1833 for this job


I am Alpesh. I am experienced developer from India and I am interested in your project. I have 6+ years of experience on PHP development. I have good experience on Laravel. We have developed many application using La More

₹1750 INR in 1 day
(8 Reviews)
₹1700 INR in 1 day
(0 Reviews)

I Mahesh Yadav, Professional & Experienced Freelance Developer From India with 8.5+ years of experience. I am well experienced programmer with a good technical & analytical ability expertise. I am feeling expert all of More

₹2050 INR in 1 day
(0 Reviews)