SELECT b.id, b.company as company_title, b.img FROM smcontents_b_vacancy a JOIN smcontents_b_user b ON a.user_id = b.id WHERE b.agency = 0 AND b.main = 1 AND a.visible = 1 AND a.display = 1 GROUP BY b.id ORDER BY RAND() /*LIMIT 0,5*/
Got error 28 from storage engine