Service multi services à 91270 Vigneux-sur-seine

1. 0.0001

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

2. 0

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

3. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='91'

4. 0.0001

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

5. 0.0001

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

6. 0.0001

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

7. 0.002

   SELECT ville_cp, ROUND((((acos(sin((48.7*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7*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.520135678816 AND ville_latitude_deg<48.879864321184 AND ville_longitude_deg>2.14414854235 AND ville_longitude_deg<2.68919145765 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='multi services'

9. 0.0013

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

10. 0.0001

    SELECT * FROM texte WHERE cate_id=50

11. 0.0002

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

12. 0.0001

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

13. 0.0002

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

14. 0.0002

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

15. 0.0001

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

16. 0.0001

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

17. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.7*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7*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.520135678816 AND ville_latitude_deg<48.879864321184 AND ville_longitude_deg>2.14414854235 AND ville_longitude_deg<2.68919145765 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0052

    SELECT ville_cp, ROUND((((acos(sin((48.7*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7*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.250339197041 AND ville_latitude_deg<49.149660802959 AND ville_longitude_deg>1.7353604808895 AND ville_longitude_deg<3.0979795191105 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0878

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='50' AND MATCH (wish_desc) AGAINST ('(+multi +services*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (91270,91270,91210,94480,91200,91230,91260,91560,94290,91550,91170,94190,91130,91000,94390,94310,91450,91350,91800,91420,94450,91390,91600,91330,94460,91360,91320,94150,94600,91860,91090,94320,91000,91360,91450,91700,91380,91160,94440,91800,94550,94380,94470,94260,91480,91080,94400,91070,91250,91700,94520,94520,94000,92160,91700,91300,94440,91160,91250,91480,91160,94231,94230,94232,94240,94233,94235,94234,94236,92340,94237,91280,94238,94239,94140,91090,94440,91160,94700,94380,94370,91240,77380,94800,91220,91220,91100,91140,77127,91310,91370,91620,91120,77170,94100,94110,91250,94210,94340,94220,91100,94205,94200,92290,91310,91310,94430,94410,92260,92330,94880,94490,94880,94270,94340,91140,92220,94250,92350,91620,77170,92320,94160,91540,91540,91540,92120,94500,91430,77150,91810,94510,91310,91460,92240,94130,92140,91570,91250,91830,91430,77150,77550,94360,91180,91630,91540,94300,77166,94420,92130,91290,77176,91710,92170,91630,91400,94120,92360,92190,77340,94350,94170,91290,91440,91940,77550,77173,77166,91630,93170,75009,75008,75006,75005,75004,75003,75002,75010,75011,75012,75116,75020,75018,75017,75016,75015,75014,75013,75000,75001,75007,75019,93100,91750,91400,91940,93330,91830,93110,92100,91630,77176,77240,92370,91680,91770,91610,77184,91520,91340,78350,77330,93360,93160,91630)

20. 0.0587

    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.7*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7*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='50' AND MATCH (wish_desc) AGAINST ('(+multi +services*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (91270,91270,91210,94480,91200,91230,91260,91560,94290,91550,91170,94190,91130,91000,94390,94310,91450,91350,91800,91420,94450,91390,91600,91330,94460,91360,91320,94150,94600,91860,91090,94320,91000,91360,91450,91700,91380,91160,94440,91800,94550,94380,94470,94260,91480,91080,94400,91070,91250,91700,94520,94520,94000,92160,91700,91300,94440,91160,91250,91480,91160,94231,94230,94232,94240,94233,94235,94234,94236,92340,94237,91280,94238,94239,94140,91090,94440,91160,94700,94380,94370,91240,77380,94800,91220,91220,91100,91140,77127,91310,91370,91620,91120,77170,94100,94110,91250,94210,94340,94220,91100,94205,94200,92290,91310,91310,94430,94410,92260,92330,94880,94490,94880,94270,94340,91140,92220,94250,92350,91620,77170,92320,94160,91540,91540,91540,92120,94500,91430,77150,91810,94510,91310,91460,92240,94130,92140,91570,91250,91830,91430,77150,77550,94360,91180,91630,91540,94300,77166,94420,92130,91290,77176,91710,92170,91630,91400,94120,92360,92190,77340,94350,94170,91290,91440,91940,77550,77173,77166,91630,93170,75009,75008,75006,75005,75004,75003,75002,75010,75011,75012,75116,75020,75018,75017,75016,75015,75014,75013,75000,75001,75007,75019,93100,91750,91400,91940,93330,91830,93110,92100,91630,77176,77240,92370,91680,91770,91610,77184,91520,91340,78350,77330,93360,93160,91630) 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='91270'

22. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.7*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7*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.520135678816 AND ville_latitude_deg<48.879864321184 AND ville_longitude_deg>2.14414854235 AND ville_longitude_deg<2.68919145765 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0055

    SELECT ville_cp, ROUND((((acos(sin((48.7*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7*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.250339197041 AND ville_latitude_deg<49.149660802959 AND ville_longitude_deg>1.7353604808895 AND ville_longitude_deg<3.0979795191105 HAVING distance <= 50 ORDER BY distance ASC

24. 0.0002

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

25. 0.0001

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

26. 0.0002

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

28. 0.0002

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

29. 0.0001

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

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

33. 0.0001

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

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

35. 0.0001

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

36. 0.0001

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

37. 0.0001

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

38. 0.0001

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

39. 0.0001

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

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

43. 0.0001

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

44. 0.0001

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

45. 0.0001

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

46. 0.0001

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

47. 0.0001

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

48. 0.0001

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

49. 0.0001

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

50. 0.0001

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

51. 0.0001

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

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

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

65. 0.0001

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

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

67. 0.0001

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

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

69. 0.0001

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

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

71. 0.0001

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

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

73. 0.0001

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

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

75. 0.0001

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

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

77. 0.0001

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

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

79. 0.0001

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

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

81. 0.0001

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

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

85. 0.0001

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

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

87. 0.0001

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

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

89. 0.0001

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

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

91. 0.0001

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

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

93. 0.0001

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

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

95. 0.0001

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

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

97. 0.0001

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

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

101. 0.0001

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

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

107. 0.0001

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

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

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

119. 0.0001

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

120. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

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

128. 0.0001

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

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

130. 0.0001

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

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

133. 0.0001

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

136. 0.0001

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

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

138. 0.0001

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

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

146. 0.0001

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

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

148. 0.0001

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

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

154. 0.0001

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

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

156. 0.0001

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

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

161. 0.0001

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

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

163. 0.0001

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

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

165. 0.0001

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

166. 0.0001

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

167. 0.0001

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

168. 0.0001

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

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

172. 0.0001

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

173. 0.0001

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

174. 0.0001

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

175. 0.0001

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

176. 0.0001

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

177. 0.0001

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

178. 0.0001

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

179. 0.0001

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

180. 0.0001

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

181. 0.0001

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

182. 0.0001

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

183. 0.0001

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

186. 0.0001

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

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

188. 0.0001

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

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

190. 0.0001

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

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

196. 0.0001

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

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

202. 0.0001

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

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

210. 0.0001

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

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

214. 0.0001

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

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

216. 0.0001

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

217. 0.0001

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

218. 0.0001

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

219. 0.0001

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

220. 0.0001

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

221. 0.0001

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

222. 0.0001

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

223. 0.0001

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

224. 0.0001

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

225. 0.0001

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

226. 0.0001

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

227. 0.0001

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

228. 0.0001

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

229. 0.0001

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

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

237. 0.0001

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

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

243. 0.0001

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

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

247. 0.0001

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

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

249. 0.0001

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

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

257. 0.0001

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

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

259. 0.0001

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

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

261. 0.0001

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

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

263. 0.0001

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

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

265. 0.0001

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

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

267. 0.0001

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

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

269. 0.0001

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

270. 0.0001

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

271. 0.0001

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

272. 0.0001

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

273. 0.0001

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

274. 0.0001

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

275. 0.0001

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

276. 0.0001

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

277. 0.0001

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

278. 0.0001

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

279. 0.0001

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

280. 0.0001

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

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

284. 0.0001

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

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

288. 0.0001

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

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

290. 0.0001

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

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

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

293. 0.0001

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

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

297. 0.0001

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

298. 0.0001

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

299. 0.0001

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

300. 0.0001

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

301. 0.0001

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

302. 0.0001

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

303. 0.0001

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

304. 0.0001

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

305. 0.0001

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

306. 0.0001

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

307. 0.0001

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

308. 0.0001

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

309. 0.0001

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

310. 0.0001

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

311. 0.0001

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

312. 0.0001

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

313. 0.0001

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

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

315. 0.0001

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

316. 0.0001

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

317. 0.0001

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

318. 0.0001

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

319. 0.0001

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

320. 0.0001

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

321. 0.0001

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

322. 0.0001

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

323. 0.0001

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

324. 0.0001

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

325. 0.0001

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

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

327. 0.0001

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

328. 0.0001

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

329. 0.0001

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

330. 0.0001

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

331. 0.0001

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

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

333. 0.0001

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

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

335. 0.0001

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

336. 0.0001

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

337. 0.0001

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

338. 0.0001

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

339. 0.0001

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

340. 0.0002

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

341. 0.0001

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

342. 0.0001

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

343. 0.0001

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

344. 0.0001

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

345. 0.0001

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

346. 0.0002

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

347. 0.0001

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

348. 0.0001

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

349. 0.0001

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

350. 0.0001

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

351. 0.0001

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

352. 0.0001

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

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

354. 0.0001

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

355. 0

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

356. 0.0001

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

357. 0

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

358. 0.0001

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

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

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

364. 0.0001

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

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

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

370. 0.0001

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

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

374. 0

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

377. 0

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

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

382. 0.0001

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

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

384. 0.0001

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

385. 0.0001

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

386. 0.0001

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

387. 0.0001

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

388. 0.0001

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

389. 0.0001

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

390. 0.0001

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

391. 0.0001

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

392. 0.0001

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

393. 0.0001

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

394. 0.0001

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

395. 0.0001

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

396. 0.0001

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

397. 0.0002

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

398. 0.0001

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

399. 0.0001

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

400. 0.0001

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

401. 0.0001

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

402. 0.0001

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

403. 0.0001

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

404. 0.0001

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

405. 0.0001

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

406. 0.0001

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

407. 0.0001

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

408. 0.0001

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

409. 0.0001

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

410. 0.0001

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

411. 0.0001

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

412. 0.0001

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

413. 0.0001

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

414. 0.0001

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

415. 0.0001

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

416. 0.0001

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

417. 0.0001

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

418. 0.0001

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

419. 0.0001

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

420. 0.0001

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

421. 0.0001

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

422. 0.0001

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

423. 0.0001

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

424. 0.0001

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

425. 0.0001

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

426. 0.0001

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

427. 0.0001

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

428. 0.0001

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

429. 0.0001

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

430. 0.0001

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

431. 0.0001

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

432. 0.0001

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

433. 0.0001

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

434. 0.0001

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

435. 0.0001

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

436. 0.0001

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

437. 0.0001

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

438. 0.0001

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

439. 0.0001

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

440. 0.0001

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

441. 0.0001

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

442. 0.0001

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

443. 0.0001

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

444. 0.0001

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

445. 0.0001

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

446. 0.0001

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

447. 0.0001

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

448. 0.0001

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

449. 0.0001

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

450. 0.0001

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

451. 0.0001

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

452. 0.0001

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

453. 0.0001

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

454. 0.0001

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

455. 0.0001

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

456. 0.0001

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

457. 0.0001

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

458. 0.0001

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

459. 0.0001

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

460. 0.0001

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

461. 0.0001

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

462. 0.0001

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

463. 0.0001

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

464. 0.0001

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

465. 0.0001

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

466. 0.0001

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

467. 0.0001

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

468. 0.0001

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

469. 0.0001

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

470. 0.0001

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

471. 0.0001

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

472. 0.0001

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

473. 0.0001

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

474. 0.0001

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

475. 0.0001

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

476. 0.0001

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

477. 0.0001

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

478. 0.0001

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

479. 0.0001

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

480. 0.0001

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

481. 0

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

482. 0.0001

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

483. 0.0001

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

484. 0

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

485. 0.0001

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

486. 0.0001

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

487. 0

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

488. 0.0001

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

489. 0.0001

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

490. 0

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

491. 0.0001

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

492. 0.0001

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

493. 0

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

494. 0.0001

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

495. 0.0001

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

496. 0

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

497. 0.0001

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

498. 0.0001

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

499. 0

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

500. 0.0001

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

501. 0.0001

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

502. 0

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

503. 0.0001

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

504. 0.0001

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

505. 0

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

506. 0.0001

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

507. 0.0001

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

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

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

510. 0.0001

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

511. 0.0008

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

512. 0

     SELECT count(*) as nbwish FROM wish

513. 0.0451

     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

513 requetes sql en 0.25979999999999