Service multi services à 94320 Thiais

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='bricolage'

2. 0

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='94'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='94320' AND ville_nom like '%thiais%' 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 '%multi%services%' OR ssrubr_title like '%multi%services%' OR ssrubr_slug like '%multi%services%') AND cate_id='50' 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='94320'

7. 0.002

   SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.586835678816 AND ville_latitude_deg<48.946564321184 AND ville_longitude_deg>2.1104467581343 AND ville_longitude_deg<2.6562132418657 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='multi services'

9. 0.0018

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

10. 0.0001

    SELECT * FROM texte WHERE cate_id=50

11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='multi services' OR ssrubr_slug='multi-services' OR (ssrubr_title like '%multi services%')) AND cate_id='50' 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 (50) ORDER BY ssrubr_order ASC

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='multi-services' AND cate_id='50'

16. 0.0001

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

17. 0.0018

    SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.586835678816 AND ville_latitude_deg<48.946564321184 AND ville_longitude_deg>2.1104467581343 AND ville_longitude_deg<2.6562132418657 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0056

    SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.317039197041 AND ville_latitude_deg<49.216360802959 AND ville_longitude_deg>1.7011160125509 AND ville_longitude_deg<3.0655439874491 HAVING distance <= 50 ORDER BY distance ASC

19. 0.1053

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='50' AND MATCH (wish_desc) AGAINST ('(+multi +services*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94320,94320,94400,94390,94310,94550,94600,94150,94800,94232,94240,94230,94233,94231,94234,94235,94236,94238,94239,94237,94140,94290,92340,94110,94700,91320,94260,94200,94205,94270,91200,91550,94480,94220,94190,94000,94460,92160,94250,92220,94380,91560,92120,92260,92330,94160,91270,94410,92320,91300,94450,94340,92240,91420,92290,91370,92350,91230,91260,92140,94100,94340,94210,91210,92170,91160,91380,94470,94300,92130,91330,94130,94430,75006,75004,75007,75005,75003,75010,75009,75012,75018,75017,75020,75016,75015,75011,75014,75013,75019,75001,75008,75000,75002,75116,94370,94380,91170,94500,91120,91160,91800,92360,92190,91390,93170,91600,93100,91360,94120,91360,94360,92100,91140,94440,94880,94490,94880,91570,94170,91160,91430,94440,91350,93310,91000,91130,93110,91160,93230,93260,91860,91450,92370,91430,94350,94520,94520,93130,91700,93330,91800,91140,92310,94420,94440,94510,92210,93360,93500,91700,78140,93400,91700,92410,92200,93250,91620,93000,91000,91090,92800,92150,91480,77170,78350,93140,92110,91450,91240,91480,78220,91400,93160,91400,92300,91310,77340,93300,91070,93120,91080,92380,92430,92420,93220,91620,91250,91310,91310,91220,91220,92400,93460,77380,77150,91440,92600,92250,93320,93340,77184,91250,78350,78530,77420,91940,91460,93210,93200,77185,92500,93350,78000,91090,77150,92270,91280,92390,93450,93150,93700,91190,77127,92700,91310,91940,78170,77170,92230,78117,77680,91100,93370,92000,78150)

20. 0.0925

    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.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- 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='50' AND MATCH (wish_desc) AGAINST ('(+multi +services*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94320,94320,94400,94390,94310,94550,94600,94150,94800,94232,94240,94230,94233,94231,94234,94235,94236,94238,94239,94237,94140,94290,92340,94110,94700,91320,94260,94200,94205,94270,91200,91550,94480,94220,94190,94000,94460,92160,94250,92220,94380,91560,92120,92260,92330,94160,91270,94410,92320,91300,94450,94340,92240,91420,92290,91370,92350,91230,91260,92140,94100,94340,94210,91210,92170,91160,91380,94470,94300,92130,91330,94130,94430,75006,75004,75007,75005,75003,75010,75009,75012,75018,75017,75020,75016,75015,75011,75014,75013,75019,75001,75008,75000,75002,75116,94370,94380,91170,94500,91120,91160,91800,92360,92190,91390,93170,91600,93100,91360,94120,91360,94360,92100,91140,94440,94880,94490,94880,91570,94170,91160,91430,94440,91350,93310,91000,91130,93110,91160,93230,93260,91860,91450,92370,91430,94350,94520,94520,93130,91700,93330,91800,91140,92310,94420,94440,94510,92210,93360,93500,91700,78140,93400,91700,92410,92200,93250,91620,93000,91000,91090,92800,92150,91480,77170,78350,93140,92110,91450,91240,91480,78220,91400,93160,91400,92300,91310,77340,93300,91070,93120,91080,92380,92430,92420,93220,91620,91250,91310,91310,91220,91220,92400,93460,77380,77150,91440,92600,92250,93320,93340,77184,91250,78350,78530,77420,91940,91460,93210,93200,77185,92500,93350,78000,91090,77150,92270,91280,92390,93450,93150,93700,91190,77127,92700,91310,91940,78170,77170,92230,78117,77680,91100,93370,92000,78150) 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='94320'

22. 0.0026

    SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.586835678816 AND ville_latitude_deg<48.946564321184 AND ville_longitude_deg>2.1104467581343 AND ville_longitude_deg<2.6562132418657 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0081

    SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.317039197041 AND ville_latitude_deg<49.216360802959 AND ville_longitude_deg>1.7011160125509 AND ville_longitude_deg<3.0655439874491 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 = 10395 AND W.type_id = 1) OR (W.util_id != 10395 AND W.type_id = 2)) AND (`post_util_id` = 10395 OR `dest_util_id` = 10395) 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=10395 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 = 14980 AND W.type_id = 1) OR (W.util_id != 14980 AND W.type_id = 2)) AND (`post_util_id` = 14980 OR `dest_util_id` = 14980) 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=14980 AND note_visu IN (1,3,4)

28. 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 = 17717 AND W.type_id = 1) OR (W.util_id != 17717 AND W.type_id = 2)) AND (`post_util_id` = 17717 OR `dest_util_id` = 17717) 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=17717 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 = 19824 AND W.type_id = 1) OR (W.util_id != 19824 AND W.type_id = 2)) AND (`post_util_id` = 19824 OR `dest_util_id` = 19824) 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=19824 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 = 4399 AND W.type_id = 1) OR (W.util_id != 4399 AND W.type_id = 2)) AND (`post_util_id` = 4399 OR `dest_util_id` = 4399) 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=4399 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 = 32657 AND W.type_id = 1) OR (W.util_id != 32657 AND W.type_id = 2)) AND (`post_util_id` = 32657 OR `dest_util_id` = 32657) 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=32657 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 = 34614 AND W.type_id = 1) OR (W.util_id != 34614 AND W.type_id = 2)) AND (`post_util_id` = 34614 OR `dest_util_id` = 34614) 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=34614 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 = 24274 AND W.type_id = 1) OR (W.util_id != 24274 AND W.type_id = 2)) AND (`post_util_id` = 24274 OR `dest_util_id` = 24274) 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=24274 AND note_visu IN (1,3,4)

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

42. 0.0001

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

46. 0.0001

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

47. 0.0001

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

48. 0.0001

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

49. 0.0001

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

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

51. 0.0001

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

52. 0.0001

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

53. 0.0001

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

54. 0.0001

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

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

82. 0.0001

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

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

90. 0.0001

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

93. 0.0001

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

94. 0.0001

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

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

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

106. 0.0001

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

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

114. 0.0002

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

124. 0.0002

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

132. 0.0001

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

139. 0.0001

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

140. 0.0001

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

141. 0.0001

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

142. 0.0001

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

143. 0.0001

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

144. 0.0001

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

145. 0.0001

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

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

153. 0.0001

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

154. 0.0001

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

155. 0.0001

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

156. 0.0001

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

157. 0.0001

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

158. 0.0001

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

159. 0.0001

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

160. 0.0001

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

161. 0.0001

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

162. 0.0001

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

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

174. 0.0001

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

175. 0.0001

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

176. 0.0001

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

177. 0.0001

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

178. 0.0001

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

179. 0.0001

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

180. 0.0001

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

181. 0.0001

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

182. 0.0001

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

183. 0.0001

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

184. 0.0001

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

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

186. 0.0001

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

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

188. 0.0001

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

189. 0.0001

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

190. 0.0001

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

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

197. 0.0001

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

200. 0.0001

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

201. 0.0001

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

202. 0.0001

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

203. 0.0001

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

204. 0.0001

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

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

211. 0.0001

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

213. 0.0001

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

215. 0.0001

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

220. 0.0001

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

221. 0.0001

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

222. 0.0001

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

223. 0.0001

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

224. 0.0001

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

225. 0.0001

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

226. 0.0001

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

227. 0.0001

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

228. 0.0001

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

229. 0.0001

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

230. 0.0001

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

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

237. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 208064 AND W.type_id = 1) OR (W.util_id != 208064 AND W.type_id = 2)) AND (`post_util_id` = 208064 OR `dest_util_id` = 208064) 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=208064 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 = 272435 AND W.type_id = 1) OR (W.util_id != 272435 AND W.type_id = 2)) AND (`post_util_id` = 272435 OR `dest_util_id` = 272435) 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=272435 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 = 274463 AND W.type_id = 1) OR (W.util_id != 274463 AND W.type_id = 2)) AND (`post_util_id` = 274463 OR `dest_util_id` = 274463) 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=274463 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 = 274478 AND W.type_id = 1) OR (W.util_id != 274478 AND W.type_id = 2)) AND (`post_util_id` = 274478 OR `dest_util_id` = 274478) 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=274478 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 = 147429 AND W.type_id = 1) OR (W.util_id != 147429 AND W.type_id = 2)) AND (`post_util_id` = 147429 OR `dest_util_id` = 147429) 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=147429 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 = 12341 AND W.type_id = 1) OR (W.util_id != 12341 AND W.type_id = 2)) AND (`post_util_id` = 12341 OR `dest_util_id` = 12341) 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=12341 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 = 282391 AND W.type_id = 1) OR (W.util_id != 282391 AND W.type_id = 2)) AND (`post_util_id` = 282391 OR `dest_util_id` = 282391) 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=282391 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 = 282491 AND W.type_id = 1) OR (W.util_id != 282491 AND W.type_id = 2)) AND (`post_util_id` = 282491 OR `dest_util_id` = 282491) 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=282491 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 = 283213 AND W.type_id = 1) OR (W.util_id != 283213 AND W.type_id = 2)) AND (`post_util_id` = 283213 OR `dest_util_id` = 283213) 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=283213 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 = 270052 AND W.type_id = 1) OR (W.util_id != 270052 AND W.type_id = 2)) AND (`post_util_id` = 270052 OR `dest_util_id` = 270052) 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=270052 AND note_visu IN (1,3,4)

257. 0.0001

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

259. 0.0001

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

264. 0.0001

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

265. 0.0001

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

266. 0.0001

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

267. 0.0001

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

268. 0.0001

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

269. 0.0001

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

270. 0.0001

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

271. 0.0001

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

272. 0.0001

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

273. 0.0001

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

274. 0.0001

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

275. 0.0001

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

276. 0.0001

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

277. 0.0001

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

278. 0.0001

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

279. 0.0001

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

280. 0.0001

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

281. 0.0001

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

282. 0.0002

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

283. 0.0001

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

284. 0.0001

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

285. 0.0001

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

286. 0.0001

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

287. 0.0001

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

288. 0.0001

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

289. 0.0001

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

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

292. 0.0001

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

296. 0.0001

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

298. 0.0001

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

299. 0.0001

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

300. 0.0001

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

301. 0.0001

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

302. 0.0001

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

303. 0.0001

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

304. 0.0001

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

305. 0.0001

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

306. 0.0001

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

314. 0.0001

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

323. 0.0001

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

324. 0.0001

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

325. 0.0001

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

326. 0.0001

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

327. 0.0001

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

328. 0.0001

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

329. 0.0001

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

330. 0.0001

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

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

332. 0.0001

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

333. 0.0001

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

334. 0.0001

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

335. 0.0001

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

336. 0.0001

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

337. 0.0003

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

338. 0.0001

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

339. 0.0001

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

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

341. 0.0001

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

342. 0.0001

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

343. 0.0001

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

344. 0.0001

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

345. 0.0001

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

346. 0.0001

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

347. 0.0001

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

348. 0.0001

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

349. 0.0001

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

350. 0.0001

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

351. 0.0001

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

352. 0.0002

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

353. 0.0001

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

354. 0.0001

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

355. 0.0001

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

356. 0.0001

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

357. 0.0001

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

358. 0.0001

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

359. 0.0001

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

360. 0.0001

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

361. 0.0001

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

362. 0.0001

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

363. 0.0001

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

364. 0.0001

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

365. 0.0001

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

366. 0.0001

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

367. 0.0001

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

368. 0.0001

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

369. 0.0001

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

370. 0.0001

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

371. 0.0001

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

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

373. 0.0001

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

374. 0.0001

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

375. 0.0001

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

376. 0.0001

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

377. 0.0001

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

378. 0.0001

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

379. 0.0001

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

380. 0.0001

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

381. 0.0001

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

382. 0.0001

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

383. 0.0001

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

384. 0.0001

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

385. 0.0001

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

386. 0.0001

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

387. 0.0001

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

388. 0.0001

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

389. 0.0001

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

390. 0.0001

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

391. 0.0001

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

392. 0.0001

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

393. 0.0002

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

394. 0.0001

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

395. 0.0001

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

396. 0.0001

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

397. 0.0001

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

398. 0.0001

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

399. 0.0001

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

400. 0.0001

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

401. 0.0001

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

402. 0.0001

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

403. 0.0001

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

404. 0.0001

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

405. 0.0001

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

406. 0.0001

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

407. 0.0001

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

408. 0.0001

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

409. 0.0001

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

410. 0.0001

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

411. 0.0001

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

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

413. 0.0001

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

414. 0.0001

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

415. 0.0001

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

416. 0.0001

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

417. 0.0001

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

418. 0.0001

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

419. 0.0001

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

420. 0.0003

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

421. 0.0001

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

422. 0.0001

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

423. 0.0001

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

424. 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='595' LIMIT 0,1

425. 0.0001

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

426. 0.0003

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

427. 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='595' LIMIT 0,1

428. 0.0001

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

429. 0.0002

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

430. 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='595' LIMIT 0,1

431. 0.0001

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

432. 0.0001

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

433. 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='595' LIMIT 0,1

434. 0.0001

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

435. 0.0001

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

436. 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='595' LIMIT 0,1

437. 0.0001

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

438. 0.0002

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

439. 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='595' LIMIT 0,1

440. 0.0001

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

441. 0.0001

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

442. 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='595' LIMIT 0,1

443. 0.0001

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

444. 0.0001

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

445. 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='595' LIMIT 0,1

446. 0.0001

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

447. 0.0001

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

448. 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='595' LIMIT 0,1

449. 0.0001

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

450. 0.0002

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

451. 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='595' LIMIT 0,1

452. 0.0001

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

453. 0.0002

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

454. 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='595' LIMIT 0,1

455. 0.0001

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

456. 0.0002

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

457. 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='600' LIMIT 0,1

458. 0.0001

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

459. 0.0002

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

460. 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='595' LIMIT 0,1

461. 0.0001

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

462. 0.0001

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

463. 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='595' LIMIT 0,1

464. 0.0001

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

465. 0.0001

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

466. 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='595' LIMIT 0,1

467. 0.0001

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

468. 0.0001

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

469. 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='595' LIMIT 0,1

470. 0.0001

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

471. 0.0002

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

472. 0.0001

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

473. 0.0002

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

474. 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='595' LIMIT 0,1

475. 0.0001

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

476. 0.0002

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

477. 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='595' LIMIT 0,1

478. 0.0001

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

479. 0.0002

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

480. 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='595' LIMIT 0,1

481. 0.0001

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

482. 0.0002

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

483. 0.0001

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

484. 0.0001

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

485. 0.0002

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

486. 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='595' LIMIT 0,1

487. 0.0001

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

488. 0.0001

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

489. 0.0001

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

490. 0.0001

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

491. 0.0001

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

492. 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='595' LIMIT 0,1

493. 0.0001

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

494. 0.0002

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

495. 0.0001

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

496. 0.0001

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

497. 0.0002

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

498. 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='595' LIMIT 0,1

499. 0.0001

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

500. 0.0003

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

501. 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='595' LIMIT 0,1

502. 0.0001

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

503. 0.0002

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

504. 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='595' LIMIT 0,1

505. 0.0001

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

506. 0.0002

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

507. 0.0001

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

508. 0.0001

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

509. 0.0002

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

510. 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='595' LIMIT 0,1

511. 0.0002

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

512. 0.0003

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

513. 0.0002

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

514. 0.0001

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

515. 0.001

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

516. 0

     SELECT count(*) as nbwish FROM wish

517. 0.0721

     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

517 requetes sql en 0.34859999999999