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

Loue : chaines à  neige (urgent)

Annonces similaires

Tout voir
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Location Michelin fast grip 130

60€/semaine

Rueil-Malmaison
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Chaîne pour auto

45€/semaine

Limeil-Brevannes
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Chaine à neige - Tiguan

45€/semaine

Lagny-sur-Marne
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Chaine speciale renault arkana

40€/semaine

Athis-Mons
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Chaîne neige

40€/semaine

Beauchamp
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Chaine neige pneu 225/60/R18

-- €

Limours
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Cherche chaînes ou chaussettes

45€/semaine

Montigny-les-Cormeilles
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Location chaine a niege

35€/semaine

Marolles-en-Hurepoix
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Chaîne neige 275 50 r20

30€/semaine

Pontault-Combault
Location chaine a neige

Demande il y a + de 30j

Il y a + de 30j

Chaînes à neige

30€/semaine

Neuilly-Plaisance

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

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

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

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

  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='334455'

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chaine-a-neige' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='725'

  9. 0.0001

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

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

  11. 0.0001

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

  12. 0.0001

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

  13. 0

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

  14. 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 = 334455

  15. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=725 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0

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

  19. 0

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

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

  21. 0.0001

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

  22. 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 = '334455'

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

  24. 0.0001

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

  25. 0.0063

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.350339197041 AND ville_latitude_deg<49.249660802959 AND ville_longitude_deg>1.6840032105093 AND ville_longitude_deg<3.0493367894907 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.004

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

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

  28. 0.0001

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

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

  30. 0.0002

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

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

  32. 0.0001

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

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

  34. 0.0003

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

  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=485978 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 = 485978 AND W.type_id = 1) OR (W.util_id <> 485978 AND W.type_id = 2)) AND (M.post_util_id = 485978 OR M.dest_util_id = 485978) 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 = 485978

  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=291655 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 = 291655 AND W.type_id = 1) OR (W.util_id <> 291655 AND W.type_id = 2)) AND (M.post_util_id = 291655 OR M.dest_util_id = 291655) 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 = 291655

  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=412951 AND note_visu IN (1,3,4)

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

  46. 0.0001

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

  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=403518 AND note_visu IN (1,3,4)

  49. 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 = 403518 AND W.type_id = 1) OR (W.util_id <> 403518 AND W.type_id = 2)) AND (M.post_util_id = 403518 OR M.dest_util_id = 403518) 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 = 403518

  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=215396 AND note_visu IN (1,3,4)

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

  54. 0.0001

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

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

  58. 0.0001

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

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

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

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

  62. 0.0002

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

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

  64. 0.0001

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

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

  66. 0.0002

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

  67. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 725

  68. 0

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

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

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

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

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

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

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

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

  76. 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 (79) ORDER BY ssrubr_order ASC

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

  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 (228) ORDER BY ssrubr_order ASC

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

  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 (95) ORDER BY ssrubr_order ASC

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

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

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

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

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

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

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

  88. 0.0018

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

  89. 0.0222

    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'

  90. 0.0165

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

90 requetes sql en 0.062

Taille variable Globale : 84.69 KB