Réserver
Description de l'annonce
Bonjour,
chaine de voiture type SUV, pour des véhicule dit "non chainable"
#chaine a neige
Indiquer un code postal ou une ville
Poster une annonce
Réserver
Bonjour,
chaine de voiture type SUV, pour des véhicule dit "non chainable"
#chaine a neige
Annonces similaires
Tout voirLouer des chaines a neige entre particuliers ou proposer des chaines a neige en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
50€
Pour appeler mon voisin & organiser le rendez-vous.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='405752'
INSERT INTO wish_photos (`wish_id`, `wish_temp_id`, `photo_path`, `photo_ordre`) VALUES (405752, 0, '/img/wiiz/225851-220209-0837-location-chaine-a-neige.jpg', 0)
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chaine-a-neige' LIMIT 1
SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='5' AND c.cate_id='227'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='59'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='225851' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 225851
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (87) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (88) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (81) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (110) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (227) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (176) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (79) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (208) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (228) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (207) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (95) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (173) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (83) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (93) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (193) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (91) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (232) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (92) ORDER BY ssrubr_order ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 405752
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=725 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='405752'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='405752' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 225851 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 225851 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''
SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 225851 AND W.type_id = 1) OR (W.util_id != 225851 AND W.type_id = 2)) AND (`post_util_id` = 225851 OR `dest_util_id` = 225851) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='225851' AND note_visu IN (1,3,4)
SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '405752'
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='225851' AND wish_id<>'405752' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59184'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.55*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.55*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.9- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.100339197041 AND ville_latitude_deg<50.999660802959 AND ville_longitude_deg>2.1923164030211 AND ville_longitude_deg<3.6076835969789 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND wish_cp IN (59184,59272,59136,59274,59112,59496,59134,59185,59134,59221,59134,59251,62138,59147,59480,59496,62410,59134,59147,62138,59112,59147,59211,59249,59133,59249,59263,59480,59320,59134,59320,59320,62138,59320,59320,62410,62840,62138,62220,62410,59320,59139,62840,62138,59133,62880,62880,62880,59113,62410,59320,62880,59320,62149,59320,59175,62590,59120,62820,62440,59280,59139,62149,59551,62710,59840,62149,62136,59175,59239,59261,59160,62840,59155,59239,62149,62740,59710,62221,62640,62218,62840,62136,59840,62300,62750,62980,62149,59551,62119,59130,62840,59162,62136,59840,62420,59930,59280,62980,59800,59777,59350,59000,59160,62110,62430,59790,62113,62113,59193,59810,62660,59710,59940,59350,62950,62300,62141,59110,62160,59710,59246,59237,59273,62400,59710,62400,59116,62680,59253,62670,62970,62136,59260,59283,62210,59850,62113,62790,62800,59370,62290,59118,62143,59950,59520,59700,62160,59283,62320,62320,62320,62320,59181,59236,59310,59273,59242,62400,62114,59235,59262,59242,62131,62131,59940,59286,59128,59890,59940,62232,62232,62232,62131,59830,62232,62580,62160,62580,59890,62490,62580,62530,59660,62920,59830,62490,62580,62350,62620,59553,62153,59553,62232,59910,59152,59290,59152,59170,62196,59553,59510,59194,62172,62350,59560,62580,62580,59830,59242,59310,62580,59650,59493,59655,59491,62153,62199,62580,62620,59152,62530,62144,62580,59420,59270,59500,59152,59830,62920,62920,62122,59510,59310,59119,62530,62580,59250,59126,59223,62580,62350,62490,62940,62620,59148,59194,62580,59552,62350,59270,59830,59270,62490,59552,59780,62620,59232,59100,59390,59780,59780,59310,59310,59560,62117,59450,59200,62350,59390,62223,62150,59830,59830,59390,62700,62690,62122,62144,59117,62112,62144,59270,59167,59169,59390,62150,59187,62223,62690,62350,59166,59310,59270,62150,62350,62490,62540,62690,62118,62118,59150,59870,62118,62112,62223,62118,59310,62118,62223,62150,62157,59960,59270,62144,59287,62540,62223,59182,59115,62150,59870,62150,59146,62690,59310,62223,59287,59182,62690,59310,62150,62223,59190,62190,59270,62161,62161,59169,62118,62460,62490,62223,59169,62690,59151,59190,62330,62470,62490,62144,62151,59190,59176,62690,62000,62190,62690,62490,62260,62150,62690,59299,62690,59870,62118,62460,62470,59310,59690,59176,62156,59169,62161,59190,59190,62127,62190,59870,62217,62156,59490,59169,59189,59870,62260,62156,62161,59151,62000,59189,62217,59230,62330,59226,62127,59151,62217,62217,59259,59270,59151,62690,62150,62190,59178,62690,62128,62128,62156,62550,59114,62156,62123,62156,59230,59165,59870,62217,59490,62123,59870,62190,62190,62690,62120,62190,62690,62123,62123,59234,59189,62260,62156,59178,62460,59114,62860,59580,62690,62860,59179,62550,62123,62860,62128,62128,62260,62860,62860,62550,62120,62128,62550,62123,59151,62128,59114,59234,62120,59190,59171,62127,59173,59580,62217,62550,62120,62550,62123,62130,59190,62217,62120,59234,59226,62550,62690,62860,59265,59171,62120,62127,62127,62128,62173,59215,62810,62182,62182,62810,62550,59178,62123,59670,62128,62120,59178,62190,62120,62182,62550,62175,62127,62550,59114,62860,62120,62120,62127,59158,59265,62120,62127,62173,62860,62860,59252,59247,59190,59173,59171,62127,62960,62810,62960,62127,62550,62128,59173,62182,62130,59670,62145,59158,62860,62173,62128,62810,62123,59252,62810,62123,59247,62550,59172,62810,62175,62127,62550,59230,59124,62123,59158,62550,59670,62860,62175,59670,62173,62860,62127,62130,62123,59158,62175,59670,62175,62860,62120,59173,59230,62128,62128,59252,59135,59247,62810,62120,62128,62130,62810,59230,62120,59156,62127,62120,62121,62860,62960,62145,59172,59670,62810,59111,62550,59265,62123,62134,59670,59265,59255,59111,59220,62121,62130,62123,59670,62130,59554,62158,59293,62128,62120,59470,62810,59265,59173,62130,62130,62130,62127,62121,59135,62127,62120,59295,59295,59670,59111,62116,62810,62860,62123,59554,59268,62121,62134,59199,62810,62960,62145,62120,59220,59195,62134,62860,59554,62111,62120,59282,62270,59554,62130,62116,62130,62810,59494,59141,62810,62116,59199,62158,62159,62159,59670,62130,59220,62810,59111,59195,62130,62145,59670,62129,62860,62158,62134,59470,62810,62130,59590,59400,59282,62129,59554,62130,62134,62158,59121,62130,59122,59141,62270,62960,62270,62111,62147,62116,59494,62130,59670,62960,59470,62130,59161,62810,62134,59192,62159,59285,62124,62158,62121,62121,62575,59400,62111,62134,59141,62810,59121,59161,62130,62129,59470,62121,62134,59174,59400,62147,62121,59410,62111,62960,59554,62960,62134,59970,62147,62130,59267,62129,59296,62810,62130,59224,62130,59470,62510,62270,62134,62158,59161,62450,62450,62124,62450,62134,62810,59267,62760,62575,62124,62116,59860,62124,62450,62134,59285,62500,62147,62760,59400,59125,62570,62130,62130,62158,62121,62147,62270,62130,62121,62130,59278,62129,59198,59470,59380,59163,80600,62134,62111,59161,62270,59233,62270,62270,59122,62147,59224,59285,59159,62810,62129) AND fami_id='5' AND cate_id='227' AND type_id='1' AND ssrubr_id='725' AND wish_id<>'405752' AND wish_url='' ORDER BY rand() LIMIT 0,10
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='725' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=377621 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 377621 AND W.type_id = 1) OR (W.util_id != 377621 AND W.type_id = 2)) AND (`post_util_id` = 377621 OR `dest_util_id` = 377621) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 377621
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='725' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=460929 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 460929 AND W.type_id = 1) OR (W.util_id != 460929 AND W.type_id = 2)) AND (`post_util_id` = 460929 OR `dest_util_id` = 460929) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 460929
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='725' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 377621
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='725' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=183223 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 183223 AND W.type_id = 1) OR (W.util_id != 183223 AND W.type_id = 2)) AND (`post_util_id` = 183223 OR `dest_util_id` = 183223) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 183223
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='725' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=224183 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 224183 AND W.type_id = 1) OR (W.util_id != 224183 AND W.type_id = 2)) AND (`post_util_id` = 224183 OR `dest_util_id` = 224183) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 224183
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='725' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=134335 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 134335 AND W.type_id = 1) OR (W.util_id != 134335 AND W.type_id = 2)) AND (`post_util_id` = 134335 OR `dest_util_id` = 134335) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 134335
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='725' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=102715 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 102715 AND W.type_id = 1) OR (W.util_id != 102715 AND W.type_id = 2)) AND (`post_util_id` = 102715 OR `dest_util_id` = 102715) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 102715
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 725
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish
SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC







Contactez-nous