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
25 € / jour
Paiement 100% sécurisé
+33
  • Service client réactif
  • Dépôt remboursé si annulé

Autres annonces du voisin

Tout voir
Location scie sauteuse
5/5 résa

Il y a + de 30j

Il y a + de 30j

Scie sauteuse electrique

13€/jour

La Couture
Location perforateur
5/5 résa

Il y a + de 30j

Il y a + de 30j

Perforateur à louer

25€/jour

La Couture
Service multi services
5/5 résa

Il y a + de 30j

Il y a + de 30j

Service : Multi service

25€/heure

La Couture
Location scie a onglet
5/5 résa

Il y a + de 30j

Il y a + de 30j

Scie a onglet sur table

26€/jour

La Couture
Location perforateur
5/5 résa

Il y a + de 30j

Il y a + de 30j

Perforateur à louer

20€/jour

La Couture
Location carrelette
5/5 résa

Il y a + de 30j

Il y a + de 30j

Carrelette manuel

20€/jour

La Couture
Location leve plaques
5/5 résa

Il y a + de 30j

Il y a + de 30j

Lève plaque à louer

25€/jour

La Couture
Location autres outils
5/5 résa

Il y a + de 30j

Il y a + de 30j

Plateforme individuel

40€/jour

La Couture
Location ponceuse
5/5 résa

Il y a + de 30j

Il y a + de 30j

Ponceuse girafe

30€/jour

La Couture
Location echafaudage
5/5 résa

Il y a + de 30j

Il y a + de 30j

échafaudage

20€/jour

La Couture
Location elagueuse
5/5 résa

Il y a + de 30j

Il y a + de 30j

élagueuse

30€/jour

La Couture
Location taille haie
5/5 résa

Il y a + de 30j

Il y a + de 30j

Taille haie

30€/jour

La Couture
Location autres outils
5/5 résa

Il y a + de 30j

Il y a + de 30j

Pince a emboiture cuivre

15€/jour

La Couture
Location regle de macon
5/5 résa

Il y a + de 30j

Il y a + de 30j

Règle de 3 m

12€/jour

La Couture
Location niveau laser
5/5 résa

Il y a + de 30j

Il y a + de 30j

Niveau laser vert

25€/jour

La Couture
Location tronconneuse
5/5 résa

Il y a + de 30j

Il y a + de 30j

Tronçonneuse

35€/jour

La Couture
Location meuleuse
5/5 résa

Il y a + de 30j

Il y a + de 30j

Grosse meuleuse

15€/jour

La Couture
Location malaxeur
5/5 résa

Il y a + de 30j

Il y a + de 30j

Malaxeur 2 embouts

20€/jour

La Couture
Location scie sabre
5/5 résa

Il y a + de 30j

Il y a + de 30j

Scie sabre

20€/jour

La Couture
Location autres outils
5/5 résa

Il y a + de 30j

Il y a + de 30j

Banjo placo

30€/jour

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

Annonces similaires

Tout voir
Location autres outils

Il y a + de 30j

Il y a + de 30j

Location scie cloche diamant

8€/jour

Faches-Thumesnil
Location autres outils

Il y a + de 30j

Il y a + de 30j

Trancheuse de sol de jardin

100€/jour

Auchy-lez-Orchies
Location autres outils

Il y a + de 30j

Il y a + de 30j

Minipelle location

150€/jour

Allennes-les-Marais
Location autres outils

Il y a + de 30j

Il y a + de 30j

Machine à dénuder le cuivre et l'alu

35€/jour

Lievin
Location autres outils
4,6/5 résa

Il y a + de 30j

Il y a + de 30j

Sangle de serrage a cliquet

3€/jour

5/5 Ronchin
Location autres outils
4,6/5 résa

Il y a + de 30j

Il y a + de 30j

Tendeur pack de 6

2€/jour

5/5 Ronchin
Location autres outils
4,6/5 résa

Il y a + de 30j

Il y a + de 30j

Sangle d'arrimage

2€/jour

5/5 Ronchin
Location autres outils

Il y a + de 30j

Il y a + de 30j

échelle multifonctions

30€/jour

Vieux-Condé
Location autres outils
4,5/5 résa

Il y a + de 30j

Il y a + de 30j

Pince à cheville molly

5€/jour

5/5 Tourcoing
Location autres outils

Il y a + de 30j

Il y a + de 30j

Embouteilleuse

25€/jour

Haveluy

Louer un outil entre particuliers ou proposer un outil 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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci

  2. 0.0001

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

  8. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'autres-outils' 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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('62' USING utf8mb4) COLLATE utf8mb4_general_ci

  11. 0.0001

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

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

  14. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1157 LIMIT 1

  15. 0.0001

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

  16. 0.0001

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

  17. 0.0001

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

  18. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=318960 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 = 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 <> ''

  20. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='318960' 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 = '502947'

  22. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1157

  23. 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='318960' AND wish_id<>'502947' 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='42' 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=318960 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 = 318960

  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='29' 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 = 318960

  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='595' 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 = 318960

  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='41' 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 = 318960

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

  34. 0.0001

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

  35. 0

    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

  36. 0.0001

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

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

  38. 0.0001

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

  39. 0

    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

  40. 0.0002

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

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

  42. 0.0002

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

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

  44. 0.0002

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

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

  46. 0.0001

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

  47. 0

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

  48. 0.0002

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

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

  50. 0.0001

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

  51. 0

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

  52. 0.0001

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

  53. 0

    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

  54. 0.0001

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

  55. 0

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

  56. 0.0001

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

  57. 0

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

  58. 0.0001

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

  59. 0

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

  60. 0.0001

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

  61. 0

    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

  62. 0.0001

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

  63. 0

    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

  64. 0.0001

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

  65. 0

    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 abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 318960

  67. 0.0001

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

  68. 0.0154

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.5833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.5833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.71667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.133639197041 AND ville_latitude_deg<51.032960802959 AND ville_longitude_deg>2.0084860928827 AND ville_longitude_deg<3.4248539071173 HAVING distance <= 50 ORDER BY distance ASC

  69. 0.008

    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 ('62136','62136','62136','62149','62400','62136','62840','62840','62400','59940','59253','62840','62149','62138','62232','62660','62149','62350','59660','62400','59480','62840','59940','59249','59480','62138','62350','62232','62232','62920','62149','62113','62149','62113','62138','59249','59134','62113','59496','62232','62920','62350','59134','62131','62131','62138','62232','62840','62980','59940','62980','62350','59274','62290','62131','59134','59496','62920','62199','59134','62350','62196','62122','62138','62670','62620','62410','59184','59181','62410','59280','59221','62350','62350','59232','59134','59136','59193','62410','59272','59320','62160','62122','62410','62114','59270','59850','62530','62750','59320','59320','59185','59270','62940','62620','59280','62157','59112','62620','62700','59211','62190','62160','59270','59270','62880','62330','62540','62540','59930','59320','59251','59320','62880','62880','62620','62190','59147','59840','07783','59320','62151','62160','59190','62300','62143','62172','62800','59189','59320','62190','59270','62530','59189','59160','59190','59112','59116','59190','62880','59320','62330','59147','59147','59190','07782','62440','62150','62218','62221','62300','08950','62150','62470','59840','62260','62460','59320','62190','59263','59133','62150','59190','59270','62150','62530','62150','08951','62470','62220','59189','62260','59139','62120','62190','59236','62710','62430','59120','62190','62190','62690','08952','62740','62150','62210','59840','62550','62460','62153','62144','59270','62153','62120','08958','62120','59133','62260','62580','62420','62640','62150','62120','59113','08950','59173','59237','62590','62150','62680','62120','62260','62690','59190','59890','59139','59114','59130','08956','62550','62120','59175','59114','08954','62550','62820','08957','62110','59299','62690','62120','62144','59270','59350','59560','59551','62550','59155','07784','62120','62120','62120','59175','59190','62690','62150','62127','62550','59890','62120','62550','59261','62190','62580','62460','62119','62690','62320','59239','59800','59160','59350','59000','59777','62550','08953','62127','62320','59110','62550','59173','59173','59114','62550','62145','62144','59118','07784','08970','62550','59239','62960','62960','62580','62580','62690','59670','62320','62320','62144','59190','62950','62550','59710','62580','62690','59520','62580','59162','62690','59790','62580','62690','62130','62120','62690','59114','62690','62120','59700','59551','62580','08900','62120','59670','59173','62120','62141','62223','07780','07780','62970','62550','62145','59810','08902','59370','59670','62144','59260','62690','62580','07781','62127','62960','62550','62690','08902','59670','62127','62490','59710','62120','62580','59560','62580','59246','59273','62161','62161','62134','62223','59710','59173','62120','62550','62790','59283','59710','59910','59950','62223','08970','59670','62690','62580','62130','62120','59670','62145','62127','62490','59670','62127','62127','59223','59250','59126','62960','59283','62120','62130','62550','08908','59117','62690','59670','59128','62130','59670','08978','62129','08902','08940','62145','62161','08980','62490','62223','62161','62223','59262','59273','59286','62129','59170','59290','59655','59491','59493','59650','62123','62223','08900','62127','59553','59420','62134','59310','59242','62123','62123','62127','62690','59553','59553','62130','62123','62223','59235','59242','62127','59670','59166','62960','59830','08900','62134','62130','62134','62575','62000','62127','59510','62129','62960','62123','59670','62490','62810','62118','62000','62130','59200','08900','08980','62130','59152','59152','62960','62129','62118','59670','62134','08906','59100','08972','59830','62134','59470','62127','62118','62810','59500','62960','62810','62223','62510','59194','59510','59285','62117','62575','62810','62130','59552','62130','62127','59152','59830','62570','62217','62217','62123','62134','59152','62123','62217','08640','62118','59552','62127','59960','59470','62500','08940','59242','59470','62810','62130','62130','62217','62123','59310','62134','62130','59119','62129','62118','08904','62134','59285','62118','59390','62112','59390','59390','62127','62134','62134','62130','08980','62129','59830','62810','62810','59194','59780','08972','62570','59470','62570','59450','62130','62490','08930','59169','62130','59310','59148','62810','08980','08640','62118','62130','59150','59390','59780','62560','59780','59830','62560','59470','62217','62500','59143','62810','08972','62130','62134','62112','62130','62219','59285','08904','62130','59122','62217','62270','62380','62310','62310','62570','62123','07712','08640','62134','62810','62380','62310','59187','62128','62810','08930','59310','62500','59310','59167','62270','59470','59830','62130','62310','62156','62810','62128','07700','62173','62490','62810','08640','62173','62310','59830','62134','62123','62123','59115','62130','62310','62219','08920','62490','62270','62217','62123','62130','62134','59470','08920','62500','62380','62128','08560','08691','62310','08920','07730','62380','62130','62810','62156','08890','59143','62560','59151','59380','62128','62156','59287','59169','62490','62810','07520','62128','62158','62560','62310','59470','62156','07522','07700','62130','62130','62156','62810','08930','07522','59310','07730','59143','62173','62130','62173','62560','08647','08920','62500','59122','62156','59287','59182','59470','59182','07730','62123','62175','08980','59870','62310','62310','62128','62123','59169','62128','59470','07502','62310','62270','59310','62270','07611','07610','62500','59259','07522','59146','59380','62380','08647','62130','62810','59870','62310','08880','62130','62130','08890','62310','08511','08650','62500','59151','08560','62270','62270','59169','08647','62158','62560','59310','62380','62380','62380','62175','59380','07730','62175','59310','59380','62810','62156','07522','62810','62175','62130','62130','62175','62770','62130','59176','59151','62123','59143','62270','07730','62770','62380','08647','62128','62128','62310','07504','62158','62860','62310','08510','59169','07730','62560','62310','08691','62158','59470','62910','62910','62270','62810','08691','62310','08880','59470','59176','08840','62310','59122','62860','59151','62270','62182','62500','08510','08690','62770','08647','62128','59143','59380','07730','07618','07711','62500','62270','07520','62860','59870','62116','62860','62860','62121','62111','62270','07501','62560','07506','59490','62770','59870','62770','62270','59143','08501','08560','62810','62310','59310','59690','62121','59630','08691','08510','62182','07503','62111','62270','07740','62158','59380','62182','59122','62128','62158','07743','62770','59870','62910','59234','62182','62158','62770','08691','62910','62560','08690','59151','59165','07500','07624','59230','59226','08880','80600','62770','08840','07620','62116','62116','08501','62760','07740','62380','07743','62380','62121','62310','62910','62860','08600','62128','62128','59178','62111','62270','08510','59490','62111','59580','08650','59143','62270','59380','59380','62380','62121','59380','59870','62860','80600','62380','59230','62560','08500','62500','59284','59870','62270','59234','07742','62860','59265','62760','08587','07500','59380','80600','07620','08690','62810','08600','62770','62770','59179','59178','59234','62270','08650','07621','07500','59580','08630','62860','62770','62860','08630','62116','08600','08630','59492','62270','08840','62560','07623','62860','62860','07540','08800','62310','62128','07620','62910','62890','08587','59630','07620','62760','62760','59171','62310','59265','08600','07542','62770','08690','62770','80600','62380','62159','62390','62860','62111','62140','62650','08800','08554','62770','59122','62760','59630','62270','62890','07521','08520','62770','59215','08860','62770','07620','62770','59171','08587','62380','62760','62270','59247') AND fami_id='5' AND cate_id='87' AND type_id='1' AND ssrubr_id='1157' AND wish_id<>'502947' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  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='1157' 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=545384 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 = 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 <> ''

  73. 0.0001

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

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

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

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

  81. 0.0002

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

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

  83. 0.0001

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

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

  85. 0.0002

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

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

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

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

  89. 0.0002

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

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

  91. 0.0002

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

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

  93. 0.0002

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

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

  95. 0.0001

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

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

  97. 0.0002

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

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

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

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

  101. 0.0001

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

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

  103. 0.0001

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

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

  105. 0.0002

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

  106. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1157

  107. 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  127. 0.0009

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

  128. 0.0238

    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'

  129. 0.0203

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

129 requetes sql en 0.084

Taille variable Globale : 83.4 KB