Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Barnum 3x9

Retour Location Tente reception Location tente reception 42 entre particuliers Location tente reception 42 entre particuliers

Réserver

Ce voisin propose en location à Saint-Étienne (42000)

120€/jour

Prix

120€/jour

-36kgqu'à l'achat

Description de l'annonce

Amplifiez votre événement avec nos spacieux barnums.
Idéaux pour les mariages, les fêtes et les événements en plein air, ces tentes offrent un espace généreux pour accueillir vos invités.
Réservez dès maintenant pour garantir un abri élégant et fonctionnel pour votre prochaine célébration
#tente reception

Autres annonces du voisin

Tout voir
Location tente reception
Location : tente reception

Saint-Étienne 42000

Barnum 3x3
Profil du voisin
Adel G

Saint-Étienne 42000

60€/jr

Louer le barnum
Location tente reception
Location : tente reception

Saint-Étienne 42000

Barnum 3x6
Profil du voisin
Adel G

Saint-Étienne 42000

90€/jr

Louer le barnum
Location chauffage
Location : chauffage

Saint-Étienne 42000

Radiateur
Profil du voisin
Adel G

Saint-Étienne 42000

20€

Louer le chauffage
Location table de reception
Location : table de reception

Saint-Étienne 42000

Manges-debout
Profil du voisin
Adel G

Saint-Étienne 42000

10€/jr

Louer la table

Annonces similaires

Tout voir
Location tente reception
Location : tente reception

Feyzin 69320

Tente de réception
Profil du voisin
Elise R Voisin vérifié

Feyzin 69320

170€

Louer le barnum
Location tente reception
Location : tente reception

Saint-Etienne 42100

Une tonnelle
Profil du voisin
Sylvie P

Saint-Etienne 42100

25€/jr

Louer le barnum
Location tente reception
Location : tente reception

Andrezieux-Bo... 42160

Location chapiteau 5x10m (50m²)
Profil du voisin
Quentin C

Andrezieux-Boutheon 42160

150€/we

Louer le barnum
Location tente reception
Location : tente reception

Saint-Étienne 42000

Barnum 3x3
Profil du voisin
Adel G

Saint-Étienne 42000

60€/jr

Louer le barnum
Location tente reception
Location : tente reception

Chasse-sur-Rh... 38670

Super barnum 3x6 metres
Profil du voisin
Jp S

Chasse-sur-Rhone 38670

180€/we

Louer le barnum
Location tente reception
Location : tente reception

Écotay-l'Olme 42600

Location : matériel de réception
Profil du voisin
Valentin V Voisin vérifié
80% fiable

Écotay-l'Olme 42600

100€

Louer le barnum
80%
Location tente reception
Location : tente reception

Mornant 69440

Tonnelle 3*6
Profil du voisin
Coco P

Mornant 69440

40€/we

Louer le barnum
Location tente reception
Location : tente reception

Lyon 69004

Barnum 3x3
Profil du voisin
Guillaume R Voisin vérifié

Lyon 69004

40€/jr

Louer le barnum
Location tente reception
Location : tente reception

La Tour-en-Ja... 42580

Tonnelle 3x3
Profil du voisin
Arthur G
100% fiable

La Tour-en-Jarez 42580

15€/jr

Louer le barnum
100%
Location tente reception
Location : tente reception

Thurins 69510

Location barnum 5 x 8 m pvc
Profil du voisin
Raphael P Voisin vérifié
100% fiable

Thurins 69510

350€/we

Louer le barnum
100%

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

  3. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'tente-reception' LIMIT 1

  4. 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'

  5. 0

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

  6. 0.0001

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

  7. 0

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

  8. 0

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

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

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

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

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

  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 (110) 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 (227) 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 (176) 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 (79) ORDER BY ssrubr_order ASC

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

  18. 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 (228) 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 (207) 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 (95) ORDER BY ssrubr_order ASC

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

  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 (83) 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 (93) 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 (193) 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 (91) 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 (232) 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 (92) ORDER BY ssrubr_order ASC

  28. 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 = 547370

  29. 0.0001

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

  30. 0.0001

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

  31. 0

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

  32. 0

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

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

  34. 0.0001

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

  35. 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 = '547370'

  36. 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='402296' AND wish_id<>'547370' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

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

  38. 0.0001

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

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

  40. 0.0001

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

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

  43. 0.0001

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

  44. 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='1168' LIMIT 0,1

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

  46. 0.0001

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

  47. 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='858' LIMIT 0,1

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

  49. 0.0001

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

  50. 0

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

  51. 0.0035

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((45.4333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((45.4333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((4.4- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.983639197041 AND ville_latitude_deg<45.882960802959 AND ville_longitude_deg>3.7592128279141 AND ville_longitude_deg<5.0407871720859 HAVING distance <= 50 ORDER BY distance ASC

  52. 0.0051

    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 (42230,42100,42000,42650,42150,42270,42390,42530,42580,42580,42350,42230,42290,42660,42500,42400,42131,42660,42700,42570,42480,42660,42240,42660,42490,42660,42320,43240,42152,42140,42170,42240,42660,42140,42240,42320,42320,42330,42740,42740,42170,42320,42330,43330,42160,42140,42740,42340,42800,42160,42220,42800,43330,42220,42660,42140,42140,42420,42160,42660,42320,43110,42240,43140,42220,42330,43140,42330,42800,42340,42380,42330,42220,42220,42680,42800,43120,43620,42140,42220,42800,42800,42800,42340,43140,42140,42380,42410,42210,42800,42220,42450,69590,43210,69590,42520,42520,42520,42410,43220,42140,69590,42220,69440,42330,69420,42380,42210,42410,69420,07340,07100,42560,42520,43620,42520,42140,42210,69440,69440,69590,42140,42800,43220,42800,42380,43120,07340,69610,42410,42380,43600,42800,42560,69590,42210,42610,42210,42210,42600,42520,07340,42520,42380,42410,42380,42210,07690,69700,42610,69850,07690,69440,69440,42410,42410,07430,43210,07430,69610,42560,07100,69700,43220,43600,07690,42140,42600,42560,69420,42520,43290,07690,69610,38370,38370,69420,69440,69700,07340,42600,69700,42560,42380,42210,43290,69440,07340,42560,07100,69850,38370,42600,69610,42380,07340,69610,38550,42600,43210,07340,42210,07100,42380,07690,42560,07340,69610,43200,43590,38370,42380,38550,43200,69440,42110,38550,69610,69610,69510,42600,69420,42550,43290,43290,42110,42210,07290,69700,42110,42600,42600,07430,38550,69610,43200,42380,38121,69510,69420,42600,07430,07430,69700,42560,07340,69510,07790,38150,07340,69930,38550,38121,69700,42110,42600,42560,38150,42600,07430,42110,69700,42600,43500,38550,07690,43190,69930,43130,69440,42360,07290,43500,38670,63660,43530,38150,07290,69690,42600,42600,69530,42110,43190,38150,07340,69520,69390,07340,07340,07290,07340,69560,69510,69510,69690,69670,43190,43200,42600,38150,38138,26140,07520,42550,69770,42600,07340,43130,07520,42110,38200,69560,69530,38150,69690,42110,63660,69560,38200,38150,07290,38150,42940,07290,69360,26140,07340,69126,42110,69360,42600,42600,69670,43130,63660,38150,07520,38150,69770,07320,42360,07290,69390,63660,69390,43200,38150,69210,43200,69630,63840,63840,69390,69360,42600,42130,43500,38150,69690,42110,42110,07410,07320,42130,69770,38200,07410,38200,07370,69360,42130,69290,42360,69540,26240,43800,38122,69360,69230,42810,69690,38780,07370,69290,63840,69290,38200,26210,69690,69210,42110,38200,43200,07410,69360,69770,26240,26140,42110,69250,43500,42130,38200,38122,07320,43200,07410,42110,26140,38270,43400,42130,69320,42940,43130,69290,69280,69340,69310,69970,43200,26240,07370,69210,42360,38122,43810,69600,43500,38270,43800,69170,69210,43520,07300,07300,42110,42130,42510,38780,42510,69210,69490,07610,69350,69110,63600,38780,42510,07370,42510,26240,38270,38200,26240,69280,43200,63600,26210,07300,69970,07320,42510,07270,07410,07410,43500,38270,42780,42130,26600,43800,69260,07320,42130,07570,69130,69490,69200,69960,42990,38122,69190,42990,63220,26240,26240,43260,69210,69490,69210,69210,69160,63600,42130,43800,26600,43500,26240,63600,69170,69570,42890,69210,07610,26210,43500,69210,07410,26210,69490,43260,63220,69210,07270,38440,07570,63220,26240,43260,26210,69890,26330,69210,43800,07270,43500,38270,63600,38540,38270,42260,38780,69009,69008,69007,69006,69005,69004,69002,69000,69001,69003) AND fami_id='5' AND cate_id='176' AND type_id='1' AND ssrubr_id='889' AND wish_id<>'547370' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

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

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

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

  67. 0.0001

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

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

  69. 0.0001

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

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

  71. 0.0001

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

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

  73. 0.0001

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

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

  75. 0.0001

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

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

  77. 0.0001

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

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

  79. 0.0001

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

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

  81. 0.0001

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

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

  83. 0.0001

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

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

  85. 0.0001

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

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

  87. 0.0001

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

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

  89. 0.0001

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

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

  91. 0.0001

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

  92. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 889

  93. 0.0008

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

  94. 0

    SELECT count(*) as nbwish FROM wish

  95. 0.0475

    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

95 requetes sql en 0.0659

Taille variable Globale : 78.97 KB