Kiwiiz : service & location entre voisins.
Utiliser ma position
Logo recherche

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Poster une annonce

Location de chaîne à neige

Autres annonces du voisin

Tout voir
Location coupe branches
4,1/5 résa

Il y a + de 30j

Il y a + de 30j

Location coupe-branches télescopique

10€/jour

4,7/5 Montesson
Location barres de toit
4,1/5 résa

Il y a + de 30j

Il y a + de 30j

Barre de toit officielle pour Toyota CHR

30€/semaine

4,7/5 Montesson
Location coffre de toit
4,1/5 résa

Il y a + de 30j

Il y a + de 30j

Location coffre de toit Thule

30€/semaine

4,7/5 Montesson
Location echelle
4,1/5 résa

Il y a + de 30j

Il y a + de 30j

Plateforme de travail

10€/jour

4,7/5 Montesson

Annonces similaires

Tout voir
Location chaine a neige
3,9/5 résa

Il y a + de 30j

Il y a + de 30j

Chaînes neige Michelin Easy Grip Evoluti

15€/semaine

La Queue-en-Brie
Location chaine a neige

Il y a + de 30j

Il y a + de 30j

Location chaines

30€/semaine

Tremblay-en-France
Location chaine a neige

Il y a + de 30j

Il y a + de 30j

Chaines neige

45€/semaine

Annet-sur-Marne
Location chaine a neige

Il y a + de 30j

Il y a + de 30j

Chaînes à neige Polaire Steel Grip 100

50€/semaine

Chatillon
Location chaine a neige
4,1/5 résa

Il y a + de 30j

Il y a + de 30j

Chaines neige KONIG K-Summit K23 K44 K33

45€/semaine

5/5 Longjumeau
Location chaine a neige
5/5 résa

Il y a + de 30j

Il y a + de 30j

Chaînes à neige

75€/semaine

Méry-sur-Oise
Location chaine a neige
5/5 résa

Il y a + de 30j

Il y a + de 30j

Chaînes à neige

75€/semaine

Méry-sur-Oise
Location chaine a neige

Il y a + de 30j

Il y a + de 30j

Location chaussette neige homologue

35€/semaine

Savigny-sur-Orge
Location chaine a neige

Il y a + de 30j

Il y a + de 30j

Chaînes neige

40€/semaine

Orgeval
Location chaine a neige

Il y a + de 30j

Il y a + de 30j

Loue chaînes neige

50€/semaine

Orgeval

Louer des chaines a neige entre particuliers ou proposer des chaines a neige en location.

Poster une annonce
Retour
Fermer

Location entre voisins

Lancez votre recherche pour voir les annonces.

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0001

    SHOW TABLES LIKE 'pays'

  3. 0.0001

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

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

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

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

  7. 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='549227'

  8. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chaine-a-neige' LIMIT 1

  9. 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='227'

  10. 0.0001

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

  11. 0.0001

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

  12. 0

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

  13. 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 = 549227

  14. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=725 LIMIT 1

  15. 0.0001

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

  16. 0.0001

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

  17. 0.0001

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

  18. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=243055 LIMIT 1

  19. 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 = 243055 AND W.type_id = 1) OR (W.util_id <> 243055 AND W.type_id = 2)) AND (M.post_util_id = 243055 OR M.dest_util_id = 243055) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  20. 0.0001

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

  21. 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 = '549227'

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

  23. 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='22' LIMIT 0,1

  24. 0.0001

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

  25. 0.0002

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

  26. 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='870' LIMIT 0,1

  27. 0.0002

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

  28. 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='723' LIMIT 0,1

  29. 0.0002

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

  30. 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='65' LIMIT 0,1

  31. 0.0002

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

  32. 0.0001

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

  33. 0.0084

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.15- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.467039197041 AND ville_latitude_deg<49.366360802959 AND ville_longitude_deg>1.4657397807905 AND ville_longitude_deg<2.8342602192095 HAVING distance <= 50 ORDER BY distance ASC

  34. 0.0041

    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 ('78360','78420','78600','78110','78800','78600','78400','78230','92000','78500','78560','78100','92500','95870','78290','78380','78430','95530','78750','78112','92700','78160','78170','78300','92250','92400','95370','95100','78260','78620','92800','92150','78700','95240','92270','92380','78240','78870','95110','78955','92200','95220','92430','92420','78570','95130','78150','78590','92210','78240','92300','92600','78150','92410','78780','95130','92230','92110','95480','95210','95218','78570','95120','78670','78670','95610','92310','95250','78590','92100','93800','78630','78860','95000','78000','78220','78140','78510','95230','95320','78330','78540','95880','95600','78450','92370','92390','93450','93400','92190','92360','95150','95550','95280','95390','92130','78480','78450','95000','78210','95580','95580','92170','78810','93430','95680','95310','95300','95170','93200','93210','95490','92140','75001','75000','75002','75003','75004','75005','75006','75007','75008','75009','75010','75011','75012','75013','75014','75015','75016','75017','75018','75019','75020','75116','95740','95000','92240','95360','78630','78390','92320','78121','95160','95410','95180','78340','92120','95840','78350','78530','78350','95430','78130','93380','78810','95800','92220','78580','93120','93300','95300','95540','95560','92350','78740','94250','78920','93240','95650','95520','95840','92260','92330','78280','95350','78740','95350','93500','78370','95570','78190','78850','95330','93310','94110','78117','95650','78180','92290','95430','95630','78410','91570','94270','78130','95400','95200','95650','95450','93350','78580','93440','92340','78960','95560','95570','94240','94230','94231','94232','94233','94234','94235','94236','94237','94238','94239','95140','93170','78250','95440','94200','94205','91370','95300','91400','95460','78250','94800','78640','95560','95300','95760','78117','91430','78580','78124','95450','95570','95400','78990','95590','91430','78124','93260','93230','78114','78250','78640','78410','95500','93100','95650','95650','92160','94160','78470','78250','78580','78126','93700','93150','78650','94300','93000','95450','95560','94260','94550','91190','78250','91190','78640','94220','78410','78470','91300','95620','95450','95810','95290','95500','93140','95720','91120','78410','78410','94140','93130','95720','95720','78640','78760','94400','78320','94150','78820','78310','94320','95690','91440','95810','95690','91400','95830','95450','95570','95450','95450','78320','91320','94700','78470','78680','78770','95720','95830','95590','95500','78650','78770','93110','95270','94410','95810','95660','95270','78460','91140','78310','78250','94120','78490','95260','91160','95190','94600','78490','94340','93250','95690','95690','95260','91940','91190','95450','78440','95500','94310','94390','78770','94130','91940','78970','78770','95810','78440','95190','95590','78720','91380','91160','78490','78490','95450','95850','78720','78320','78770','95810','94170','91140','78580','95270','93320','93340','78690','91470','93600','78440','95450','95340','91160','91550','78770','93360','78440','94000','95190','95270','91420','95640','78460','95450','91940','91400','78490','95450','78930','78930','93270','95640','95640','95270','95340','94290','78770','93220','78440','95700','94360','91470','78440','78490','78490','93420','78440','95640','95380','95850','78720','78490','94100','94210','94340','60230','95450','95270','78690','95270','91200','78440','93330','95450','94500','93190','93390','91160','78440','95640','95380','95270','94380','94480','91640','78490','94460','94430','95640','95810','95340','95270','95270','94190','91470','95810','91620','95640','95820','95270','91360','78930','93410','78790','78790','93370','95640','91470','94350','95420','95270','91620','78720','91360','78940','93460','78610','91270','91260','60530','91560','78890','78520','78910','93160','60820','91390','91600','93290','95510','95670','60240','60110','91700','78440','95380','77181','93470','95470','78490','94450','78910','78930','60540','60540','78790','78440','95380','95750','91460','78200','78711','78910','60119','78930','95750','94420','91210','78200','95420','95450','78610','91230','94470','60530','91170','94370','94380','91310','91310','95380','94490','94880','94880','78930','78930','60119','91310','77500','78940','60260','60530','91640','91240','60110','91640','78520','91470','60540','95510','95420','95420','77420','60540','91330','78125','78790','77181','77270','91310','78790','77990','78910','95420','91350','91700','78610','78830','78200','78910','95510','95470','77990','60580','60119','60530','78720','60240','77290','94510','78830','91800','91680','60110','60240','60460','91700','91640','78520','78200','78910','77185','78790','95420','91680','60240','60270','78200','60240','60530','91000','91130','91220','91220','77177','60175','60540','95470','95470','94440','78490','78610','94440','77340','77184','60530','91180','95420','60560','78200','77186','60173','77410','78200','95510','60240','78200','78790','95780','77230','60530','60520','60240','91450','78200','77360','60570','77230','91530','60460','60110','78200','95420','77200','91860','91520','91340','91070','60240','91470','77230','60128','78120','78550','94440','91290','78790','95420','94520','94520','60340','91290','91080','95420','77410','78910','78120','91800','91090','91000','78550','60340','78200','77170','95510','77680','78710','77290','77090','77183','91650','60570','91650','78980','78840','78111','78730','78730','60520','60500','60240','78950','91450','78125','77400','60240','78520','77230','78910','78270','77400','60240','60149','91530','60730','95420','60240','91480','91630','60128','77600','91650','60730','95420','60500','77150','60240','95780','60790','91410','91630','78270','60740','78113','91480','91090','78200','77410','60240','91630','78270','77230','60240','77410','77400','91250','95710','91630','78113','77150','77410','91530','60520','77600','77600','60110','60730','91790','78550','77230','78550','77380','60660','77330','91250','78980','60790','77410','77400','78790','77400','77230','91630','78200','95510','77400','95710','60730','78120','77164','60660','60660','95780','78730','91810','91280','77600','78910','60300','60300','77230','78790','60240','78125','77135','60160','95420','78550','60240','60660','60660','60250','60570','91580','60430','77410','60790','91910','91730','27630','60240','78840','77400','78113','77230','91100','78550','60240','91530','77170','60240','91540','77127','91730','77280','91100','60790','60790','60730','60240','78270','91410','60240','91250','77600','60240','95710','91410','60240','91710','77173','78980','60950','77230','60160','28410','91540','91540','27620','78270','60300','60330','77144','60240','60240','78125','78980','28560','28260','78270','91580','77230','60300','60790','60250','91770','78730','91540','91730','77600','78125','60240','78113','78125','77450','78980','28260','95770','78980','78125','60180','77144','77700','91510','91510','27620','78730','77410','60240','60240','60300','28410','77230','78270','28560','60240','78125','91850','28410','27630','60240','60100','77166','78113','77166','77165','78125','27630','60250','28260','77410','60430','77450','60240','60660','95770','95770','91580','78270','77165','77410','60430','91760','91580','91250','91830','78270','27630','60950','91610','60250','27630','60590','60240','77410','60250','77700','77550','78113','28410','78270','77165','77165','27420','60300','77220','91410','78270','77230','91750','60870','28260','28410','60330','77700','60390','27640','77450','27720','60300','28230','78125','60300','60300','78980','60590','60290','60300','27620','78125','77176','78660','60430','60240','28230','60430','60240','60390','60590','60290','60390','91580','91410','91590','60700','27140','60550','77450','77450','77174','28260','60390','60250','91410','28210','77170','60950','28210','28210','77111','77700','77550','91830','60390','77165','77220','28410','77220','28410','27630','60330','28260','60250','27720','60590','77220','78270','60290','91750','77700','60290','27630','27630','78660','78270','28410','77450','77450','60250') AND fami_id='5' AND cate_id='227' AND type_id='1' AND ssrubr_id='725' AND wish_id<>'549227' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  35. 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='725' LIMIT 0,1

  36. 0.0001

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

  37. 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 = 211276 AND W.type_id = 1) OR (W.util_id <> 211276 AND W.type_id = 2)) AND (M.post_util_id = 211276 OR M.dest_util_id = 211276) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  38. 0.0001

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

  39. 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='725' LIMIT 0,1

  40. 0.0001

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

  41. 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 = 407508 AND W.type_id = 1) OR (W.util_id <> 407508 AND W.type_id = 2)) AND (M.post_util_id = 407508 OR M.dest_util_id = 407508) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  42. 0.0001

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

  43. 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='725' LIMIT 0,1

  44. 0.0001

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

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

  46. 0.0002

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

  47. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='725' LIMIT 0,1

  48. 0.0001

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

  49. 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 = 489911 AND W.type_id = 1) OR (W.util_id <> 489911 AND W.type_id = 2)) AND (M.post_util_id = 489911 OR M.dest_util_id = 489911) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  50. 0.0001

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

  51. 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='725' LIMIT 0,1

  52. 0.0001

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

  53. 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 = 232908 AND W.type_id = 1) OR (W.util_id <> 232908 AND W.type_id = 2)) AND (M.post_util_id = 232908 OR M.dest_util_id = 232908) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  54. 0.0002

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

  55. 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='725' LIMIT 0,1

  56. 0.0001

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

  57. 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 = 226636 AND W.type_id = 1) OR (W.util_id <> 226636 AND W.type_id = 2)) AND (M.post_util_id = 226636 OR M.dest_util_id = 226636) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  58. 0.0002

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

  59. 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='725' LIMIT 0,1

  60. 0.0002

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

  61. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='725' LIMIT 0,1

  62. 0.0001

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

  63. 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 = 293001 AND W.type_id = 1) OR (W.util_id <> 293001 AND W.type_id = 2)) AND (M.post_util_id = 293001 OR M.dest_util_id = 293001) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  64. 0.0002

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

  65. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='725' LIMIT 0,1

  66. 0.0001

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

  67. 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 = 428445 AND W.type_id = 1) OR (W.util_id <> 428445 AND W.type_id = 2)) AND (M.post_util_id = 428445 OR M.dest_util_id = 428445) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  68. 0.0003

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

  69. 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='725' LIMIT 0,1

  70. 0.0001

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

  71. 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 = 470894 AND W.type_id = 1) OR (W.util_id <> 470894 AND W.type_id = 2)) AND (M.post_util_id = 470894 OR M.dest_util_id = 470894) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  72. 0.0002

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

  73. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 725

  74. 0

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

  75. 0.0002

    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

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

  77. 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 (88) ORDER BY ssrubr_order ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  94. 0.001

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

  95. 0.028

    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'

  96. 0.0339

    SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

96 requetes sql en 0.0885

Taille variable Globale : 84.39 KB