...  EXISTS (SELECT 1 FROM `mem_net` WHERE `mem_net`.`calc_month` = 53 AND `mem_net`.`rank` > 6 ) AND
  EXISTS (SELECT 1 FROM `mem_net` WHERE `mem_net`.`calc_month` = 52 AND `mem_net`.`rank` > 6 ) AND
  EXISTS (SELECT 1 FROM `mem_net` WHERE `mem_net`.`calc_month` = 51 AND `mem_net`.`rank` > 6 ) AND
  EXISTS (SELECT 1 FROM `mem_net` WHERE `mem_net`.`calc_month` = 50 AND `mem_net`.`rank` > 6 ) AND
  EXISTS (SELECT 1 FROM `mem_net` WHERE `mem_net`.`calc_month` = 49 AND `mem_net`.`rank` > 6 ) AND
  EXISTS (SELECT 1 FROM `mem_net` WHERE `mem_net`.`calc_month` = 48 AND `mem_net`.`rank` > 6 ) AND
  EXISTS (SELECT 1 FROM `mem_net` WHERE `mem_net`.`calc_month` = 47 AND `mem_net`.`rank` > 6 ) AND
  EXISTS (SELECT 1 FROM `mem_net` WHERE `mem_net`.`calc_month` = 46 AND `mem_net`.`rank` > 6 )

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select distinct c.*
from mem_net m
join mem_net c on c.rank>6 and c.calc_month' [color=red]at line 3[/color]

set @q=45;
select distinct c.*
from mem_net m
join mem_net c on c.rank>6 and c.calc_month between m.calc_month and m.calc_month+@q-1
where m.rank>6 and @q<=(
  select count(*) 
  from mem_net c
  where c.rank>6 and c.calc_month between m.calc_month and m.calc_month+@q-1
  )

   	$agents_query = $subs::dbh->prepare('SELECT id,contract,rank,calc_month, (SELECT fio FROM net WHERE `mem_net`.contract = `net`.contract AND `net`.depo<>99992),(SELECT rank FROM net WHERE `mem_net`.contract = `net`.contract AND `net`.depo<>99992)
										 FROM mem_net WHERE '.$add_query.' 1 AND (SELECT 1 FROM net WHERE `mem_net`.contract = `net`.contract AND `net`.depo<>99992) AND contract<>0 order by contract');     $agents_query->execute();						
	@list_agent = $agents_query->fetchrow; # Подготовили из таблицы кого нужно
и выбрали
 while (@list_agent) {		
			$counter++;		
			if ($counter%2) {
				$bef1 = '<tr class="lr1">';
			}
			else {
				$bef1 = '<tr class="lr2">';
			}
		
			$page_content .= $bef1;
	
	 if ($temp != $list_agent[1]) {$temp=$list_agent[1];$calc_month=1;} 
	 else {if ($list_agent[2]>=$url_command{'rank'}) {$calc_month++;if($calc_month>=$month_count){
	 $page_content .= $bef2.$temp.$aft2;
	 $page_content .= $bef2.$list_agent[4].$aft2;
	 $page_content .= $bef2.&subs::rank_by_id($list_agent[5]).$aft2;
   # $page_content .= $bef2.&subs::print_month_by_id($list_agent[3]).$aft2;
	 $calc_month=1;} } else {$calc_month=1;}
	 }
			
	 $page_content .= $aft1;

	 @list_agent = $agents_query->fetchrow;
	}

    $agents_query->finish;
	$page_content .= '</table>';