Discuter
Description de l'annonce
A la recherche d'un coffre de toit pour une semaine, merci.
#coffre de toit
Indiquer un code postal ou une ville
Poster une annonce
Discuter
A la recherche d'un coffre de toit pour une semaine, merci.
#coffre de toit
Annonces similaires
Tout voirLouer un coffre de toit entre particuliers ou proposer un coffre de toit en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
25€
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='395834'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='coffre-de-toit' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='723'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'coffre-de-toit' 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='227'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='27'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='216516' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 216516
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 = 395834
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=723 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='395834'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='395834' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 216516 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 216516 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 = 216516 AND W.type_id = 1) OR (W.util_id != 216516 AND W.type_id = 2)) AND (`post_util_id` = 216516 OR `dest_util_id` = 216516) 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='216516' 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 = '395834'
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='216516' AND wish_id<>'395834' 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='27120'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.05*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.05*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.600339197041 AND ville_latitude_deg<49.499660802959 AND ville_longitude_deg>0.63057707697713 AND ville_longitude_deg<2.0027629230229 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 (27120,27120,27120,27120,27120,27120,27120,27120,27120,27120,27930,27120,27930,27930,27120,27600,27950,27490,27120,27950,27950,27490,27930,27930,27950,27120,27930,27950,27930,27120,27930,27930,27950,27120,27930,27120,27490,27120,27930,27120,27930,27120,27600,27920,27220,27920,27120,27930,27490,27120,27930,27120,27930,27640,27220,27940,27950,27600,27220,27950,27220,27220,27930,27490,27220,78270,27950,27930,27120,27640,27600,27930,27930,27200,78270,27000,27930,27930,27600,27220,27600,27510,27600,27220,27600,78270,27220,27940,27730,27930,27220,27220,27400,27940,27730,27600,27940,27930,27930,78270,78270,27620,27180,27930,27400,78270,27730,27400,78980,27180,27400,27220,27940,27940,27220,27220,78270,27930,27220,27780,78270,27400,27400,27510,27400,27640,27180,27620,27220,27750,27180,27240,27400,27930,27180,78270,27700,27240,78980,27430,27930,27510,27110,27700,27700,27400,27510,27400,78980,27700,78270,27620,27930,28260,27180,27630,27180,27220,27220,78980,27700,27220,27400,78840,27220,27400,28260,27220,78270,27180,27620,27180,27430,27190,27700,27400,27540,78200,27430,27530,27180,27240,28260,78270,27220,27700,27110,27220,27700,27240,27240,27430,27430,27400,27510,27110,27400,27110,27430,27400,28260,27190,27190,28260,78270,27630,27110,95780,78520,27430,27700,27100,28260,78200,78710,27190,28260,78980,27430,27110,78270,28520,28520,27190,27240,78980,27630,27180,27720,27190,27400,78200,27240,28260,27320,27110,95510,27400,27510,27320,27700,27630,27110,27630,27110,78200,78980,27190,27510,78840,27510,95780,27400,27700,95710,78200,27190,27320,27430,27810,27100,27100,27770,28260,78790,27630,27190,27420,27400,27700,78200,27190,27110,27190,78200,27190,27370,50680,78790,27690,95510,27110,28560,27240,27190,27110,27630,78111,78200,95710,27190,27650,27110,78200,27440,27420,95780,78520,28260,28560,27590,27710,27340,27240,27420,27700,27190,27740,78200,27110,27110,27700,78790,27370,14380,27240,27420,27370,27240,27150,27190,78520,27340,27190,27630,78200,78910,27240,27420,27380,27190,27420,27190,27420,27380,27340,27440,78910,95710,78200,27150,27590,27420,27320,27150,95510,27170,27110,27420,78790,95770,27110,95420,27240,78790,78790,78200,78711,78930,27370,27110,78910,78930,78930,27440,27460,95510,28570,28410,76320,27150,27370,27110,27460,78930,27110,78520,95770,95770,28500,27380,27650,78790,27110,27650,27440,27170,95510,78440,27870,27370,27360,27320,28500,27610,28410,78550,28380,27320,27340,27370,27460,27170,27170,27240,27440,28350,22870,27240,27370,27720,27370,27150,76410,27160,27320,27160,27190,27110,27170,78440,95420,27190,27150,78930,76320,27110,27340,27150,27380,27380,27110,27370,28410,78910,95420,28350,28410,27370,95510,78440,76410,27370,27150,78440,76520,28500,95420,27170,95420,27170,78440,27190,78550,27370,27150,78790,60240,27110,95420,27370,27440,78790,76500,78790,76520,28410,27170,27110,76520,27370,27440,76350,76410,95420,95420,27570,78440,28500,78930,27380,27150,76410,27160,28500,78550,28100,27850,76520,28500,27380,78910,27720,28500,76520,95420,27570,28410,27150,27370,78910,78930,76410,27570,78550,27160,27790,27570,28410,28410,27170,27190,78970,78440,27170,27370,27370,27150,78440,27160,76520,78440,27150,76500,27110,78910,27110,28500,27380,78580,27670,28500,50410,27380,60240,27370,28500,95420,27370,78440,76500,78910,78770,28270,27370,28500,78550,27160,76520,28500,95420,78680,27190,27160,28500,78550,27760,27410,60240,27160,28270,27370,27160,60240,27370,27160,78910,60240,78440,78250,60240,27910,28500,28500,27170,27670,27150,76520,28410,78820,27890,78410,78410,27660,27660,28270,28270,27170,27410,78770,27800,27130,27830,27670,95450,95420,78410,95450,28500,28270,95450,95450,27170,76800,76520,28270,27800,27480,60240,28500,95450,27410,27860,76530,78950,78770,76240,28500,76520,28270,27160,78890,95420,78770,27160,27910,78126,76520,27170,27330,78410,78940,27150,27410,27130,28270,78250,76920,27800,27170,78580,78770,78770,27150,27800,76530,27480,27520,78113,60240,27370,28500,78250,27160,78580,76160,27130,28270,28210,76240,27520,76116,60240,27910,28500,95450,78250,27150,28500,27140,95750,76113,27800,28500,76650,27470,27140,76160,27910,78250,27480,28210,27480,28210,27910,78940,78113,27550,95450,27330,27800,76160,27480,76113,76530,78124,78113,78410,27520,76380,60240,60240,76300,78770,78490,60240,78250,27410,27330,28210,27470,78113,60240,78130,27150,27480,27140,78124,27150,78490,76160,95450,78113,78580,27330,76160,76240,95640,78113,28210,28270,60240,27910,28170,78650,27520,28210,27520,27150,78490,27300,60240,95450,27410,27130,28270,60590,28210,27550,28170,27470,95450,27480,78920,78490,27160,28210,95450,27520,14450,60590,27520,76120,27150,27290,78490,50570,76000,76100,27310,78650,78130,27520,27520,27800,27800,76780,28270,76160,95450,95450,78580,27410,78740,27330,28170,28210,76116,27310,76116,28170,50800,60590,60590,27800,60590,95750,27800,76780,27800,27480,78630,27130,27310,95640,95640,78490,78490,28210,76780,27250,28210,28210,76140,76160,27130,27330,27300,27410,78125,78740,27310,76160,28210,27520,95450,60590,60240,27520,78640,27150,60590,27140,76113,27310,60240,28170,27330,28270,60240,27800,76116,76230,27300,76116,27580,76116,22680,28170,60240,76420,76220,76780,76530,27520,78121,76840,27330,95450,76160,95180,27410,78640,76780,78640,27250,28210,78490,78490,76380,27800,78125,27300,78850,76160,78480,50370,27290,60590,27310,76130,27290,78810,78540,78610,27800,28210,28270,50370,60240,27310,95640,27330,27800,95800,27290,60240,27250,78640,95650,95650,78490,60590,95000) AND fami_id='5' AND cate_id='227' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='723' AND wish_id<>'395834' 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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=353338 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 = 353338 AND W.type_id = 1) OR (W.util_id != 353338 AND W.type_id = 2)) AND (`post_util_id` = 353338 OR `dest_util_id` = 353338) 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 = 353338
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=103243 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 = 103243 AND W.type_id = 1) OR (W.util_id != 103243 AND W.type_id = 2)) AND (`post_util_id` = 103243 OR `dest_util_id` = 103243) 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 = 103243
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=343918 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 = 343918 AND W.type_id = 1) OR (W.util_id != 343918 AND W.type_id = 2)) AND (`post_util_id` = 343918 OR `dest_util_id` = 343918) 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 = 343918
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=99434 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 = 99434 AND W.type_id = 1) OR (W.util_id != 99434 AND W.type_id = 2)) AND (`post_util_id` = 99434 OR `dest_util_id` = 99434) 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 = 99434
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=423488 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 = 423488 AND W.type_id = 1) OR (W.util_id != 423488 AND W.type_id = 2)) AND (`post_util_id` = 423488 OR `dest_util_id` = 423488) 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 = 423488
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 723
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