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

Autres annonces du voisin

Tout voir
Location leve plaques

Il y a + de 30j

Il y a + de 30j

Leve plaque

10€/jour

Avesnes-les-Aubert
Location scie sauteuse

Il y a + de 30j

Il y a + de 30j

Scie sauteuse makita

8€/jour

Avesnes-les-Aubert
Location diable

Il y a + de 30j

Il y a + de 30j

Transpalette manuel

10€/jour

Avesnes-les-Aubert
Service electricien

Il y a + de 30j

Il y a + de 30j

Service : électricien

28€/heure

Avesnes-les-Aubert
Location echafaudage

Il y a + de 30j

Il y a + de 30j

Gazelle 6 marches

15€/jour

Avesnes-les-Aubert
Location autres outils

Il y a + de 30j

Il y a + de 30j

Pince à glissement

15€/jour

Avesnes-les-Aubert
Location autres outils

Il y a + de 30j

Il y a + de 30j

Scie cloche a beton

5€/jour

Avesnes-les-Aubert
Location autres outils

Il y a + de 30j

Il y a + de 30j

Foret sds 60cm different diametre

8€/jour

Avesnes-les-Aubert
Location scie sabre

Il y a + de 30j

Il y a + de 30j

Scie sabre

5€/jour

Avesnes-les-Aubert
Location marteau piqueur

Il y a + de 30j

Il y a + de 30j

Marteau piqueur 24kl

15€/jour

Avesnes-les-Aubert
Location autres outils

Il y a + de 30j

Il y a + de 30j

Rampe voiture moto

20€/jour

Avesnes-les-Aubert
Location perforateur

Il y a + de 30j

Il y a + de 30j

Perforateur

10€/jour

Avesnes-les-Aubert
Location disqueuse

Il y a + de 30j

Il y a + de 30j

Laine de verre

2€/jour

Avesnes-les-Aubert
Location autres outils

Il y a + de 30j

Il y a + de 30j

Coupe parquet

5€/jour

Avesnes-les-Aubert
Location betonniere

Demande il y a + de 30j

Il y a + de 30j

Cherche bétonnière

30€/jour

Avesnes-les-Aubert

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

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

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

Il y a + de 30j

Il y a + de 30j

Pince a sertir PER et Multi Couche

15€/jour

Wattignies
Location pince a sertir
5/5 résa

Il y a + de 30j

Il y a + de 30j

Pince à sertir RJ45

5€/jour

Arras
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince à glissement PER

25€/jour

Inchy-en-Artois
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince a sertir per/multicouche

10€/jour

Cantin

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

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

  11. 0.0001

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

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

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

  16. 0.0001

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

  18. 0

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

  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='306439' AND wish_id<>'474148' 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='59' 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=306439 AND note_visu IN (1,3,4)

  25. 0.0001

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

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

  27. 0.0001

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

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

  29. 0.0001

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

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

  31. 0.0001

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

  32. 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='66' LIMIT 0,1

  33. 0.0001

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

  34. 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='1157' LIMIT 0,1

  35. 0.0001

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

  36. 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='1157' LIMIT 0,1

  37. 0.0001

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

  38. 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='1157' LIMIT 0,1

  39. 0.0001

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

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

  41. 0.0001

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

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

  43. 0.0001

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

  44. 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='1157' LIMIT 0,1

  45. 0.0001

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

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

  47. 0.0001

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

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

  49. 0.0001

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

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

  51. 0.0001

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

  52. 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='73' LIMIT 0,1

  53. 0.0001

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

  54. 0.0001

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

  55. 0.0136

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.2*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.2*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.750339197041 AND ville_latitude_deg<50.649660802959 AND ville_longitude_deg>2.6808481920031 AND ville_longitude_deg<4.0858118079969 HAVING distance <= 50 ORDER BY distance ASC

  56. 0.0034

    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 ('59129','59188','59277','59292','59188','59188','59217','59214','59217','59296','59217','59161','59141','59227','59227','59198','59141','59161','59400','59294','59730','59157','59157','59111','59540','59141','59730','59271','59400','59217','59540','59161','59400','59730','59111','59295','59295','59400','59282','59161','59400','59111','59227','59111','59540','59730','59554','59730','59554','59400','59540','59224','59282','59252','59213','59191','59400','59293','59554','59400','59191','59225','59554','59172','59268','59247','59213','59213','59213','59360','59127','59224','59265','59213','59213','59252','59730','59172','59980','59191','59225','59265','59156','59233','59252','59269','59121','59267','59121','59980','59258','59247','59281','59247','59218','59218','59218','59258','59530','59125','59980','59220','59222','59127','59124','59220','59241','59360','59220','59222','59554','59360','59554','59218','59265','59980','59980','59400','59159','59215','59234','59269','59530','62860','59580','59300','59234','59269','59265','59267','59127','59255','59258','59238','59159','59530','59195','59265','59127','59195','59127','59222','59580','59360','59530','59300','59234','59990','59360','59174','59530','59165','59990','59171','59135','59530','59550','59171','59135','59530','59360','59530','59530','59171','59151','59530','62860','59288','59179','59142','59137','59494','59266','62860','59400','59300','59550','02110','59360','59490','59494','59151','59169','59530','59410','02420','02110','62147','59176','59770','62860','62860','59990','59490','59530','59360','59144','59267','59176','59266','02110','59990','62860','62860','59590','59530','02110','59169','59870','59192','59880','59159','59231','59151','59169','02110','02110','02110','62860','59266','59530','59182','59287','59990','59360','59870','59144','59860','59144','02110','59360','62860','62860','59182','62147','59151','59144','62147','59287','59231','59146','02420','59530','59550','62860','02420','59169','59144','62860','59178','02420','02110','59870','62860','59870','02110','59870','59144','62860','59297','59360','59144','62147','59360','59151','59187','59990','59231','62860','59167','59264','02630','02110','59259','59178','02110','59178','62490','59178','59230','59243','59870','59450','59990','62490','59144','62147','07387','62156','62182','02420','02630','02420','59169','62124','62112','59570','62147','59550','59550','62182','59278','02450','62860','07387','59870','59194','59119','59230','02230','62112','59230','02110','62490','59552','07387','62156','02420','59570','80740','62860','02630','59970','02420','80740','59920','02110','02450','62490','59570','62147','07387','59148','59552','59570','59500','62124','02420','62156','59570','80122','59970','59310','62124','59226','59145','07387','02420','07387','59194','62124','62117','59570','02420','02110','59158','07387','80360','02450','02420','62156','59550','59970','59550','02450','07380','02420','59570','59154','59310','02510','59199','80240','02510','80240','62182','59145','80240','59230','62182','59570','59570','62124','62124','59199','07387','59163','59553','59553','02420','59570','62156','62124','62159','59550','07380','80112','02510','07382','59310','02110','02110','02110','02110','59226','62118','62156','62124','02420','59310','59690','62124','02120','59553','59620','80360','59310','59230','02170','62490','59138','59620','59286','59570','59310','02420','59163','59128','62156','80240','62118','07387','59244','02420','02120','02120','62124','07387','62128','62128','62128','62124','02100','02110','62128','07370','62128','59620','02490','59158','07350','02100','02100','59283','59163','02450','02450','59138','59158','59950','62490','59244','07387','80360','02490','02120','62159','62124','59550','59440','59310','02110','07624','07623','80240','62790','80240','02510','62118','59138','07370','59310','62124','80240','59620','59158','59310','07620','59138','62118','07350','59283','02490','59440','02170','59244','62118','80240','80240','80240','59570','62124','62490','02110','02490','02120','62970','07370','02100','02110','02170','62128','59235','07370','59570','59570','62450','62450','07621','59330','02120','07320','62141','59310','62490','07608','62128','07350','80360','07622','02490','02450','62118','02100','07603','62450','80240','59246','62128','62580','07611','62128','02120','62450','62118','62950','59162','80240','07350','62450','07322','02100','07600','59330','07620','59440','02490','02170','07620','02120','62450','59620','02120','62128','80240','07604','80360','07321','07620','59330','59440','62450','80760','02100','02120','59710','62159','07340','59242','62119','07620','62580','62128','07620','07321','59242','62320','62320','02760','02720','07322','80240','62223','59440','62450','07300','02170','59330','59330','02100','62580','59440','07601','62128','62121','59440','07618','02390','59239','59750','59330','80200','59551','02100','62450','07604','80240','02120','62450','07080','59830','07610','02120','80200','62121','62121','62320','07641','07640','59710','62110','80360','62580','59261','59242','07040','07040','59440','07604','80240','02120','62128','59830','02760','62128','62121','07640','07973','80240','02490','62223','07340','07340','62217','62580','62450','02720','07301','07971','02720','62820','59239','07602','62320','80200','02120','62217','59830','59440','62590','02100','02260','59710','80200','62580','07340','62640','07640','62450','80360','59219','07972','02620','62450','07643','07080','02390','62580','62450','59440','07334','07330','07500','80240','62175','59330','59440','80200','59830','02390','07604','62217','02120','02120','02120','07080','07506','59440','07973','02120','07604','07971','59830','62450','02490','07502','62420','07538','80200','07971','62740','80360','07504','59720','07642','62121','02490','02490','07971','62710','62450','59551','59830','62580','59440','80200','59600','07500','80360','59219','07040','02240','62175','07333','59710','59273','02100','07390','62121','62680','59600','62223','07334','07080','02390','07040','07040','02120','62220','07521','62217','80200','02260','02120','62121','80360','59219','80200','02430','07390','07040','59273','59780','62000','80360','80200','62121','07904','59133','02120','62175','62430','07530','62121','07536','02680','07040','59600','02260','62440','80360','59680','62580','07012','62880','62217','62217','59131','07332','02240','07534','62223','59600','02240','07080','62223','62580','02120','07040','80200','07331','02240','59440','07501','59830','62221','62218','62210','02590','07522','02120','62175','59680','59680','59216','07972','59680','59133','62223','80200','59216','59216','02680','62450','07500','59262','59177','02120','02140','02260','07522','07012','59780','02260','02260','07548','80200','07904','80360','59600','02680','02680','02590','02590','80200','59112','59600','59152','80360','02680','62121','02590','80200','80200','59113','02120','62880','62880','62175','07970','59740','62223','07041','59680','59152','59152','02240','59177','59600','62173','80300','07904','62116','07522','07033','80300','07972','59175','02690','07040','62116','59810','02260','59740','07024','59147','07531','07950','02590','07332','02140','59680','62223','62300','02260','62580','62300','07503','07540','07906','80360','62217','80360','02240','80200','59175','07522','02580','62880','02590','02590','59177','02240','02260','59600','62173','59740','02590','80300','07022','62116','07532','80300','62450','80300','07011','07534','59152','02790','07022','80360','07022','59251','59147','59155','02240','07903','02240','80300','02240','80400','02120','80200','62000','59168','59245','62580','59185','80200','59740','59212','80200','02480','07950','80200','02580','07903','59740','62116','62410','02690','59139','07022','07540','59790','59610','59147','59112','59263','07533','07901','02260','02140','02260','62116','62410','80300','07000','59780','62153','80200','02260','02250','62116','07050','02240','07032','59600','07903','62173','07950','59139','07520','62173','59680','62800','59221','59740','07041') AND fami_id='5' AND cate_id='87' AND type_id='1' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='49' AND wish_id<>'474148' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

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

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

  60. 0.0001

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

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

  64. 0.0001

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

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

  68. 0.0001

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

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

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

  72. 0.0001

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

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

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

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

  76. 0.0001

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

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

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

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

  80. 0.0001

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

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

  82. 0.0001

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

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

  84. 0.0002

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

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

  86. 0.0001

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

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

  88. 0.0002

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

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

  90. 0.0001

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

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

  92. 0.0002

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

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

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

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

  96. 0.0002

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

  97. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 49

  98. 0.0001

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  118. 0.0011

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

  119. 0.0219

    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'

  120. 0.0165

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

120 requetes sql en 0.0713

Taille variable Globale : 85.26 KB