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

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Location injecteur extracteur à 94600 Choisy-le-roi


Location injecteur extracteur : 4 injecteur extracteur injecteur extracteurs à louer entre particuliers à 94600 Choisy-le-roi Louer un injecteur extracteur, aussi appelé shampouineuse. Le nettoyeur injecteur extracteur est un modèle de nettoyeur/aspirateur conçu pour nettoyer la moquette, tapis, canapés, intérieur voiture, ou d’autres meubles. Vous pouvez louer un injecteur extracteur pas cher entre voisins. La location d’un injecteur extracteur se fait souvent à la journée. Karcher est la marque de référence d’aspirateur injecteur extracteur, trouvez des locations d’extracteur injecteur Karcher entre particuliers.
 ... voir la suite
Location injecteur extracteur

Il y a + de 30j

Il y a + de 30j

Injecteur-Extracteur Karcher

25€/jour

19 km · Livry-Gargan
Location injecteur extracteur

Il y a + de 30j

Il y a + de 30j

Shampouineuse kärcher puzzi 8

28€/jour

20 km · L'Île-Saint-Denis
Location injecteur extracteur

Il y a + de 30j

Il y a + de 30j

Location extracteur injecteur

50€/jour

21 km · Corbeil-Essonnes
Location injecteur extracteur

Il y a + de 30j

Il y a + de 30j

Aspirateur injecteur extracteur Bissel

24€/jour

21 km · Jouy-en-Josas
Location injecteur extracteur
3,6/5 résa

Il y a + de 30j

Il y a + de 30j

Location extracteur injecteurs

30€/jour

19 km · Asnieres-sur-Seine
Location injecteur extracteur
3,6/5 résa

Il y a + de 30j

Il y a + de 30j

Injecteur/extracteur

30€/jour

20 km · Collegien

Proposer mon aide

Louer du matériel ou proposer un service

Faire appel à mes voisins

Besoin d'un objet ou d'un service ?
Location injecteur extracteur
3,6/5 résa

Il y a + de 30j

Il y a + de 30j

Location nebulisateur désinfection

30€/jour

20 km · Collégien
<< <
1
2
Demander à louer un materiel de nettoyage ou proposer un materiel de nettoyage en location entre particuliers.
Poster une annonce

   Aspirateur injecteur extracteur    Nettoyeur injecteur extracteur    Injecteur extracteur karcher    Injecteur extracteur voiture    Injecteur extracteur bissell    Injecteur extracteur puzzi    Injecteur extracteur wurth    Injecteur extracteur pro    Injecteur extracteur matelas    Injecteur extracteur moquette
Retour
Fermer

Location › Matériel nettoyage

Lancez votre recherche pour voir les annonces.

Trouver

Trouver
Demandes des voisins

Demandes

 créer une annonce
Messagerie

Messages

 Mon profil

Profil

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wall.php

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

  2. 0.0001

    SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='materiel-nettoyage'

  3. 0

    SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=110

  4. 0.0002

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='94'

  5. 0.0001

    SELECT ville_nom FROM villes WHERE ville_cp='94600' AND ville_nom like '%choisy%le%roi%' ORDER BY ville_population_2012 DESC LIMIT 0,1

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

    SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%injecteur%extracteur%' OR ssrubr_title like '%injecteur%extracteur%' OR ssrubr_slug like '%injecteur%extracteur%') AND cate_id='110' ORDER BY ssrubr_id LIMIT 0,1

  8. 0.0001

    SHOW TABLES LIKE 'pays'

  9. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

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

  11. 0.0001

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

  12. 0.0023

    SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.586835678816 AND ville_latitude_deg<48.946564321184 AND ville_longitude_deg>2.1437867581343 AND ville_longitude_deg<2.6895532418657 HAVING distance <= 20 ORDER BY distance ASC

  13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='extracteur; injecteur extracteur'

  14. 0.0008

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='110'AND MATCH (wish_title,wish_desc) AGAINST ('+extracteur; injecteur extracteur*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '94600%'

  15. 0.0001

    SELECT * FROM texte WHERE cate_id=110

  16. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='extracteur; injecteur extracteur' OR ssrubr_slug='extracteur;-injecteur-extracteur' OR (ssrubr_title like '%extracteur; injecteur extracteur%')) AND cate_id='110' ORDER BY ssrubr_id LIMIT 0,1

  17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='injecteur-extracteur' AND cate_id='110'

  18. 0.0001

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

  19. 0.0021

    SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.586835678816 AND ville_latitude_deg<48.946564321184 AND ville_longitude_deg>2.1437867581343 AND ville_longitude_deg<2.6895532418657 HAVING distance <= 20 ORDER BY distance ASC

  20. 0.0064

    SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.317039197041 AND ville_latitude_deg<49.216360802959 AND ville_longitude_deg>1.7344560125509 AND ville_longitude_deg<3.0988839874491 HAVING distance <= 50 ORDER BY distance ASC

  21. 0.0637

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='110' AND MATCH (wish_desc) AGAINST ('(+extracteur; +injecteur +extracteur*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94600,94600,94400,94390,94310,94320,94140,94290,94700,94000,94460,94190,94550,94380,94800,94150,94480,94220,91200,91560,94205,94200,94450,94410,94233,94234,94231,94232,94236,94237,94238,94230,94239,94235,94240,94340,94270,91550,94110,94340,94210,94100,91320,92340,94160,91270,94470,94260,91230,94430,91330,94250,94380,94370,92160,94130,92120,94500,91210,92220,94300,91260,91800,91420,94880,92260,94880,92330,94490,94440,92240,94360,92320,94440,91300,94120,92290,94170,93170,92350,91370,93100,92170,91160,91380,91170,92140,75015,75016,75017,75018,75012,75020,75116,75014,75019,75013,75001,75000,75002,75003,75005,75004,75006,75007,75008,75009,75010,75011,91860,93110,91600,91390,94350,94520,94520,94420,92130,94440,94510,93330,91800,91360,91130,91000,93230,93310,93260,91350,91450,91160,93360,91360,91120,77170,93130,92360,92190,91480,77340,92100,91140,93250,93160,91160,91480,91570,91160,93500,93000,91000,91090,91430,77150,93140,91700,91450,93220,91700,93460,77380,77184,93400,91700,91250,92370,91430,77150,77420,91140,77185,93340,93320,91080,92310,92210,91070,93300,93120,92200,91620,92110,91240,77170,91250,92150,92800,78140,77680,92410,92300,91280,91310,77127,91220,91220,78350,77330,77186,93370,91310,91310,93350,91090,91400,77500,93150,93700,78220,91620,91400,92600,92400,92380,93200,93210,77173,91100,92420,92430,92250,93190,93390,77200,93450,92390,91250,77090,77183,91440,92270) AND type_id=1 GROUP BY wish_id

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

  23. 0.0001

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

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

  25. 0.0001

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

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

  27. 0.0001

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

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

  29. 0.0001

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

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

  31. 0.0001

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

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

  33. 0.0001

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

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

  35. 0.0001

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

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

  37. 0.0001

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

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

  39. 0.0001

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

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

  41. 0.0001

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

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

  43. 0.0001

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

  44. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 197320 AND W.type_id = 1) OR (W.util_id <> 197320 AND W.type_id = 2)) AND (M.post_util_id = 197320 OR M.dest_util_id = 197320) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  45. 0.0001

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

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

  47. 0.0001

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

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

  49. 0.0001

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

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

  51. 0.0001

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

  52. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 210505 AND W.type_id = 1) OR (W.util_id <> 210505 AND W.type_id = 2)) AND (M.post_util_id = 210505 OR M.dest_util_id = 210505) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  53. 0.0001

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

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

  55. 0.0001

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

  56. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 189552 AND W.type_id = 1) OR (W.util_id <> 189552 AND W.type_id = 2)) AND (M.post_util_id = 189552 OR M.dest_util_id = 189552) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  57. 0.0001

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

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

  59. 0.0001

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

  60. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 273731 AND W.type_id = 1) OR (W.util_id <> 273731 AND W.type_id = 2)) AND (M.post_util_id = 273731 OR M.dest_util_id = 273731) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  61. 0.0001

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

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

  63. 0.0001

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

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

  65. 0.0001

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

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

  67. 0.0001

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

  68. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 305764 AND W.type_id = 1) OR (W.util_id <> 305764 AND W.type_id = 2)) AND (M.post_util_id = 305764 OR M.dest_util_id = 305764) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  69. 0.0001

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

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

  71. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=306863 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 = 271946 AND W.type_id = 1) OR (W.util_id <> 271946 AND W.type_id = 2)) AND (M.post_util_id = 271946 OR M.dest_util_id = 271946) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  73. 0.0001

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

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

  75. 0.0001

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

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

  77. 0.0001

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

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

  79. 0.0001

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

  80. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 322617 AND W.type_id = 1) OR (W.util_id <> 322617 AND W.type_id = 2)) AND (M.post_util_id = 322617 OR M.dest_util_id = 322617) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  81. 0.0001

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

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

  83. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=330921 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 = 332616 AND W.type_id = 1) OR (W.util_id <> 332616 AND W.type_id = 2)) AND (M.post_util_id = 332616 OR M.dest_util_id = 332616) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  85. 0.0001

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

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

  87. 0.0001

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

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

  89. 0.0001

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

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

  91. 0.0001

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

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

  93. 0.0001

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

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

  95. 0.0001

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

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

  97. 0.0001

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

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

  99. 0.0001

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

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

  101. 0.0001

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

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

  103. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=413143 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 = 431305 AND W.type_id = 1) OR (W.util_id <> 431305 AND W.type_id = 2)) AND (M.post_util_id = 431305 OR M.dest_util_id = 431305) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  105. 0.0001

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

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

  107. 0.0001

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

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

  109. 0.0001

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

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

  111. 0.0001

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

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

  113. 0.0001

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

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

  115. 0.0001

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

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

  117. 0.0001

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

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

  119. 0.0001

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

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

  121. 0.0001

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

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

  123. 0.0001

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

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

  125. 0.0001

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

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

  127. 0.0001

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

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

  129. 0.0001

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

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

  131. 0.0001

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

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

  133. 0.0001

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

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

  135. 0.0001

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

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

  137. 0.0001

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

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

  139. 0.0001

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

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

  141. 0.0001

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

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

  143. 0.0001

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

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

  145. 0.0001

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

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

  147. 0.0001

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

  148. 0.0001

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

  149. 0.0022

    SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.586835678816 AND ville_latitude_deg<48.946564321184 AND ville_longitude_deg>2.1437867581343 AND ville_longitude_deg<2.6895532418657 HAVING distance <= 20 ORDER BY distance ASC

  150. 0.0061

    SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.317039197041 AND ville_latitude_deg<49.216360802959 AND ville_longitude_deg>1.7344560125509 AND ville_longitude_deg<3.0988839874491 HAVING distance <= 50 ORDER BY distance ASC

  151. 0.0001

    SELECT ssr.ssrubr_id, ssr.ssrubr_slug, ssr.ssrubr_mail, ssr.ssrubr_mail_bis, ssr.ssrubr_keywords, ssr.ssrubr_bt2, ssr.ssrubr_photo, c.cate_title_slug, f.fami_url 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 IN (1076)

  152. 0.0002

    SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (477926,273731,201491,312098,117081,189758)

  153. 0.0001

    SELECT util_id, util_photo FROM util_info WHERE util_id IN (477926,273731,201491,312098,117081,189758)

  154. 0.0003

    SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=110 AND ss.fami_id=5 ORDER BY ssrubr_order LIMIT 6,100

  155. 0.0002

    SELECT ss.fami_id, fami_url, ss.cate_id, cate_title_slug, keywords_title FROM `ssrubr_keywords` sk, ssrubr ss, category c, family f WHERE sk.ssrubr_id=ss.ssrubr_id AND ss.cate_id=c.cate_id AND c.fami_id=f.fami_id AND (ssrubr_slug='extracteur; injecteur extracteur' OR ssrubr_slug like '%extracteur; injecteur extracteur%' OR MATCH (ssrubr_slug) AGAINST ('(+extracteur; +injecteur +extracteur)')) AND sk.ssrubr_id='1076' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

  156. 0.0001

    SELECT * FROM actu WHERE ssrubr_id='1076' AND actu_niveau=0 ORDER BY actu_ordre DESC

  157. 0.0001

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

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

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

  160. 0.0009

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

  161. 0.0254

    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'

  162. 0.0188

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

162 requetes sql en 0.1486

Taille variable Globale : 133.94 KB