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

Pince à sertir pour le PER et le multicouche

Autres annonces du voisin

Tout voir
Location perceuse

Il y a + de 30j

Il y a + de 30j

Perceuse à percussion filaire BLACK&DECK

10€/jour

Survilliers
Location scie circulaire

Il y a + de 30j

Il y a + de 30j

Scie circulaire filaire DEXTER 1300W 185

10€/jour

Survilliers

Annonces similaires

Tout voir
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Coffret pince à sertir

25€/jour

Neuilly-sur-Marne
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Location malette à sertir le PER

10€/jour

Andresy
Location pince a sertir
4,3/5 résa

Il y a + de 30j

Il y a + de 30j

Loue pince à sertir ridgid

20€/jour

5/5 Clamart
Location pince a sertir
4,5/5 résa

Il y a + de 30j

Il y a + de 30j

Pince à sertir les rails Mac Allister

5€/jour

5/5 Montesson
Location pince a sertir
5/5 résa

Il y a + de 30j

Il y a + de 30j

Pince à sertir pour Multicouche et PER

15€/jour

5/5 Champigny-sur-Marne
Location pince a sertir
4,3/5 résa

Il y a + de 30j

Il y a + de 30j

Location pince à sertir - per et multico

7€/jour

5/5 Fresnes
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince a sertir

25€/jour

Mouroux
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince à sertir

20€/jour

Villiers-sur-Marne
Location pince a sertir
3,6/5 résa

Il y a + de 30j

Il y a + de 30j

Pince à sertir per et multicouche

20€/jour

Longueil-Annel
Location pince a sertir
4,4/5 résa

Il y a + de 30j

Il y a + de 30j

Pince à sertire rems

25€/jour

Chatillon

Louer une pince a sertir entre particuliers ou proposer une pince a sertir 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.0005

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

  8. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'pince-a-sertir' 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='87'

  10. 0.0001

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

  11. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='510627' 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` = 510627

  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 = 627502

  14. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=49 LIMIT 1

  15. 0.0001

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

  16. 0.0001

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

  17. 0

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

  18. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=510627 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 = 510627 AND W.type_id = 1) OR (W.util_id <> 510627 AND W.type_id = 2)) AND (M.post_util_id = 510627 OR M.dest_util_id = 510627) 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='510627' 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 = '627502'

  22. 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='510627' AND wish_id<>'627502' 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='50' 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=510627 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 = 510627

  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='33' 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 = 510627

  28. 0.0001

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

  29. 0.0162

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.1*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.1*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.48333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.650339197041 AND ville_latitude_deg<49.549660802959 AND ville_longitude_deg>1.7965461466191 AND ville_longitude_deg<3.1701138533809 HAVING distance <= 50 ORDER BY distance ASC

  30. 0.0032

    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 ('95470','95270','95670','95270','95270','95850','95380','95270','95190','60560','95470','95850','60520','95270','95270','60580','95190','95270','95470','60260','95380','95720','95470','60128','95380','60520','95270','95380','95720','95570','60128','95720','95380','60520','95270','77230','95190','95270','95720','95270','77990','60270','60500','95500','60500','95500','77230','95570','95460','95700','95270','60300','60300','95440','60820','95570','95560','77990','95560','95500','60740','77230','95330','95400','95200','60300','95350','95590','60340','95560','95590','95400','60460','95350','95820','60340','95570','77230','60950','95590','77280','95260','60300','60300','95500','93420','95340','60300','95160','77230','95140','60330','95260','60950','60300','95410','77290','60300','77230','60300','60300','60460','95340','95560','93600','95170','60160','93380','60530','95680','60530','93440','93290','95580','95580','77290','95660','77230','77230','95360','60660','60530','95840','60700','93240','95290','95390','95600','60230','60100','60180','95840','60810','95230','93150','93700','93430','60950','93270','60160','60810','93350','95880','60530','77230','95320','77230','60530','95620','93410','60330','60300','60660','60660','60530','77410','95740','60870','60660','60660','60810','77230','95120','77410','60550','95760','60330','93200','93210','95430','95630','95340','95150','95550','95210','95218','77270','93190','93390','95540','93800','77230','95130','77230','60440','60810','92390','93450','93120','93470','93300','77181','77410','95690','93140','60290','60540','60540','60540','93340','60870','60290','95130','93000','93320','60530','95110','77181','77165','95250','60870','92230','77410','93500','93370','60660','60330','60440','95430','77178','60700','77165','60810','60810','95690','60250','60440','77410','60700','95100','93250','93130','60940','60140','60290','60940','77165','60540','60800','93230','93220','93260','95240','60540','77165','77165','95690','77178','60940','60250','93400','93310','95480','60440','95690','60730','60410','60810','60700','77410','95370','77410','92600','95300','60700','77500','95220','92270','93110','92110','60730','60250','60140','60140','77410','93360','60290','93100','93170','95530','60110','60800','77177','92700','77410','60410','92300','93460','60290','60440','95870','95810','60250','77122','60410','95310','77165','77165','60730','77410','78500','60440','60800','94120','94170','60140','60140','95300','60730','60440','77400','92250','93330','94300','92400','95300','77400','60700','60570','60800','95810','60290','93160','95300','77450','75001','75010','75011','75012','75013','75014','75020','75015','75016','75017','75018','75019','75116','75004','75005','75006','75003','75007','75002','75008','75009','75000','60570','77360','77410','60410','92200','60440','60110','60730','78800','77450','60250','60700','77420','77139','77124','95810','95610','60700','60110','78600','77400','94130','60140','94360','77400','60320','60250','77186','60600','78420','94350','94160','77139','60410','77400','60410','60710','77200','92000','77400','95810','95650','60800','95520','77450','77910','60800','78700','77124','60250','95810','60250','77400','77450','77185','95000','60710','77600','60600','60600','94340','94410','60800','60250','94500','60600','60190','60840','95810','92150','92800','78360','78600','95000','92500','95810','77700','77144','77139','94220','77124','60250','77600','77600','60620','60680','77700','60600','94420','77600','94205','60600','60190','60190','94200','78780','77910','77144','60800','60129','60110','60320','77183','77090','92170','60126','77124','77100','94270','60175','77450','60620','95640','60320','60320','60570','60190','77450','77184','95650','60370','78570','77600','60430','60126','94250','94340','94100','94210','60119','60800','94430','77100','60600','94700','95490','77139','94140','60190','60800','92120','60430','78260','77450','60620','95830','95280','60370','92100','92240','78400','95640','60620','94800','95650','60110','60129','60430','77910','92210','60790','77340','60880','60370','78110','77164','77450','94110','60620','60680','60680','60600','95830','94000','77139','95650','95650','92130','78570','60600','60600','60610','77700','77600','60430','60129','60149','77680','94490','94880','94880','77700','77100','77440','60119','78230','94400','77910','60173','92220','95640','60190','94510','95800','78560','77860','77470','92380','60117','60119','60620','60240','60190','78380','78290','95000','92320','60620','95450','60790','60129','78300','78100','77860','60620','95640','78955','60790','60430','60510','60620','94239','94233','94234','94235','94236','94238','94232','94231','94230','94237','94240','92140','92360','77135','77860','92190','78170','60134','60600','94380','60600','95640','60190','92430','92420','94370','94380','92410','78430','77580','77440','60190','60190','60600','94600','60127','60790','60620','78510','95180','60790','60800','95450','60880','60880','60134','60510','60620','92310','94320','77440','78750','77470','60930','60680','60600','92260','92330','92340','60430','94550','77700','60790','60240','92350','60510','77470','78480','77470','78740','78112','60117','94460','60130','60190','95640','60620','95640','78670','94470','78670','78160','77174','60510','60130','95450','92370','60117','78540','60620','60190','94390','94310','77330','60127','95450','77580','78240','60240','77580','60190','60190','60430','78140','78150','78740','77580','77580','78620','95450','77470','95450','94150','60240','60390','95450','77145','78150','92290','78870','60141','77440','77174','78220','60240','77580','78240','60890','95750','77470','60190','94450','94260','60130','60130','94190','77580','77440','94290','60190','94440','60390','60240','77440','77440','92160','78590','60890','95450','60510','95640','60130','60240','60510','60190','77470','78630','60117','77150','60430','60350','91370','78000','60240','60200','77580','60130','60240','91320','77150','78250','77660','60510','60890','95450','95450','77840','60890','60240','60890','91330','60130','60117','60000','60141','91560','60240','60510','60123','78130','77660','77440','60130','60130','78130','77440','94440','60000','60190','94480','60390','60190','77220','91200','94440','60890','77440','60190','77170','91300','78590','77163','60200','60240','91550','78250','91570','60390','78350','60190','02600','60240','60240','78250','60390','78250','78860','95750','60510','78630','60280','60510','91800','60130','91230','78920','60420','60240','60130','78330','77220','77173','77580','94520','91270','94520','60190','60123','95450','02810','95450','78530','78350','77610','60190','78410','60190','95450','60113','60510','60113','78210','60240','02600','78450','91430','78250','77440','60130','60350','60890','60420','77163','60130','95450','02600','60240','91430','60240','60350','77220','60240','77580','78810','91420','60510','78450','77580','77440','91120','60390','02600','78580','60130','95450','95420','60130','77640','91860','60130','60190','91380','91160','78440','60200','60200','91800','60240','91210','02600','95420','02460','60240','02600','78250','60420','60510','78121','77260','77260','77220','91400','91260','77840','60155','60000','60750','60420','60130','91160','78117','91480','77580','77515','60113','95420','78410','77163','77170','60240','60150','60150','78820','60155','91140','78440','60350','78390','78810','60150','60510','60240','60480','78280','77610','60000','77610','60240','60480','78340','77166','60130','91480','60350','60150','78410','60510','60162','02810','77380','60000','77260','78580','60350','95420','60000','78440','60420','91170','77120','60153','60480','60240','78440','60240','91160','60510','02600','77220','78580','91600','91390','60150','60000','91360','77610','78117','60162','78180','91400','60390','60480','60490','60650','91360','91190','02460','60390','78126','91140','78850','78440','78190','77840') AND fami_id='5' AND cate_id='87' AND type_id='1' AND ssrubr_id='49' AND wish_id<>'627502' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

  34. 0.0002

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

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

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

  38. 0.0002

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

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

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

  42. 0.0002

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

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

  45. 0.0005

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 311956 AND W.type_id = 1) OR (W.util_id <> 311956 AND W.type_id = 2)) AND (M.post_util_id = 311956 OR M.dest_util_id = 311956) 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 = 311956

  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='49' 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=135787 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 = 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 <> ''

  50. 0.0001

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

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

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

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

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

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

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

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

  66. 0.0001

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

  67. 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='49' LIMIT 0,1

  68. 0.0001

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

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

  70. 0.0002

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

  71. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 49

  72. 0.0001

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

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

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

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

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

  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 (110) 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 (227) 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 (176) 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 (79) ORDER BY ssrubr_order ASC

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

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

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

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

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

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

  88. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (193) ORDER BY ssrubr_order ASC

  89. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (91) ORDER BY ssrubr_order ASC

  90. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (232) ORDER BY ssrubr_order ASC

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

  92. 0.0012

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

  93. 0.0258

    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'

  94. 0.0181

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

94 requetes sql en 0.0783

Taille variable Globale : 85.42 KB