Indiquer un code postal ou une ville Indiquer un code postal

Poster une annonce

Se connecter S'inscrire

i18n

Sono puissante pour soirée

Location Sono

Réserver

Ce voisin propose en location à L'Haÿ-les-Roses (94240)

50€/jour

Nicolas G.

3 annonces

Prix

50€/jour

-50kgqu'à l'achat

2x moins cher qu'en magasin

Description de l'annonce

Bonjour à tous
Le monde se déconfine et les gens reprennent progressivement les soirées :
Je loue donc du matériel pour vos soirées de 10 à 200 personnes.
Je propose des tarifs préférentiels par rapport aux pros.
Le matériel proposé est :
Sono :
- une enceinte HK PRO 15 400W : 50€/jour
- un caisson de basses 1600W : 50€/jour
Du matériel lumineux est également disponible
Lumière :
- une barre de lumières montée sur trépied : 35€/jour
Chauvet GigBar2
- un stroboscope puissant : 10€/jour
- une machine à fumée : 10€/jour
Des packs de produits peuvent être pris afin de profiter de réductions .
L'ensemble des produits peut être loué pour 120€ !
Je propose également la livraison et l'installation du matériel pour un supplément à établir en fonction de la distance.
En conclusion, des devis personnalisés peuvent être réalisés en fonction de vos besoins. #sono

Autres annonces du voisin

Tout voir

Il y a + de 30j

Cours de Physique, Chimie et SVT.

15€/heure

L'Haÿ-les-Roses

Il y a + de 30j

Jeu de lumière pro sur trépied

35€/jour

L'Haÿ-les-Roses

Annonces similaires

Tout voir

5/5 résa

Il y a + de 30j

JBL PartyBox Stage 320 • Sono soirée dan

50€/jour

5/5 Paris

5/5 résa

Il y a + de 30j

Location matériel Sono (Evolve 50)

150€/jour

Ezanville

5/5 résa

Il y a + de 30j

Sonorisation

60€/jour

Montreuil

4,2/5 résa

Il y a + de 30j

Location sono, sonorisation, Contrôleur

30€/jour

Bezons

4,3/5 résa

Il y a + de 30j

Location enceintes professionnelles 3200

110€/jour

Versailles

Il y a + de 30j

Prêt enceinte madison

50€/jour

Clamart

Il y a + de 30j

Boomtone dj mobile 15 uhf

70€/jour

Colombes

4,2/5 résa

Il y a + de 30j

Système de sonorisation 800wRMS/1600w

95€/jour

Bois-d'Arcy

Il y a + de 30j

Soirée musical

-- €

Chatou

Il y a + de 30j

Pack Elokance 800

90€/jour

Paris

Louer une sono entre particuliers ou proposer une sono 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.0002
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
0.0006
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='379939'
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'sono' 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='94'
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='196993' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 196993
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 = 379939
0
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=790 LIMIT 1
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='379939'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='379939' 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` = 196993 AND util_tel != ''
0
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=196993 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 = 196993 AND W.type_id = 1) OR (W.util_id <> 196993 AND W.type_id = 2)) AND (M.post_util_id = 196993 OR M.dest_util_id = 196993) 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='196993' 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 = '379939'
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='196993' AND wish_id<>'379939' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
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='1024' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=196993 AND note_visu IN (1,3,4)
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 196993
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='667' 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 = 196993
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='94240'
0.0064
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.333639197041 AND ville_latitude_deg<49.232960802959 AND ville_longitude_deg>1.650890395336 AND ville_longitude_deg<3.015769604664 HAVING distance <= 50 ORDER BY distance ASC
0.0022
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 ('94238','94239','94237','94236','94235','94234','94233','94232','94231','94240','94230','92340','94110','94550','94800','92220','92330','92260','94250','94150','94260','92120','94320','92320','94270','92160','92240','92350','94400','92290','92140','94200','94205','91320','92170','94310','94390','92130','91370','94140','94600','91300','94220','92360','92190','94700','91550','92100','94160','94290','75000','75013','75014','75016','75018','75019','75020','75116','75015','75012','75011','75010','75002','75003','75004','75005','75017','75006','75007','75008','75001','75009','91200','91420','91570','91160','91380','91120','94480','94000','94410','92370','91430','94190','94300','94460','92310','94340','91160','92210','93170','91140','91270','78140','94380','91430','91560','92410','91260','92800','92150','93100','93310','92200','91160','94130','94450','78350','94100','94210','94340','78220','91230','91210','92380','92420','92430','91360','93400','91360','91600','91390','92110','94120','93230','93260','91140','91400','91170','91160','92300','94430','93500','94500','94470','92400','94170','91330','92250','93110','91400','94360','92600','94370','94380','78530','78350','78000','93130','92500','91700','91350','93300','93120','91440','91800','78170','93000','91620','92270','94490','94880','94880','78150','91000','91130','92700','92000','93140','78117','93360','93330','91190','94440','93250','91620','91940','92390','93450','91700','93200','93210','94350','78150','94440','91240','92230','91700','91310','91450','78290','78380','91310','91310','78400','91860','94420','91190','78800','93350','91940','78117','91460','94510','78430','93220','94520','94520','91800','91940','91190','78420','91220','91220','93160','93800','94440','93340','93320','93700','93150','95870','91000','91090','91070','93240','91080','91450','78560','93460','93430','91310','95100','93440','91480','78210','78280','78870','77170','77340','78360','91640','91480','78114','95880','95360','78110','91400','78160','93380','78470','91250','95210','95218','78590','77420','77184','78330','78960','95140','91180','95110','91090','78750','93370','78230','77380','77185','78590','78470','77150','78500','91250','78620','95500','93390','93190','78180','93270','91280','95170','95410','95230','78100','77500','78112','91680','77150','78460','91290','95120','78600','93600','78600','91640','77127','91290','95400','91100','95530','77186','78390','77680','95130','91470','93470','77181','91470','77170','91470','91250','95500','91340','91520','91100','78450','93410','78470','95160','91630','91630','91810','95580','95350','95580','95240','78860','77200','95200','95600','95400','91640','91680','78190','77330','91630','91540','77177','95370','91630','77360','77183','77090','93420','95130','91540','91540','91470','77181','78240','91470','77173','78460','91640','78340','95350','95500','91710','78720','93290','95680','95440','77166','91540','91630','95390','95500','91650','78240','77270','78300','95320','77600','78450','77166','77135','77550','95720','95220','91650','91830','91250','78720','77400','91790','91530','78320','77410','77164','95700','95190','95250','91770','95330','77600','77600','95460','77400','78720','78700','77176','78990','91650','78260','78370','78320','77400','78810','95720','95480','78955','91750','91730','78830','91610','78320','95150','95550','77550','77600','77400','78570','78630','91470','91760','77111','95570','95570','91850','95570','77220','77170','78720','91910','91830','91730','91510','91510','95560','95720','77400','95840','77176','95380','77290','77240','91530','78310','78670','78670','77550','78830','78810','78310','77600','95190','91730','91750','95740','91580','77400','78780','77600','91530','77240','95610','78570','77400','78121','78850','77220','91590','95560','95560','77550','77410','78760','77410','77111','77240','77310','77144','95720','78640','95380','78640','77220','95840','95850','95000','77990','77390','77410','78690','95190','91410','77310','78720','78540','95540','78510','91580','77220','95380','77950','77220','78640','78690','77990','91530','95380','91590','95560','95570','95270','95590','77144','77700','95310','95380','91580','78630','77410','77410','77700','95430','91750','91580','78580','78480','95270','91590','95000','95280','78730','78730','91580','78490','95300','77310','77290','78610','77950','77174','78640','95850','77390','95430','95630','77410','77350','77950','78650','77450','77390','91590','91590','77950','95270','78580','91590','77450','95490','77230','78490','78490','77350','91410','95670','95000','77230','78130','78920','91580','95470','95300','77700','78125','77390','78124','91890','77230','77230','77350','95270','95270','91410','95180','78120','77700','78124','95270','95760','77700','78610','77610','77610','77390','77174','78490','78490','95470','91840','77410','95800','77930','78650','77000','77000','77230','95520','91590','77610','77190','95590','91590','78740','95270','77950','95470','95270','95650','77450','77410','78410','77930','77930','77410','95270','95290','78490','78490','77390','78730','78580','95620','95300','78740','77230','78770','77450','91150','91490','78580','77230','95650','77230','95470','95650','77190','91820','77450','78130','77450','77930','95270','95270','78770','77580','91880','95590','95270','78610','91820','78126','77450','77230','95260','78490','95300','91410','77230','77950','95260','77000','78490','77610','95660','78770','77860','95450','77450','78730','78120','60128','91870','77410','77930','78770','78410','77165','78250','78120','77390','91150','77000','91410','78250','91490','77390','78770','91490','77610','77390','77930','95690','77860','91720','77165','77165','95450','77230','78410','77720','77115','77390','77165','78250','78410','77610','78410','78250','78730','95340','60560','95690','91150','95650','95650','78770','77115','60260','78490','78940','60520','77610','77390','95810','60128','60580','77630','78250','95810','95450','77280','78680','77230','78610','91410','77860','77100','91150','77580','77580','77630','77390','95690','78660','95820','60820','95340','77163','77124','78820','60330','91720','77580','78890','77590','78580','77720','91410','91150','95690','78770','95450','60230','77163','77124','77100','77230','95340','60950','91780','91780','95830','91490','60520','78125','78940','77720','77165','95450','78970','78930','95810','77163','77580','77820','78490','77390','95810','78125','95450','78910','77590','95450','95830','91720','77630','78910','60530','60520','78930','77100','91150','78440','78125','77122','77124','60270','77720','78250','91150','60330','95810','77720','77540','91490','91720','77580','78790','78790','91410','77540','77124','95450','91410','78910','78125','77590','78440','78440','77470','60530','60460','95450','77178','77515','78790','77515','77580','91410','77820','78440','60530','78910','78660','78440','95640','91150','78930','77580','77720','78440','60540','60540','78660','95450','77580','60950','77178','91410','60500','91150','60330','91720','91780','60500','77540','95810','95450','77540','78125','77910','78440','78440','77123','78910','77910','95640','95640','95450','77131','77165','77165','77920','77470','95640','78660','91150','60530','91690','91720','60530','77470','60340','91150','78910','95810','60340','60300','60300','60950','77470','78660','78660','60540','95450','91150','77470','78930','77139','77850','78550','77515','78950','60460','60740','60110','91690','78113','95450','60330','77720','95640','95640','60540','78440','77123','78520','78113','78930','78930','78790','77820','78930','78125','95640','91690','78200','78711','28700','78125','77580','60300','60300','95640','60110','91150','60300','78790','77470','77540','78660') AND fami_id='5' AND cate_id='176' AND type_id='1' AND ssrubr_id='790' AND wish_id<>'379939' 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='790' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=538585 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 = 538585 AND W.type_id = 1) OR (W.util_id <> 538585 AND W.type_id = 2)) AND (M.post_util_id = 538585 OR M.dest_util_id = 538585) 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 = 538585
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='790' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=543265 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 = 543265 AND W.type_id = 1) OR (W.util_id <> 543265 AND W.type_id = 2)) AND (M.post_util_id = 543265 OR M.dest_util_id = 543265) 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 = 543265
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='790' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=506637 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 = 506637 AND W.type_id = 1) OR (W.util_id <> 506637 AND W.type_id = 2)) AND (M.post_util_id = 506637 OR M.dest_util_id = 506637) 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 = 506637
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='790' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=461994 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 = 461994 AND W.type_id = 1) OR (W.util_id <> 461994 AND W.type_id = 2)) AND (M.post_util_id = 461994 OR M.dest_util_id = 461994) 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 = 461994
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='790' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=447850 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 = 447850 AND W.type_id = 1) OR (W.util_id <> 447850 AND W.type_id = 2)) AND (M.post_util_id = 447850 OR M.dest_util_id = 447850) 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 = 447850
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='790' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=66837 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 = 66837 AND W.type_id = 1) OR (W.util_id <> 66837 AND W.type_id = 2)) AND (M.post_util_id = 66837 OR M.dest_util_id = 66837) 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 = 66837
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='790' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=418405 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 = 418405 AND W.type_id = 1) OR (W.util_id <> 418405 AND W.type_id = 2)) AND (M.post_util_id = 418405 OR M.dest_util_id = 418405) 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 = 418405
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='790' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=370960 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 = 370960 AND W.type_id = 1) OR (W.util_id <> 370960 AND W.type_id = 2)) AND (M.post_util_id = 370960 OR M.dest_util_id = 370960) 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 = 370960
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='790' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=358594 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 = 358594 AND W.type_id = 1) OR (W.util_id <> 358594 AND W.type_id = 2)) AND (M.post_util_id = 358594 OR M.dest_util_id = 358594) 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 = 358594
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='790' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=343630 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 = 343630 AND W.type_id = 1) OR (W.util_id <> 343630 AND W.type_id = 2)) AND (M.post_util_id = 343630 OR M.dest_util_id = 343630) 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 = 343630
0
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 790
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.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 (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.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.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.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.0009
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
0.0235
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.0163
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

94 requetes sql en 0.0614

Taille variable Globale : 85.29 KB