Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Cherche retraité ou étudiants

Annonces similaires

Tout voir
Location jardin potager
Location jardin potager
LOCATION JARDIN
Profil du voisin
Nicole B

Logelheim 68280

75€/m

Location jardin potager
Location jardin potager
Profil du voisin
Ouassila B

Reiningue 68950

-- €

Location jardin potager
Location jardin potager
LOCATION TERRAIN 400M2
Profil du voisin
Voisin #137095

Ingersheim 68040

200€/m

Location jardin potager
Location jardin potager
TERRAIN POUR JARDIN FORESTIER (8 MOIS)
Profil du voisin
Marie christiane R

Knoeringue 68220

50€

Louer un jardin entre particuliers ou proposer un jardin en location.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 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='380707'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='jardin-potager' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1173'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'jardin-potager' LIMIT 1

  5. 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='88'

  6. 0

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='90'

  7. 0.0001

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

  8. 0

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

  9. 0.0001

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

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

  11. 0.0004

    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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  29. 0.0001

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

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1173 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  33. 0

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

  34. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 122105 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

  35. 0.0001

    SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 122105 AND W.type_id = 1) OR (W.util_id != 122105 AND W.type_id = 2)) AND (`post_util_id` = 122105 OR `dest_util_id` = 122105) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  36. 0.0001

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

  37. 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 = '380707'

  38. 0.0001

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

  39. 0.0001

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

  40. 0.003

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.7167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.7167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.96667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.267039197041 AND ville_latitude_deg<48.166360802959 AND ville_longitude_deg>6.2983176103033 AND ville_longitude_deg<7.6350223896967 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.005

    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 (90110,90110,90110,90110,90110,90110,90170,90360,90170,90150,90360,90150,90150,90170,68290,90150,90150,90150,90150,90150,90150,68780,90150,90200,68210,90380,90170,68290,90150,90300,68290,90150,68780,68780,68210,68290,90160,90160,68780,68210,90300,90300,90200,68780,90200,68290,68210,68290,68290,68116,90200,68210,68290,90150,90150,90330,90340,68780,90300,90300,68290,68290,68290,68210,90160,90200,90130,90340,68780,90300,90130,68210,68210,68800,68210,68800,90000,68210,68210,68210,90300,90200,68700,68210,90340,68210,68210,68290,90130,90400,68210,90350,90400,90140,68800,68210,90200,68520,68800,90400,68210,68700,68210,90850,68700,90140,68210,90850,68520,90400,90200,68210,70400,68800,68210,68210,68210,68620,90400,68520,68210,68210,90400,90100,68210,70400,90100,90400,68470,68210,90140,90140,90100,90140,68470,90140,90100,90100,70290,70400,68720,68210,90800,90800,68760,90400,68690,68550,70290,68210,68700,70400,90800,90400,90400,90800,68720,90600,68121,68470,68470,68700,68700,90120,68990,90700,90100,68210,68550,68470,70290,70400,68720,70400,68580,68210,68690,25600,68990,88540,70400,68760,70400,68950,68470,90100,90100,70440,70400,68720,90120,68580,25490,68700,88560,88160,68130,70290,68580,25600,68130,70400,68720,70400,25600,68830,70400,90100,25200,70270,68790,68720,68720,68118,25490,90100,70400,70440,68720,68580,88160,68130,68720,68720,70250,70400,68580,68580,68500,90100,25200,70440,68310,68850,68130,68820,90100,70400,90100,25490,68460,25600,25600,25490,68500,68500,68120,70400,68350,68500,70400,88310,90100,25460,68500,70400,25550,25200,90100,25400,88160,88160,70400,68560,90100,68120,68500,70400,70200,68720,25400,68350,68130,90500,68720,70270,88360,25230,90370,68130,68130,70270,70200,68530,25550,70310,68540,68560,25750,68610,68360,68130,25750,25750,70400,68130,25550,68580,70200,25420,68100,68200,68580,25550,68610,90100,25400,68560,68560,90500,25230,68500,25400,68480,25630,68110,70200,70200,70200,68130,70200,25230,70270,70270,68260,70200,68540,68840,68530,25550,25550,70400,68440,68610,25550,88310,25700,68270,68820,70200,70200,90100,68580,90100,25550,88290,25420,68440,68960,68960,70400,68190,70310,68640,70400,68960,68400,70270,68130,68440,68500,68640,25750,68130,68130,68500,70200,68390,68510,68380,25230,68960,68440,70200,68500,70270,25550,68390,25113,68500,68440,68130,25420,25750,70200,25310,68130,68190,70200,68510,68640,88250,68480,25310,25350,25420,68380,70310,68440,70200,68500,70200,68510,70200,68270,68440,68130,88290,25420,68170,88360,25260,68480,68190,70400,70310,70310,68250,25260,68480,68440,68440,68390,68510,88120,68480,25310,70400,70270,70310,68510,68640,68380,70310,68570,25310,68480,68480,68250,70400,70200,25700,68480,25310,68510,68130,70400,68480,68380,68230,70310,68510,25260,68570,68480,70200,70200,68890,68480,68140,25250,70400,70310,25250,70310,70270,25250,68480,68510,88120,68480,25310,25260,68480,25250,70310,88120,25150,68140,25150,70300,68510,68250,68890,68380,68640,68480,70200,68480,68250,68220,25250,70200,70200,68510,70110,68220,25250,70200,25150,70110,88120,70280,70310,68870,25310,70200,70280,70110,68510,70200,68250,25260,25310,70300,88120,68480,68140,70280,68730,68480,70110,68640,68870,88200,68480,68140,68220,25150,25150,68480,25260,70280,68140,68140,25190,68730,25310,68230,70110,70110,88200,68420,70200,88400,68480,88120,70280,25250,70110,25310,25250,70300,68740,70200,25250,25150,68680,68140,70200,68490,70110,70110,68140,25250,25250,68250,68250,88340,68490,68480,70110,70110,68220,68730,25190,68480,88400,68230,25190,68220,25250,25190,68490,68680,68420,70200,25250,70200,68127,70110,68480,68420,68420,68740,88120,25150,70110,68480,25250,68490,25190,70110,68420,88340,68420,68740,70300,25150,25250,70110,70200,70300,88530,68250,25190,25150,25150,68480,25250,88230,68220,88120,25250,25250,68740,68128,25190,25190,25190,68480,70110,68220,25250,70200,68220,68220,68740,68230,68230,70110,70300,68220,70110,88200,88530,70200,68250,88200,25250,70240,25250,70110,25190,70110,88400,68220,25470,25470,70300,68420,25470,25190,70300,68490,70300,70110,25190,70300,25190,25190,70240,68920,88370,68127,25340,68220,68480,70110,25250,25190,70110,70220,25470,70300,70240,68280,70240,25190,68220,70300,68128,88200,68220,68920,88430,68740,25340,70240,68230,70110,68300,68128,88640,25190,25340,25190,70110,70110,70300,68600,25340,68910,88640,25680,25680,68740,68740,68600,70110,68330,68280,70300,88430,25190,25470,25430,70240,68280,68370,25340,68230,68230,25680,70300,25470,70240,25340,68740,70240,70300,70240,25470,70110,88640,25190,70300,25430,88460,25340,68040,70110,25190,70300,70800,25340,25680,25190,70240,70320,25340,88510,88220) AND fami_id='5' AND cate_id='88' AND type_id='1' AND ssrubr_id='1173' AND wish_id<>'380707' AND wish_url='' ORDER BY rand() LIMIT 0,10

  42. 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='1173' LIMIT 0,1

  43. 0.0001

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

  44. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 48789 AND W.type_id = 1) OR (W.util_id != 48789 AND W.type_id = 2)) AND (`post_util_id` = 48789 OR `dest_util_id` = 48789) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  45. 0.0001

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

  46. 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='1173' LIMIT 0,1

  47. 0.0001

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

  48. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 373410 AND W.type_id = 1) OR (W.util_id != 373410 AND W.type_id = 2)) AND (`post_util_id` = 373410 OR `dest_util_id` = 373410) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  49. 0.0001

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

  50. 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='1173' LIMIT 0,1

  51. 0.0001

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

  52. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137095 AND W.type_id = 1) OR (W.util_id != 137095 AND W.type_id = 2)) AND (`post_util_id` = 137095 OR `dest_util_id` = 137095) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  53. 0.0001

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

  54. 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='1173' LIMIT 0,1

  55. 0.0001

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

  56. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 66015 AND W.type_id = 1) OR (W.util_id != 66015 AND W.type_id = 2)) AND (`post_util_id` = 66015 OR `dest_util_id` = 66015) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  57. 0.0001

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

  58. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1173

  59. 0.0008

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

  60. 0

    SELECT count(*) as nbwish FROM wish

  61. 0.047

    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

61 requetes sql en 0.0629

Taille variable Globale : 76.07 KB