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

Il y a + de 30j

Il y a + de 30j

Scie circulaire Bosch

20€/jour

Banvillars
Location betonniere

Il y a + de 30j

Il y a + de 30j

Bétonnière parfaite état

30€/jour

Banvillars
Location niveau laser

Il y a + de 30j

Il y a + de 30j

Niveau optique de chantier

25€/jour

Banvillars

Annonces similaires

Tout voir
Location pince a sertir

Il y a + de 30j

Il y a + de 30j

Pince a sertir le muuticouche

20€/jour

L'Isle-sur-le-Doubs

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

    SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC

  5. 0.0001

    SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL

  6. 0.0006

    SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''

  7. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='471330'

  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

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

  11. 0.0001

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

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

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

  16. 0.0001

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

  18. 0

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

  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='303666' AND wish_id<>'471330' 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='33' 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=303666 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 = 303666

  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='73' 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 = 303666

  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='53' 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 = 303666

  30. 0.0001

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

  31. 0.0078

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.6167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.6167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.78333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.167039197041 AND ville_latitude_deg<48.066360802959 AND ville_longitude_deg>6.1162568506243 AND ville_longitude_deg<7.4504031493757 HAVING distance <= 50 ORDER BY distance ASC

  32. 0.0044

    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 ('90800','70400','70400','70400','90800','90850','90800','90800','70400','90850','70400','70400','70400','70400','90300','90400','70400','90400','70400','70400','90400','90400','90000','90400','90350','70400','90400','70400','90300','90700','70400','70400','70400','90400','25550','70400','70400','70400','90400','90160','90400','90300','25750','25200','90300','90300','25750','25600','25750','90300','25550','25200','70400','90340','90400','90300','25550','25600','90160','25600','25200','70400','25550','90380','90140','70400','25600','90330','70290','25600','70200','90160','25550','25550','70400','70290','70200','90340','90150','90150','90140','70400','25750','25490','90200','25420','25630','25550','90200','90140','90120','25550','25400','70250','90120','70200','90150','90140','90340','90200','25400','25490','25750','70200','70200','90140','25113','25460','90170','90170','90150','90200','25420','70200','70200','90130','25400','90200','25550','25400','90170','70200','70200','90150','90110','90150','90600','90200','25260','70400','90140','90130','90150','90150','90130','25490','70400','90110','70200','90150','25420','90200','25420','70290','25700','25420','90150','90150','70400','90100','25490','70270','25230','25260','70200','90110','25250','90110','25250','25230','70400','70200','70400','90500','25250','90100','90200','25260','70200','90100','90100','25350','25250','70200','90100','90100','68210','68210','70200','68210','25230','90110','70290','25230','25250','90170','25250','90500','90150','25260','90150','90110','68210','70110','90150','70110','90100','25700','90360','70110','68210','90360','70200','25150','90100','70270','70200','70270','25260','70270','90100','68210','70110','90100','90100','25310','70200','90100','70110','70110','68210','70270','70270','25250','68210','25260','02926','68290','25150','90100','25250','25250','70200','68210','70200','70440','25310','70200','68210','25310','25250','70110','68290','68290','25250','25310','25150','68210','68780','70200','90100','68290','70440','25310','68210','70110','70110','68210','68210','70110','68290','25250','68780','68290','68290','25250','70110','02925','25150','68210','68210','68290','25250','68290','90100','68780','70110','90100','25250','68210','70200','68210','68210','68780','70110','90100','25310','70200','70110','25250','02924','02916','68780','02915','90100','70440','70110','90100','25150','70200','68780','25150','70110','70270','25150','25250','68210','68210','25250','25310','68580','68210','02923','25250','25250','68780','70110','68580','70200','68116','25150','70200','68290','25310','68210','68210','70110','25150','25310','02908','70270','68210','02933','68210','68290','68210','70110','88560','88160','25250','70200','02922','68580','25150','68290','90370','25340','25250','70270','70200','70110','25310','02933','70200','70310','70310','68210','70110','02907','02914','68210','70200','68800','02905','70200','88160','68210','68800','70300','02906','02912','88540','02935','68210','25190','25190','25190','25190','68580','68580','02932','25340','25190','25190','25340','68700','70300','70310','70110','70110','25190','68520','25680','25680','70240','68720','70310','68580','88160','70310','25340','02900','02900','02900','70200','70110','68520','88160','02912','70110','25190','25190','68470','25340','68800','25680','70310','25190','25340','68210','70240','70300','25190','25190','68480','68800','88360','25340','68720','70110','68580','70200','70280','68700','70310','02944','68700','25340','68470','68121','68470','25430','02904','70300','25340','25680','68130','70110','70240','70110','68118','70110','25430','70310','68520','25340','02902','25190','70280','68620','70240','02943','70310','25340','02942','68800','70310','68470','25340','68720','70240','25190','70300','25190','68550','68690','25190','68990','70280','68580','25190','68130','68720','02903','70280','25190','70280','68760','25680','68470','68550','25190','68580','25340','25430','25470','68470','68130','25680','70000','25340','68560','70310','25340','25190','25190','68700','70300','70300','70240','68720','25190','68560','02950','70230','25470','70300','02946','70240','25680','88310','25190','25340','25470','25430','70310','25430','25430','68990','70240','25680','70300','02889','70000','25680','88360','68700','68700','68480','25110','68720','68130','68690','68830','25430','68720','70240','68560','68950','70300','70240','68720','68720','02952','02888','88290','02950','25470','25340','25380','68760','70300','70300','25680','70230','68480','25470','68640','25680','68480','68130','25470','70240','68560','68480','68820','25430','25110','70240','70240','70300','68480','25380','70000','68640','25110','25110','25430','02953','25110','25470','25680','25380','68480','02947','68700','70300','70300','68130','68130','68130','70240','25680','68720','25430','25120','25120','02886','68720','25120','88310','88290','68790','25380','68960','68960','70230','02887','02882','02882','70300','25120','25680','70300','25430','25680','68480','25110','25380','25470','25470','02953','68480','68130','02885','70000','02884','68130','68960','88340','68350','70230','68480','68960','02954','70300','25680','25110','25110','25680','02353','70300','68640','25120','70240','88120','25470','68480','02807','88340','68460','70300','68480','68720','02354','25110','70230','70240','70220','25380','25380','68130','68130','02363','02362','70000','68850','68310','25380','68350','25450','25680','68500','25110','25680','02883','25380','68500','68120','68480','68480','68500','70230','88200','68480','25470','70000','25110','70800','68130','25430','68130','70000','70240','68500','02364','70230','68440','70000','68120','25120','70230','68500','68820','25110','68640','88120','25360','88250','25110','02803','68480','25530','02857','68500','70240','02807','68480','25110','25680','02360','02856','68130','02362','68200','68100','88200','68130','25380','25470','25680','68610','70230','68510','70000','68480','68530','02338','70300','25110','70000','02855','68440','25510','70300','88120','25140','25140','88120','25140','25380','68540','68610','25210','68440','25640','88120','68360','88370','02350','70230','02873','70000','70000','68510','68480','70240','88120','70000','68510','70000','25380','68110','68130','70230','68640','25360','70320','70800','70800','68440','68500','68480','02338','70800','25640','02718','25110','02813','25640','70000','25380','68260','70320','68610','68400','70160','68530','02340','68510','70000','70000','68440','70230','70000','70230','25210','02854','02718','68380','02714','68840','68220','68540','25640','02802','25640','25210','68270','70000','68440','68480','68480','68380','70160','25110','70230','25640','88200','02812','25360','88120','70160','25110','25530','70230','02717','70320','68480','68390','68510','68440','68510','25110','02345','70230','70800','68510','68220','68190','25640','25360','68510','70000','02806','25510','70000','02863','25530','70160','02814','68500','02717','88200','02714','68480','68640','25110','68390','70800','68500','68480','70230','68440','02722','25360','02713','02345','68500','70800','70000','68510','68500','70000','25640','02715','68510','70000','70800','88120','25110','68220','68170','02853','68440','70800','70190','68480','25210','25210','25530','68380','68480','02800','02800','70000','25110','02715','02336','25530','25510','02800','70800','68190','70800','70190','02720','25210','68270','70170','68870') AND fami_id='5' AND cate_id='87' AND type_id='1' AND ssrubr_id='49' AND wish_id<>'471330' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

  34. 0.0001

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

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

  36. 0.0002

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

  37. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 49

  38. 0.0001

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

  39. 0.0002

    SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  58. 0.0009

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

  59. 0.0304

    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'

  60. 0.0207

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

60 requetes sql en 0.0724

Taille variable Globale : 76.63 KB