Service nettoyage à 93300 Aubervilliers

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='menage-repassage'

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='93'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='93300' AND ville_nom like '%aubervilliers%' 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 '%nettoyage%' OR ssrubr_title like '%nettoyage%' OR ssrubr_slug like '%nettoyage%') AND cate_id='47' 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='93300'

7. 0.002

   SELECT ville_cp, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.736835678816 AND ville_latitude_deg<49.096564321184 AND ville_longitude_deg>2.109628272488 AND ville_longitude_deg<2.657031727512 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='nettoyage'

9. 0.001

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

10. 0.0001

    SELECT * FROM texte WHERE cate_id=47

11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='nettoyage' OR ssrubr_slug='nettoyage' OR (ssrubr_title like '%nettoyage%')) AND cate_id='47' 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.0001

    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

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='nettoyage' AND cate_id='47'

16. 0.0001

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

17. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.736835678816 AND ville_latitude_deg<49.096564321184 AND ville_longitude_deg>2.109628272488 AND ville_longitude_deg<2.657031727512 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0052

    SELECT ville_cp, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.467039197041 AND ville_latitude_deg<49.366360802959 AND ville_longitude_deg>1.6990697807905 AND ville_longitude_deg<3.0675902192095 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0452

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='47' AND MATCH (wish_desc) AGAINST ('(+nettoyage*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (93300,93120,93300,93500,93210,93200,93350,93240,93310,93450,92390,93400,93440,93260,93700,93230,93150,93000,93430,93380,95360,95140,93170,92230,93140,92110,93800,95500,93100,75020,75006,75005,75004,75116,75017,75003,75002,75000,75001,75010,75012,75007,75019,75016,75015,75014,75013,75018,75011,75009,75008,93130,92600,95880,92300,95410,95400,95170,94300,92270,95500,93110,95210,95218,95400,95200,93250,92200,95350,95230,94160,92700,92400,93340,92250,93320,95160,94120,95100,93600,95580,95500,95580,92170,93270,94200,95440,94205,94270,95110,93360,95120,94170,94220,95350,93220,94250,95720,95500,95600,94130,92120,93390,93190,93420,92800,92150,95870,94410,95190,94340,92240,95460,94800,95720,94140,95130,93330,95680,78800,95700,92100,94360,95330,94110,94700,93410,92000,93370,92500,95390,92130,95130,92220,93460,77181,93470,78420,92210,93290,95320,94500,95720,94400,92320,95570,78500,95570,94235,94236,94239,94240,94234,94238,94237,94233,94232,94231,94230,95240,93160,94350,95380,92140,94210,94340,94100,95190,95530,92360,92190,95570,94000,94430,77500,95370,92340,92260,92330,94320,95720,92380,94600,94550,77181,78360,95850,95560,92350,77270,92410,95190,95560,95250,94420,92310,78600,78400,77420,95840,95560,95150,95380,95550,92420,92430,95380,94380,95220,95380,95270,95570,94390,77290,94310,78170,77177,92370,95270,94150,92290,78600,78290,78380,95850,95560,95380,95740,94260,94880,94880,94490,77990,95480,77185,77410,94460,92160,77990,78140,78110,77186,78560,95590,95840,94370,94380)

20. 0.05

    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.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='47' AND MATCH (wish_desc) AGAINST ('(+nettoyage*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (93300,93120,93300,93500,93210,93200,93350,93240,93310,93450,92390,93400,93440,93260,93700,93230,93150,93000,93430,93380,95360,95140,93170,92230,93140,92110,93800,95500,93100,75020,75006,75005,75004,75116,75017,75003,75002,75000,75001,75010,75012,75007,75019,75016,75015,75014,75013,75018,75011,75009,75008,93130,92600,95880,92300,95410,95400,95170,94300,92270,95500,93110,95210,95218,95400,95200,93250,92200,95350,95230,94160,92700,92400,93340,92250,93320,95160,94120,95100,93600,95580,95500,95580,92170,93270,94200,95440,94205,94270,95110,93360,95120,94170,94220,95350,93220,94250,95720,95500,95600,94130,92120,93390,93190,93420,92800,92150,95870,94410,95190,94340,92240,95460,94800,95720,94140,95130,93330,95680,78800,95700,92100,94360,95330,94110,94700,93410,92000,93370,92500,95390,92130,95130,92220,93460,77181,93470,78420,92210,93290,95320,94500,95720,94400,92320,95570,78500,95570,94235,94236,94239,94240,94234,94238,94237,94233,94232,94231,94230,95240,93160,94350,95380,92140,94210,94340,94100,95190,95530,92360,92190,95570,94000,94430,77500,95370,92340,92260,92330,94320,95720,92380,94600,94550,77181,78360,95850,95560,92350,77270,92410,95190,95560,95250,94420,92310,78600,78400,77420,95840,95560,95150,95380,95550,92420,92430,95380,94380,95220,95380,95270,95570,94390,77290,94310,78170,77177,92370,95270,94150,92290,78600,78290,78380,95850,95560,95380,95740,94260,94880,94880,94490,77990,95480,77185,77410,94460,92160,77990,78140,78110,77186,78560,95590,95840,94370,94380) AND type_id=1 GROUP BY wish_id

21. 0.0001

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

22. 0.0018

    SELECT ville_cp, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.736835678816 AND ville_latitude_deg<49.096564321184 AND ville_longitude_deg>2.109628272488 AND ville_longitude_deg<2.657031727512 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0052

    SELECT ville_cp, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.467039197041 AND ville_latitude_deg<49.366360802959 AND ville_longitude_deg>1.6990697807905 AND ville_longitude_deg<3.0675902192095 HAVING distance <= 50 ORDER BY distance ASC

24. 0.0002

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

25. 0.0001

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

26. 0.0001

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

27. 0.0001

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

28. 0.0001

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

29. 0.0001

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

30. 0.0001

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

31. 0.0001

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

32. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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

33. 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)

34. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 42816 AND W.type_id = 1) OR (W.util_id != 42816 AND W.type_id = 2)) AND (`post_util_id` = 42816 OR `dest_util_id` = 42816) 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=42816 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 = 55012 AND W.type_id = 1) OR (W.util_id != 55012 AND W.type_id = 2)) AND (`post_util_id` = 55012 OR `dest_util_id` = 55012) 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=55012 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 = 55735 AND W.type_id = 1) OR (W.util_id != 55735 AND W.type_id = 2)) AND (`post_util_id` = 55735 OR `dest_util_id` = 55735) 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=55735 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 = 57049 AND W.type_id = 1) OR (W.util_id != 57049 AND W.type_id = 2)) AND (`post_util_id` = 57049 OR `dest_util_id` = 57049) 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=57049 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 = 58017 AND W.type_id = 1) OR (W.util_id != 58017 AND W.type_id = 2)) AND (`post_util_id` = 58017 OR `dest_util_id` = 58017) 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=58017 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 = 58692 AND W.type_id = 1) OR (W.util_id != 58692 AND W.type_id = 2)) AND (`post_util_id` = 58692 OR `dest_util_id` = 58692) 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=58692 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 = 59386 AND W.type_id = 1) OR (W.util_id != 59386 AND W.type_id = 2)) AND (`post_util_id` = 59386 OR `dest_util_id` = 59386) 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=59386 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 = 59960 AND W.type_id = 1) OR (W.util_id != 59960 AND W.type_id = 2)) AND (`post_util_id` = 59960 OR `dest_util_id` = 59960) 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=59960 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 = 61397 AND W.type_id = 1) OR (W.util_id != 61397 AND W.type_id = 2)) AND (`post_util_id` = 61397 OR `dest_util_id` = 61397) 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=61397 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 = 64748 AND W.type_id = 1) OR (W.util_id != 64748 AND W.type_id = 2)) AND (`post_util_id` = 64748 OR `dest_util_id` = 64748) 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=64748 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 = 67304 AND W.type_id = 1) OR (W.util_id != 67304 AND W.type_id = 2)) AND (`post_util_id` = 67304 OR `dest_util_id` = 67304) 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=67304 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 = 70129 AND W.type_id = 1) OR (W.util_id != 70129 AND W.type_id = 2)) AND (`post_util_id` = 70129 OR `dest_util_id` = 70129) 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=70129 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 = 30035 AND W.type_id = 1) OR (W.util_id != 30035 AND W.type_id = 2)) AND (`post_util_id` = 30035 OR `dest_util_id` = 30035) 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=30035 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 = 74842 AND W.type_id = 1) OR (W.util_id != 74842 AND W.type_id = 2)) AND (`post_util_id` = 74842 OR `dest_util_id` = 74842) 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=74842 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 = 79439 AND W.type_id = 1) OR (W.util_id != 79439 AND W.type_id = 2)) AND (`post_util_id` = 79439 OR `dest_util_id` = 79439) 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=79439 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 = 80808 AND W.type_id = 1) OR (W.util_id != 80808 AND W.type_id = 2)) AND (`post_util_id` = 80808 OR `dest_util_id` = 80808) 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=80808 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 = 80808 AND W.type_id = 1) OR (W.util_id != 80808 AND W.type_id = 2)) AND (`post_util_id` = 80808 OR `dest_util_id` = 80808) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

67. 0.0001

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

68. 0.0001

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

69. 0.0001

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

70. 0.0001

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

71. 0.0001

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

72. 0.0001

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

73. 0.0001

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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

80. 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)

81. 0.0001

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

82. 0.0001

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

89. 0.0001

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

90. 0.0001

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

91. 0.0001

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

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

100. 0.0001

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

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

112. 0.0001

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

113. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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

114. 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)

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

120. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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

126. 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)

127. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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

128. 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)

129. 0.0001

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

130. 0.0001

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

131. 0.0001

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

132. 0.0001

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

133. 0.0001

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

134. 0.0001

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

135. 0.0001

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

136. 0.0001

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

137. 0.0001

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

138. 0.0001

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

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 = 186957 AND W.type_id = 1) OR (W.util_id != 186957 AND W.type_id = 2)) AND (`post_util_id` = 186957 OR `dest_util_id` = 186957) 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=186957 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 = 188344 AND W.type_id = 1) OR (W.util_id != 188344 AND W.type_id = 2)) AND (`post_util_id` = 188344 OR `dest_util_id` = 188344) 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=188344 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 = 188820 AND W.type_id = 1) OR (W.util_id != 188820 AND W.type_id = 2)) AND (`post_util_id` = 188820 OR `dest_util_id` = 188820) 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=188820 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 = 191795 AND W.type_id = 1) OR (W.util_id != 191795 AND W.type_id = 2)) AND (`post_util_id` = 191795 OR `dest_util_id` = 191795) 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=191795 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 = 192799 AND W.type_id = 1) OR (W.util_id != 192799 AND W.type_id = 2)) AND (`post_util_id` = 192799 OR `dest_util_id` = 192799) 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=192799 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 = 80731 AND W.type_id = 1) OR (W.util_id != 80731 AND W.type_id = 2)) AND (`post_util_id` = 80731 OR `dest_util_id` = 80731) 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=80731 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 = 197038 AND W.type_id = 1) OR (W.util_id != 197038 AND W.type_id = 2)) AND (`post_util_id` = 197038 OR `dest_util_id` = 197038) 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=197038 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 = 203221 AND W.type_id = 1) OR (W.util_id != 203221 AND W.type_id = 2)) AND (`post_util_id` = 203221 OR `dest_util_id` = 203221) 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=203221 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 = 221751 AND W.type_id = 1) OR (W.util_id != 221751 AND W.type_id = 2)) AND (`post_util_id` = 221751 OR `dest_util_id` = 221751) 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=221751 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 = 220481 AND W.type_id = 1) OR (W.util_id != 220481 AND W.type_id = 2)) AND (`post_util_id` = 220481 OR `dest_util_id` = 220481) 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=220481 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 = 220481 AND W.type_id = 1) OR (W.util_id != 220481 AND W.type_id = 2)) AND (`post_util_id` = 220481 OR `dest_util_id` = 220481) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

160. 0.0001

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

161. 0.0001

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

162. 0.0001

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

163. 0.0001

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

164. 0.0001

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

165. 0.0001

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

166. 0.0001

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

167. 0.0001

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

168. 0.0001

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

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

172. 0.0001

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

173. 0.0001

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

174. 0.0001

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

175. 0.0001

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

176. 0.0001

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

177. 0.0001

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

178. 0.0001

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

179. 0.0001

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

180. 0.0001

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

181. 0.0001

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

182. 0.0001

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

191. 0.0002

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

192. 0.0001

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

193. 0.0001

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

194. 0.0001

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

195. 0.0001

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

196. 0.0001

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

197. 0.0001

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

198. 0.0001

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

199. 0.0001

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

200. 0.0001

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

201. 0.0001

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

202. 0.0001

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

203. 0.0001

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

204. 0.0001

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

205. 0.0001

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

206. 0.0001

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

207. 0.0001

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

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

209. 0.0001

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

210. 0.0001

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

211. 0.0001

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

212. 0.0001

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

213. 0.0001

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

214. 0.0001

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

215. 0.0001

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

216. 0.0001

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

217. 0.0001

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

218. 0.0001

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

223. 0.0001

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

224. 0.0001

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

225. 0.0001

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

236. 0.0001

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

237. 0.0001

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

238. 0.0001

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

239. 0.0001

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

240. 0.0001

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

241. 0.0001

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

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

243. 0.0001

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

244. 0.0001

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

245. 0.0001

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

246. 0.0001

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

247. 0.0001

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

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

251. 0.0001

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

252. 0.0001

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

253. 0.0001

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

258. 0.0001

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

259. 0.0001

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

260. 0.0001

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

261. 0.0001

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

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

263. 0.0001

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

264. 0.0001

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

265. 0.0001

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

266. 0.0001

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

267. 0.0001

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

268. 0.0001

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

269. 0.0001

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

270. 0.0001

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

271. 0.0001

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

272. 0.0001

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

273. 0.0001

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

282. 0.0001

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

283. 0.0001

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

284. 0.0001

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

285. 0.0002

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

286. 0.0001

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

287. 0.0001

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

288. 0.0001

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

289. 0.0001

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

290. 0.0001

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

291. 0.0001

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

292. 0.0001

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

293. 0.0001

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

294. 0.0001

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

295. 0.0001

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

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

299. 0.0001

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

300. 0.0001

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

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

303. 0.0001

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

304. 0.0001

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

305. 0.0001

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

306. 0.0001

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

307. 0.0001

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

308. 0.0001

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

309. 0.0001

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

310. 0.0001

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

311. 0.0001

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

312. 0.0001

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

313. 0.0001

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

314. 0.0001

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

315. 0.0001

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

316. 0.0001

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

317. 0.0001

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

318. 0.0001

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

325. 0.0001

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

326. 0.0001

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

327. 0.0001

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

328. 0.0001

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

329. 0.0001

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

330. 0.0001

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

331. 0.0001

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

332. 0.0001

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

333. 0.0001

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

334. 0.0001

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

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

336. 0.0001

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

337. 0.0001

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

338. 0.0001

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

339. 0.0001

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

340. 0.0001

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

341. 0.0001

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

342. 0.0001

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

343. 0.0001

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

344. 0.0001

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

345. 0.0001

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

346. 0.0001

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

347. 0.0001

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

348. 0.0001

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

349. 0.0001

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

350. 0.0001

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

351. 0.0001

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

352. 0.0001

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

353. 0.0001

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

354. 0.0001

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

355. 0.0001

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

356. 0.0001

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

357. 0.0001

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

358. 0.0001

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

359. 0.0001

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

370. 0.0001

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

371. 0.0001

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

372. 0.0001

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

373. 0.0001

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

374. 0.0001

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

375. 0.0001

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

378. 0.0001

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

379. 0.0001

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

380. 0.0001

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

381. 0.0001

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

386. 0.0001

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

387. 0.0001

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

388. 0.0001

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

389. 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='970' LIMIT 0,1

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

391. 0.0002

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

392. 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='970' LIMIT 0,1

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

394. 0.0001

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

395. 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='970' LIMIT 0,1

396. 0.0001

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

397. 0.0001

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

398. 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='977' LIMIT 0,1

399. 0.0001

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

400. 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='970' LIMIT 0,1

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

402. 0.0001

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

403. 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='937' LIMIT 0,1

404. 0.0001

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

405. 0.0001

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

406. 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='938' LIMIT 0,1

407. 0.0001

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

408. 0.0001

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

409. 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='937' LIMIT 0,1

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

411. 0.0001

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

412. 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='970' LIMIT 0,1

413. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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

414. 0.0001

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

415. 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='977' LIMIT 0,1

416. 0.0001

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

417. 0

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

418. 0.0001

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

419. 0.0001

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

420. 0.0001

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

421. 0.0001

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

422. 0.0001

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

423. 0.0001

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

424. 0.0001

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

425. 0.0001

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

426. 0.0001

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

427. 0.0001

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

428. 0.0001

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

429. 0.0001

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

430. 0.0001

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

431. 0.0001

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

432. 0.0001

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

433. 0.0001

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

434. 0.0001

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

435. 0.0001

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

436. 0.0001

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

437. 0.0001

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

438. 0

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

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

440. 0.0002

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

441. 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='970' LIMIT 0,1

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

443. 0.0002

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

444. 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='970' LIMIT 0,1

445. 0.0001

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

446. 0.0002

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

447. 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='1080' LIMIT 0,1

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

449. 0.0002

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

450. 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='1080' LIMIT 0,1

451. 0.0001

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

452. 0.0002

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

453. 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='1211' LIMIT 0,1

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

455. 0.0002

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

456. 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='977' LIMIT 0,1

457. 0.0001

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

458. 0.0001

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

459. 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='1211' LIMIT 0,1

460. 0.0001

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

461. 0.0001

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

462. 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='937' LIMIT 0,1

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

464. 0.0002

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

465. 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='937' LIMIT 0,1

466. 0.0001

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

467. 0.0001

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

468. 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='977' LIMIT 0,1

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

470. 0.0001

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

471. 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='937' LIMIT 0,1

472. 0.0001

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

473. 0.0001

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

474. 0.0001

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

475. 0.0001

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

476. 0.0001

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

477. 0.0001

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

478. 0.0001

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

479. 0.0001

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

480. 0

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

481. 0.0001

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

482. 0.0001

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

483. 0.0001

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

484. 0.0001

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

485. 0.0002

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

486. 0.0001

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

487. 0.0001

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

488. 0.0002

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

489. 0.0001

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

490. 0.0001

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

491. 0.0001

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

492. 0.0001

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

493. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 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

494. 0.0001

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

495. 0.0001

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

496. 0.0001

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

497. 0.0001

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

498. 0.0001

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

499. 0.0001

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

500. 0.0001

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

501. 0.0001

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

502. 0.0001

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

503. 0.0001

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

504. 0.0001

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

505. 0.0001

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

506. 0.0001

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

507. 0.0001

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

508. 0.0001

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

509. 0.0001

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

510. 0.0001

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

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

512. 0.0001

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

513. 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='1211' LIMIT 0,1

514. 0.0001

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

515. 0.0002

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

516. 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='1211' LIMIT 0,1

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

518. 0.0002

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

519. 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='970' LIMIT 0,1

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

521. 0.0002

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

522. 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='970' LIMIT 0,1

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

524. 0.0002

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

525. 0

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

526. 0.0001

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

527. 0.0001

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

528. 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='977' LIMIT 0,1

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

530. 0.0001

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

531. 0

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

532. 0.0001

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

533. 0.0001

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

534. 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='970' LIMIT 0,1

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

536. 0.0001

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

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

539. 0.0001

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

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='970' 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 = 341032 AND W.type_id = 1) OR (W.util_id != 341032 AND W.type_id = 2)) AND (`post_util_id` = 341032 OR `dest_util_id` = 341032) 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 = 341032

543. 0

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='970' 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 = 119964 AND W.type_id = 1) OR (W.util_id != 119964 AND W.type_id = 2)) AND (`post_util_id` = 119964 OR `dest_util_id` = 119964) 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 = 119964

546. 0

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1080' 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 = 132329 AND W.type_id = 1) OR (W.util_id != 132329 AND W.type_id = 2)) AND (`post_util_id` = 132329 OR `dest_util_id` = 132329) 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 = 132329

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='1080' 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 = 420176 AND W.type_id = 1) OR (W.util_id != 420176 AND W.type_id = 2)) AND (`post_util_id` = 420176 OR `dest_util_id` = 420176) 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 = 420176

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

554. 0.0001

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

555. 0

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='970' 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 = 140744 AND W.type_id = 1) OR (W.util_id != 140744 AND W.type_id = 2)) AND (`post_util_id` = 140744 OR `dest_util_id` = 140744) 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 = 140744

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

560. 0.0001

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

561. 0

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='970' 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 = 511217 AND W.type_id = 1) OR (W.util_id != 511217 AND W.type_id = 2)) AND (`post_util_id` = 511217 OR `dest_util_id` = 511217) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

563. 0.0001

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

564. 0

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='970' 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 = 500917 AND W.type_id = 1) OR (W.util_id != 500917 AND W.type_id = 2)) AND (`post_util_id` = 500917 OR `dest_util_id` = 500917) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

566. 0.0001

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

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

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

569. 0.0001

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

570. 0.0008

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

571. 0

     SELECT count(*) as nbwish FROM wish

572. 0.0497

     SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

572 requetes sql en 0.2201