SELECT SQL_CALC_FOUND_ROWS agent.name agentname,agent.phone1 agentphone1,agent.phone2 agentphone2,agent.agent_id agent_id, client.name, client.surname, client.phone1, client.phone2,client.phone3, object_id, deal_type, object_type, city, object.region_id, street_id, dom_num, level_num, levels,total_area,living_area,kitchen_area,uch_area,price,torg,room_num, created,prozvon,prozvoninfo,pics, year, planirovka, material,object.status, balkon,lodzhia,toilet,floor,holvoda,gorvoda,vezd,electroline,gaz,sost_snaruzhi,sost_vnutri,ostanovka,orientir,info1,dopisloviya,avans FROM object LEFT JOIN client ON object.client_id=client.client_id LEFT JOIN agent ON object.agent_id=agent.agent_id LEFT JOIN spr_city ON object.city_id=spr_city.city_id LEFT JOIN spr_region ON object.region_id=spr_region.region WHERE object_type = 'Участок' AND object.region_id='Чкаловский' AND object.room_num='' AND deal_type='Продажа' AND object.object_id<>4425 AND object.city_id=spr_region.city_id ORDER BY prozvon DESC LIMIT 0, 4 ~~Got error 28 from storage engine