Description de l'annonce
Je suis propriétaire d'un jardin avec point d'eau (puit), je le prête
a une personne qui a envie de jardiner. Accessible facilement situé Commune de Luzancy..
#Jardinage
Voir les annonces autour de moi Géolocaliser
Poster une annonce
Je suis propriétaire d'un jardin avec point d'eau (puit), je le prête
a une personne qui a envie de jardiner. Accessible facilement situé Commune de Luzancy..
#Jardinage
Louer d'entretien d'espace vert entre particuliers ou proposer d'entretien d'espace vert en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
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
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='634846'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='jardinage' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='0'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'jardinage' 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='88'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('77' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='371620' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 371620
SELECT util_cp FROM utilisateur WHERE util_id=371620 LIMIT 1
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
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<>''
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 = 634846
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 371620 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='634846'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='634846' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=371620 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=371620 AND note_visu IN (1,3,4)
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 = 371620 AND W.type_id = 1) OR (W.util_id <> 371620 AND W.type_id = 2)) AND (M.post_util_id = 371620 OR M.dest_util_id = 371620) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
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 = '634846'
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='371620' AND wish_id<>'634846' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (w.wish_area IS NULL OR w.wish_area='' OR w.wish_area='FR')
SELECT ssrubr_slug, ssrubr_title, 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='532' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 371620
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='77138'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.18333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.517039197041 AND ville_latitude_deg<49.416360802959 AND ville_longitude_deg>2.4983839280719 AND ville_longitude_deg<3.8682760719281 HAVING distance <= 50 ORDER BY distance ASC
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_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('77138','77730','77730','77260','77730','77260','77260','77260','02310','77730','77640','77750','77750','02310','02310','02310','77260','77440','77750','02310','77260','02310','77260','77750','77440','77750','02310','02310','77640','02310','77750','02310','77440','77440','77510','77660','77440','02310','77840','77440','77510','02810','02400','77840','77510','77440','77440','77440','77660','77440','02400','02810','77169','77580','77510','77510','02570','02810','02400','02400','02810','77120','77470','02570','02810','02810','77510','02400','77840','77145','77510','77470','77440','02810','77510','77580','77510','77169','02400','77470','02810','02400','77120','02570','77169','02810','02400','02400','77470','77440','77510','77580','77910','77470','02540','60890','02810','02810','02400','77120','77470','02400','77440','02810','02400','77169','77580','77910','60620','77580','60890','77470','02400','02400','02540','02470','77320','02540','77320','77139','02400','77580','60620','77120','02540','02400','02470','60890','02470','77120','77139','02400','02470','77515','02400','77120','77910','77100','77320','02540','77580','02400','60620','77124','77320','60620','60620','02470','77320','77139','77320','02540','02470','60620','77910','02210','02540','02400','02460','60890','77515','77515','77580','02470','60890','77139','77860','77515','77124','77124','77100','02330','77100','77580','77580','77580','77320','02540','77320','02210','02650','02540','60890','02470','02470','02400','77163','77139','02400','60620','77163','60890','77120','02650','77860','02210','60620','77124','02210','77120','02460','02210','77320','02330','02650','51210','77320','77120','77165','77165','02460','02600','77860','77122','02330','77450','77120','77320','02210','02210','77320','60440','02400','51210','60620','02330','77320','77450','77320','77320','77580','02330','77320','02210','02330','02330','77450','77450','02210','77515','02330','02210','60141','77450','51210','77320','51210','02600','02210','02600','02330','77450','60620','02210','60620','77163','02330','02850','60141','02600','02210','77131','60620','77165','02850','02850','77178','77700','77700','02210','77410','77410','77165','77165','77410','60440','51310','77320','02850','77131','77540','02130','60440','77320','02850','77178','77450','02130','02210','02210','60620','77410','77560','77174','77700','77165','77540','02210','51210','77165','02330','77450','51210','51310','77320','02600','51210','02850','02600','02600','60117','51210','77970','60330','02330','51210','77970','02130','51700','77230','77610','77144','77700','02600','77700','02210','60440','77970','02600','77230','77141','60800','02600','60117','77174','60440','51210','51310','60117','02210','77320','77410','02850','77230','02330','77610','02600','60440','77970','77144','02130','51310','77560','77320','60330','51210','51210','02600','77610','60330','77560','77400','02210','51210','77540','51310','77230','77410','02130','51700','02600','77600','77560','77400','51210','77600','02130','60117','77410','77540','77410','77400','77410','02130','77610','02130','77230','02210','02130','77230','77400','60117','02210','77970','77230','60800','60800','77600','60800','02130','02210','77151','77610','51210','51270','02600','02130','77220','60123','02130','51310','02210','77540','77400','51700','02600','60950','02600','60440','60800','60330','02600','77600','77600','77230','02130','77610','02130','60123','51700','51270','77400','77410','77560','60440','77290','60800','02210','77230','77540','77400','51310','51700','51310','77164','02210','77560','77280','77600','51210','77230','02600','77160','77370','51120','51700','02210','02600','77540','77560','51310','77410','60950','77160','60800','02200','60300','51210','60950','77135','51310','51700','77610','77220','51700','60127','02220','51270','02200','02600','77560','02130','77360','51270','77183','77090','51210','51700','02200','02200','02600','77230','02600','02600','77390','51700','02200','77160','77200','60800','77370','77177','60129','60800','60127','02130','51120','77390','02600','77290','51270','60129','77270','02200','02130','51310','51270','77181','51120','77370','02200','77220','02200','02130','60129','60800','77390','77220','02200','77186','77560','51700','77230','02200','02200','77220','51310','02600','51270','77160','02600','60300','60300','60800','77370','02130','51310','77990','02220','60129','77370','77160','77720','77680','51700','51700','77370','02220','51120','77500','02220','77560','02220','02200','77390','77720','77330','51700','77230','51700','77185','60350','51270','02220','77181','02220','93470','51270','02130','60810','60350','93290','77990','02290','77420','51270','77184','02130','60300','77390','02200','51270','60810','02290','51120','51120','51700','51270','60350','77390','77171','93410','51120','60350','02200','77720','77370','77160','51700','93370','60320','60320','02220','60128','60320','51120','02200','02200','51120','02200','02220','51270','60128','77340','51480','95470','77720','02290','77390','77160','51700','02290','77160','93460','02200','51700','77390','93390','93190','77370','51170','51480','60810','02200','02200','95380','95470','60350','02220','02200','93160','77173','51120','95380','77370','02220','77160','02220','29830','60350','60350','60350','51700','02220','02220','51270','93420','60810','93270','60300','60410','02220','02220','77150','02200','51170','51120','51700','51170','77390','02220','94420','02220','51120','51170','77650','77650','51700','60520','02290','77370','95380','51120','93220','94510','02290','77650','95470','02220','02200','60320','94350','77170','02220','93600','51170','77160','51170','51120','51270','95700','77390','60810','77150','02200','02220','51120','77111','51480','77160','77166','93330','93320','93340','02220','60810','77370','60350','02220','60410','51480','51270','60350','77171','51480','60300','60350','02880','51270','51170','10370','93360','51270','02880','51200') AND fami_id='5' AND cate_id='88' AND type_id='1' AND ssrubr_id='0' AND wish_id<>'634846' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
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 AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous