Server shutdown in progressselect houses.*, typesofhouses.type, typesofhouses.commercial, IF(agent_id > 0, 1, 0) as 'agent1'
         from pixilink_360.houses
         left join pixilink_360.typesofhouses on (typesofhouses.house_type = houses.type)
         where houses.house_id = 113936 and (agent_id = 4592 or agent_id2 = 4592)  and is_deleted <> 1 order by agent1 desc, house_id desc