10SELECT t_marcas.abreviacion as valor_marca, t_modelos.valor as valor_modelo, t_vehiculos.* FROM t_vehiculos,t_marcas,t_modelos where t_vehiculos.id_marca=t_marcas.id and t_vehiculos.id_modelo=t_modelos.id and id_estado_vehiculo=2 and id_estado_vehiculo in (2,3) order by t_vehiculos.id desc