Location robe de mariée à 94270 Val-de-marne

1. 0.0002

   SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='vetement'

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='94'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='94270' AND ville_nom like '%le%kremlin%bic%ecirc%tre%' 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 '%robe%de%mariee%' OR ssrubr_title like '%robe%de%mariee%' OR ssrubr_slug like '%robe%de%mariee%') AND cate_id='91' 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='94270'

7. 0.002

   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.36667- 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.0935146819952 AND ville_longitude_deg<2.6398253180048 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='robe mariée; robe de mariee'

9. 0.0003

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='91'AND MATCH (wish_title,wish_desc) AGAINST ('+robe mariée; robe de mariee*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '94270%'

10. 0.0001

    SELECT * FROM texte WHERE cate_id=91

11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='robe mariée; robe de mariee' OR ssrubr_slug='robe-mariée;-robe-de-mariee' OR (ssrubr_title like '%robe mariée; robe de mariee%')) AND cate_id='91' ORDER BY ssrubr_id LIMIT 0,1

12. 0.0001

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

13. 0.0001

    SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' 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 (91) ORDER BY ssrubr_order ASC

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='robe-de-mariee' AND cate_id='91'

16. 0.0001

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

17. 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.36667- 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.0935146819952 AND ville_longitude_deg<2.6398253180048 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0053

    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.36667- 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.6837758163378 AND ville_longitude_deg<3.0495641836622 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0064

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='91' AND MATCH (wish_desc) AGAINST ('(+robe +mariée; +robe +de +mariee*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94270,94270,94205,94200,94800,94250,94110,94220,92120,94160,94140,94230,94239,94238,94240,94231,94232,94233,94234,94235,94236,94237,94400,92240,75018,75012,75009,75001,75000,75003,75004,75005,75006,75007,75002,75011,75116,75020,75008,75010,75017,75016,75019,75015,75014,75013,94700,92220,92170,94550,94320,92340,94300,92320,94600,93170,94410,92330,92260,92130,94340,93100,94150,92140,93310,94310,94390,94000,92350,94260,94130,92100,93260,93230,92160,92290,92190,92360,94120,93400,93500,91320,94210,94340,94100,94290,93110,94380,92200,93130,94460,91370,94170,92110,94500,93000,92300,94190,91300,91550,94360,94430,93300,93120,92150,92800,92210,91200,94480,93140,92600,92310,93250,92400,93360,92370,92250,94450,91560,93330,92410,93200,93210,92390,93450,91420,94470,91570,92270,94370,94380,93350,91270,78140,94350,92380,92230,91160,91380,94880,94490,94880,92700,91120,92420,92430,92500,93220,93150,93700,91230,93340,93320,91430,94420,78220,91330,93240,91260,91160,93160,93440,91210,92000,91430,93800,91140,93460,78350,93430,91800,78170,94510,94440,78800,94440,91160,93380,91600,91170,95360,91390,91360,95870,95140,95880,91360,95100,78000,93370,91400,95500,93190,78420,93390,77420,78400,77340,78150,95218,95210,91160,91140,93270,78380,78290,78350,78530,77184,77185,78150,94440,93600,91860,95410,91350,77500,94520,94520,91400,95170,95110,95400,91130,91000,78430,95230,91700,91800,93470,78360,77181,77170,95500,91450,93410,91440,78560,78117,77186,95120,91620,78500)

20. 0.0145

    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.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='91' AND MATCH (wish_desc) AGAINST ('(+robe +mariée; +robe +de +mariee*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94270,94270,94205,94200,94800,94250,94110,94220,92120,94160,94140,94230,94239,94238,94240,94231,94232,94233,94234,94235,94236,94237,94400,92240,75018,75012,75009,75001,75000,75003,75004,75005,75006,75007,75002,75011,75116,75020,75008,75010,75017,75016,75019,75015,75014,75013,94700,92220,92170,94550,94320,92340,94300,92320,94600,93170,94410,92330,92260,92130,94340,93100,94150,92140,93310,94310,94390,94000,92350,94260,94130,92100,93260,93230,92160,92290,92190,92360,94120,93400,93500,91320,94210,94340,94100,94290,93110,94380,92200,93130,94460,91370,94170,92110,94500,93000,92300,94190,91300,91550,94360,94430,93300,93120,92150,92800,92210,91200,94480,93140,92600,92310,93250,92400,93360,92370,92250,94450,91560,93330,92410,93200,93210,92390,93450,91420,94470,91570,92270,94370,94380,93350,91270,78140,94350,92380,92230,91160,91380,94880,94490,94880,92700,91120,92420,92430,92500,93220,93150,93700,91230,93340,93320,91430,94420,78220,91330,93240,91260,91160,93160,93440,91210,92000,91430,93800,91140,93460,78350,93430,91800,78170,94510,94440,78800,94440,91160,93380,91600,91170,95360,91390,91360,95870,95140,95880,91360,95100,78000,93370,91400,95500,93190,78420,93390,77420,78400,77340,78150,95218,95210,91160,91140,93270,78380,78290,78350,78530,77184,77185,78150,94440,93600,91860,95410,91350,77500,94520,94520,91400,95170,95110,95400,91130,91000,78430,95230,91700,91800,93470,78360,77181,77170,95500,91450,93410,91440,78560,78117,77186,95120,91620,78500) 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='94270'

22. 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.36667- 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.0935146819952 AND ville_longitude_deg<2.6398253180048 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0053

    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.36667- 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.6837758163378 AND ville_longitude_deg<3.0495641836622 HAVING distance <= 50 ORDER BY distance ASC

24. 0.0001

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

39. 0.0001

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

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

43. 0.0001

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

44. 0.0001

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

45. 0.0001

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

46. 0.0001

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

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

61. 0.0001

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

68. 0.0001

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

69. 0.0001

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

70. 0.0001

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

71. 0.0001

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

72. 0.0001

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

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

81. 0.0001

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

82. 0.0001

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

89. 0.0001

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

90. 0.0001

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

91. 0.0001

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

92. 0.0001

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

93. 0.0001

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

94. 0.0001

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

95. 0.0001

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

96. 0.0001

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

100. 0.0001

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

101. 0.0001

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

102. 0.0001

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

103. 0.0001

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

104. 0.0001

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

105. 0.0001

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

106. 0.0001

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

128. 0.0001

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

129. 0.0001

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

130. 0.0001

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

141. 0.0001

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

142. 0.0001

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

143. 0.0001

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

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

153. 0.0001

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

154. 0.0001

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

155. 0.0001

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

156. 0.0001

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

157. 0.0001

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

158. 0.0001

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

159. 0.0001

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

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

161. 0.0001

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

162. 0.0001

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

163. 0.0001

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

164. 0.0001

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

166. 0.0001

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

167. 0.0001

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

168. 0.0001

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

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

172. 0.0001

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

173. 0.0001

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

174. 0.0001

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

175. 0.0001

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

182. 0.0001

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

183. 0.0001

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

184. 0.0001

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

185. 0.0001

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

186. 0.0001

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

187. 0.0001

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

188. 0.0001

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

189. 0.0001

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

190. 0.0001

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

191. 0.0001

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

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

195. 0.0001

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

196. 0.0001

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

197. 0.0001

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

203. 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 = 387580 AND W.type_id = 1) OR (W.util_id != 387580 AND W.type_id = 2)) AND (`post_util_id` = 387580 OR `dest_util_id` = 387580) 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=387580 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 = 387778 AND W.type_id = 1) OR (W.util_id != 387778 AND W.type_id = 2)) AND (`post_util_id` = 387778 OR `dest_util_id` = 387778) 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=387778 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 = 393382 AND W.type_id = 1) OR (W.util_id != 393382 AND W.type_id = 2)) AND (`post_util_id` = 393382 OR `dest_util_id` = 393382) 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=393382 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 = 396305 AND W.type_id = 1) OR (W.util_id != 396305 AND W.type_id = 2)) AND (`post_util_id` = 396305 OR `dest_util_id` = 396305) 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=396305 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 = 403369 AND W.type_id = 1) OR (W.util_id != 403369 AND W.type_id = 2)) AND (`post_util_id` = 403369 OR `dest_util_id` = 403369) 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=403369 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 = 404091 AND W.type_id = 1) OR (W.util_id != 404091 AND W.type_id = 2)) AND (`post_util_id` = 404091 OR `dest_util_id` = 404091) 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=404091 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 = 353046 AND W.type_id = 1) OR (W.util_id != 353046 AND W.type_id = 2)) AND (`post_util_id` = 353046 OR `dest_util_id` = 353046) 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=353046 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 = 429459 AND W.type_id = 1) OR (W.util_id != 429459 AND W.type_id = 2)) AND (`post_util_id` = 429459 OR `dest_util_id` = 429459) 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=429459 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 = 429690 AND W.type_id = 1) OR (W.util_id != 429690 AND W.type_id = 2)) AND (`post_util_id` = 429690 OR `dest_util_id` = 429690) 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=429690 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 = 432266 AND W.type_id = 1) OR (W.util_id != 432266 AND W.type_id = 2)) AND (`post_util_id` = 432266 OR `dest_util_id` = 432266) 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=432266 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 = 444722 AND W.type_id = 1) OR (W.util_id != 444722 AND W.type_id = 2)) AND (`post_util_id` = 444722 OR `dest_util_id` = 444722) 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=444722 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 = 255654 AND W.type_id = 1) OR (W.util_id != 255654 AND W.type_id = 2)) AND (`post_util_id` = 255654 OR `dest_util_id` = 255654) 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=255654 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 = 255654 AND W.type_id = 1) OR (W.util_id != 255654 AND W.type_id = 2)) AND (`post_util_id` = 255654 OR `dest_util_id` = 255654) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

228. 0.0001

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

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

234. 0.0001

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

235. 0.0001

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

236. 0.0001

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

237. 0.0001

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

238. 0.0001

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

239. 0.0001

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

240. 0.0001

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

241. 0.0001

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

242. 0.0001

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

243. 0.0001

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

244. 0.0001

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

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 = 494604 AND W.type_id = 1) OR (W.util_id != 494604 AND W.type_id = 2)) AND (`post_util_id` = 494604 OR `dest_util_id` = 494604) 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=494604 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 = 503639 AND W.type_id = 1) OR (W.util_id != 503639 AND W.type_id = 2)) AND (`post_util_id` = 503639 OR `dest_util_id` = 503639) 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=503639 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 = 477670 AND W.type_id = 1) OR (W.util_id != 477670 AND W.type_id = 2)) AND (`post_util_id` = 477670 OR `dest_util_id` = 477670) 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=477670 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 = 519148 AND W.type_id = 1) OR (W.util_id != 519148 AND W.type_id = 2)) AND (`post_util_id` = 519148 OR `dest_util_id` = 519148) 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=519148 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 = 456570 AND W.type_id = 1) OR (W.util_id != 456570 AND W.type_id = 2)) AND (`post_util_id` = 456570 OR `dest_util_id` = 456570) 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=456570 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 = 541744 AND W.type_id = 1) OR (W.util_id != 541744 AND W.type_id = 2)) AND (`post_util_id` = 541744 OR `dest_util_id` = 541744) 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=541744 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 = 546399 AND W.type_id = 1) OR (W.util_id != 546399 AND W.type_id = 2)) AND (`post_util_id` = 546399 OR `dest_util_id` = 546399) 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=546399 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 = 548551 AND W.type_id = 1) OR (W.util_id != 548551 AND W.type_id = 2)) AND (`post_util_id` = 548551 OR `dest_util_id` = 548551) 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=548551 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 = 549573 AND W.type_id = 1) OR (W.util_id != 549573 AND W.type_id = 2)) AND (`post_util_id` = 549573 OR `dest_util_id` = 549573) 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=549573 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 = 549573 AND W.type_id = 1) OR (W.util_id != 549573 AND W.type_id = 2)) AND (`post_util_id` = 549573 OR `dest_util_id` = 549573) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

264. 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='830' LIMIT 0,1

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

266. 0.0001

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

267. 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='830' LIMIT 0,1

268. 0.0001

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

269. 0.0001

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

270. 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='830' LIMIT 0,1

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

272. 0.0001

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

273. 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='830' LIMIT 0,1

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

275. 0.0002

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

276. 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='830' LIMIT 0,1

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

278. 0.0001

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

279. 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=91 AND ss.fami_id=5 ORDER BY ssrubr_order LIMIT 6,100

280. 0.0002

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

281. 0.0001

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

282. 0.0008

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

283. 0

     SELECT count(*) as nbwish FROM wish

284. 0.0469

     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

284 requetes sql en 0.1131