Service garde d'enfants à 95500 Le thillay

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='3' AND cate_title_slug='babysitting'

3. 0

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

4. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('95' USING utf8mb4) COLLATE utf8mb4_general_ci

5. 0.0001

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

6. 0.0004

   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 ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%garde%enfants%' OR ssrubr_title like '%garde%enfants%' OR ssrubr_slug like '%garde%enfants%') AND cate_id='39' 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='95500'

12. 0.0025

    SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.48333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.820135678816 AND ville_latitude_deg<49.179864321184 AND ville_longitude_deg>2.209170802952 AND ville_longitude_deg<2.757489197048 HAVING distance <= 20 ORDER BY distance ASC

13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='garde enfant; garde enfants'

14. 0.0046

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='39' AND ssrubr_id='1008' AND wish_visu IN (1,6,10) AND wish_cp like '95500%'

15. 0.0001

    SELECT * FROM texte WHERE cate_id=39

16. 0.0001

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='garde enfant; garde enfants' OR ssrubr_slug='garde-enfant;-garde-enfants' OR (ssrubr_title like '%garde enfant; garde enfants%')) AND cate_id='39' ORDER BY ssrubr_id LIMIT 0,1

17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='garde-enfants' AND cate_id='39'

18. 0.0001

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

19. 0.002

    SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.48333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.820135678816 AND ville_latitude_deg<49.179864321184 AND ville_longitude_deg>2.209170802952 AND ville_longitude_deg<2.757489197048 HAVING distance <= 20 ORDER BY distance ASC

20. 0.0137

    SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.48333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.550339197041 AND ville_latitude_deg<49.449660802959 AND ville_longitude_deg>1.7979260970883 AND ville_longitude_deg<3.1687339029117 HAVING distance <= 50 ORDER BY distance ASC

21. 0.0097

    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((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.48333- 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='3' AND cate_id='39' AND ssrubr_id='1008' AND wish_visu IN (1,6,10) AND wish_cp IN (95500,95500,95500,95190,95700,95500,95380,95720,93420,95500,95400,93600,95190,95380,95140,95720,95380,95400,95200,95380,93440,95380,95440,95190,93700,93150,77990,95720,95850,93270,93290,95350,77990,93350,93240,95460,93380,95670,95850,95720,93410,95470,95350,95410,77290,95360,93390,93190,95270,95160,95470,95170,95470,95270,93140,77230,95570,77230,93430,93320,95270,93340,95270,93000,95330,77230,93210,93200,93120,93470,93300,77181,95270,95470,77270,95570,95570,93500,93370,95880,93130,93250,92390,93450,60128,95580,95580,77290,77181,93230,95270,93260,93220,95230,77230,95270,77410,93800,95560,95270,93310,95570,77230,95600,95680,95270,93110,93360,60560,95210,95218,60520,93100,95560,95560,77410,92230,60128,77500,93170,77230,93400,77230,95390,77410,95120,93460,77230,77410,94120,60580,94170,95560,77410,77177,60260,94300,93330,95270,77230,95320,95590,77280,60520,92110,95110,92600,95270,93160,95840,95100,60520,95130,60330,60950,95130,92270,77230,92300,95270,94130,77230,75005,75116,75001,75000,75002,75003,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75010,75004,75009,75008,75007,75006,95590,94360,77420,94350,94160,77360,77410,92700,77400,95840,77230,77410,95150,95550,95590,77186) AND type_id=1 GROUP BY wish_id

22. 0.0005

    SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (4136,4253,5584,7702,8550,9150,9359,10897,14698,15701,21328,28735,36186,36348,40550,46253,46390,47846,48180,46895,50716,51367,51888,53846,25213,58216,61345,61412,64751,64791,65361,65381,65520,67955,68409,61639,64383,70515,68272,71895,72386,72754,72836,73648,74267,75024,75192,76942,42843,79516,79854,79910,5320,81351,82252,83065,83280,84618,86547,88621,91834,95294,93688,95199,98373,100625,103710,103970,109922,110779,112191,113188,113505,114306,114606,116006,117237,118498,114380,120155,120807,121735,122446,123019,123630,115154,124383,121081,125768,8995,126887,126848,129009,131446,115251,134505,137836,139767,140668,141090,141426,143790,146878,109273,147908,149125,136070,137393,149720,153162,30781,153725,154518,111734,151842,159989,160563,163134,164105,164850,165668,91689,174021,171708,176796,177027,178012,117002,185957,177838,191320,192694,136700,195581,91274,197030,90089,197923,147176,201214,203548,200258,207211,211039,212839,189788,220475,220738,220486,222156,227426,229009,233225,229985,231698,243850,246212,247332,251914,252254,255751,173620,257881,27630,264646,264671,224548,271608,273111,282576,292135,292626,300421,296699,308699,307166,315985,322412,322463,341635,344364,344994,153202,182005,376971,380504,215853,387040,397301,401362,406342,180294,408673,418553,422039,435535,469661,471579,312234,479186,480275,483053,486331,482876,507625,18479,524290,541762,327800,546142)

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

24. 0.0001

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

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

26. 0.0001

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

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

28. 0.0001

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

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

30. 0.0001

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

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

32. 0.0001

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

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

34. 0.0001

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

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

36. 0.0001

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

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

38. 0.0001

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

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

40. 0.0001

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

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

42. 0.0001

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

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

44. 0.0001

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

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

46. 0.0001

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

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

48. 0.0001

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

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

50. 0.0001

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

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

52. 0.0001

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

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

54. 0.0001

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

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

56. 0.0001

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

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

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

66. 0.0001

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

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

68. 0.0001

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

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

70. 0.0001

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

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

72. 0.0001

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

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

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

82. 0.0001

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

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

84. 0.0001

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

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

86. 0.0001

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

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

88. 0.0001

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

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

90. 0.0001

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

91. 0.0001

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

92. 0.0001

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

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

94. 0.0001

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

95. 0.0001

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

96. 0.0001

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

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

98. 0.0001

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

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

100. 0.0001

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

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

102. 0.0001

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

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

104. 0.0001

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

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

106. 0.0001

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

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

108. 0.0001

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

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

110. 0.0001

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

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

112. 0.0001

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

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

114. 0.0001

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

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

116. 0.0001

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

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

118. 0.0001

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

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

120. 0.0001

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

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

122. 0.0001

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

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

124. 0.0001

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

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

126. 0.0001

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

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

128. 0.0001

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

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

130. 0.0001

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

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

132. 0.0001

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

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

134. 0.0001

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

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

136. 0.0001

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

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

138. 0.0001

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

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

140. 0.0001

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

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

142. 0.0001

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

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

144. 0.0001

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

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

146. 0.0001

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

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

148. 0.0001

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

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

150. 0.0001

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

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

152. 0.0001

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

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

154. 0.0001

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

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

156. 0.0001

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

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

158. 0.0001

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

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

160. 0.0001

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

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

162. 0.0001

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

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

164. 0.0001

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

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

166. 0.0001

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

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

168. 0.0001

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

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

170. 0.0001

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

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

172. 0.0001

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

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

174. 0.0001

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

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

176. 0.0001

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

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

178. 0.0001

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

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

180. 0.0001

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

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

182. 0.0001

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

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

184. 0.0001

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

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

186. 0.0001

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

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

188. 0.0001

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

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

190. 0.0001

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

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

192. 0.0001

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

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

194. 0.0001

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

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

196. 0.0001

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

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

198. 0.0001

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

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

200. 0.0001

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

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

202. 0.0001

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

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

204. 0.0001

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

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

206. 0.0001

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

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

208. 0.0001

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

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

210. 0.0001

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

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

212. 0.0001

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

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

214. 0.0001

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

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

216. 0.0001

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

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

218. 0.0001

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

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

220. 0.0001

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

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

222. 0.0001

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

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

224. 0.0001

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

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

226. 0.0001

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

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

228. 0.0001

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

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

230. 0.0001

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

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

232. 0.0001

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

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

234. 0.0001

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

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

236. 0.0001

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

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

238. 0.0001

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

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

240. 0.0001

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

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

242. 0.0001

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

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

244. 0.0001

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

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

246. 0.0001

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

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

248. 0.0001

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

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

250. 0.0001

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

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

252. 0.0001

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

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

254. 0.0001

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

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

256. 0.0001

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

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

258. 0.0001

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

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

260. 0.0001

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

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

262. 0.0001

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

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

264. 0.0001

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

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

266. 0.0001

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

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

268. 0.0001

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

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

270. 0.0001

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

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

272. 0.0001

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

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

274. 0.0001

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

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

276. 0.0001

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

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

278. 0.0001

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

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

280. 0.0001

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

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

282. 0.0001

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

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

284. 0.0001

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

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

286. 0.0001

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

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

288. 0.0001

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

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

290. 0.0001

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

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

292. 0.0001

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

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

294. 0.0001

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

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

296. 0.0001

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

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

298. 0.0001

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

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

300. 0.0001

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

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

302. 0.0001

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

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

304. 0.0001

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

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

306. 0.0001

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

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

308. 0.0001

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

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

310. 0.0001

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

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

312. 0.0001

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

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

314. 0.0001

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

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

316. 0.0001

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

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

318. 0.0001

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

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

320. 0.0001

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

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

322. 0.0001

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

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

324. 0.0001

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

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

326. 0.0001

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

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

328. 0.0001

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

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

330. 0.0001

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

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

332. 0.0001

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

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

334. 0.0001

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

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

336. 0.0001

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

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

338. 0.0001

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

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

340. 0.0001

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

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

342. 0.0001

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

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

344. 0.0001

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

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

346. 0.0001

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

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

348. 0.0001

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

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

350. 0.0001

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

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

352. 0.0001

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

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

354. 0.0001

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

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

356. 0.0001

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

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

358. 0.0001

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

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

360. 0.0001

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

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

362. 0.0001

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

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

364. 0.0001

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

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

366. 0.0001

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

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

368. 0.0001

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

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

370. 0.0001

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

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

372. 0.0001

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

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

374. 0.0001

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

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

376. 0.0001

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

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

378. 0.0001

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

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

380. 0.0001

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

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

382. 0.0001

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

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

384. 0.0001

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

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

386. 0.0001

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

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

388. 0.0001

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

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

390. 0.0001

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

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

392. 0.0001

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

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

394. 0.0001

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

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

396. 0.0001

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

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

398. 0.0001

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

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

400. 0.0001

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

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

402. 0.0001

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

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

404. 0.0001

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

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

406. 0.0001

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

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

408. 0.0001

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

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

410. 0.0001

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

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

412. 0.0001

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

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

414. 0.0001

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

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

416. 0.0001

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

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

418. 0.0001

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

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

420. 0.0001

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

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

422. 0.0001

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

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

424. 0.0001

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

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

426. 0.0001

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

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

428. 0.0001

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

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

430. 0.0001

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

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

432. 0.0001

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

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

434. 0.0001

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

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

436. 0.0001

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

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

438. 0.0001

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

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

440. 0.0001

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

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

442. 0.0001

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

443. 0.0001

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

444. 0.0021

     SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.48333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.820135678816 AND ville_latitude_deg<49.179864321184 AND ville_longitude_deg>2.209170802952 AND ville_longitude_deg<2.757489197048 HAVING distance <= 20 ORDER BY distance ASC

445. 0.0144

     SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.48333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.550339197041 AND ville_latitude_deg<49.449660802959 AND ville_longitude_deg>1.7979260970883 AND ville_longitude_deg<3.1687339029117 HAVING distance <= 50 ORDER BY distance ASC

446. 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 (1008)

447. 0.0002

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (149720,146878,131446,126848,116006,114306,113188,103710,95294,83065,79910,79854,75192,75024,67955,65520,65381,58216,53846,51888,51367,46895,36348,21328,9359,5584,4253,4136,61412,435535,327800,541762,123019,112191,74267,134505,243850)

448. 0.0001

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (149720,146878,131446,126848,116006,114306,113188,103710,95294,83065,79910,79854,75192,75024,67955,65520,65381,58216,53846,51888,51367,46895,36348,21328,9359,5584,4253,4136,61412,435535,327800,541762,123019,112191,74267,134505,243850)

449. 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='garde enfant; garde enfants' OR ssrubr_slug like '%garde enfant; garde enfants%' OR MATCH (ssrubr_slug) AGAINST ('(+garde +enfant; +garde +enfants)')) AND sk.ssrubr_id='1008' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

450. 0.0001

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

451. 0.0001

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

452. 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='3' AND cate_cate_id IS NULL ORDER BY cate_order ASC

453. 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 (39) ORDER BY ssrubr_order ASC

454. 0.0009

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

455. 0.0256

     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'

456. 0.017

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

456 requetes sql en 0.1387