Location groupe électrogène

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='materiel-bricolage'

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

4. 0.0003

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

5. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='groupe électrogène'

6. 0.1509

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='87'AND MATCH (wish_title,wish_desc) AGAINST ('+groupe électrogène*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10)

7. 0.0001

   SELECT * FROM texte WHERE cate_id=87

8. 0.0004

   SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='groupe électrogène' OR ssrubr_slug='groupe-électrogène' OR (ssrubr_title like '%groupe électrogène%')) AND cate_id='87' ORDER BY ssrubr_id LIMIT 0,1

9. 0.0001

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

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

11. 0.0003

    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 (87) ORDER BY ssrubr_order ASC

12. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='groupe-electrogene' AND cate_id='87'

13. 0.1673

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='87' AND MATCH (wish_desc) AGAINST ('(+groupe +électrogène*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10)

14. 0.1434

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id 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='87' AND MATCH (wish_desc) AGAINST ('(+groupe +électrogène*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND type_id=1 GROUP BY wish_id

15. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 6375 AND W.type_id = 1) OR (W.util_id != 6375 AND W.type_id = 2)) AND (`post_util_id` = 6375 OR `dest_util_id` = 6375) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

16. 0.0001

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

17. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 11756 AND W.type_id = 1) OR (W.util_id != 11756 AND W.type_id = 2)) AND (`post_util_id` = 11756 OR `dest_util_id` = 11756) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

18. 0.0001

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

19. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 19490 AND W.type_id = 1) OR (W.util_id != 19490 AND W.type_id = 2)) AND (`post_util_id` = 19490 OR `dest_util_id` = 19490) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

20. 0.0001

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

21. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 15951 AND W.type_id = 1) OR (W.util_id != 15951 AND W.type_id = 2)) AND (`post_util_id` = 15951 OR `dest_util_id` = 15951) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

22. 0.0001

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

23. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 25707 AND W.type_id = 1) OR (W.util_id != 25707 AND W.type_id = 2)) AND (`post_util_id` = 25707 OR `dest_util_id` = 25707) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

24. 0.0001

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

25. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 29003 AND W.type_id = 1) OR (W.util_id != 29003 AND W.type_id = 2)) AND (`post_util_id` = 29003 OR `dest_util_id` = 29003) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

26. 0.0001

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

27. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 34465 AND W.type_id = 1) OR (W.util_id != 34465 AND W.type_id = 2)) AND (`post_util_id` = 34465 OR `dest_util_id` = 34465) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

28. 0.0001

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

29. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 44190 AND W.type_id = 1) OR (W.util_id != 44190 AND W.type_id = 2)) AND (`post_util_id` = 44190 OR `dest_util_id` = 44190) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

30. 0.0001

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

31. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 48025 AND W.type_id = 1) OR (W.util_id != 48025 AND W.type_id = 2)) AND (`post_util_id` = 48025 OR `dest_util_id` = 48025) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

32. 0.0001

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

33. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 51989 AND W.type_id = 1) OR (W.util_id != 51989 AND W.type_id = 2)) AND (`post_util_id` = 51989 OR `dest_util_id` = 51989) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

34. 0.0001

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

35. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 52259 AND W.type_id = 1) OR (W.util_id != 52259 AND W.type_id = 2)) AND (`post_util_id` = 52259 OR `dest_util_id` = 52259) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

36. 0.0001

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

37. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 54553 AND W.type_id = 1) OR (W.util_id != 54553 AND W.type_id = 2)) AND (`post_util_id` = 54553 OR `dest_util_id` = 54553) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

38. 0.0001

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

39. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 55004 AND W.type_id = 1) OR (W.util_id != 55004 AND W.type_id = 2)) AND (`post_util_id` = 55004 OR `dest_util_id` = 55004) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

40. 0.0001

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

41. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 58318 AND W.type_id = 1) OR (W.util_id != 58318 AND W.type_id = 2)) AND (`post_util_id` = 58318 OR `dest_util_id` = 58318) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

42. 0.0001

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

43. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 60917 AND W.type_id = 1) OR (W.util_id != 60917 AND W.type_id = 2)) AND (`post_util_id` = 60917 OR `dest_util_id` = 60917) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

44. 0.0001

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

45. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 68025 AND W.type_id = 1) OR (W.util_id != 68025 AND W.type_id = 2)) AND (`post_util_id` = 68025 OR `dest_util_id` = 68025) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

46. 0.0001

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

47. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 68991 AND W.type_id = 1) OR (W.util_id != 68991 AND W.type_id = 2)) AND (`post_util_id` = 68991 OR `dest_util_id` = 68991) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

48. 0.0001

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

49. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 69161 AND W.type_id = 1) OR (W.util_id != 69161 AND W.type_id = 2)) AND (`post_util_id` = 69161 OR `dest_util_id` = 69161) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

50. 0.0001

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

51. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 72771 AND W.type_id = 1) OR (W.util_id != 72771 AND W.type_id = 2)) AND (`post_util_id` = 72771 OR `dest_util_id` = 72771) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

52. 0.0001

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

53. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 73753 AND W.type_id = 1) OR (W.util_id != 73753 AND W.type_id = 2)) AND (`post_util_id` = 73753 OR `dest_util_id` = 73753) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

54. 0.0001

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

55. 0.0003

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 11888 AND W.type_id = 1) OR (W.util_id != 11888 AND W.type_id = 2)) AND (`post_util_id` = 11888 OR `dest_util_id` = 11888) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

56. 0.0001

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

57. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 61854 AND W.type_id = 1) OR (W.util_id != 61854 AND W.type_id = 2)) AND (`post_util_id` = 61854 OR `dest_util_id` = 61854) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

58. 0.0001

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

59. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 82785 AND W.type_id = 1) OR (W.util_id != 82785 AND W.type_id = 2)) AND (`post_util_id` = 82785 OR `dest_util_id` = 82785) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

60. 0.0001

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

61. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 93219 AND W.type_id = 1) OR (W.util_id != 93219 AND W.type_id = 2)) AND (`post_util_id` = 93219 OR `dest_util_id` = 93219) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

62. 0.0001

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

63. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 101076 AND W.type_id = 1) OR (W.util_id != 101076 AND W.type_id = 2)) AND (`post_util_id` = 101076 OR `dest_util_id` = 101076) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

64. 0.0001

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

65. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 100935 AND W.type_id = 1) OR (W.util_id != 100935 AND W.type_id = 2)) AND (`post_util_id` = 100935 OR `dest_util_id` = 100935) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

66. 0.0001

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

67. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 108173 AND W.type_id = 1) OR (W.util_id != 108173 AND W.type_id = 2)) AND (`post_util_id` = 108173 OR `dest_util_id` = 108173) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

68. 0.0001

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

69. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 96027 OR `dest_util_id` = 96027) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

71. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 111837 AND W.type_id = 1) OR (W.util_id != 111837 AND W.type_id = 2)) AND (`post_util_id` = 111837 OR `dest_util_id` = 111837) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

72. 0.0001

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

73. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 111972 AND W.type_id = 1) OR (W.util_id != 111972 AND W.type_id = 2)) AND (`post_util_id` = 111972 OR `dest_util_id` = 111972) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

74. 0.0001

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

75. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 111971 AND W.type_id = 1) OR (W.util_id != 111971 AND W.type_id = 2)) AND (`post_util_id` = 111971 OR `dest_util_id` = 111971) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

76. 0.0001

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

77. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 114618 AND W.type_id = 1) OR (W.util_id != 114618 AND W.type_id = 2)) AND (`post_util_id` = 114618 OR `dest_util_id` = 114618) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

78. 0.0001

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

79. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 117475 AND W.type_id = 1) OR (W.util_id != 117475 AND W.type_id = 2)) AND (`post_util_id` = 117475 OR `dest_util_id` = 117475) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

80. 0.0001

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

81. 0.0003

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 20429 AND W.type_id = 1) OR (W.util_id != 20429 AND W.type_id = 2)) AND (`post_util_id` = 20429 OR `dest_util_id` = 20429) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

82. 0.0001

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

83. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 121535 AND W.type_id = 1) OR (W.util_id != 121535 AND W.type_id = 2)) AND (`post_util_id` = 121535 OR `dest_util_id` = 121535) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

84. 0.0001

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

85. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 121487 AND W.type_id = 1) OR (W.util_id != 121487 AND W.type_id = 2)) AND (`post_util_id` = 121487 OR `dest_util_id` = 121487) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

86. 0.0001

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

87. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 129324 AND W.type_id = 1) OR (W.util_id != 129324 AND W.type_id = 2)) AND (`post_util_id` = 129324 OR `dest_util_id` = 129324) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

88. 0.0001

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

89. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 130714 AND W.type_id = 1) OR (W.util_id != 130714 AND W.type_id = 2)) AND (`post_util_id` = 130714 OR `dest_util_id` = 130714) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

90. 0.0001

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

91. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 133305 AND W.type_id = 1) OR (W.util_id != 133305 AND W.type_id = 2)) AND (`post_util_id` = 133305 OR `dest_util_id` = 133305) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

92. 0.0001

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

93. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 141391 AND W.type_id = 1) OR (W.util_id != 141391 AND W.type_id = 2)) AND (`post_util_id` = 141391 OR `dest_util_id` = 141391) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

94. 0.0001

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

95. 0.0003

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 86924 AND W.type_id = 1) OR (W.util_id != 86924 AND W.type_id = 2)) AND (`post_util_id` = 86924 OR `dest_util_id` = 86924) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

96. 0.0001

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

97. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 143869 AND W.type_id = 1) OR (W.util_id != 143869 AND W.type_id = 2)) AND (`post_util_id` = 143869 OR `dest_util_id` = 143869) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

98. 0.0001

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

99. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 145420 AND W.type_id = 1) OR (W.util_id != 145420 AND W.type_id = 2)) AND (`post_util_id` = 145420 OR `dest_util_id` = 145420) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

100. 0.0001

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

101. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 145888 AND W.type_id = 1) OR (W.util_id != 145888 AND W.type_id = 2)) AND (`post_util_id` = 145888 OR `dest_util_id` = 145888) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

102. 0.0001

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

103. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 145888 AND W.type_id = 1) OR (W.util_id != 145888 AND W.type_id = 2)) AND (`post_util_id` = 145888 OR `dest_util_id` = 145888) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

104. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 7203 AND W.type_id = 1) OR (W.util_id != 7203 AND W.type_id = 2)) AND (`post_util_id` = 7203 OR `dest_util_id` = 7203) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

105. 0.0001

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

106. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 149511 AND W.type_id = 1) OR (W.util_id != 149511 AND W.type_id = 2)) AND (`post_util_id` = 149511 OR `dest_util_id` = 149511) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

107. 0.0001

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

108. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 151180 AND W.type_id = 1) OR (W.util_id != 151180 AND W.type_id = 2)) AND (`post_util_id` = 151180 OR `dest_util_id` = 151180) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

109. 0.0001

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

110. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 61621 AND W.type_id = 1) OR (W.util_id != 61621 AND W.type_id = 2)) AND (`post_util_id` = 61621 OR `dest_util_id` = 61621) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

111. 0.0001

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

112. 0.0003

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 152492 AND W.type_id = 1) OR (W.util_id != 152492 AND W.type_id = 2)) AND (`post_util_id` = 152492 OR `dest_util_id` = 152492) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

113. 0.0001

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

114. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 153291 AND W.type_id = 1) OR (W.util_id != 153291 AND W.type_id = 2)) AND (`post_util_id` = 153291 OR `dest_util_id` = 153291) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

115. 0.0001

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

116. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 134844 AND W.type_id = 1) OR (W.util_id != 134844 AND W.type_id = 2)) AND (`post_util_id` = 134844 OR `dest_util_id` = 134844) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

117. 0.0001

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

118. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 162314 AND W.type_id = 1) OR (W.util_id != 162314 AND W.type_id = 2)) AND (`post_util_id` = 162314 OR `dest_util_id` = 162314) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

119. 0.0001

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

120. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 165554 AND W.type_id = 1) OR (W.util_id != 165554 AND W.type_id = 2)) AND (`post_util_id` = 165554 OR `dest_util_id` = 165554) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

121. 0.0001

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

122. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 166799 AND W.type_id = 1) OR (W.util_id != 166799 AND W.type_id = 2)) AND (`post_util_id` = 166799 OR `dest_util_id` = 166799) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

123. 0.0001

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

124. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 175005 AND W.type_id = 1) OR (W.util_id != 175005 AND W.type_id = 2)) AND (`post_util_id` = 175005 OR `dest_util_id` = 175005) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

125. 0.0001

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

126. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 186328 AND W.type_id = 1) OR (W.util_id != 186328 AND W.type_id = 2)) AND (`post_util_id` = 186328 OR `dest_util_id` = 186328) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

127. 0.0001

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

128. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 187988 AND W.type_id = 1) OR (W.util_id != 187988 AND W.type_id = 2)) AND (`post_util_id` = 187988 OR `dest_util_id` = 187988) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

129. 0.0001

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

130. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 189148 AND W.type_id = 1) OR (W.util_id != 189148 AND W.type_id = 2)) AND (`post_util_id` = 189148 OR `dest_util_id` = 189148) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

131. 0.0001

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

132. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 100454 AND W.type_id = 1) OR (W.util_id != 100454 AND W.type_id = 2)) AND (`post_util_id` = 100454 OR `dest_util_id` = 100454) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

133. 0.0001

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

134. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 21904 AND W.type_id = 1) OR (W.util_id != 21904 AND W.type_id = 2)) AND (`post_util_id` = 21904 OR `dest_util_id` = 21904) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

135. 0.0001

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

136. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 193630 AND W.type_id = 1) OR (W.util_id != 193630 AND W.type_id = 2)) AND (`post_util_id` = 193630 OR `dest_util_id` = 193630) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

137. 0.0001

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

138. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 198952 AND W.type_id = 1) OR (W.util_id != 198952 AND W.type_id = 2)) AND (`post_util_id` = 198952 OR `dest_util_id` = 198952) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

139. 0.0001

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

140. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 200184 AND W.type_id = 1) OR (W.util_id != 200184 AND W.type_id = 2)) AND (`post_util_id` = 200184 OR `dest_util_id` = 200184) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

141. 0.0001

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

142. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 182715 AND W.type_id = 1) OR (W.util_id != 182715 AND W.type_id = 2)) AND (`post_util_id` = 182715 OR `dest_util_id` = 182715) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

143. 0.0001

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

144. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 202875 AND W.type_id = 1) OR (W.util_id != 202875 AND W.type_id = 2)) AND (`post_util_id` = 202875 OR `dest_util_id` = 202875) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

145. 0.0001

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

146. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 203319 AND W.type_id = 1) OR (W.util_id != 203319 AND W.type_id = 2)) AND (`post_util_id` = 203319 OR `dest_util_id` = 203319) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

147. 0.0001

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

148. 0.0003

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 206240 AND W.type_id = 1) OR (W.util_id != 206240 AND W.type_id = 2)) AND (`post_util_id` = 206240 OR `dest_util_id` = 206240) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

149. 0.0001

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

150. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 207473 AND W.type_id = 1) OR (W.util_id != 207473 AND W.type_id = 2)) AND (`post_util_id` = 207473 OR `dest_util_id` = 207473) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

151. 0.0001

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

152. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 211126 AND W.type_id = 1) OR (W.util_id != 211126 AND W.type_id = 2)) AND (`post_util_id` = 211126 OR `dest_util_id` = 211126) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

153. 0.0001

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

154. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 214721 AND W.type_id = 1) OR (W.util_id != 214721 AND W.type_id = 2)) AND (`post_util_id` = 214721 OR `dest_util_id` = 214721) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

155. 0.0003

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

156. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 58095 AND W.type_id = 1) OR (W.util_id != 58095 AND W.type_id = 2)) AND (`post_util_id` = 58095 OR `dest_util_id` = 58095) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

157. 0.0001

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

158. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 132533 AND W.type_id = 1) OR (W.util_id != 132533 AND W.type_id = 2)) AND (`post_util_id` = 132533 OR `dest_util_id` = 132533) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

159. 0.0001

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

160. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 97433 AND W.type_id = 1) OR (W.util_id != 97433 AND W.type_id = 2)) AND (`post_util_id` = 97433 OR `dest_util_id` = 97433) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

161. 0.0001

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

162. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 222775 AND W.type_id = 1) OR (W.util_id != 222775 AND W.type_id = 2)) AND (`post_util_id` = 222775 OR `dest_util_id` = 222775) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

163. 0.0001

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

164. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 223163 AND W.type_id = 1) OR (W.util_id != 223163 AND W.type_id = 2)) AND (`post_util_id` = 223163 OR `dest_util_id` = 223163) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

165. 0.0001

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

166. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 196452 AND W.type_id = 1) OR (W.util_id != 196452 AND W.type_id = 2)) AND (`post_util_id` = 196452 OR `dest_util_id` = 196452) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

167. 0.0001

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

168. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 227081 AND W.type_id = 1) OR (W.util_id != 227081 AND W.type_id = 2)) AND (`post_util_id` = 227081 OR `dest_util_id` = 227081) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

169. 0.0001

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

170. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 202019 AND W.type_id = 1) OR (W.util_id != 202019 AND W.type_id = 2)) AND (`post_util_id` = 202019 OR `dest_util_id` = 202019) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

171. 0.0001

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

172. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 214527 AND W.type_id = 1) OR (W.util_id != 214527 AND W.type_id = 2)) AND (`post_util_id` = 214527 OR `dest_util_id` = 214527) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

173. 0.0001

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

174. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 96032 AND W.type_id = 1) OR (W.util_id != 96032 AND W.type_id = 2)) AND (`post_util_id` = 96032 OR `dest_util_id` = 96032) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

175. 0.0001

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

176. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 239507 AND W.type_id = 1) OR (W.util_id != 239507 AND W.type_id = 2)) AND (`post_util_id` = 239507 OR `dest_util_id` = 239507) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

177. 0.0001

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

178. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 156673 AND W.type_id = 1) OR (W.util_id != 156673 AND W.type_id = 2)) AND (`post_util_id` = 156673 OR `dest_util_id` = 156673) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

179. 0.0001

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

180. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 244041 AND W.type_id = 1) OR (W.util_id != 244041 AND W.type_id = 2)) AND (`post_util_id` = 244041 OR `dest_util_id` = 244041) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

181. 0.0001

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

182. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 245504 AND W.type_id = 1) OR (W.util_id != 245504 AND W.type_id = 2)) AND (`post_util_id` = 245504 OR `dest_util_id` = 245504) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

183. 0.0001

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

184. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 249323 AND W.type_id = 1) OR (W.util_id != 249323 AND W.type_id = 2)) AND (`post_util_id` = 249323 OR `dest_util_id` = 249323) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

185. 0.0001

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

186. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 251615 AND W.type_id = 1) OR (W.util_id != 251615 AND W.type_id = 2)) AND (`post_util_id` = 251615 OR `dest_util_id` = 251615) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

187. 0.0001

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

188. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 251850 AND W.type_id = 1) OR (W.util_id != 251850 AND W.type_id = 2)) AND (`post_util_id` = 251850 OR `dest_util_id` = 251850) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

189. 0.0001

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

190. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 252545 AND W.type_id = 1) OR (W.util_id != 252545 AND W.type_id = 2)) AND (`post_util_id` = 252545 OR `dest_util_id` = 252545) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

191. 0.0001

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

192. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 255161 AND W.type_id = 1) OR (W.util_id != 255161 AND W.type_id = 2)) AND (`post_util_id` = 255161 OR `dest_util_id` = 255161) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

193. 0.0001

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

194. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 270512 AND W.type_id = 1) OR (W.util_id != 270512 AND W.type_id = 2)) AND (`post_util_id` = 270512 OR `dest_util_id` = 270512) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

195. 0.0001

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

196. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 283387 AND W.type_id = 1) OR (W.util_id != 283387 AND W.type_id = 2)) AND (`post_util_id` = 283387 OR `dest_util_id` = 283387) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

197. 0.0001

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

198. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 292707 AND W.type_id = 1) OR (W.util_id != 292707 AND W.type_id = 2)) AND (`post_util_id` = 292707 OR `dest_util_id` = 292707) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

199. 0.0001

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

200. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 293717 AND W.type_id = 1) OR (W.util_id != 293717 AND W.type_id = 2)) AND (`post_util_id` = 293717 OR `dest_util_id` = 293717) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

201. 0.0001

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

202. 0.0006

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 138228 AND W.type_id = 1) OR (W.util_id != 138228 AND W.type_id = 2)) AND (`post_util_id` = 138228 OR `dest_util_id` = 138228) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

203. 0.0001

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

204. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 296667 AND W.type_id = 1) OR (W.util_id != 296667 AND W.type_id = 2)) AND (`post_util_id` = 296667 OR `dest_util_id` = 296667) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

205. 0.0001

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

206. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 296947 AND W.type_id = 1) OR (W.util_id != 296947 AND W.type_id = 2)) AND (`post_util_id` = 296947 OR `dest_util_id` = 296947) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

207. 0.0001

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

208. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 300274 AND W.type_id = 1) OR (W.util_id != 300274 AND W.type_id = 2)) AND (`post_util_id` = 300274 OR `dest_util_id` = 300274) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

209. 0.0001

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

210. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 303233 AND W.type_id = 1) OR (W.util_id != 303233 AND W.type_id = 2)) AND (`post_util_id` = 303233 OR `dest_util_id` = 303233) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

211. 0.0001

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

212. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 303233 AND W.type_id = 1) OR (W.util_id != 303233 AND W.type_id = 2)) AND (`post_util_id` = 303233 OR `dest_util_id` = 303233) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

213. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 181631 AND W.type_id = 1) OR (W.util_id != 181631 AND W.type_id = 2)) AND (`post_util_id` = 181631 OR `dest_util_id` = 181631) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

214. 0.0001

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

215. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 308602 AND W.type_id = 1) OR (W.util_id != 308602 AND W.type_id = 2)) AND (`post_util_id` = 308602 OR `dest_util_id` = 308602) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

216. 0.0001

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

217. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 309226 AND W.type_id = 1) OR (W.util_id != 309226 AND W.type_id = 2)) AND (`post_util_id` = 309226 OR `dest_util_id` = 309226) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

218. 0.0001

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

219. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 309504 AND W.type_id = 1) OR (W.util_id != 309504 AND W.type_id = 2)) AND (`post_util_id` = 309504 OR `dest_util_id` = 309504) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

220. 0.0001

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

221. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 309504 AND W.type_id = 1) OR (W.util_id != 309504 AND W.type_id = 2)) AND (`post_util_id` = 309504 OR `dest_util_id` = 309504) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

222. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 313057 AND W.type_id = 1) OR (W.util_id != 313057 AND W.type_id = 2)) AND (`post_util_id` = 313057 OR `dest_util_id` = 313057) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

223. 0.0001

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

224. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 313431 AND W.type_id = 1) OR (W.util_id != 313431 AND W.type_id = 2)) AND (`post_util_id` = 313431 OR `dest_util_id` = 313431) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

225. 0.0001

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

226. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 266181 AND W.type_id = 1) OR (W.util_id != 266181 AND W.type_id = 2)) AND (`post_util_id` = 266181 OR `dest_util_id` = 266181) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

227. 0.0001

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

228. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 259597 AND W.type_id = 1) OR (W.util_id != 259597 AND W.type_id = 2)) AND (`post_util_id` = 259597 OR `dest_util_id` = 259597) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

229. 0.0001

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

230. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 315817 AND W.type_id = 1) OR (W.util_id != 315817 AND W.type_id = 2)) AND (`post_util_id` = 315817 OR `dest_util_id` = 315817) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

231. 0.0001

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

232. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 316270 AND W.type_id = 1) OR (W.util_id != 316270 AND W.type_id = 2)) AND (`post_util_id` = 316270 OR `dest_util_id` = 316270) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

233. 0.0001

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

234. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 315512 AND W.type_id = 1) OR (W.util_id != 315512 AND W.type_id = 2)) AND (`post_util_id` = 315512 OR `dest_util_id` = 315512) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

235. 0.0001

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

236. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 17406 AND W.type_id = 1) OR (W.util_id != 17406 AND W.type_id = 2)) AND (`post_util_id` = 17406 OR `dest_util_id` = 17406) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

237. 0.0001

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

238. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 325687 AND W.type_id = 1) OR (W.util_id != 325687 AND W.type_id = 2)) AND (`post_util_id` = 325687 OR `dest_util_id` = 325687) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

239. 0.0001

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

240. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 326339 AND W.type_id = 1) OR (W.util_id != 326339 AND W.type_id = 2)) AND (`post_util_id` = 326339 OR `dest_util_id` = 326339) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

241. 0.0001

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

242. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 49145 AND W.type_id = 1) OR (W.util_id != 49145 AND W.type_id = 2)) AND (`post_util_id` = 49145 OR `dest_util_id` = 49145) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

243. 0.0001

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

244. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 333646 AND W.type_id = 1) OR (W.util_id != 333646 AND W.type_id = 2)) AND (`post_util_id` = 333646 OR `dest_util_id` = 333646) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

245. 0.0001

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

246. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 88946 AND W.type_id = 1) OR (W.util_id != 88946 AND W.type_id = 2)) AND (`post_util_id` = 88946 OR `dest_util_id` = 88946) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

247. 0.0001

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

248. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 341487 AND W.type_id = 1) OR (W.util_id != 341487 AND W.type_id = 2)) AND (`post_util_id` = 341487 OR `dest_util_id` = 341487) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

249. 0.0001

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

250. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 342542 AND W.type_id = 1) OR (W.util_id != 342542 AND W.type_id = 2)) AND (`post_util_id` = 342542 OR `dest_util_id` = 342542) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

251. 0.0001

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

252. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 345570 AND W.type_id = 1) OR (W.util_id != 345570 AND W.type_id = 2)) AND (`post_util_id` = 345570 OR `dest_util_id` = 345570) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

253. 0.0001

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

254. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 345755 AND W.type_id = 1) OR (W.util_id != 345755 AND W.type_id = 2)) AND (`post_util_id` = 345755 OR `dest_util_id` = 345755) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

255. 0.0001

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

256. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 345755 AND W.type_id = 1) OR (W.util_id != 345755 AND W.type_id = 2)) AND (`post_util_id` = 345755 OR `dest_util_id` = 345755) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

257. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 345755 AND W.type_id = 1) OR (W.util_id != 345755 AND W.type_id = 2)) AND (`post_util_id` = 345755 OR `dest_util_id` = 345755) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

258. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 348159 AND W.type_id = 1) OR (W.util_id != 348159 AND W.type_id = 2)) AND (`post_util_id` = 348159 OR `dest_util_id` = 348159) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

259. 0.0001

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

260. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 347171 OR `dest_util_id` = 347171) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

262. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 353328 AND W.type_id = 1) OR (W.util_id != 353328 AND W.type_id = 2)) AND (`post_util_id` = 353328 OR `dest_util_id` = 353328) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

263. 0.0001

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

264. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 225643 AND W.type_id = 1) OR (W.util_id != 225643 AND W.type_id = 2)) AND (`post_util_id` = 225643 OR `dest_util_id` = 225643) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

265. 0.0001

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

266. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 358117 AND W.type_id = 1) OR (W.util_id != 358117 AND W.type_id = 2)) AND (`post_util_id` = 358117 OR `dest_util_id` = 358117) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

267. 0.0001

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

268. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 372059 OR `dest_util_id` = 372059) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

270. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 375386 AND W.type_id = 1) OR (W.util_id != 375386 AND W.type_id = 2)) AND (`post_util_id` = 375386 OR `dest_util_id` = 375386) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

271. 0.0001

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

272. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 376732 AND W.type_id = 1) OR (W.util_id != 376732 AND W.type_id = 2)) AND (`post_util_id` = 376732 OR `dest_util_id` = 376732) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

273. 0.0001

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

274. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 377567 AND W.type_id = 1) OR (W.util_id != 377567 AND W.type_id = 2)) AND (`post_util_id` = 377567 OR `dest_util_id` = 377567) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

275. 0.0001

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

276. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 378522 AND W.type_id = 1) OR (W.util_id != 378522 AND W.type_id = 2)) AND (`post_util_id` = 378522 OR `dest_util_id` = 378522) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

277. 0.0001

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

278. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 377179 AND W.type_id = 1) OR (W.util_id != 377179 AND W.type_id = 2)) AND (`post_util_id` = 377179 OR `dest_util_id` = 377179) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

279. 0.0001

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

280. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 270956 AND W.type_id = 1) OR (W.util_id != 270956 AND W.type_id = 2)) AND (`post_util_id` = 270956 OR `dest_util_id` = 270956) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

281. 0.0001

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

282. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 386560 AND W.type_id = 1) OR (W.util_id != 386560 AND W.type_id = 2)) AND (`post_util_id` = 386560 OR `dest_util_id` = 386560) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

283. 0.0001

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

284. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 370787 AND W.type_id = 1) OR (W.util_id != 370787 AND W.type_id = 2)) AND (`post_util_id` = 370787 OR `dest_util_id` = 370787) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

285. 0.0001

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

286. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 387233 AND W.type_id = 1) OR (W.util_id != 387233 AND W.type_id = 2)) AND (`post_util_id` = 387233 OR `dest_util_id` = 387233) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

287. 0.0001

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

288. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 387209 AND W.type_id = 1) OR (W.util_id != 387209 AND W.type_id = 2)) AND (`post_util_id` = 387209 OR `dest_util_id` = 387209) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

289. 0.0001

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

290. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 388918 AND W.type_id = 1) OR (W.util_id != 388918 AND W.type_id = 2)) AND (`post_util_id` = 388918 OR `dest_util_id` = 388918) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

291. 0.0001

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

292. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 328291 AND W.type_id = 1) OR (W.util_id != 328291 AND W.type_id = 2)) AND (`post_util_id` = 328291 OR `dest_util_id` = 328291) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

293. 0.0001

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

294. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 389527 AND W.type_id = 1) OR (W.util_id != 389527 AND W.type_id = 2)) AND (`post_util_id` = 389527 OR `dest_util_id` = 389527) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

295. 0.0001

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

296. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 266608 AND W.type_id = 1) OR (W.util_id != 266608 AND W.type_id = 2)) AND (`post_util_id` = 266608 OR `dest_util_id` = 266608) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

297. 0.0001

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

298. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 79534 AND W.type_id = 1) OR (W.util_id != 79534 AND W.type_id = 2)) AND (`post_util_id` = 79534 OR `dest_util_id` = 79534) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

299. 0.0001

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

300. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 395348 AND W.type_id = 1) OR (W.util_id != 395348 AND W.type_id = 2)) AND (`post_util_id` = 395348 OR `dest_util_id` = 395348) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

301. 0.0001

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

302. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 396416 AND W.type_id = 1) OR (W.util_id != 396416 AND W.type_id = 2)) AND (`post_util_id` = 396416 OR `dest_util_id` = 396416) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

303. 0.0001

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

304. 0.0004

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 380641 AND W.type_id = 1) OR (W.util_id != 380641 AND W.type_id = 2)) AND (`post_util_id` = 380641 OR `dest_util_id` = 380641) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

305. 0.0001

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

306. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 290047 AND W.type_id = 1) OR (W.util_id != 290047 AND W.type_id = 2)) AND (`post_util_id` = 290047 OR `dest_util_id` = 290047) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

307. 0.0001

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

308. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 139455 AND W.type_id = 1) OR (W.util_id != 139455 AND W.type_id = 2)) AND (`post_util_id` = 139455 OR `dest_util_id` = 139455) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

309. 0.0001

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

310. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 281936 AND W.type_id = 1) OR (W.util_id != 281936 AND W.type_id = 2)) AND (`post_util_id` = 281936 OR `dest_util_id` = 281936) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

311. 0.0001

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

312. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 408990 AND W.type_id = 1) OR (W.util_id != 408990 AND W.type_id = 2)) AND (`post_util_id` = 408990 OR `dest_util_id` = 408990) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

313. 0.0001

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

314. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 169125 AND W.type_id = 1) OR (W.util_id != 169125 AND W.type_id = 2)) AND (`post_util_id` = 169125 OR `dest_util_id` = 169125) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

315. 0.0001

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

316. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 312311 AND W.type_id = 1) OR (W.util_id != 312311 AND W.type_id = 2)) AND (`post_util_id` = 312311 OR `dest_util_id` = 312311) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

317. 0.0001

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

318. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 415059 AND W.type_id = 1) OR (W.util_id != 415059 AND W.type_id = 2)) AND (`post_util_id` = 415059 OR `dest_util_id` = 415059) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

319. 0.0001

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

320. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 406879 AND W.type_id = 1) OR (W.util_id != 406879 AND W.type_id = 2)) AND (`post_util_id` = 406879 OR `dest_util_id` = 406879) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

321. 0.0001

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

322. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 419945 AND W.type_id = 1) OR (W.util_id != 419945 AND W.type_id = 2)) AND (`post_util_id` = 419945 OR `dest_util_id` = 419945) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

323. 0.0001

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

324. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 423770 AND W.type_id = 1) OR (W.util_id != 423770 AND W.type_id = 2)) AND (`post_util_id` = 423770 OR `dest_util_id` = 423770) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

325. 0.0001

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

326. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 416589 AND W.type_id = 1) OR (W.util_id != 416589 AND W.type_id = 2)) AND (`post_util_id` = 416589 OR `dest_util_id` = 416589) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

327. 0.0001

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

328. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 430562 AND W.type_id = 1) OR (W.util_id != 430562 AND W.type_id = 2)) AND (`post_util_id` = 430562 OR `dest_util_id` = 430562) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

329. 0.0001

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

330. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 281735 AND W.type_id = 1) OR (W.util_id != 281735 AND W.type_id = 2)) AND (`post_util_id` = 281735 OR `dest_util_id` = 281735) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

331. 0.0001

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

332. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 348158 AND W.type_id = 1) OR (W.util_id != 348158 AND W.type_id = 2)) AND (`post_util_id` = 348158 OR `dest_util_id` = 348158) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

333. 0.0001

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

334. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 441393 AND W.type_id = 1) OR (W.util_id != 441393 AND W.type_id = 2)) AND (`post_util_id` = 441393 OR `dest_util_id` = 441393) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

335. 0.0001

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

336. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 441953 AND W.type_id = 1) OR (W.util_id != 441953 AND W.type_id = 2)) AND (`post_util_id` = 441953 OR `dest_util_id` = 441953) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

337. 0.0001

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

338. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 434204 AND W.type_id = 1) OR (W.util_id != 434204 AND W.type_id = 2)) AND (`post_util_id` = 434204 OR `dest_util_id` = 434204) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

339. 0.0001

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

340. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 449066 AND W.type_id = 1) OR (W.util_id != 449066 AND W.type_id = 2)) AND (`post_util_id` = 449066 OR `dest_util_id` = 449066) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

341. 0.0001

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

342. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 309984 AND W.type_id = 1) OR (W.util_id != 309984 AND W.type_id = 2)) AND (`post_util_id` = 309984 OR `dest_util_id` = 309984) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

343. 0.0001

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

344. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 264388 AND W.type_id = 1) OR (W.util_id != 264388 AND W.type_id = 2)) AND (`post_util_id` = 264388 OR `dest_util_id` = 264388) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

345. 0.0001

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

346. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 459443 AND W.type_id = 1) OR (W.util_id != 459443 AND W.type_id = 2)) AND (`post_util_id` = 459443 OR `dest_util_id` = 459443) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

347. 0.0001

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

348. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 461070 AND W.type_id = 1) OR (W.util_id != 461070 AND W.type_id = 2)) AND (`post_util_id` = 461070 OR `dest_util_id` = 461070) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

349. 0.0001

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

350. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 461994 AND W.type_id = 1) OR (W.util_id != 461994 AND W.type_id = 2)) AND (`post_util_id` = 461994 OR `dest_util_id` = 461994) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

351. 0.0001

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

352. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 463199 AND W.type_id = 1) OR (W.util_id != 463199 AND W.type_id = 2)) AND (`post_util_id` = 463199 OR `dest_util_id` = 463199) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

353. 0.0001

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

354. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 463495 AND W.type_id = 1) OR (W.util_id != 463495 AND W.type_id = 2)) AND (`post_util_id` = 463495 OR `dest_util_id` = 463495) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

355. 0.0001

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

356. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 463495 AND W.type_id = 1) OR (W.util_id != 463495 AND W.type_id = 2)) AND (`post_util_id` = 463495 OR `dest_util_id` = 463495) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

357. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 472388 AND W.type_id = 1) OR (W.util_id != 472388 AND W.type_id = 2)) AND (`post_util_id` = 472388 OR `dest_util_id` = 472388) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

358. 0.0001

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

359. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 473266 AND W.type_id = 1) OR (W.util_id != 473266 AND W.type_id = 2)) AND (`post_util_id` = 473266 OR `dest_util_id` = 473266) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

360. 0.0001

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

361. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 474208 AND W.type_id = 1) OR (W.util_id != 474208 AND W.type_id = 2)) AND (`post_util_id` = 474208 OR `dest_util_id` = 474208) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

362. 0.0001

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

363. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 418495 AND W.type_id = 1) OR (W.util_id != 418495 AND W.type_id = 2)) AND (`post_util_id` = 418495 OR `dest_util_id` = 418495) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

364. 0.0001

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

365. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 479324 AND W.type_id = 1) OR (W.util_id != 479324 AND W.type_id = 2)) AND (`post_util_id` = 479324 OR `dest_util_id` = 479324) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

366. 0.0001

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

367. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 484568 AND W.type_id = 1) OR (W.util_id != 484568 AND W.type_id = 2)) AND (`post_util_id` = 484568 OR `dest_util_id` = 484568) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

368. 0.0001

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

369. 0.0005

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 390343 AND W.type_id = 1) OR (W.util_id != 390343 AND W.type_id = 2)) AND (`post_util_id` = 390343 OR `dest_util_id` = 390343) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

370. 0.0001

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

371. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 489792 AND W.type_id = 1) OR (W.util_id != 489792 AND W.type_id = 2)) AND (`post_util_id` = 489792 OR `dest_util_id` = 489792) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

372. 0.0001

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

373. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 420741 AND W.type_id = 1) OR (W.util_id != 420741 AND W.type_id = 2)) AND (`post_util_id` = 420741 OR `dest_util_id` = 420741) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

374. 0.0001

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

375. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 144852 AND W.type_id = 1) OR (W.util_id != 144852 AND W.type_id = 2)) AND (`post_util_id` = 144852 OR `dest_util_id` = 144852) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

376. 0.0001

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

377. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 502948 AND W.type_id = 1) OR (W.util_id != 502948 AND W.type_id = 2)) AND (`post_util_id` = 502948 OR `dest_util_id` = 502948) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

378. 0.0001

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

379. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 504485 AND W.type_id = 1) OR (W.util_id != 504485 AND W.type_id = 2)) AND (`post_util_id` = 504485 OR `dest_util_id` = 504485) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

380. 0.0001

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

381. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 504529 AND W.type_id = 1) OR (W.util_id != 504529 AND W.type_id = 2)) AND (`post_util_id` = 504529 OR `dest_util_id` = 504529) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

382. 0.0001

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

383. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 288479 AND W.type_id = 1) OR (W.util_id != 288479 AND W.type_id = 2)) AND (`post_util_id` = 288479 OR `dest_util_id` = 288479) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

384. 0.0001

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

385. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 231793 AND W.type_id = 1) OR (W.util_id != 231793 AND W.type_id = 2)) AND (`post_util_id` = 231793 OR `dest_util_id` = 231793) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

386. 0.0001

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

387. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 520218 AND W.type_id = 1) OR (W.util_id != 520218 AND W.type_id = 2)) AND (`post_util_id` = 520218 OR `dest_util_id` = 520218) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

388. 0.0001

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

389. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 331837 AND W.type_id = 1) OR (W.util_id != 331837 AND W.type_id = 2)) AND (`post_util_id` = 331837 OR `dest_util_id` = 331837) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

390. 0.0001

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

391. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 472675 AND W.type_id = 1) OR (W.util_id != 472675 AND W.type_id = 2)) AND (`post_util_id` = 472675 OR `dest_util_id` = 472675) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

392. 0.0001

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

393. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 525408 AND W.type_id = 1) OR (W.util_id != 525408 AND W.type_id = 2)) AND (`post_util_id` = 525408 OR `dest_util_id` = 525408) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

394. 0.0001

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

395. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 525408 AND W.type_id = 1) OR (W.util_id != 525408 AND W.type_id = 2)) AND (`post_util_id` = 525408 OR `dest_util_id` = 525408) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

396. 0.0003

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 379720 AND W.type_id = 1) OR (W.util_id != 379720 AND W.type_id = 2)) AND (`post_util_id` = 379720 OR `dest_util_id` = 379720) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

397. 0.0001

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

398. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 320793 AND W.type_id = 1) OR (W.util_id != 320793 AND W.type_id = 2)) AND (`post_util_id` = 320793 OR `dest_util_id` = 320793) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

399. 0.0001

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

400. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 513619 AND W.type_id = 1) OR (W.util_id != 513619 AND W.type_id = 2)) AND (`post_util_id` = 513619 OR `dest_util_id` = 513619) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

401. 0.0001

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

402. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 544527 AND W.type_id = 1) OR (W.util_id != 544527 AND W.type_id = 2)) AND (`post_util_id` = 544527 OR `dest_util_id` = 544527) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

403. 0.0001

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

404. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 545384 AND W.type_id = 1) OR (W.util_id != 545384 AND W.type_id = 2)) AND (`post_util_id` = 545384 OR `dest_util_id` = 545384) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

405. 0.0001

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

406. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 546632 AND W.type_id = 1) OR (W.util_id != 546632 AND W.type_id = 2)) AND (`post_util_id` = 546632 OR `dest_util_id` = 546632) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

407. 0.0001

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

408. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 546632 AND W.type_id = 1) OR (W.util_id != 546632 AND W.type_id = 2)) AND (`post_util_id` = 546632 OR `dest_util_id` = 546632) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

409. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 347953 AND W.type_id = 1) OR (W.util_id != 347953 AND W.type_id = 2)) AND (`post_util_id` = 347953 OR `dest_util_id` = 347953) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

410. 0.0001

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

411. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 548872 AND W.type_id = 1) OR (W.util_id != 548872 AND W.type_id = 2)) AND (`post_util_id` = 548872 OR `dest_util_id` = 548872) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

412. 0.0001

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

413. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 549780 AND W.type_id = 1) OR (W.util_id != 549780 AND W.type_id = 2)) AND (`post_util_id` = 549780 OR `dest_util_id` = 549780) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

414. 0.0001

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

415. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

417. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

418. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

419. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

420. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

421. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

422. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

423. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

424. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

425. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

426. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

427. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

428. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

429. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

430. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

431. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

432. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

433. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

434. 0.0005

     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=87 AND ss.fami_id=5 ORDER BY ssrubr_order LIMIT 6,100

435. 0.0003

     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='groupe électrogène' OR ssrubr_slug like '%groupe électrogène%' OR MATCH (ssrubr_slug) AGAINST ('(+groupe +électrogène)')) AND sk.ssrubr_id='63' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

436. 0.0001

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

437. 0.0017

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

438. 0

     SELECT count(*) as nbwish FROM wish

439. 0.0787

     SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

439 requetes sql en 0.60299999999999