Kiwiiz : service & location entre voisins.
Utiliser ma position
Logo recherche

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Poster une annonce
50 € / semaine
Paiement 100% sécurisé
  • Service client réactif
  • Dépôt remboursé si annulé

Annonces similaires

Tout voir
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Chaines frontales

-- €

Nice
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Recherche location de chaînes à neige

50€/semaine

Mandelieu-la-Napoule
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Chaîne montage frontal 225/55 R19

60€/semaine

Villers-Pol

Louer des chaines a neige entre particuliers ou proposer des chaines a neige en location.

Poster une annonce
Retour
Fermer

Location entre voisins

Lancez votre recherche pour voir les annonces.

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci

  2. 0.0001

    SHOW TABLES LIKE 'pays'

  3. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0003

    SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC

  5. 0.0002

    SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL

  6. 0.0005

    SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''

  7. 0.0001

    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='390351'

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chaine-a-neige' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='725'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chaine-a-neige' LIMIT 1

  10. 0.0001

    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'

  11. 0.0001

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('59' USING utf8mb4) COLLATE utf8mb4_general_ci

  12. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='209881' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  13. 0.0001

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 209881

  14. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 390351

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=725 LIMIT 1

  16. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 209881 AND util_tel != ''

  17. 0

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='390351'

  18. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='390351' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  19. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=209881 LIMIT 1

  20. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 209881 AND W.type_id = 1) OR (W.util_id <> 209881 AND W.type_id = 2)) AND (M.post_util_id = 209881 OR M.dest_util_id = 209881) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  21. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='209881' AND note_visu IN (1,3,4)

  22. 0.0001

    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 = '390351'

  23. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='209881' AND wish_id<>'390351' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  24. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59680'

  25. 0.0152

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.2167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.2167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((4.01667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.767039197041 AND ville_latitude_deg<50.666360802959 AND ville_longitude_deg>3.3139423247262 AND ville_longitude_deg<4.7193976752738 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0032

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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 ('59680','59680','59680','59680','59740','59740','59330','59216','59680','59740','59680','59440','59740','59216','59216','59131','59680','59740','59680','59330','59740','59149','59330','59440','59720','59330','59740','59620','59330','59600','59740','59168','59245','59740','59440','59600','59740','59440','59600','59330','59330','59149','59740','59164','59440','59440','06560','59138','59460','59440','59177','59600','59138','06470','59600','59750','06470','59620','06560','59440','59740','59138','59440','59740','59440','06500','59600','59570','59177','59138','59149','59620','06470','59620','59600','06560','59600','59440','59620','59600','06500','06560','06560','59145','59440','07040','59440','06560','59145','07040','06567','06500','59570','59550','06470','07041','59570','59132','06500','06567','06500','07120','07120','07120','07040','59177','59440','59570','59550','06470','59570','59132','59244','59132','07040','07040','07041','07040','06500','06567','07120','59570','59244','59132','06530','07120','06567','06500','59570','07120','59570','59244','06542','59219','07040','07022','59132','59132','59570','07080','59610','06470','59132','07120','06440','02260','07040','06543','07120','07120','06511','06533','07040','07022','59550','59219','07080','59530','59570','59144','06532','07080','07022','06440','05650','59570','59570','59219','59144','59212','06536','07120','07387','07080','06460','07370','59570','06591','02170','07024','07387','59550','07032','07080','06440','07133','06540','06530','06540','06590','07022','07387','59530','07031','06531','07131','59550','59570','07340','07130','06441','59550','02260','07134','05650','59610','06460','06536','07130','59530','59550','06460','06594','07030','07340','07340','07130','06592','59186','59144','07387','07022','07134','07340','02260','59530','59530','07033','06440','07387','02260','59530','07370','07012','59144','07387','05650','07134','59530','07387','07370','59144','06460','59288','07387','07000','05651','07390','59550','07134','06534','59144','07110','07100','59530','07012','06460','07110','07387','59530','07301','59530','02260','07021','02170','59530','06150','02170','07370','06120','07382','59360','02500','07390','06120','06596','07387','07141','59550','07100','59144','06461','06460','05630','05651','05630','59530','07034','07300','06120','07070','07070','06593','07020','07330','59530','07110','59222','07100','02450','07350','07011','07380','59218','06111','59990','02260','05630','07100','06142','05630','06462','59360','05651','05650','07020','07141','07034','59144','06140','05650','07387','06464','02620','07350','07110','05650','59530','06463','59218','59218','59990','02450','59920','59218','07140','07140','07070','06464','59530','05630','07070','06110','02500','02500','02500','02500','07333','05650','02450','02500','59222','07380','07160','06120','59360','59990','02170','05651','59990','07331','07100','59360','07110','06596','02260','05660','06141','06120','59222','59269','06030','07061','06464','02170','07350','59990','07170','05630','59213','59213','02260','07061','59990','02450','59360','07170','07350','59730','02500','06032','59990','06031','59243','07334','05650','07160','02260','06030','05651','59154','07050','07170','02580','02830','59730','59269','59730','07334','59213','59213','05651','07170','05660','07322','06182','07322','05600','59264','59360','59360','59360','02550','05650','02500','05660','07170','06183','07050','05651','07050','05660','07050','05600','02580','07332','05660','59213','02110','06001','59360','07070','59269','59770','07050','07160','07050','06044','05600','02450','02450','59163','02260','08380','59163','59360','07181','02510','59300','06020','06280','02450','06010','59730','05660','59970','05600','59880','02630','02500','07321','59213','02580','59300','06000','02500','59300','06180','08380','02830','05600','06181','02120','59294','07062','02260','06464','59730','07332','05600','59227','59730','02120','07190','06280','05660','02120','05660','05660','06280','07320','02510','05620','06042','07973','59278','05600','05621','02510','06040','07870','02140','59860','59233','02110','59970','02140','02500','07180','59360','02110','05621','59360','05621','07973','07063','07190','59125','05621','02500','02260','02500','59224','02510','59271','05660','06280','06061','08380','05620','06060','59163','59410','59227','59227','06200','07321','07060','07190','02120','02120','02120','06230','59174','59540','06280','06041','59980','05660','02140','07191','07950','07870','05600','05670','07870','05600','59192','05600','07972','06230','59980','59224','59494','07870','02140','08380','07063','59121','06200','02120','59540','02500','07181','02120','06200','02110','02110','59970','05600','05660','05620','06230','07970','02140','59590','02630','02120','59188','06464','02140','06238','05600','06043','02120','08230','02120','06230','59540','06280','07603','59188','07940','02140','59198','59195','59121','07950','07870','07950','59494','06240','59980','07181','07181','59214','07971','59292','02500','05670','02140','02630','59220','02140','05600','07060','06250','02500','59980','59980','05640','07940','59540','06238','06230','07950','08380','59188','07090','59195','06250','07951','07830','02120','07950','02120','02120','07600','06240','59137','07971','07943','05600','05640','06210','05680','08380','59220','02140','02500','02500','02120','59135','59225','07090','07861','02140','08380','07942','02110','05670','59199','59129','06220','07830','59296','07941','07971','05070','06210','08260','07971','06250','07972','08260','59282','59217','02140','08290','07090','05660','05660','08230','06211','07090','06250','06210','59282','59199','06250','07811','59157','08260','07802','07830','07830','05680','06220','07601','05646','02140','59255','02140','06220','02140','02140','59225','02140','02140','07972','05670','59238','01400','01404','02120','08290','02110','02110','59220','59135','59217','07602','07810','07608','05070','59157','05620','59191','06210','08230','05640','07904','59277','07903','02140','05060','07090','02120','06210','07823','05620','07812','05680','59111','59217','02120','01400','59230','59293','02110','05640','06220','07090','02140','02110','59230','08260','02140','05060','05060','07604','02360','08260','02120','02120','02140','07830','05060','05600','02140','05670','05600','59191','59156','05600','07801','07903','01430','08260','07904','02140','08230','02250','59158','07812','07800','02140','02360','01460','08260','59230','59171','01402','02140','59124','07604','59191','02140','07604','05670','02140','01476','07604','07812','59172','07822','06224','59217','59400','05070','02140','08290','06221','05070','59141','02120','07822','59127','02120','05620','02360','59178','05641','05060') AND fami_id='5' AND cate_id='227' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='725' AND wish_id<>'390351' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  27. 0.0001

    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

  28. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=307754 AND note_visu IN (1,3,4)

  29. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 307754 AND W.type_id = 1) OR (W.util_id <> 307754 AND W.type_id = 2)) AND (M.post_util_id = 307754 OR M.dest_util_id = 307754) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  30. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 307754

  31. 0.0001

    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

  32. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=133543 AND note_visu IN (1,3,4)

  33. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 133543 AND W.type_id = 1) OR (W.util_id <> 133543 AND W.type_id = 2)) AND (M.post_util_id = 133543 OR M.dest_util_id = 133543) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  34. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 133543

  35. 0.0001

    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

  36. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=128273 AND note_visu IN (1,3,4)

  37. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 128273 AND W.type_id = 1) OR (W.util_id <> 128273 AND W.type_id = 2)) AND (M.post_util_id = 128273 OR M.dest_util_id = 128273) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  38. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128273

  39. 0

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  40. 0.0001

    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

  41. 0.0003

    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

  42. 0.0002

    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

  43. 0.0001

    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

  44. 0.0002

    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

  45. 0.0002

    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

  46. 0.0003

    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

  47. 0.0002

    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

  48. 0.0002

    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

  49. 0.0002

    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

  50. 0.0003

    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

  51. 0.0002

    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

  52. 0.0001

    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

  53. 0.0002

    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

  54. 0.0002

    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

  55. 0.0002

    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

  56. 0.0002

    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

  57. 0.0002

    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

  58. 0.0003

    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

  59. 0.0018

    SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7

  60. 0.0226

    SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'

  61. 0.0174

    SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

61 requetes sql en 0.0682

Taille variable Globale : 78.02 KB