Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Recherche quad à louer

Annonces similaires

Tout voir
Location quad
Location : quad

Demande il y a + de 30j

Il y a + de 30j • 62880

Je cherche un 700 raptor (2 jours)
Profil du voisin
Voisin #271918

Vendin-le-Vieil 62880

200€

Louer mon quad
Location quad
Location : quad

Demande il y a + de 30j

Il y a + de 30j • 62420

Recherche quad à louer
Profil du voisin
Voisin #193233

Billy-Montigny 62420

-- €

Louer mon quad
Location quad
Location : quad

Demande il y a + de 30j

Il y a + de 30j • 62220

Cherche quad à louer (7 jours)
Profil du voisin
Voisin #524211

Carvin 62220

100€

Louer mon quad
Location quad
Location : quad

Demande il y a + de 30j

Il y a + de 30j • 59570

Recherche quad à  louer (1 mois)
Profil du voisin
Voisin #73837

Bavay 59570

-- €

Louer mon quad
Location quad
Location : quad

Demande il y a + de 30j

Il y a + de 30j • 62880

Quad homologuer
Profil du voisin
Sheherazade B

Vendin-le-Vieil 62880

250€/sem

Louer mon quad

Louer un quad entre particuliers ou proposer un quad en location.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php
  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0001

    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='572973'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='quad' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1001'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'quad' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, 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'

  6. 0

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='59'

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='424063' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  8. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 424063

  9. 0.0001

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  10. 0.0001

    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

  11. 0.0004

    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

  12. 0.0002

    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

  13. 0.0002

    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

  14. 0.0002

    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

  15. 0.0002

    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

  16. 0.0002

    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

  17. 0.0002

    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

  18. 0.0002

    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

  19. 0.0002

    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

  20. 0.0003

    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

  21. 0.0002

    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

  22. 0.0001

    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

  23. 0.0002

    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

  24. 0.0002

    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

  25. 0.0001

    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

  26. 0.0001

    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

  27. 0.0001

    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

  28. 0.0002

    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

  29. 0.0001

    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 = 572973

  30. 0.0001

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='572973'

  31. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='572973' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  32. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 424063 AND util_tel != ''

  33. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 424063 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

  34. 0.0001

    SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 424063 AND W.type_id = 1) OR (W.util_id != 424063 AND W.type_id = 2)) AND (`post_util_id` = 424063 OR `dest_util_id` = 424063) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  35. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='424063' AND note_visu IN (1,3,4)

  36. 0.0001

    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 = '572973'

  37. 0.0001

    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='424063' AND wish_id<>'572973' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  38. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59410'

  39. 0.0041

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.917039197041 AND ville_latitude_deg<50.816360802959 AND ville_longitude_deg>2.795053505516 AND ville_longitude_deg<4.204946494484 HAVING distance <= 50 ORDER BY distance ASC

  40. 0.0024

    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 (59410,59494,59192,59590,59174,59494,59860,59300,59880,59770,59195,59300,59135,59195,59125,59300,59220,59121,59990,59220,59135,59121,59278,59990,59264,59255,59990,59233,59990,59224,59269,59243,59230,59970,59220,59269,59171,59970,59990,59224,59970,59144,59178,59178,59269,59990,59990,59163,59213,59282,59199,59199,59213,59227,59124,59158,59171,59920,59230,59154,59156,59144,59530,59282,59530,59293,59163,59178,59171,59870,59144,59230,59226,59213,59213,59870,59178,59144,59172,59230,59163,59144,59179,59198,59530,59215,59870,59230,59158,59227,59213,59227,59213,59490,59111,59296,59158,59158,59530,59144,59111,59172,59530,59870,59570,59870,59294,59226,59730,59530,59111,59530,59690,59310,59530,59530,59188,59490,59580,59570,59188,59310,59570,59580,59730,59530,59570,59144,59144,59252,59111,59310,59870,59870,59165,59570,59218,59218,59530,59141,59530,59218,59252,59252,59310,59188,59295,59295,59146,59176,59129,59730,59730,59570,59570,59218,59292,59176,59141,59277,59234,59570,59141,59310,59182,59730,59530,59730,59310,59247,59247,59570,59214,59530,59310,59310,59570,59234,59161,59148,59400,59234,59167,59182,59287,59570,59554,59530,59271,59169,59570,59217,59288,59222,59161,59161,59310,59287,59247,59265,59194,59169,59554,59570,59222,59217,59222,59161,59550,59217,59151,59360,59268,59265,59830,59550,59540,59400,59194,59540,59265,59265,59450,59119,59157,59187,59242,59554,59570,59157,59830,59830,59554,59540,59235,59360,59540,59138,59169,59310,59151,62860,59830,59400,59217,59400,59242,59169,59138,59265,59138,59145,59360,59400,59830,59145,59400,59550,59980,59151,59780,59400,59830,59242,59286,59554,59620,62860,59225,59360,59283,59750,62860,59330,59360,59554,59552,59500,59267,59246,59191,59138,59710,59283,59169,59151,59330,62860,59360,59400,59620,59780,59550,59191,59980,62790,59151,59980,59710,59710,59553,59553,59552,62860,59128,59600,62112,59550,59225,59950,59127,62112,59273,59400,59152,62490,59281,59830,59191,59550,59273,59551,59330,59600,59620,59360,62860,59330,62860,59152,59152,59980,59980,62490,59262,59267,62141,62860,59258,59550,59159,59360,59620,59152,59553,59241,59162,62490,59600,59239,62117,62860,59258,59360,62970,59600,59710,59620,59720,59259,59127,59780,59239,02110,59360,59261,62860,02110,59238,59159,59600,59360,59330,59330,62860,59440,59551,62860,62860,59440,59810,59400,59127,62820,62490,62490,62156,59550,59258,59440,59390,62490,59600,62950,59330,62147,59137,59510,62156,59131,59244,62119,59600,59127,59127,59680,59600,59175,59244,59510,59360,59440,62860,59133,62590,02450,59390,62156,62182,59790,59440,62118,59244,59113,59260,59175,59390,02110,59267,59440,02110,02110,62860,59155,62490,62147,59600,02110,62182,59115,59390,59680,02630,59680,59266,59142,62118,59440,59139,62220,62156,02110,59168,59245,02450,59133,59159,59680,62490,62110,62156,02420,62147,02450,62640,59231,59147,59680,02170,62156,59550,59266,59440,62710,59112,59370,59680,62320,62320,62580,02450,59440,59290,59170,59440,02110,59263,59139,59147,62860,62860,59216,62740,59164,62118,59150,59740,62156,59440,62118,59440,59740,62182,62320,59266,59350,59160,59000,59800,59777,59440,02630,02110,62880,62420,59147,59216,59216,62147,59251,59231,02110,59460,62182,62147,62147,59655,59493,59491,59650,59680,62440,62118,62580,62320,62580,02420,02170,59320,62580,59100,02510,59110,62128,59680,62118,59120,02420,59112,59740,62118,02420,59700,59231,59185,02630,59297,62128,59320,62580,59740,62680,62880,62880,59740,59149,59440,62147,59420,62430,02510,02110,02170,62124,02510,62218,62221,59130,62128,02110,59740,59350,59320,62159,59272,62124,59520,59200,62410,62580,02170,62128,62128,62880,62580,59177,02110,02450,02450,59740,59910,62124,02230,59219,59221,59211,59219,62128,02120,59136,62124,59177,62124,62128,59740,62223,59320,02420,59184,02420,62580,62128,62210,59118,02260,62124,62128,62300,62410,02510,02110,62138,62223,59149,59320,62124,59219,02110,02110,02110,59740,02170,62124,80740,62580,02420,59496,02120,02120,59840,02450,59740,59134,62300,59177,62124,59320,59320,02420,80740,02120,59320,62159,80122,62124,62410,80360,62128,59160,59274,59960,62128,02420,62580,59320,59149,62217,80240,59134,59237,02420,59740) 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<>'572973' AND wish_url='' ORDER BY rand() LIMIT 0,10

  41. 0.0001

    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

  42. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=271918 AND note_visu IN (1,3,4)

  43. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 271918 AND W.type_id = 1) OR (W.util_id != 271918 AND W.type_id = 2)) AND (`post_util_id` = 271918 OR `dest_util_id` = 271918) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  44. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 271918

  45. 0.0001

    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

  46. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=193233 AND note_visu IN (1,3,4)

  47. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 193233 AND W.type_id = 1) OR (W.util_id != 193233 AND W.type_id = 2)) AND (`post_util_id` = 193233 OR `dest_util_id` = 193233) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  48. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 193233

  49. 0.0001

    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

  50. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=524211 AND note_visu IN (1,3,4)

  51. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 524211 AND W.type_id = 1) OR (W.util_id != 524211 AND W.type_id = 2)) AND (`post_util_id` = 524211 OR `dest_util_id` = 524211) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  52. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 524211

  53. 0.0001

    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

  54. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=73837 AND note_visu IN (1,3,4)

  55. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 73837 AND W.type_id = 1) OR (W.util_id != 73837 AND W.type_id = 2)) AND (`post_util_id` = 73837 OR `dest_util_id` = 73837) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  56. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 73837

  57. 0.0001

    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

  58. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=39374 AND note_visu IN (1,3,4)

  59. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 39374 AND W.type_id = 1) OR (W.util_id != 39374 AND W.type_id = 2)) AND (`post_util_id` = 39374 OR `dest_util_id` = 39374) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  60. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 39374

  61. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1001

  62. 0.0009

    SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7

  63. 0

    SELECT count(*) as nbwish FROM wish

  64. 0.0577

    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

64 requetes sql en 0.0723

Taille variable Globale : 76.54 KB