Service avec camion à 95140 Garges-lès-gonesse

1. 0.0001

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

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='95'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='95140' AND ville_nom like '%garges%les%gonesse%' 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 '%avec%camion%' OR ssrubr_title like '%avec%camion%' OR ssrubr_slug like '%avec%camion%') AND cate_id='42' 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='95140'

7. 0.0021

   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.41667- 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.1426939337662 AND ville_longitude_deg<2.6906460662338 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='camion; avec camion'

9. 0.0006

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

10. 0.0001

    SELECT * FROM texte WHERE cate_id=42

11. 0.0002

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

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

14. 0.0001

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

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='avec-camion' AND cate_id='42'

16. 0

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

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.41667- 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.1426939337662 AND ville_longitude_deg<2.6906460662338 HAVING distance <= 20 ORDER BY distance ASC

18. 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.41667- 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.7317239280719 AND ville_longitude_deg<3.1016160719281 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0353

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

20. 0.0275

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

22. 0.0017

    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.41667- 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.1426939337662 AND ville_longitude_deg<2.6906460662338 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0055

    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.41667- 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.7317239280719 AND ville_longitude_deg<3.1016160719281 HAVING distance <= 50 ORDER BY distance ASC

24. 0.0001

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

26. 0.0001

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

30. 0.0001

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

35. 0.0001

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

36. 0.0001

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

37. 0.0001

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

38. 0.0001

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

39. 0.0001

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

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

43. 0.0001

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

44. 0.0001

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

45. 0.0001

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

46. 0.0001

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

47. 0.0001

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

48. 0.0001

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

49. 0.0001

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

50. 0.0001

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

51. 0.0001

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

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

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

65. 0.0001

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

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

71. 0.0001

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

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 = 59694 AND W.type_id = 1) OR (W.util_id != 59694 AND W.type_id = 2)) AND (`post_util_id` = 59694 OR `dest_util_id` = 59694) 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=59694 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 = 60980 AND W.type_id = 1) OR (W.util_id != 60980 AND W.type_id = 2)) AND (`post_util_id` = 60980 OR `dest_util_id` = 60980) 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=60980 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 = 62416 AND W.type_id = 1) OR (W.util_id != 62416 AND W.type_id = 2)) AND (`post_util_id` = 62416 OR `dest_util_id` = 62416) 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=62416 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 = 63751 AND W.type_id = 1) OR (W.util_id != 63751 AND W.type_id = 2)) AND (`post_util_id` = 63751 OR `dest_util_id` = 63751) 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=63751 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 = 66297 AND W.type_id = 1) OR (W.util_id != 66297 AND W.type_id = 2)) AND (`post_util_id` = 66297 OR `dest_util_id` = 66297) 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=66297 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 = 66857 AND W.type_id = 1) OR (W.util_id != 66857 AND W.type_id = 2)) AND (`post_util_id` = 66857 OR `dest_util_id` = 66857) 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=66857 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 = 68136 AND W.type_id = 1) OR (W.util_id != 68136 AND W.type_id = 2)) AND (`post_util_id` = 68136 OR `dest_util_id` = 68136) 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=68136 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 = 68439 AND W.type_id = 1) OR (W.util_id != 68439 AND W.type_id = 2)) AND (`post_util_id` = 68439 OR `dest_util_id` = 68439) 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=68439 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 = 71766 AND W.type_id = 1) OR (W.util_id != 71766 AND W.type_id = 2)) AND (`post_util_id` = 71766 OR `dest_util_id` = 71766) 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=71766 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 = 26497 AND W.type_id = 1) OR (W.util_id != 26497 AND W.type_id = 2)) AND (`post_util_id` = 26497 OR `dest_util_id` = 26497) 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=26497 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 = 74094 AND W.type_id = 1) OR (W.util_id != 74094 AND W.type_id = 2)) AND (`post_util_id` = 74094 OR `dest_util_id` = 74094) 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=74094 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 = 74456 AND W.type_id = 1) OR (W.util_id != 74456 AND W.type_id = 2)) AND (`post_util_id` = 74456 OR `dest_util_id` = 74456) 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=74456 AND note_visu IN (1,3,4)

96. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

128. 0.0001

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

129. 0.0001

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

130. 0.0001

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

131. 0.0001

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

132. 0.0001

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

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

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

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

142. 0.0001

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

143. 0.0001

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

144. 0.0001

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

145. 0.0001

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

146. 0.0001

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

147. 0.0001

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

148. 0.0001

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

149. 0.0001

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

150. 0.0001

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

151. 0.0001

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

152. 0.0001

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

153. 0.0001

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

154. 0.0001

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

155. 0.0001

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

160. 0.0001

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

161. 0.0001

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

162. 0.0001

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

163. 0.0001

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

164. 0.0001

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

165. 0.0001

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

166. 0.0001

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

167. 0.0001

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

168. 0.0001

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

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

172. 0.0001

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

173. 0.0001

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

174. 0.0001

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

183. 0.0001

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

184. 0.0001

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

185. 0.0001

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

186. 0.0001

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

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 = 258005 AND W.type_id = 1) OR (W.util_id != 258005 AND W.type_id = 2)) AND (`post_util_id` = 258005 OR `dest_util_id` = 258005) 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=258005 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 = 123783 AND W.type_id = 1) OR (W.util_id != 123783 AND W.type_id = 2)) AND (`post_util_id` = 123783 OR `dest_util_id` = 123783) 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=123783 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 = 272784 AND W.type_id = 1) OR (W.util_id != 272784 AND W.type_id = 2)) AND (`post_util_id` = 272784 OR `dest_util_id` = 272784) 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=272784 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 = 273422 AND W.type_id = 1) OR (W.util_id != 273422 AND W.type_id = 2)) AND (`post_util_id` = 273422 OR `dest_util_id` = 273422) 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=273422 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 = 274106 AND W.type_id = 1) OR (W.util_id != 274106 AND W.type_id = 2)) AND (`post_util_id` = 274106 OR `dest_util_id` = 274106) 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=274106 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 = 277978 AND W.type_id = 1) OR (W.util_id != 277978 AND W.type_id = 2)) AND (`post_util_id` = 277978 OR `dest_util_id` = 277978) 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=277978 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 = 279748 AND W.type_id = 1) OR (W.util_id != 279748 AND W.type_id = 2)) AND (`post_util_id` = 279748 OR `dest_util_id` = 279748) 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=279748 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 = 281528 AND W.type_id = 1) OR (W.util_id != 281528 AND W.type_id = 2)) AND (`post_util_id` = 281528 OR `dest_util_id` = 281528) 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=281528 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 = 282531 AND W.type_id = 1) OR (W.util_id != 282531 AND W.type_id = 2)) AND (`post_util_id` = 282531 OR `dest_util_id` = 282531) 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=282531 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 = 227181 AND W.type_id = 1) OR (W.util_id != 227181 AND W.type_id = 2)) AND (`post_util_id` = 227181 OR `dest_util_id` = 227181) 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=227181 AND note_visu IN (1,3,4)

207. 0.0001

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

209. 0.0001

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

219. 0.0001

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

230. 0.0001

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

231. 0.0001

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

232. 0.0001

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

233. 0.0001

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

234. 0.0001

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

235. 0.0001

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

236. 0.0001

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

237. 0.0001

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

238. 0.0001

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

239. 0.0001

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

240. 0.0001

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

241. 0.0001

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

242. 0.0001

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

254. 0.0001

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

259. 0.0001

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

260. 0.0001

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

261. 0.0001

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

262. 0.0001

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

263. 0.0001

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

264. 0.0001

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

265. 0.0001

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

266. 0.0001

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

267. 0.0001

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

268. 0.0001

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

269. 0.0001

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

270. 0.0001

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

271. 0.0001

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

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

277. 0.0001

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

278. 0.0001

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

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

288. 0.0001

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

289. 0.0001

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

290. 0.0001

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

291. 0.0001

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

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

293. 0.0001

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

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

295. 0.0001

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

296. 0.0001

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

297. 0.0001

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

298. 0.0001

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

299. 0.0001

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

300. 0.0001

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

301. 0.0001

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

302. 0.0001

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

303. 0.0001

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

304. 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='947' LIMIT 0,1

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

306. 0.0001

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

307. 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='947' LIMIT 0,1

308. 0.0001

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

309. 0.0001

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

310. 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='947' LIMIT 0,1

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

312. 0.0001

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

313. 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='996' LIMIT 0,1

314. 0.0001

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

315. 0.0001

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

316. 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='947' LIMIT 0,1

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

318. 0.0002

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

319. 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='948' LIMIT 0,1

320. 0.0001

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

321. 0.0002

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

322. 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='947' LIMIT 0,1

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

324. 0.0002

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

325. 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='947' LIMIT 0,1

326. 0.0001

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

327. 0.0002

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

328. 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='947' LIMIT 0,1

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

330. 0.0002

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

331. 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='947' LIMIT 0,1

332. 0.0001

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

333. 0.0001

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

334. 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='947' LIMIT 0,1

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

336. 0.0002

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

337. 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='947' LIMIT 0,1

338. 0.0001

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

339. 0.0001

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

340. 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='996' LIMIT 0,1

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

342. 0.0001

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

343. 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='947' LIMIT 0,1

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

345. 0.0001

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

346. 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='947' LIMIT 0,1

347. 0.0001

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

348. 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='996' LIMIT 0,1

349. 0.0001

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

350. 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='948' LIMIT 0,1

351. 0.0001

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

352. 0.0001

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

353. 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='959' LIMIT 0,1

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

355. 0.0001

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

356. 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='947' LIMIT 0,1

357. 0.0001

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

358. 0.0001

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

359. 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='947' LIMIT 0,1

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

361. 0.0001

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

362. 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='948' LIMIT 0,1

363. 0.0001

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

364. 0.0001

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

365. 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='947' LIMIT 0,1

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

367. 0.0001

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

368. 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='947' LIMIT 0,1

369. 0.0001

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

370. 0.0001

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

371. 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='947' LIMIT 0,1

372. 0.0001

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

373. 0.0001

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

374. 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='947' LIMIT 0,1

375. 0.0001

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

376. 0.0001

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

377. 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='947' LIMIT 0,1

378. 0.0001

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

379. 0.0001

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

380. 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='959' LIMIT 0,1

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

382. 0.0001

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

383. 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='947' LIMIT 0,1

384. 0.0001

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

385. 0.0002

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

386. 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='947' LIMIT 0,1

387. 0.0002

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

388. 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='947' LIMIT 0,1

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

390. 0.0001

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

391. 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='947' LIMIT 0,1

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

393. 0.0001

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

394. 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='947' LIMIT 0,1

395. 0.0001

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

396. 0.0001

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

397. 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='947' LIMIT 0,1

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

399. 0.0001

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

400. 0.0002

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

401. 0.0001

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

402. 0.0001

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

403. 0.0008

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

404. 0

     SELECT count(*) as nbwish FROM wish

405. 0.0472

     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

405 requetes sql en 0.1691