Disk full (/var/tmp/#sql_b8f_0); waiting for someone to free some space...
SELECT postpjt.`id`, postpjt.`projecttitle`,postpjt.`project_id`, postpjt.`pro_projectdesc` , postpjt.`appropriate_status`, postpjt.`completion_time`, postpjt.`pro_location` , postpjt.pro_lat, postpjt.`pro_lang`, postpjt.`pro_maincatname`, postpjt.`pro_catname`,postpjt.`pro_catname_seo` , postpjt.`idealstart_date` FROM jm_postaproject as postpjt LEFT JOIN jm_user as user ON postpjt.`userid` = user.`id` WHERE postpjt.`status` = '1' AND postpjt.`processtatus` = 'N' AND postpjt.`delete_field` = 'No' AND user.`status` = '1' AND user.`delete_field` = 'No' AND postpjt.`actual_contractor_interest` > (SELECT COUNT(`id`) FROM jm_jobleadflowmgmt WHERE `status` = 'I' AND `jobid` = postpjt.`id` AND `rfr_deleted_field` = 'No') GROUP BY postpjt.`id` ORDER BY postpjt.`id` DESC