Location kayak

1. 0.0001

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

2. 0

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

3. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

4. 0.0014

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

5. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='kayak'

6. 0.0383

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

7. 0.0001

   SELECT * FROM texte WHERE cate_id=95

8. 0.0002

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

9. 0.0001

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

10. 0.0001

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

11. 0.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 (95) ORDER BY ssrubr_order ASC

12. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='kayak' AND cate_id='95'

13. 0.0361

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

14. 0.0412

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='95' AND MATCH (wish_desc) AGAINST ('(+kayak*)' 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 = 1113 AND W.type_id = 1) OR (W.util_id != 1113 AND W.type_id = 2)) AND (`post_util_id` = 1113 OR `dest_util_id` = 1113) 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=1113 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 = 2028 AND W.type_id = 1) OR (W.util_id != 2028 AND W.type_id = 2)) AND (`post_util_id` = 2028 OR `dest_util_id` = 2028) 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=2028 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 = 2140 AND W.type_id = 1) OR (W.util_id != 2140 AND W.type_id = 2)) AND (`post_util_id` = 2140 OR `dest_util_id` = 2140) 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=2140 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 = 2140 AND W.type_id = 1) OR (W.util_id != 2140 AND W.type_id = 2)) AND (`post_util_id` = 2140 OR `dest_util_id` = 2140) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

22. 0.0001

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

23. 0.0001

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

24. 0.0001

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

25. 0.0001

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

26. 0.0001

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

27. 0.0001

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

28. 0.0001

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

29. 0.0001

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

30. 0.0001

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

31. 0.0001

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

32. 0.0001

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

33. 0.0001

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

34. 0.0001

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

35. 0.0001

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

36. 0.0001

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

37. 0.0001

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

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 = 29864 AND W.type_id = 1) OR (W.util_id != 29864 AND W.type_id = 2)) AND (`post_util_id` = 29864 OR `dest_util_id` = 29864) 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=29864 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 = 36651 AND W.type_id = 1) OR (W.util_id != 36651 AND W.type_id = 2)) AND (`post_util_id` = 36651 OR `dest_util_id` = 36651) 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=36651 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 = 39273 AND W.type_id = 1) OR (W.util_id != 39273 AND W.type_id = 2)) AND (`post_util_id` = 39273 OR `dest_util_id` = 39273) 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=39273 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 = 40868 AND W.type_id = 1) OR (W.util_id != 40868 AND W.type_id = 2)) AND (`post_util_id` = 40868 OR `dest_util_id` = 40868) 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=40868 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 = 47923 AND W.type_id = 1) OR (W.util_id != 47923 AND W.type_id = 2)) AND (`post_util_id` = 47923 OR `dest_util_id` = 47923) 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=47923 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 = 68007 AND W.type_id = 1) OR (W.util_id != 68007 AND W.type_id = 2)) AND (`post_util_id` = 68007 OR `dest_util_id` = 68007) 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=68007 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 = 79868 AND W.type_id = 1) OR (W.util_id != 79868 AND W.type_id = 2)) AND (`post_util_id` = 79868 OR `dest_util_id` = 79868) 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=79868 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 = 85104 AND W.type_id = 1) OR (W.util_id != 85104 AND W.type_id = 2)) AND (`post_util_id` = 85104 OR `dest_util_id` = 85104) 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=85104 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 = 92178 AND W.type_id = 1) OR (W.util_id != 92178 AND W.type_id = 2)) AND (`post_util_id` = 92178 OR `dest_util_id` = 92178) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

65. 0.0001

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

66. 0.0001

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

67. 0.0001

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

68. 0.0001

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

69. 0.0001

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

70. 0.0001

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

71. 0.0001

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

72. 0.0001

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

73. 0.0001

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

81. 0.0001

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

82. 0.0001

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

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 = 160811 AND W.type_id = 1) OR (W.util_id != 160811 AND W.type_id = 2)) AND (`post_util_id` = 160811 OR `dest_util_id` = 160811) 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=160811 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 = 161479 AND W.type_id = 1) OR (W.util_id != 161479 AND W.type_id = 2)) AND (`post_util_id` = 161479 OR `dest_util_id` = 161479) 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=161479 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 = 161416 AND W.type_id = 1) OR (W.util_id != 161416 AND W.type_id = 2)) AND (`post_util_id` = 161416 OR `dest_util_id` = 161416) 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=161416 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 = 162662 AND W.type_id = 1) OR (W.util_id != 162662 AND W.type_id = 2)) AND (`post_util_id` = 162662 OR `dest_util_id` = 162662) 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=162662 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 = 139690 AND W.type_id = 1) OR (W.util_id != 139690 AND W.type_id = 2)) AND (`post_util_id` = 139690 OR `dest_util_id` = 139690) 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=139690 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 = 163474 AND W.type_id = 1) OR (W.util_id != 163474 AND W.type_id = 2)) AND (`post_util_id` = 163474 OR `dest_util_id` = 163474) 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=163474 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 = 163474 AND W.type_id = 1) OR (W.util_id != 163474 AND W.type_id = 2)) AND (`post_util_id` = 163474 OR `dest_util_id` = 163474) 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 = 168501 AND W.type_id = 1) OR (W.util_id != 168501 AND W.type_id = 2)) AND (`post_util_id` = 168501 OR `dest_util_id` = 168501) 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=168501 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 = 169938 AND W.type_id = 1) OR (W.util_id != 169938 AND W.type_id = 2)) AND (`post_util_id` = 169938 OR `dest_util_id` = 169938) 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=169938 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 = 173977 AND W.type_id = 1) OR (W.util_id != 173977 AND W.type_id = 2)) AND (`post_util_id` = 173977 OR `dest_util_id` = 173977) 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=173977 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 = 173977 AND W.type_id = 1) OR (W.util_id != 173977 AND W.type_id = 2)) AND (`post_util_id` = 173977 OR `dest_util_id` = 173977) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

120. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

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 = 183239 AND W.type_id = 1) OR (W.util_id != 183239 AND W.type_id = 2)) AND (`post_util_id` = 183239 OR `dest_util_id` = 183239) 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=183239 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 = 183658 AND W.type_id = 1) OR (W.util_id != 183658 AND W.type_id = 2)) AND (`post_util_id` = 183658 OR `dest_util_id` = 183658) 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=183658 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 = 185189 AND W.type_id = 1) OR (W.util_id != 185189 AND W.type_id = 2)) AND (`post_util_id` = 185189 OR `dest_util_id` = 185189) 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=185189 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 = 185390 AND W.type_id = 1) OR (W.util_id != 185390 AND W.type_id = 2)) AND (`post_util_id` = 185390 OR `dest_util_id` = 185390) 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=185390 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 = 185911 AND W.type_id = 1) OR (W.util_id != 185911 AND W.type_id = 2)) AND (`post_util_id` = 185911 OR `dest_util_id` = 185911) 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=185911 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 = 187946 AND W.type_id = 1) OR (W.util_id != 187946 AND W.type_id = 2)) AND (`post_util_id` = 187946 OR `dest_util_id` = 187946) 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=187946 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 = 188766 AND W.type_id = 1) OR (W.util_id != 188766 AND W.type_id = 2)) AND (`post_util_id` = 188766 OR `dest_util_id` = 188766) 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=188766 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 = 189872 AND W.type_id = 1) OR (W.util_id != 189872 AND W.type_id = 2)) AND (`post_util_id` = 189872 OR `dest_util_id` = 189872) 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=189872 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 = 190036 AND W.type_id = 1) OR (W.util_id != 190036 AND W.type_id = 2)) AND (`post_util_id` = 190036 OR `dest_util_id` = 190036) 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=190036 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 = 190539 AND W.type_id = 1) OR (W.util_id != 190539 AND W.type_id = 2)) AND (`post_util_id` = 190539 OR `dest_util_id` = 190539) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

147. 0.0001

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

148. 0.0001

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

149. 0.0001

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

150. 0.0001

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

151. 0.0001

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

152. 0.0001

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

153. 0.0001

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

154. 0.0001

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

155. 0.0001

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

156. 0.0001

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

157. 0.0001

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

158. 0.0001

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

159. 0.0001

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

160. 0.0001

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

161. 0.0001

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

162. 0.0001

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

163. 0.0001

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

164. 0.0001

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

165. 0.0001

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

166. 0.0001

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

167. 0.0001

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

168. 0.0001

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

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

172. 0.0001

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

173. 0.0001

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

174. 0.0001

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

175. 0.0001

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

176. 0.0001

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

177. 0.0001

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

178. 0.0001

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

179. 0.0001

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

180. 0.0001

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

181. 0.0001

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

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 = 148533 AND W.type_id = 1) OR (W.util_id != 148533 AND W.type_id = 2)) AND (`post_util_id` = 148533 OR `dest_util_id` = 148533) 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=148533 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 = 254698 AND W.type_id = 1) OR (W.util_id != 254698 AND W.type_id = 2)) AND (`post_util_id` = 254698 OR `dest_util_id` = 254698) 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=254698 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 = 257805 AND W.type_id = 1) OR (W.util_id != 257805 AND W.type_id = 2)) AND (`post_util_id` = 257805 OR `dest_util_id` = 257805) 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=257805 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 = 257951 AND W.type_id = 1) OR (W.util_id != 257951 AND W.type_id = 2)) AND (`post_util_id` = 257951 OR `dest_util_id` = 257951) 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=257951 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 = 259655 AND W.type_id = 1) OR (W.util_id != 259655 AND W.type_id = 2)) AND (`post_util_id` = 259655 OR `dest_util_id` = 259655) 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=259655 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 = 260510 AND W.type_id = 1) OR (W.util_id != 260510 AND W.type_id = 2)) AND (`post_util_id` = 260510 OR `dest_util_id` = 260510) 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=260510 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 = 262049 AND W.type_id = 1) OR (W.util_id != 262049 AND W.type_id = 2)) AND (`post_util_id` = 262049 OR `dest_util_id` = 262049) 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=262049 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 = 262862 AND W.type_id = 1) OR (W.util_id != 262862 AND W.type_id = 2)) AND (`post_util_id` = 262862 OR `dest_util_id` = 262862) 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=262862 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 = 262212 AND W.type_id = 1) OR (W.util_id != 262212 AND W.type_id = 2)) AND (`post_util_id` = 262212 OR `dest_util_id` = 262212) 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=262212 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 = 265026 AND W.type_id = 1) OR (W.util_id != 265026 AND W.type_id = 2)) AND (`post_util_id` = 265026 OR `dest_util_id` = 265026) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

201. 0.0001

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

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 = 263349 AND W.type_id = 1) OR (W.util_id != 263349 AND W.type_id = 2)) AND (`post_util_id` = 263349 OR `dest_util_id` = 263349) 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=263349 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 = 268032 AND W.type_id = 1) OR (W.util_id != 268032 AND W.type_id = 2)) AND (`post_util_id` = 268032 OR `dest_util_id` = 268032) 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=268032 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 = 268569 AND W.type_id = 1) OR (W.util_id != 268569 AND W.type_id = 2)) AND (`post_util_id` = 268569 OR `dest_util_id` = 268569) 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=268569 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 = 273547 AND W.type_id = 1) OR (W.util_id != 273547 AND W.type_id = 2)) AND (`post_util_id` = 273547 OR `dest_util_id` = 273547) 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=273547 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 = 275930 AND W.type_id = 1) OR (W.util_id != 275930 AND W.type_id = 2)) AND (`post_util_id` = 275930 OR `dest_util_id` = 275930) 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=275930 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 = 270868 AND W.type_id = 1) OR (W.util_id != 270868 AND W.type_id = 2)) AND (`post_util_id` = 270868 OR `dest_util_id` = 270868) 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=270868 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 = 276336 AND W.type_id = 1) OR (W.util_id != 276336 AND W.type_id = 2)) AND (`post_util_id` = 276336 OR `dest_util_id` = 276336) 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=276336 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 = 282194 AND W.type_id = 1) OR (W.util_id != 282194 AND W.type_id = 2)) AND (`post_util_id` = 282194 OR `dest_util_id` = 282194) 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=282194 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 = 282892 AND W.type_id = 1) OR (W.util_id != 282892 AND W.type_id = 2)) AND (`post_util_id` = 282892 OR `dest_util_id` = 282892) 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=282892 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 = 282463 AND W.type_id = 1) OR (W.util_id != 282463 AND W.type_id = 2)) AND (`post_util_id` = 282463 OR `dest_util_id` = 282463) 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=282463 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 = 297718 AND W.type_id = 1) OR (W.util_id != 297718 AND W.type_id = 2)) AND (`post_util_id` = 297718 OR `dest_util_id` = 297718) 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=297718 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 = 315202 AND W.type_id = 1) OR (W.util_id != 315202 AND W.type_id = 2)) AND (`post_util_id` = 315202 OR `dest_util_id` = 315202) 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=315202 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 = 319243 AND W.type_id = 1) OR (W.util_id != 319243 AND W.type_id = 2)) AND (`post_util_id` = 319243 OR `dest_util_id` = 319243) 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=319243 AND note_visu IN (1,3,4)

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

230. 0.0002

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

231. 0.0001

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

232. 0.0001

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

233. 0.0001

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

234. 0.0002

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

235. 0.0001

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

236. 0.0001

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

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 = 330291 AND W.type_id = 1) OR (W.util_id != 330291 AND W.type_id = 2)) AND (`post_util_id` = 330291 OR `dest_util_id` = 330291) 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=330291 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 = 333116 AND W.type_id = 1) OR (W.util_id != 333116 AND W.type_id = 2)) AND (`post_util_id` = 333116 OR `dest_util_id` = 333116) 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=333116 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 = 333319 AND W.type_id = 1) OR (W.util_id != 333319 AND W.type_id = 2)) AND (`post_util_id` = 333319 OR `dest_util_id` = 333319) 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=333319 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 = 333535 AND W.type_id = 1) OR (W.util_id != 333535 AND W.type_id = 2)) AND (`post_util_id` = 333535 OR `dest_util_id` = 333535) 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=333535 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 = 335799 AND W.type_id = 1) OR (W.util_id != 335799 AND W.type_id = 2)) AND (`post_util_id` = 335799 OR `dest_util_id` = 335799) 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=335799 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 = 315306 AND W.type_id = 1) OR (W.util_id != 315306 AND W.type_id = 2)) AND (`post_util_id` = 315306 OR `dest_util_id` = 315306) 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=315306 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 = 194390 AND W.type_id = 1) OR (W.util_id != 194390 AND W.type_id = 2)) AND (`post_util_id` = 194390 OR `dest_util_id` = 194390) 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=194390 AND note_visu IN (1,3,4)

251. 0.0005

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 310747 AND W.type_id = 1) OR (W.util_id != 310747 AND W.type_id = 2)) AND (`post_util_id` = 310747 OR `dest_util_id` = 310747) 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=310747 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 = 340101 AND W.type_id = 1) OR (W.util_id != 340101 AND W.type_id = 2)) AND (`post_util_id` = 340101 OR `dest_util_id` = 340101) 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=340101 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 = 340425 AND W.type_id = 1) OR (W.util_id != 340425 AND W.type_id = 2)) AND (`post_util_id` = 340425 OR `dest_util_id` = 340425) 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=340425 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 = 340552 AND W.type_id = 1) OR (W.util_id != 340552 AND W.type_id = 2)) AND (`post_util_id` = 340552 OR `dest_util_id` = 340552) 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=340552 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 = 344352 AND W.type_id = 1) OR (W.util_id != 344352 AND W.type_id = 2)) AND (`post_util_id` = 344352 OR `dest_util_id` = 344352) 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=344352 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 = 344898 AND W.type_id = 1) OR (W.util_id != 344898 AND W.type_id = 2)) AND (`post_util_id` = 344898 OR `dest_util_id` = 344898) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

262. 0.0001

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

263. 0.0001

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

264. 0.0001

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

265. 0.0001

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

266. 0.0001

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

267. 0.0001

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

268. 0.0001

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

269. 0.0001

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

270. 0.0001

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

271. 0.0001

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

272. 0.0001

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

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

274. 0.0001

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

275. 0.0001

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

276. 0.0001

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

277. 0.0001

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

278. 0.0001

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

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

282. 0.0001

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

283. 0.0001

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

284. 0.0001

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

285. 0.0001

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

286. 0.0001

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

287. 0.0001

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

288. 0.0001

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

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

298. 0.0001

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

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

302. 0.0001

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

303. 0.0001

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

304. 0.0001

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

305. 0.0001

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

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 = 74432 AND W.type_id = 1) OR (W.util_id != 74432 AND W.type_id = 2)) AND (`post_util_id` = 74432 OR `dest_util_id` = 74432) 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=74432 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 = 365233 AND W.type_id = 1) OR (W.util_id != 365233 AND W.type_id = 2)) AND (`post_util_id` = 365233 OR `dest_util_id` = 365233) 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=365233 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 = 312727 AND W.type_id = 1) OR (W.util_id != 312727 AND W.type_id = 2)) AND (`post_util_id` = 312727 OR `dest_util_id` = 312727) 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=312727 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 = 20444 AND W.type_id = 1) OR (W.util_id != 20444 AND W.type_id = 2)) AND (`post_util_id` = 20444 OR `dest_util_id` = 20444) 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=20444 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 = 21283 AND W.type_id = 1) OR (W.util_id != 21283 AND W.type_id = 2)) AND (`post_util_id` = 21283 OR `dest_util_id` = 21283) 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=21283 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 = 422957 AND W.type_id = 1) OR (W.util_id != 422957 AND W.type_id = 2)) AND (`post_util_id` = 422957 OR `dest_util_id` = 422957) 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=422957 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 = 303209 AND W.type_id = 1) OR (W.util_id != 303209 AND W.type_id = 2)) AND (`post_util_id` = 303209 OR `dest_util_id` = 303209) 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=303209 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 = 425191 AND W.type_id = 1) OR (W.util_id != 425191 AND W.type_id = 2)) AND (`post_util_id` = 425191 OR `dest_util_id` = 425191) 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=425191 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 = 429798 AND W.type_id = 1) OR (W.util_id != 429798 AND W.type_id = 2)) AND (`post_util_id` = 429798 OR `dest_util_id` = 429798) 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=429798 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 = 430882 AND W.type_id = 1) OR (W.util_id != 430882 AND W.type_id = 2)) AND (`post_util_id` = 430882 OR `dest_util_id` = 430882) 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=430882 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 = 435467 AND W.type_id = 1) OR (W.util_id != 435467 AND W.type_id = 2)) AND (`post_util_id` = 435467 OR `dest_util_id` = 435467) 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=435467 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 = 435820 AND W.type_id = 1) OR (W.util_id != 435820 AND W.type_id = 2)) AND (`post_util_id` = 435820 OR `dest_util_id` = 435820) 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=435820 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 = 436792 AND W.type_id = 1) OR (W.util_id != 436792 AND W.type_id = 2)) AND (`post_util_id` = 436792 OR `dest_util_id` = 436792) 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=436792 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 = 437018 AND W.type_id = 1) OR (W.util_id != 437018 AND W.type_id = 2)) AND (`post_util_id` = 437018 OR `dest_util_id` = 437018) 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=437018 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 = 437176 AND W.type_id = 1) OR (W.util_id != 437176 AND W.type_id = 2)) AND (`post_util_id` = 437176 OR `dest_util_id` = 437176) 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=437176 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 = 442049 AND W.type_id = 1) OR (W.util_id != 442049 AND W.type_id = 2)) AND (`post_util_id` = 442049 OR `dest_util_id` = 442049) 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=442049 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 = 441504 AND W.type_id = 1) OR (W.util_id != 441504 AND W.type_id = 2)) AND (`post_util_id` = 441504 OR `dest_util_id` = 441504) 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=441504 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 = 445850 AND W.type_id = 1) OR (W.util_id != 445850 AND W.type_id = 2)) AND (`post_util_id` = 445850 OR `dest_util_id` = 445850) 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=445850 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 = 447720 AND W.type_id = 1) OR (W.util_id != 447720 AND W.type_id = 2)) AND (`post_util_id` = 447720 OR `dest_util_id` = 447720) 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=447720 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 = 306517 AND W.type_id = 1) OR (W.util_id != 306517 AND W.type_id = 2)) AND (`post_util_id` = 306517 OR `dest_util_id` = 306517) 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=306517 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 = 140272 AND W.type_id = 1) OR (W.util_id != 140272 AND W.type_id = 2)) AND (`post_util_id` = 140272 OR `dest_util_id` = 140272) 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=140272 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 = 450693 AND W.type_id = 1) OR (W.util_id != 450693 AND W.type_id = 2)) AND (`post_util_id` = 450693 OR `dest_util_id` = 450693) 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=450693 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 = 406835 AND W.type_id = 1) OR (W.util_id != 406835 AND W.type_id = 2)) AND (`post_util_id` = 406835 OR `dest_util_id` = 406835) 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=406835 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 = 452666 AND W.type_id = 1) OR (W.util_id != 452666 AND W.type_id = 2)) AND (`post_util_id` = 452666 OR `dest_util_id` = 452666) 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=452666 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 = 345419 AND W.type_id = 1) OR (W.util_id != 345419 AND W.type_id = 2)) AND (`post_util_id` = 345419 OR `dest_util_id` = 345419) 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=345419 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 = 453520 AND W.type_id = 1) OR (W.util_id != 453520 AND W.type_id = 2)) AND (`post_util_id` = 453520 OR `dest_util_id` = 453520) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

357. 0.0001

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

358. 0.0001

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

359. 0.0001

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

360. 0.0001

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

361. 0.0001

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

362. 0.0001

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

363. 0.0001

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

364. 0.0001

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

365. 0.0001

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

366. 0.0001

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

367. 0.0001

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

368. 0.0001

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

369. 0.0001

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

370. 0.0001

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

371. 0.0001

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

372. 0.0001

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

373. 0.0001

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

374. 0.0001

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

375. 0.0001

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

376. 0.0001

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

377. 0.0001

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

378. 0.0001

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

379. 0.0001

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

380. 0.0001

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

381. 0.0001

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

382. 0.0001

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

383. 0.0001

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

384. 0.0001

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

385. 0.0001

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

386. 0.0001

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

387. 0.0001

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

388. 0.0001

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

389. 0.0001

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

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

391. 0.0001

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

392. 0.0001

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

393. 0.0001

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

394. 0.0001

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

395. 0.0001

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

396. 0.0001

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

397. 0.0001

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

398. 0.0001

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

399. 0.0001

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

400. 0.0001

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

401. 0.0001

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

402. 0.0001

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

403. 0.0001

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

404. 0.0001

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

405. 0.0001

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

406. 0.0001

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

407. 0.0001

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

408. 0.0001

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

409. 0.0001

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

410. 0.0001

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

411. 0.0001

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

412. 0.0001

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

413. 0.0001

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

414. 0.0001

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

415. 0.0001

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

416. 0.0001

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

417. 0.0001

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

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

421. 0.0001

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

422. 0.0001

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

423. 0.0001

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

424. 0.0001

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

425. 0.0001

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

426. 0.0001

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

427. 0.0001

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

428. 0.0001

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

429. 0.0001

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

430. 0.0001

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

431. 0.0001

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

432. 0.0001

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

433. 0.0001

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

434. 0.0001

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

435. 0.0001

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

436. 0.0001

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

437. 0.0001

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

438. 0.0001

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

439. 0.0001

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

440. 0.0001

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

441. 0.0001

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

442. 0.0001

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

443. 0.0001

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

444. 0.0001

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

445. 0.0001

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

446. 0.0001

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

447. 0.0001

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

448. 0.0001

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

449. 0.0001

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

450. 0.0001

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

451. 0.0001

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

452. 0.0001

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

453. 0.0001

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

454. 0.0001

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

455. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

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

457. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 523371

458. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

459. 0.0001

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

460. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 521815

461. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

462. 0.0001

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

463. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 521296

464. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

465. 0.0001

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

466. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 518133

467. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

468. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 192071

469. 0

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

470. 0.0001

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

471. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 510481

472. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

473. 0.0001

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

474. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 509080

475. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

476. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 461619

477. 0

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

478. 0.0001

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

479. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 236913

480. 0

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1124' LIMIT 0,1

481. 0.0001

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

482. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 461609

483. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

484. 0.0001

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

485. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 457416

486. 0

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

487. 0.0001

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

488. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 441504

489. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

490. 0.0001

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

491. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 425191

492. 0

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

493. 0.0001

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

494. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 303209

495. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

496. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 365233

497. 0

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

498. 0.0001

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

499. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 445850

500. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

501. 0.0001

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

502. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 436792

503. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

504. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 368073

505. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

506. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 356291

507. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

508. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 344898

509. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1124' LIMIT 0,1

510. 0.0001

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

511. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 363179

512. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1124' LIMIT 0,1

513. 0.0001

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

514. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 363179

515. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

516. 0.0001

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

517. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 351942

518. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

519. 0.0001

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

520. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 315306

521. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

522. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 276336

523. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

524. 0.0001

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

525. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 330291

526. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

527. 0.0001

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

528. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 327444

529. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

530. 0.0001

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

531. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 297718

532. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

533. 0.0001

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

534. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 270868

535. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

536. 0.0001

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

537. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 275930

538. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

539. 0.0001

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

540. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 273547

541. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

542. 0.0001

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

543. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 262862

544. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

545. 0.0001

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

546. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 262049

547. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

548. 0.0001

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

549. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 183658

550. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

551. 0.0001

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

552. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 251649

553. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

554. 0.0001

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

555. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 213024

556. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

557. 0.0001

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

558. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 199090

559. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

560. 0.0001

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 185189

561. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1124' LIMIT 0,1

562. 0.0001

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

563. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 190036

564. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

565. 0.0001

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

566. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 182785

567. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

568. 0.0001

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

569. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 182937

570. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

571. 0.0001

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

572. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 176147

573. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

574. 0.0001

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

575. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 173977

576. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

577. 0.0001

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

578. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 173977

579. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

580. 0.0001

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

581. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 161416

582. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

583. 0.0001

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

584. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 159472

585. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

586. 0.0001

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

587. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 162662

588. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

589. 0.0001

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

590. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 159472

591. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

592. 0.0001

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

593. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 99293

594. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

595. 0.0001

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

596. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 99183

597. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

598. 0.0001

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

599. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 79868

600. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

601. 0.0001

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

602. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 68007

603. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='710' LIMIT 0,1

604. 0.0001

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

605. 0.0002

     SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 19761

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

607. 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='kayak' OR ssrubr_slug like '%kayak%' OR MATCH (ssrubr_slug) AGAINST ('(+kayak)')) AND sk.ssrubr_id='710' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

608. 0.0001

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

609. 0.001

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

610. 0

     SELECT count(*) as nbwish FROM wish

611. 0.0489

     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

611 requetes sql en 0.2314