Notice: Use of undefined constant Y - assumed 'Y' in /webs/www/migrados/naumusados/php/funciones.php on line 18
001
SET 
    NAMES "utf8" COLLATE "utf8_general_ci"
FileFunctionLine
/webs/www/migrados/naumusados/php/Zebra_Database.phpquery()3158
/webs/www/migrados/naumusados/php/db.phpset_charset()5
/webs/www/migrados/naumusados/sitio/listado.phpinclude()6
002
SELECT 
    Max(autos.ano) AS maxan, 
    Min(autos.ano) AS minan, 
    Max(autos.km) AS maxkm, 
    Min(autos.km) AS minkm, 
    Max(autos.precio) AS maxpr, 
    Min(autos.precio) AS minpr, 
    Count(autos.id) AS totalau 
FROM 
    autos
maxanminanmaxkmminkmmaxprminprtotalau
0
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEautosALL1100.00
FileFunctionLine
/webs/www/migrados/naumusados/php/funciones.phpquery()14
/webs/www/migrados/naumusados/sitio/listado.phpinclude()7
001
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 'AND 2018 AND autos.km BETWEEN AND AND autos.precio BETWEEN 0 AND 0 ORDER BY' at line 17
SELECT 
    SQL_CALC_FOUND_ROWS autos.id, 
    autos.marca, 
    autos.modelo, 
    autos.icono, 
    autos.tipo, 
    autos.ano, 
    autos.km, 
    autos.precio, 
    autos.`desc`, 
    color.color, 
    color.codigo 
FROM 
    autos 
    LEFT JOIN color ON autos.color = color.id 
WHERE 
    autos.ano BETWEEN 
    AND 2018 
    AND autos.km BETWEEN 
    AND 
    AND autos.precio BETWEEN 0 
    AND 0 
ORDER BY 
    marca 
LIMIT 
    0, 9
FileFunctionLine
/webs/www/migrados/naumusados/sitio/listado.phpquery()48
001
$_POST
array (
)
001
$_GET
array (
)
001
$_SESSION
array (
  'maxpr' => '0',
  'minpr' => '0',
  'maxan' => '2018',
  'minan' => NULL,
  'maxkm' => NULL,
  'minkm' => NULL,
  'marca' => '',
  'model' => '',
  'orden' => 'ma',
)
001
$_COOKIE
array (
)
001
$_FILES
array (
)
001
$_SERVER
array (
  'HTTP_HOST' => 'www.naumusados.com.ar',
  'HTTP_ACCEPT_ENCODING' => 'x-gzip, gzip, deflate',
  'HTTP_USER_AGENT' => 'CCBot/2.0 (http://commoncrawl.org/faq/)',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  'HTTP_IF_MODIFIED_SINCE' => 'Tue, 21 Nov 2017 14:02:48 GMT',
  'PATH' => '/usr/local/bin:/usr/bin:/bin',
  'SERVER_SIGNATURE' => '<address>Apache/2.2.16 (Debian) Server at www.naumusados.com.ar Port 80</address>
',
  'SERVER_SOFTWARE' => 'Apache/2.2.16 (Debian)',
  'SERVER_NAME' => 'www.naumusados.com.ar',
  'SERVER_ADDR' => '190.11.130.11',
  'SERVER_PORT' => '80',
  'REMOTE_ADDR' => '54.167.62.170',
  'DOCUMENT_ROOT' => '/var/www/migrados/naumusados',
  'SERVER_ADMIN' => 'mpieruccini@powervt.com.ar',
  'SCRIPT_FILENAME' => '/var/www/migrados/naumusados/sitio/listado.php',
  'REMOTE_PORT' => '55244',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'SERVER_PROTOCOL' => 'HTTP/1.0',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'REQUEST_URI' => '/sitio/listado.php',
  'SCRIPT_NAME' => '/sitio/listado.php',
  'PHP_SELF' => '/sitio/listado.php',
  'REQUEST_TIME' => 1519260514,
)
2 / 1