Service garde chat à 78330 Fontenay-le-fleury

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='garde-d-animaux'

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='78330' AND ville_nom like '%fontenay%le%fleury%' ORDER BY ville_population_2012 DESC LIMIT 0,1

5. 0.0001

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

6. 0.0001

   SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78330'

7. 0.0023

   SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.05- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>1.7768446819952 AND ville_longitude_deg<2.3231553180048 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='chat'

9. 0.0009

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='45'AND MATCH (wish_title,wish_desc) AGAINST ('+chat*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '78330%'

10. 0.0001

    SELECT * FROM texte WHERE cate_id=45

11. 0.0002

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

12. 0.0001

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

13. 0.0002

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

14. 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 (45) ORDER BY ssrubr_order ASC

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='chat' AND cate_id='45'

16. 0.0001

    SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='78330'

17. 0.0022

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.05- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>1.7768446819952 AND ville_longitude_deg<2.3231553180048 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0072

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.05- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.3671058163378 AND ville_longitude_deg<2.7328941836622 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0829

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='45' AND MATCH (wish_desc) AGAINST ('(+chat*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (78330,78330,78590,78210,78450,78390,78590,78870,78860,78340,78150,78190,78150,78280,78180,78620,78160,78450,78000,78370,78430,78960,78112,78750,78170,78990,78380,78290,78810,78350,78530,78220,78560,78117,78470,92430,92420,78240,78114,78240,78100,78470,78140,78230,78117,92380,78810,78350,92410,78400,78320,78850,78110,92310,78640,78320,78640,92370,78310,78121,78760,78630,91190,78640,78310,92210,91400,91190,78300,78460,78470,92500,78360,78320,78640,78720,78720,78650,78490,92360,92190,91570,78690,92000,91430,78600,92800,92150,92100,78580,78420,91470,78955,78460,78490,78490,78670,78670,78580,78124,91430,78630,91440,78720,78800,78690,78490,92130,78650,92140,91190,91940,91400,78124,92350,78600,78260,91470,92290,78770,92320,91940,92400,92250,91400,78540,92260,92330,78490,78490,92200,78490,91370,78500,78920,78720,95870,78610,78770,92240,78490,92700,78580,92170,91120,78490,92220,91470,78570,78570,78770,78580,78770,91470,78130,91940,78510,78700,78770,78480,95530,92270,92300,91300,92120,78126,78610,91140,92160,91640,78410)

20. 0.0872

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.05- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='45' AND MATCH (wish_desc) AGAINST ('(+chat*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (78330,78330,78590,78210,78450,78390,78590,78870,78860,78340,78150,78190,78150,78280,78180,78620,78160,78450,78000,78370,78430,78960,78112,78750,78170,78990,78380,78290,78810,78350,78530,78220,78560,78117,78470,92430,92420,78240,78114,78240,78100,78470,78140,78230,78117,92380,78810,78350,92410,78400,78320,78850,78110,92310,78640,78320,78640,92370,78310,78121,78760,78630,91190,78640,78310,92210,91400,91190,78300,78460,78470,92500,78360,78320,78640,78720,78720,78650,78490,92360,92190,91570,78690,92000,91430,78600,92800,92150,92100,78580,78420,91470,78955,78460,78490,78490,78670,78670,78580,78124,91430,78630,91440,78720,78800,78690,78490,92130,78650,92140,91190,91940,91400,78124,92350,78600,78260,91470,92290,78770,92320,91940,92400,92250,91400,78540,92260,92330,78490,78490,92200,78490,91370,78500,78920,78720,95870,78610,78770,92240,78490,92700,78580,92170,91120,78490,92220,91470,78570,78570,78770,78580,78770,91470,78130,91940,78510,78700,78770,78480,95530,92270,92300,91300,92120,78126,78610,91140,92160,91640,78410) AND type_id=1 GROUP BY wish_id

21. 0.0001

    SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='78330'

22. 0.0025

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.05- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>1.7768446819952 AND ville_longitude_deg<2.3231553180048 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0086

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.05- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.3671058163378 AND ville_longitude_deg<2.7328941836622 HAVING distance <= 50 ORDER BY distance ASC

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

26. 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 = 13561 AND W.type_id = 1) OR (W.util_id != 13561 AND W.type_id = 2)) AND (`post_util_id` = 13561 OR `dest_util_id` = 13561) 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=13561 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 = 25767 AND W.type_id = 1) OR (W.util_id != 25767 AND W.type_id = 2)) AND (`post_util_id` = 25767 OR `dest_util_id` = 25767) 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=25767 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 = 28599 AND W.type_id = 1) OR (W.util_id != 28599 AND W.type_id = 2)) AND (`post_util_id` = 28599 OR `dest_util_id` = 28599) 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=28599 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 = 42152 AND W.type_id = 1) OR (W.util_id != 42152 AND W.type_id = 2)) AND (`post_util_id` = 42152 OR `dest_util_id` = 42152) 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=42152 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 = 47848 AND W.type_id = 1) OR (W.util_id != 47848 AND W.type_id = 2)) AND (`post_util_id` = 47848 OR `dest_util_id` = 47848) 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=47848 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 = 53817 AND W.type_id = 1) OR (W.util_id != 53817 AND W.type_id = 2)) AND (`post_util_id` = 53817 OR `dest_util_id` = 53817) 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=53817 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 = 56954 AND W.type_id = 1) OR (W.util_id != 56954 AND W.type_id = 2)) AND (`post_util_id` = 56954 OR `dest_util_id` = 56954) 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=56954 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 = 62340 AND W.type_id = 1) OR (W.util_id != 62340 AND W.type_id = 2)) AND (`post_util_id` = 62340 OR `dest_util_id` = 62340) 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=62340 AND note_visu IN (1,3,4)

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

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

47. 0.0001

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

48. 0.0001

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

49. 0.0002

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

50. 0.0001

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

51. 0.0001

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

52. 0.0001

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

53. 0.0001

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

54. 0.0001

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

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

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

62. 0.0001

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

63. 0.0001

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

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 = 93275 AND W.type_id = 1) OR (W.util_id != 93275 AND W.type_id = 2)) AND (`post_util_id` = 93275 OR `dest_util_id` = 93275) 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=93275 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 = 95830 AND W.type_id = 1) OR (W.util_id != 95830 AND W.type_id = 2)) AND (`post_util_id` = 95830 OR `dest_util_id` = 95830) 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=95830 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 = 99085 AND W.type_id = 1) OR (W.util_id != 99085 AND W.type_id = 2)) AND (`post_util_id` = 99085 OR `dest_util_id` = 99085) 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=99085 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 = 99813 AND W.type_id = 1) OR (W.util_id != 99813 AND W.type_id = 2)) AND (`post_util_id` = 99813 OR `dest_util_id` = 99813) 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=99813 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 = 102645 AND W.type_id = 1) OR (W.util_id != 102645 AND W.type_id = 2)) AND (`post_util_id` = 102645 OR `dest_util_id` = 102645) 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=102645 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 = 102729 AND W.type_id = 1) OR (W.util_id != 102729 AND W.type_id = 2)) AND (`post_util_id` = 102729 OR `dest_util_id` = 102729) 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=102729 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 = 107897 AND W.type_id = 1) OR (W.util_id != 107897 AND W.type_id = 2)) AND (`post_util_id` = 107897 OR `dest_util_id` = 107897) 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=107897 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 = 107915 AND W.type_id = 1) OR (W.util_id != 107915 AND W.type_id = 2)) AND (`post_util_id` = 107915 OR `dest_util_id` = 107915) 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=107915 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 = 32095 AND W.type_id = 1) OR (W.util_id != 32095 AND W.type_id = 2)) AND (`post_util_id` = 32095 OR `dest_util_id` = 32095) 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=32095 AND note_visu IN (1,3,4)

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

89. 0.0001

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

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

91. 0.0001

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

92. 0.0001

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

93. 0.0002

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

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

95. 0.0001

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

96. 0.0001

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

100. 0.0001

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

101. 0.0001

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

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

104. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 93732 AND W.type_id = 1) OR (W.util_id != 93732 AND W.type_id = 2)) AND (`post_util_id` = 93732 OR `dest_util_id` = 93732) 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=93732 AND note_visu IN (1,3,4)

106. 0.0002

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

120. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

128. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 24170 AND W.type_id = 1) OR (W.util_id != 24170 AND W.type_id = 2)) AND (`post_util_id` = 24170 OR `dest_util_id` = 24170) 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=24170 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 = 131387 AND W.type_id = 1) OR (W.util_id != 131387 AND W.type_id = 2)) AND (`post_util_id` = 131387 OR `dest_util_id` = 131387) 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=131387 AND note_visu IN (1,3,4)

132. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 114726 AND W.type_id = 1) OR (W.util_id != 114726 AND W.type_id = 2)) AND (`post_util_id` = 114726 OR `dest_util_id` = 114726) 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=114726 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 = 177401 AND W.type_id = 1) OR (W.util_id != 177401 AND W.type_id = 2)) AND (`post_util_id` = 177401 OR `dest_util_id` = 177401) 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=177401 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 = 177989 AND W.type_id = 1) OR (W.util_id != 177989 AND W.type_id = 2)) AND (`post_util_id` = 177989 OR `dest_util_id` = 177989) 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=177989 AND note_visu IN (1,3,4)

138. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 178738 AND W.type_id = 1) OR (W.util_id != 178738 AND W.type_id = 2)) AND (`post_util_id` = 178738 OR `dest_util_id` = 178738) 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=178738 AND note_visu IN (1,3,4)

140. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 181526 AND W.type_id = 1) OR (W.util_id != 181526 AND W.type_id = 2)) AND (`post_util_id` = 181526 OR `dest_util_id` = 181526) 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=181526 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 = 184767 AND W.type_id = 1) OR (W.util_id != 184767 AND W.type_id = 2)) AND (`post_util_id` = 184767 OR `dest_util_id` = 184767) 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=184767 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 = 185310 AND W.type_id = 1) OR (W.util_id != 185310 AND W.type_id = 2)) AND (`post_util_id` = 185310 OR `dest_util_id` = 185310) 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=185310 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 = 186009 AND W.type_id = 1) OR (W.util_id != 186009 AND W.type_id = 2)) AND (`post_util_id` = 186009 OR `dest_util_id` = 186009) 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=186009 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 = 190705 AND W.type_id = 1) OR (W.util_id != 190705 AND W.type_id = 2)) AND (`post_util_id` = 190705 OR `dest_util_id` = 190705) 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=190705 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 = 193338 AND W.type_id = 1) OR (W.util_id != 193338 AND W.type_id = 2)) AND (`post_util_id` = 193338 OR `dest_util_id` = 193338) 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=193338 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 = 193338 AND W.type_id = 1) OR (W.util_id != 193338 AND W.type_id = 2)) AND (`post_util_id` = 193338 OR `dest_util_id` = 193338) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

153. 0.0001

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

154. 0.0001

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

155. 0.0001

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

156. 0.0001

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

157. 0.0001

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

158. 0.0001

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

159. 0.0001

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

160. 0.0001

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

161. 0.0001

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

162. 0.0001

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

163. 0.0001

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

164. 0.0001

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

165. 0.0001

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

166. 0.0001

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

167. 0.0001

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

168. 0.0001

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

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

172. 0.0001

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

173. 0.0001

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

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 = 228556 AND W.type_id = 1) OR (W.util_id != 228556 AND W.type_id = 2)) AND (`post_util_id` = 228556 OR `dest_util_id` = 228556) 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=228556 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 = 233188 AND W.type_id = 1) OR (W.util_id != 233188 AND W.type_id = 2)) AND (`post_util_id` = 233188 OR `dest_util_id` = 233188) 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=233188 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 = 127942 AND W.type_id = 1) OR (W.util_id != 127942 AND W.type_id = 2)) AND (`post_util_id` = 127942 OR `dest_util_id` = 127942) 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=127942 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 = 242633 AND W.type_id = 1) OR (W.util_id != 242633 AND W.type_id = 2)) AND (`post_util_id` = 242633 OR `dest_util_id` = 242633) 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=242633 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 = 244165 AND W.type_id = 1) OR (W.util_id != 244165 AND W.type_id = 2)) AND (`post_util_id` = 244165 OR `dest_util_id` = 244165) 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=244165 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 = 246388 AND W.type_id = 1) OR (W.util_id != 246388 AND W.type_id = 2)) AND (`post_util_id` = 246388 OR `dest_util_id` = 246388) 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=246388 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 = 252244 AND W.type_id = 1) OR (W.util_id != 252244 AND W.type_id = 2)) AND (`post_util_id` = 252244 OR `dest_util_id` = 252244) 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=252244 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 = 249751 AND W.type_id = 1) OR (W.util_id != 249751 AND W.type_id = 2)) AND (`post_util_id` = 249751 OR `dest_util_id` = 249751) 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=249751 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 = 227513 AND W.type_id = 1) OR (W.util_id != 227513 AND W.type_id = 2)) AND (`post_util_id` = 227513 OR `dest_util_id` = 227513) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

191. 0.0001

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

192. 0.0001

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

193. 0.0001

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

194. 0.0001

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

195. 0.0001

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

196. 0.0001

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

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

198. 0.0001

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

199. 0.0001

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

200. 0.0001

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

201. 0.0001

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

202. 0.0001

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

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

204. 0.0001

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

205. 0.0001

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

206. 0.0001

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

207. 0.0001

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

208. 0.0001

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

209. 0.0001

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

210. 0.0001

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

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

212. 0.0001

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

213. 0.0002

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

214. 0.0001

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

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

216. 0.0001

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

217. 0.0001

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

218. 0.0001

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

219. 0.0001

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

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

225. 0.0002

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=298711 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 = 13871 AND W.type_id = 1) OR (W.util_id != 13871 AND W.type_id = 2)) AND (`post_util_id` = 13871 OR `dest_util_id` = 13871) 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=13871 AND note_visu IN (1,3,4)

228. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 176817 AND W.type_id = 1) OR (W.util_id != 176817 AND W.type_id = 2)) AND (`post_util_id` = 176817 OR `dest_util_id` = 176817) 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=176817 AND note_visu IN (1,3,4)

230. 0.0001

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

231. 0.0001

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

232. 0.0001

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

233. 0.0001

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

234. 0.0001

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

235. 0.0001

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

236. 0.0001

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

237. 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 = 272982 AND W.type_id = 1) OR (W.util_id != 272982 AND W.type_id = 2)) AND (`post_util_id` = 272982 OR `dest_util_id` = 272982) 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=272982 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 = 326431 AND W.type_id = 1) OR (W.util_id != 326431 AND W.type_id = 2)) AND (`post_util_id` = 326431 OR `dest_util_id` = 326431) 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=326431 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 = 330221 AND W.type_id = 1) OR (W.util_id != 330221 AND W.type_id = 2)) AND (`post_util_id` = 330221 OR `dest_util_id` = 330221) 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=330221 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 = 332793 AND W.type_id = 1) OR (W.util_id != 332793 AND W.type_id = 2)) AND (`post_util_id` = 332793 OR `dest_util_id` = 332793) 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=332793 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 = 337074 AND W.type_id = 1) OR (W.util_id != 337074 AND W.type_id = 2)) AND (`post_util_id` = 337074 OR `dest_util_id` = 337074) 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=337074 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 = 337962 AND W.type_id = 1) OR (W.util_id != 337962 AND W.type_id = 2)) AND (`post_util_id` = 337962 OR `dest_util_id` = 337962) 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=337962 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 = 340488 AND W.type_id = 1) OR (W.util_id != 340488 AND W.type_id = 2)) AND (`post_util_id` = 340488 OR `dest_util_id` = 340488) 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=340488 AND note_visu IN (1,3,4)

251. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 342457 AND W.type_id = 1) OR (W.util_id != 342457 AND W.type_id = 2)) AND (`post_util_id` = 342457 OR `dest_util_id` = 342457) 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=342457 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 = 279533 AND W.type_id = 1) OR (W.util_id != 279533 AND W.type_id = 2)) AND (`post_util_id` = 279533 OR `dest_util_id` = 279533) 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=279533 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 = 349553 AND W.type_id = 1) OR (W.util_id != 349553 AND W.type_id = 2)) AND (`post_util_id` = 349553 OR `dest_util_id` = 349553) 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=349553 AND note_visu IN (1,3,4)

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

259. 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 = 297877 AND W.type_id = 1) OR (W.util_id != 297877 AND W.type_id = 2)) AND (`post_util_id` = 297877 OR `dest_util_id` = 297877) 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=297877 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 = 369494 AND W.type_id = 1) OR (W.util_id != 369494 AND W.type_id = 2)) AND (`post_util_id` = 369494 OR `dest_util_id` = 369494) 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=369494 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 = 375205 AND W.type_id = 1) OR (W.util_id != 375205 AND W.type_id = 2)) AND (`post_util_id` = 375205 OR `dest_util_id` = 375205) 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=375205 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 = 380777 AND W.type_id = 1) OR (W.util_id != 380777 AND W.type_id = 2)) AND (`post_util_id` = 380777 OR `dest_util_id` = 380777) 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=380777 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 = 384832 AND W.type_id = 1) OR (W.util_id != 384832 AND W.type_id = 2)) AND (`post_util_id` = 384832 OR `dest_util_id` = 384832) 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=384832 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 = 388499 AND W.type_id = 1) OR (W.util_id != 388499 AND W.type_id = 2)) AND (`post_util_id` = 388499 OR `dest_util_id` = 388499) 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=388499 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 = 393938 AND W.type_id = 1) OR (W.util_id != 393938 AND W.type_id = 2)) AND (`post_util_id` = 393938 OR `dest_util_id` = 393938) 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=393938 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 = 402205 AND W.type_id = 1) OR (W.util_id != 402205 AND W.type_id = 2)) AND (`post_util_id` = 402205 OR `dest_util_id` = 402205) 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=402205 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 = 403114 AND W.type_id = 1) OR (W.util_id != 403114 AND W.type_id = 2)) AND (`post_util_id` = 403114 OR `dest_util_id` = 403114) 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=403114 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 = 129864 AND W.type_id = 1) OR (W.util_id != 129864 AND W.type_id = 2)) AND (`post_util_id` = 129864 OR `dest_util_id` = 129864) 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=129864 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 = 424957 AND W.type_id = 1) OR (W.util_id != 424957 AND W.type_id = 2)) AND (`post_util_id` = 424957 OR `dest_util_id` = 424957) 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=424957 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 = 437477 AND W.type_id = 1) OR (W.util_id != 437477 AND W.type_id = 2)) AND (`post_util_id` = 437477 OR `dest_util_id` = 437477) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

282. 0.0001

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

283. 0.0001

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

284. 0.0001

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

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

286. 0.0001

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

287. 0.0001

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

288. 0.0001

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

289. 0.0001

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

290. 0.0001

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

291. 0.0001

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

292. 0.0002

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

293. 0.0001

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

294. 0.0001

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

295. 0.0001

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

296. 0.0002

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

297. 0.0001

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

298. 0.0002

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

299. 0.0002

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

300. 0.0001

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

301. 0.0001

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

302. 0.0001

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

303. 0.0001

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

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

305. 0.0001

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

306. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 301661 AND W.type_id = 1) OR (W.util_id != 301661 AND W.type_id = 2)) AND (`post_util_id` = 301661 OR `dest_util_id` = 301661) 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=301661 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 = 485360 AND W.type_id = 1) OR (W.util_id != 485360 AND W.type_id = 2)) AND (`post_util_id` = 485360 OR `dest_util_id` = 485360) 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=485360 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 = 503565 AND W.type_id = 1) OR (W.util_id != 503565 AND W.type_id = 2)) AND (`post_util_id` = 503565 OR `dest_util_id` = 503565) 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=503565 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 = 508769 AND W.type_id = 1) OR (W.util_id != 508769 AND W.type_id = 2)) AND (`post_util_id` = 508769 OR `dest_util_id` = 508769) 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=508769 AND note_visu IN (1,3,4)

314. 0.0002

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 275990 AND W.type_id = 1) OR (W.util_id != 275990 AND W.type_id = 2)) AND (`post_util_id` = 275990 OR `dest_util_id` = 275990) 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=275990 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 = 514762 AND W.type_id = 1) OR (W.util_id != 514762 AND W.type_id = 2)) AND (`post_util_id` = 514762 OR `dest_util_id` = 514762) 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=514762 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 = 520762 AND W.type_id = 1) OR (W.util_id != 520762 AND W.type_id = 2)) AND (`post_util_id` = 520762 OR `dest_util_id` = 520762) 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=520762 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 = 514741 AND W.type_id = 1) OR (W.util_id != 514741 AND W.type_id = 2)) AND (`post_util_id` = 514741 OR `dest_util_id` = 514741) 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=514741 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 = 34706 AND W.type_id = 1) OR (W.util_id != 34706 AND W.type_id = 2)) AND (`post_util_id` = 34706 OR `dest_util_id` = 34706) 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=34706 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 = 525908 AND W.type_id = 1) OR (W.util_id != 525908 AND W.type_id = 2)) AND (`post_util_id` = 525908 OR `dest_util_id` = 525908) 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=525908 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 = 322674 AND W.type_id = 1) OR (W.util_id != 322674 AND W.type_id = 2)) AND (`post_util_id` = 322674 OR `dest_util_id` = 322674) 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=322674 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 = 547575 AND W.type_id = 1) OR (W.util_id != 547575 AND W.type_id = 2)) AND (`post_util_id` = 547575 OR `dest_util_id` = 547575) 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=547575 AND note_visu IN (1,3,4)

330. 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='950' LIMIT 0,1

331. 0.0001

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

332. 0.0002

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

333. 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='951' LIMIT 0,1

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

335. 0.0002

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

336. 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='950' LIMIT 0,1

337. 0.0001

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

338. 0.0002

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

339. 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='951' LIMIT 0,1

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

341. 0.0002

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

342. 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='950' LIMIT 0,1

343. 0.0001

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

344. 0.0002

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

345. 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='950' LIMIT 0,1

346. 0.0002

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

347. 0.0003

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

348. 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='1016' LIMIT 0,1

349. 0.0001

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

350. 0.0002

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

351. 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='950' LIMIT 0,1

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

353. 0.0003

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

354. 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='1016' LIMIT 0,1

355. 0.0001

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

356. 0.0003

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

357. 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='950' LIMIT 0,1

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

359. 0.0002

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

360. 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='1070' LIMIT 0,1

361. 0.0002

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

362. 0.0002

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

363. 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='950' LIMIT 0,1

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

365. 0.0002

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

366. 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='950' LIMIT 0,1

367. 0.0001

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

368. 0.0002

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

369. 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='950' LIMIT 0,1

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

371. 0.0002

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

372. 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='950' LIMIT 0,1

373. 0.0001

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

374. 0.0002

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

375. 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='1016' LIMIT 0,1

376. 0.0004

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

377. 0.0003

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

378. 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='1016' LIMIT 0,1

379. 0.0002

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

380. 0.0003

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

381. 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='950' LIMIT 0,1

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

383. 0.0003

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

384. 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='951' LIMIT 0,1

385. 0.0002

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

386. 0.0003

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

387. 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='950' LIMIT 0,1

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

389. 0.0003

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

390. 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='951' LIMIT 0,1

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

392. 0.0003

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

393. 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='950' LIMIT 0,1

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

395. 0.0003

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

396. 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='950' LIMIT 0,1

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

398. 0.0003

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

399. 0.0002

     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='951' LIMIT 0,1

400. 0.0002

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

401. 0.0003

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

402. 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='950' LIMIT 0,1

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

404. 0.0003

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

405. 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='950' LIMIT 0,1

406. 0.0002

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

407. 0.0002

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

408. 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='950' LIMIT 0,1

409. 0.0001

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

410. 0.0002

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

411. 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='1016' LIMIT 0,1

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

413. 0.0002

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

414. 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='950' LIMIT 0,1

415. 0.0001

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

416. 0.0002

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

417. 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='950' LIMIT 0,1

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

419. 0.0002

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

420. 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='1149' LIMIT 0,1

421. 0.0001

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

422. 0.0003

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

423. 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='950' LIMIT 0,1

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

425. 0.0002

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

426. 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='950' LIMIT 0,1

427. 0.0001

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

428. 0.0002

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

429. 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='950' LIMIT 0,1

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

431. 0.0002

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

432. 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='1016' LIMIT 0,1

433. 0.0001

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

434. 0.0002

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

435. 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='950' LIMIT 0,1

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

437. 0.0002

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

438. 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='951' LIMIT 0,1

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

440. 0.0002

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

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

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

443. 0.0001

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

444. 0.001

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

445. 0

     SELECT count(*) as nbwish FROM wish

446. 0.0641

     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

446 requetes sql en 0.3131