Service multi services à 93380 Pierrefitte-sur-seine

1. 0.0001

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

2. 0

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

3. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='93'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='93380' AND ville_nom like '%pierrefitte%sur%seine%' ORDER BY ville_population_2012 DESC LIMIT 0,1

5. 0.0001

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

6. 0.0001

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

7. 0.0024

   SELECT ville_cp, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.786835678816 AND ville_latitude_deg<49.146564321184 AND ville_longitude_deg>2.0926939337662 AND ville_longitude_deg<2.6406460662338 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='multi services'

9. 0.0004

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

10. 0.0001

    SELECT * FROM texte WHERE cate_id=50

11. 0.0002

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

12. 0.0001

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

13. 0.0002

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

14. 0.0002

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

15. 0.0001

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

16. 0.0001

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

17. 0.0019

    SELECT ville_cp, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.786835678816 AND ville_latitude_deg<49.146564321184 AND ville_longitude_deg>2.0926939337662 AND ville_longitude_deg<2.6406460662338 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0059

    SELECT ville_cp, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.517039197041 AND ville_latitude_deg<49.416360802959 AND ville_longitude_deg>1.6817239280719 AND ville_longitude_deg<3.0516160719281 HAVING distance <= 50 ORDER BY distance ASC

19. 0.099

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='50' AND MATCH (wish_desc) AGAINST ('(+multi +services*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (93380,93380,95360,93430,95410,93240,95170,95880,95140,95350,93210,93200,95200,95400,95400,93440,95160,92390,93450,93800,95500,95230,93350,93300,95440,93120,95350,95218,95210,95580,95580,92230,95500,95600,93150,93700,95720,95460,95120,95330,93500,93400,95500,95680,95720,95110,92600,95100,92110,95190,95390,92270,95500,95570,95720,95570,93310,92300,93000,95130,92700,95320,93140,95130,95570,93260,93230,95190,93600,92250,95720,92400,95700,95870,95560,93170,95560,93130,92200,75008,75018,75017,75016,75009,75010,75015,75013,75011,75014,75019,75020,75005,75116,75006,75001,75000,75002,75003,75004,75012,75007,95850,95560,93100,93420,95380,95240,95840,95190,93270,95570,95270,95150,95550,93320,93340,95250,95530,78800,93250,95560,95270,78500,95370,94300,95380,93110,92000,95590,95850,95740,93190,93390,78420,95840,92800,92150,95270,95220,93410,94160,95380,95380,93220,92500,93290,94120,93360,92170,95480,78600,95270,95270,95670,94170,95380,93370,95540,95270,94270,94205,94200,77181,78360,93470,95270,94250,94220,95270,92120,95470,92100,94130,95270,95590,92240,77990,92210,95430,95630,93330,78600,77990,94410,94340,92130,95470,95430,77290,78400,93460,94360,95270,94800,95270,77270,95270,94110,94140,77181,95590,95760,94700,92220,95290,92380,77500,95260,95470,92320,78700,93160,78110,92190,92360,95260,92140,95620,94500,95470,94350)

20. 0.0761

    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.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='50' AND MATCH (wish_desc) AGAINST ('(+multi +services*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (93380,93380,95360,93430,95410,93240,95170,95880,95140,95350,93210,93200,95200,95400,95400,93440,95160,92390,93450,93800,95500,95230,93350,93300,95440,93120,95350,95218,95210,95580,95580,92230,95500,95600,93150,93700,95720,95460,95120,95330,93500,93400,95500,95680,95720,95110,92600,95100,92110,95190,95390,92270,95500,95570,95720,95570,93310,92300,93000,95130,92700,95320,93140,95130,95570,93260,93230,95190,93600,92250,95720,92400,95700,95870,95560,93170,95560,93130,92200,75008,75018,75017,75016,75009,75010,75015,75013,75011,75014,75019,75020,75005,75116,75006,75001,75000,75002,75003,75004,75012,75007,95850,95560,93100,93420,95380,95240,95840,95190,93270,95570,95270,95150,95550,93320,93340,95250,95530,78800,93250,95560,95270,78500,95370,94300,95380,93110,92000,95590,95850,95740,93190,93390,78420,95840,92800,92150,95270,95220,93410,94160,95380,95380,93220,92500,93290,94120,93360,92170,95480,78600,95270,95270,95670,94170,95380,93370,95540,95270,94270,94205,94200,77181,78360,93470,95270,94250,94220,95270,92120,95470,92100,94130,95270,95590,92240,77990,92210,95430,95630,93330,78600,77990,94410,94340,92130,95470,95430,77290,78400,93460,94360,95270,94800,95270,77270,95270,94110,94140,77181,95590,95760,94700,92220,95290,92380,77500,95260,95470,92320,78700,93160,78110,92190,92360,95260,92140,95620,94500,95470,94350) 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='93380'

22. 0.0019

    SELECT ville_cp, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.786835678816 AND ville_latitude_deg<49.146564321184 AND ville_longitude_deg>2.0926939337662 AND ville_longitude_deg<2.6406460662338 HAVING distance <= 20 ORDER BY distance ASC

23. 0.006

    SELECT ville_cp, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.517039197041 AND ville_latitude_deg<49.416360802959 AND ville_longitude_deg>1.6817239280719 AND ville_longitude_deg<3.0516160719281 HAVING distance <= 50 ORDER BY distance ASC

24. 0.0002

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

25. 0.0001

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

26. 0.0002

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

27. 0.0001

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

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

29. 0.0001

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

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

34. 0.0001

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

35. 0.0001

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

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

37. 0.0001

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

38. 0.0001

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

39. 0.0001

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

40. 0.0002

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

41. 0.0001

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

42. 0.0002

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

45. 0.0001

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

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

47. 0.0001

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

48. 0.0002

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

49. 0.0001

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

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

51. 0.0001

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

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

53. 0.0001

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

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

57. 0.0001

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

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

59. 0.0001

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

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

63. 0.0001

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

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

67. 0.0001

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

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

69. 0.0001

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

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

73. 0.0001

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

81. 0.0001

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

82. 0.0001

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

89. 0.0001

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

90. 0.0001

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

91. 0.0001

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

92. 0.0001

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

93. 0.0001

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

94. 0.0001

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

95. 0.0001

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

96. 0.0002

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

100. 0.0001

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

101. 0.0001

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

102. 0.0001

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

103. 0.0001

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

104. 0.0001

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

105. 0.0001

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

106. 0.0001

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

120. 0.0001

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

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

128. 0.0001

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

129. 0.0001

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

130. 0.0001

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

131. 0.0001

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

132. 0.0001

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

133. 0.0001

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

134. 0.0001

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

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

136. 0.0001

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

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

138. 0.0001

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

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

140. 0.0001

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

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

142. 0.0001

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

143. 0.0001

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

144. 0.0001

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

145. 0.0001

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

146. 0.0001

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

147. 0.0001

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

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

149. 0.0001

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

150. 0.0001

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

151. 0.0001

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

152. 0.0001

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

153. 0.0001

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

154. 0.0001

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

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

156. 0.0001

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

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

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

162. 0.0001

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

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

164. 0.0001

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

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

166. 0.0001

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

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

170. 0.0001

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

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

174. 0.0001

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

175. 0.0001

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

176. 0.0001

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

177. 0.0001

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

178. 0.0001

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

179. 0.0001

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

180. 0.0001

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

181. 0.0001

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

182. 0.0001

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

183. 0.0001

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

184. 0.0001

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

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

186. 0.0001

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

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

188. 0.0001

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

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

192. 0.0001

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

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

196. 0.0001

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

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

198. 0.0001

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

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

200. 0.0001

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

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

202. 0.0001

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

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

204. 0.0001

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

205. 0.0001

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

206. 0.0001

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

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

208. 0.0001

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

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

210. 0.0001

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

211. 0.0001

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

212. 0.0001

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

213. 0.0001

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

214. 0.0001

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

215. 0.0001

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

216. 0.0001

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

217. 0.0001

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

218. 0.0001

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

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

220. 0.0001

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

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

226. 0.0001

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

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

228. 0.0001

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

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

230. 0.0001

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

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

232. 0.0001

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

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

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

237. 0.0001

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

238. 0.0001

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

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

240. 0.0001

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

241. 0.0001

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

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

243. 0.0001

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

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

247. 0.0001

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

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

249. 0.0001

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

250. 0.0001

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

251. 0.0001

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

252. 0.0001

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

253. 0.0001

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

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

255. 0.0001

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

256. 0.0001

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

257. 0.0001

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

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

259. 0.0001

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

260. 0.0001

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

261. 0.0001

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

262. 0.0001

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

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

266. 0.0001

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

267. 0.0001

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

268. 0.0001

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

271. 0.0001

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

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

273. 0.0001

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

274. 0.0001

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

275. 0.0001

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

276. 0.0001

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

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

280. 0.0001

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

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

282. 0.0001

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

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

284. 0.0001

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

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

286. 0.0001

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

287. 0.0001

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

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

291. 0.0001

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

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

295. 0.0001

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

296. 0.0001

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

297. 0.0001

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

298. 0.0001

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

299. 0.0001

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

300. 0.0001

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

301. 0.0001

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

302. 0.0001

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

303. 0.0001

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

304. 0.0001

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

305. 0.0001

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

306. 0.0001

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

307. 0.0001

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

308. 0.0001

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

309. 0.0001

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

310. 0.0001

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

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

312. 0.0001

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

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

316. 0.0001

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

317. 0.0001

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

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

322. 0.0001

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

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

325. 0.0001

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

326. 0.0001

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

327. 0.0002

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

328. 0.0001

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

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

330. 0.0001

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

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

332. 0.0001

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

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

338. 0.0001

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

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

342. 0.0001

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

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

344. 0.0001

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

345. 0.0001

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

346. 0.0001

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

347. 0.0001

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

348. 0.0002

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

349. 0.0001

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

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

353. 0.0001

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

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

357. 0.0001

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

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

361. 0.0001

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

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

363. 0.0001

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

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

371. 0.0001

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

372. 0.0002

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

373. 0.0001

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

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

377. 0.0001

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

378. 0.0001

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

379. 0.0001

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

380. 0.0001

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

381. 0.0001

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

382. 0.0001

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

383. 0.0001

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

384. 0.0001

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

385. 0.0001

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

386. 0.0001

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

387. 0.0001

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

388. 0.0001

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

389. 0.0001

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

390. 0.0001

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

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

392. 0.0001

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

393. 0.0001

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

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

395. 0.0001

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

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

401. 0.0001

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

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

404. 0.0002

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

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

407. 0.0002

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

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

410. 0.0002

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

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

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

413. 0.0003

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

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

416. 0.0002

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

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

419. 0.0002

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

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

422. 0.0002

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

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

425. 0.0002

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

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

427. 0.0001

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

428. 0.0002

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

429. 0.0001

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

430. 0.0001

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

431. 0.0002

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

432. 0.0001

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

433. 0.0001

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

434. 0.0002

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

435. 0.0001

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

436. 0.0001

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

437. 0.0002

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

438. 0.0001

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

439. 0.0001

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

440. 0.0002

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

441. 0.0001

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

442. 0.0001

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

443. 0.0002

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

444. 0.0001

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

445. 0.0001

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

446. 0.0002

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

447. 0.0001

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

448. 0.0001

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

449. 0.0002

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

450. 0.0001

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

451. 0.0001

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

452. 0.0002

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

453. 0.0001

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

454. 0.0001

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

455. 0.0002

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

456. 0.0001

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

457. 0.0002

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

458. 0.0003

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

459. 0.0002

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

460. 0.0001

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

461. 0.0017

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

462. 0

     SELECT count(*) as nbwish FROM wish

463. 0.0546

     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

463 requetes sql en 0.2998