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 a sertir per/multicouche

Autres annonces du voisin

Tout voir
Location echelle

Il y a + de 30j

Il y a + de 30j

Echelle de toit

40€/jour

Cantin
Location carrelette

Il y a + de 30j

Il y a + de 30j

Carelette pro 90cm RUBI

20€/jour

Cantin
Location cloueuse

Il y a + de 30j

Il y a + de 30j

Cloueuse a air comprimée

15€/jour

Cantin
Location scie sabre

Il y a + de 30j

Il y a + de 30j

Scie sabre a batterie

15€/jour

Capinghem
Location deshumidificateur

Il y a + de 30j

Il y a + de 30j

Deshumidificateur d'air

80€/semaine

Cantin
Location scie a onglet

Il y a + de 30j

Il y a + de 30j

Scie sur table

30€/jour

Cantin
Location scie circulaire

Il y a + de 30j

Il y a + de 30j

Scie circulaire

15€/jour

Cantin

Annonces similaires

Tout voir
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Location sertisseuse cuivre et multicouc

13€/jour

Faches-Thumesnil
Location pince a sertir
3,9/5 résa

Il y a + de 30j

Il y a + de 30j

Location sertisseuse & déboucheur électr

20€/jour

4,5/5 Lille
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince à sertir per ou multicouche

18€/jour

5/5 Wavrechain-sous-Denain
Location pince a sertir
4,3/5 résa

Il y a + de 30j

Il y a + de 30j

Pince PER et multicouche

20€/jour

Ennevelin
Location pince a sertir
5/5 résa

Il y a + de 30j

Il y a + de 30j

Pince a sertir - PER / Multicouche

10€/jour

Wattrelos
Location pince a sertir
4,6/5 résa

Il y a + de 30j

Il y a + de 30j

Pince a sertir multicouche et per

13€/jour

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

Il y a + de 30j

Il y a + de 30j

Pince a sertir

25€/jour

La Couture
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince à Sertir Multicouches/PER

15€/jour

Saint-Quentin
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince à sertir

8€/jour

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

Il y a + de 30j

Il y a + de 30j

Pince a sertir

5€/jour

5/5 Tourcoing

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

    SHOW TABLES LIKE 'pays'

  3. 0.0002

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

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

  8. 0

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='pince-a-sertir' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='49'

  9. 0.0001

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

  11. 0

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

  12. 0.0001

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

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

  15. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=49 LIMIT 1

  16. 0.0001

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

  17. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='415363' 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` = 236940 AND util_tel != ''

  19. 0

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

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

  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='236940' AND wish_id<>'415363' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

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

  25. 0.0001

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

  26. 0.0002

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

  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='72' LIMIT 0,1

  28. 0.0002

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

  29. 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='756' LIMIT 0,1

  30. 0.0002

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

  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='25' LIMIT 0,1

  32. 0.0002

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

  33. 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='775' LIMIT 0,1

  34. 0.0002

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

  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='41' LIMIT 0,1

  36. 0.0002

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

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

  38. 0.0002

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

  39. 0.0001

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

  40. 0.0157

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.16667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.867039197041 AND ville_latitude_deg<50.766360802959 AND ville_longitude_deg>2.4624652035945 AND ville_longitude_deg<3.8708747964055 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0033

    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 ('59169','59169','59151','59234','59182','59287','59287','59169','59234','59176','59234','59169','59165','59187','59176','59265','59182','59580','59151','59151','59580','59450','59247','59151','59252','62860','59169','59151','59167','59265','59247','59252','59552','59490','59119','59146','62860','62112','62112','62490','59247','59500','59252','59552','59194','62490','62860','59215','59172','62860','59265','59490','59111','62490','59870','62860','62860','59870','62860','59554','62117','59179','59259','59553','59553','62860','59265','59295','59295','59111','59194','59265','59268','59172','59553','59171','59111','62860','59554','59148','62490','59128','59141','59286','62860','62156','59554','59156','59870','59171','62156','59124','62490','59400','59293','59950','62860','59554','59554','59870','59141','62490','62156','59111','59283','59870','59161','62118','59141','62790','62860','59161','59310','59171','62182','62970','59220','62118','59282','59554','59282','59283','62156','62141','62860','59161','59870','62182','62490','62156','59400','59870','62490','59310','59267','59255','62156','59296','62950','62860','59310','59400','59135','59178','59162','59161','59220','62118','59310','62580','62118','62156','62119','59178','59277','59267','59235','62860','59246','59310','59400','59121','59230','59178','62182','59220','59400','62320','62320','59198','59195','62118','59400','62147','59230','59135','62118','62860','62147','59159','62110','59188','62128','59121','62182','59129','62580','62118','59224','59239','59310','59400','62320','62580','59195','62860','59710','59281','59261','59310','62580','62128','59188','62640','59178','62590','59217','59551','59310','62820','62320','62128','59224','59494','62420','62740','59310','59690','59239','62580','59227','59227','62710','59242','59159','59125','59400','59710','59267','59241','62580','59233','62128','59226','62580','59174','62223','59188','59292','59230','59400','62147','62147','62128','62128','59494','59227','62680','62128','62220','59217','59226','59400','59217','59590','59551','59310','62223','62580','62128','62430','62440','59242','62159','59217','62147','59710','59410','59213','62880','59242','59159','62128','59214','59133','59192','59710','59258','59300','59157','62128','62221','62218','07624','59294','59258','59269','62147','62210','62128','62580','62217','59213','07611','62124','59157','59133','62124','59300','62217','59273','59830','59231','62223','62880','62880','59158','62580','59300','59127','59112','59830','59258','62124','07623','62147','59830','62300','62128','59730','62880','59860','62159','59540','59213','59213','62300','62223','62128','59269','59147','59191','59230','59770','62000','59113','07621','62217','62124','59880','62217','59158','59273','59540','62223','07620','59266','59730','62124','59830','59730','62128','62124','59230','07610','59271','62175','59730','59990','59830','59185','62223','62223','59191','59251','62410','59158','62580','59269','59175','62124','59830','59213','59213','59199','62217','62217','62121','62121','59175','59147','62124','07618','62410','59730','62159','59112','62450','62580','07620','62124','59147','62223','59191','07620','59990','59262','59990','59830','59231','59266','59810','59231','07620','59199','59225','59221','07620','59158','59540','62410','62450','59127','59530','62175','07502','59263','62124','59780','07622','62800','59278','62153','59155','62138','59139','62124','59225','59540','59990','62750','62410','59970','59990','07620','59530','07504','59266','62175','62121','62121','59272','62450','62450','07506','59139','59127','59297','62143','59152','59152','59264','62450','59152','59790','59144','62121','59730','59127','59780','62121','59184','59496','62173','62000','59360','59530','59980','59970','02420','62175','59218','59218','62124','62124','62138','62217','80360','07641','59970','07500','07522','62153','59243','07500','62450','59980','62124','59127','59142','59136','62450','59163','62121','62161','62161','59218','80360','59530','62144','62450','62175','59218','59274','59260','59152','02420','59530','59320','80240','07608','59496','62450','62173','80122','62144','59530','62121','07522','59320','62160','80360','07522','62138','59144','07640','59980','59980','62161','59980','07501','59530','62160','59990','62450','62450','59238','62450','07604','07642','59990','07640','59222','62160','59222','59134','59120','62116','59211','62450','80360','62138','62450','07521','62121','59360','59510','07522','80740','07640','07643','59480','59144','59780','59360','62161','59144','62173','02420','62123','59134','80240','02420','59134','59320','62980','62144','59000','59800','59160','59350','59777','07500','62123','62116','62450','07536','59154','62116','07387','59320','62173','59163','59530','59134','80240','80360','59920','02110','59530','62138','62116','59530','59370','07503','59480','02110','59530','07604','59144','80240','62144','62149','62980','59144','07538','59390','62149','59222','07600','62670','62121','02420','80740','62123','59530','59510','62172','59320','59320','07603','02420','07520','07548','07604','59360','62114','59163','62149','80112','59530','07387','07387','59110','59320','62149','62123','62123','59530','07530','62144','62530','62123','07387','59320','07601','80360','59550','07380','62690','62450','80360','59137','59288','80300','59360','59130','62690','62530','07380','59320','02110','07604','07320','62111','59249','80360','07904','80300','62113','62113','62840','07350','59134','59170','59290','80240','62450','62116','62123','59550','59570','59390','07540','62123','62123','80300','59360','07520','59350','59390','62690','07540','07387','07602','59249','59700','07604','07531','02420','80360','62123','80360','59144','62123','02110','59360','62530','59390','07730','80360','59160','02110','62690','80760','80240','80240','02420','62116','62290','07382','07387','62123','62690','59840','62149','62840','07534','62123','80240','07387','62690','59144','07321','07387','07350','59520','62123','07730','80300','59840','02420','59491','59493','59650','59655','62660','07743','07743','62113','80360','07542','59360','80240','02420','02110','62690','80200','59115','59530','02420','80300','07971','59570','07971','59840','62690','59570','62111','80360','07532','59570','07321','59118','62810','07730','07904','02110','02110','62150','07971','62620','07730','02420','02110','07322','02110','62111','62136','62690','07971','62123','59280','02110','07543','07370','59237','80240','02110','62450','80300','62111','07350','07370','59100','02490','59570','02490','59420','80240','59150','80240','59570','59360','80200','07533','07740','62150','07972','62131','59910','62111','07540','62690','62131','62131','07534','62810','07973','62111','59550','07906','62620','80240','62810','59360','07387','80240','02420','62158','07387','62136','07322','62150','80200','62158','07730','59570','62690','62810','59570','02110','62400','62690','62620','62840','80200','02420','62111','80360','80300','62158','59570','07370','07350','62690','62136','07540','62810','07973','59200','02230','07730','80300','02490','80300','07387','62620','62940','07904','07712','80360','62400','07730','62232','02420','07742','59930','80300','59360','80200','07740','62690','80300','62400','59360','07972','62196','62690','62150','59570','62810','07760','62840','62158','02420','62690','62150','59280','80300','02630','80200','80360','07901','07760','80200','80200','07370','62232','62232','62760','07760','62232','07911','59890','02420','02630','80300','80300','07972','59116','62810','80360','07334','59550','59570','07300','02490','59193','62111','02490','80200','02110','62840','62158','59223','59250','59126','08587','80200','80240','02110','80240','62199','80560','80560','59550','62127','62111','80560','02110','80300','07700','07711','62150','62127','07903','59570','62810','62760','59145','59236','07911','07340','59940','07910','80300','02110','62810','62700','02450','07903','80300','80360','02630','07900','07900','80300','08587','07903','07700','62136','62920','02100','02100','62232','07783','07970','80200','62122','59145','80560','07334','07911','62127','59960','02490','62810','59253','80240','62150','80240','02100','08510','07330','59570','62127','02100','07760','07301','62127','59138','08587','59850','62760','59550','07910','80300','59890','02450','62127','07333','62920','07332','80200','07950','80560','62150','62810','59138','59620','62158','80560','02110','07760','80200','02100','80340','07910','62760','07340','07911','59620','62127','62150','80340','59550','07340','62810','59570','07782','80200','07910','07910','59550','02110','02110') AND fami_id='5' AND cate_id='87' AND type_id='1' AND ssrubr_id='49' AND wish_id<>'415363' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

  43. 0.0001

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

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

  45. 0.0001

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

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

  47. 0.0001

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

  48. 0.0004

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

  49. 0.0001

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

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

  51. 0.0001

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

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

  53. 0.0001

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

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

  55. 0.0001

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

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

  57. 0.0001

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

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

  59. 0.0001

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

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

  61. 0.0001

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

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

  63. 0.0001

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

  64. 0.0004

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

  65. 0.0001

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

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

  67. 0.0001

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

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

  69. 0.0001

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

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

  71. 0.0001

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

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

  73. 0.0001

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

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

  75. 0.0001

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

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

  77. 0.0002

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

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

  79. 0.0001

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

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

  81. 0.0001

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 49

  83. 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  103. 0.0014

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

  104. 0.0246

    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'

  105. 0.018

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

105 requetes sql en 0.076

Taille variable Globale : 85.38 KB