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

-5kg qu'à l'achat

Autres annonces du voisin

Tout voir
Location coffre de toit

Il y a + de 30j

Il y a + de 30j

Thule Touring M

50€/semaine

Kingersheim
Location barres de toit

Il y a + de 30j

Il y a + de 30j

Barres de toit Thule Wingbar Evo 127cm

40€/semaine

Kingersheim

Annonces similaires

Tout voir
Location porte velo

Il y a + de 30j

Il y a + de 30j

Porte-vélos sur attelage (4 places)

14€/jour

Meroux
Location porte velo

Il y a + de 30j

Il y a + de 30j

Portes vélos pliable

20€/jour

Heiteren

Louer un porte-velo entre particuliers ou proposer un porte-velo 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='520982'

  8. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'porte-velo' LIMIT 1

  9. 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'

  10. 0.0001

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

  11. 0.0001

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

  12. 0.0001

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

  13. 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 = 520982

  14. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=722 LIMIT 1

  15. 0

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

  16. 0.0001

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

  17. 0.0001

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

  18. 0

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

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

  20. 0.0001

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

  21. 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 = '520982'

  22. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 722

  23. 0.0002

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

  24. 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='723' LIMIT 0,1

  25. 0.0001

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

  26. 0.0002

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

  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='870' LIMIT 0,1

  28. 0.0002

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

  29. 0.0001

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

  30. 0.0052

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((7.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.350339197041 AND ville_latitude_deg<48.249660802959 AND ville_longitude_deg>6.6639066919192 AND ville_longitude_deg<8.0027533080808 HAVING distance <= 50 ORDER BY distance ASC

  31. 0.0031

    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 ('68260','68110','68270','68390','68390','68120','68120','68270','68390','68460','68200','68100','68840','68400','68170','68850','68310','68790','68190','68540','68950','68350','68190','68350','68540','68440','68440','68720','68190','68500','68440','68990','68720','68890','68440','68500','68740','68360','68500','68700','68700','68490','68440','68490','68490','68250','68890','68250','68520','68500','68440','68740','68500','68700','68700','68440','68720','68720','68440','68990','68700','68500','68500','68740','68440','68800','68700','68520','68520','68740','68720','68720','68500','68210','68720','68510','68490','68500','68490','68680','68500','68720','68700','68130','68500','68720','68510','68250','68250','68510','68740','68720','68250','68720','68130','68800','68500','68510','68510','68530','68680','68210','68127','68130','68510','68530','68130','68720','68740','68130','68130','68800','68800','68510','68250','68760','68620','68250','68510','68210','68210','68760','68116','68510','68780','68740','68740','68210','68210','68800','68570','68290','68610','68130','68870','68130','68130','68780','68780','68130','68250','68740','68210','68780','68250','68610','68870','68780','68130','68610','68210','68600','68510','68690','68570','68130','68130','68130','68130','68210','68130','68290','68420','68210','68780','68210','68210','68210','68780','68510','68550','68690','68210','68600','68210','68210','68128','68600','68730','68118','68210','68420','68960','68420','68420','68290','68127','68560','68130','68280','68210','68210','68420','68220','68560','68730','68290','68210','68280','68470','68550','90360','68210','68230','68730','90360','90150','68470','68960','68600','68210','68960','68960','68600','68210','90150','68420','68290','68220','68560','68280','68560','68210','90150','68220','68600','90110','68290','68290','68210','68380','68140','68470','68220','68230','68220','68480','68640','68640','68420','68640','68210','68600','68140','68580','68128','68640','68600','68470','68580','68210','68470','90110','90110','68640','68210','68290','68290','68600','68290','90110','90150','90150','68140','68330','68210','68220','68830','90150','68600','68580','68220','68230','90110','68480','68920','68380','68600','68128','68300','68290','68920','68220','68580','68140','68220','68121','68470','68640','68280','68210','68210','90150','68580','68580','68600','68230','68230','68210','90110','68580','90150','90150','90150','68820','68320','90150','68380','90100','04056','90170','68180','68480','68140','68140','68000','04057','04055','68230','90170','68380','90100','68380','90170','90100','04124','04123','04123','90130','90150','04091','04075','04030','04005','04020','04019','04018','04010','04000','04009','04002','04070','68290','68320','04031','68480','68320','68140','04054','68220','68220','04001','90130','04089','04039','04039','04089','04041','04089','04089','04041','04051','04058','68480','90150','90150','68580','68320','90130','68580','68480','68480','68040','68230','68230','68480','68480','90170','68320','68480','68480','90200','68820','04102','04102','04125','04125','68320','90160','68220','68140','90100','68220','90380','68320','68320','90200','04053','04052','04052','90100','90100','90340','68480','90340','90160','68320','68125','68480','68480','68770','04105','04104','04101','68480','90300','04059','68480','68320','04127','04103','68320','90100','04126','04118','90140','90340','90140','90200','68910','90100','04112','04112','90300','90140','90200','68320','68220','68480','90370','88540','68480','68240','90300','68480','68240','90160','04112','02935','68480','68480','68240','04106','04108','04115','90200','68480','88310','04042','04142','04040','04042','04142','68480','68320','90400','02944','90330','90100','04132','90140','90100','68320','04116','04132','90100','90100','90200','04153','04153','90100','68980','68630','68630','04114','68150','90300','90300','90600','68370','02933','04117','90000','04107','90400','90140','68480','68480','88230','68480','90300','88250','02933','04144','90400','90140','02924','68150','68340','68340','68480','68650','90120','04147','90300','88560','88160','02943','04133','04223','04133','90400','90400','04302','02814','02813','04243','88310','90100','90200','68240','04244','04245','04143','90350','02947','04303','02926','04303','90400','90400','68480','04148','04224','02932','90850','67390','90200','02925','02946','90850','68970','02807','04402','04222','90120','02807','04304','68970','04145','88160','90400','02812','90400','02923','70290','67390','68650','04414','90100','02953','04202','25490','90100','04254','02942','88400','70400','67390','04203','68150','90400','04310','90700','68750','02953','04310','90800','90800','25600','04225','04146','88400','25490','70440','70290','04242','02806','04305','02805','70400','04412','25490','88160','68150','88290','88360','88160','04253','02803','02922','25490','90800','04410','02952','70290','04422','25600','70440','70400','90800','67390','67390','70400','90100','90100','04204','04421','68590','02954','02900','02900','02900','67390','04313','04246','04413','04226','25600','90500','88230','04252','04252','02800','02800','04411','67390','04312','70400','02915','88120','02800','70400','25200','04206','04419','04232','70400','25230','02950','88120','04423','02950','68590','02857','68590','02822','68590','04227','67600','25460','90100','88230','02902','02823','88290','90500','04247','02802','70440','02905','88120','04415','04453','25600','25600','70400','70310','25400','04464','25230','70400','88230','67390','67390','04323','04208','04416','04314','04417','88120','25200','88430','70290','70400') AND fami_id='5' AND cate_id='227' AND type_id='1' AND ssrubr_id='722' AND wish_id<>'520982' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  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='722' 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=369379 AND note_visu IN (1,3,4)

  34. 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 = 369379 AND W.type_id = 1) OR (W.util_id <> 369379 AND W.type_id = 2)) AND (M.post_util_id = 369379 OR M.dest_util_id = 369379) 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 = 369379

  36. 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='722' LIMIT 0,1

  37. 0.0001

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

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

  39. 0.0002

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

  40. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 722

  41. 0.0001

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

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

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

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

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

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

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

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

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

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

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

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

  56. 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 (93) ORDER BY ssrubr_order ASC

  57. 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 (193) ORDER BY ssrubr_order ASC

  58. 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 (91) ORDER BY ssrubr_order ASC

  59. 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 (232) ORDER BY ssrubr_order ASC

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

  61. 0.0014

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

  62. 0.0215

    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'

  63. 0.0186

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

63 requetes sql en 0.0579

Taille variable Globale : 77.55 KB