Service extension de cils

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='coiffure-esthetique'

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

4. 0.0002

   SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%extension%de%cils%' OR ssrubr_title like '%extension%de%cils%' OR ssrubr_slug like '%extension%de%cils%') AND cate_id='43' ORDER BY ssrubr_id LIMIT 0,1

5. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='extension cil; extension de cils'

6. 0.0305

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='43'AND MATCH (wish_title,wish_desc) AGAINST ('+extension cil; extension de cils*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10)

7. 0.0001

   SELECT * FROM texte WHERE cate_id=43

8. 0.0002

   SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='extension cil; extension de cils' OR ssrubr_slug='extension-cil;-extension-de-cils' OR (ssrubr_title like '%extension cil; extension de cils%')) AND cate_id='43' 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.0002

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

11. 0.0002

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

12. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='extension-de-cils' AND cate_id='43'

13. 0.034

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='43' AND MATCH (wish_desc) AGAINST ('(+extension +cil; +extension +de +cils*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10)

14. 0.0318

    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='3' AND cate_id='43' AND MATCH (wish_desc) AGAINST ('(+extension +cil; +extension +de +cils*)' 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 = 4950 AND W.type_id = 1) OR (W.util_id != 4950 AND W.type_id = 2)) AND (`post_util_id` = 4950 OR `dest_util_id` = 4950) 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=4950 AND note_visu IN (1,3,4)

17. 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 = 5795 AND W.type_id = 1) OR (W.util_id != 5795 AND W.type_id = 2)) AND (`post_util_id` = 5795 OR `dest_util_id` = 5795) 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=5795 AND note_visu IN (1,3,4)

19. 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 = 10634 AND W.type_id = 1) OR (W.util_id != 10634 AND W.type_id = 2)) AND (`post_util_id` = 10634 OR `dest_util_id` = 10634) 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=10634 AND note_visu IN (1,3,4)

21. 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 = 14241 AND W.type_id = 1) OR (W.util_id != 14241 AND W.type_id = 2)) AND (`post_util_id` = 14241 OR `dest_util_id` = 14241) 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=14241 AND note_visu IN (1,3,4)

23. 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 = 14758 AND W.type_id = 1) OR (W.util_id != 14758 AND W.type_id = 2)) AND (`post_util_id` = 14758 OR `dest_util_id` = 14758) 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=14758 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 = 16118 AND W.type_id = 1) OR (W.util_id != 16118 AND W.type_id = 2)) AND (`post_util_id` = 16118 OR `dest_util_id` = 16118) 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=16118 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 = 21965 AND W.type_id = 1) OR (W.util_id != 21965 AND W.type_id = 2)) AND (`post_util_id` = 21965 OR `dest_util_id` = 21965) 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=21965 AND note_visu IN (1,3,4)

29. 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 = 31194 AND W.type_id = 1) OR (W.util_id != 31194 AND W.type_id = 2)) AND (`post_util_id` = 31194 OR `dest_util_id` = 31194) 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=31194 AND note_visu IN (1,3,4)

31. 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 = 38014 AND W.type_id = 1) OR (W.util_id != 38014 AND W.type_id = 2)) AND (`post_util_id` = 38014 OR `dest_util_id` = 38014) 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=38014 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 = 44050 AND W.type_id = 1) OR (W.util_id != 44050 AND W.type_id = 2)) AND (`post_util_id` = 44050 OR `dest_util_id` = 44050) 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=44050 AND note_visu IN (1,3,4)

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

38. 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 = 48991 AND W.type_id = 1) OR (W.util_id != 48991 AND W.type_id = 2)) AND (`post_util_id` = 48991 OR `dest_util_id` = 48991) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

39. 0.0001

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

40. 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 = 49845 AND W.type_id = 1) OR (W.util_id != 49845 AND W.type_id = 2)) AND (`post_util_id` = 49845 OR `dest_util_id` = 49845) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

41. 0.0001

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

42. 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 = 58457 AND W.type_id = 1) OR (W.util_id != 58457 AND W.type_id = 2)) AND (`post_util_id` = 58457 OR `dest_util_id` = 58457) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

43. 0.0001

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

44. 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 = 58505 AND W.type_id = 1) OR (W.util_id != 58505 AND W.type_id = 2)) AND (`post_util_id` = 58505 OR `dest_util_id` = 58505) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

45. 0.0001

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

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

47. 0.0001

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

48. 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 = 59854 AND W.type_id = 1) OR (W.util_id != 59854 AND W.type_id = 2)) AND (`post_util_id` = 59854 OR `dest_util_id` = 59854) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

49. 0.0001

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

50. 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 = 61629 AND W.type_id = 1) OR (W.util_id != 61629 AND W.type_id = 2)) AND (`post_util_id` = 61629 OR `dest_util_id` = 61629) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

51. 0.0001

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

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

53. 0.0001

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

54. 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 = 63299 AND W.type_id = 1) OR (W.util_id != 63299 AND W.type_id = 2)) AND (`post_util_id` = 63299 OR `dest_util_id` = 63299) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

55. 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 = 70112 AND W.type_id = 1) OR (W.util_id != 70112 AND W.type_id = 2)) AND (`post_util_id` = 70112 OR `dest_util_id` = 70112) 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=70112 AND note_visu IN (1,3,4)

57. 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 = 71840 AND W.type_id = 1) OR (W.util_id != 71840 AND W.type_id = 2)) AND (`post_util_id` = 71840 OR `dest_util_id` = 71840) 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=71840 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 = 73424 AND W.type_id = 1) OR (W.util_id != 73424 AND W.type_id = 2)) AND (`post_util_id` = 73424 OR `dest_util_id` = 73424) 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=73424 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 = 80269 AND W.type_id = 1) OR (W.util_id != 80269 AND W.type_id = 2)) AND (`post_util_id` = 80269 OR `dest_util_id` = 80269) 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=80269 AND note_visu IN (1,3,4)

63. 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 = 86276 AND W.type_id = 1) OR (W.util_id != 86276 AND W.type_id = 2)) AND (`post_util_id` = 86276 OR `dest_util_id` = 86276) 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=86276 AND note_visu IN (1,3,4)

65. 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 = 89022 AND W.type_id = 1) OR (W.util_id != 89022 AND W.type_id = 2)) AND (`post_util_id` = 89022 OR `dest_util_id` = 89022) 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=89022 AND note_visu IN (1,3,4)

67. 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 = 90128 AND W.type_id = 1) OR (W.util_id != 90128 AND W.type_id = 2)) AND (`post_util_id` = 90128 OR `dest_util_id` = 90128) 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=90128 AND note_visu IN (1,3,4)

69. 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 = 95821 AND W.type_id = 1) OR (W.util_id != 95821 AND W.type_id = 2)) AND (`post_util_id` = 95821 OR `dest_util_id` = 95821) 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=95821 AND note_visu IN (1,3,4)

71. 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 = 96450 AND W.type_id = 1) OR (W.util_id != 96450 AND W.type_id = 2)) AND (`post_util_id` = 96450 OR `dest_util_id` = 96450) 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=96450 AND note_visu IN (1,3,4)

73. 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 = 103015 AND W.type_id = 1) OR (W.util_id != 103015 AND W.type_id = 2)) AND (`post_util_id` = 103015 OR `dest_util_id` = 103015) 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=103015 AND note_visu IN (1,3,4)

75. 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 = 105443 AND W.type_id = 1) OR (W.util_id != 105443 AND W.type_id = 2)) AND (`post_util_id` = 105443 OR `dest_util_id` = 105443) 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=105443 AND note_visu IN (1,3,4)

77. 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 = 45514 AND W.type_id = 1) OR (W.util_id != 45514 AND W.type_id = 2)) AND (`post_util_id` = 45514 OR `dest_util_id` = 45514) 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=45514 AND note_visu IN (1,3,4)

79. 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 = 106826 AND W.type_id = 1) OR (W.util_id != 106826 AND W.type_id = 2)) AND (`post_util_id` = 106826 OR `dest_util_id` = 106826) 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=106826 AND note_visu IN (1,3,4)

81. 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 = 114606 AND W.type_id = 1) OR (W.util_id != 114606 AND W.type_id = 2)) AND (`post_util_id` = 114606 OR `dest_util_id` = 114606) 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=114606 AND note_visu IN (1,3,4)

83. 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 = 115902 AND W.type_id = 1) OR (W.util_id != 115902 AND W.type_id = 2)) AND (`post_util_id` = 115902 OR `dest_util_id` = 115902) 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=115902 AND note_visu IN (1,3,4)

85. 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 = 116532 AND W.type_id = 1) OR (W.util_id != 116532 AND W.type_id = 2)) AND (`post_util_id` = 116532 OR `dest_util_id` = 116532) 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=116532 AND note_visu IN (1,3,4)

87. 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 = 116705 AND W.type_id = 1) OR (W.util_id != 116705 AND W.type_id = 2)) AND (`post_util_id` = 116705 OR `dest_util_id` = 116705) 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=116705 AND note_visu IN (1,3,4)

89. 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 = 115362 AND W.type_id = 1) OR (W.util_id != 115362 AND W.type_id = 2)) AND (`post_util_id` = 115362 OR `dest_util_id` = 115362) 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=115362 AND note_visu IN (1,3,4)

91. 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 = 117479 AND W.type_id = 1) OR (W.util_id != 117479 AND W.type_id = 2)) AND (`post_util_id` = 117479 OR `dest_util_id` = 117479) 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=117479 AND note_visu IN (1,3,4)

93. 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 = 118940 AND W.type_id = 1) OR (W.util_id != 118940 AND W.type_id = 2)) AND (`post_util_id` = 118940 OR `dest_util_id` = 118940) 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=118940 AND note_visu IN (1,3,4)

95. 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 = 119132 AND W.type_id = 1) OR (W.util_id != 119132 AND W.type_id = 2)) AND (`post_util_id` = 119132 OR `dest_util_id` = 119132) 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=119132 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 = 121514 AND W.type_id = 1) OR (W.util_id != 121514 AND W.type_id = 2)) AND (`post_util_id` = 121514 OR `dest_util_id` = 121514) 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=121514 AND note_visu IN (1,3,4)

99. 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 = 122839 AND W.type_id = 1) OR (W.util_id != 122839 AND W.type_id = 2)) AND (`post_util_id` = 122839 OR `dest_util_id` = 122839) 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=122839 AND note_visu IN (1,3,4)

101. 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 = 118940 AND W.type_id = 1) OR (W.util_id != 118940 AND W.type_id = 2)) AND (`post_util_id` = 118940 OR `dest_util_id` = 118940) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

103. 0.0001

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

104. 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 = 117982 AND W.type_id = 1) OR (W.util_id != 117982 AND W.type_id = 2)) AND (`post_util_id` = 117982 OR `dest_util_id` = 117982) 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=117982 AND note_visu IN (1,3,4)

106. 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 = 132804 AND W.type_id = 1) OR (W.util_id != 132804 AND W.type_id = 2)) AND (`post_util_id` = 132804 OR `dest_util_id` = 132804) 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=132804 AND note_visu IN (1,3,4)

108. 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 = 134052 AND W.type_id = 1) OR (W.util_id != 134052 AND W.type_id = 2)) AND (`post_util_id` = 134052 OR `dest_util_id` = 134052) 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=134052 AND note_visu IN (1,3,4)

110. 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 = 146930 AND W.type_id = 1) OR (W.util_id != 146930 AND W.type_id = 2)) AND (`post_util_id` = 146930 OR `dest_util_id` = 146930) 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=146930 AND note_visu IN (1,3,4)

112. 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 = 151157 AND W.type_id = 1) OR (W.util_id != 151157 AND W.type_id = 2)) AND (`post_util_id` = 151157 OR `dest_util_id` = 151157) 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=151157 AND note_visu IN (1,3,4)

114. 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 = 137530 AND W.type_id = 1) OR (W.util_id != 137530 AND W.type_id = 2)) AND (`post_util_id` = 137530 OR `dest_util_id` = 137530) 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=137530 AND note_visu IN (1,3,4)

116. 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 = 126477 AND W.type_id = 1) OR (W.util_id != 126477 AND W.type_id = 2)) AND (`post_util_id` = 126477 OR `dest_util_id` = 126477) 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=126477 AND note_visu IN (1,3,4)

118. 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 = 50236 AND W.type_id = 1) OR (W.util_id != 50236 AND W.type_id = 2)) AND (`post_util_id` = 50236 OR `dest_util_id` = 50236) 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=50236 AND note_visu IN (1,3,4)

120. 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 = 160462 AND W.type_id = 1) OR (W.util_id != 160462 AND W.type_id = 2)) AND (`post_util_id` = 160462 OR `dest_util_id` = 160462) 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=160462 AND note_visu IN (1,3,4)

122. 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 = 163378 AND W.type_id = 1) OR (W.util_id != 163378 AND W.type_id = 2)) AND (`post_util_id` = 163378 OR `dest_util_id` = 163378) 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=163378 AND note_visu IN (1,3,4)

124. 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 = 24951 AND W.type_id = 1) OR (W.util_id != 24951 AND W.type_id = 2)) AND (`post_util_id` = 24951 OR `dest_util_id` = 24951) 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=24951 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 = 169058 AND W.type_id = 1) OR (W.util_id != 169058 AND W.type_id = 2)) AND (`post_util_id` = 169058 OR `dest_util_id` = 169058) 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=169058 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 = 169283 AND W.type_id = 1) OR (W.util_id != 169283 AND W.type_id = 2)) AND (`post_util_id` = 169283 OR `dest_util_id` = 169283) 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=169283 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 = 170191 AND W.type_id = 1) OR (W.util_id != 170191 AND W.type_id = 2)) AND (`post_util_id` = 170191 OR `dest_util_id` = 170191) 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=170191 AND note_visu IN (1,3,4)

132. 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 = 165262 AND W.type_id = 1) OR (W.util_id != 165262 AND W.type_id = 2)) AND (`post_util_id` = 165262 OR `dest_util_id` = 165262) 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=165262 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 = 179550 AND W.type_id = 1) OR (W.util_id != 179550 AND W.type_id = 2)) AND (`post_util_id` = 179550 OR `dest_util_id` = 179550) 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=179550 AND note_visu IN (1,3,4)

136. 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 = 163161 AND W.type_id = 1) OR (W.util_id != 163161 AND W.type_id = 2)) AND (`post_util_id` = 163161 OR `dest_util_id` = 163161) 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=163161 AND note_visu IN (1,3,4)

138. 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 = 190695 AND W.type_id = 1) OR (W.util_id != 190695 AND W.type_id = 2)) AND (`post_util_id` = 190695 OR `dest_util_id` = 190695) 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=190695 AND note_visu IN (1,3,4)

140. 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 = 191497 AND W.type_id = 1) OR (W.util_id != 191497 AND W.type_id = 2)) AND (`post_util_id` = 191497 OR `dest_util_id` = 191497) 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=191497 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 = 192563 AND W.type_id = 1) OR (W.util_id != 192563 AND W.type_id = 2)) AND (`post_util_id` = 192563 OR `dest_util_id` = 192563) 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=192563 AND note_visu IN (1,3,4)

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

147. 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 = 194862 AND W.type_id = 1) OR (W.util_id != 194862 AND W.type_id = 2)) AND (`post_util_id` = 194862 OR `dest_util_id` = 194862) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

148. 0.0001

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

149. 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 = 197009 AND W.type_id = 1) OR (W.util_id != 197009 AND W.type_id = 2)) AND (`post_util_id` = 197009 OR `dest_util_id` = 197009) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

150. 0.0001

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

151. 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 = 90287 AND W.type_id = 1) OR (W.util_id != 90287 AND W.type_id = 2)) AND (`post_util_id` = 90287 OR `dest_util_id` = 90287) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

152. 0.0001

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

153. 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 = 197408 AND W.type_id = 1) OR (W.util_id != 197408 AND W.type_id = 2)) AND (`post_util_id` = 197408 OR `dest_util_id` = 197408) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

154. 0.0001

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

155. 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 = 194745 AND W.type_id = 1) OR (W.util_id != 194745 AND W.type_id = 2)) AND (`post_util_id` = 194745 OR `dest_util_id` = 194745) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

156. 0.0001

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

157. 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 = 200781 AND W.type_id = 1) OR (W.util_id != 200781 AND W.type_id = 2)) AND (`post_util_id` = 200781 OR `dest_util_id` = 200781) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

158. 0.0001

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

159. 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 = 201832 AND W.type_id = 1) OR (W.util_id != 201832 AND W.type_id = 2)) AND (`post_util_id` = 201832 OR `dest_util_id` = 201832) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

160. 0.0001

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

161. 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 = 203146 AND W.type_id = 1) OR (W.util_id != 203146 AND W.type_id = 2)) AND (`post_util_id` = 203146 OR `dest_util_id` = 203146) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

162. 0.0001

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

163. 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 = 203411 AND W.type_id = 1) OR (W.util_id != 203411 AND W.type_id = 2)) AND (`post_util_id` = 203411 OR `dest_util_id` = 203411) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

164. 0.0001

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

165. 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 = 204900 AND W.type_id = 1) OR (W.util_id != 204900 AND W.type_id = 2)) AND (`post_util_id` = 204900 OR `dest_util_id` = 204900) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

166. 0.0001

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

167. 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 = 205945 AND W.type_id = 1) OR (W.util_id != 205945 AND W.type_id = 2)) AND (`post_util_id` = 205945 OR `dest_util_id` = 205945) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

168. 0.0001

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

169. 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 = 206559 AND W.type_id = 1) OR (W.util_id != 206559 AND W.type_id = 2)) AND (`post_util_id` = 206559 OR `dest_util_id` = 206559) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

170. 0.0001

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

171. 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 = 206755 AND W.type_id = 1) OR (W.util_id != 206755 AND W.type_id = 2)) AND (`post_util_id` = 206755 OR `dest_util_id` = 206755) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

172. 0.0001

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

173. 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 = 64927 AND W.type_id = 1) OR (W.util_id != 64927 AND W.type_id = 2)) AND (`post_util_id` = 64927 OR `dest_util_id` = 64927) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

174. 0.0001

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

175. 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 = 200954 AND W.type_id = 1) OR (W.util_id != 200954 AND W.type_id = 2)) AND (`post_util_id` = 200954 OR `dest_util_id` = 200954) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

176. 0.0001

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

177. 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 = 210103 AND W.type_id = 1) OR (W.util_id != 210103 AND W.type_id = 2)) AND (`post_util_id` = 210103 OR `dest_util_id` = 210103) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

178. 0.0001

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

179. 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 = 211565 AND W.type_id = 1) OR (W.util_id != 211565 AND W.type_id = 2)) AND (`post_util_id` = 211565 OR `dest_util_id` = 211565) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

180. 0.0001

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

181. 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 = 211565 AND W.type_id = 1) OR (W.util_id != 211565 AND W.type_id = 2)) AND (`post_util_id` = 211565 OR `dest_util_id` = 211565) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

182. 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 = 214719 AND W.type_id = 1) OR (W.util_id != 214719 AND W.type_id = 2)) AND (`post_util_id` = 214719 OR `dest_util_id` = 214719) 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=214719 AND note_visu IN (1,3,4)

184. 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 = 216159 AND W.type_id = 1) OR (W.util_id != 216159 AND W.type_id = 2)) AND (`post_util_id` = 216159 OR `dest_util_id` = 216159) 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=216159 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 = 220741 AND W.type_id = 1) OR (W.util_id != 220741 AND W.type_id = 2)) AND (`post_util_id` = 220741 OR `dest_util_id` = 220741) 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=220741 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 = 221065 AND W.type_id = 1) OR (W.util_id != 221065 AND W.type_id = 2)) AND (`post_util_id` = 221065 OR `dest_util_id` = 221065) 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=221065 AND note_visu IN (1,3,4)

190. 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 = 221713 AND W.type_id = 1) OR (W.util_id != 221713 AND W.type_id = 2)) AND (`post_util_id` = 221713 OR `dest_util_id` = 221713) 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=221713 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 = 123845 AND W.type_id = 1) OR (W.util_id != 123845 AND W.type_id = 2)) AND (`post_util_id` = 123845 OR `dest_util_id` = 123845) 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=123845 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 = 226225 AND W.type_id = 1) OR (W.util_id != 226225 AND W.type_id = 2)) AND (`post_util_id` = 226225 OR `dest_util_id` = 226225) 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=226225 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 = 231063 AND W.type_id = 1) OR (W.util_id != 231063 AND W.type_id = 2)) AND (`post_util_id` = 231063 OR `dest_util_id` = 231063) 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=231063 AND note_visu IN (1,3,4)

198. 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 = 231851 AND W.type_id = 1) OR (W.util_id != 231851 AND W.type_id = 2)) AND (`post_util_id` = 231851 OR `dest_util_id` = 231851) 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=231851 AND note_visu IN (1,3,4)

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

201. 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 = 231851 AND W.type_id = 1) OR (W.util_id != 231851 AND W.type_id = 2)) AND (`post_util_id` = 231851 OR `dest_util_id` = 231851) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

202. 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 = 233161 AND W.type_id = 1) OR (W.util_id != 233161 AND W.type_id = 2)) AND (`post_util_id` = 233161 OR `dest_util_id` = 233161) 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=233161 AND note_visu IN (1,3,4)

204. 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 = 235218 AND W.type_id = 1) OR (W.util_id != 235218 AND W.type_id = 2)) AND (`post_util_id` = 235218 OR `dest_util_id` = 235218) 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=235218 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 = 235867 AND W.type_id = 1) OR (W.util_id != 235867 AND W.type_id = 2)) AND (`post_util_id` = 235867 OR `dest_util_id` = 235867) 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=235867 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 = 236568 AND W.type_id = 1) OR (W.util_id != 236568 AND W.type_id = 2)) AND (`post_util_id` = 236568 OR `dest_util_id` = 236568) 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=236568 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 = 237944 AND W.type_id = 1) OR (W.util_id != 237944 AND W.type_id = 2)) AND (`post_util_id` = 237944 OR `dest_util_id` = 237944) 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=237944 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 = 238179 AND W.type_id = 1) OR (W.util_id != 238179 AND W.type_id = 2)) AND (`post_util_id` = 238179 OR `dest_util_id` = 238179) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

213. 0.0001

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

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

215. 0.0001

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

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

217. 0.0001

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

218. 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 = 247058 AND W.type_id = 1) OR (W.util_id != 247058 AND W.type_id = 2)) AND (`post_util_id` = 247058 OR `dest_util_id` = 247058) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

219. 0.0001

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

220. 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 = 252107 AND W.type_id = 1) OR (W.util_id != 252107 AND W.type_id = 2)) AND (`post_util_id` = 252107 OR `dest_util_id` = 252107) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

221. 0.0001

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

222. 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 = 256197 AND W.type_id = 1) OR (W.util_id != 256197 AND W.type_id = 2)) AND (`post_util_id` = 256197 OR `dest_util_id` = 256197) 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=256197 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 = 261135 AND W.type_id = 1) OR (W.util_id != 261135 AND W.type_id = 2)) AND (`post_util_id` = 261135 OR `dest_util_id` = 261135) 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=261135 AND note_visu IN (1,3,4)

226. 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 = 265945 AND W.type_id = 1) OR (W.util_id != 265945 AND W.type_id = 2)) AND (`post_util_id` = 265945 OR `dest_util_id` = 265945) 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=265945 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 = 268775 AND W.type_id = 1) OR (W.util_id != 268775 AND W.type_id = 2)) AND (`post_util_id` = 268775 OR `dest_util_id` = 268775) 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=268775 AND note_visu IN (1,3,4)

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

231. 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 = 272782 AND W.type_id = 1) OR (W.util_id != 272782 AND W.type_id = 2)) AND (`post_util_id` = 272782 OR `dest_util_id` = 272782) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

232. 0.0001

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

233. 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 = 277683 AND W.type_id = 1) OR (W.util_id != 277683 AND W.type_id = 2)) AND (`post_util_id` = 277683 OR `dest_util_id` = 277683) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

234. 0.0001

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

235. 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 = 282629 AND W.type_id = 1) OR (W.util_id != 282629 AND W.type_id = 2)) AND (`post_util_id` = 282629 OR `dest_util_id` = 282629) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

236. 0.0001

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

237. 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 = 172530 AND W.type_id = 1) OR (W.util_id != 172530 AND W.type_id = 2)) AND (`post_util_id` = 172530 OR `dest_util_id` = 172530) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

238. 0.0001

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

239. 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 = 167904 AND W.type_id = 1) OR (W.util_id != 167904 AND W.type_id = 2)) AND (`post_util_id` = 167904 OR `dest_util_id` = 167904) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

240. 0.0001

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

241. 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 = 291637 AND W.type_id = 1) OR (W.util_id != 291637 AND W.type_id = 2)) AND (`post_util_id` = 291637 OR `dest_util_id` = 291637) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

242. 0.0001

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

243. 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 = 294541 AND W.type_id = 1) OR (W.util_id != 294541 AND W.type_id = 2)) AND (`post_util_id` = 294541 OR `dest_util_id` = 294541) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

244. 0.0001

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

245. 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 = 296131 AND W.type_id = 1) OR (W.util_id != 296131 AND W.type_id = 2)) AND (`post_util_id` = 296131 OR `dest_util_id` = 296131) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

246. 0.0001

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

247. 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 = 163761 AND W.type_id = 1) OR (W.util_id != 163761 AND W.type_id = 2)) AND (`post_util_id` = 163761 OR `dest_util_id` = 163761) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

248. 0.0001

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

249. 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 = 287064 AND W.type_id = 1) OR (W.util_id != 287064 AND W.type_id = 2)) AND (`post_util_id` = 287064 OR `dest_util_id` = 287064) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

250. 0.0001

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

251. 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 = 301186 AND W.type_id = 1) OR (W.util_id != 301186 AND W.type_id = 2)) AND (`post_util_id` = 301186 OR `dest_util_id` = 301186) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

252. 0.0001

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

253. 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 = 304237 AND W.type_id = 1) OR (W.util_id != 304237 AND W.type_id = 2)) AND (`post_util_id` = 304237 OR `dest_util_id` = 304237) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

254. 0.0001

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

255. 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 = 304238 AND W.type_id = 1) OR (W.util_id != 304238 AND W.type_id = 2)) AND (`post_util_id` = 304238 OR `dest_util_id` = 304238) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

256. 0.0001

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

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

258. 0.0001

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

259. 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 = 306424 AND W.type_id = 1) OR (W.util_id != 306424 AND W.type_id = 2)) AND (`post_util_id` = 306424 OR `dest_util_id` = 306424) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

260. 0.0001

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

261. 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 = 306424 AND W.type_id = 1) OR (W.util_id != 306424 AND W.type_id = 2)) AND (`post_util_id` = 306424 OR `dest_util_id` = 306424) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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 = 315898 AND W.type_id = 1) OR (W.util_id != 315898 AND W.type_id = 2)) AND (`post_util_id` = 315898 OR `dest_util_id` = 315898) 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=315898 AND note_visu IN (1,3,4)

264. 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 = 318426 AND W.type_id = 1) OR (W.util_id != 318426 AND W.type_id = 2)) AND (`post_util_id` = 318426 OR `dest_util_id` = 318426) 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=318426 AND note_visu IN (1,3,4)

266. 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 = 319478 AND W.type_id = 1) OR (W.util_id != 319478 AND W.type_id = 2)) AND (`post_util_id` = 319478 OR `dest_util_id` = 319478) 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=319478 AND note_visu IN (1,3,4)

268. 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 = 320759 AND W.type_id = 1) OR (W.util_id != 320759 AND W.type_id = 2)) AND (`post_util_id` = 320759 OR `dest_util_id` = 320759) 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=320759 AND note_visu IN (1,3,4)

270. 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 = 322367 AND W.type_id = 1) OR (W.util_id != 322367 AND W.type_id = 2)) AND (`post_util_id` = 322367 OR `dest_util_id` = 322367) 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=322367 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 = 322367 AND W.type_id = 1) OR (W.util_id != 322367 AND W.type_id = 2)) AND (`post_util_id` = 322367 OR `dest_util_id` = 322367) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

273. 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 = 322367 AND W.type_id = 1) OR (W.util_id != 322367 AND W.type_id = 2)) AND (`post_util_id` = 322367 OR `dest_util_id` = 322367) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

274. 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 = 325064 AND W.type_id = 1) OR (W.util_id != 325064 AND W.type_id = 2)) AND (`post_util_id` = 325064 OR `dest_util_id` = 325064) 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=325064 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 = 325174 AND W.type_id = 1) OR (W.util_id != 325174 AND W.type_id = 2)) AND (`post_util_id` = 325174 OR `dest_util_id` = 325174) 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=325174 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 = 325174 AND W.type_id = 1) OR (W.util_id != 325174 AND W.type_id = 2)) AND (`post_util_id` = 325174 OR `dest_util_id` = 325174) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

279. 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 = 328210 AND W.type_id = 1) OR (W.util_id != 328210 AND W.type_id = 2)) AND (`post_util_id` = 328210 OR `dest_util_id` = 328210) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

280. 0.0001

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

281. 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 = 330200 AND W.type_id = 1) OR (W.util_id != 330200 AND W.type_id = 2)) AND (`post_util_id` = 330200 OR `dest_util_id` = 330200) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

282. 0.0001

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

283. 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 = 342289 AND W.type_id = 1) OR (W.util_id != 342289 AND W.type_id = 2)) AND (`post_util_id` = 342289 OR `dest_util_id` = 342289) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

284. 0.0001

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

285. 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 = 349747 AND W.type_id = 1) OR (W.util_id != 349747 AND W.type_id = 2)) AND (`post_util_id` = 349747 OR `dest_util_id` = 349747) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

286. 0.0001

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

287. 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 = 216524 AND W.type_id = 1) OR (W.util_id != 216524 AND W.type_id = 2)) AND (`post_util_id` = 216524 OR `dest_util_id` = 216524) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

288. 0.0001

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

289. 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 = 354996 AND W.type_id = 1) OR (W.util_id != 354996 AND W.type_id = 2)) AND (`post_util_id` = 354996 OR `dest_util_id` = 354996) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

290. 0.0001

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

291. 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 = 123283 AND W.type_id = 1) OR (W.util_id != 123283 AND W.type_id = 2)) AND (`post_util_id` = 123283 OR `dest_util_id` = 123283) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

292. 0.0001

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

293. 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 = 361366 AND W.type_id = 1) OR (W.util_id != 361366 AND W.type_id = 2)) AND (`post_util_id` = 361366 OR `dest_util_id` = 361366) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

294. 0.0001

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

295. 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 = 365535 AND W.type_id = 1) OR (W.util_id != 365535 AND W.type_id = 2)) AND (`post_util_id` = 365535 OR `dest_util_id` = 365535) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

296. 0.0001

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

297. 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 = 365535 AND W.type_id = 1) OR (W.util_id != 365535 AND W.type_id = 2)) AND (`post_util_id` = 365535 OR `dest_util_id` = 365535) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

298. 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 = 365535 AND W.type_id = 1) OR (W.util_id != 365535 AND W.type_id = 2)) AND (`post_util_id` = 365535 OR `dest_util_id` = 365535) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

299. 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 = 366045 AND W.type_id = 1) OR (W.util_id != 366045 AND W.type_id = 2)) AND (`post_util_id` = 366045 OR `dest_util_id` = 366045) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

300. 0.0001

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

301. 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 = 231063 AND W.type_id = 1) OR (W.util_id != 231063 AND W.type_id = 2)) AND (`post_util_id` = 231063 OR `dest_util_id` = 231063) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

302. 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 = 268385 AND W.type_id = 1) OR (W.util_id != 268385 AND W.type_id = 2)) AND (`post_util_id` = 268385 OR `dest_util_id` = 268385) 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=268385 AND note_visu IN (1,3,4)

304. 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 = 379025 AND W.type_id = 1) OR (W.util_id != 379025 AND W.type_id = 2)) AND (`post_util_id` = 379025 OR `dest_util_id` = 379025) 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=379025 AND note_visu IN (1,3,4)

306. 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 = 385585 AND W.type_id = 1) OR (W.util_id != 385585 AND W.type_id = 2)) AND (`post_util_id` = 385585 OR `dest_util_id` = 385585) 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=385585 AND note_visu IN (1,3,4)

308. 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 = 387157 AND W.type_id = 1) OR (W.util_id != 387157 AND W.type_id = 2)) AND (`post_util_id` = 387157 OR `dest_util_id` = 387157) 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=387157 AND note_visu IN (1,3,4)

310. 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 = 386988 AND W.type_id = 1) OR (W.util_id != 386988 AND W.type_id = 2)) AND (`post_util_id` = 386988 OR `dest_util_id` = 386988) 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=386988 AND note_visu IN (1,3,4)

312. 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 = 387626 AND W.type_id = 1) OR (W.util_id != 387626 AND W.type_id = 2)) AND (`post_util_id` = 387626 OR `dest_util_id` = 387626) 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=387626 AND note_visu IN (1,3,4)

314. 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 = 388764 AND W.type_id = 1) OR (W.util_id != 388764 AND W.type_id = 2)) AND (`post_util_id` = 388764 OR `dest_util_id` = 388764) 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=388764 AND note_visu IN (1,3,4)

316. 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 = 388835 AND W.type_id = 1) OR (W.util_id != 388835 AND W.type_id = 2)) AND (`post_util_id` = 388835 OR `dest_util_id` = 388835) 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=388835 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 = 392376 AND W.type_id = 1) OR (W.util_id != 392376 AND W.type_id = 2)) AND (`post_util_id` = 392376 OR `dest_util_id` = 392376) 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=392376 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 = 393671 AND W.type_id = 1) OR (W.util_id != 393671 AND W.type_id = 2)) AND (`post_util_id` = 393671 OR `dest_util_id` = 393671) 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=393671 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 = 393880 AND W.type_id = 1) OR (W.util_id != 393880 AND W.type_id = 2)) AND (`post_util_id` = 393880 OR `dest_util_id` = 393880) 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=393880 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 = 395679 AND W.type_id = 1) OR (W.util_id != 395679 AND W.type_id = 2)) AND (`post_util_id` = 395679 OR `dest_util_id` = 395679) 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=395679 AND note_visu IN (1,3,4)

326. 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 = 396163 AND W.type_id = 1) OR (W.util_id != 396163 AND W.type_id = 2)) AND (`post_util_id` = 396163 OR `dest_util_id` = 396163) 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=396163 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 = 398284 AND W.type_id = 1) OR (W.util_id != 398284 AND W.type_id = 2)) AND (`post_util_id` = 398284 OR `dest_util_id` = 398284) 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=398284 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 = 143562 AND W.type_id = 1) OR (W.util_id != 143562 AND W.type_id = 2)) AND (`post_util_id` = 143562 OR `dest_util_id` = 143562) 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=143562 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 = 403256 AND W.type_id = 1) OR (W.util_id != 403256 AND W.type_id = 2)) AND (`post_util_id` = 403256 OR `dest_util_id` = 403256) 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=403256 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 = 404447 AND W.type_id = 1) OR (W.util_id != 404447 AND W.type_id = 2)) AND (`post_util_id` = 404447 OR `dest_util_id` = 404447) 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=404447 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 = 408868 AND W.type_id = 1) OR (W.util_id != 408868 AND W.type_id = 2)) AND (`post_util_id` = 408868 OR `dest_util_id` = 408868) 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=408868 AND note_visu IN (1,3,4)

338. 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 = 383646 AND W.type_id = 1) OR (W.util_id != 383646 AND W.type_id = 2)) AND (`post_util_id` = 383646 OR `dest_util_id` = 383646) 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=383646 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 = 306574 AND W.type_id = 1) OR (W.util_id != 306574 AND W.type_id = 2)) AND (`post_util_id` = 306574 OR `dest_util_id` = 306574) 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=306574 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 = 440137 AND W.type_id = 1) OR (W.util_id != 440137 AND W.type_id = 2)) AND (`post_util_id` = 440137 OR `dest_util_id` = 440137) 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=440137 AND note_visu IN (1,3,4)

344. 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 = 445582 AND W.type_id = 1) OR (W.util_id != 445582 AND W.type_id = 2)) AND (`post_util_id` = 445582 OR `dest_util_id` = 445582) 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=445582 AND note_visu IN (1,3,4)

346. 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 = 447838 AND W.type_id = 1) OR (W.util_id != 447838 AND W.type_id = 2)) AND (`post_util_id` = 447838 OR `dest_util_id` = 447838) 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=447838 AND note_visu IN (1,3,4)

348. 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 = 454298 AND W.type_id = 1) OR (W.util_id != 454298 AND W.type_id = 2)) AND (`post_util_id` = 454298 OR `dest_util_id` = 454298) 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=454298 AND note_visu IN (1,3,4)

350. 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 = 452491 AND W.type_id = 1) OR (W.util_id != 452491 AND W.type_id = 2)) AND (`post_util_id` = 452491 OR `dest_util_id` = 452491) 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=452491 AND note_visu IN (1,3,4)

352. 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 = 460374 AND W.type_id = 1) OR (W.util_id != 460374 AND W.type_id = 2)) AND (`post_util_id` = 460374 OR `dest_util_id` = 460374) 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=460374 AND note_visu IN (1,3,4)

354. 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 = 463489 AND W.type_id = 1) OR (W.util_id != 463489 AND W.type_id = 2)) AND (`post_util_id` = 463489 OR `dest_util_id` = 463489) 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=463489 AND note_visu IN (1,3,4)

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

357. 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 = 469036 AND W.type_id = 1) OR (W.util_id != 469036 AND W.type_id = 2)) AND (`post_util_id` = 469036 OR `dest_util_id` = 469036) 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=469036 AND note_visu IN (1,3,4)

359. 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 = 315167 AND W.type_id = 1) OR (W.util_id != 315167 AND W.type_id = 2)) AND (`post_util_id` = 315167 OR `dest_util_id` = 315167) 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=315167 AND note_visu IN (1,3,4)

361. 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 = 476412 AND W.type_id = 1) OR (W.util_id != 476412 AND W.type_id = 2)) AND (`post_util_id` = 476412 OR `dest_util_id` = 476412) 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=476412 AND note_visu IN (1,3,4)

363. 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 = 476651 AND W.type_id = 1) OR (W.util_id != 476651 AND W.type_id = 2)) AND (`post_util_id` = 476651 OR `dest_util_id` = 476651) 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=476651 AND note_visu IN (1,3,4)

365. 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 = 477842 AND W.type_id = 1) OR (W.util_id != 477842 AND W.type_id = 2)) AND (`post_util_id` = 477842 OR `dest_util_id` = 477842) 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=477842 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 = 472606 AND W.type_id = 1) OR (W.util_id != 472606 AND W.type_id = 2)) AND (`post_util_id` = 472606 OR `dest_util_id` = 472606) 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=472606 AND note_visu IN (1,3,4)

369. 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 = 479402 AND W.type_id = 1) OR (W.util_id != 479402 AND W.type_id = 2)) AND (`post_util_id` = 479402 OR `dest_util_id` = 479402) 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=479402 AND note_visu IN (1,3,4)

371. 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 = 481054 AND W.type_id = 1) OR (W.util_id != 481054 AND W.type_id = 2)) AND (`post_util_id` = 481054 OR `dest_util_id` = 481054) 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=481054 AND note_visu IN (1,3,4)

373. 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 = 484183 AND W.type_id = 1) OR (W.util_id != 484183 AND W.type_id = 2)) AND (`post_util_id` = 484183 OR `dest_util_id` = 484183) 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=484183 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 = 484928 AND W.type_id = 1) OR (W.util_id != 484928 AND W.type_id = 2)) AND (`post_util_id` = 484928 OR `dest_util_id` = 484928) 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=484928 AND note_visu IN (1,3,4)

377. 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 = 485377 AND W.type_id = 1) OR (W.util_id != 485377 AND W.type_id = 2)) AND (`post_util_id` = 485377 OR `dest_util_id` = 485377) 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=485377 AND note_visu IN (1,3,4)

379. 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 = 496217 AND W.type_id = 1) OR (W.util_id != 496217 AND W.type_id = 2)) AND (`post_util_id` = 496217 OR `dest_util_id` = 496217) 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=496217 AND note_visu IN (1,3,4)

381. 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 = 479609 AND W.type_id = 1) OR (W.util_id != 479609 AND W.type_id = 2)) AND (`post_util_id` = 479609 OR `dest_util_id` = 479609) 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=479609 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 = 502194 AND W.type_id = 1) OR (W.util_id != 502194 AND W.type_id = 2)) AND (`post_util_id` = 502194 OR `dest_util_id` = 502194) 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=502194 AND note_visu IN (1,3,4)

385. 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 = 505060 AND W.type_id = 1) OR (W.util_id != 505060 AND W.type_id = 2)) AND (`post_util_id` = 505060 OR `dest_util_id` = 505060) 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=505060 AND note_visu IN (1,3,4)

387. 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 = 505123 AND W.type_id = 1) OR (W.util_id != 505123 AND W.type_id = 2)) AND (`post_util_id` = 505123 OR `dest_util_id` = 505123) 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=505123 AND note_visu IN (1,3,4)

389. 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 = 505123 AND W.type_id = 1) OR (W.util_id != 505123 AND W.type_id = 2)) AND (`post_util_id` = 505123 OR `dest_util_id` = 505123) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

390. 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 = 505123 AND W.type_id = 1) OR (W.util_id != 505123 AND W.type_id = 2)) AND (`post_util_id` = 505123 OR `dest_util_id` = 505123) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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 = 61220 AND W.type_id = 1) OR (W.util_id != 61220 AND W.type_id = 2)) AND (`post_util_id` = 61220 OR `dest_util_id` = 61220) 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=61220 AND note_visu IN (1,3,4)

393. 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 = 513304 AND W.type_id = 1) OR (W.util_id != 513304 AND W.type_id = 2)) AND (`post_util_id` = 513304 OR `dest_util_id` = 513304) 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=513304 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 = 514216 AND W.type_id = 1) OR (W.util_id != 514216 AND W.type_id = 2)) AND (`post_util_id` = 514216 OR `dest_util_id` = 514216) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

396. 0.0001

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

397. 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 = 515354 AND W.type_id = 1) OR (W.util_id != 515354 AND W.type_id = 2)) AND (`post_util_id` = 515354 OR `dest_util_id` = 515354) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

398. 0.0001

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

399. 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 = 520493 AND W.type_id = 1) OR (W.util_id != 520493 AND W.type_id = 2)) AND (`post_util_id` = 520493 OR `dest_util_id` = 520493) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

400. 0.0001

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

401. 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 = 527945 AND W.type_id = 1) OR (W.util_id != 527945 AND W.type_id = 2)) AND (`post_util_id` = 527945 OR `dest_util_id` = 527945) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

402. 0.0001

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

403. 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 = 530502 AND W.type_id = 1) OR (W.util_id != 530502 AND W.type_id = 2)) AND (`post_util_id` = 530502 OR `dest_util_id` = 530502) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

404. 0.0001

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

405. 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 = 538348 AND W.type_id = 1) OR (W.util_id != 538348 AND W.type_id = 2)) AND (`post_util_id` = 538348 OR `dest_util_id` = 538348) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

406. 0.0001

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

407. 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 = 539023 AND W.type_id = 1) OR (W.util_id != 539023 AND W.type_id = 2)) AND (`post_util_id` = 539023 OR `dest_util_id` = 539023) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

408. 0.0001

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

409. 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 = 543710 AND W.type_id = 1) OR (W.util_id != 543710 AND W.type_id = 2)) AND (`post_util_id` = 543710 OR `dest_util_id` = 543710) 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=543710 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 = 545424 AND W.type_id = 1) OR (W.util_id != 545424 AND W.type_id = 2)) AND (`post_util_id` = 545424 OR `dest_util_id` = 545424) 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=545424 AND note_visu IN (1,3,4)

413. 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 = 546092 AND W.type_id = 1) OR (W.util_id != 546092 AND W.type_id = 2)) AND (`post_util_id` = 546092 OR `dest_util_id` = 546092) 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=546092 AND note_visu IN (1,3,4)

415. 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 = 546480 AND W.type_id = 1) OR (W.util_id != 546480 AND W.type_id = 2)) AND (`post_util_id` = 546480 OR `dest_util_id` = 546480) 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=546480 AND note_visu IN (1,3,4)

417. 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 = 546480 AND W.type_id = 1) OR (W.util_id != 546480 AND W.type_id = 2)) AND (`post_util_id` = 546480 OR `dest_util_id` = 546480) 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 = 548805 AND W.type_id = 1) OR (W.util_id != 548805 AND W.type_id = 2)) AND (`post_util_id` = 548805 OR `dest_util_id` = 548805) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

419. 0.0001

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

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

421. 0.0002

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

422. 0.0001

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

423. 0.0001

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

424. 0.0009

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

425. 0

     SELECT count(*) as nbwish FROM wish

426. 0.0497

     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

426 requetes sql en 0.1895