Disk full (/var/tmp/#sql_b8f_0); waiting for someone to free some space...
SELECT user.`id`, user.`contractor_logo`, user.`con_categoryid`, user.`firstname`, user.`tradename`, user.tradename_seo, user.`emailid`, user.`mobileno`, user.`service_lat`, user.`service_log`, user.`service_area`, user.`servicemiles`, user.`email_verify`, user.`profile_description`, user.`addeddate`, SUM(if(fed.`contractor_id` = user.`id` AND fed.`status`='1', 1, 0)) AS count, (SUM(if(fed.`contractor_id` = user.`id` AND fed.`status`='1', (fed.`qulaity`+fed.`service`+fed.`money`)/3, 0)))/SUM(if(fed.`contractor_id` = user.`id` AND fed.`status`='1', 1, 0)) AS ratingval, user.`con_categoryid` FROM jm_user as user LEFT JOIN jm_feedback as fed ON fed.`contractor_id` = user.`id` LEFT JOIN jm_category AS sub ON sub.`id` IS NULL WHERE user.`status` = '1' AND user.`delete_field` = 'No' AND user.`usertype` = 'T' GROUP BY user.`id` ORDER BY ratingval DESC ,count DESC