				
	 				<?php $query_yes_new = mysqli_query($con,"select * from stdevice		            
		             where NOT EXISTS 
	                (select * from location_details where stdevice.id = location_details.id)
		             and dev_status='new' ORDER BY stdevice.id DESC");
					$count_no_new = mysqli_num_rows($query_yes_new);

		
		            ?>
					<?php $query_no_new = mysqli_query($con,"select * from stdevice		            
		            where NOT EXISTS 
	                (select * from location_details where stdevice.id = location_details.id)
		            and dev_status='none' ORDER BY stdevice.id DESC");
					$count_yes_new = mysqli_num_rows($query_no_new);
					
		            ?>
					
					<?php $not_read_new = $count_no_new -  $count_yes_new; ?>
