Discuter
Description de l'annonce
Recherche quad 1 journée dans la semaine du 23 au 28 novembre
#quad
Indiquer un code postal ou une ville
Poster une annonce
Discuter
Recherche quad 1 journée dans la semaine du 23 au 28 novembre
#quad
Annonces similaires
Tout voirLouer un quad entre particuliers ou proposer un quad en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
60€
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='322764'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='quad' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1001'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'quad' 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='81'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='30'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='123614' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 123614
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 = 322764
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1001 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='322764'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='322764' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 123614 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 123614 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 = 123614 AND W.type_id = 1) OR (W.util_id != 123614 AND W.type_id = 2)) AND (`post_util_id` = 123614 OR `dest_util_id` = 123614) 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='123614' 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 = '322764'
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='123614' AND wish_id<>'322764' 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='30330'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((44.1167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.1167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((4.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>43.667039197041 AND ville_latitude_deg<44.566360802959 AND ville_longitude_deg>3.8903282475373 AND ville_longitude_deg<5.1430117524627 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 (30330,30330,30330,30330,30330,30330,30200,30330,30580,30330,30700,30330,30330,30330,30630,30700,30700,30580,30200,30330,30210,30200,30200,30200,30700,30200,30700,30290,30700,30630,30700,30630,30200,30290,30200,30580,30580,30580,30700,30200,30630,30130,30210,30700,30700,30130,30200,30210,30200,30700,30126,30580,30200,30126,30210,30760,30760,30210,30700,30700,30580,30210,30130,30630,30150,30130,30190,30126,30700,30760,84860,30210,30150,30760,30700,30580,30430,84550,30760,30700,84430,30760,30210,30390,30760,30210,30700,30190,07700,30190,84420,84840,30650,30430,30580,30210,30190,30430,30580,07700,30210,30210,30150,84100,30430,30430,30500,07150,30390,30360,07700,30320,30430,30360,30190,30580,30340,30360,30150,30190,84840,30430,30650,30210,30360,30500,30131,30190,84100,30390,30190,30190,30500,30320,30320,84500,30840,84230,30360,30360,30490,30340,30133,07150,30360,30360,30340,84830,07700,30400,07150,30500,30190,30190,30360,30500,30340,07460,84290,30390,30190,26790,30340,30190,30360,84350,07700,07700,84850,30190,30360,30320,30360,30190,84000,84140,30300,30500,07150,13570,30190,13150,84150,30340,30340,84700,13150,30560,30500,30300,84130,30350,84850,30190,30129,30960,84370,26130,30230,30300,26790,30410,30350,30350,07460,26130,30730,84290,30410,30350,07150,26700,13870,30340,30960,30350,07150,30350,30129,30350,30730,84270,30000,30900,30960,30100,30730,30380,84150,30520,84320,07460,30500,26790,30160,84290,13690,26130,30230,30720,07120,30350,07220,30480,84260,30140,26130,30730,30350,30300,30350,26700,84310,30132,30350,07120,84210,30110,07700,13150,30140,13160,07230,84190,30960,30730,07220,07460,07150,26790,30160,13910,26130,26790,84450,84450,07460,30350,30350,07120,30160,84870,26290,84110,30820,30350,84190,84470,84110,07120,84290,30110,84170,30128,84810,30260,30110,30350,30260,07460,26290,26230,13103,13630,07120,07120,30127,30540,84110,26230,30870,13103,30260,30980,84190,84820,13550,30140,30140,30730,26230,30980,30110,30870,30140,30530,84510,30260,84600,07120,84110,30610,07170,84190,84110,30610,07220,30610,07400,07200,30620,84200,30140,30260,30114,07140,30160,07220,30250,84250,26780,30620,26230,07140,30530,30110,30140,84190,30140,84190,30480,07120,30260,13440,30260,30160,07170,84330,84210,30510,07230,26110,07260,26230,13210,13670,30114,84110,26230,30140,26780,84740,07140,30140,30620,07200,07200,07230,30420,84110,84600,30450,26780,07110,30110,30110,30610,30260,84110,84330,07260,84330,13520,30450,07110,13670,30250,48160,30260,30140,30170,07140,26230,30530,07230,07260,30640,84600,30450,30250,30600,30450,07110,30300,30250,30140,84330,30111,07140,84110,84800,07170,07260,30920,26230,07170,30800,13460,48160,07200,84210,30310,30250,30260,07400,07110,07140,07140,07110,13520,13990,07110,30250,13940,84340,13520,30121,07200,84210,30610,26770,84380,30670,30250,30260,30600,07400,07140) AND fami_id='5' AND cate_id='81' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='1001' AND wish_id<>'322764' 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='1001' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=325999 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 = 325999 AND W.type_id = 1) OR (W.util_id != 325999 AND W.type_id = 2)) AND (`post_util_id` = 325999 OR `dest_util_id` = 325999) 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 = 325999
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='1001' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=324437 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 = 324437 AND W.type_id = 1) OR (W.util_id != 324437 AND W.type_id = 2)) AND (`post_util_id` = 324437 OR `dest_util_id` = 324437) 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 = 324437
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='1001' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=366049 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 = 366049 AND W.type_id = 1) OR (W.util_id != 366049 AND W.type_id = 2)) AND (`post_util_id` = 366049 OR `dest_util_id` = 366049) 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 = 366049
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='1001' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=94130 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 = 94130 AND W.type_id = 1) OR (W.util_id != 94130 AND W.type_id = 2)) AND (`post_util_id` = 94130 OR `dest_util_id` = 94130) 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 = 94130
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1001
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