Réserver
Description de l'annonce
Climatiseur mobile électrique #climatiseur
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Réserver
Climatiseur mobile électrique #climatiseur
Autres annonces du voisin
Tout voirAnnonces similaires
Tout voirLouer une camera thermique entre particuliers ou proposer une camera thermique en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
65€
Pour appeler mon voisin & organiser le rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
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='326800'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='climatiseur' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='777'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'climatiseur' 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='87'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='70'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='128155' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 128155
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 = 326800
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=777 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='326800'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='326800' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 128155 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=128155 LIMIT 1
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 = 128155 AND W.type_id = 1) OR (W.util_id <> 128155 AND W.type_id = 2)) AND (M.post_util_id = 128155 OR M.dest_util_id = 128155) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='128155' AND note_visu IN (1,3,4)
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 = '326800'
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='128155' AND wish_id<>'326800' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
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='14' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=128155 AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128155
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='68' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128155
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='73' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128155
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='69' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128155
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='602' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128155
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='36' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128155
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='71' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128155
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='966' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128155
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='29' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128155
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='59' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128155
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='57' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128155
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='70290'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.75- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.317039197041 AND ville_latitude_deg<48.216360802959 AND ville_longitude_deg>6.0810053833052 AND ville_longitude_deg<7.4189946166948 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_cp IN ('70290','70290','90200','90200','90200','70290','70440','90200','70270','70440','90200','90200','90330','70290','70440','90300','70270','70400','90300','90200','70270','70250','90350','70400','90200','88160','88560','68290','70310','90170','90170','88160','70270','70270','90300','70400','70400','90300','70310','70200','88160','70270','90170','70400','88160','68290','70270','90300','88540','88360','90300','70200','70200','70400','68290','68290','70200','90170','70200','90850','90300','70200','68290','70310','70400','68290','90110','68290','90110','90380','70400','90800','70400','70270','70310','70200','90110','70200','70200','90000','68290','90150','90150','70310','90850','70310','70200','90110','90110','70310','70200','90160','70200','70400','70310','70270','70400','90160','70200','90150','90150','68290','70200','70310','90400','70400','90160','90800','70310','90110','70300','90800','90800','90340','70200','88360','68470','90150','90150','68121','68470','70200','90360','70200','90400','70200','68290','70310','70310','70280','70400','88290','70400','88310','90400','70400','70280','90360','70400','70200','70200','70400','70200','70300','70280','68780','90150','90400','68290','70200','68470','90400','68470','90150','90150','90150','70280','90400','90400','70400','88290','90400','70400','90340','70280','70400','90400','70300','25750','70200','68470','88310','90150','70200','90400','90700','68210','68290','68780','68470','68550','70200','90150','90150','70400','68550','68690','90150','68800','70200','68780','88120','68830','25550','70400','90130','70400','25750','25750','68820','90340','90140','68780','68210','68800','68116','90130','70400','88340','70400','68210','90140','70400','70300','68800','68780','88200','25600','68210','70200','88340','68620','25550','70200','70200','70110','90140','25550','90140','70400','68210','25200','90130','68800','70300','88120','68760','68210','70200','25200','25750','90140','70400','68690','68210','68210','88200','25600','25550','70200','68780','25600','68700','70300','70300','70200','70400','70300','90120','88250','25550','88120','68210','88120','88120','25550','70300','70200','70110','25200','68210','70110','88120','25490','90140','68780','68210','68210','25600','25600','25750','70300','68700','25250','90120','68800','68760','68210','68820','90600','90100','68210','70220','70110','70240','25550','25550','25630','70110','70110','25420','88370','25113','90100','68700','90100','70300','70300','25490','25250','70110','68210','68210','68210','68210','68520','88120','25260','25400','90100','68700','88200','25400','25460','68210','70200','68210','70300','88200','90100','25250','70110','70110','70240','70300','70240','68520','25550','25420','70110','68700','68700','68520','25400','70240','90100','90100','88120','70110','68210','70110','25400','25490','70110','70110','70110','68210','68210','70300','70300','70300','68700','70800','68210','70300','68210','25490','25250','70110','70110','70240','70320','25250','68210','68210','90100','68210','68500','25420','88530','25420','25420','70240','90100','25260','25230','70240','70300','68380','70240','25260','68210','25250','70110','88200','90500','25700','68610','70240','25250','70110','70110','70110','70240','68720','70110','25250','70320','25230','68210','68380','70110','88400','68500','70300','70240','90100','25250','90100','68610','25230','88530','68580','68210','70110','68210','70320','68530','25260','25350','68720','68500','90500','25250','68990','88370','70110','88220','25230','25260','68500','90100','70800','68500','70240','68720','68610','68950','68580','70240','68990','68380','02926','70110','68500','25250','70240','70800','90100','70110','25260','25250','25150','90100','25700','25340','70240','88400','68530','68580','88400','70000','25250','90100','70300','70800','68500','70000','68850','68310','70800','68720','70800','70240','90100','68380','90100','70800','68360','88510','25310','25250','02925','68130','70800','90100','25250','70300','68790','68380','70110','68130','25250','25680','25680','25250','88640','68540','68140','25150','68720','70240','02924','70110','25150','25310','88240','88460','68580','68580','68580','88550','25250','68118','25310','68720','68720','68460','90100','25310','25250','68120','70800','70800','25310','25680','68720','70000','68720','90370','88220','68230','02933','68500','68500','70240','70800','88640','68140','68130','68720','70000','68500','70800','88220','68140','02915','02923','88640','25340','68130','25680','25150','68120','70160','88460','88640','88550','25150','70160','68500','68540','70000','88460','68350','70240','02916','88430','25250','25250','70230','68190','02935','02933','25310','68840','88380','88380','25680','88460','68570','68140','70160','68570','70000','70800','70160','68140','68140','68560','88230','25150','25340','70800','88640','68350','68580','02922','25150','25150','88240','70000','68720','70800','25680','68480','70000','68500','68720','25340','25680','68130','70000','25310','25250','88220','70800','25340','25340','25340','02932','25680','68580','68560','68250','25150','68110','68100','68200','70800','68260','68130','70800','68130','88460','68140','02908','68270','70230','25310','25340','70000','25310','68190','70210','68250','68130','70000','70000','25340','88430','88600','68130','88240','02944','88640','88600','25150','88240','02905','88640','70000','68560','68230','88240','25340','70210','68560','25340','88430','88600','68140','02907','68580','88220','02900','02900','02900','25310','88000','02906','88600','68130','70000','88460','70000','88430','68250','02914','25680','88460','25680','68230','02943','25340','70000','02912','88220','70160','68390','70160','68400','70230','68190','68390','68440','70000','25680','88600','88600','25190','25190','25190','25190','88600','70160','70170','25190','25190','68250','88460','25340','88600','68640','70210','88600','68270','68640','88240','68440','25190','25190','70000','68960','68960','25680','25110','02942','70230','68960','68890','68440','68130','70210','02912','25430','70000','68130','68130','68420','25340','70230','25680','25190','25430','68440','02902','02904','88230','88240','68890','68250','68480','70210','68390','25680','68960','70000','68510','70170','25190','70000','25190','88600','88600','25190','68440','88600','88600','70230','25110','88600','70160','70210','68170','68130','88240','68420','88650','70160','88230','88430','68480','25190','25340','68640','88240','02946','68440','70210','68480','70000','68130','68230','68230','25340','70160','68510','25680','68480','70230','25680','02903','25110','68440','68420','68420','68420','68480','68510','70230','70000','68130','68480','25190','70160','70000','68480','25680','70230','88230','02950','70210','68440','25190') AND fami_id='5' AND cate_id='87' AND type_id='1' AND ssrubr_id='777' AND wish_id<>'326800' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 777
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 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'
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)
Contactez-nous