Réserver
Description de l'annonce
Location de combinaisons de ski enfants âge 6 ans.
Une rouge et une bleue en location :
15 euro / semaine / par combinaison
Les 2 combinaisons 20 euros.
#materiel de ski
Indiquer un code postal ou une ville
Poster une annonce
Réserver
Location de combinaisons de ski enfants âge 6 ans.
Une rouge et une bleue en location :
15 euro / semaine / par combinaison
Les 2 combinaisons 20 euros.
#materiel de ski
Annonces similaires
Tout voirLouer du materiel de ski entre particuliers ou proposer du materiel de ski en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
20€
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='244781'
INSERT INTO wish_photos (`wish_id`, `wish_temp_id`, `photo_path`, `photo_ordre`) VALUES (244781, 0, '/img/wiiz/13113-190131-1609-location-combinaison-de-ski-6-ans.jpg', 0)
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'materiel-de-ski' 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='95'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='77'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='13113' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 13113
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 = 244781
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=706 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='244781'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='244781' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 13113 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 13113 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 = 13113 AND W.type_id = 1) OR (W.util_id != 13113 AND W.type_id = 2)) AND (`post_util_id` = 13113 OR `dest_util_id` = 13113) 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='13113' 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 = '244781'
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='13113' AND wish_id<>'244781' 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='77230'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.0167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.73333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.567039197041 AND ville_latitude_deg<49.466360802959 AND ville_longitude_deg>2.0476961764121 AND ville_longitude_deg<3.4189638235879 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 (77230,77230,77230,77165,77230,77165,77230,77165,77165,77230,77410,77230,77165,77290,77230,77410,77230,77410,77410,77230,77122,77178,77410,60330,77230,60330,77410,77178,77280,77410,77450,77124,77410,77165,77230,77165,77290,60330,77990,60950,77410,77124,60330,77910,77990,77139,77450,77410,77230,77450,60440,77124,60440,77124,77100,77139,77910,77270,60950,77410,77400,60950,93290,77450,95470,77100,77450,95380,60440,77700,95380,60440,77181,95470,77450,60128,77139,77910,77139,60128,77400,77400,77450,77144,77700,95380,77400,77100,93410,93420,77181,77470,93470,95700,77910,60440,95470,77450,77177,60300,77400,77144,77400,77860,60300,60300,77400,95380,77860,93270,93390,93190,77440,93600,77470,77440,77860,77500,77700,77360,93370,77600,77600,60620,77470,95500,60620,77470,60520,77139,95670,77600,77600,60440,77580,60440,77600,77700,95380,60300,60440,60620,95190,60520,77200,77580,95500,77470,77186,60520,60620,77580,77440,77470,60560,77600,95470,77580,93340,93320,93460,77580,77580,77440,60620,93220,77420,77183,77090,95190,95500,77440,77700,60620,77470,95190,95270,60300,60800,60620,77580,77164,77440,95720,77440,95850,77580,77660,77185,93160,60800,60810,77145,95850,95500,77660,93250,95270,95270,93700,93150,60810,60800,77174,93360,60300,95720,77440,77440,95400,93140,77174,60620,93330,60620,95140,60300,77184,60810,77135,95270,60800,93440,60800,60620,77440,77163,94350,93000,60580,77580,93130,95270,95720,93110,60810,77680,60890,93350,95720,60300,60300,60620,94170,94420,77840,77580,95440,95200,95400,95270,77580,94360,60800,60620,77340,94120,77640,60800,60260,93260,93230,60620,95270,77260,93240,77260,77163,95270,60890,77440,95460,95350,60800,77440,60300,60117,94500,60500,93380,94130,60890,60890,93100,93500,95570,60810,93300,93120,95350,77580,77515,60810,77220,60700,60500,94510,95570,95410,77330,77260,60800,60890,93310,95360,93170,77120,94300,60810,77610,60300,94430,93210,93200,02810,60141,60800,60129,94880,94880,94490,77163,95330,77840,95160,93430,95570,95170,95270,60890,94340,94210,94100,94340,60270,95270,60320,60410,94410,77260,60117,60740,77515,77260,77640,92390,93450,60141,95270,94160,95560,95880,77260,77515,60117,60129,77610,77120,95560,60800,94370,94380,60890,60410,77220,60410,60129,60410,77220,77440,95580,95580,60410,02810,95570,95230,93800,95270,93400,60340,77610,77840,95560,60700,60320,60320,94220,77260,77610,77150,94000,60127,60117,60820,02460,77120,94700,77515,77150,95680,95600,60340,92230,60700,60100,94380,95210,95218,77138,75017,75011,75004,75015,75013,75014,75018,75016,75001,75009,75002,75003,75005,75006,75008,75116,75010,75020,75019,75000,75012,75007,60129,60700,02600,60410,77220,94140,95590,60320,60550,60460,94470,95590,77173,94200,94205,77120,60180,60117,60160,77515,95390,02310,02810,95590,92110,60870,95560,94440,95120,77730,95820,77750,60127,77510,92600,60700,60870,94270,77540,77610,77170,60870,95320,02810,95260,77220,92300,60160,77120,60123,95840,77730,94460,94440,60660,94400,77169,02810,95340,77730,95110,77610,60460,92270,60940,02810,94800,95100,02600,94600,02600,95260,94440,94450,77131,77750,02310,95130,02460,77610,02600,95130,94250,77169,60123,95840,60940,02810,60290,92700,60126,02470,95340,60126,77390,92200,02310,60610,60710,02460,77166,60940,91330,95660,02600,60710,92400,60530,60530,92250,77120,60530,60290,77750,92170,94520,94520,60660,60660,92120,95150,94190,77131,95550,94320,95740,02470,94110,60700,77170,02810,95290,77730,02470,77120,60700,02810,94390,94310,60660,60660,60140,92240,02470,77750,95870,95250,60880,02310,60230,77170,02310,95240,60140,94238,94237,94235,94233,94232,94231,94236,94234,94240,94239,94230,94290,91800,77120,60290,02600,95620,95540,91560,60700,60680,60350,94550,95630,95430,02810,60190,60530,60530,02600,60530,77169,91480,60660,02470,92220,77390,91800,02600,02600,77540,02810,95760,02470,02310,92800,92150,60140,02400,95370,91860,02810,78800,02310,95530,77510,94480,92340,02600,92130,77540,60140,92320,77380,77510,92100,77111,94150,02310,77540,78500,60680,60880,77166,60880,60680,02600,77390,91230,77111,02470,77120,77510,77750,92000,95340,77750,02600,60350,91200,95480,95220,60290,02310,91480,02600,60190,78420,02400,92500,95430,77169,92140,77540,92330,92260,77390,60140,95690,91270,60190,60190,02470,02400,02400,60250,60140,60350,92210,94260,77390,77390,60530,60680,60540,77390,60290,92360,92190,02210,60540,60190,60540,91550,92350,60250,02600,77510,02310,02600,77120,91320,60350,78600,77390,02470,60350,92160,60250,77510,02600,02600,91210,77390,77540,95690,02310,02400,78360,92290,02210,60600,60730,77320,02600,60290,77720,02400,95690,77390,77510,60600,77550,60600,92380,60190,60540,95300,77540,77127,60540,60200,77550,02600,92310,60190,92410,77320,95690,02210,02400,91260,77141,60250,60200,78400,95310,78600,91370,77550,91300,92430,92420,60250,60840,60600,02600,91450,60730,91420,60190,92370,77320,60350,60350,02400,91250,02210,77320,95610,02400,02400,95300,60190,77390,02570,78700,02600,77320,78170,77510,95300,91170,02600,60190,60280,77390,95810,60350,60350,60110,02210,78110,78140,78380,78290,91450,91000,91130,95300,60250,77550,02290,60153,60600,60730,60730,02210,60350,91160,91380,60600,78560,91090,91000,77370,02210,60750,77720,91280,02600,02210,60350,60600,02210,78220,91600,91390,02570,78230,77510,78430,91570,60600,60600,91250,91350,77970,60190,60190,60190,77950,60190,77390,77720,95810,77950,02210,60250,91120,95000,02400,60350,02600,60250,95000,78780,91360,77970,60570,60200,60570,60200,02400,78570,60730,77320,95520,78260,60350,60600,91160,77320,95650,60150,60190,60190,77510,91430,78100,78150,60110,02210,77720,91250,02600,91360,02400,78150,02210,60190,95810,77176,78750,60250,02600,60170,60600,02210,91100,95810,02400,60110,02400,78350,91140) AND fami_id='5' AND cate_id='95' AND type_id='1' AND ssrubr_id='706' AND wish_id<>'244781' 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='706' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=342557 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 = 342557 AND W.type_id = 1) OR (W.util_id != 342557 AND W.type_id = 2)) AND (`post_util_id` = 342557 OR `dest_util_id` = 342557) 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 = 342557
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='706' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=139621 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 = 139621 AND W.type_id = 1) OR (W.util_id != 139621 AND W.type_id = 2)) AND (`post_util_id` = 139621 OR `dest_util_id` = 139621) 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 = 139621
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='706' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 342557
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='706' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=70742 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 = 70742 AND W.type_id = 1) OR (W.util_id != 70742 AND W.type_id = 2)) AND (`post_util_id` = 70742 OR `dest_util_id` = 70742) 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 = 70742
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='706' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=377735 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 = 377735 AND W.type_id = 1) OR (W.util_id != 377735 AND W.type_id = 2)) AND (`post_util_id` = 377735 OR `dest_util_id` = 377735) 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 = 377735
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='706' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=311956 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 = 311956 AND W.type_id = 1) OR (W.util_id != 311956 AND W.type_id = 2)) AND (`post_util_id` = 311956 OR `dest_util_id` = 311956) 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 = 311956
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 706
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