Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Location voiture boite auto (2 semaines)

Retour Location Voitures Location voitures 79 entre particuliers Location voitures 79 entre particuliers

Discuter

Ce voisin demande à louer à Tourtenay (79100)

400€

-7200kgqu'à l'achat

Description de l'annonce

Je recherche une petite voiture boite AUTOMATIQUE, à louer pour 2 semaines en aout, (entre le 14 et le 28 ) pour les vacances (petits déplacements dans les Deux-Sèvres.

#voitures

Annonces similaires

Tout voir
Location voitures
Location : voitures

Demande il y a + de 30j

Il y a + de 30j • 79300

Cherche location vehicule (2 jours)
Profil du voisin
Voisin #500993

Bressuire 79300

110€

Louer ma voiture
Location voitures
Location : voitures

Demande il y a + de 30j

Il y a + de 30j • 79440

Prêt de véhicule pour une journée
Profil du voisin
Karine T

Courlay 79440

41€/jr

Louer ma voiture
Location voitures
Location : voitures

Demande il y a + de 30j

Il y a + de 30j • 79300

Location voiture
Profil du voisin
Frederic G

Bressuire 79300

52€/jr

Louer ma voiture
Location voitures
Location : voitures

Demande il y a + de 30j

Il y a + de 30j • 86200

Cherche audi tt pour un mariage
Profil du voisin
Voisin #42646

Loudun 86200

150€/jr

Louer ma voiture
Location voitures
Location : voitures

Demande il y a + de 30j

Il y a + de 30j • 49310

Louer une voiture (urgent)
Profil du voisin
Voisin #50637

Montilliers 49310

7€/jr

Louer ma voiture
Location voitures
Location : voitures

Demande il y a + de 30j

Il y a + de 30j • 79200

Recherche location voiture 4 jours
Profil du voisin
H

Parthenay 79200

200€

Louer ma voiture
Location voitures
Location : voitures

Demande il y a + de 30j

Il y a + de 30j • 44310

Cherche mecano
Profil du voisin
Carretero. N

Saint-Philbert-de-Grand-Lieu 44310

50€/jr

Louer ma voiture
Location voitures
Location : voitures

Demande il y a + de 30j

Il y a + de 30j • 44310

Recherche voiture en location
Profil du voisin
Daniel D

Saint-Philbert-de-Grand-Lieu 44310

-- €

Louer ma voiture
Location voitures
Location : voitures

Demande il y a + de 30j

Il y a + de 30j • 79200

Recherches location véhicule léger
Profil du voisin
Vanessa T

Parthenay 79200

40€

Louer ma voiture
Location voitures
Location : voitures

Demande il y a + de 30j

Il y a + de 30j • 79700

Location de voiture ou covoiturage
Profil du voisin
Voisin #54409

Saint-Pierre-des-Échaubrognes 79700

70€/sem

Louer ma voiture

Louer une voiture entre particuliers ou proposer une voiture 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='363410'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='voitures' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='985'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'voitures' 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.0001

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

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='173832' 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` = 173832

  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.0002

    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.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 (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.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 (193) ORDER BY ssrubr_order ASC

  26. 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 (91) ORDER BY ssrubr_order ASC

  27. 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 (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 = 363410

  30. 0.0001

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

  31. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='363410' 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` = 173832 AND util_tel != ''

  33. 0

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

  34. 0.0002

    SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 173832 AND W.type_id = 1) OR (W.util_id != 173832 AND W.type_id = 2)) AND (`post_util_id` = 173832 OR `dest_util_id` = 173832) 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='173832' 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 = '363410'

  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='173832' AND wish_id<>'363410' 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='79100'

  39. 0.0044

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.0167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.0167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.216667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.567039197041 AND ville_latitude_deg<47.466360802959 AND ville_longitude_deg>-0.87620822078489 AND ville_longitude_deg<0.44287422078489 HAVING distance <= 50 ORDER BY distance ASC

  40. 0.0137

    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 (79100,79100,79100,79100,79290,79290,79100,79100,79100,79100,79100,79100,79290,79100,79100,79290,79100,79150,79290,79290,49260,49260,49260,79330,86120,86120,79100,86120,86120,79100,86120,49260,79330,86200,79100,79150,49260,79330,79150,86200,79150,79150,86200,79600,79300,79330,49560,49700,49700,49560,49560,79330,79100,79330,79330,79600,79150,86120,86200,49700,86120,79600,86120,49260,79600,49260,79150,49700,49700,79600,49260,86120,49700,79600,49260,86330,49310,79150,86200,49260,86200,79300,49700,79600,49700,49310,86120,49260,79150,79350,49310,49700,79150,79600,49260,86120,49700,86330,79600,86200,49400,79150,49400,49540,49400,86120,49400,86200,79600,79600,86330,49540,49700,49310,86330,86330,79350,49700,37500,49700,49590,49310,79300,86200,49400,79600,85260,49310,49310,49400,49540,49540,86200,49360,49730,86330,49400,49400,49700,79250,49730,86330,49700,79600,37500,86200,86330,79350,79300,49360,49730,79390,86420,86120,49730,37500,79200,79200,37500,37500,79390,86110,49360,49320,37500,37500,49700,49350,86200,49320,79140,86420,49380,49380,49160,86420,37500,86200,37420,79390,86420,49310,37500,79200,49380,49350,49690,49350,86110,49650,79390,79430,79320,49670,49320,79390,37420,37420,49340,79140,86420,49320,49320,49360,86110,79350,86200,49380,86110,49680,37140,86200,79440,79200,49350,49380,49350,86170,79140,86110,86170,79200,86110,49650,79390,37500,86420,79450,86170,37140,86420,37120,49120,37500,49350,79140,79200,49380,49340,37500,49120,49680,86110,79700,49320,79390,79320,37120,49360,49320,49320,49750,79140,79200,37120,79200,49160,49120,37500,49160,86140,37140,49320,79380,79700,79130,49360,49390,79320,86170,86140,79450,86110,86190,79240,37120,37120,86190,37420,49250,37140,79240,79380,49750,37120,37120,79380,79130,79200,79140,79700,86230,49250,49750,86170,79320,37220,49120,49120,49320,37140,86140,86170,49340,49610,49160,86190,79200,49750,79200,37120,49250,79200,49610,86230,49610,86110,37140,49340,49320,37500,37120,37120,79130,49280,37120,86230,79240,49320,44860,44610,85700,37500,49320,86170,49250,85700,86170,79320,49800,49390,37220,37420,79420,79130,37140,49390,49610,86140,79700,49800,37220,86190,86190,44310,49120,49280,49250,79420,86170,49120,49250,79240,49250,37220,37120,86190,44650,49190,49120,85700,86230,37220,37120,49390,85590,85700,86380,37220,86190,49190,49130,86140,86380,86230,37220,79130,49130,49190) 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='985' AND wish_id<>'363410' 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='985' 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=500993 AND note_visu IN (1,3,4)

  43. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 500993 AND W.type_id = 1) OR (W.util_id != 500993 AND W.type_id = 2)) AND (`post_util_id` = 500993 OR `dest_util_id` = 500993) 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 = 500993

  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='985' 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=11777 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 = 11777 AND W.type_id = 1) OR (W.util_id != 11777 AND W.type_id = 2)) AND (`post_util_id` = 11777 OR `dest_util_id` = 11777) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  48. 0.0002

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

  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='985' 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=64802 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 = 64802 AND W.type_id = 1) OR (W.util_id != 64802 AND W.type_id = 2)) AND (`post_util_id` = 64802 OR `dest_util_id` = 64802) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  52. 0.0002

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

  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='985' 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=42646 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 = 42646 AND W.type_id = 1) OR (W.util_id != 42646 AND W.type_id = 2)) AND (`post_util_id` = 42646 OR `dest_util_id` = 42646) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  56. 0.0002

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

  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='985' 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=50637 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 = 50637 AND W.type_id = 1) OR (W.util_id != 50637 AND W.type_id = 2)) AND (`post_util_id` = 50637 OR `dest_util_id` = 50637) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  60. 0.0002

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

  61. 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='985' LIMIT 0,1

  62. 0.0001

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

  63. 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 = 71926 AND W.type_id = 1) OR (W.util_id != 71926 AND W.type_id = 2)) AND (`post_util_id` = 71926 OR `dest_util_id` = 71926) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  64. 0.0002

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

  65. 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='985' LIMIT 0,1

  66. 0.0001

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

  67. 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 = 442786 AND W.type_id = 1) OR (W.util_id != 442786 AND W.type_id = 2)) AND (`post_util_id` = 442786 OR `dest_util_id` = 442786) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  68. 0.0002

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

  69. 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='985' LIMIT 0,1

  70. 0.0001

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

  71. 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 = 321931 AND W.type_id = 1) OR (W.util_id != 321931 AND W.type_id = 2)) AND (`post_util_id` = 321931 OR `dest_util_id` = 321931) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  72. 0.0002

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

  73. 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='985' LIMIT 0,1

  74. 0.0001

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

  75. 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 = 65430 AND W.type_id = 1) OR (W.util_id != 65430 AND W.type_id = 2)) AND (`post_util_id` = 65430 OR `dest_util_id` = 65430) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  76. 0.0002

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

  77. 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='985' LIMIT 0,1

  78. 0.0001

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

  79. 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 = 54409 AND W.type_id = 1) OR (W.util_id != 54409 AND W.type_id = 2)) AND (`post_util_id` = 54409 OR `dest_util_id` = 54409) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  80. 0.0002

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

  81. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 985

  82. 0.001

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

  83. 0

    SELECT count(*) as nbwish FROM wish

  84. 0.0567

    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

84 requetes sql en 0.0867

Taille variable Globale : 78.82 KB