Discuter
Description de l'annonce
Recherche réfrigérateur pour la période du 21 juillet au 2 Août environ de champdeniers
#refrigerateur
Indiquer un code postal ou une ville
Poster une annonce
Discuter
Recherche réfrigérateur pour la période du 21 juillet au 2 Août environ de champdeniers
#refrigerateur
Annonces similaires
Tout voirLouer un refrigerateur entre particuliers ou proposer un refrigerateur en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
30€
Pour appeler mon voisin & organiser le rendez-vous.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
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='500556'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='refrigerateur' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='702'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'refrigerateur' 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='207'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='79'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='337208' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 337208
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 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 = 500556
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=702 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='500556'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='500556' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 337208 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 337208 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''
SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 337208 AND W.type_id = 1) OR (W.util_id != 337208 AND W.type_id = 2)) AND (`post_util_id` = 337208 OR `dest_util_id` = 337208) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='337208' 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 = '500556'
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='337208' AND wish_id<>'500556' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='79220'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((46.4842*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((46.4842*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.405- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.034539197041 AND ville_latitude_deg<46.933860802959 AND ville_longitude_deg>-1.0580570443173 AND ville_longitude_deg<0.24805704431727 HAVING distance <= 50 ORDER BY distance ASC
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 (79220,79220,79220,79310,79220,79220,79220,79220,79220,79220,79220,79160,79410,79310,79160,79130,79160,79310,79310,79400,79160,79160,79410,79130,79410,79410,79400,79310,79160,79130,79160,79260,79000,79310,79420,79400,79160,79420,79130,79160,79180,79160,79310,79400,79130,79260,79160,79410,79420,79400,79260,79240,79400,79400,79200,79130,79420,79240,79240,79230,79450,85240,79000,79340,79370,79200,79400,85490,79260,85240,79420,85240,79800,79240,79460,79000,79200,85240,85240,79420,85240,79370,85420,79340,79240,79450,79230,79200,79800,79130,79200,79800,85240,79240,79510,79200,79240,79370,79340,79370,85120,85420,79200,85120,79200,79270,79370,79240,79420,79800,79350,85120,85420,85420,79200,79230,85200,85420,79800,85120,79270,85200,79800,85200,79320,79340,79370,79270,79270,79230,79370,79320,79200,85120,79230,85420,85400,79340,85420,79370,79320,85200,79800,79210,79210,79320,79340,85320,79800,79210,79370,79230,79200,79430,85200,79350,85120,79360,86600,79800,79270,85120,85420,85120,79370,85200,85120,79360,79340,79390,79270,79390,79230,79390,85120,79210,85200,79230,85200,85200,79320,79380,79200,79120,79300,85420,85410,79210,79120,79120,85200,85200,79800,79270,85390,79210,79390,85200,86600,79360,85410,79350,85410,79600,85390,79360,79440,79170,79500,79360,86480,79500,85200,85200,79500,79500,86470,79600,86600,79170,79500,85700,79380,86190,85570,79210,17170,79360,79360,79210,79390,85770,17170,86470,86600,17170,85410,79120,79390,85570,79600,17170,79360,79380,85770,86190,79170,79350,85770,85770,85570,79500,85570,79500,79500,79500,85390,79600,85390,85700,17170,17170,79170,86470,85410,86600,85700,79120,79360,79600,17700,79600,85570,17170,79170,79300,79500,86170,86190,79170,79170,85210,85410,79360,79170,85390,79210,85570,85450,79140,17330,79140,85390,85370,79170,79500,79120,79600,79360,86470,85700,85450,79110,79330,79120,17330,79170,79600,79170,17700,85110,79170,79390,85700,17700,79110,17170,17170,79330,86600,86170,85210,85370,79330,17330,79170,85210,17170,79170,85210,79120,17330,85770,86600,79140,79600,86190,79110,79110,86600,86190,79140,85210,85390,79170,79140,79330,17470,86170,17700,79170,17330,79330,85700,86190,79120,79190,17470,86190,17330,79190,79330,86190,86110,17330,17540,79140,86170,86330,85700,86370,79170,17330,79120,79190,85370,85450,85260,17470,17330,79600,17700,17540,17330,85110,79190,85110,79110,86370,17330,86700,17700,85210,17330,86700,86170,86110,85210,79300,79190,86700) AND fami_id='5' AND cate_id='207' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='702' AND wish_id<>'500556' AND wish_url='' ORDER BY rand() LIMIT 0,10
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='702' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=249888 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 249888 AND W.type_id = 1) OR (W.util_id != 249888 AND W.type_id = 2)) AND (`post_util_id` = 249888 OR `dest_util_id` = 249888) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 249888
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='702' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=484913 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 484913 AND W.type_id = 1) OR (W.util_id != 484913 AND W.type_id = 2)) AND (`post_util_id` = 484913 OR `dest_util_id` = 484913) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 484913
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 702
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish
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
Contactez-nous