Description de l'annonce
Tonte de pelouse et haie
#Elagage
Voir les annonces autour de moi Géolocaliser
Poster une annonce
Tonte de pelouse et haie
#Elagage
Demande un service d'elagage entre voisins ou proposer mes services d'elagage.
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='623983'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='elagage' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='526'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'elagage' 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='3' AND c.cate_id='38'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('51' 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='505059' 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` = 505059
SELECT util_cp FROM utilisateur WHERE util_id=505059 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 = 623983
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=526 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 505059 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='623983'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='623983' 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=505059 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=505059 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 = 505059 AND W.type_id = 1) OR (W.util_id <> 505059 AND W.type_id = 2)) AND (M.post_util_id = 505059 OR M.dest_util_id = 505059) 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 = '623983'
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='505059' AND wish_id<>'623983' 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='51360'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.1667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.1667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((4.18333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.717039197041 AND ville_latitude_deg<49.616360802959 AND ville_longitude_deg>3.495621459868 AND ville_longitude_deg<4.871038540132 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 ('51360','51360','51380','51360','51360','51380','51400','51400','51500','51500','51500','51380','51500','51400','51500','51500','51400','51150','51500','51490','51420','51150','51380','51500','51500','51400','51400','51400','51500','51150','51350','51150','51150','51420','51500','51500','51160','51160','51500','51420','51150','51490','51400','51150','51100','51500','51500','51160','51150','51110','51150','51400','51400','51430','51420','51500','51450','51160','51490','51370','51600','51110','51150','51160','51500','51150','51150','51430','51160','51500','51160','51480','51600','51490','51520','51490','51150','51370','51490','51490','51490','51370','51110','51390','51150','51390','51150','51160','51110','51150','51370','51400','51200','51200','51370','51160','51480','51480','51110','51400','51400','51490','51390','51390','51200','51110','51110','51600','51530','51390','51600','51390','51480','51480','51510','51480','51400','51220','51200','51390','51220','08310','51190','51170','51600','51110','51220','51390','51390','51110','51150','51200','51110','51220','08310','51520','51190','51220','51170','51170','51520','51140','08310','51140','08310','51170','51390','51390','51480','51220','51510','51460','51600','51130','51510','51200','08310','51140','08310','51480','51510','51130','51200','51390','51390','51110','51510','51480','51220','51220','51200','51190','51140','51480','51600','51480','51480','51200','51110','51600','51220','51170','51510','51600','51200','51130','51170','51000','51200','51170','51480','02190','51190','51190','51480','51170','51190','51200','51200','02190','51480','51140','51220','51140','08190','08300','51170','08300','51220','51470','51600','08300','51140','08310','51170','51700','08190','51130','08310','51510','51200','08300','51200','51170','51140','51700','51600','51130','08310','51460','08190','08300','51700','51480','51200','51200','51140','51600','08190','08310','02190','51170','51480','51130','51220','51170','02190','51510','51130','51140','51170','08300','51700','51700','08310','02190','51700','08310','08190','02190','51140','51130','02190','02190','08300','51130','51240','51170','51170','51460','51130','51140','51600','51130','51510','51520','51700','08190','08310','51700','51140','08310','51130','02190','02160','51240','51170','51700','02160','51700','51140','51700','02190','51130','51170','51470','51240','51140','02190','51520','08300','08190','08190','51170','51170','51700','08310','51130','51140','51130','08400','08400','02160','02160','51240','51240','51130','02130','02130','51700','08190','08190','08190','51320','08310','51140','08310','08300','51460','51270','51600','51130','08310','51170','02190','51600','08310','51700','02190','02160','51600','51600','51130','51460','51170','51700','51170','08400','51240','51170','51240','08190','51130','08190','51240','51170','02130','02190','51700','51800','51130','02160','02160','51240','08190','51170','51130','02160','51700','08300','08400','51700','51270','51270','02160','02160','51170','08400','08400','51240','08300','02160','51800','51800','51270','08130','08360','51240','51130','08300','51240','51130','51170','51320','08300','08360','51800','51700','08400','02160','51460','51270','51270','08130','08300','51240','51240','02130','08300','08300','02190','51700','51240','51270','08400','51800','51800','02160','08400','02160','08400','02130','51800','51270','08400','08360','51130','08360','08400','08400','08300','51240','08130','51320','51800','08300','51270','08130','08190','08250','02160','08130','02160','02190','51700','51240','51800','02160','02160','08300','08400','02160','02190','02220','51270','51240','02160','08400','08300','51230','02160','51800','02130','51240','51240','02130','08400','02220','02220','08400','02820','51270','02820','51800','51270','51800','02160','08400','51270','51270','51240','02850','02160','08300','08250','02330','08130','51800','02160','02160','51800','08300','02220','02160','51800','02220','02820','51800','02160','02820','51460','08300','51240','08400','51700','51800','51210','08130','51320','08360','02160','51240','02160','02160','08220','51230','08400','02160','51800','02130','51240','02130','08130','51270','08300','51210','08300','51230','51270','51320','51800','02860','02150','08400','08300','51800','08400','02820','02820','08130','02330','08300','08400','02160','51320','02820','02220','08250','02330','02130','02220','02220','02850','02820','51320','02850','51800','02150','51270','51240','51270','51240','02160','08250','02860','08300','51800','02220','08270','51270','08400','51240','08220','02130','02220','02850','08300','02860','51210','02130','51230','02130','02850','02850','08250','02160','02160','02160','02220','02220','08130','51210','02820','08130','02860','08270','51330','02330','51230','51800','08130','02820','51230','02130','51800','02850','51320','02220','08220','02220','02860','08400','51330','08270','51320','51800','08250','08130','51230','51330','02130','02160','51120','08400','51270','51800','08130','51330','51210','02220','08220','08400','02860','08250','02150','08270','29253','02330','51300','08250','02820','02330','51300','51120','08220','08270','02330','51300','02330','51800','08270','51800','02220','02840') AND fami_id='3' AND cate_id='38' AND type_id='1' AND ssrubr_id='526' AND wish_id<>'623983' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
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='526' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=99773 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 = 99773 AND W.type_id = 1) OR (W.util_id <> 99773 AND W.type_id = 2)) AND (M.post_util_id = 99773 OR M.dest_util_id = 99773) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 99773
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='3' 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 (50) 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 (38) 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 (45) 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 (231) 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 (47) 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 (42) 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 (37) 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 (43) 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 (39) 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 (229) 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 (230) 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