Location box sécurisé

1. 0.0002

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

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

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

5. 0.0006

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

6. 0.0002

   SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%stockage%box%securise%' OR ssrubr_title like '%stockage%box%securise%' OR ssrubr_slug like '%stockage%box%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='sécurisé; stockage box securise'

11. 0.0426

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='79'AND MATCH (wish_title,wish_desc) AGAINST ('+sécurisé; stockage box securise*' 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='sécurisé; stockage box securise' OR ssrubr_slug='sécurisé;-stockage-box-securise' OR (ssrubr_title like '%sécurisé; stockage box securise%')) AND cate_id='79' ORDER BY ssrubr_id LIMIT 0,1

14. 0.0001

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

15. 0.0318

    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 ('(+sécurisé; +stockage +box +securise*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND type_id=1 GROUP BY wish_id

16. 0.0004

    SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (6064,9103,10255,13119,26719,31899,33163,43929,9322,49188,49376,53102,51620,59103,59799,62954,63657,65807,66354,67042,68967,69844,74254,76112,78002,79143,80375,86474,90905,91002,105314,105413,106927,111619,117537,118991,118034,121020,129378,8045,136027,137802,140501,144821,146771,148655,145152,153448,128908,161566,162456,165348,165831,91663,9084,167694,170959,177633,188468,198894,200377,201097,201451,201823,12368,202757,203818,204216,205162,205467,206661,207890,211670,211776,216377,217666,218669,227780,229932,237233,237519,234892,248396,252132,258559,104570,120871,36073,87820,295079,297213,299372,301720,301708,305120,306769,231156,98381,342529,343091,206436,351545,357735,342261,292525,367498,367770,372193,372314,374094,147117,89631,379850,380269,385999,393016,394251,397282,397333,408639,412063,339661,172530,424797,425208,425747,425800,78686,446239,20869,159674,290288,467076,472039,472433,474717,281585,477180,471981,342459,492644,493489,496237,500029,505769,506813,511816,513495,517605,510703,526533,525028,538063,538128,501094,544149,545814,548058)

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

18. 0.0001

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

19. 0.0001

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

20. 0.0001

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

21. 0.0001

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

22. 0.0001

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

23. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 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 <> ''

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

25. 0.0001

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

26. 0.0001

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

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

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

29. 0.0001

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

30. 0.0001

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

31. 0.0001

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

32. 0.0001

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

33. 0.0001

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

34. 0.0001

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

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

36. 0.0001

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

37. 0.0001

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

38. 0.0001

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

39. 0.0001

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

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

43. 0.0001

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

44. 0.0001

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

45. 0.0001

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

46. 0.0001

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

47. 0.0001

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

48. 0.0001

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

49. 0.0001

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

50. 0.0001

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

51. 0.0001

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

52. 0.0001

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

53. 0.0001

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

54. 0.0001

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

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

65. 0.0001

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

66. 0.0001

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

67. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

69. 0.0001

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

70. 0.0001

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

71. 0.0001

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

72. 0.0001

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

73. 0.0001

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

81. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

89. 0.0001

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

90. 0.0001

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

91. 0.0001

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

92. 0.0001

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

93. 0.0001

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

94. 0.0001

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

95. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

100. 0.0001

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

101. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

103. 0.0001

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

104. 0.0001

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

105. 0.0001

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

106. 0.0001

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

120. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

128. 0.0001

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

129. 0.0001

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

130. 0.0001

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

131. 0.0001

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

132. 0.0001

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

133. 0.0001

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

134. 0.0001

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

135. 0.0001

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

136. 0.0001

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

137. 0.0001

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

138. 0.0001

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

139. 0.0001

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

140. 0.0001

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

141. 0.0001

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

142. 0.0001

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

143. 0.0001

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

144. 0.0001

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

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

146. 0.0001

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

147. 0.0001

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

148. 0.0001

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

149. 0.0001

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

150. 0.0001

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

151. 0.0001

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

152. 0.0001

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

153. 0.0001

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

154. 0.0001

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

155. 0.0001

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

156. 0.0001

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

157. 0.0001

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

158. 0.0001

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

159. 0.0001

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

160. 0.0001

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

161. 0.0001

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

162. 0.0001

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

163. 0.0001

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

164. 0.0001

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

165. 0.0001

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

166. 0.0001

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

167. 0.0001

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

168. 0.0001

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

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

172. 0.0001

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

173. 0.0001

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

174. 0.0001

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

175. 0.0001

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

176. 0.0001

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

177. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

179. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

181. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

183. 0.0001

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

184. 0.0001

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

185. 0.0001

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

186. 0.0001

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

187. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

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

190. 0.0001

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

191. 0.0001

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

192. 0.0001

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

193. 0.0001

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

194. 0.0001

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

195. 0.0001

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

196. 0.0001

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

197. 0.0001

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

198. 0.0001

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

199. 0.0001

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

200. 0.0001

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

201. 0.0001

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

202. 0.0001

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

203. 0.0001

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

204. 0.0001

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

205. 0.0001

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

206. 0.0001

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

207. 0.0001

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

208. 0.0001

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

209. 0.0001

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

210. 0.0001

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

211. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

213. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

215. 0.0001

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

216. 0.0001

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

217. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

219. 0.0001

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

220. 0.0001

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

221. 0.0001

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

222. 0.0001

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

223. 0.0001

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

224. 0.0001

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

225. 0.0001

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

226. 0.0001

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

227. 0.0001

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

228. 0.0001

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

229. 0.0001

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

230. 0.0001

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

231. 0.0001

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

232. 0.0001

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

233. 0.0001

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

234. 0.0001

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

235. 0.0001

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

236. 0.0001

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

237. 0.0001

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

238. 0.0001

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

239. 0.0001

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

240. 0.0001

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

241. 0.0001

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

242. 0.0001

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

243. 0.0001

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

244. 0.0001

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

245. 0.0001

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

246. 0.0001

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

247. 0.0001

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

248. 0.0001

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

249. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

251. 0.0001

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

252. 0.0001

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

253. 0.0001

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

254. 0.0001

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

255. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

257. 0.0001

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

258. 0.0001

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

259. 0.0001

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

260. 0.0001

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

261. 0.0001

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

262. 0.0001

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

263. 0.0001

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

264. 0.0001

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

265. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

267. 0.0001

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

268. 0.0001

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

269. 0.0001

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

270. 0.0001

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

271. 0.0001

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

272. 0.0001

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

273. 0.0001

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

274. 0.0001

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

275. 0.0001

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

276. 0.0001

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

277. 0.0001

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

278. 0.0001

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

279. 0.0001

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

280. 0.0001

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

281. 0.0001

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

282. 0.0001

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

283. 0.0001

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

284. 0.0001

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

285. 0.0001

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

286. 0.0001

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

287. 0.0001

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

288. 0.0001

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

289. 0.0001

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

290. 0.0001

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

291. 0.0001

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

292. 0.0001

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

293. 0.0001

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

294. 0.0001

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

295. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

297. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

299. 0.0001

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

300. 0.0001

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

301. 0.0001

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

302. 0.0001

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

303. 0.0001

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

304. 0.0001

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

305. 0.0001

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

306. 0.0001

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

307. 0.0001

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

308. 0.0001

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

309. 0.0001

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

310. 0.0001

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

311. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

313. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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 <> ''

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

315. 0.0001

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

316. 0.0001

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

317. 0.0001

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

318. 0.0001

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

319. 0.0001

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

320. 0.0001

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

321. 0.0001

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

322. 0.0001

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

323. 0.0001

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

324. 0.0001

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

325. 0.0001

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

326. 0.0001

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

327. 0.0001

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

328. 0.0001

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

329. 0.0001

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

330. 0.0001

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

331. 0.0001

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

332. 0.0001

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

333. 0.0001

     SELECT ssr.ssrubr_id, ssr.ssrubr_slug, ssr.ssrubr_mail, ssr.ssrubr_mail_bis, ssr.ssrubr_keywords, ssr.ssrubr_bt2, ssr.ssrubr_photo, c.cate_title_slug, f.fami_url FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id IN (519,509,1037,514,513,511,515,512,510,523)

334. 0.0002

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (500029,477180,467076,474717,472039,290288,425208,412063,397333,397282,393016,89631,147117,372193,367770,292525,342261,98381,170959,248396,234892,229932,227780,218669,217666,206661,205467,205162,204216,201823,161566,188468,91663,162456,146771,144821,137802,118034,86474,79143,78002,74254,67042,62954,33163,6064,159674,544149,538063,526533,510703,511816,492644,342459,408639,472433,446239)

335. 0.0002

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (500029,477180,467076,474717,472039,290288,425208,412063,397333,397282,393016,89631,147117,372193,367770,292525,342261,98381,170959,248396,234892,229932,227780,218669,217666,206661,205467,205162,204216,201823,161566,188468,91663,162456,146771,144821,137802,118034,86474,79143,78002,74254,67042,62954,33163,6064,159674,544149,538063,526533,510703,511816,492644,342459,408639,472433,446239)

336. 0.0001

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

337. 0.0001

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

338. 0.0001

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

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

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

341. 0.0009

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

342. 0.0221

     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'

343. 0.0168

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

343 requetes sql en 0.1501