print ($strSQL);

SELECT DISTINCT ra.id, ra.id_user, DATE_FORMAT(ra.movedate,'%m.%d.%Y') as movedate, ra.type, ra.people_count, ra.room_type, ra.sold_leased_status, ra.status, ra.headline, u.fname, u.phone, u.user_type, urp.min_payment, urp.max_payment, urp.auction, ct.name as country_name, rt.name as region_name, cit.name as city_name, hlt.id_friend, blt.id_enemy, url.id_region, url.adress as address, rnt.shpr, ra.upload_path as slide_path, sp.order_id, sp.status as spstatus, SUM(vst.visits_count) as visits, ft.id as featured, rety.id_value as rent_type 
FROM rent_ads ra 
LEFT JOIN user_rent_location url ON url.id_ad=ra.id 
LEFT JOIN user u ON u.id=ra.id_user 
LEFT JOIN `rent_prices` rnt ON ra.id=rnt.id_ad 
LEFT JOIN `spr_rent_type_user` rety ON ra.id=rety.id_ad 
LEFT JOIN user_rent_pays urp ON urp.id_ad=ra.id 
LEFT JOIN country_spr ct ON ct.id=url.id_country 
LEFT JOIN region_spr rt ON rt.id=url.id_region 
LEFT JOIN city_spr cit ON cit.id=url.id_city 
LEFT JOIN hotlist hlt on ra.id_user=hlt.id_friend and hlt.id_user='2' 
LEFT JOIN blacklist blt on ra.id_user=blt.id_enemy and blt.id_user='2' 
LEFT JOIN sponsors_ads sp ON sp.id_ad=ra.id 
LEFT JOIN rent_ad_visit vst ON vst.id_ad=ra.id 
LEFT JOIN featured ft ON ft.id_ad=ra.id 
WHERE ra.id_user LIKE '%' AND ra.type='4' AND rety.id_value='9' AND ct.id='164' AND rt.id='2' AND cit.id='986221' GROUP BY ra.id LIMIT 0, 5

SELECT DISTINCT ra.id, ra.id_user, DATE_FORMAT(ra.movedate,'%m.%d.%Y') as movedate, ra.type, ra.people_count, ra.room_type, ra.sold_leased_status, ra.status, ra.headline, u.fname, u.phone, u.user_type, urp.min_payment, urp.max_payment, urp.auction, ct.name as country_name, rt.name as region_name, cit.name as city_name, hlt.id_friend, blt.id_enemy, url.id_region, url.adress as address, rnt.shpr, ra.upload_path as slide_path, sp.order_id, sp.status as spstatus, SUM(vst.visits_count) as visits, ft.id as featured, rety.id_value as rent_type 
FROM rent_ads ra 
LEFT JOIN user_rent_location url ON url.id_ad=ra.id 
LEFT JOIN user u ON u.id=ra.id_user 
LEFT JOIN `rent_prices` rnt ON ra.id=rnt.id_ad 
LEFT JOIN `spr_rent_type_user` rety ON ra.id=rety.id_ad LEFT JOIN user_rent_pays urp ON urp.id_ad=ra.id 
LEFT JOIN country_spr ct ON ct.id=url.id_country 
LEFT JOIN region_spr rt ON rt.id=url.id_region 
LEFT JOIN city_spr cit ON cit.id=url.id_city 
LEFT JOIN hotlist hlt on ra.id_user=hlt.id_friend and hlt.id_user='2' 
LEFT JOIN blacklist blt on ra.id_user=blt.id_enemy and blt.id_user='2' 
LEFT JOIN sponsors_ads sp ON sp.id_ad=ra.id 
LEFT JOIN rent_ad_visit vst ON vst.id_ad=ra.id 
LEFT JOIN featured ft ON ft.id_ad=ra.id 
WHERE ra.id_user LIKE '%' GROUP BY ra.id LIMIT 5, 5

sale.php?show=pr

       if (isset($_POST['choise']) or isset($_POST['realty_type']) or isset($_POST['country']) or isset($_POST['region']) or isset($_POST['city']) or isset($_POST['min_payment']) or isset($_POST['max_payment']))
       {
       $_SESSION['search']['choise']=$_POST['choise'];
       $choise=$_SESSION['search']['choise'];
       $_SESSION['search']['realty_type']=$_POST['realty_type'];
       $rt=$_SESSION['search']['realty_type'];
       $_SESSION['search']['country']=$_POST['country'];
       $country=$_SESSION['search']['country'];
       $_SESSION['search']['region']=$_POST['region'];
       $region=$_SESSION['search']['region'];
       $_SESSION['search']['city']=$_POST['city'];
       $city=$_SESSION['search']['city'];
       $_SESSION['search']['min_payment']=$_POST['min_payment'];
       $min_payment=$_SESSION['search']['min_payment'];
       $_SESSION['search']['max_payment']=$_POST['max_payment'];
       $max_payment=$_SESSION['search']['max_payment'];
       }
       if (isset($_SESSION['search']))
       {
         $choise=$_SESSION['search']['choise'];
         $rt=$_SESSION['search']['realty_type'];
         $country=$_SESSION['search']['country'];
         $region=$_SESSION['search']['region'];
         $city=$_SESSION['search']['city'];
         $min_payment=$_SESSION['search']['min_payment'];
         $max_payment=$_SESSION['search']['max_payment'];
       	}