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 load.
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))
Hello. Nice to meet you :)
I have read your job carefully and I am interested in this.
I am expert in MySQL & Laravel and I have developed some projects over 5+ years.
I can start work immediately.
Due to my experiences in this field, I will bring you the perfect result in time with high quality.
I wish we will discuss more details via private chatting.
Best regards.
Cristian P.