"AND item_title_ru !="

"AND item_title_ru <>"

	 function getObjectList($type = 'house', $lang='de', $buy = null, $city = null, $page = 1, $number = 15, $order = 'created'){
		$limit = $number;
		$offset = ($page-1)*15;

		//$orders = array('created','modified','rooms','price','area','area2','area3','buildyear');
		//$types= array('house', 'apartment', 'gewerbe', 'grundstuck', 'projekt', 'rendite', 'verkauft');
		
		//if ($page == null || !is_int($page)) $page = 1;
		//if ($number == null || !is_int($number)) $number =15;
		//if ($order == '' || !in_array($order, $orders)) $order = 'created';
		//if ($type == '' || !in_array($type, $types)) $type = 'house';

if ($buy != null) $buy = "AND `item_$buy` = 1 "; else $buy ='';
		
		if ($city != null && is_string($city) && strlen($city)<20) {
			$select = array(
				'pforzheim' => "`item_buero_ort` LIKE 'Pforzheim'",
				'muhlacker' => "`item_buero_ort` LIKE 'Mьhlacker' OR `item_buero_ort` = 'M'",
				'stuttgart' => "`item_buero_ort` LIKE 'Stuttgart'",
				'baden-baden' =>"`item_buero_ort` LIKE 'Baden-Baden'",
				'bad-wildbad'=>"`item_buero_ort` LIKE 'Bad-Wildbad'",
				'karlsruhe' =>"`item_buero_ort` LIKE 'Karlsruhe'",
				'other' =>"`item_buero_ort` = '' ",
				'spain' =>"`city_country` LIKE 'ESP'",
				'france' =>"`city_country` LIKE 'FRA'",
				'russia' =>"`city_country` LIKE 'RUS'",
				'greece' =>"`city_country` LIKE 'GRE'",
				'italien' =>"`city_country` LIKE 'ITA'",
				'monaco' =>"`city_country` LIKE 'MCO'",
				'croatia' =>"`city_country` LIKE 'HRV'",
				'egypt' =>"`city_country` LIKE 'EGY'"
			);
			
			$query = 'SELECT * FROM `immo_items` a 
					  LEFT JOIN `immo_cityindex` b ON a.item_cityindex_id = city_id
					  WHERE '.$select[$city].'  '.$buy.' AND `item_'.$type.'` = 1  AND item_title_'.$lang.' != \'\' AND item_active = 1
					 ORDER BY `item_'.$order.'` ASC
					  LIMIT  '.$offset.' , '.$limit.';';
			$count = 'SELECT COUNT(*) FROM `immo_items` a 
					  LEFT JOIN `immo_cityindex` b ON a.item_cityindex_id = city_id
					  WHERE '.$select[$city].' AND `item_'.$type.'` = 1 '.$buy.' AND item_title_'.$lang.' != \'\' AND item_active = 1';
			
		}else{
			$query = 'SELECT * FROM `immo_items` a LEFT JOIN `immo_cityindex` b ON a.item_cityindex_id = b.city_id
					  WHERE  item_'.$type.' = 1 '.$buy.' AND item_title_'.$lang.' != \'\' AND item_active = 1
					  ORDER BY `item_'.$order.'` ASC
					  LIMIT  '.$offset.' , '.$limit.';';
			$count = 'SELECT COUNT(*) FROM `immo_items` a LEFT JOIN `immo_cityindex` b ON a.item_cityindex_id = b.city_id
					  WHERE  item_'.$type.' = 1 '.$buy.' AND item_title_'.$lang.' != \'\' AND item_active = 1';
			
		}
		$this->_db->setQuery($query);
		$result = $this->_db->loadAssocList(); 
		$this->_db->setQuery($count);
		$result['number'] = $this->_db->loadResult();
		if (is_array($result[0])){
			$i=0;$id = array();
			while ($result[$i]['item_id']){
				$id[] = $result[$i]['item_id'];
				$i++;
			}
			
			$query = 'SELECT * FROM immo_images
					  LEFT OUTER JOIN  immo_imgdesc ON img_imgdesc_id = desc_id
					  WHERE img_item_id IN ('.implode(',',$id).') AND img_sort = 1';
			$this->_db->setQuery($query);
		
			$result['img'] = $this->_db->loadAssocList();
		}
		
		
		
		return $result;
	}
	
	function getCountry($lang='de', $city = null, $page = 1, $number = 15, $order = 'created'){
		$limit = $number;
		$offset = ($page-1)*15;	 
		
		
			$select = array(
				'pforzheim' => "`item_buero_ort` LIKE 'Pforzheim'",
				'muhlacker' => "`item_buero_ort` LIKE 'Mьhlacker' OR `item_buero_ort` = 'M'",
				'stuttgart' => "`item_buero_ort` LIKE 'Stuttgart'",
				'baden-baden' =>"`item_buero_ort` LIKE 'Baden-Baden'",
				'bad-wildbad'=>"`item_buero_ort` LIKE 'Bad-Wildbad'",
				'karlsruhe' =>"`item_buero_ort` LIKE 'Karlsruhe'",
				'other' =>"`item_buero_ort` = '' ",
				'spain' =>"`city_country` LIKE 'ESP'",
				'france' =>"`city_country` LIKE 'FRA'",
				'russia' =>"`city_country` LIKE 'RUS'",
				'greece' =>"`city_country` LIKE 'GRE'",
				'italien' =>"`city_country` LIKE 'ITA'",
				'monaco' =>"`city_country` LIKE 'MCO'",
				'croatia' => "`city_country` LIKE 'HRV'",
				'egypt' =>"`city_country` LIKE 'EGY'"
			);
			
			$query = 'SELECT * FROM `immo_items` a LEFT JOIN `immo_cityindex` b ON a.item_cityindex_id = b.city_id
					  WHERE '.$select[$city].' AND item_title_'.$lang.' != \'\' AND item_active = 1
					  ORDER BY `item_'.$order.'` ASC
					  LIMIT  '.$offset.' , '.$limit.';';
			$count = 'SELECT COUNT(*) FROM `immo_items` a LEFT JOIN `immo_cityindex` b ON a.item_cityindex_id = b.city_id
					  WHERE '.$select[$city].' AND item_title_'.$lang.' != \'\' AND item_active = 1';
			
		
		$this->_db->setQuery($query);
		$result = $this->_db->loadAssocList(); 
		$this->_db->setQuery($count);

		$result['number'] = $this->_db->loadResult();
		if (is_array($result[0])){
			$i=0;$id = array();
			while ($result[$i]['item_id']){
				$id[] = $result[$i]['item_id'];
				$i++;
			}
			
			$query = 'SELECT * FROM immo_images
					  LEFT OUTER JOIN  immo_imgdesc ON img_imgdesc_id = desc_id
					  WHERE img_item_id IN ('.implode(',',$id).') AND img_sort = 1';
			$this->_db->setQuery($query);
		
			$result['img'] = $this->_db->loadAssocList();
		}
		
		
		
		return $result;
	}

	function getObject($obj_id){
		$query = 'SELECT * FROM `immo_items` LEFT OUTER JOIN immo_cityindex 
				   ON item_cityindex_id = city_id  
				   WHERE `item_id` = '.$obj_id.';';
		$this->_db->setQuery($query);
		$obj['info'] = $this->_db->loadAssoc();
		
		
	
		
		$query = "SELECT * FROM `immo_langvalues`
				  INNER JOIN `immo_langlabels` ON value_langlabels_id = label_id
				   WHERE `value_active` = 1 
				   AND `value_items_id` = $obj_id";
		$this->_db->setQuery($query);
		$obj['properties'] = $this->_db->loadAssocList();
		
		
		$query = "SELECT * FROM immo_images a LEFT JOIN immo_imgdesc b ON a.img_imgdesc_id = b.desc_id 
				  WHERE img_item_id = $obj_id ";
		
		
		$this->_db->setQuery($query);
		
		$obj['images'] = $this->_db->loadAssocList();
		
		$buro = $obj['info']['item_buero_ort'];
		
		$select = array(
			'Pforzheim' => 1,
			'Mьhlacker' =>6,
			'M' => 6,
			'Stuttgart' =>2,
			'Baden-Baden' =>4,
			'Karlsruhe'=>5);
		$query = "SELECT * FROM `immo_bueros` WHERE `b_id` = '".$select[$buro]."'"; 
		$this->_db->setQuery($query);
		$obj['contact'] = $this->_db->loadAssocList();
		return $obj;
	}