Indiquer un code postal ou une ville Indiquer un code postal

Poster une annonce

Se connecter S'inscrire

i18n

Sounboks 4 - enceinte portable 126db

Location Autres electromenager

Réserver

Ce voisin propose en location à Saint-Cloud (92210)

40€/jour

- -. Paiement activé

5/5résa

Calculée selon les réservations honorées et annulées.

9 annonces

Prix

40€/jour

Description de l'annonce

La Soundboks 4 est idéale pour donner vie à vos événements, que ce soit en intérieur ou en extérieur. Avec sa puissance impressionnante de 126 dB, elle assure un son clair et puissant capable d'animer jusqu'à 100 personnes.
⚡ Connexion simple et rapide : Bluetooth, câble ou platine DJ
? Autonomie exceptionnelle : de 4h à 40h selon le volume
? Disponible en retrait à Saint-Cloud ou en livraison sur Paris et sa région
Parfaite pour : soirées privées, anniversaires, mariages, événements étudiants, afterworks ou encore garden parties.
? Réservez en quelques clics sur : *** soundcall *** #autres electromenager

Autres annonces du voisin

Tout voir

5/5 résa

Il y a + de 30j

Technics sl-1210 mk2

50€/jour

Saint-Cloud

5/5 résa

Il y a + de 30j

Controller xdj-xz

120€/jour

Saint-Cloud

5/5 résa

Il y a + de 30j

Pioneer cdj-2000 nexus 2

70€/jour

Saint-Cloud

5/5 résa

Il y a + de 30j

Pack dj pioneer nxs2 – cdj-2000nxs2 + dj

200€/jour

Saint-Cloud

5/5 résa

Il y a + de 30j

Pack dj (xdj-xz + 2 sounboks + 2 pieds)

120€/jour

Saint-Cloud

5/5 résa

Il y a + de 30j

Pioneer djm-900 nexus 2

70€/jour

Saint-Cloud

5/5 résa

Il y a + de 30j

Pioneer djm-750mk2

50€/jour

Saint-Cloud

5/5 résa

Il y a + de 30j

Platine pioneer xdj-xz

60€/jour

Saint-Cloud

Annonces similaires

Tout voir

Il y a + de 30j

????Shampouineuse

20€/jour

Beaumont-sur-Oise

5/5 résa

Il y a + de 30j

Location chafing dish (chauffe plat)

6€/jour

Livry-sur-Seine

5/5 résa

Il y a + de 30j

Location shampooineuse Bissel SportClean

15€/jour

Sartrouville

5/5 résa

Il y a + de 30j

Loue stérilisateur électrique 30 L – Con

30€/jour

Paris

5/5 résa

Il y a + de 30j

Glacière de voyage (7 jours)

20€

5/5 Champigny-sur-Marne

Il y a + de 30j

Machine à glaces Italiennes

150€/jour

Lagny-sur-Marne

Il y a + de 30j

Machine à granité

30€/jour

Noisy-le-Roi

Il y a + de 30j

Machine à barbe à papa sur Chariot

35€/jour

Lagny-sur-Marne

5/5 résa

Il y a + de 30j

Machine barbe à papa professionnelle

30€/jour

5/5 Paris

Il y a + de 30j

Location machine à granité Slushi Ninja

30€/jour

Noisy-le-Roi

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

102 requetes sql en 0.0884

Taille variable Globale : 83.4 KB