Service avec camion à 94500 Champigny-sur-marne

1. 0.0001

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

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='94'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='94500' AND ville_nom like '%champigny%sur%marne%' ORDER BY ville_population_2012 DESC LIMIT 0,1

5. 0.0001

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

6. 0.0001

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

7. 0.0021

   SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.2435146819952 AND ville_longitude_deg<2.7898253180048 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

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

9. 0.001

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

10. 0.0001

    SELECT * FROM texte WHERE cate_id=42

11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='camion; avec camion' OR ssrubr_slug='camion;-avec-camion' OR (ssrubr_title like '%camion; avec camion%')) AND cate_id='42' ORDER BY ssrubr_id LIMIT 0,1

12. 0.0001

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

13. 0.0002

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

14. 0.0001

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

15. 0.0001

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

16. 0.0001

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

17. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.2435146819952 AND ville_longitude_deg<2.7898253180048 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0057

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.8337758163378 AND ville_longitude_deg<3.1995641836622 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0369

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='42' AND MATCH (wish_desc) AGAINST ('(+camion; +avec +camion*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94500,94500,94360,94430,94100,94210,94340,94350,94130,94420,94340,93330,94170,94410,94120,94880,94490,94880,93160,94000,93360,94370,94380,94380,93110,94510,94700,93460,77340,77420,94300,77184,94220,94470,93220,93250,94160,94140,77185,93100,93130,94460,93170,94600,93320,93340,77186,94400,94440,94450,77500,93230,93260,94205,94200,77680,93370,93140,77200,93000,94190,94270,77090,77183,94800,94440,91330,77360,94320,93310,77177,94390,94310,93390,93190,94440,77150,94290,93470,77181,77170,91560,77330,93500,77150,77600,93270,91800,94520,94520,77181,94480,77400,94550,94250,93410,75006,75004,75005,75007,75003,75002,75000,75001,75015,75008,75009,75116,75019,75018,75017,75016,75014,75013,75012,75011,75010,75020,77135,94110,77164,93150,93700,91230,77600,77600,94239,94238,94237,94235,94233,94236,94232,94231,94230,94234,94240,91200,77400,94150,77400,92120,93120,77410,93300,93600,91860,77270,91800,93350,91270,77600,92340,77173,91550,77400,91480,92240,92220,92170,93290,93400,91320,77400,94260,93440,77170,91210,91480,93420,77600,77380,77600,92320,77400,93210,93200,92260,92330,77400,92160,93240,95500,91260,77144,95140,92130,92110,77410,77220,92140,77166,92390,93450,92350,91420,92290,95500,91450,91170,92300,91300,92100,92200,77144,77700,91370,77700,92600,95400,77290,77166,91130,91000,93380,77410,77410)

20. 0.0285

    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.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='42' AND MATCH (wish_desc) AGAINST ('(+camion; +avec +camion*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94500,94500,94360,94430,94100,94210,94340,94350,94130,94420,94340,93330,94170,94410,94120,94880,94490,94880,93160,94000,93360,94370,94380,94380,93110,94510,94700,93460,77340,77420,94300,77184,94220,94470,93220,93250,94160,94140,77185,93100,93130,94460,93170,94600,93320,93340,77186,94400,94440,94450,77500,93230,93260,94205,94200,77680,93370,93140,77200,93000,94190,94270,77090,77183,94800,94440,91330,77360,94320,93310,77177,94390,94310,93390,93190,94440,77150,94290,93470,77181,77170,91560,77330,93500,77150,77600,93270,91800,94520,94520,77181,94480,77400,94550,94250,93410,75006,75004,75005,75007,75003,75002,75000,75001,75015,75008,75009,75116,75019,75018,75017,75016,75014,75013,75012,75011,75010,75020,77135,94110,77164,93150,93700,91230,77600,77600,94239,94238,94237,94235,94233,94236,94232,94231,94230,94234,94240,91200,77400,94150,77400,92120,93120,77410,93300,93600,91860,77270,91800,93350,91270,77600,92340,77173,91550,77400,91480,92240,92220,92170,93290,93400,91320,77400,94260,93440,77170,91210,91480,93420,77600,77380,77600,92320,77400,93210,93200,92260,92330,77400,92160,93240,95500,91260,77144,95140,92130,92110,77410,77220,92140,77166,92390,93450,92350,91420,92290,95500,91450,91170,92300,91300,92100,92200,77144,77700,91370,77700,92600,95400,77290,77166,91130,91000,93380,77410,77410) 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='94500'

22. 0.0019

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.2435146819952 AND ville_longitude_deg<2.7898253180048 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0074

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.8337758163378 AND ville_longitude_deg<3.1995641836622 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 = 4872 AND W.type_id = 1) OR (W.util_id != 4872 AND W.type_id = 2)) AND (`post_util_id` = 4872 OR `dest_util_id` = 4872) 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=4872 AND note_visu IN (1,3,4)

26. 0.0001

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

28. 0.0001

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

29. 0.0001

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

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

31. 0.0001

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

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

33. 0.0001

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

34. 0.0001

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

35. 0.0001

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

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

37. 0.0001

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

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

39. 0.0001

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

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

43. 0.0001

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

44. 0.0001

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

45. 0.0001

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

46. 0.0001

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

47. 0.0001

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

48. 0.0001

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

49. 0.0001

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

50. 0.0001

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

51. 0.0001

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

52. 0.0001

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

53. 0.0001

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

54. 0.0001

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

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

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

59. 0.0001

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

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

65. 0.0001

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

66. 0.0001

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

67. 0.0001

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

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

69. 0.0001

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

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

71. 0.0001

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

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

73. 0.0001

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

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

75. 0.0001

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

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

77. 0.0001

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

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

79. 0.0001

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

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

81. 0.0001

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

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

83. 0.0001

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

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

85. 0.0001

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

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

87. 0.0001

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

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

89. 0.0001

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

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

91. 0.0001

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

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

93. 0.0001

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

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

95. 0.0001

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

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

97. 0.0001

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

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

99. 0.0001

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

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

101. 0.0001

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

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

103. 0.0001

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

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

105. 0.0001

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

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

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

111. 0.0001

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

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

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

124. 0.0001

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

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

126. 0.0001

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

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

128. 0.0001

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

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

130. 0.0001

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

131. 0.0001

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

132. 0.0001

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

133. 0.0001

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

134. 0.0001

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

135. 0.0001

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

136. 0.0001

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

137. 0.0001

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

138. 0.0001

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

139. 0.0001

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

140. 0.0001

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

141. 0.0001

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

142. 0.0001

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

143. 0.0001

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

144. 0.0001

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

145. 0.0001

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

146. 0.0001

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

147. 0.0001

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

148. 0.0001

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

149. 0.0001

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

150. 0.0001

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

151. 0.0001

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

152. 0.0001

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

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

154. 0.0001

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

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

156. 0.0001

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

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

158. 0.0001

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

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

160. 0.0001

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

161. 0.0001

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

162. 0.0001

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

163. 0.0001

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

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

166. 0.0001

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

167. 0.0001

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

168. 0.0001

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

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

172. 0.0001

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

173. 0.0001

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

174. 0.0001

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

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

176. 0.0001

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

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

178. 0.0001

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

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

180. 0.0001

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

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

182. 0.0001

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

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

184. 0.0001

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

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

186. 0.0001

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

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

188. 0.0001

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

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

190. 0.0001

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

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

192. 0.0001

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

193. 0.0001

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

194. 0.0001

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

195. 0.0001

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

196. 0.0001

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

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

200. 0.0001

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

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

204. 0.0001

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

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

206. 0.0001

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

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

208. 0.0001

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

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

210. 0.0001

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

211. 0.0001

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

212. 0.0001

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

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

214. 0.0001

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

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

216. 0.0001

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

217. 0.0001

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

218. 0.0001

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

219. 0.0001

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

220. 0.0001

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

221. 0.0001

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

222. 0.0001

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

223. 0.0001

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

224. 0.0001

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

225. 0.0001

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

226. 0.0001

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

227. 0.0001

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

228. 0.0001

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

229. 0.0001

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

230. 0.0001

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

231. 0.0001

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

232. 0.0001

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

233. 0.0001

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

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

241. 0.0001

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

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

245. 0.0001

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

246. 0.0001

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

247. 0.0001

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

248. 0.0001

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

249. 0.0001

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

250. 0.0001

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

251. 0.0001

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

252. 0.0001

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

253. 0.0001

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

254. 0.0001

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

255. 0.0001

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

256. 0.0001

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

257. 0.0001

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

258. 0.0001

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

259. 0.0001

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

260. 0.0001

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

261. 0.0001

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

262. 0.0001

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

263. 0.0001

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

264. 0.0001

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

265. 0.0001

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

266. 0.0001

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

267. 0.0001

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

268. 0.0001

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

269. 0.0001

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

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

271. 0.0001

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

272. 0.0001

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

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

274. 0.0001

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

275. 0.0001

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

276. 0.0001

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

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

280. 0.0001

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

281. 0.0001

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

282. 0.0001

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

283. 0.0001

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

284. 0.0001

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

285. 0.0001

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

286. 0.0001

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

287. 0.0001

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

288. 0.0001

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

289. 0.0001

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

290. 0.0001

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

291. 0.0001

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

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

293. 0.0001

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

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

296. 0.0001

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

297. 0.0001

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

298. 0.0001

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

299. 0.0001

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

300. 0.0001

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

301. 0.0001

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

302. 0.0001

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

303. 0.0001

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

304. 0.0002

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

305. 0.0001

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

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

307. 0.0002

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

308. 0.0001

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

309. 0.0001

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

310. 0.0002

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

311. 0.0001

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

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

313. 0.0002

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

314. 0.0001

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

315. 0.0001

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

316. 0.0002

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

317. 0.0001

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

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

319. 0.0002

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

320. 0.0001

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

321. 0.0001

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

322. 0.0002

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

323. 0.0001

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

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

325. 0.0002

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

326. 0.0001

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

327. 0.0001

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

328. 0.0002

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

329. 0.0001

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

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

331. 0.0002

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

332. 0.0001

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

333. 0.0001

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

334. 0.0002

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

335. 0.0001

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

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

337. 0.0002

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

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

340. 0.0002

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

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

343. 0.0002

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

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

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

346. 0.0002

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

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

348. 0.0002

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

349. 0.0002

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

350. 0.0001

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

351. 0.0001

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

352. 0.0002

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

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

354. 0.0001

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

355. 0.0001

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

356. 0.0001

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

357. 0.0001

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

358. 0.0001

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

359. 0.0001

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

360. 0.0001

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

361. 0.0001

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

362. 0.0001

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

363. 0.0001

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

364. 0.0001

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

365. 0.0001

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

366. 0.0001

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

367. 0.0002

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

368. 0.0001

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

369. 0.0001

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

370. 0.0001

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

371. 0.0001

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

374. 0.0001

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

376. 0.0002

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

377. 0.0001

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

379. 0.0002

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

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

382. 0.0001

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

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

384. 0.0001

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

385. 0.0001

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

386. 0.0001

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

387. 0.0001

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

388. 0.0001

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

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

391. 0.0002

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

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

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

397. 0.0001

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

398. 0.0002

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

399. 0.0001

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

400. 0.0001

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

401. 0.0009

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

402. 0

     SELECT count(*) as nbwish FROM wish

403. 0.0495

     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

403 requetes sql en 0.1776