Mysql Laravel expert Need -- 6

SELECT * FROM posts WHERE status = 1 AND posts.worker_need> (SELECT COUNT (id) FROM prove WHERE job_id = [login to view URL] AND (status = 0 OR status = 1))

Here is the second condition that I am counting = (SELECT COUNT (id) FROM prove WHERE job_id = [login to view URL] AND (status = 0 OR status = 1)) With this query the whole server CPU becomes 100% just for this I wanted to know if there is any other way to do the count work where there will not be so much server [login to view URL] * FROM posts WHERE status=1 AND posts.worker_need > (SELECT COUNT(id) FROM prove WHERE job_id=[login to view URL] AND (status = 0 OR status = 1))

Skills: PHP, Laravel, MySQL, HTML

See more: companys canada need partner call center work campaigns, need script load access database, find mysql security expert, need typist books typing work pakistan, need linux apache mysql security expert, php mysql script expert, need program atmega32 ds1307 work alarm clock 16x2, urgently need can data entry work, need help load commerce, need working proxy post work, need form invoice contractual work, need signeture forum posting work, need feedback script can work godaddy, need website load faster, c# expert 5-6 hours of work, need creative designers to work on cafe design interior design and 3d modeling and rendring based on the documents i attached, i am to graduate with mechanical engineering this year and i need a full scholarship, Laravel Expert need urgent, laravel expert needed right away to work on my site . only experts, I want to work with mobile so please show that i need

Project ID: #28256417