SELECT a.id, a.user, ( a.premier_jour ) AS price, a.adresse, 1 as 'type_search', a.reduction_un, a.reduction_deux, a.reduction_trois, a.reduction_quatre,a.reservation_instantanee, a.vehicule,a.rabais, a.disponibilite_precision,a.longitude,a.latitude,a.premier_jour,a.jour_suivant ,a.prix_par_km ,a.ville,a.image1,k.id AS keybox_id, a.longue_duree,a.deplacement, a.arret_bus, a.arret_gare, a.arret_aeroport,a.date_circulation, a.model, a.description, ( 3959 * acos( cos( radians(46.206947) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(6.132379) ) + sin( radians(46.206947) ) * sin( radians( latitude ) ) ) ) AS distance, m.marque, c.cylindree, mt.type, ca.carburant FROM `#__autos` as a LEFT JOIN `#__autos_marque` as m ON a.marque=m.id LEFT JOIN `#__autos_cylindree` as c ON a.cylindree=c.id LEFT JOIN `#__autos_type` as mt ON a.type=mt.id LEFT JOIN `#__autos_carburant` as ca ON a.carburant=ca.id LEFT JOIN `#__autos_keybox` as k ON a.id = k.id_auto WHERE a.published=1 AND a.vehicule="auto" HAVING distance < 3 UNION ALL SELECT a.id, a.user, ( a.premier_jour ) AS price, a.adresse_2 as adresse, 2 as 'type_search', a.reduction_un, a.reduction_deux, a.reduction_trois, a.reduction_quatre,a.reservation_instantanee, a.vehicule,a.rabais, a.disponibilite_precision,a.longitude_2 as longitude,a.latitude_2 as latitude,a.premier_jour,a.jour_suivant ,a.prix_par_km ,a.ville,a.image1,k.id AS keybox_id, a.longue_duree,a.deplacement, a.arret_bus, a.arret_gare, a.arret_aeroport,a.date_circulation, a.model, a.description, ( 3959 * acos( cos( radians(46.206947) ) * cos( radians( latitude_2 ) ) * cos( radians( longitude_2 ) - radians(6.132379) ) + sin( radians(46.206947) ) * sin( radians( latitude_2 ) ) ) ) AS distance, m.marque, c.cylindree, mt.type, ca.carburant FROM `#__autos` as a LEFT JOIN `#__autos_marque` as m ON a.marque=m.id LEFT JOIN `#__autos_cylindree` as c ON a.cylindree=c.id LEFT JOIN `#__autos_type` as mt ON a.type=mt.id LEFT JOIN `#__autos_carburant` as ca ON a.carburant=ca.id LEFT JOIN `#__autos_keybox` as k ON a.id = k.id_auto WHERE a.published=1 AND a.vehicule="auto" HAVING distance < 3 ORDER BY distance
SELECT a.id, a.user, ( a.premier_jour ) AS price, a.adresse, 1 as 'type_search', a.reduction_un, a.reduction_deux, a.reduction_trois, a.reduction_quatre,a.reservation_instantanee, a.vehicule,a.rabais, a.disponibilite_precision,a.longitude,a.latitude,a.premier_jour,a.jour_suivant ,a.prix_par_km ,a.ville,a.image1,k.id AS keybox_id, a.longue_duree,a.deplacement, a.arret_bus, a.arret_gare, a.arret_aeroport,a.date_circulation, a.model, a.description, ( 3959 * acos( cos( radians(46.206947) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(6.132379) ) + sin( radians(46.206947) ) * sin( radians( latitude ) ) ) ) AS distance, m.marque, c.cylindree, mt.type, ca.carburant FROM `#__autos` as a LEFT JOIN `#__autos_marque` as m ON a.marque=m.id LEFT JOIN `#__autos_cylindree` as c ON a.cylindree=c.id LEFT JOIN `#__autos_type` as mt ON a.type=mt.id LEFT JOIN `#__autos_carburant` as ca ON a.carburant=ca.id LEFT JOIN `#__autos_keybox` as k ON a.id = k.id_auto WHERE a.published=1 AND a.vehicule="auto" HAVING distance < 3 UNION ALL SELECT a.id, a.user, ( a.premier_jour ) AS price, a.adresse_2 as adresse, 2 as 'type_search', a.reduction_un, a.reduction_deux, a.reduction_trois, a.reduction_quatre,a.reservation_instantanee, a.vehicule,a.rabais, a.disponibilite_precision,a.longitude_2 as longitude,a.latitude_2 as latitude,a.premier_jour,a.jour_suivant ,a.prix_par_km ,a.ville,a.image1,k.id AS keybox_id, a.longue_duree,a.deplacement, a.arret_bus, a.arret_gare, a.arret_aeroport,a.date_circulation, a.model, a.description, ( 3959 * acos( cos( radians(46.206947) ) * cos( radians( latitude_2 ) ) * cos( radians( longitude_2 ) - radians(6.132379) ) + sin( radians(46.206947) ) * sin( radians( latitude_2 ) ) ) ) AS distance, m.marque, c.cylindree, mt.type, ca.carburant FROM `#__autos` as a LEFT JOIN `#__autos_marque` as m ON a.marque=m.id LEFT JOIN `#__autos_cylindree` as c ON a.cylindree=c.id LEFT JOIN `#__autos_type` as mt ON a.type=mt.id LEFT JOIN `#__autos_carburant` as ca ON a.carburant=ca.id LEFT JOIN `#__autos_keybox` as k ON a.id = k.id_auto WHERE a.published=1 AND a.vehicule="auto" HAVING distance < 3 ORDER BY distance
AKZEPTANZQUOTE Wenn du für die gewählte Zeit keinen Vermieter findest, schicke deine Anfrage vor allem an Vermieter mit einer guten Rückmeldequote und sende bis zu 3 Anfragen gleichzeitig, um mindestens eine positive Antwort zu erhalten.
-10% *Ab CHF 35 /T
Dieser Vermieter akzeptiert die meisten Mietgesuche.
-10% *Ab CHF 66 /T
-10% *Ab CHF 87 /T
-5% *Ab CHF 55 /T
Ab CHF 40 /T
-10% *Ab CHF 40 /T
-10% *Ab CHF 30 /T
Ab CHF 30 /T
-10% *Ab CHF 30 /T
-50% *Ab CHF 30 /T
Ab CHF 35 /T
-10% *Ab CHF 99 /T
-10% *Ab CHF 30 /T
-10% *Ab CHF 99 /T
-10% *Ab CHF 27 /T
-5% *Ab CHF 57 /T
-10% *Ab CHF 40 /T
-10% *Ab CHF 60 /T
-10% *Ab CHF 80 /T
