ИМОТИ ЗА НАЕМ

SET 
    NAMES "utf8" COLLATE "utf8_general_ci"

SELECT 
    o.EstateID, 
    MainType, 
    Price, 
    BrokerName, 
    BrokerTel, 
    EstateRefCode, 
    OpenedArea, 
    BuiltArea, 
    LandArea, 
    Area, 
    Images, 
    top.TopSlide, 
    top.TopFix, 
    cur.Value, 
    cur.Text AS curr_text, 
    esn.Text AS estate_name, 
    descr.Text AS estate_desc 
FROM 
    t_offers o 
    LEFT JOIN t_currencies cur ON o.Currency = cur.Code 
    LEFT JOIN t_description descr ON o.EstateID = descr.EstateID 
    LEFT JOIN t_estate_name esn ON o.EstateID = esn.EstateID 
    LEFT JOIN t_subcities sc ON o.SubCity = sc.Code 
    LEFT JOIN t_top_offers top ON o.EstateID = top.EstateID 
WHERE 
    cur.Lang = '1' 
    AND descr.Lang = '1' 
    AND esn.Lang = '1' 
    AND DealType = '2' 
GROUP BY 
    o.EstateID 
ORDER BY 
    Price ASC

array (
)

array (
  'key' => 'results',
  'deal' => '2',
)

array (
  'lang' => 
  array (
    'fix-file' => 'lang/fix-site-bg_lang.php',
    'file' => 'lang/site-bg_lang.php',
    'id' => 1,
  ),
  'meta' => 
  array (
    'verification' => '',
    'analitic' => '<script>
  (function(i,s,o,g,r,a,m){i[\'GoogleAnalyticsObject\']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,\'script\',\'https://www.google-analytics.com/analytics.js\',\'ga\');

  ga(\'create\', \'UA-‎84002882-1\', \'auto\');
  ga(\'send\', \'pageview\');

</script>',
    'langs' => '1,3,7',
  ),
  'last_search' => '/index.php?key=search&deal=2',
  'last_results' => '/index.php?key=results&deal=2',
)

array (
)

array (
)

array (
  'PHP_INI_SCAN_DIR' => '/home/ardesbg/.sh.phpmanager/php73.d',
  'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin',
  'PWD' => '/home/ardesbg/public_html/prodigyimoti.com',
  'TZ' => 'Europe/Sofia',
  'SHLVL' => '0',
  'SCRIPT_NAME' => '/index.php',
  'REQUEST_URI' => '/index.php?key=results&deal=2',
  'QUERY_STRING' => 'key=results&deal=2',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REMOTE_PORT' => '48346',
  'SCRIPT_FILENAME' => '/home/ardesbg/public_html/prodigyimoti.com/index.php',
  'SERVER_ADMIN' => 'webmaster@prodigyimoti.ardes.bg',
  'CONTEXT_DOCUMENT_ROOT' => '/home/ardesbg/public_html/prodigyimoti.com',
  'CONTEXT_PREFIX' => '',
  'REQUEST_SCHEME' => 'https',
  'DOCUMENT_ROOT' => '/home/ardesbg/public_html/prodigyimoti.com',
  'REMOTE_ADDR' => '3.236.46.172',
  'SERVER_PORT' => '443',
  'SERVER_ADDR' => '195.191.149.219',
  'SERVER_NAME' => 'prodigyimoti.com',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_SIGNATURE' => '',
  'HTTP_X_HTTPS' => '1',
  'HTTP_CONNECTION' => 'close',
  'HTTP_HOST' => 'prodigyimoti.com',
  'HTTP_ACCEPT_ENCODING' => 'br,gzip',
  'HTTP_IF_MODIFIED_SINCE' => 'Mon, 29 May 2023 09:46:16 GMT',
  'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
  'SSL_TLS_SNI' => 'prodigyimoti.com',
  'HTTPS' => 'on',
  'SCRIPT_URI' => 'https://prodigyimoti.com/index.php',
  'SCRIPT_URL' => '/index.php',
  'UNIQUE_ID' => 'ZR4uJS0DQ1-olzb6LGjG1AAAA9M',
  'FCGI_ROLE' => 'RESPONDER',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1696476709.221393108367919921875,
  'REQUEST_TIME' => 1696476709,
  'argv' => 
  array (
    0 => 'key=results&deal=2',
  ),
  'argc' => 1,
)