Location parking sécurisé

1. 0.0001

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

2. 0.0001

   SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='box-stockage'

3. 0

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

4. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

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

6. 0.0002

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

7. 0.0001

   SHOW TABLES LIKE 'pays'

8. 0.0002

   SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

9. 0.0003

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

10. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='parking sécurisé'

11. 0.0424

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='79'AND MATCH (wish_title,wish_desc) AGAINST ('+parking sécurisé*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10)

12. 0.0001

    SELECT * FROM texte WHERE cate_id=79

13. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='parking sécurisé' OR ssrubr_slug='parking-sécurisé' OR (ssrubr_title like '%parking sécurisé%')) AND cate_id='79' ORDER BY ssrubr_id LIMIT 0,1

14. 0.0002

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='parking-securise' AND cate_id='79'

15. 0.0395

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='79' AND MATCH (wish_desc) AGAINST ('(+parking +sécurisé*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND type_id=1 GROUP BY wish_id

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

17. 0.0001

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

18. 0.0001

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

19. 0.0001

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

20. 0.0001

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

21. 0.0001

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

22. 0.0001

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

23. 0.0001

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

24. 0.0002

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

25. 0.0001

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

26. 0.0002

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

27. 0.0001

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

28. 0.0001

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

29. 0.0001

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

30. 0.0001

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

31. 0.0001

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

32. 0.0001

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

33. 0.0001

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

34. 0.0001

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

35. 0.0001

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

36. 0.0001

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

37. 0.0001

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

38. 0.0001

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

39. 0.0001

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

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

43. 0.0001

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

44. 0.0001

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

45. 0.0001

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

46. 0.0001

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

47. 0.0001

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

48. 0.0001

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

49. 0.0001

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

50. 0.0001

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

51. 0.0001

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

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

53. 0.0001

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

54. 0.0001

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

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

65. 0.0001

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

66. 0.0001

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

67. 0.0001

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

68. 0.0001

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

69. 0.0001

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

70. 0.0001

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

71. 0.0001

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

72. 0.0001

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

73. 0.0001

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

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

81. 0.0001

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

82. 0.0001

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

89. 0.0001

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

90. 0.0001

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

91. 0.0001

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

92. 0.0001

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

93. 0.0001

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

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

95. 0.0001

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

96. 0.0001

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

100. 0.0001

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

101. 0.0001

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

102. 0.0001

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

103. 0.0001

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

104. 0.0001

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

105. 0.0001

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

106. 0.0001

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

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

119. 0.0001

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

120. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0002

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

125. 0.0001

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

126. 0.0002

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

127. 0.0001

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

128. 0.0002

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

129. 0.0001

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

130. 0.0002

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

131. 0.0001

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

132. 0.0001

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

133. 0.0001

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

134. 0.0001

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

135. 0.0001

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

136. 0.0002

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

137. 0.0001

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

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

139. 0.0001

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

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

141. 0.0001

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

142. 0.0002

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

143. 0.0001

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

144. 0.0001

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

145. 0.0001

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

146. 0.0001

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

147. 0.0001

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

148. 0.0001

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

149. 0.0001

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

150. 0.0001

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

151. 0.0001

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

152. 0.0001

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

153. 0.0001

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

154. 0.0001

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

155. 0.0001

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

156. 0.0001

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

157. 0.0001

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

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

159. 0.0001

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

160. 0.0001

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

161. 0.0001

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

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

163. 0.0001

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

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

165. 0.0001

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

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

167. 0.0001

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

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

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

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

173. 0.0001

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

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

175. 0.0001

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

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

177. 0.0001

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

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

179. 0.0001

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

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

181. 0.0001

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

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

183. 0.0001

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

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

185. 0.0001

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

186. 0.0003

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

187. 0.0001

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

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

189. 0.0001

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

190. 0.0001

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

191. 0.0001

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

192. 0.0001

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

193. 0.0001

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

194. 0.0001

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

195. 0.0001

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

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

197. 0.0001

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

198. 0.0001

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

199. 0.0001

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

200. 0.0001

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

201. 0.0001

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

202. 0.0001

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

203. 0.0001

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

204. 0.0001

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

205. 0.0001

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

206. 0.0001

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

207. 0.0001

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

208. 0.0001

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

209. 0.0001

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

210. 0.0001

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

211. 0.0001

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

212. 0.0001

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

213. 0.0001

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

214. 0.0001

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

215. 0.0001

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

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

217. 0.0001

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

218. 0.0001

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

219. 0.0001

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

220. 0.0001

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

221. 0.0001

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

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

223. 0.0001

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

224. 0.0001

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

225. 0.0001

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

226. 0.0001

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

227. 0.0001

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

228. 0.0001

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

229. 0.0001

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

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

231. 0.0001

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

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

233. 0.0001

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

234. 0.0001

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

235. 0.0001

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

236. 0.0001

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

237. 0.0001

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

238. 0.0001

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

239. 0.0001

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

240. 0.0001

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

241. 0.0001

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

242. 0.0001

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

243. 0.0001

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

244. 0.0001

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

245. 0.0001

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

246. 0.0001

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

247. 0.0001

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

248. 0.0001

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

249. 0.0001

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

250. 0.0001

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

251. 0.0001

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

252. 0.0001

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

253. 0.0001

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

254. 0.0001

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

255. 0.0001

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

256. 0.0001

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

257. 0.0001

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

258. 0.0001

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

259. 0.0001

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

260. 0.0001

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

261. 0.0001

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

262. 0.0001

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

263. 0.0001

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

264. 0.0001

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

265. 0.0001

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

266. 0.0001

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

267. 0.0001

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

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

269. 0.0001

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

270. 0.0001

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

271. 0.0001

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

272. 0.0001

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

273. 0.0001

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

274. 0.0001

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

275. 0.0001

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

276. 0.0001

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

277. 0.0001

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

278. 0.0001

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

279. 0.0001

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

280. 0.0001

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

281. 0.0001

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

282. 0.0001

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

283. 0.0001

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

284. 0.0001

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

285. 0.0001

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

286. 0.0001

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

287. 0.0001

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

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

289. 0.0001

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

290. 0.0001

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

291. 0.0001

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

292. 0.0001

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

293. 0.0001

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

294. 0.0001

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

295. 0.0001

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

296. 0.0001

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

297. 0.0001

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

298. 0.0001

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

299. 0.0001

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

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

301. 0.0001

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

302. 0.0001

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

303. 0.0001

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

304. 0.0001

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

305. 0.0001

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

306. 0.0001

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

307. 0.0001

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

308. 0.0001

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

309. 0.0001

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

310. 0.0001

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

311. 0.0001

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

312. 0.0001

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

313. 0.0001

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

314. 0.0001

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

315. 0.0001

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

316. 0.0001

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

317. 0.0001

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

318. 0.0001

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

319. 0.0001

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

320. 0.0001

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

321. 0.0001

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

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

323. 0.0001

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

324. 0.0001

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

325. 0.0001

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

326. 0.0001

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

327. 0.0001

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

328. 0.0001

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

329. 0.0001

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

330. 0.0001

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

331. 0.0001

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

332. 0.0001

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

333. 0.0001

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

334. 0.0001

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

335. 0.0001

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

336. 0.0001

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

337. 0.0001

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

338. 0.0001

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

339. 0.0001

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

340. 0.0001

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

341. 0.0001

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

342. 0.0001

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

343. 0.0001

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

344. 0.0001

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

345. 0.0001

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

346. 0.0001

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

347. 0.0001

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

348. 0.0001

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

349. 0.0001

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

350. 0.0001

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

351. 0.0001

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

352. 0.0001

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

353. 0.0001

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

354. 0.0001

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

355. 0.0001

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

356. 0.0001

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

357. 0.0001

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

358. 0.0001

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

359. 0.0001

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

360. 0.0001

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

361. 0.0001

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

362. 0.0001

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

363. 0.0001

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

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

365. 0.0001

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

366. 0.0001

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

367. 0.0001

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

368. 0.0001

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

369. 0.0001

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

370. 0.0001

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

371. 0.0001

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

372. 0.0001

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

373. 0.0001

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

374. 0.0001

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

375. 0.0001

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

376. 0.0001

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

377. 0.0001

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

378. 0.0001

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

379. 0.0001

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

380. 0.0001

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

381. 0.0001

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

382. 0.0001

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

383. 0.0001

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

384. 0.0001

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

385. 0.0001

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

386. 0.0001

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

387. 0.0001

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

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

389. 0.0001

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

390. 0.0001

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

391. 0.0001

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

392. 0.0001

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

393. 0.0001

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

394. 0.0001

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

395. 0.0001

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

396. 0.0001

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

397. 0.0001

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

398. 0.0001

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

399. 0.0001

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

400. 0.0001

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

401. 0.0001

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

402. 0.0001

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

403. 0.0001

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

404. 0.0001

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

405. 0.0001

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

406. 0.0001

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

407. 0.0001

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

408. 0.0001

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

409. 0.0001

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

410. 0.0001

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

411. 0.0001

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

412. 0.0001

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

413. 0.0001

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

414. 0.0001

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

415. 0.0001

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

416. 0.0001

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

417. 0.0001

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

418. 0.0001

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

419. 0.0001

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

420. 0.0001

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

421. 0.0001

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

422. 0.0001

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

423. 0.0001

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

424. 0.0001

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

425. 0.0001

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

426. 0.0001

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

427. 0.0001

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

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

429. 0.0001

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

430. 0.0001

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

431. 0.0001

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

432. 0.0001

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

433. 0.0001

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

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

435. 0.0001

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

436. 0.0001

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

437. 0.0001

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

438. 0.0001

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

439. 0.0001

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

440. 0.0001

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

441. 0.0001

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

442. 0.0001

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

443. 0.0002

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

444. 0.0001

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

445. 0.0001

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

446. 0.0001

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

447. 0.0001

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

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

449. 0.0001

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

450. 0.0001

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

451. 0.0001

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

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

453. 0.0001

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

454. 0.0001

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

455. 0.0001

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

456. 0.0001

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

457. 0.0001

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

458. 0.0001

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

459. 0.0001

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

460. 0.0001

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

461. 0.0001

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

462. 0.0001

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

463. 0.0001

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

464. 0.0001

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

465. 0.0001

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

466. 0.0001

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

467. 0.0001

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

468. 0.0001

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

469. 0.0001

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

470. 0.0001

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

471. 0.0001

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

472. 0.0001

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

473. 0.0001

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

474. 0.0001

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

475. 0.0001

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

476. 0.0001

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

477. 0.0001

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

478. 0.0001

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

479. 0.0001

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

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

481. 0.0001

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

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

483. 0.0001

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

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

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

486. 0.0001

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

487. 0.0001

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

488. 0.0001

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

489. 0.0001

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

490. 0.0001

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

491. 0.0001

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

492. 0.0001

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

493. 0.0001

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

494. 0.0001

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

495. 0.0001

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

496. 0.0001

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

497. 0.0001

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

498. 0.0001

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

499. 0.0001

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

500. 0.0001

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

501. 0.0001

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

502. 0.0001

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

503. 0.0001

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

504. 0.0001

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

505. 0.0001

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

506. 0.0001

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

507. 0.0001

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

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

509. 0.0001

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

510. 0.0001

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

511. 0.0001

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

512. 0.0001

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

513. 0.0001

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

514. 0.0001

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

515. 0.0001

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

516. 0.0001

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

517. 0.0001

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

518. 0.0001

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

519. 0.0001

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

520. 0.0001

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

521. 0.0001

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

522. 0.0001

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

523. 0.0001

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

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

525. 0.0001

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

526. 0.0001

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

527. 0.0001

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

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

529. 0.0001

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

530. 0.0001

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

531. 0.0001

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

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

533. 0.0001

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

534. 0.0001

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

535. 0.0001

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

536. 0.0002

     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 (1028,522,516,523,514,520,1174,517,518)

537. 0.0003

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (535069,525425,504097,508716,492644,7005,347032,342459,425157,408639,140501,194599,336922,387212,28031,425878,414983,403745,299069,276858,70110,291820,391627,383183,379634,207602,377428,342529,206436,43061,338885,158757,328518,51317,178481,300747,285110,130965,6738,169904,272982,104570,92466,264899,226450,148045,215550,159842,237519,229825,196024,223980,199218,143042,209688,203233)

538. 0.0003

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (535069,525425,504097,508716,492644,7005,347032,342459,425157,408639,140501,194599,336922,387212,28031,425878,414983,403745,299069,276858,70110,291820,391627,383183,379634,207602,377428,342529,206436,43061,338885,158757,328518,51317,178481,300747,285110,130965,6738,169904,272982,104570,92466,264899,226450,148045,215550,159842,237519,229825,196024,223980,199218,143042,209688,203233)

539. 0.0003

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

540. 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='parking sécurisé' OR ssrubr_slug like '%parking sécurisé%' OR MATCH (ssrubr_slug) AGAINST ('(+parking +sécurisé)')) AND sk.ssrubr_id='518' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

541. 0.0001

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

542. 0

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

543. 0.0001

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

544. 0.0002

     SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (79) ORDER BY ssrubr_order ASC

545. 0.0016

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

546. 0.0308

     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'

547. 0.018

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

547 requetes sql en 0.1935