Indiquer un code postal ou une ville Indiquer un code postal

Poster une annonce

Se connecter S'inscrire

i18n

Chapiteau/tonnelle/barnum (2 jours)

Location Tente reception

Discuter

Ce voisin propose en location à Biache-Saint-Vaast (62118)

120€

Benoit A.

1 annonce

Prix

120€

-36kgqu'à l'achat

Description de l'annonce

Je vous propose ma tonnelle de qualité professionnelle en PVC
• Dimensions : 5m x 8m
• Capacité : Peut accueillir jusqu'à 50 personnes confortablement.
• Matériaux : PVC robuste et résistant aux intempéries
• Structure : Armature en acier galvanisé pour une robustesse et stabilité optimales.
• Inclus : Service de montage et démontage pour votre confort
• Idéale pour : Mariages, fêtes, réceptions, salons, et tout autre événement nécessitant un espace couvert #tente reception

Annonces similaires

Tout voir

Il y a + de 30j

Location tonnelle 9x3

50€/jour

Wasquehal

5/5 résa

Il y a + de 30j

Tonnelle de 5X10m soit 50m2

160€/weekend

5/5 Nieppe

4,2/5 résa

Il y a + de 30j

Tonnelle 6 x 8m

100€/jour

Bachy

Il y a + de 30j

Tonelle 3x3 m

30€/jour

Lille

Il y a + de 30j

Chapiteau/tonnelle/barnum

180€/weekend

Biache-Saint-Vaast

4,6/5 résa

Il y a + de 30j

Location tonnelle 3*6 mètres

50€/jour

5/5 Ronchin

4,6/5 résa

Il y a + de 30j

Location tonnelle 3*3 mètres

30€/jour

5/5 Ronchin

Il y a + de 30j

Loue Barnum 5 x 8 m installé chez vous !

175€/weekend

Bethune

Il y a + de 30j

Barnum 4x8m

80€/jour

Arras

Il y a + de 30j

Location barnum 3 m par 4,5 m

30€/jour

Lille

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.0003
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='629466'
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.0001
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='62'
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='515467' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 515467
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 = 629466
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='629466'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='629466' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 515467 AND util_tel != ''
0
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=515467 LIMIT 1
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 = 515467 AND W.type_id = 1) OR (W.util_id <> 515467 AND W.type_id = 2)) AND (M.post_util_id = 515467 OR M.dest_util_id = 515467) 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='515467' 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 = '629466'
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='515467' AND wish_id<>'629466' 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='62118'
0.0204
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.2976*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.2976*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.89639- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.847939197041 AND ville_latitude_deg<50.747260802959 AND ville_longitude_deg>2.1924679790384 AND ville_longitude_deg<3.6003120209616 HAVING distance <= 50 ORDER BY distance ASC
0.0066
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 ('62118','62118','62118','62118','62118','62223','62118','62580','62223','62490','62118','62156','62580','62128','62128','62580','62156','62580','62156','62217','62580','62223','62156','62156','62128','62490','62580','62128','62490','62580','62217','62580','62156','62000','62128','62223','62128','62490','62223','62217','62580','62128','62223','62117','62320','62580','62320','62320','62320','62182','62217','62217','62490','62490','62217','62490','62223','62156','59259','62223','62128','62128','62580','62490','62860','62112','62175','59553','62182','62680','62182','62112','62182','59151','62860','62210','62128','59552','59169','62128','62128','62000','62128','62860','62860','62420','62580','59151','62430','62110','62175','62173','59552','62217','62121','62153','62161','62161','62860','62860','62175','59500','62300','59553','59553','59151','62860','62950','59169','62128','62860','62175','62144','62161','62740','62121','62221','62218','62640','62173','59169','62121','62300','62970','59128','62175','62153','62860','62800','62860','62860','62119','62860','62161','62123','62860','62121','62123','59187','62159','62173','62143','62159','62144','62440','62710','59950','59151','62860','59450','62173','62123','62141','59151','62144','62860','59119','62159','62144','59169','62116','62124','62123','59286','62750','62121','62121','62880','62880','62880','62116','62123','62123','62880','59287','62144','62160','59169','62790','62116','62121','59265','59162','62690','62160','62590','62123','62123','59265','62121','62123','59182','59287','59283','62116','62450','62450','62123','62147','62690','62124','62860','62450','59234','62147','62160','62860','62690','62111','62124','62123','62450','62410','62172','62124','62123','62530','62410','59265','62220','59194','59194','62410','62147','59167','59283','62123','59234','62121','62123','62690','62530','62450','59182','62690','59554','62450','59247','62810','62690','59176','62820','62147','62450','62690','62410','62124','59554','62121','62450','59400','62114','59234','62147','59261','62123','62690','62116','59247','59239','59265','62670','59176','62980','62810','62111','62450','59265','62450','62124','62810','59400','62147','62690','62450','59165','62980','80300','62530','59221','59185','62138','59268','62116','62450','62158','59247','62810','62111','62124','62690','62111','59146','62158','62138','62150','80300','59112','59148','62690','59246','59554','59239','59133','59252','62810','59580','59310','62690','59267','62149','62138','62111','62124','59580','80300','59267','59554','62158','62138','59554','62450','62124','59133','62810','62150','62149','62690','62150','59267','62620','59551','62111','62158','59490','59496','62290','59112','59252','62690','62690','62113','62113','62450','62149','59251','59870','59252','59496','59551','62124','62690','62450','59147','59159','62810','62124','59159','80300','59480','59554','62147','59235','59161','59710','62138','59310','62111','62149','62450','62760','62158','80300','59111','62113','59400','80360','62150','62620','59870','62124','59295','59295','59400','59184','59272','80360','59274','62810','62810','62124','62127','62124','59141','59161','59147','59490','62111','62620','62660','59159','59172','62150','59147','62760','62131','80300','59710','59215','62810','62620','62940','59231','59281','62131','62131','62127','59870','59710','80360','62450','80360','80300','62127','80360','59179','59113','80360','62810','59310','62127','59111','59136','59134','59870','62111','80560','80360','59400','59111','59141','59134','62158','59480','62127','62127','62149','59241','59310','80560','62810','62127','62760','80360','59161','59141','62196','59171','62450','80300','59263','62150','80300','80360','62840','59242','59172','80560','59710','80560','80360','62158','80360','62810','59161','62232','80360','62760','59231','62760','62760','62810','62127','59134','62150','80560','59175','62810','62150','59870','59171','62700','80300','59400','62150','62400','62232','59400','62127','59175','59156','80240','59111','80600','62400','59124','59242','59293','62127','62760','80300','59273','62840','80300','62232','62232','62810','59139','62810','59231','62199','59310','80360','80560','62136','80560','80300','62127','59258','59870','59400','59266','59139','80300','59134','62810','59310','80560','59870','62122','59249','62460','59258','62460','59211','62760','59249','80122','59155','59277','59400','62400','80300','62270','62127','59320','80240','62136','59171','80560','59258','59310','59320','59178','62810','59297','59282','59282','80560','59242','62136','80300','80300','62127','59220','80240','80200','59266','59296','62920','62460','62540','62920','80360','80300','59310','62810','80760','59230','62127','59830','59810','59217','59320','80360','62130','62122','62127','80300','59134','59320','59273','59178','59320','59320','62760','80240','80560','80600','62470','62232','62810','62760','59320','59266','59400','59217','80560','80560','59255','59129','59230','80560','62270','80300','59120','62130','59135','59790','62760','59310','62470','59830','62130','59188','59178','62130','80300','80360','62760','59262','59127','80740','59220','62540','62130','80360','59310','59690','59217','80560','80560','59198','80300','59320','59830','80600','62760','80300','62270','80360','59320','62270','59830','80560','80240','62270','62130','80112','62260','62130','62920','62550','59188','80300','59157','62130','59121','59226','59217','59220','80240','80240','62157','59830','62840','62350','62136','59195','07611','80810','62760','80600','80200','02420','62810','59260','59178','80200','62260','80200','62130','62550','59292','59135','62130','62270','59830','80560','59191','80200','59157','59280','59000','59800','59160','59350','59777','59188','59224','80240','59840','59121','59940','62840','02420','59160','80560','62760','59195','80340','62760','59214','62550','62550','59830','59253','02420','80740','80300','59152','59152','80560','59227','59227','07624','62151','62840','59127','59226','59130','62130','62130','59780','62550','59224','59152','80300','80200','62350','59127','07610','62270','62550','59191','80200','59494','80340','62350','59230','59110','80240','80600','62130','59191','59370','59142','62270','62270','59540','80300','80240','59127','80340','80300','59840','80200','80300','62130','02420','62350','02420','59350','59840','59233','59660','59125','02420','80600','62550','62260','59227','62190','62130','80600','59780','80240','07623','59174','80300','59152','07502','80600','62130','80240','59540','59494','80200','80200','02420','59940','07618','62350','80340','80340','80200','59510','62130','62130','80600','80600','80200','59294','80600','59590','62130','80300','07621','62550','62270','59930','59280','80300','59193','59213','80300','62270','59225','62550','59225','59700','62350','80200','80340','62130','80560','59127','62550','80240','80300','59237','59158','62190','59410','62270','07620','80340','59730','07504','62270','07620','02420','59520','62550','59271','07522','62130','02110','80980','62260','80560','59192','62550','80240','62190','62190','62190','59269','59300','59158','59730','59213','59540','59118','80560','80560','59780','80800','02490','80600','62190','80200','07506','07620','07620','80300','62130','59510','59940','62550','59116','59730','07522','59170','59290','80600','02490','07620','59230','80340','59850','59300','59390','59158','80113','62190','62120','59540','62350','62130','59230','80340','59181','62130','02420','62134','59213','59213','59300','02490','07522','07783','80630','80340','62550','02110','80800','80240','62270','62270','62330','02420','07500','59980','80600','80200','80200','62130','02420','59980','07522','59238','59730','80200','80240','59860','62270','62130','62130','59491','59493','59650','59655','62134','80260','07620','07622','80200','80800','80200','59269','80113','59730','80200','59158','59236','07500','07501','59199','62550','59770','62134','62190','59390','80200','59910','59213','59213','59880','59980','59980','80600','62270','62270','62134','07520','80340','59890','80240','80600','80800','80260','80260','59390','80200','80800','80200','62120','62270','62130','59390','07641','62330','59269','59990','62130','07782','62134','59360','59420','80340','62960','62960','59199','80800','80200','02110','62120','80200','80260','59980','80121','02420','80600','62270','80240','80600','62270','80260','62134','59232','80200','07503','80800','80200','59890','62120','80260','59100','07730','59730','62960','80800','59990','80600','62390','62130','62130','62134','59530','59990','02110','02420','07500','80800','80800','07642','07521','02420','80260','80340','07640','59270','59970','59530','59278','80260','80200','62270','62120','62134','62130','59189','80260','02110','59115','80260','02490','62390','62270','59270','80320','59200','80600','62120','62134') AND fami_id='5' AND cate_id='176' AND type_id='1' AND ssrubr_id='889' AND wish_id<>'629466' 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=490749 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 = 490749 AND W.type_id = 1) OR (W.util_id <> 490749 AND W.type_id = 2)) AND (M.post_util_id = 490749 OR M.dest_util_id = 490749) 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 = 490749
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=528939 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 = 528939 AND W.type_id = 1) OR (W.util_id <> 528939 AND W.type_id = 2)) AND (M.post_util_id = 528939 OR M.dest_util_id = 528939) 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 = 528939
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=461938 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 = 461938 AND W.type_id = 1) OR (W.util_id <> 461938 AND W.type_id = 2)) AND (M.post_util_id = 461938 OR M.dest_util_id = 461938) 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 = 461938
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=528042 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 = 528042 AND W.type_id = 1) OR (W.util_id <> 528042 AND W.type_id = 2)) AND (M.post_util_id = 528042 OR M.dest_util_id = 528042) 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 = 528042
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=516715 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 = 516715 AND W.type_id = 1) OR (W.util_id <> 516715 AND W.type_id = 2)) AND (M.post_util_id = 516715 OR M.dest_util_id = 516715) 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 = 516715
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=339897 AND note_visu IN (1,3,4)
0.0005
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 = 339897 AND W.type_id = 1) OR (W.util_id <> 339897 AND W.type_id = 2)) AND (M.post_util_id = 339897 OR M.dest_util_id = 339897) 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 = 339897
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 = 339897
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=487258 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 = 487258 AND W.type_id = 1) OR (W.util_id <> 487258 AND W.type_id = 2)) AND (M.post_util_id = 487258 OR M.dest_util_id = 487258) 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 = 487258
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=364058 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 = 364058 AND W.type_id = 1) OR (W.util_id <> 364058 AND W.type_id = 2)) AND (M.post_util_id = 364058 OR M.dest_util_id = 364058) 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 = 364058
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=441713 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 = 441713 AND W.type_id = 1) OR (W.util_id <> 441713 AND W.type_id = 2)) AND (M.post_util_id = 441713 OR M.dest_util_id = 441713) 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 = 441713
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.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
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.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
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.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
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
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
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 (95) 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 (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.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
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
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
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
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.0324
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.0249
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

87 requetes sql en 0.0973

Taille variable Globale : 83.87 KB