Indiquer un code postal ou une ville Indiquer un code postal

Poster une annonce

Se connecter S'inscrire

i18n

Location barnum 32m2

Location Tente reception

Réserver

Ce voisin propose en location à Essarts-le-Roi (78690)

150€/weekend

Cécilia . Paiement activé

1 annonce

Prix

150€/weekend

-36kgqu'à l'achat

Description de l'annonce

Je loue un barnum de 32m2 avec les caractéristiques suivantes :
- Tente barnum tonnelle de réception grande taille dim. 7,98L x 3,92l x 2,8H m
- Idéal pour organiser une fête type anniversaire, mariage, baptême, etc...
- Bâches de toit et latérales en polyéthylène haute densité imperméable et anti-UV
- Système optimal de fixation des bâches à via cordons élastiques et oeillets
- 8 grandes fenêtres avec motifs carreaux
- 2 grandes portes avant et arrière à fermeture déroulante avec zip et boucle fermoir
- Structure intégralement en acier #tente reception

Annonces similaires

Tout voir

4,5/5 résa

Il y a + de 30j

Barnum / Tente de réception 3x6m

60€/jour

5/5 Montesson

4,5/5 résa

Il y a + de 30j

Barnum / Tente de réception 4x6m

70€/jour

5/5 Montesson

4,5/5 résa

Il y a + de 30j

Barnum / Tente de reception 4x8

80€/jour

5/5 Montesson

Il y a + de 30j

Location tente d'événements/réception

50€/jour

Epinay-sur-Seine

Il y a + de 30j

Location tente de réception 3m×3m

50€/jour

Épinay-sur-Seine

Il y a + de 30j

Barnum 4x8m

150€/jour

Cerny

Il y a + de 30j

Location barnum 3x6 ( tente de réception

100€/jour

Villiers-le-Bel

Il y a + de 30j

Tonnelle pliante 3x3 imperméable

20€/jour

Eragny

Il y a + de 30j

Location barnum

39€/jour

Saint-Ouen-l'Aumone

Il y a + de 30j

Location de tente

150€/jour

Cergy

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

Poster une annonce

Location entre voisins

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Autre chose ?

Contactez-nous

Script : /wiiz-annonce.php

0.0001
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
0.0002
SHOW TABLES LIKE 'pays'
0.0002
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
0.0002
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
0.0001
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
0.0004
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
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='637047'
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'tente-reception' LIMIT 1
0.0001
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='176'
0
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='505531' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 505531
0.0001
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 637047
0
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=889 LIMIT 1
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='637047'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='637047' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
0.0001
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 505531 AND util_tel != ''
0
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=505531 LIMIT 1
0.0003
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 505531 AND W.type_id = 1) OR (W.util_id <> 505531 AND W.type_id = 2)) AND (M.post_util_id = 505531 OR M.dest_util_id = 505531) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='505531' AND note_visu IN (1,3,4)
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 = '637047'
0.0001
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='505531' AND wish_id<>'637047' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78690'
0.0071
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.75*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.75*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.88333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.300339197041 AND ville_latitude_deg<49.199660802959 AND ville_longitude_deg>1.2013427806797 AND ville_longitude_deg<2.5653172193203 HAVING distance <= 50 ORDER BY distance ASC
0.0059
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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 ('78690','78310','78310','78490','78690','78490','78760','78490','78490','78320','78610','78610','78320','78990','78490','78490','78320','78610','78640','78640','78640','78490','78490','78370','78125','78720','78190','78610','78490','78640','78490','78470','78650','78720','78940','78340','78720','78770','78490','78720','78180','78650','78390','78850','78120','78960','78890','78125','78460','78940','78470','78770','78450','78460','78450','78810','78114','78280','78770','78720','78330','91470','78770','78810','78910','78210','78860','78124','78770','78121','78590','78120','78125','78770','78910','78470','78113','78113','78950','78117','78910','91470','91470','78580','78124','78550','78117','78770','78830','78910','78590','91190','78113','78910','78125','78870','91470','78530','78350','78125','78830','78120','78125','78620','78580','91190','78580','78000','78125','78790','78240','78150','78125','91400','78160','78550','78910','78150','78550','91190','91940','78113','78630','78580','78730','78730','78125','78790','78790','78240','78112','78550','78113','78930','78580','78126','78730','78630','78750','78350','28230','91400','78125','78550','28230','78430','78220','78113','91440','78125','91470','28410','78930','91940','78790','78100','78730','78920','78910','78290','78380','78170','28210','91640','78410','78410','78790','78560','91640','78140','91400','78550','91940','78680','91470','78230','78790','78930','91410','28210','92430','92420','91430','28410','78910','78790','78300','78670','78670','92370','78110','28210','28130','91640','92410','78410','78410','92380','78410','28410','92310','78130','78200','78930','78930','91530','91570','28410','78400','91430','28130','91640','78910','78790','78955','28320','78970','28210','78730','28210','78540','91530','78930','78660','78440','78111','91680','28320','28410','78930','91410','78660','92210','78790','91410','78200','91140','28560','28260','28210','28410','78360','78660','28410','78480','78200','78711','78790','92190','92360','91120','78510','78200','78600','28700','91140','92500','28130','78260','28320','28700','78250','78820','78130','28560','91620','28210','28210','78250','78200','91530','28500','91370','92290','78520','78570','78200','78440','91530','78980','91410','28130','92350','92100','28210','92000','91680','92140','28410','91160','78200','92800','78980','92150','78420','78440','78660','91460','28130','92130','91160','28210','91650','91650','78570','28320','28500','28410','91300','91410','78200','92260','92330','78980','78600','28320','28210','28130','28130','78250','78800','78250','92320','78200','28700','91650','78740','91620','78740','28700','78700','78200','78200','28130','78660','95180','78440','92160','28260','78250','91340','91520','91310','91160','28260','95000','78780','91310','91310','92220','78200','91380','28500','91580','91160','91580','78500','28130','92240','78660','95450','92400','78250','92250','95280','78440','28210','91410','91180','91410','92200','94260','95870','95450','92340','92170','28210','78520','78440','91310','28500','78660','28260','95000','91700','78200','95530','92120','28260','92700','95800','91410','91730','91910','91290','78980','28260','78440','28500','91320','28130','91790','91360','28700','28260','94240','94233','94234','94235','94231','94237','94238','94239','28570','94236','94232','94230','28500','91240','78710','28210','95490','28700','94110','78440','91420','78440','95610','28260','92270','92300','91290','95450','91410','91630','94250','78980','27540','95370','28130','94150','78520','95000','94550','91360','28500','78440','28700','92600','95220','91580','95650','91630','28130','91870','28700','92110','28700','95240','28260','78520','95100','91220','91220','95450','91730','28700','95450','91600','91390','28500','91700','78270','28210','91150','28700','78440','78980','91550','28500','28300','91730','91410','27640','94800','91630','75008','75007','75006','75005','75004','75003','75002','75000','75001','75009','75010','75020','75019','75018','75017','75016','75015','75014','75013','75012','75011','75116','28260','95510','95110','95480','94270','91410','91580','78270','95130','95510','27530','28700','92230','94320','91630','95510','95650','93400','95300','28300','78980','28170','28700','95450','95450','28210','95450','28500','28700','94200','94205','91260','95310','78270','95250','95780','95520','27730','91780','91780','95450','91700','91630','95130','27780','91170','28300','94310','94390','95210','95218','28500','28100','95650','95650','28300','91780','94400','28500','91200','28700','91150','95120','93800','27710','91510','91510','91350','78270','95300','78840','78270','28700','93450','92390','95450','28520','28520','28700','95420','78270','27750','27650','94600','94290','78270','28700','91580','78840','94480','95450','95650','94140','91270','91070','95420','95420','27730','94220','27810','91210','95880','95150','78270','95550','95510','28300','95320','27220','95230','28170','91850','94160','93200','93210','95780','91150','78270','95600','28300','28170','95510','93310','91150','94700','91130','91000','28500','91080','93430','95450','95390','28700','27640','27730','95430','95450','28700','91770','91810','28700','95450','28500','93300','93120','28700','27220','93170','27120','95580','95580','95740','95780','93500','27220','28300','91580','28630','94190','95680','78270','95830','91560','95360','94300','91710','27650','95170','95830','91230','91740','95300','91760','78270','28700','95540','91740','28700','28300','93100','78270','28170','78270','27620','27220','95510','28630','91090','28700','28700','95640','95450','95420','94410','94460','28700','27640','93380','95840','27650','28500','93240','27120','95410','95640','95640','95420','94000','93230','93260','95810','28300','28500','28700','27220','95300','28300','91450','27620','91540','95160','28300','91590','27220','95420','95710','94340','27120','27620','95840','28700','95560','91090','91000','91150','28000','95430','95630','95420','28500','27120','27220','28300','91540','27120','94380','94450','28500','93350','91590','27630','95810','95420','28500','78270','91590','95750','28700','91610','27320','28310','27220','93000','91450','28310','91590','27220','93440','94130','95350','28500','95640','95420','27220','95570','95350','93130','27320','28500','91540','91540','95760','95420','28300','91740','28150','94120','27220','91590','91330','91690','94210','94340','95640','94100','91100','95330','27120','91800','27770','93110','93140','95140','95710','95810','27120','95200','95400','91690','91930','28500','93150','93700','28300','28630','95420','28360','94470','95810','95710','28380','91250','95750','94170','28310','95560','28630','91590','91880','28110','94430','28150','95400','27120','95570','95690','95640','27120','95500','91690','91590','27220','94500','28190','91860','91750','27220','27120','95440','91250','91100','95640','95420','95590','27200','95810','94360','28600','28630','95460','95560','95620','93250','28630','28170','91280','94380','94370','95570','28170','94440','95690','28270','27120','28630','91150','27620','91690','95290','27220','93360','60240','60240','91150','91250','28150','91800','60240','60240','27220','27630','95690','91150','91480','91690','28150','28300','95560','28170','93330','28350','95500','94440','60240','27120','91670','27630','94490','28150','94880','94880','27950','28270','95690','28190','91750','91150','91590','27120','94520','94520','93320','93340','28300','27630','95420','91830','91250','91820','95640','27320','94350','91150','27630','93220','27950','27120','27320','95720','95810') AND fami_id='5' AND cate_id='176' AND type_id='1' AND ssrubr_id='889' AND wish_id<>'637047' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
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
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=311956 AND note_visu IN (1,3,4)
0.0007
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 311956 AND W.type_id = 1) OR (W.util_id <> 311956 AND W.type_id = 2)) AND (M.post_util_id = 311956 OR M.dest_util_id = 311956) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 311956
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
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 311956
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
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 311956
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
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=544020 AND note_visu IN (1,3,4)
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 544020 AND W.type_id = 1) OR (W.util_id <> 544020 AND W.type_id = 2)) AND (M.post_util_id = 544020 OR M.dest_util_id = 544020) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 544020
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
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 544020
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
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=538532 AND note_visu IN (1,3,4)
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 538532 AND W.type_id = 1) OR (W.util_id <> 538532 AND W.type_id = 2)) AND (M.post_util_id = 538532 OR M.dest_util_id = 538532) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 538532
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
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=44634 AND note_visu IN (1,3,4)
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 44634 AND W.type_id = 1) OR (W.util_id <> 44634 AND W.type_id = 2)) AND (M.post_util_id = 44634 OR M.dest_util_id = 44634) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 44634
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
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=541068 AND note_visu IN (1,3,4)
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 541068 AND W.type_id = 1) OR (W.util_id <> 541068 AND W.type_id = 2)) AND (M.post_util_id = 541068 OR M.dest_util_id = 541068) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 541068
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
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=539020 AND note_visu IN (1,3,4)
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 539020 AND W.type_id = 1) OR (W.util_id <> 539020 AND W.type_id = 2)) AND (M.post_util_id = 539020 OR M.dest_util_id = 539020) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 539020
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
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=519389 AND note_visu IN (1,3,4)
0.0001
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 519389 AND W.type_id = 1) OR (W.util_id <> 519389 AND W.type_id = 2)) AND (M.post_util_id = 519389 OR M.dest_util_id = 519389) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 519389
0
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 889
0
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
0.001
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
0.0247
SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
0.0188
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

83 requetes sql en 0.0687

Taille variable Globale : 81.92 KB