Description de l'annonce
Loue 1200 m² de jardin pour réunion familiale, anniversaire
#Jardin
Voir les annonces autour de moi Géolocaliser
Poster une annonce
Loue 1200 m² de jardin pour réunion familiale, anniversaire
#Jardin
Louer jardin entre particuliers ou proposer jardin 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 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 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='511002'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='jardin' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='928'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'jardin' 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='176'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('70' 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='351627' 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` = 351627
SELECT util_cp FROM utilisateur WHERE util_id=351627 LIMIT 1
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 = 511002
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=928 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 351627 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='511002'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='511002' 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=351627 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=351627 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 = 351627 AND W.type_id = 1) OR (W.util_id <> 351627 AND W.type_id = 2)) AND (M.post_util_id = 351627 OR M.dest_util_id = 351627) 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 = '511002'
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='351627' AND wish_id<>'511002' 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 ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='70230'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.4333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.4333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.25- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.983639197041 AND ville_latitude_deg<47.882960802959 AND ville_longitude_deg>5.5852550489953 AND ville_longitude_deg<6.9147449510047 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 ('70230','25680','25640','25640','70230','25640','70230','25680','70230','25640','70230','25680','25640','70230','70230','70230','25680','25680','25640','25640','25680','70190','70230','25640','70230','25640','70230','70190','25680','70230','25640','25680','70190','70190','25110','25640','25640','25680','25680','25680','25110','25680','70230','25640','25110','25640','25640','70190','25680','70230','25110','25680','70190','70190','25680','25110','70230','70230','25680','25680','25640','25640','25640','25640','70230','25110','25110','70190','70190','25870','25110','25640','25110','70190','25110','25870','25870','25680','70190','70190','25340','70190','25110','25640','25640','25640','70190','25640','70000','25110','70110','25870','25680','70190','25110','25340','70190','70110','25640','25340','25110','25680','25680','25870','70190','25820','70000','25340','25960','70000','25340','70190','25110','70000','25640','25110','25110','25110','70000','70110','70110','70190','70000','25220','25360','25340','70190','25110','25340','25870','70190','70000','25110','25360','25340','25870','25110','70000','70110','25110','25220','25640','25220','25360','25360','25360','70000','70110','70000','25870','70190','25360','25220','25250','70190','70110','25110','70190','70110','25340','25340','70000','70110','25360','70000','25360','70190','70110','25340','70110','70000','70000','70190','25340','25250','25220','70190','70190','25340','70000','70000','70000','25870','25340','70190','70110','70110','25220','70190','25360','25360','70000','70000','70190','70110','25360','25250','25360','70110','70110','70110','70110','25870','70000','25430','25870','70110','70110','70000','25360','70000','25220','25220','70000','25360','25250','70190','25530','25660','25430','25340','70110','70190','25870','70000','70000','70190','70110','70110','25340','70190','70200','70110','70240','25360','70130','25250','25250','70000','70110','70700','25430','25530','70000','25530','70000','70000','70240','25530','70700','70000','25660','25250','25340','25620','70000','70000','25360','70000','70110','70110','70000','25530','25870','70130','25250','25430','25430','25530','70000','70200','25250','25530','70110','25660','70150','70240','70000','25580','25870','70130','70000','70240','25530','25000','70000','70700','25660','25870','25250','25250','70240','70700','70700','25530','25620','70110','25480','25530','25510','70200','70130','70240','70000','25870','25480','70400','70130','25250','70130','70360','25250','25250','70360','25660','70240','25250','70700','25430','70400','70400','70240','25250','70240','25430','25480','70000','70200','70170','70400','70000','25250','70360','25170','70150','70700','70240','70170','70700','25250','25250','25510','70400','25430','25430','25620','70240','70240','70700','25250','25430','25170','70150','25530','70200','70360','25620','25260','70130','70240','70200','70360','25510','25530','70000','70700','25170','25260','70700','25430','70130','25250','25510','70200','70240','70360','25620','25250','70170','25510','70130','25170','70170','70200','70360','25660','25530','25115','25770','70130','70150','25580','70240','25150','70700','70170','70130','25620','25170','70200','70360','70240','70240','25530','25620','70240','25720','25720','70200','25260','25380','70200','25800','25170','70400','70130','70360','25170','25770','25750','70200','70170','25190','25690','70400','25430','25260','70700','70200','25510','70700','25620','25150','25750','25170','25170','70240','70700','25580','25720','70200','70360','70400','70200','70360','25260','70170','25150','70150','25620','25620','25190','70150','70700','70160','70200','70120','25510','25720','70200','25660','70120','25380','25800','25113','25170','70200','70200','25190','25550','25720','70700','25190','70700','70300','25580','70400','25260','25170','25580','70160','70170','70130','25150','25770','25380','70300','70200','70200','25320','70300','25750','25320','70150','25390','70700','70700','25800','70300','70200','70170','25690','25750','25750','70160','25550','25150','70130','70130','25170','25380','25170','70200','25420','70170','70400','70300','25580','25660','25320','25390','70700','25550','25550','70400','25190','25320','25580','25580','25550','70300','70200','25150','70300','70150','25690','25580','25320','70160','70120','70400','25620','70200','70160','70300','25380','25170','25380','70200','25170','25190','25580','25380','70400','70130','70200','25170','25420','70700','70200','25290','70120','70160','25550','70360','70200','70700','25380','70400','70300','25580','70170','70100','25550','25390','25410','25170','25380','70120','25550','25550','70200','70160','25290','70130','25410','25190','70100','25580','70300','25420','70700','70300','25111','25690','70130','25210','70400','25420','25580','70300','25580','25290','25150','70200','70120','25320','25390','25630','25380','25390','25440','70300','25320','25170','70130','70130','25410','70160','70160','70200','70400','25580','25190','25190','25190','25380','70150','25410','25700','25150','25290','70200','25440','25410','70130','25380','25190','25190','70400','25290','25320','25380','70120','70400','70700','25840','70160','25420','70400','70200','25210','70150','25210','25290','70300','70180','70400','25320','25390','70150','25840','70300','70800','25330','70100','25210','25350','70100','70120','70120','25170','25120','70400','70150','25190','25120','25390','70120','25170','70300','70300','70250','70150','25690','70180','25210','25410','70160','25200','25190','70270','70400','70120','70800','25930','70800','70160','25410','25210','25150','25200','25190','25390','70150','25580','25410','70800','25400','25150','70100','70180','70500','70160','25210','70120','70270','70270','70160','25330','70180','25320','70400','70300','70400','70150','70120','70160','70400','70120','70270','25410','25440','25170','70300','25520','70180','70100','25410','25330','25170','25700','70500','70120','25400','25120','70100','70290','25440','70300','25400','25330','70800','25920','70180','70100','70140','25190','70120','70180','70150','25440','25440','25310','25600','25600','25330','25210','70300','25190','25520','90800','70180','70400','25320','25210','25440','25170','39700','70270','25230','25310','25200','70120','90800','70100','25330','25310','25440','25320','25500','25330','70400','25440','70120','25400','25210','39350','25440','25140','25410','70400','39700','25210','70160','25330','70180','70500','25650','70270','39350','25120','25330','25520','25440','70800','25190','70140','70100','70800','70800','70100','90800','90800','25310','25600','25330','25230','70100','25120','70160','70800','25330','25500','70100','70800','25520','39350','90400','25330','70500','70100','25460','25210','25310','70100','25190','70500','70270','25440','70500','70270','25410','70140','39350','70280','70160','25330','70310','70180','90700','25210','25310','25600','70120','70300','25310','25120','39700','70400','70140','25440','70280','25310','39350','39350','25140','90850','25500','70290','90400','25600','25470','39700','25520','70800','70280','70310','25440','70500','90850','25520','70270','70120','25650','70500','90400','70800','25500','70140','25440','25440','25500','90400','70140','70310','70500','25520','70120','25230','25140','39350','02914','39700','90350','25230','70210','25310','90400','70180','39350','25500','25440','70310','25470','25440','70140','70600','70280','70140','25440','25490','25210','25190','70180','90400','39350','90300') AND fami_id='5' AND cate_id='176' AND type_id='1' AND ssrubr_id='928' AND wish_id<>'511002' 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