Location jardin privé

1. 0.0003

   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='salle'

3. 0.0001

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

4. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

5. 0.0004

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

6. 0.0002

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

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='jardin'

11. 0.0823

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

12. 0.0001

    SELECT * FROM texte WHERE cate_id=176

13. 0.0003

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

14. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='jardin' AND cate_id='176'

15. 0.0596

    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='176' AND MATCH (wish_desc) AGAINST ('(+jardin*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND type_id=1 GROUP BY wish_id

16. 0.0002

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

17. 0.0001

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

18. 0.0001

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

19. 0.0001

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

20. 0.0001

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

21. 0.0001

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

22. 0.0001

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

23. 0.0001

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

24. 0.0001

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

25. 0.0001

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

26. 0.0001

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

27. 0.0001

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

28. 0.0001

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

29. 0.0001

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

30. 0.0001

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

31. 0.0001

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

32. 0.0001

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

33. 0.0001

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

34. 0.0001

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

35. 0.0001

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

36. 0.0001

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

37. 0.0001

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

38. 0.0001

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

39. 0.0001

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

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

43. 0.0001

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

44. 0.0001

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

45. 0.0001

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

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

47. 0.0001

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

48. 0.0001

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

49. 0.0001

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

50. 0.0001

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

51. 0.0001

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

52. 0.0001

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

53. 0.0001

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

54. 0.0001

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

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

65. 0.0001

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

66. 0.0001

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

67. 0.0001

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

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

69. 0.0001

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

70. 0.0001

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

71. 0.0001

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

72. 0.0001

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

73. 0.0001

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

81. 0.0001

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

82. 0.0001

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

89. 0.0001

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

90. 0.0001

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

91. 0.0001

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

92. 0.0001

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

93. 0.0001

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

94. 0.0002

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

95. 0.0001

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

96. 0.0001

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

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

101. 0.0001

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

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

103. 0.0001

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

104. 0.0001

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

105. 0.0001

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

106. 0.0001

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

120. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

128. 0.0001

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

129. 0.0001

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

130. 0.0001

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

131. 0.0001

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

132. 0.0003

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

133. 0.0001

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

134. 0.0002

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

135. 0.0001

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

136. 0.0002

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

137. 0.0001

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

138. 0.0002

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

139. 0.0001

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

140. 0.0002

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

141. 0.0001

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

142. 0.0002

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

143. 0.0001

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

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

145. 0.0001

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

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

147. 0.0001

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

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

149. 0.0001

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

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

151. 0.0001

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

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

153. 0.0001

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

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

155. 0.0001

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

156. 0.0001

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

157. 0.0001

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

158. 0.0002

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

159. 0.0001

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

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

161. 0.0001

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

162. 0.0002

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

163. 0.0001

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

164. 0.0002

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

165. 0.0001

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

166. 0.0002

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

167. 0.0001

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

168. 0.0002

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

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

172. 0.0001

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

173. 0.0001

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

174. 0.0001

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

175. 0.0001

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

176. 0.0001

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

177. 0.0001

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

178. 0.0001

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

179. 0.0001

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

180. 0.0002

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

181. 0.0001

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

182. 0.0001

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

183. 0.0001

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

184. 0.0002

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

185. 0.0001

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

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

187. 0.0001

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

188. 0.0002

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

189. 0.0001

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

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

191. 0.0001

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

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

193. 0.0001

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

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

195. 0.0001

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

196. 0.0002

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

197. 0.0001

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

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

199. 0.0001

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

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

201. 0.0001

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

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

203. 0.0001

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

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

205. 0.0001

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

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

207. 0.0001

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

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

209. 0.0001

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

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

211. 0.0001

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

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

213. 0.0001

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

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

215. 0.0001

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

216. 0.0002

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

217. 0.0001

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

218. 0.0001

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

219. 0.0001

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

220. 0.0001

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

221. 0.0001

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

222. 0.0001

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

223. 0.0001

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

224. 0.0001

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

225. 0.0001

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

226. 0.0001

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

227. 0.0001

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

228. 0.0001

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

229. 0.0001

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

230. 0.0002

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

231. 0.0001

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

232. 0.0001

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

233. 0.0001

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

234. 0.0001

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

235. 0.0001

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

236. 0.0001

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

237. 0.0001

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

238. 0.0001

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

239. 0.0001

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

240. 0.0001

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

241. 0.0001

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

242. 0.0001

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

243. 0.0001

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

244. 0.0001

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

245. 0.0001

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

246. 0.0001

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

247. 0.0001

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

248. 0.0001

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

249. 0.0001

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

250. 0.0001

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

251. 0.0001

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

252. 0.0001

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

253. 0.0001

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

254. 0.0001

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

255. 0.0001

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

256. 0.0001

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

257. 0.0001

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

258. 0.0001

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

259. 0.0001

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

260. 0.0001

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

261. 0.0001

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

262. 0.0001

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

263. 0.0001

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

264. 0.0001

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

265. 0.0001

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

266. 0.0001

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

267. 0.0001

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

268. 0.0001

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

269. 0.0001

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

270. 0.0001

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

271. 0.0001

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

272. 0.0001

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

273. 0.0001

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

274. 0.0001

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

275. 0.0001

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

276. 0.0001

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

277. 0.0001

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

278. 0.0001

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

279. 0.0001

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

280. 0.0001

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

281. 0.0001

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

282. 0.0001

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

283. 0.0001

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

284. 0.0001

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

285. 0.0001

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

286. 0.0001

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

287. 0.0001

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

288. 0.0001

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

289. 0.0001

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

290. 0.0001

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

291. 0.0001

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

292. 0.0001

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

293. 0.0001

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

294. 0.0001

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

295. 0.0001

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

296. 0.0001

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

297. 0.0001

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

298. 0.0001

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

299. 0.0001

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

300. 0.0001

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

301. 0.0001

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

302. 0.0001

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

303. 0.0001

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

304. 0.0001

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

305. 0.0001

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

306. 0.0001

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

307. 0.0001

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

308. 0.0001

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

309. 0.0001

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

310. 0.0001

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

311. 0.0001

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

312. 0.0001

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

313. 0.0001

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

314. 0.0001

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

315. 0.0001

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

316. 0.0001

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

317. 0.0001

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

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

319. 0.0001

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

320. 0.0001

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

321. 0.0001

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

322. 0.0001

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

323. 0.0001

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

324. 0.0001

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

325. 0.0001

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

326. 0.0001

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

327. 0.0001

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

328. 0.0001

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

329. 0.0001

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

330. 0.0001

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

331. 0.0001

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

332. 0.0001

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

333. 0.0001

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

334. 0.0001

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

335. 0.0001

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

336. 0.0001

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

337. 0.0001

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

338. 0.0001

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

339. 0.0001

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

340. 0.0001

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

341. 0.0001

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

342. 0.0001

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

343. 0.0001

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

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

345. 0.0001

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

346. 0.0001

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

347. 0.0001

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

348. 0.0001

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

349. 0.0001

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

350. 0.0001

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

351. 0.0001

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

352. 0.0001

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

353. 0.0001

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

354. 0.0001

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

355. 0.0001

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

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

357. 0.0001

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

358. 0.0001

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

359. 0.0001

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

360. 0.0001

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

361. 0.0001

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

362. 0.0001

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

363. 0.0001

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

364. 0.0001

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

365. 0.0001

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

366. 0.0001

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

367. 0.0001

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

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

369. 0.0001

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

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

371. 0.0001

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

372. 0.0001

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

373. 0.0001

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

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

375. 0.0001

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

376. 0.0001

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

377. 0.0001

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

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

379. 0.0001

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

380. 0.0001

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

381. 0.0001

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

382. 0.0001

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

383. 0.0001

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

384. 0.0001

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

385. 0.0001

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

386. 0.0001

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

387. 0.0001

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

388. 0.0001

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

389. 0.0001

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

390. 0.0001

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

391. 0.0001

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

392. 0.0001

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

393. 0.0001

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

394. 0.0001

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

395. 0.0001

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

396. 0.0001

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

397. 0.0001

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

398. 0.0001

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

399. 0.0001

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

400. 0.0001

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

401. 0.0001

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

402. 0.0001

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

403. 0.0001

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

404. 0.0001

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

405. 0.0001

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

406. 0.0001

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

407. 0.0001

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

408. 0.0001

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

409. 0.0001

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

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

411. 0.0001

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

412. 0.0001

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

413. 0.0001

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

414. 0.0001

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

415. 0.0001

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

416. 0.0001

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

417. 0.0001

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

418. 0.0001

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

419. 0.0001

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

420. 0.0001

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

421. 0.0001

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

422. 0.0001

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

423. 0.0001

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

424. 0.0001

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

425. 0.0001

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

426. 0.0001

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

427. 0.0001

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

428. 0.0001

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

429. 0.0001

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

430. 0.0001

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

431. 0.0001

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

432. 0.0001

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

433. 0.0001

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

434. 0.0001

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

435. 0.0001

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

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

437. 0.0001

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

438. 0.0001

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

439. 0.0001

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

440. 0.0001

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

441. 0.0001

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

442. 0.0001

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

443. 0.0001

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

444. 0.0001

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

445. 0.0001

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

446. 0.0001

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

447. 0.0001

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

448. 0.0001

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

449. 0.0001

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

450. 0.0001

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

451. 0.0001

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

452. 0.0001

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

453. 0.0001

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

454. 0.0001

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

455. 0.0001

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

456. 0.0001

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

457. 0.0001

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

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

459. 0.0001

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

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

461. 0.0001

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

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

463. 0.0001

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

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

465. 0.0001

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

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

467. 0.0001

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

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

469. 0.0001

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

470. 0.0001

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

471. 0.0001

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

472. 0.0001

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

473. 0.0001

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

474. 0.0001

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

475. 0.0001

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

476. 0.0001

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

477. 0.0001

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

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

479. 0.0001

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

480. 0.0002

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

481. 0.0001

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

482. 0.0001

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

483. 0.0001

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

484. 0.0001

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

485. 0.0001

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

486. 0.0001

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

487. 0.0001

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

488. 0.0001

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

489. 0.0001

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

490. 0.0001

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

491. 0.0001

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

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

493. 0.0001

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

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

495. 0.0001

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

496. 0.0001

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

497. 0.0001

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

498. 0.0001

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

499. 0.0001

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

500. 0.0001

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

501. 0.0001

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

502. 0.0001

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

503. 0.0001

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

504. 0.0001

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

505. 0.0001

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

506. 0.0001

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

507. 0.0001

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

508. 0.0001

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

509. 0.0001

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

510. 0.0001

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

511. 0.0001

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

512. 0.0001

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

513. 0.0001

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

514. 0.0001

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

515. 0.0001

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

516. 0.0001

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

517. 0.0001

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

518. 0.0002

     SELECT ssr.ssrubr_id, ssr.ssrubr_slug, ssr.ssrubr_mail, ssr.ssrubr_mail_bis, ssr.ssrubr_keywords, ssr.ssrubr_bt2, ssr.ssrubr_photo, c.cate_title_slug, f.fami_url FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id IN (496,928,929,790,889,852,1112,1149,1192)

519. 0.0002

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (436640,192916,231490,357268,241271,319597,269487,326606,281358,262979,260883,256733,255890,219974,207516,197611,133847,96027,45416,549883,521601,531032,522114,527802,519869,356678,510299,501980,407766,491396,463464,262333,457800,450456,454054,190328,438848,438426,401178,110967,427506,425041,382620,374036,373615,322787,356834,354941,353913,351031,350813,293550,266901)

520. 0.0002

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (436640,192916,231490,357268,241271,319597,269487,326606,281358,262979,260883,256733,255890,219974,207516,197611,133847,96027,45416,549883,521601,531032,522114,527802,519869,356678,510299,501980,407766,491396,463464,262333,457800,450456,454054,190328,438848,438426,401178,110967,427506,425041,382620,374036,373615,322787,356834,354941,353913,351031,350813,293550,266901)

521. 0.0003

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

522. 0.0002

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

523. 0.0001

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

524. 0

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

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

526. 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 (176) ORDER BY ssrubr_order ASC

527. 0.0009

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

528. 0.0251

     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'

529. 0.0172

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

529 requetes sql en 0.2456