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 € / mois
Paiement 100% sécurisé
  • Service client réactif
  • Dépôt remboursé si annulé

Annonces similaires

Tout voir
Location garde meuble

Il y a + de 30j

Il y a + de 30j

grand garage de villa securisé

26€/semaine

Vence
Location garde meuble

Il y a + de 30j

Il y a + de 30j

Propose la location de box ou atelier

80€/mois

Guillaumes

Louer un garde-meubles entre particuliers ou proposer un garde-meubles 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.0002

    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.0002

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='garde-meuble' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1037'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'garde-meuble' 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='79'

  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='237233' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  13. 0

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

  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 = 415594

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1037 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='415594' 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=237233 LIMIT 1

  20. 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 = 237233 AND W.type_id = 1) OR (W.util_id <> 237233 AND W.type_id = 2)) AND (M.post_util_id = 237233 OR M.dest_util_id = 237233) 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='237233' 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 = '415594'

  23. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1037

  24. 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='237233' AND wish_id<>'415594' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  25. 0.0001

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

  26. 0.0158

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.0167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.0167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((4- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.567039197041 AND ville_latitude_deg<50.466360802959 AND ville_longitude_deg>3.3002016815828 AND ville_longitude_deg<4.6997983184172 HAVING distance <= 50 ORDER BY distance ASC

  27. 0.0053

    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 ('59212','59610','02260','02260','59610','59219','59177','59132','59219','02260','02500','59219','59186','02260','02260','02260','59132','59132','59177','02500','02500','02500','02500','02500','02170','59440','59440','06594','59440','59177','59440','02260','06590','59440','59440','59740','02260','02500','02550','59132','02620','59740','02580','02260','59440','02500','06593','59244','59132','02580','02830','59550','59440','59740','59244','02500','06591','02170','02500','59244','59132','06592','59216','59216','59440','02580','59440','59440','02140','59740','02140','59132','59440','02500','02170','59740','02170','06460','06460','02260','59550','06596','59440','02170','59740','02260','59216','02140','59440','06460','06596','59620','02500','02120','02830','59550','02260','59620','02140','08380','02120','59740','02450','59680','06470','59740','59550','06470','06460','02140','59330','59330','59740','02120','06460','59550','06470','59620','02500','02450','02500','59740','02140','59620','02500','02140','59550','02450','59680','59680','59330','59740','59740','02140','02140','06460','06470','02500','02120','02120','02120','02450','02450','02450','59740','08380','59145','06464','59620','02140','59360','02450','06470','08380','59680','02140','02140','02140','02120','59138','02140','59145','06470','02140','06464','02140','06461','59330','59680','02500','02500','02510','59550','02120','59149','08380','59138','02510','02140','59330','59680','02140','02140','02120','02140','59330','02140','06462','06500','08380','59680','02360','02140','59360','02510','06464','02140','08290','06464','08290','06500','08380','02140','02140','59360','06463','59138','02360','02140','06440','06440','59360','02120','59131','02140','59680','59720','02510','02140','59149','59138','02140','02360','02360','02120','06500','02630','06500','02140','08380','59530','59330','59360','02120','59550','02140','06560','02120','08260','02250','02360','02120','02360','02140','06440','59600','59600','05660','06500','59168','59245','02110','05660','59360','59288','59550','08260','02120','05660','06500','59149','08290','02360','02140','02120','02110','59530','59222','59570','02360','59360','02120','08260','08230','02120','02120','08260','05660','08290','59600','02340','02250','02360','02340','59570','06464','06500','59164','59750','59530','02250','02360','08260','59460','02630','59570','06560','02630','59570','05660','02250','02250','02250','02250','59530','05660','08260','59222','06560','05660','59600','06441','59600','59530','02340','59360','02110','02340','02340','59222','02120','02250','02360','02250','02360','02360','05630','59360','59570','59530','02360','59360','06560','05660','59144','02250','02120','08290','02110','02110','06560','02360','02110','02110','02360','02120','08290','59360','59218','59570','02250','59218','59570','59530','02340','59144','08260','59600','59600','05650','06560','59600','59600','02360','02120','59530','05660','02250','02340','02340','06440','08230','59530','02360','05650','59218','59218','06567','06511','08260','59730','06567','08260','02120','07040','59530','06530','07040','08290','08290','05630','59570','59570','59530','02250','59360','05660','06567','02340','59570','08260','06536','59144','02270','05660','05630','08290','05650','02250','59980','02110','05630','59570','02110','02250','02270','59137','59530','07120','05660','06532','05660','59530','07041','05660','02120','07040','08220','08230','07120','07120','07040','08260','08230','06533','02270','06542','59570','59570','59730','02250','02250','02340','08260','08260','02110','59980','02340','08220','06536','02350','05630','07040','07040','59144','59570','05651','06567','02110','02120','08230','02340','02340','05630','08290','05670','59540','59980','59980','08220','02340','08150','59980','59730','07120','02350','02350','59213','59213','08150','59730','07041','59144','08150','59530','06543','08220','02110','59730','07080','06531','08150','05650','05600','59530','05600','59540','59271','05650','07387','07120','08230','59144','07387','08220','02390','08150','02340','59730','06530','07387','07120','02350','07040','02350','07387','05600','08220','59144','05651','02250','02270','08460','07120','07387','59238','07370','02350','02270','06540','07040','07022','02110','05600','06120','05600','59213','07080','59213','08150','02390','05650','02230','02390','59540','05651','02240','02340','59225','07387','05650','59269','07120','02270','07120','07040','02270','05670','05650','59294','59144','07387','02110','06540','02270','07080','02240','08150','59990','07022','05600','06534','02350','07387','06120','59225','08220','08150','59540','05600','02350','07387','07022','08150','05670','07133','06120','07080','05600','02350','05600','02110','07080','08220','02270','08150','02390','02240','02270','59213','02110','08150','07120','02110','07387','05651','02150','08220','07370','07340','02350','07340','59990','02270','02270','59214','02110','07024','02350','59269','02350','07370','02270','02240','59213','08150','02110','05650','59191','59990','07382','08560','07340','59127','07131','08150','07032','59990','59269','02270','07130','59188','07134','08220','07340','07022','05670','05651','07134','59292','59191','05680','05670','59157','59227','59227','59990','07130','07031','59227','08460','59990','08500','05651','08150','07370','59217','05620','07380','08220','02110','06120','05600','07387','08220','59990','02110','07130','05600','05600','07022','07033','07030','08460','59157','02100','59188','59920','02240','02000','08220','08150','08220','02240','59191','07012','02350','05600','06111','06150','08220','05680','08150','02720','59217','06120','02270','08500','05670','02270','07134','59127','07301','59300','07134','05670','07390','59224','59188','02110','05651','59127','02270','59300','59233','59129','06110','05620','02000','06142','08220','05670','07300','07012','07000','07350','07390','07141','07380','59127','08460','02420','02720','59770','59198','59243','07100','08560','08090','02350','59217','59400','59217','08560','06140','05600','07110','08220','08150','02840','02100','02100','08270','02000','08220','08090','07350','05621','07110','59127','59125','07330','08090','59264','02420','08500','59300','02000','07021','05680','02270','02350','07100') AND fami_id='5' AND cate_id='79' AND type_id='1' AND ssrubr_id='1037' AND wish_id<>'415594' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  28. 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='1037' LIMIT 0,1

  29. 0.0001

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

  30. 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 = 808 AND W.type_id = 1) OR (W.util_id <> 808 AND W.type_id = 2)) AND (M.post_util_id = 808 OR M.dest_util_id = 808) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  31. 0.0001

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

  32. 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='1037' LIMIT 0,1

  33. 0.0001

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

  34. 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 = 13475 AND W.type_id = 1) OR (W.util_id <> 13475 AND W.type_id = 2)) AND (M.post_util_id = 13475 OR M.dest_util_id = 13475) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  35. 0.0001

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

  36. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1037

  37. 0.0001

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

  38. 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

  39. 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

  40. 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

  41. 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

  42. 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 (110) ORDER BY ssrubr_order ASC

  43. 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

  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 (176) 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 (79) ORDER BY ssrubr_order ASC

  46. 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

  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 (228) ORDER BY ssrubr_order ASC

  48. 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

  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 (95) ORDER BY ssrubr_order ASC

  50. 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

  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 (83) ORDER BY ssrubr_order ASC

  52. 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

  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 (193) 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 (91) 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 (232) 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 (92) ORDER BY ssrubr_order ASC

  57. 0.0017

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

  58. 0.0342

    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'

  59. 0.0194

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

59 requetes sql en 0.084

Taille variable Globale : 76.99 KB