<?php 
	if(isset($_GET['view']))
		{
			$cond = "and a.media = '".$_GET['view']."'";
		}else{
			//$cond = "and a.media = 'P'";
			$cond = "";
		}
	
	if(!isset($_GET["start"])) {                         // This variable is set to zero for the first page
$start = '0';
}else {$start = $_GET["start"];}
$eu = ($start); 
$limit = 5; // No of records to be shown per page.
$this1 = $eu + $limit; 
$back = $eu - $limit; 
$next = $eu + $limit; 
	
	
	$m2v_join = "join mod2vid as m2v on m.model_id = m2v.model_id";
	$tour_join = "join tour t on t.asset_id = m2v.asset_id";

	$query = " 	select m.model_id, m.name, m.official_site,  a.asset_id, a.media 
				from models as m
				$m2v_join
			
				$tour_join 
				join assets as a on a.asset_id = m2v.asset_id   
				and (t.tour_date < now() and a.p_date <> '0000-00-00') and  t.site_id = '".CURR_SITE_ID."' and a.hide_photo <> 'y' and t.tour_title <> '' where m.sex != 'M'   $cond
				group by m.model_id
				order by m.name ";
			//	limit " . ITEMS_PER_PAGE;
			//	$niche_join			
				$models_r = $connection->query($query);
				
				$nume = '0';
				
				$new_result = array();
				
				foreach($models_r as $key => $element) {
				$random_pic = "
				select   m2v.asset_id
				from mod2vid as m2v
				$tour_join
				join assets as a on a.asset_id = m2v.asset_id 
				where m2v.model_id = '{$element['model_id']}' and  t.site_id = '".CURR_SITE_ID."' and t.tour_title <> '' and (t.tour_date < now() and a.p_date <> '0000-00-00') and a.hide_photo <> 'y'
				order by rand() limit 1 				";
				$random_pic = $connection->query($random_pic);
				$new_result[$key] = $element;
				$new_result[$key]['random_pic'] = $random_pic['0'];
				
				
			}
			$models_r = $new_result;
?>