Service nettoyage à 93170 Bagnolet

1. 0.0001

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

2. 0

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

3. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='93'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='93170' AND ville_nom like '%bagnolet%' 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='93170'

7. 0.002

   SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.686835678816 AND ville_latitude_deg<49.046564321184 AND ville_longitude_deg>2.1432418543365 AND ville_longitude_deg<2.6900981456635 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='nettoyage'

9. 0.0008

   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 '93170%'

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

    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

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

17. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.686835678816 AND ville_latitude_deg<49.046564321184 AND ville_longitude_deg>2.1432418543365 AND ville_longitude_deg<2.6900981456635 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0053

    SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.417039197041 AND ville_latitude_deg<49.316360802959 AND ville_longitude_deg>1.7330937413096 AND ville_longitude_deg<3.1002462586904 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0466

    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 (93170,93170,93100,93230,93310,93260,94300,94160,93500,93130,93000,93110,93140,94120,75007,75009,75020,75006,75005,75004,75003,75002,75000,75010,75011,75116,75001,75019,75018,75017,75015,75016,75014,75013,75008,75012,94220,93120,94200,93300,94205,94130,94410,93250,94170,94340,94270,93400,93360,93350,94140,94700,93150,93700,93340,93320,94360,94250,94800,93210,93200,93330,93220,94500,92120,93440,92110,92170,94400,93240,92390,93450,94340,94210,94110,94100,94000,92240,94430,92300,94350,92600,93460,94235,94234,94233,94232,94231,94240,94236,94237,94238,94239,94230,94600,92200,95140,93160,95500,93190,93390,92230,93270,92220,94320,93430,93370,93380,93600,94550,95360,94380,93800,92320,92270,94420,92130,92400,92340,92250,92100,95400,94390,94310,95500,93410,92140,95880,93470,92700,77181,92150,92800,94880,94880,94490,92330,92260,94460,77500,77420,95410,94150,93420,94380,94370,95170,92360,92190,92350,95210,95218,94290,92210,94470,94260,95200,95400,94190,77185,95350,95500,95100,94510,93290,95230,92160,95500,94450,92290,77181,77184,77340,77177,92500,77186,95160,91320,92000,95870,77270,95110,95700,94480,95720,91200,78800,92310,91560,95440,95120,91370,95190,77360,91550,95580,92410,95580,77200,92380,95350,92370,95600,91330,94440,91300,78420,77410,92420,92430,95720,91270,77680,78140,95130,77090,77183,91230,94440,95460,95680,78500,77400,95330,95380,91420,91800,77290,91570,78400,77400,78170,77600,78220,95390,94440,95130)

20. 0.0513

    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.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- 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 (93170,93170,93100,93230,93310,93260,94300,94160,93500,93130,93000,93110,93140,94120,75007,75009,75020,75006,75005,75004,75003,75002,75000,75010,75011,75116,75001,75019,75018,75017,75015,75016,75014,75013,75008,75012,94220,93120,94200,93300,94205,94130,94410,93250,94170,94340,94270,93400,93360,93350,94140,94700,93150,93700,93340,93320,94360,94250,94800,93210,93200,93330,93220,94500,92120,93440,92110,92170,94400,93240,92390,93450,94340,94210,94110,94100,94000,92240,94430,92300,94350,92600,93460,94235,94234,94233,94232,94231,94240,94236,94237,94238,94239,94230,94600,92200,95140,93160,95500,93190,93390,92230,93270,92220,94320,93430,93370,93380,93600,94550,95360,94380,93800,92320,92270,94420,92130,92400,92340,92250,92100,95400,94390,94310,95500,93410,92140,95880,93470,92700,77181,92150,92800,94880,94880,94490,92330,92260,94460,77500,77420,95410,94150,93420,94380,94370,95170,92360,92190,92350,95210,95218,94290,92210,94470,94260,95200,95400,94190,77185,95350,95500,95100,94510,93290,95230,92160,95500,94450,92290,77181,77184,77340,77177,92500,77186,95160,91320,92000,95870,77270,95110,95700,94480,95720,91200,78800,92310,91560,95440,95120,91370,95190,77360,91550,95580,92410,95580,77200,92380,95350,92370,95600,91330,94440,91300,78420,77410,92420,92430,95720,91270,77680,78140,95130,77090,77183,91230,94440,95460,95680,78500,77400,95330,95380,91420,91800,77290,91570,78400,77400,78170,77600,78220,95390,94440,95130) 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='93170'

22. 0.0018

    SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.686835678816 AND ville_latitude_deg<49.046564321184 AND ville_longitude_deg>2.1432418543365 AND ville_longitude_deg<2.6900981456635 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0053

    SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.417039197041 AND ville_latitude_deg<49.316360802959 AND ville_longitude_deg>1.7330937413096 AND ville_longitude_deg<3.1002462586904 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 = 12265 AND W.type_id = 1) OR (W.util_id != 12265 AND W.type_id = 2)) AND (`post_util_id` = 12265 OR `dest_util_id` = 12265) 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=12265 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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

68. 0.0001

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

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

70. 0.0001

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

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

72. 0.0001

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

93. 0.0001

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

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

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 = 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

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

97. 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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

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

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

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

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 = 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

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

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 = 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

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

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 = 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

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

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

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

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 = 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

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

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 = 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

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

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 = 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

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

161. 0.0001

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

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

163. 0.0001

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

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

165. 0.0001

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

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

167. 0.0001

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

168. 0.0001

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

169. 0.0001

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

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

171. 0.0001

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

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

173. 0.0001

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

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

175. 0.0001

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

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

177. 0.0001

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

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

179. 0.0001

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

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

181. 0.0001

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

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

183. 0.0001

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

184. 0.0001

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

185. 0.0001

     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

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

187. 0.0001

     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

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

189. 0.0001

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

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

191. 0.0001

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

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

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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

204. 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

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

206. 0.0001

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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

221. 0.0001

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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

244. 0.0001

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

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

246. 0.0001

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

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

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 = 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

249. 0.0001

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

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

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 = 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

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

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

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

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 = 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

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 = 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

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

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 = 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

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

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 = 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

263. 0.0001

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

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

265. 0.0001

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

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 = 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

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

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 = 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

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

270. 0.0001

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

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

272. 0.0001

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

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 = 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

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

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 = 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

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

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 = 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

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

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

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

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 = 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

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

285. 0.0001

     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

286. 0.0001

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

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

288. 0.0001

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

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

290. 0.0001

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

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

292. 0.0001

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

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

294. 0.0001

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

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

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 = 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

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

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 = 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

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

300. 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

311. 0.0001

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

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

313. 0.0001

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

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

315. 0.0001

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

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 = 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

317. 0.0001

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

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

319. 0.0001

     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

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

321. 0.0001

     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

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

323. 0.0001

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

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

325. 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 = 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

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

327. 0.0001

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

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

329. 0.0001

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

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

331. 0.0001

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

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

333. 0.0001

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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

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

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 = 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

350. 0.0001

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

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

352. 0.0001

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

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

354. 0.0001

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

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

356. 0.0001

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

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

358. 0.0001

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

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

360. 0.0001

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

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

362. 0.0001

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

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

364. 0.0001

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

365. 0.0001

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

366. 0.0001

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

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

368. 0.0001

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

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

370. 0.0001

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

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

372. 0.0001

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

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

374. 0.0001

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

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

376. 0.0001

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

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

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 = 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

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

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 = 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

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

382. 0.0001

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

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

384. 0.0001

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

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

386. 0.0001

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

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

388. 0.0001

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

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

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 = 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

391. 0.0001

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

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

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 = 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

394. 0.0001

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

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

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 = 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

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

398. 0.0001

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

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

400. 0.0001

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

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

402. 0.0001

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

403. 0.0001

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

404. 0.0001

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

405. 0.0001

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

406. 0.0001

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

407. 0.0001

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

408. 0.0001

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

409. 0.0001

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

410. 0.0001

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

411. 0.0001

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

412. 0.0001

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

413. 0.0001

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

414. 0.0001

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

415. 0.0001

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

416. 0.0001

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

417. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='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 = 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

419. 0.0001

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

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='970' 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 = 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

422. 0.0001

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

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='970' 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 = 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

425. 0.0001

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

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

427. 0.0001

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

428. 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

429. 0.0001

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

430. 0.0001

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

431. 0.0001

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

432. 0.0001

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

433. 0.0001

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

434. 0.0001

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

435. 0.0002

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

436. 0.0001

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

437. 0.0001

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

438. 0.0001

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

439. 0.0001

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

440. 0.0001

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

441. 0.0001

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

442. 0.0001

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

443. 0.0001

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

444. 0.0001

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

445. 0.0001

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

446. 0.0001

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

447. 0.0001

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

448. 0.0001

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

449. 0.0001

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

450. 0.0001

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

451. 0.0001

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

452. 0.0001

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

453. 0.0001

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

454. 0.0001

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

455. 0.0001

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

456. 0.0001

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

457. 0.0001

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

458. 0.0001

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

459. 0.0001

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

460. 0.0001

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

461. 0.0001

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

462. 0.0001

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

463. 0.0001

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

464. 0.0001

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

465. 0.0001

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

466. 0.0001

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

467. 0.0001

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

468. 0.0001

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

469. 0.0001

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

470. 0.0001

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

471. 0.0001

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

472. 0.0001

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

473. 0.0001

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

474. 0.0001

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

475. 0.0001

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

476. 0.0001

     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

477. 0.0001

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

478. 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

479. 0.0001

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

480. 0.0001

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

481. 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

482. 0.0001

     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

483. 0.0001

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

484. 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

485. 0.0001

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

486. 0.0001

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

487. 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

488. 0.0001

     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

489. 0.0001

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

490. 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

491. 0.0001

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

492. 0.0001

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

493. 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

494. 0.0001

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

495. 0.0001

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

496. 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

497. 0.0001

     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

498. 0.0001

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

499. 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

500. 0.0001

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

501. 0.0001

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

502. 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

503. 0.0001

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

504. 0.0001

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

505. 0.0001

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

506. 0.0001

     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

507. 0.0001

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

508. 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

509. 0.0001

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

510. 0.0001

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

511. 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

512. 0.0001

     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

513. 0.0001

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

514. 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

515. 0.0001

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

516. 0.0001

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

517. 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

518. 0.0001

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

519. 0.0001

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

520. 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

521. 0.0001

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

522. 0.0001

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

523. 0.0001

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

524. 0.0001

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

525. 0.0001

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

526. 0.0001

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

527. 0.0001

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

528. 0.0001

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

529. 0.0001

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

530. 0.0001

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

531. 0.0001

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

532. 0.0001

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

533. 0.0001

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

534. 0.0001

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

535. 0.0001

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

536. 0.0001

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

537. 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

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 = 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

539. 0.0001

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

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='937' 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 = 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

542. 0.0001

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

543. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1211' 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 = 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

545. 0.0001

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

546. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='970' 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 = 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

548. 0.0001

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

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='970' 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 = 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

551. 0.0001

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

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='1211' 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 = 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

554. 0.0001

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

555. 0.0001

     SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='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 = 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

557. 0.0001

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

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 = 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

560. 0.0001

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

561. 0.0001

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

562. 0.0001

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

563. 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

564. 0.0001

     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

565. 0.0001

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

566. 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

567. 0.0001

     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

568. 0.0001

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

569. 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

570. 0.0001

     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

571. 0.0001

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

572. 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

573. 0.0001

     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

574. 0.0001

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

575. 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

576. 0.0001

     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

577. 0.0001

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

578. 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

579. 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

580. 0.0001

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

581. 0.0009

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

582. 0

     SELECT count(*) as nbwish FROM wish

583. 0.0481

     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

583 requetes sql en 0.2213