Service plat maison à 94470 Boissy-saint-léger

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='repas-fait-maison'

2. 0

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

3. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='94'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='94470' AND ville_nom like '%boissy%saint%leger%' 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 '%plat%seul%' OR ssrubr_title like '%plat%seul%' OR ssrubr_slug like '%plat%seul%') AND cate_id='80' 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='94470'

7. 0.0023

   SELECT ville_cp, ROUND((((acos(sin((48.75*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.75*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.570135678816 AND ville_latitude_deg<48.929864321184 AND ville_longitude_deg>2.2438774646036 AND ville_longitude_deg<2.7894625353964 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='plat'

9. 0.0004

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

10. 0.0001

    SELECT * FROM texte WHERE cate_id=80

11. 0.0002

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

16. 0.0002

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

17. 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 (231) ORDER BY ssrubr_order ASC

18. 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 (47) ORDER BY ssrubr_order ASC

19. 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 (42) ORDER BY ssrubr_order ASC

20. 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 (37) ORDER BY ssrubr_order ASC

21. 0.0002

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

22. 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 (39) ORDER BY ssrubr_order ASC

23. 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 (229) ORDER BY ssrubr_order ASC

24. 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 (230) ORDER BY ssrubr_order ASC

25. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='plat-seul' AND cate_id='80'

26. 0.0001

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

27. 0.0025

    SELECT ville_cp, ROUND((((acos(sin((48.75*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.75*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.570135678816 AND ville_latitude_deg<48.929864321184 AND ville_longitude_deg>2.2438774646036 AND ville_longitude_deg<2.7894625353964 HAVING distance <= 20 ORDER BY distance ASC

28. 0.0074

    SELECT ville_cp, ROUND((((acos(sin((48.75*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.75*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.300339197041 AND ville_latitude_deg<49.199660802959 AND ville_longitude_deg>1.8346827806797 AND ville_longitude_deg<3.1986572193203 HAVING distance <= 50 ORDER BY distance ASC

29. 0.024

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='80' AND MATCH (wish_desc) AGAINST ('(+plat*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94470,94470,94370,94380,94380,94450,94440,94460,91330,94440,94880,94490,94880,94000,94440,94190,94430,94210,94340,91800,94100,94520,94520,91560,94510,77170,91230,91860,94500,91800,94600,94290,77150,94480,94700,94340,94420,77340,94390,94310,94410,91480,77150,94140,91270,94360,91200,94400,91480,94350,94130,94320,77380,77184,94220,91210,77170,77330,93330,94170,77680,94120,77173,91550,93160,77185,94160,91450,94150,94200,94205,91260,94800,94550,94300,77420,93360,91250,77127,93110,94270,77166,91130,91000,91170,93460,91450,91320,77166,91000,91090,94230,94238,94237,94236,94231,94235,94233,94239,94240,94232,94234,77186,93100,77183,77090,77135,94110,91420,94260,77200,91350,93220,93250,91280,93170,92340,91250,93130,91600,94250,91390,92160,77164,77220,93230,77500,77550,93260,77360,77170,91360,92120,77600,77111,93320,93340,91250,92220,91380,91160,91100,91700,93140,93370,77177,93310,91080,91300,91360,93000,77600,77600,92330,92260,77220,92240,75005,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75019,75020,75018,75007,75006,75116,75001,75000,75002,75003,75004,91070,77400,92320,77550,91090,91370,92170,77111,77220,92290,77550,77390,77400,93190,92350,91700,93390,93500,77600,77176,92140,91160,77220,93470,77181,91100,77400,77550,91700,77600,91160,77400,77220,92130,91160,91120,77181)

30. 0.0263

    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.75*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.75*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- 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='80' AND MATCH (wish_desc) AGAINST ('(+plat*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94470,94470,94370,94380,94380,94450,94440,94460,91330,94440,94880,94490,94880,94000,94440,94190,94430,94210,94340,91800,94100,94520,94520,91560,94510,77170,91230,91860,94500,91800,94600,94290,77150,94480,94700,94340,94420,77340,94390,94310,94410,91480,77150,94140,91270,94360,91200,94400,91480,94350,94130,94320,77380,77184,94220,91210,77170,77330,93330,94170,77680,94120,77173,91550,93160,77185,94160,91450,94150,94200,94205,91260,94800,94550,94300,77420,93360,91250,77127,93110,94270,77166,91130,91000,91170,93460,91450,91320,77166,91000,91090,94230,94238,94237,94236,94231,94235,94233,94239,94240,94232,94234,77186,93100,77183,77090,77135,94110,91420,94260,77200,91350,93220,93250,91280,93170,92340,91250,93130,91600,94250,91390,92160,77164,77220,93230,77500,77550,93260,77360,77170,91360,92120,77600,77111,93320,93340,91250,92220,91380,91160,91100,91700,93140,93370,77177,93310,91080,91300,91360,93000,77600,77600,92330,92260,77220,92240,75005,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75019,75020,75018,75007,75006,75116,75001,75000,75002,75003,75004,91070,77400,92320,77550,91090,91370,92170,77111,77220,92290,77550,77390,77400,93190,92350,91700,93390,93500,77600,77176,92140,91160,77220,93470,77181,91100,77400,77550,91700,77600,91160,77400,77220,92130,91160,91120,77181) AND type_id=1 GROUP BY wish_id

31. 0.0001

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

32. 0.0018

    SELECT ville_cp, ROUND((((acos(sin((48.75*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.75*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.570135678816 AND ville_latitude_deg<48.929864321184 AND ville_longitude_deg>2.2438774646036 AND ville_longitude_deg<2.7894625353964 HAVING distance <= 20 ORDER BY distance ASC

33. 0.0067

    SELECT ville_cp, ROUND((((acos(sin((48.75*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.75*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.300339197041 AND ville_latitude_deg<49.199660802959 AND ville_longitude_deg>1.8346827806797 AND ville_longitude_deg<3.1986572193203 HAVING distance <= 50 ORDER BY distance ASC

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

40. 0.0001

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

50. 0.0001

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

59. 0.0001

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

60. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 27597 AND W.type_id = 1) OR (W.util_id != 27597 AND W.type_id = 2)) AND (`post_util_id` = 27597 OR `dest_util_id` = 27597) 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=27597 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 = 31367 AND W.type_id = 1) OR (W.util_id != 31367 AND W.type_id = 2)) AND (`post_util_id` = 31367 OR `dest_util_id` = 31367) 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=31367 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 = 32064 AND W.type_id = 1) OR (W.util_id != 32064 AND W.type_id = 2)) AND (`post_util_id` = 32064 OR `dest_util_id` = 32064) 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=32064 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 = 33300 AND W.type_id = 1) OR (W.util_id != 33300 AND W.type_id = 2)) AND (`post_util_id` = 33300 OR `dest_util_id` = 33300) 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=33300 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 = 39336 AND W.type_id = 1) OR (W.util_id != 39336 AND W.type_id = 2)) AND (`post_util_id` = 39336 OR `dest_util_id` = 39336) 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=39336 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 = 43971 AND W.type_id = 1) OR (W.util_id != 43971 AND W.type_id = 2)) AND (`post_util_id` = 43971 OR `dest_util_id` = 43971) 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=43971 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 = 49407 AND W.type_id = 1) OR (W.util_id != 49407 AND W.type_id = 2)) AND (`post_util_id` = 49407 OR `dest_util_id` = 49407) 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=49407 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 = 49641 AND W.type_id = 1) OR (W.util_id != 49641 AND W.type_id = 2)) AND (`post_util_id` = 49641 OR `dest_util_id` = 49641) 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=49641 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 = 41072 AND W.type_id = 1) OR (W.util_id != 41072 AND W.type_id = 2)) AND (`post_util_id` = 41072 OR `dest_util_id` = 41072) 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=41072 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 = 50806 AND W.type_id = 1) OR (W.util_id != 50806 AND W.type_id = 2)) AND (`post_util_id` = 50806 OR `dest_util_id` = 50806) 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=50806 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 = 51963 AND W.type_id = 1) OR (W.util_id != 51963 AND W.type_id = 2)) AND (`post_util_id` = 51963 OR `dest_util_id` = 51963) 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=51963 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 = 53323 AND W.type_id = 1) OR (W.util_id != 53323 AND W.type_id = 2)) AND (`post_util_id` = 53323 OR `dest_util_id` = 53323) 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=53323 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 = 55793 AND W.type_id = 1) OR (W.util_id != 55793 AND W.type_id = 2)) AND (`post_util_id` = 55793 OR `dest_util_id` = 55793) 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=55793 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 = 55889 AND W.type_id = 1) OR (W.util_id != 55889 AND W.type_id = 2)) AND (`post_util_id` = 55889 OR `dest_util_id` = 55889) 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=55889 AND note_visu IN (1,3,4)

88. 0.0001

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

91. 0.0001

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

92. 0.0001

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

93. 0.0001

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

94. 0.0001

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

95. 0.0001

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

96. 0.0001

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

100. 0.0001

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

101. 0.0001

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

102. 0.0001

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

103. 0.0001

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

104. 0.0001

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

105. 0.0001

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

106. 0.0001

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

114. 0.0001

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

124. 0.0001

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

138. 0.0001

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

146. 0.0001

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

147. 0.0001

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

148. 0.0001

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

149. 0.0001

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

150. 0.0001

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

151. 0.0001

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

152. 0.0001

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

153. 0.0001

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

154. 0.0001

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

155. 0.0001

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

156. 0.0001

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

157. 0.0001

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

158. 0.0001

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

159. 0.0001

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

160. 0.0001

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

161. 0.0001

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

162. 0.0001

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

163. 0.0001

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

182. 0.0001

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

183. 0.0001

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

184. 0.0001

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

185. 0.0001

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

186. 0.0001

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

187. 0.0001

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

188. 0.0001

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

189. 0.0001

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

190. 0.0001

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

191. 0.0001

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

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

193. 0.0001

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

194. 0.0001

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

195. 0.0001

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

196. 0.0001

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

197. 0.0001

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

198. 0.0002

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

199. 0.0001

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

200. 0.0001

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

205. 0.0001

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

206. 0.0001

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

207. 0.0001

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

208. 0.0001

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

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

218. 0.0001

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

219. 0.0001

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

220. 0.0001

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

221. 0.0001

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

222. 0.0001

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

223. 0.0001

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

224. 0.0001

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

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 = 101004 AND W.type_id = 1) OR (W.util_id != 101004 AND W.type_id = 2)) AND (`post_util_id` = 101004 OR `dest_util_id` = 101004) 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=101004 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 = 102566 AND W.type_id = 1) OR (W.util_id != 102566 AND W.type_id = 2)) AND (`post_util_id` = 102566 OR `dest_util_id` = 102566) 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=102566 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 = 105312 AND W.type_id = 1) OR (W.util_id != 105312 AND W.type_id = 2)) AND (`post_util_id` = 105312 OR `dest_util_id` = 105312) 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=105312 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 = 106218 AND W.type_id = 1) OR (W.util_id != 106218 AND W.type_id = 2)) AND (`post_util_id` = 106218 OR `dest_util_id` = 106218) 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=106218 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 = 107284 AND W.type_id = 1) OR (W.util_id != 107284 AND W.type_id = 2)) AND (`post_util_id` = 107284 OR `dest_util_id` = 107284) 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=107284 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 = 107982 AND W.type_id = 1) OR (W.util_id != 107982 AND W.type_id = 2)) AND (`post_util_id` = 107982 OR `dest_util_id` = 107982) 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=107982 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 = 109573 AND W.type_id = 1) OR (W.util_id != 109573 AND W.type_id = 2)) AND (`post_util_id` = 109573 OR `dest_util_id` = 109573) 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=109573 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 = 112036 AND W.type_id = 1) OR (W.util_id != 112036 AND W.type_id = 2)) AND (`post_util_id` = 112036 OR `dest_util_id` = 112036) 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=112036 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 = 112036 AND W.type_id = 1) OR (W.util_id != 112036 AND W.type_id = 2)) AND (`post_util_id` = 112036 OR `dest_util_id` = 112036) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

242. 0.0001

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

243. 0.0001

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

244. 0.0001

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

245. 0.0001

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

246. 0.0001

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

247. 0.0001

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

248. 0.0001

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

249. 0.0001

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

250. 0.0001

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

251. 0.0001

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

252. 0.0001

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

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

262. 0.0001

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

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

265. 0.0001

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

266. 0.0001

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

267. 0.0001

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

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

273. 0.0001

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

274. 0.0001

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

275. 0.0001

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

276. 0.0001

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

277. 0.0001

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

278. 0.0001

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

279. 0.0001

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

280. 0.0001

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

281. 0.0001

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

282. 0.0001

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

302. 0.0001

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

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

304. 0.0001

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

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

306. 0.0001

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

307. 0.0001

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

308. 0.0001

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

309. 0.0001

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

310. 0.0001

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

311. 0.0001

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

312. 0.0001

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

313. 0.0001

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

314. 0.0001

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

315. 0.0001

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

316. 0.0001

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

317. 0.0001

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

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

323. 0.0001

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

324. 0.0001

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

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

336. 0.0001

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

337. 0.0001

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

338. 0.0001

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

339. 0.0001

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

340. 0.0001

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

352. 0.0001

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

359. 0.0001

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

360. 0.0001

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

361. 0.0001

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

362. 0.0001

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

363. 0.0001

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

364. 0.0001

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

365. 0.0001

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

370. 0.0001

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

371. 0.0001

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

372. 0.0001

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

375. 0.0001

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

376. 0.0001

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

377. 0.0001

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

378. 0.0001

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

379. 0.0001

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

380. 0.0001

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

381. 0.0001

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

386. 0.0001

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

387. 0.0001

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

388. 0.0001

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

389. 0.0001

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

390. 0.0001

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

391. 0.0001

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

393. 0.0001

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

406. 0.0001

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

407. 0.0001

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

408. 0.0001

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

409. 0.0001

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

410. 0.0001

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

411. 0.0001

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

412. 0.0001

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

415. 0.0001

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

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

419. 0.0001

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

420. 0.0001

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

424. 0.0001

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

425. 0.0001

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

426. 0.0001

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

427. 0.0001

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

428. 0.0001

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

429. 0.0001

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

430. 0.0001

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

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

432. 0.0001

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

433. 0.0001

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

434. 0.0001

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

435. 0.0001

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

436. 0.0001

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

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

438. 0.0001

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

439. 0.0001

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

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

441. 0.0001

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

442. 0.0001

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

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

444. 0.0001

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

445. 0.0001

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

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

447. 0.0001

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

448. 0.0001

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

449. 0.0001

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

450. 0.0001

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

451. 0.0001

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

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

453. 0.0001

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

454. 0.0001

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

455. 0.0001

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

456. 0.0001

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

457. 0.0001

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

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

459. 0.0001

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

460. 0.0001

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

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

462. 0.0001

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

463. 0.0001

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

464. 0.0001

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

465. 0.0001

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

466. 0.0001

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

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

468. 0.0001

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

469. 0.0001

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

470. 0.0001

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

471. 0.0001

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

472. 0.0001

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

473. 0.0001

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

474. 0.0001

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

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

476. 0.0001

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

477. 0.0001

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

478. 0.0001

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

479. 0.0001

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

480. 0.0001

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

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

482. 0.0001

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

483. 0.0001

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

484. 0.0001

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

485. 0.0001

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

486. 0.0001

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

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

488. 0.0001

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

489. 0.0001

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

490. 0.0001

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

491. 0.0001

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

492. 0.0001

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

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

494. 0.0001

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

495. 0.0001

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

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

497. 0.0001

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

498. 0.0001

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

499. 0.0001

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

500. 0.0001

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

501. 0.0001

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

502. 0.0001

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

503. 0.0001

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

504. 0.0001

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

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

506. 0.0001

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

507. 0.0001

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

508. 0.0001

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

509. 0.0001

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

510. 0.0001

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

511. 0.0001

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

512. 0.0001

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

513. 0.0001

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

514. 0.0001

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

515. 0.0001

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

516. 0.0001

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

517. 0.0001

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

518. 0.0001

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

519. 0.0001

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

520. 0.0001

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

521. 0.0001

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

522. 0.0001

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

523. 0.0001

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

524. 0.0001

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

525. 0.0001

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

526. 0.0001

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

527. 0.0001

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

528. 0.0001

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

529. 0.0001

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

530. 0.0001

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

531. 0.0001

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

532. 0.0001

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

533. 0.0001

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

534. 0.0001

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

535. 0.0001

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

536. 0.0001

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

537. 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='1104' LIMIT 0,1

538. 0.0001

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

539. 0.0002

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

540. 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='1104' LIMIT 0,1

541. 0.0001

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

542. 0.0001

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

543. 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='1104' LIMIT 0,1

544. 0.0001

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

545. 0.0001

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

546. 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='1104' LIMIT 0,1

547. 0.0001

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

548. 0.0001

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

549. 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='1104' LIMIT 0,1

550. 0.0001

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

551. 0.0001

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

552. 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='984' LIMIT 0,1

553. 0.0001

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

554. 0.0002

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

555. 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='1104' LIMIT 0,1

556. 0.0001

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

557. 0.0002

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

558. 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='968' LIMIT 0,1

559. 0.0001

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

560. 0.0002

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

561. 0.0001

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

562. 0.0001

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

563. 0.0002

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

564. 0.0001

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

565. 0.0001

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

566. 0.0002

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

567. 0.0001

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

568. 0.0001

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

569. 0.0002

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

570. 0.0001

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

571. 0.0001

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

572. 0.0002

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

573. 0.0001

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

574. 0.0001

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

575. 0.0002

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

576. 0.0001

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

577. 0.0001

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

578. 0.0002

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

579. 0.0001

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

580. 0.0001

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

581. 0.0002

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

582. 0.0001

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

583. 0.0001

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

584. 0.0002

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

585. 0.0001

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

586. 0.0001

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

587. 0.0002

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

588. 0.0001

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

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

590. 0.0002

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

591. 0.0001

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

592. 0.0001

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

593. 0.0002

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

594. 0.0001

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

595. 0.0001

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

596. 0.0002

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

597. 0.0001

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

598. 0.0001

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

599. 0.0002

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

600. 0.0001

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

601. 0.0001

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

602. 0.0002

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

603. 0.0001

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

604. 0.0001

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

605. 0.0002

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

606. 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='537' LIMIT 0,1

607. 0.0001

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

608. 0.0002

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

609. 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='1104' LIMIT 0,1

610. 0.0001

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

611. 0.0002

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

612. 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='1104' LIMIT 0,1

613. 0.0001

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

614. 0.0002

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

615. 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='1104' LIMIT 0,1

616. 0.0001

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

617. 0.0002

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

618. 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='984' LIMIT 0,1

619. 0.0001

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

620. 0.0002

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

621. 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='984' LIMIT 0,1

622. 0.0001

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

623. 0.0002

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

624. 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='549' LIMIT 0,1

625. 0.0001

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

626. 0.0002

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

627. 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='1103' LIMIT 0,1

628. 0.0001

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

629. 0.0002

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

630. 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='1104' LIMIT 0,1

631. 0.0001

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

632. 0.0002

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

633. 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='984' LIMIT 0,1

634. 0.0001

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

635. 0.0002

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

636. 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='1104' LIMIT 0,1

637. 0.0001

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

638. 0.0002

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

639. 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='1104' LIMIT 0,1

640. 0.0001

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

641. 0.0002

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

642. 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='1104' LIMIT 0,1

643. 0.0001

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

644. 0.0002

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

645. 0.0002

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

646. 0.0001

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

647. 0.0001

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

648. 0.0016

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

649. 0

     SELECT count(*) as nbwish FROM wish

650. 0.06

     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

650 requetes sql en 0.2017