prepare($sql);
$stmt->bind_param('s',$_SESSION['matricula_search']);
$stmt->execute();
$res = $stmt->get_result();
if($res->num_rows)
{
$fila = $res->fetch_array();
$vehiculo_tas = $fila['VEHICULO'];
$sql = "SELECT DISTINCT V.CODIGO AS CODIGO_COCHE, V.KM, V.MOSTRAR, V.MARCA AS M, V.MODELO AS VEHMOD, V.ANO_FAB, V.MATRICULACION, V.BASTIDOR, V.KM, V.CARROCERIA, V.COMBUSTIBLE, V.COLOR_CODIGO, V.COLOR_COMERCIAL, V.VERSION, V.POTENCIA,V.CAJACAMBIOS, V.ALTA, V.BAJA, V.ITV_ULTIMA, V.ITV_PROXIMA, V.PRECIO_COMPRA, V.PRECIO_VENTA, V.GARANTIA, V.VENTA_BASE, V.COMPRA_BASE, V.VENTA_DTO, V.NOTAS, V.VENTA_OPCIONES, V.OTRO_EQUIP, V.VELOCIDADES, V.LLAVES, V.CODIGO_RAD, V.USO_ANTERIOR, V.MANUAL, V.LIBRO_MANT, V.IMPORTACION, V.MANT_SELLADO, V.TIPO_SEGURO, T.*,
L5.EXTRA1,
M.DESCRIPCION AS MARCAS,
MO.DESCRIPCION AS MODELOS,
L1.DESCRIPCION_$lg AS DESCRIPCION_LG1,
L2.DESCRIPCION_$lg AS DESCRIPCION_LG2,
L3.DESCRIPCION_$lg AS DESCRIPCION_LG3,
L5.DESCRIPCION_$lg AS DESCRIPCION_LG5,
L6.DESCRIPCION_$lg AS DESCRIPCION_LG6,
L7.DESCRIPCION_$lg AS DESCRIPCION_LG7
FROM VEHICULOS V
LEFT JOIN VEHICULOS_MARCAS M ON M.CODIGO = V.MARCA
LEFT JOIN VEHICULOS_MODELOS MO ON MO.CODIGO = V.MODELO
LEFT JOIN VEHICULOS_TASACIONES T ON T.VEHICULO = V.CODIGO
LEFT JOIN VEHICULOS_LITERALES L1 ON L1.CODIGO = V.COMBUSTIBLE AND L1.TIPO = 'TIP_COM'
LEFT JOIN VEHICULOS_LITERALES L2 ON L2.CODIGO = V.CAJACAMBIOS AND L2.TIPO = 'TIP_CAJ'
LEFT JOIN VEHICULOS_LITERALES L3 ON L3.CODIGO = V.CARROCERIA AND L3.TIPO = 'TIP_CAR'
LEFT JOIN VEHICULOS_LITERALES L5 ON L5.CODIGO = V.COLOR_CODIGO AND L5.TIPO = 'COL_PRI'
LEFT JOIN VEHICULOS_LITERALES L6 ON L6.CODIGO = V.COLOR_COMERCIAL AND L6.TIPO = 'COL_COM'
LEFT JOIN VEHICULOS_LITERALES L7 ON L7.CODIGO = V.TIPO_SEGURO AND L7.TIPO = 'TIP_SEG'
WHERE V.ACTIVO = 1
AND V.TIPO = 'VO'
AND V.CODIGO = ?";
$stmt = $con->prepare($sql);
$stmt->bind_param('i',$vehiculo_tas);
$stmt->execute();
$res = $stmt->get_result();
$fila = $res->fetch_array();
/* $MotherCar = new MotherCar($con);
$fila = $MotherCar->getCarData($lg, $vehiculo_tas); */
?>