Service repassage à 92340 Bourg-la-reine

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='menage-repassage'

3. 0

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

4. 0.0001

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

5. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='92340' AND ville_nom like '%bourg%la%reine%' ORDER BY ville_population_2012 DESC LIMIT 0,1

6. 0.0005

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

7. 0.0001

   SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%repassage%' OR ssrubr_title like '%repassage%' OR ssrubr_slug like '%repassage%') AND cate_id='47' 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.0002

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

11. 0.0001

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

12. 0.0025

    SELECT ville_cp, ROUND((((acos(sin((48.775*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.775*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.595135678816 AND ville_latitude_deg<48.954864321184 AND ville_longitude_deg>2.0437416454043 AND ville_longitude_deg<2.5895983545957 HAVING distance <= 20 ORDER BY distance ASC

13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='repassage'

14. 0.0003

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='47'AND MATCH (wish_title,wish_desc) AGAINST ('+repassage*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '92340%'

15. 0.0001

    SELECT * FROM texte WHERE cate_id=47

16. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='repassage' OR ssrubr_slug='repassage' OR (ssrubr_title like '%repassage%')) AND cate_id='47' ORDER BY ssrubr_id LIMIT 0,1

17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='repassage' AND cate_id='47'

18. 0.0001

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

19. 0.0021

    SELECT ville_cp, ROUND((((acos(sin((48.775*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.775*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.595135678816 AND ville_latitude_deg<48.954864321184 AND ville_longitude_deg>2.0437416454043 AND ville_longitude_deg<2.5895983545957 HAVING distance <= 20 ORDER BY distance ASC

20. 0.006

    SELECT ville_cp, ROUND((((acos(sin((48.775*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.775*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.325339197041 AND ville_latitude_deg<49.224660802959 AND ville_longitude_deg>1.6343432297533 AND ville_longitude_deg<2.9989967702467 HAVING distance <= 50 ORDER BY distance ASC

21. 0.0589

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.775*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.775*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- 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='47' AND MATCH (wish_desc) AGAINST ('(+repassage*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (92340,92340,94231,94235,94234,94233,94236,94232,94230,94240,94237,94238,94239,94550,92260,92330,94260,92160,94110,92220,94150,92320,92290,92350,91370,92140,94800,92120,92240,91320,94250,94320,91300,92130,94270,94400,92170,92360,92190,94310,94390,94200,94205,94600,91550,94140,91570,91120,92100,91380,91420,91160,91430,94290,94220,91200,92370,94700,91160,75018,75002,75019,75006,75003,75004,75005,75000,75001,75007,75008,75012,75013,75014,75009,75015,75016,75010,75017,75011,75116,91140,75020,92310,91430,94160,94480,78140,92210,92410,94190,91160,94000,78350,91270,91260,78220,94460,94410,91560,92800,92150,91140,91400,94340,94300,91360,91360,92430,92420,94380,92380,91160,91600,91390,93170,91210,92200,91400,91230,91170,94450,93100,78350,78530,93310,94100,94210,94340,78000,91440,94130,93400,91700,92110,92300,91620,92400,92250,91350,93230,92500,93260,78170,94120,94430,91330,91190,94470,78117,91940,78150,93500,91620,92600,94500,91000,91130,91240,94170,91700,91800,93110,94370,94380,91310,94360,78150,91190,92270,91310,91310,91700,93130,91940,92000,92700,93300,93120,78117,78290,78380,91940,91190,91460,93000,91450,94880,94880,94490,78400,94440,91220,91220,92390,92230,93450,93140,94440,93360,78430,91860,93200,93210,93330,78800,93250,91070,91310,94350,78280,91640,78210,78420,91090,91000,91080,91800,94420,78114,78560,91400,78870,78470,94520,94520,95870,93350,91450,94440,93800,94510,78960,78160,93220,78360,91480) AND type_id=1 GROUP BY wish_id

22. 0.0008

    SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (1552,4916,5765,9777,9925,10614,11251,11896,13248,13596,13601,2264,21545,23562,24880,24635,25938,27149,29847,30152,32965,35401,36893,41154,42843,43778,40966,45014,45894,47068,47639,45392,50684,51184,51395,51759,53432,53899,53987,53981,54188,55012,55295,55735,56400,56508,57204,58744,59239,59386,59877,61397,61696,62769,63119,64943,65523,65857,65969,68398,38611,69727,70129,30035,70581,70910,70960,71124,71965,73272,73841,74183,76579,78823,80822,80912,81547,60060,78833,85929,85846,86418,87590,87607,87740,88222,88692,23252,89704,90797,91339,61886,90903,91874,92837,93679,93890,95897,97352,97440,98338,99675,101007,102419,103393,103964,108231,108236,111200,112193,113016,113472,113485,113483,113952,114579,115638,115649,115791,115985,117569,118354,118402,118494,118737,118979,119463,119767,120154,120466,120858,83419,121091,121634,122463,122749,123348,123481,124263,123903,124747,125934,126313,128695,115138,131116,131132,131446,62335,131668,80888,134172,135052,135558,136423,137233,137518,139976,141268,141556,142333,141577,146132,146877,149858,153162,153506,155611,157120,157315,158139,158368,158463,160211,160904,163154,163134,74643,166546,168912,170398,170630,165797,171813,176768,71629,190572,191513,189806,192799,194344,197894,199483,200147,120876,202321,203656,204697,204977,207514,211959,198010,58981,215104,216425,216486,218551,225666,226802,228740,229249,225518,231821,112803,232215,233776,232778,240080,240429,101688,126285,231698,228239,250275,251304,253563,237790,257529,25728,112841,123164,272095,272279,280690,277299,284616,286187,288328,288402,295026,295186,296712,296775,297315,292890,305242,307874,308240,308809,309719,315013,220713,319332,103885,321885,323726,330264,334350,98335,342852,339565,339683,344836,346040,361806,366117,117010,375727,377099,69184,386358,397905,398042,401116,224299,103464,307144,213223,408673,346501,412811,413145,414020,415697,417117,285040,429176,96128,440882,436636,453206,320256,37102,464232,194599,466501,470399,475962,351051,478971,60763,481881,482956,487414,487544,489747,495694,60754,501104,146449,387752,515219,454849,523471,269695,477885,187823,544809,545809,494474,548803)

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 = 1552 AND W.type_id = 1) OR (W.util_id <> 1552 AND W.type_id = 2)) AND (M.post_util_id = 1552 OR M.dest_util_id = 1552) 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=1552 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 = 4916 AND W.type_id = 1) OR (W.util_id <> 4916 AND W.type_id = 2)) AND (M.post_util_id = 4916 OR M.dest_util_id = 4916) 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=4916 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 = 5765 AND W.type_id = 1) OR (W.util_id <> 5765 AND W.type_id = 2)) AND (M.post_util_id = 5765 OR M.dest_util_id = 5765) 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=5765 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 = 9777 AND W.type_id = 1) OR (W.util_id <> 9777 AND W.type_id = 2)) AND (M.post_util_id = 9777 OR M.dest_util_id = 9777) 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=9777 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 = 9925 AND W.type_id = 1) OR (W.util_id <> 9925 AND W.type_id = 2)) AND (M.post_util_id = 9925 OR M.dest_util_id = 9925) 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=9925 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 = 10614 AND W.type_id = 1) OR (W.util_id <> 10614 AND W.type_id = 2)) AND (M.post_util_id = 10614 OR M.dest_util_id = 10614) 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=10614 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 = 11251 AND W.type_id = 1) OR (W.util_id <> 11251 AND W.type_id = 2)) AND (M.post_util_id = 11251 OR M.dest_util_id = 11251) 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=11251 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 = 11896 AND W.type_id = 1) OR (W.util_id <> 11896 AND W.type_id = 2)) AND (M.post_util_id = 11896 OR M.dest_util_id = 11896) 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=11896 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 = 13248 AND W.type_id = 1) OR (W.util_id <> 13248 AND W.type_id = 2)) AND (M.post_util_id = 13248 OR M.dest_util_id = 13248) 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=13248 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 = 13596 AND W.type_id = 1) OR (W.util_id <> 13596 AND W.type_id = 2)) AND (M.post_util_id = 13596 OR M.dest_util_id = 13596) 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=13596 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 = 13601 AND W.type_id = 1) OR (W.util_id <> 13601 AND W.type_id = 2)) AND (M.post_util_id = 13601 OR M.dest_util_id = 13601) 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=13601 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 = 2264 AND W.type_id = 1) OR (W.util_id <> 2264 AND W.type_id = 2)) AND (M.post_util_id = 2264 OR M.dest_util_id = 2264) 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=2264 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 = 21545 AND W.type_id = 1) OR (W.util_id <> 21545 AND W.type_id = 2)) AND (M.post_util_id = 21545 OR M.dest_util_id = 21545) 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=21545 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 = 23562 AND W.type_id = 1) OR (W.util_id <> 23562 AND W.type_id = 2)) AND (M.post_util_id = 23562 OR M.dest_util_id = 23562) 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=23562 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 = 24880 AND W.type_id = 1) OR (W.util_id <> 24880 AND W.type_id = 2)) AND (M.post_util_id = 24880 OR M.dest_util_id = 24880) 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=24880 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 = 24635 AND W.type_id = 1) OR (W.util_id <> 24635 AND W.type_id = 2)) AND (M.post_util_id = 24635 OR M.dest_util_id = 24635) 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=24635 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 = 25938 AND W.type_id = 1) OR (W.util_id <> 25938 AND W.type_id = 2)) AND (M.post_util_id = 25938 OR M.dest_util_id = 25938) 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=25938 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 = 27149 AND W.type_id = 1) OR (W.util_id <> 27149 AND W.type_id = 2)) AND (M.post_util_id = 27149 OR M.dest_util_id = 27149) 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=27149 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 = 29847 AND W.type_id = 1) OR (W.util_id <> 29847 AND W.type_id = 2)) AND (M.post_util_id = 29847 OR M.dest_util_id = 29847) 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=29847 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 = 30152 AND W.type_id = 1) OR (W.util_id <> 30152 AND W.type_id = 2)) AND (M.post_util_id = 30152 OR M.dest_util_id = 30152) 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=30152 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 = 32965 AND W.type_id = 1) OR (W.util_id <> 32965 AND W.type_id = 2)) AND (M.post_util_id = 32965 OR M.dest_util_id = 32965) 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=32965 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 = 35401 AND W.type_id = 1) OR (W.util_id <> 35401 AND W.type_id = 2)) AND (M.post_util_id = 35401 OR M.dest_util_id = 35401) 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=35401 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 = 36893 AND W.type_id = 1) OR (W.util_id <> 36893 AND W.type_id = 2)) AND (M.post_util_id = 36893 OR M.dest_util_id = 36893) 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=36893 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 = 41154 AND W.type_id = 1) OR (W.util_id <> 41154 AND W.type_id = 2)) AND (M.post_util_id = 41154 OR M.dest_util_id = 41154) 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=41154 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 = 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 <> ''

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

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 = 43778 AND W.type_id = 1) OR (W.util_id <> 43778 AND W.type_id = 2)) AND (M.post_util_id = 43778 OR M.dest_util_id = 43778) 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=43778 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 = 40966 AND W.type_id = 1) OR (W.util_id <> 40966 AND W.type_id = 2)) AND (M.post_util_id = 40966 OR M.dest_util_id = 40966) 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=40966 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 = 45014 AND W.type_id = 1) OR (W.util_id <> 45014 AND W.type_id = 2)) AND (M.post_util_id = 45014 OR M.dest_util_id = 45014) 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=45014 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 = 45894 AND W.type_id = 1) OR (W.util_id <> 45894 AND W.type_id = 2)) AND (M.post_util_id = 45894 OR M.dest_util_id = 45894) 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=45894 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 = 47068 AND W.type_id = 1) OR (W.util_id <> 47068 AND W.type_id = 2)) AND (M.post_util_id = 47068 OR M.dest_util_id = 47068) 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=47068 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 = 47639 AND W.type_id = 1) OR (W.util_id <> 47639 AND W.type_id = 2)) AND (M.post_util_id = 47639 OR M.dest_util_id = 47639) 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=47639 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 = 45392 AND W.type_id = 1) OR (W.util_id <> 45392 AND W.type_id = 2)) AND (M.post_util_id = 45392 OR M.dest_util_id = 45392) 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=45392 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 = 50684 AND W.type_id = 1) OR (W.util_id <> 50684 AND W.type_id = 2)) AND (M.post_util_id = 50684 OR M.dest_util_id = 50684) 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=50684 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 = 51184 AND W.type_id = 1) OR (W.util_id <> 51184 AND W.type_id = 2)) AND (M.post_util_id = 51184 OR M.dest_util_id = 51184) 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=51184 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 = 51395 AND W.type_id = 1) OR (W.util_id <> 51395 AND W.type_id = 2)) AND (M.post_util_id = 51395 OR M.dest_util_id = 51395) 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=51395 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 = 51759 AND W.type_id = 1) OR (W.util_id <> 51759 AND W.type_id = 2)) AND (M.post_util_id = 51759 OR M.dest_util_id = 51759) 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=51759 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 = 53432 AND W.type_id = 1) OR (W.util_id <> 53432 AND W.type_id = 2)) AND (M.post_util_id = 53432 OR M.dest_util_id = 53432) 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=53432 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 = 53899 AND W.type_id = 1) OR (W.util_id <> 53899 AND W.type_id = 2)) AND (M.post_util_id = 53899 OR M.dest_util_id = 53899) 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=53899 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 = 53987 AND W.type_id = 1) OR (W.util_id <> 53987 AND W.type_id = 2)) AND (M.post_util_id = 53987 OR M.dest_util_id = 53987) 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=53987 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 = 53981 AND W.type_id = 1) OR (W.util_id <> 53981 AND W.type_id = 2)) AND (M.post_util_id = 53981 OR M.dest_util_id = 53981) 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=53981 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 = 54188 AND W.type_id = 1) OR (W.util_id <> 54188 AND W.type_id = 2)) AND (M.post_util_id = 54188 OR M.dest_util_id = 54188) 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=54188 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 = 55012 AND W.type_id = 1) OR (W.util_id <> 55012 AND W.type_id = 2)) AND (M.post_util_id = 55012 OR M.dest_util_id = 55012) 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=55012 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 = 55295 AND W.type_id = 1) OR (W.util_id <> 55295 AND W.type_id = 2)) AND (M.post_util_id = 55295 OR M.dest_util_id = 55295) 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=55295 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 = 55735 AND W.type_id = 1) OR (W.util_id <> 55735 AND W.type_id = 2)) AND (M.post_util_id = 55735 OR M.dest_util_id = 55735) 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=55735 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 = 56400 AND W.type_id = 1) OR (W.util_id <> 56400 AND W.type_id = 2)) AND (M.post_util_id = 56400 OR M.dest_util_id = 56400) 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=56400 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 = 56508 AND W.type_id = 1) OR (W.util_id <> 56508 AND W.type_id = 2)) AND (M.post_util_id = 56508 OR M.dest_util_id = 56508) 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=56508 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 = 57204 AND W.type_id = 1) OR (W.util_id <> 57204 AND W.type_id = 2)) AND (M.post_util_id = 57204 OR M.dest_util_id = 57204) 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=57204 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 = 58744 AND W.type_id = 1) OR (W.util_id <> 58744 AND W.type_id = 2)) AND (M.post_util_id = 58744 OR M.dest_util_id = 58744) 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=58744 AND note_visu IN (1,3,4)

119. 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 = 59239 AND W.type_id = 1) OR (W.util_id <> 59239 AND W.type_id = 2)) AND (M.post_util_id = 59239 OR M.dest_util_id = 59239) 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=59239 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 = 59386 AND W.type_id = 1) OR (W.util_id <> 59386 AND W.type_id = 2)) AND (M.post_util_id = 59386 OR M.dest_util_id = 59386) 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=59386 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 = 59877 AND W.type_id = 1) OR (W.util_id <> 59877 AND W.type_id = 2)) AND (M.post_util_id = 59877 OR M.dest_util_id = 59877) 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=59877 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 = 61397 AND W.type_id = 1) OR (W.util_id <> 61397 AND W.type_id = 2)) AND (M.post_util_id = 61397 OR M.dest_util_id = 61397) 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=61397 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 = 61696 AND W.type_id = 1) OR (W.util_id <> 61696 AND W.type_id = 2)) AND (M.post_util_id = 61696 OR M.dest_util_id = 61696) 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=61696 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 = 62769 AND W.type_id = 1) OR (W.util_id <> 62769 AND W.type_id = 2)) AND (M.post_util_id = 62769 OR M.dest_util_id = 62769) 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=62769 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 = 63119 AND W.type_id = 1) OR (W.util_id <> 63119 AND W.type_id = 2)) AND (M.post_util_id = 63119 OR M.dest_util_id = 63119) 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=63119 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 = 64943 AND W.type_id = 1) OR (W.util_id <> 64943 AND W.type_id = 2)) AND (M.post_util_id = 64943 OR M.dest_util_id = 64943) 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=64943 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 = 65523 AND W.type_id = 1) OR (W.util_id <> 65523 AND W.type_id = 2)) AND (M.post_util_id = 65523 OR M.dest_util_id = 65523) 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=65523 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 = 65857 AND W.type_id = 1) OR (W.util_id <> 65857 AND W.type_id = 2)) AND (M.post_util_id = 65857 OR M.dest_util_id = 65857) 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=65857 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 = 65969 AND W.type_id = 1) OR (W.util_id <> 65969 AND W.type_id = 2)) AND (M.post_util_id = 65969 OR M.dest_util_id = 65969) 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=65969 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 = 68398 AND W.type_id = 1) OR (W.util_id <> 68398 AND W.type_id = 2)) AND (M.post_util_id = 68398 OR M.dest_util_id = 68398) 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=68398 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 = 38611 AND W.type_id = 1) OR (W.util_id <> 38611 AND W.type_id = 2)) AND (M.post_util_id = 38611 OR M.dest_util_id = 38611) 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=38611 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 = 69727 AND W.type_id = 1) OR (W.util_id <> 69727 AND W.type_id = 2)) AND (M.post_util_id = 69727 OR M.dest_util_id = 69727) 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=69727 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 = 70129 AND W.type_id = 1) OR (W.util_id <> 70129 AND W.type_id = 2)) AND (M.post_util_id = 70129 OR M.dest_util_id = 70129) 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=70129 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 = 30035 AND W.type_id = 1) OR (W.util_id <> 30035 AND W.type_id = 2)) AND (M.post_util_id = 30035 OR M.dest_util_id = 30035) 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=30035 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 = 70581 AND W.type_id = 1) OR (W.util_id <> 70581 AND W.type_id = 2)) AND (M.post_util_id = 70581 OR M.dest_util_id = 70581) 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=70581 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 = 70910 AND W.type_id = 1) OR (W.util_id <> 70910 AND W.type_id = 2)) AND (M.post_util_id = 70910 OR M.dest_util_id = 70910) 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=70910 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 = 70960 AND W.type_id = 1) OR (W.util_id <> 70960 AND W.type_id = 2)) AND (M.post_util_id = 70960 OR M.dest_util_id = 70960) 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=70960 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 = 71124 AND W.type_id = 1) OR (W.util_id <> 71124 AND W.type_id = 2)) AND (M.post_util_id = 71124 OR M.dest_util_id = 71124) 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=71124 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 = 71965 AND W.type_id = 1) OR (W.util_id <> 71965 AND W.type_id = 2)) AND (M.post_util_id = 71965 OR M.dest_util_id = 71965) 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=71965 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 = 73272 AND W.type_id = 1) OR (W.util_id <> 73272 AND W.type_id = 2)) AND (M.post_util_id = 73272 OR M.dest_util_id = 73272) 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=73272 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 = 73841 AND W.type_id = 1) OR (W.util_id <> 73841 AND W.type_id = 2)) AND (M.post_util_id = 73841 OR M.dest_util_id = 73841) 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=73841 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 = 74183 AND W.type_id = 1) OR (W.util_id <> 74183 AND W.type_id = 2)) AND (M.post_util_id = 74183 OR M.dest_util_id = 74183) 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=74183 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 = 76579 AND W.type_id = 1) OR (W.util_id <> 76579 AND W.type_id = 2)) AND (M.post_util_id = 76579 OR M.dest_util_id = 76579) 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=76579 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 = 78823 AND W.type_id = 1) OR (W.util_id <> 78823 AND W.type_id = 2)) AND (M.post_util_id = 78823 OR M.dest_util_id = 78823) 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=78823 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 = 80822 AND W.type_id = 1) OR (W.util_id <> 80822 AND W.type_id = 2)) AND (M.post_util_id = 80822 OR M.dest_util_id = 80822) 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=80822 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 = 80912 AND W.type_id = 1) OR (W.util_id <> 80912 AND W.type_id = 2)) AND (M.post_util_id = 80912 OR M.dest_util_id = 80912) 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=80912 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 = 81547 AND W.type_id = 1) OR (W.util_id <> 81547 AND W.type_id = 2)) AND (M.post_util_id = 81547 OR M.dest_util_id = 81547) 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=81547 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 = 60060 AND W.type_id = 1) OR (W.util_id <> 60060 AND W.type_id = 2)) AND (M.post_util_id = 60060 OR M.dest_util_id = 60060) 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=60060 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 = 78833 AND W.type_id = 1) OR (W.util_id <> 78833 AND W.type_id = 2)) AND (M.post_util_id = 78833 OR M.dest_util_id = 78833) 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=78833 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 = 85929 AND W.type_id = 1) OR (W.util_id <> 85929 AND W.type_id = 2)) AND (M.post_util_id = 85929 OR M.dest_util_id = 85929) 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=85929 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 = 85846 AND W.type_id = 1) OR (W.util_id <> 85846 AND W.type_id = 2)) AND (M.post_util_id = 85846 OR M.dest_util_id = 85846) 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=85846 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 = 86418 AND W.type_id = 1) OR (W.util_id <> 86418 AND W.type_id = 2)) AND (M.post_util_id = 86418 OR M.dest_util_id = 86418) 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=86418 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 = 87590 AND W.type_id = 1) OR (W.util_id <> 87590 AND W.type_id = 2)) AND (M.post_util_id = 87590 OR M.dest_util_id = 87590) 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=87590 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 = 87607 AND W.type_id = 1) OR (W.util_id <> 87607 AND W.type_id = 2)) AND (M.post_util_id = 87607 OR M.dest_util_id = 87607) 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=87607 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 = 87740 AND W.type_id = 1) OR (W.util_id <> 87740 AND W.type_id = 2)) AND (M.post_util_id = 87740 OR M.dest_util_id = 87740) 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=87740 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 = 88222 AND W.type_id = 1) OR (W.util_id <> 88222 AND W.type_id = 2)) AND (M.post_util_id = 88222 OR M.dest_util_id = 88222) 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=88222 AND note_visu IN (1,3,4)

195. 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 = 88692 AND W.type_id = 1) OR (W.util_id <> 88692 AND W.type_id = 2)) AND (M.post_util_id = 88692 OR M.dest_util_id = 88692) 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=88692 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 = 23252 AND W.type_id = 1) OR (W.util_id <> 23252 AND W.type_id = 2)) AND (M.post_util_id = 23252 OR M.dest_util_id = 23252) 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=23252 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 = 89704 AND W.type_id = 1) OR (W.util_id <> 89704 AND W.type_id = 2)) AND (M.post_util_id = 89704 OR M.dest_util_id = 89704) 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=89704 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 = 90797 AND W.type_id = 1) OR (W.util_id <> 90797 AND W.type_id = 2)) AND (M.post_util_id = 90797 OR M.dest_util_id = 90797) 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=90797 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 = 91339 AND W.type_id = 1) OR (W.util_id <> 91339 AND W.type_id = 2)) AND (M.post_util_id = 91339 OR M.dest_util_id = 91339) 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=91339 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 = 61886 AND W.type_id = 1) OR (W.util_id <> 61886 AND W.type_id = 2)) AND (M.post_util_id = 61886 OR M.dest_util_id = 61886) 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=61886 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 = 90903 AND W.type_id = 1) OR (W.util_id <> 90903 AND W.type_id = 2)) AND (M.post_util_id = 90903 OR M.dest_util_id = 90903) 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=90903 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 = 91874 AND W.type_id = 1) OR (W.util_id <> 91874 AND W.type_id = 2)) AND (M.post_util_id = 91874 OR M.dest_util_id = 91874) 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=91874 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 = 92837 AND W.type_id = 1) OR (W.util_id <> 92837 AND W.type_id = 2)) AND (M.post_util_id = 92837 OR M.dest_util_id = 92837) 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=92837 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 = 93679 AND W.type_id = 1) OR (W.util_id <> 93679 AND W.type_id = 2)) AND (M.post_util_id = 93679 OR M.dest_util_id = 93679) 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=93679 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 = 93890 AND W.type_id = 1) OR (W.util_id <> 93890 AND W.type_id = 2)) AND (M.post_util_id = 93890 OR M.dest_util_id = 93890) 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=93890 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 = 95897 AND W.type_id = 1) OR (W.util_id <> 95897 AND W.type_id = 2)) AND (M.post_util_id = 95897 OR M.dest_util_id = 95897) 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=95897 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 = 97352 AND W.type_id = 1) OR (W.util_id <> 97352 AND W.type_id = 2)) AND (M.post_util_id = 97352 OR M.dest_util_id = 97352) 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=97352 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 = 97440 AND W.type_id = 1) OR (W.util_id <> 97440 AND W.type_id = 2)) AND (M.post_util_id = 97440 OR M.dest_util_id = 97440) 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=97440 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 = 98338 AND W.type_id = 1) OR (W.util_id <> 98338 AND W.type_id = 2)) AND (M.post_util_id = 98338 OR M.dest_util_id = 98338) 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=98338 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 = 99675 AND W.type_id = 1) OR (W.util_id <> 99675 AND W.type_id = 2)) AND (M.post_util_id = 99675 OR M.dest_util_id = 99675) 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=99675 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 = 101007 AND W.type_id = 1) OR (W.util_id <> 101007 AND W.type_id = 2)) AND (M.post_util_id = 101007 OR M.dest_util_id = 101007) 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=101007 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 = 102419 AND W.type_id = 1) OR (W.util_id <> 102419 AND W.type_id = 2)) AND (M.post_util_id = 102419 OR M.dest_util_id = 102419) 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=102419 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 = 103393 AND W.type_id = 1) OR (W.util_id <> 103393 AND W.type_id = 2)) AND (M.post_util_id = 103393 OR M.dest_util_id = 103393) 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=103393 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 = 103964 AND W.type_id = 1) OR (W.util_id <> 103964 AND W.type_id = 2)) AND (M.post_util_id = 103964 OR M.dest_util_id = 103964) 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=103964 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 = 108231 AND W.type_id = 1) OR (W.util_id <> 108231 AND W.type_id = 2)) AND (M.post_util_id = 108231 OR M.dest_util_id = 108231) 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=108231 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 = 108236 AND W.type_id = 1) OR (W.util_id <> 108236 AND W.type_id = 2)) AND (M.post_util_id = 108236 OR M.dest_util_id = 108236) 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=108236 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 = 111200 AND W.type_id = 1) OR (W.util_id <> 111200 AND W.type_id = 2)) AND (M.post_util_id = 111200 OR M.dest_util_id = 111200) 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=111200 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 = 112193 AND W.type_id = 1) OR (W.util_id <> 112193 AND W.type_id = 2)) AND (M.post_util_id = 112193 OR M.dest_util_id = 112193) 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=112193 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 = 113016 AND W.type_id = 1) OR (W.util_id <> 113016 AND W.type_id = 2)) AND (M.post_util_id = 113016 OR M.dest_util_id = 113016) 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=113016 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 = 113472 AND W.type_id = 1) OR (W.util_id <> 113472 AND W.type_id = 2)) AND (M.post_util_id = 113472 OR M.dest_util_id = 113472) 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=113472 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 = 113485 AND W.type_id = 1) OR (W.util_id <> 113485 AND W.type_id = 2)) AND (M.post_util_id = 113485 OR M.dest_util_id = 113485) 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=113485 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 = 113483 AND W.type_id = 1) OR (W.util_id <> 113483 AND W.type_id = 2)) AND (M.post_util_id = 113483 OR M.dest_util_id = 113483) 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=113483 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 = 113952 AND W.type_id = 1) OR (W.util_id <> 113952 AND W.type_id = 2)) AND (M.post_util_id = 113952 OR M.dest_util_id = 113952) 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=113952 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 = 114579 AND W.type_id = 1) OR (W.util_id <> 114579 AND W.type_id = 2)) AND (M.post_util_id = 114579 OR M.dest_util_id = 114579) 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=114579 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 = 115638 AND W.type_id = 1) OR (W.util_id <> 115638 AND W.type_id = 2)) AND (M.post_util_id = 115638 OR M.dest_util_id = 115638) 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=115638 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 = 115649 AND W.type_id = 1) OR (W.util_id <> 115649 AND W.type_id = 2)) AND (M.post_util_id = 115649 OR M.dest_util_id = 115649) 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=115649 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 = 115791 AND W.type_id = 1) OR (W.util_id <> 115791 AND W.type_id = 2)) AND (M.post_util_id = 115791 OR M.dest_util_id = 115791) 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=115791 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 = 115985 AND W.type_id = 1) OR (W.util_id <> 115985 AND W.type_id = 2)) AND (M.post_util_id = 115985 OR M.dest_util_id = 115985) 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=115985 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 = 117569 AND W.type_id = 1) OR (W.util_id <> 117569 AND W.type_id = 2)) AND (M.post_util_id = 117569 OR M.dest_util_id = 117569) 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=117569 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 = 118354 AND W.type_id = 1) OR (W.util_id <> 118354 AND W.type_id = 2)) AND (M.post_util_id = 118354 OR M.dest_util_id = 118354) 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=118354 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 = 118402 AND W.type_id = 1) OR (W.util_id <> 118402 AND W.type_id = 2)) AND (M.post_util_id = 118402 OR M.dest_util_id = 118402) 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=118402 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 = 118494 AND W.type_id = 1) OR (W.util_id <> 118494 AND W.type_id = 2)) AND (M.post_util_id = 118494 OR M.dest_util_id = 118494) 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=118494 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 = 118737 AND W.type_id = 1) OR (W.util_id <> 118737 AND W.type_id = 2)) AND (M.post_util_id = 118737 OR M.dest_util_id = 118737) 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=118737 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 = 118979 AND W.type_id = 1) OR (W.util_id <> 118979 AND W.type_id = 2)) AND (M.post_util_id = 118979 OR M.dest_util_id = 118979) 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=118979 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 = 119463 AND W.type_id = 1) OR (W.util_id <> 119463 AND W.type_id = 2)) AND (M.post_util_id = 119463 OR M.dest_util_id = 119463) 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=119463 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 = 119767 AND W.type_id = 1) OR (W.util_id <> 119767 AND W.type_id = 2)) AND (M.post_util_id = 119767 OR M.dest_util_id = 119767) 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=119767 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 = 120154 AND W.type_id = 1) OR (W.util_id <> 120154 AND W.type_id = 2)) AND (M.post_util_id = 120154 OR M.dest_util_id = 120154) 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=120154 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 = 120466 AND W.type_id = 1) OR (W.util_id <> 120466 AND W.type_id = 2)) AND (M.post_util_id = 120466 OR M.dest_util_id = 120466) 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=120466 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 = 120858 AND W.type_id = 1) OR (W.util_id <> 120858 AND W.type_id = 2)) AND (M.post_util_id = 120858 OR M.dest_util_id = 120858) 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=120858 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 = 83419 AND W.type_id = 1) OR (W.util_id <> 83419 AND W.type_id = 2)) AND (M.post_util_id = 83419 OR M.dest_util_id = 83419) 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=83419 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 = 121091 AND W.type_id = 1) OR (W.util_id <> 121091 AND W.type_id = 2)) AND (M.post_util_id = 121091 OR M.dest_util_id = 121091) 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=121091 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 = 121634 AND W.type_id = 1) OR (W.util_id <> 121634 AND W.type_id = 2)) AND (M.post_util_id = 121634 OR M.dest_util_id = 121634) 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=121634 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 = 122463 AND W.type_id = 1) OR (W.util_id <> 122463 AND W.type_id = 2)) AND (M.post_util_id = 122463 OR M.dest_util_id = 122463) 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=122463 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 = 122749 AND W.type_id = 1) OR (W.util_id <> 122749 AND W.type_id = 2)) AND (M.post_util_id = 122749 OR M.dest_util_id = 122749) 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=122749 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 = 123348 AND W.type_id = 1) OR (W.util_id <> 123348 AND W.type_id = 2)) AND (M.post_util_id = 123348 OR M.dest_util_id = 123348) 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=123348 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 = 123481 AND W.type_id = 1) OR (W.util_id <> 123481 AND W.type_id = 2)) AND (M.post_util_id = 123481 OR M.dest_util_id = 123481) 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=123481 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 = 124263 AND W.type_id = 1) OR (W.util_id <> 124263 AND W.type_id = 2)) AND (M.post_util_id = 124263 OR M.dest_util_id = 124263) 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=124263 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 = 123903 AND W.type_id = 1) OR (W.util_id <> 123903 AND W.type_id = 2)) AND (M.post_util_id = 123903 OR M.dest_util_id = 123903) 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=123903 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 = 124747 AND W.type_id = 1) OR (W.util_id <> 124747 AND W.type_id = 2)) AND (M.post_util_id = 124747 OR M.dest_util_id = 124747) 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=124747 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 = 125934 AND W.type_id = 1) OR (W.util_id <> 125934 AND W.type_id = 2)) AND (M.post_util_id = 125934 OR M.dest_util_id = 125934) 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=125934 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 = 126313 AND W.type_id = 1) OR (W.util_id <> 126313 AND W.type_id = 2)) AND (M.post_util_id = 126313 OR M.dest_util_id = 126313) 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=126313 AND note_visu IN (1,3,4)

309. 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 = 128695 AND W.type_id = 1) OR (W.util_id <> 128695 AND W.type_id = 2)) AND (M.post_util_id = 128695 OR M.dest_util_id = 128695) 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=128695 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 = 115138 AND W.type_id = 1) OR (W.util_id <> 115138 AND W.type_id = 2)) AND (M.post_util_id = 115138 OR M.dest_util_id = 115138) 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=115138 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 = 131116 AND W.type_id = 1) OR (W.util_id <> 131116 AND W.type_id = 2)) AND (M.post_util_id = 131116 OR M.dest_util_id = 131116) 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=131116 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 = 131132 AND W.type_id = 1) OR (W.util_id <> 131132 AND W.type_id = 2)) AND (M.post_util_id = 131132 OR M.dest_util_id = 131132) 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=131132 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 = 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 <> ''

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

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 = 62335 AND W.type_id = 1) OR (W.util_id <> 62335 AND W.type_id = 2)) AND (M.post_util_id = 62335 OR M.dest_util_id = 62335) 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=62335 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 = 131668 AND W.type_id = 1) OR (W.util_id <> 131668 AND W.type_id = 2)) AND (M.post_util_id = 131668 OR M.dest_util_id = 131668) 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=131668 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 = 80888 AND W.type_id = 1) OR (W.util_id <> 80888 AND W.type_id = 2)) AND (M.post_util_id = 80888 OR M.dest_util_id = 80888) 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=80888 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 = 134172 AND W.type_id = 1) OR (W.util_id <> 134172 AND W.type_id = 2)) AND (M.post_util_id = 134172 OR M.dest_util_id = 134172) 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=134172 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 = 135052 AND W.type_id = 1) OR (W.util_id <> 135052 AND W.type_id = 2)) AND (M.post_util_id = 135052 OR M.dest_util_id = 135052) 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=135052 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 = 135558 AND W.type_id = 1) OR (W.util_id <> 135558 AND W.type_id = 2)) AND (M.post_util_id = 135558 OR M.dest_util_id = 135558) 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=135558 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 = 136423 AND W.type_id = 1) OR (W.util_id <> 136423 AND W.type_id = 2)) AND (M.post_util_id = 136423 OR M.dest_util_id = 136423) 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=136423 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 = 137233 AND W.type_id = 1) OR (W.util_id <> 137233 AND W.type_id = 2)) AND (M.post_util_id = 137233 OR M.dest_util_id = 137233) 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=137233 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 = 137518 AND W.type_id = 1) OR (W.util_id <> 137518 AND W.type_id = 2)) AND (M.post_util_id = 137518 OR M.dest_util_id = 137518) 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=137518 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 = 139976 AND W.type_id = 1) OR (W.util_id <> 139976 AND W.type_id = 2)) AND (M.post_util_id = 139976 OR M.dest_util_id = 139976) 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=139976 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 = 141268 AND W.type_id = 1) OR (W.util_id <> 141268 AND W.type_id = 2)) AND (M.post_util_id = 141268 OR M.dest_util_id = 141268) 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=141268 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 = 141556 AND W.type_id = 1) OR (W.util_id <> 141556 AND W.type_id = 2)) AND (M.post_util_id = 141556 OR M.dest_util_id = 141556) 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=141556 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 = 142333 AND W.type_id = 1) OR (W.util_id <> 142333 AND W.type_id = 2)) AND (M.post_util_id = 142333 OR M.dest_util_id = 142333) 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=142333 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 = 141577 AND W.type_id = 1) OR (W.util_id <> 141577 AND W.type_id = 2)) AND (M.post_util_id = 141577 OR M.dest_util_id = 141577) 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=141577 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 = 146132 AND W.type_id = 1) OR (W.util_id <> 146132 AND W.type_id = 2)) AND (M.post_util_id = 146132 OR M.dest_util_id = 146132) 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=146132 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 = 146877 AND W.type_id = 1) OR (W.util_id <> 146877 AND W.type_id = 2)) AND (M.post_util_id = 146877 OR M.dest_util_id = 146877) 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=146877 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 = 149858 AND W.type_id = 1) OR (W.util_id <> 149858 AND W.type_id = 2)) AND (M.post_util_id = 149858 OR M.dest_util_id = 149858) 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=149858 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 = 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 <> ''

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

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 = 153506 AND W.type_id = 1) OR (W.util_id <> 153506 AND W.type_id = 2)) AND (M.post_util_id = 153506 OR M.dest_util_id = 153506) 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=153506 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 = 155611 AND W.type_id = 1) OR (W.util_id <> 155611 AND W.type_id = 2)) AND (M.post_util_id = 155611 OR M.dest_util_id = 155611) 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=155611 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 = 157120 AND W.type_id = 1) OR (W.util_id <> 157120 AND W.type_id = 2)) AND (M.post_util_id = 157120 OR M.dest_util_id = 157120) 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=157120 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 = 157315 AND W.type_id = 1) OR (W.util_id <> 157315 AND W.type_id = 2)) AND (M.post_util_id = 157315 OR M.dest_util_id = 157315) 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=157315 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 = 158139 AND W.type_id = 1) OR (W.util_id <> 158139 AND W.type_id = 2)) AND (M.post_util_id = 158139 OR M.dest_util_id = 158139) 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=158139 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 = 158368 AND W.type_id = 1) OR (W.util_id <> 158368 AND W.type_id = 2)) AND (M.post_util_id = 158368 OR M.dest_util_id = 158368) 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=158368 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 = 158463 AND W.type_id = 1) OR (W.util_id <> 158463 AND W.type_id = 2)) AND (M.post_util_id = 158463 OR M.dest_util_id = 158463) 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=158463 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 = 160211 AND W.type_id = 1) OR (W.util_id <> 160211 AND W.type_id = 2)) AND (M.post_util_id = 160211 OR M.dest_util_id = 160211) 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=160211 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 = 160904 AND W.type_id = 1) OR (W.util_id <> 160904 AND W.type_id = 2)) AND (M.post_util_id = 160904 OR M.dest_util_id = 160904) 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=160904 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 = 163154 AND W.type_id = 1) OR (W.util_id <> 163154 AND W.type_id = 2)) AND (M.post_util_id = 163154 OR M.dest_util_id = 163154) 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=163154 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 = 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 <> ''

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

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 = 74643 AND W.type_id = 1) OR (W.util_id <> 74643 AND W.type_id = 2)) AND (M.post_util_id = 74643 OR M.dest_util_id = 74643) 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=74643 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 = 166546 AND W.type_id = 1) OR (W.util_id <> 166546 AND W.type_id = 2)) AND (M.post_util_id = 166546 OR M.dest_util_id = 166546) 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=166546 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 = 168912 AND W.type_id = 1) OR (W.util_id <> 168912 AND W.type_id = 2)) AND (M.post_util_id = 168912 OR M.dest_util_id = 168912) 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=168912 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 = 170398 AND W.type_id = 1) OR (W.util_id <> 170398 AND W.type_id = 2)) AND (M.post_util_id = 170398 OR M.dest_util_id = 170398) 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=170398 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 = 170630 AND W.type_id = 1) OR (W.util_id <> 170630 AND W.type_id = 2)) AND (M.post_util_id = 170630 OR M.dest_util_id = 170630) 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=170630 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 = 165797 AND W.type_id = 1) OR (W.util_id <> 165797 AND W.type_id = 2)) AND (M.post_util_id = 165797 OR M.dest_util_id = 165797) 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=165797 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 = 171813 AND W.type_id = 1) OR (W.util_id <> 171813 AND W.type_id = 2)) AND (M.post_util_id = 171813 OR M.dest_util_id = 171813) 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=171813 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 = 176768 AND W.type_id = 1) OR (W.util_id <> 176768 AND W.type_id = 2)) AND (M.post_util_id = 176768 OR M.dest_util_id = 176768) 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=176768 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 = 71629 AND W.type_id = 1) OR (W.util_id <> 71629 AND W.type_id = 2)) AND (M.post_util_id = 71629 OR M.dest_util_id = 71629) 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=71629 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 = 190572 AND W.type_id = 1) OR (W.util_id <> 190572 AND W.type_id = 2)) AND (M.post_util_id = 190572 OR M.dest_util_id = 190572) 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=190572 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 = 191513 AND W.type_id = 1) OR (W.util_id <> 191513 AND W.type_id = 2)) AND (M.post_util_id = 191513 OR M.dest_util_id = 191513) 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=191513 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 = 189806 AND W.type_id = 1) OR (W.util_id <> 189806 AND W.type_id = 2)) AND (M.post_util_id = 189806 OR M.dest_util_id = 189806) 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=189806 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 = 192799 AND W.type_id = 1) OR (W.util_id <> 192799 AND W.type_id = 2)) AND (M.post_util_id = 192799 OR M.dest_util_id = 192799) 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=192799 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 = 194344 AND W.type_id = 1) OR (W.util_id <> 194344 AND W.type_id = 2)) AND (M.post_util_id = 194344 OR M.dest_util_id = 194344) 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=194344 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 = 197894 AND W.type_id = 1) OR (W.util_id <> 197894 AND W.type_id = 2)) AND (M.post_util_id = 197894 OR M.dest_util_id = 197894) 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=197894 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 = 199483 AND W.type_id = 1) OR (W.util_id <> 199483 AND W.type_id = 2)) AND (M.post_util_id = 199483 OR M.dest_util_id = 199483) 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=199483 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 = 200147 AND W.type_id = 1) OR (W.util_id <> 200147 AND W.type_id = 2)) AND (M.post_util_id = 200147 OR M.dest_util_id = 200147) 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=200147 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 = 120876 AND W.type_id = 1) OR (W.util_id <> 120876 AND W.type_id = 2)) AND (M.post_util_id = 120876 OR M.dest_util_id = 120876) 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=120876 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 = 202321 AND W.type_id = 1) OR (W.util_id <> 202321 AND W.type_id = 2)) AND (M.post_util_id = 202321 OR M.dest_util_id = 202321) 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=202321 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 = 203656 AND W.type_id = 1) OR (W.util_id <> 203656 AND W.type_id = 2)) AND (M.post_util_id = 203656 OR M.dest_util_id = 203656) 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=203656 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 = 204697 AND W.type_id = 1) OR (W.util_id <> 204697 AND W.type_id = 2)) AND (M.post_util_id = 204697 OR M.dest_util_id = 204697) 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=204697 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 = 204977 AND W.type_id = 1) OR (W.util_id <> 204977 AND W.type_id = 2)) AND (M.post_util_id = 204977 OR M.dest_util_id = 204977) 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=204977 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 = 207514 AND W.type_id = 1) OR (W.util_id <> 207514 AND W.type_id = 2)) AND (M.post_util_id = 207514 OR M.dest_util_id = 207514) 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=207514 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 = 211959 AND W.type_id = 1) OR (W.util_id <> 211959 AND W.type_id = 2)) AND (M.post_util_id = 211959 OR M.dest_util_id = 211959) 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=211959 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 = 198010 AND W.type_id = 1) OR (W.util_id <> 198010 AND W.type_id = 2)) AND (M.post_util_id = 198010 OR M.dest_util_id = 198010) 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=198010 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 = 58981 AND W.type_id = 1) OR (W.util_id <> 58981 AND W.type_id = 2)) AND (M.post_util_id = 58981 OR M.dest_util_id = 58981) 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=58981 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 = 215104 AND W.type_id = 1) OR (W.util_id <> 215104 AND W.type_id = 2)) AND (M.post_util_id = 215104 OR M.dest_util_id = 215104) 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=215104 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 = 216425 AND W.type_id = 1) OR (W.util_id <> 216425 AND W.type_id = 2)) AND (M.post_util_id = 216425 OR M.dest_util_id = 216425) 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=216425 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 = 216486 AND W.type_id = 1) OR (W.util_id <> 216486 AND W.type_id = 2)) AND (M.post_util_id = 216486 OR M.dest_util_id = 216486) 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=216486 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 = 218551 AND W.type_id = 1) OR (W.util_id <> 218551 AND W.type_id = 2)) AND (M.post_util_id = 218551 OR M.dest_util_id = 218551) 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=218551 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 = 225666 AND W.type_id = 1) OR (W.util_id <> 225666 AND W.type_id = 2)) AND (M.post_util_id = 225666 OR M.dest_util_id = 225666) 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=225666 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 = 226802 AND W.type_id = 1) OR (W.util_id <> 226802 AND W.type_id = 2)) AND (M.post_util_id = 226802 OR M.dest_util_id = 226802) 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=226802 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 = 228740 AND W.type_id = 1) OR (W.util_id <> 228740 AND W.type_id = 2)) AND (M.post_util_id = 228740 OR M.dest_util_id = 228740) 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=228740 AND note_visu IN (1,3,4)

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

444. 0.0001

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

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

446. 0.0001

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

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

448. 0.0001

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

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

450. 0.0001

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

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

452. 0.0001

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

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

454. 0.0001

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

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

456. 0.0001

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

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

458. 0.0001

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

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

460. 0.0001

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

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

462. 0.0001

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

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

464. 0.0001

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

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

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

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

468. 0.0001

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

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

470. 0.0001

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

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

472. 0.0001

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

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

474. 0.0001

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

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

476. 0.0001

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

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

478. 0.0001

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

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

480. 0.0001

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

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

482. 0.0001

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

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

484. 0.0001

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

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

486. 0.0001

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

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

488. 0.0001

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

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

490. 0.0001

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

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

492. 0.0001

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

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

494. 0.0001

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

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

496. 0.0001

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

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

498. 0.0001

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

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

500. 0.0001

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

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

502. 0.0001

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

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

504. 0.0001

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

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

506. 0.0001

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

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

508. 0.0001

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

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

510. 0.0001

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

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

512. 0.0001

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

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

514. 0.0001

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

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

516. 0.0001

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

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

518. 0.0001

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

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

520. 0.0001

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

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

522. 0.0001

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

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

524. 0.0001

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

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

526. 0.0001

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

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

528. 0.0001

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

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

530. 0.0001

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

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

532. 0.0001

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

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

534. 0.0001

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

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

536. 0.0001

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

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

538. 0.0001

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

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

540. 0.0001

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

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

542. 0.0001

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

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

544. 0.0001

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

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

546. 0.0001

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

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

548. 0.0001

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

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

550. 0.0001

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

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

552. 0.0001

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

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

554. 0.0001

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

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

556. 0.0001

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

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

558. 0.0001

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

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

560. 0.0001

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

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

562. 0.0001

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

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

564. 0.0001

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

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

566. 0.0001

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

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

568. 0.0001

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

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

570. 0.0001

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

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

572. 0.0001

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

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

574. 0.0001

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

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

576. 0.0001

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

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

578. 0.0001

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

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

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

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

582. 0.0001

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

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

584. 0.0001

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

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

586. 0.0001

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

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

588. 0.0001

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

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

590. 0.0001

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

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

592. 0.0001

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

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

594. 0.0001

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

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

596. 0.0001

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

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

598. 0.0001

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

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

600. 0.0001

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

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

602. 0.0001

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

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

604. 0.0001

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

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

606. 0.0001

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

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

608. 0.0001

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

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

610. 0.0001

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

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

612. 0.0001

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

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

614. 0.0001

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

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

616. 0.0001

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

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

618. 0.0001

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

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

620. 0.0001

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

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

622. 0.0001

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

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

624. 0.0001

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

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

626. 0.0001

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

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

628. 0.0001

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

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

630. 0.0001

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

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

632. 0.0001

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

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

634. 0.0001

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

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

636. 0.0001

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

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

638. 0.0001

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

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

640. 0.0001

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

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

642. 0.0001

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

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

644. 0.0001

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

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

646. 0.0001

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

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

648. 0.0001

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

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

650. 0.0001

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

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

652. 0.0001

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

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

654. 0.0001

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

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

656. 0.0001

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

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

658. 0.0001

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

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

660. 0.0001

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

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

662. 0.0001

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

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

664. 0.0001

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

665. 0.0001

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

666. 0.0019

     SELECT ville_cp, ROUND((((acos(sin((48.775*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.775*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.595135678816 AND ville_latitude_deg<48.954864321184 AND ville_longitude_deg>2.0437416454043 AND ville_longitude_deg<2.5895983545957 HAVING distance <= 20 ORDER BY distance ASC

667. 0.006

     SELECT ville_cp, ROUND((((acos(sin((48.775*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.775*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.325339197041 AND ville_latitude_deg<49.224660802959 AND ville_longitude_deg>1.6343432297533 AND ville_longitude_deg<2.9989967702467 HAVING distance <= 50 ORDER BY distance ASC

668. 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 (938,937,1080,970)

669. 0.0002

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (257529,166546,146877,13596,64943,170630,99675,65857,272279,85929,58744,351051,137233,103393,475962,57204,65523,250275,113016,23252,515219,117569,91339,78823,80822,142333,81547,120876,121091,232778,454849,408673,135052,191513,225518,136423,126313,37102,295186,286187,80912,53899,45894,32965,23562,123348,160211,292890,61886,146449,417117,323726,189806,85846,53987,386358,171813)

670. 0.0002

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (257529,166546,146877,13596,64943,170630,99675,65857,272279,85929,58744,351051,137233,103393,475962,57204,65523,250275,113016,23252,515219,117569,91339,78823,80822,142333,81547,120876,121091,232778,454849,408673,135052,191513,225518,136423,126313,37102,295186,286187,80912,53899,45894,32965,23562,123348,160211,292890,61886,146449,417117,323726,189806,85846,53987,386358,171813)

671. 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='repassage' OR ssrubr_slug like '%repassage%' OR MATCH (ssrubr_slug) AGAINST ('(+repassage)')) AND sk.ssrubr_id='938' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

672. 0.0001

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

673. 0.0001

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

674. 0.0003

     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

675. 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 (47) ORDER BY ssrubr_order ASC

676. 0.001

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

677. 0.0222

     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'

678. 0.0176

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

678 requetes sql en 0.1874