Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Recherche grande tente pour 29/07/23

Retour Location Tente reception Location tente reception 27 entre particuliers Location tente reception 27 entre particuliers

Discuter

Ce voisin demande à louer à Guichainville (27930)

250€/jour

Prix

250€/jour

-36kgqu'à l'achat

Description de l'annonce

Bonjour,
Je recherche pour le week end du 29/30 juillet 2023 une tente réception 40/50 personnes montage / démontage inclus, possibilité chauffage, prix non déterminé et à discuter
car tables et chaises seraient un +
#tente reception

Annonces similaires

Tout voir
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 76840

Location barnum pour 40 personnes
Profil du voisin
Melanie B

Saint-Martin-de-Boscherville 76840

200€/we

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 27950

Location tente réception
Profil du voisin
Voisin #74517

Saint-Just 27950

150€/we

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 76140

Louer une tonnelle de 6m sur 4 m
Profil du voisin
Voisin #54952

Le Petit-Quevilly 76140

60€/nuit

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 27110

Louer : barnum / parasols
Profil du voisin
Maximilien V

Le Neubourg 27110

50€/jr

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 76000

Louer un barnum (20 mai)
Profil du voisin
Voisin #313392

Rouen 76000

100€/jr

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 27500

Location barnum
Profil du voisin
Catherine D
5.0

Bourneville 27500

200€/we

Louer mon barnum
5.0
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 28380

Dimanche 9 juin
Profil du voisin
Mandy C

Saint-Remy-sur-Avre 28380

50€/jr

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 27150

Location tente ou barnum 24h
Profil du voisin
Josephine S

Morgny 27150

150€/nuit

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 27510

Location : barnum
Profil du voisin
Manu P

Tourny 27510

150€/we

Louer mon barnum
Location tente reception
Location : tente reception

Demande il y a + de 30j

Il y a + de 30j • 27400

Cherche location barnum + parquet (2 jou
Profil du voisin
Estelle S

La Vacherie 27400

400€

Louer mon barnum

Louer un barnum entre particuliers ou proposer un barnum 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='429161'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='tente-reception' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='889'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'tente-reception' 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='176'

  6. 0

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

  7. 0.0001

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

  9. 0

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

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

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

  24. 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 (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.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 (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 = 429161

  30. 0.0001

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

  31. 0.0001

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

  33. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 254151 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 = 254151 AND W.type_id = 1) OR (W.util_id != 254151 AND W.type_id = 2)) AND (`post_util_id` = 254151 OR `dest_util_id` = 254151) 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='254151' 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 = '429161'

  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='254151' AND wish_id<>'429161' 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='27930'

  39. 0.0052

    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.08333- 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.39723707697713 AND ville_longitude_deg<1.7694229230229 HAVING distance <= 50 ORDER BY distance ASC

  40. 0.0054

    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 (27930,27930,27930,27180,27930,27180,27930,27930,27180,27180,27180,27110,27930,27930,27930,27180,27930,27930,27000,27190,27110,27180,27930,27180,27190,27930,27190,27930,27190,27190,27930,27110,27930,27930,27180,27400,27400,27110,27930,27190,27930,27930,27110,27400,27110,27930,27190,27930,27180,27400,27190,27110,27190,27190,27400,27490,27190,27110,27930,27190,27930,27930,27240,27110,27110,27400,27190,27190,27490,27220,27190,27170,27110,27240,27180,27930,27930,27110,27490,27930,27120,27190,27190,27490,50680,27930,27240,27170,27220,27400,27400,27240,27400,27490,27110,27110,14380,27170,27170,27170,27120,27120,27120,27190,27240,27190,27110,27110,27400,27240,27400,27110,27120,27600,27220,27190,27110,27400,27220,27120,27110,27110,27220,27170,27170,27190,27120,27400,27110,27600,27120,27110,27120,27220,27400,27170,27400,27370,27110,27240,27950,27600,27240,27370,27190,27400,27110,27120,27170,27600,27400,27170,27120,27220,27600,27220,27240,27220,27400,27220,27240,27120,27190,27110,27400,27370,27120,27120,27110,27120,50410,27370,27370,27160,27120,27370,27600,27110,27940,27370,27600,27240,27370,27400,27110,27950,27410,27760,27160,27220,27170,27950,27120,27600,27240,27220,27190,27220,27950,27430,27370,27120,27370,27940,27160,27370,27240,27320,27170,27410,27430,27370,27950,27170,22870,27220,27370,27220,27410,27370,27940,27220,27340,27920,27920,76320,27120,27100,27430,27370,27430,27950,27370,27800,27890,27240,27800,27410,27170,27640,27330,27120,27370,27370,27370,27160,27430,27940,27120,27370,27120,27170,27600,27220,27160,27220,27430,27430,27370,27320,27240,27470,76320,27800,27730,27950,27550,27220,27330,27160,27220,27100,76500,27160,27160,27370,27410,27120,27640,27950,27470,27940,27370,27730,27690,27670,27950,27800,27940,27340,27340,27510,27300,27410,27220,27700,27160,27470,27220,76410,27320,27800,27340,27160,27330,27750,27120,27700,27700,27700,76500,27340,27430,27550,27800,27220,76500,27670,78270,27100,27670,27770,27370,50570,27200,27410,78270,27160,27330,27700,27780,27700,76410,78270,27730,27430,27160,27320,76410,76410,27570,27460,27330,27520,27740,27300,27410,27460,27800,27800,27590,27460,27520,27520,27160,27800,27520,27570,27570,27570,76350,76410,27590,27700,27330,27800,27800,27700,27300,27530,28520,28520,78980,27410,28350,27320,27290,78270,27510,27130,27330,27640,27300,27810,76520,27520,27720,27330,27650,27320,27250,78270,27620,27700,28350,28260,27510,27800,78270,27380,27330,27520,27520,27410,27800,28270,27700,27540,27800,27620,27700,76520,27800,28380,28260,28260,27440,76530,78270,78270,76520,27380,27360,27610,27160,27410,27320,50800,76530,76520,27300,50210,27290,28260,27510,27800,28260,27710,78980,27520,27520,27520,78980,28260,27800,27130,76113,76530,27250,27330,27520,27300,27380,27300,28500,27650,78270,78980,27520,28270,27130,27250,27300,27290,76520,28260,27290,27800,76113,27300,27700,27440,27310,27630,27310,27250,27270,78270,27800,27620,27700,27290,28260,27130,27130,27580,27650,28270,27510,76800,28270,27330,76520,27290,28270,27310,28260,76650,27310,76380,27310,27290,28270,27800,78200,78840,27310,50370,28500,27250,27270,28500,27290,78270,27620,27270,27250,78980,27380,76520,28270,27700,28500,27130,27250,28270,50370,27510,27450,27310,14450,27630,27300,27510,27330,27300,27250,27800,27300,76920,27310,27440,78270,27440,27580,28570,27250,27380,76240,27800,78200,78980,27510,27450,27270,28270,76520,28560,27800,76530,27150,78270,27380,27310,95780,27130,27270,78520,28500,78790,27630,76113,27630,28270,27300,78710,27290,27270,27420,27450,27420,28560,28260,27440,27310,27380,28270,76300,78200,27290,27420,28100,27230,78790,76120,78980,76240,27290,27420,76520,27560,28410,76160,27390,78270,61300,27300,27310,27380,76530,27230,28500,61300,95510,28270,27420,61550,27150,27380,76840,27630,78200,28500,27630,27850,28500,27300,95710,27440,78111,78200,27270,27910,28500,27130,27560,76520,78840,28270,27150,27450,76000,76100,27300,95780,27270,27390,27150,78910,76240,76140,27230,27390,78200,76160,28340,28410,27560,28500,27350,27230,78200,61300,27630,27290,27150,78200,27560,27790,76160,27440,78790,27420,27820,27420,27450,27150,76520,76480,28500,28410,61550,61550,95510,27230,61300,27390,78910,78200,76480,27350,27230,27420,27230,27350,28410,27580,76160,95710,28500,28500,27270,27150,76380,28410,28500,28500,78200,28270,76160,78550,27350,27350,95780,27630,78520,61300,78910,28500,27290,28500,28270,78200,50250,27270,27350,27560,76840,78790,27390,28500,27230,28170,27270,27230,27420,27230,27450,27450,27560,27390,27390,27150,27910,78790,61550,28340,76116,27500,27350,28340,27870,28410,61300,95770,28170,27230,78790,95710,27500,27910,78520,76130,27350,76420,76160,28410,76250,76150,76230,27350,28250,28170,27820,27820,27150,27230,76160,76380,95770,95770,61300,78200,27150,76480,78930,78930,61300,78790,76160,78930,28500,27230,95420,78200,78711,28340,27350,28500,61550,28410,28500,95510,27720,22680,78930,27390,27230,95510,27150,27560,27150,61190,78550,27480,78550,27910,27260,27230,28500,78520,14290,27150,78550,76480,50300,27560,28250,76480,76960,78910,27910,76150,50300,76940,27390,76480,76116,27230,95510,78440,27560,27390,76160,14290,27500,27150,27350,76840,61550,27230,76160,78930,95420,61550,14290,61300,27910,95420,61270,28170,28340,28340,78440,28170,78790,76116,27230) AND fami_id='5' AND cate_id='176' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='889' AND wish_id<>'429161' 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='889' 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=195931 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 = 195931 AND W.type_id = 1) OR (W.util_id != 195931 AND W.type_id = 2)) AND (`post_util_id` = 195931 OR `dest_util_id` = 195931) 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 = 195931

  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='889' 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=74517 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 = 74517 AND W.type_id = 1) OR (W.util_id != 74517 AND W.type_id = 2)) AND (`post_util_id` = 74517 OR `dest_util_id` = 74517) 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 = 74517

  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='889' 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=54952 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 = 54952 AND W.type_id = 1) OR (W.util_id != 54952 AND W.type_id = 2)) AND (`post_util_id` = 54952 OR `dest_util_id` = 54952) 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 = 54952

  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='889' 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=86960 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 = 86960 AND W.type_id = 1) OR (W.util_id != 86960 AND W.type_id = 2)) AND (`post_util_id` = 86960 OR `dest_util_id` = 86960) 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 = 86960

  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='889' 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=313392 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 = 313392 AND W.type_id = 1) OR (W.util_id != 313392 AND W.type_id = 2)) AND (`post_util_id` = 313392 OR `dest_util_id` = 313392) 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 = 313392

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

  64. 0.0001

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

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

  68. 0.0001

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

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

  72. 0.0001

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

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

  76. 0.0001

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

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

  80. 0.0001

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

  81. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 889

  82. 0.0008

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

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

Taille variable Globale : 78.9 KB