Location moto à 92390 Villeneuve-la-garenne

1. 0.0002

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

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='92'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='92390' AND ville_nom like '%villeneuve%la%garenne%' ORDER BY ville_population_2012 DESC LIMIT 0,1

5. 0.0019

   SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%moto%' OR ssrubr_title like '%moto%' OR ssrubr_slug like '%moto%') AND cate_id='81' 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='92390'

7. 0.0021

   SELECT ville_cp, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.753435678816 AND ville_latitude_deg<49.113164321184 AND ville_longitude_deg>2.059537276093 AND ville_longitude_deg<2.607122723907 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='moto'

9. 0.0004

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='81'AND MATCH (wish_title,wish_desc) AGAINST ('+moto*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '92390%'

10. 0.0001

    SELECT * FROM texte WHERE cate_id=81

11. 0.0003

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='moto' OR ssrubr_slug='moto' OR (ssrubr_title like '%moto%')) AND cate_id='81' 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.0002

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

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='moto' AND cate_id='81'

16. 0.0001

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

17. 0.0019

    SELECT ville_cp, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.753435678816 AND ville_latitude_deg<49.113164321184 AND ville_longitude_deg>2.059537276093 AND ville_longitude_deg<2.607122723907 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0051

    SELECT ville_cp, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.483639197041 AND ville_latitude_deg<49.382960802959 AND ville_longitude_deg>1.6488422878414 AND ville_longitude_deg<3.0178177121586 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0958

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='81' AND MATCH (wish_desc) AGAINST ('(+moto*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (92390,92390,93450,93200,93210,92230,93800,93430,93400,95360,95880,93300,93120,93240,92600,92110,93380,92300,92270,95218,95210,95170,95410,95230,93350,93500,93440,92700,95100,95140,95110,92250,92400,93310,92200,95120,95160,95580,95350,95580,75013,75012,75005,75006,75000,75014,75015,75008,75016,75018,75004,75001,75017,95500,75003,75002,75116,75020,75009,75019,75011,75010,75007,95400,95600,95400,95200,95870,93150,93700,93230,93260,95130,93000,95350,93170,78800,95680,95440,95500,92800,95130,93100,92150,92000,93140,95390,95320,78420,78500,95330,95240,92500,93130,95460,92170,95530,94300,95720,95500,95370,95720,92100,94160,94250,95570,92120,95570,92240,94270,95570,95500,93110,92210,93250,95190,95250,94205,94200,78360,78600,93600,92130,95560,95720,93320,93340,95550,95150,95220,95840,94220,94120,78400,93270,94110,95560,92380,92220,94800,95560,93420,78600,92320,95480,95700,94170,93360,92360,92190,95740,95190,92140,95720,94130,93220,94410,92410,93190,93390,94140,92420,92430,94340,92310,78110,78170,78290,78380,95380,95840,95850,94700,94239,94235,94236,94237,94240,94230,94231,94232,94238,94234,94233,95560,78560,95570,93410,95590,92260,92330,95270,95190,93330,92350,94400,94360,93370,78230,78430,92340,95540,92370,95270,78700,93290,93470,77181,95380,78140,94550,95270,93460,78100,94500,95850,94320,78750,92290,95430,94340,78220,94100,94210,95430,95630,94000,95380,94350,78150,95610,93160,78150,94600,95380,78160,78260,94430)

20. 0.0536

    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.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- 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='81' AND MATCH (wish_desc) AGAINST ('(+moto*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (92390,92390,93450,93200,93210,92230,93800,93430,93400,95360,95880,93300,93120,93240,92600,92110,93380,92300,92270,95218,95210,95170,95410,95230,93350,93500,93440,92700,95100,95140,95110,92250,92400,93310,92200,95120,95160,95580,95350,95580,75013,75012,75005,75006,75000,75014,75015,75008,75016,75018,75004,75001,75017,95500,75003,75002,75116,75020,75009,75019,75011,75010,75007,95400,95600,95400,95200,95870,93150,93700,93230,93260,95130,93000,95350,93170,78800,95680,95440,95500,92800,95130,93100,92150,92000,93140,95390,95320,78420,78500,95330,95240,92500,93130,95460,92170,95530,94300,95720,95500,95370,95720,92100,94160,94250,95570,92120,95570,92240,94270,95570,95500,93110,92210,93250,95190,95250,94205,94200,78360,78600,93600,92130,95560,95720,93320,93340,95550,95150,95220,95840,94220,94120,78400,93270,94110,95560,92380,92220,94800,95560,93420,78600,92320,95480,95700,94170,93360,92360,92190,95740,95190,92140,95720,94130,93220,94410,92410,93190,93390,94140,92420,92430,94340,92310,78110,78170,78290,78380,95380,95840,95850,94700,94239,94235,94236,94237,94240,94230,94231,94232,94238,94234,94233,95560,78560,95570,93410,95590,92260,92330,95270,95190,93330,92350,94400,94360,93370,78230,78430,92340,95540,92370,95270,78700,93290,93470,77181,95380,78140,94550,95270,93460,78100,94500,95850,94320,78750,92290,95430,94340,78220,94100,94210,95430,95630,94000,95380,94350,78150,95610,93160,78150,94600,95380,78160,78260,94430) 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='92390'

22. 0.0018

    SELECT ville_cp, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.753435678816 AND ville_latitude_deg<49.113164321184 AND ville_longitude_deg>2.059537276093 AND ville_longitude_deg<2.607122723907 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0051

    SELECT ville_cp, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.483639197041 AND ville_latitude_deg<49.382960802959 AND ville_longitude_deg>1.6488422878414 AND ville_longitude_deg<3.0178177121586 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 = 10531 AND W.type_id = 1) OR (W.util_id != 10531 AND W.type_id = 2)) AND (`post_util_id` = 10531 OR `dest_util_id` = 10531) 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=10531 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 = 11574 AND W.type_id = 1) OR (W.util_id != 11574 AND W.type_id = 2)) AND (`post_util_id` = 11574 OR `dest_util_id` = 11574) 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=11574 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 = 26457 AND W.type_id = 1) OR (W.util_id != 26457 AND W.type_id = 2)) AND (`post_util_id` = 26457 OR `dest_util_id` = 26457) 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=26457 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 = 26457 AND W.type_id = 1) OR (W.util_id != 26457 AND W.type_id = 2)) AND (`post_util_id` = 26457 OR `dest_util_id` = 26457) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

31. 0.0001

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

32. 0.0001

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

33. 0.0001

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

34. 0.0001

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

35. 0.0001

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

36. 0.0001

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

37. 0.0001

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

38. 0.0001

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

39. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 62768 AND W.type_id = 1) OR (W.util_id != 62768 AND W.type_id = 2)) AND (`post_util_id` = 62768 OR `dest_util_id` = 62768) 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=62768 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 = 65564 AND W.type_id = 1) OR (W.util_id != 65564 AND W.type_id = 2)) AND (`post_util_id` = 65564 OR `dest_util_id` = 65564) 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=65564 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 = 71395 AND W.type_id = 1) OR (W.util_id != 71395 AND W.type_id = 2)) AND (`post_util_id` = 71395 OR `dest_util_id` = 71395) 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=71395 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 = 55090 AND W.type_id = 1) OR (W.util_id != 55090 AND W.type_id = 2)) AND (`post_util_id` = 55090 OR `dest_util_id` = 55090) 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=55090 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 = 71703 AND W.type_id = 1) OR (W.util_id != 71703 AND W.type_id = 2)) AND (`post_util_id` = 71703 OR `dest_util_id` = 71703) 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=71703 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 = 86202 AND W.type_id = 1) OR (W.util_id != 86202 AND W.type_id = 2)) AND (`post_util_id` = 86202 OR `dest_util_id` = 86202) 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=86202 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 = 86850 AND W.type_id = 1) OR (W.util_id != 86850 AND W.type_id = 2)) AND (`post_util_id` = 86850 OR `dest_util_id` = 86850) 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=86850 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 = 78141 AND W.type_id = 1) OR (W.util_id != 78141 AND W.type_id = 2)) AND (`post_util_id` = 78141 OR `dest_util_id` = 78141) 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=78141 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 = 96001 AND W.type_id = 1) OR (W.util_id != 96001 AND W.type_id = 2)) AND (`post_util_id` = 96001 OR `dest_util_id` = 96001) 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=96001 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 = 108830 AND W.type_id = 1) OR (W.util_id != 108830 AND W.type_id = 2)) AND (`post_util_id` = 108830 OR `dest_util_id` = 108830) 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=108830 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 = 146194 AND W.type_id = 1) OR (W.util_id != 146194 AND W.type_id = 2)) AND (`post_util_id` = 146194 OR `dest_util_id` = 146194) 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=146194 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 = 155275 AND W.type_id = 1) OR (W.util_id != 155275 AND W.type_id = 2)) AND (`post_util_id` = 155275 OR `dest_util_id` = 155275) 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=155275 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 = 186130 AND W.type_id = 1) OR (W.util_id != 186130 AND W.type_id = 2)) AND (`post_util_id` = 186130 OR `dest_util_id` = 186130) 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=186130 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 = 189007 AND W.type_id = 1) OR (W.util_id != 189007 AND W.type_id = 2)) AND (`post_util_id` = 189007 OR `dest_util_id` = 189007) 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=189007 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 = 251586 AND W.type_id = 1) OR (W.util_id != 251586 AND W.type_id = 2)) AND (`post_util_id` = 251586 OR `dest_util_id` = 251586) 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=251586 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 = 273856 AND W.type_id = 1) OR (W.util_id != 273856 AND W.type_id = 2)) AND (`post_util_id` = 273856 OR `dest_util_id` = 273856) 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=273856 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 = 293226 AND W.type_id = 1) OR (W.util_id != 293226 AND W.type_id = 2)) AND (`post_util_id` = 293226 OR `dest_util_id` = 293226) 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=293226 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 = 317008 AND W.type_id = 1) OR (W.util_id != 317008 AND W.type_id = 2)) AND (`post_util_id` = 317008 OR `dest_util_id` = 317008) 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=317008 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 = 317583 AND W.type_id = 1) OR (W.util_id != 317583 AND W.type_id = 2)) AND (`post_util_id` = 317583 OR `dest_util_id` = 317583) 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=317583 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 = 281179 AND W.type_id = 1) OR (W.util_id != 281179 AND W.type_id = 2)) AND (`post_util_id` = 281179 OR `dest_util_id` = 281179) 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=281179 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 = 339164 AND W.type_id = 1) OR (W.util_id != 339164 AND W.type_id = 2)) AND (`post_util_id` = 339164 OR `dest_util_id` = 339164) 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=339164 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 = 341844 AND W.type_id = 1) OR (W.util_id != 341844 AND W.type_id = 2)) AND (`post_util_id` = 341844 OR `dest_util_id` = 341844) 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=341844 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 = 362328 AND W.type_id = 1) OR (W.util_id != 362328 AND W.type_id = 2)) AND (`post_util_id` = 362328 OR `dest_util_id` = 362328) 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=362328 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 = 367680 AND W.type_id = 1) OR (W.util_id != 367680 AND W.type_id = 2)) AND (`post_util_id` = 367680 OR `dest_util_id` = 367680) 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=367680 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 = 371246 AND W.type_id = 1) OR (W.util_id != 371246 AND W.type_id = 2)) AND (`post_util_id` = 371246 OR `dest_util_id` = 371246) 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=371246 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 = 374381 AND W.type_id = 1) OR (W.util_id != 374381 AND W.type_id = 2)) AND (`post_util_id` = 374381 OR `dest_util_id` = 374381) 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=374381 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 = 376321 AND W.type_id = 1) OR (W.util_id != 376321 AND W.type_id = 2)) AND (`post_util_id` = 376321 OR `dest_util_id` = 376321) 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=376321 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 = 385245 AND W.type_id = 1) OR (W.util_id != 385245 AND W.type_id = 2)) AND (`post_util_id` = 385245 OR `dest_util_id` = 385245) 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=385245 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 = 389308 AND W.type_id = 1) OR (W.util_id != 389308 AND W.type_id = 2)) AND (`post_util_id` = 389308 OR `dest_util_id` = 389308) 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=389308 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 = 390978 AND W.type_id = 1) OR (W.util_id != 390978 AND W.type_id = 2)) AND (`post_util_id` = 390978 OR `dest_util_id` = 390978) 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=390978 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 = 398218 AND W.type_id = 1) OR (W.util_id != 398218 AND W.type_id = 2)) AND (`post_util_id` = 398218 OR `dest_util_id` = 398218) 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=398218 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 = 399956 AND W.type_id = 1) OR (W.util_id != 399956 AND W.type_id = 2)) AND (`post_util_id` = 399956 OR `dest_util_id` = 399956) 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=399956 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 = 405915 AND W.type_id = 1) OR (W.util_id != 405915 AND W.type_id = 2)) AND (`post_util_id` = 405915 OR `dest_util_id` = 405915) 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=405915 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 = 409436 AND W.type_id = 1) OR (W.util_id != 409436 AND W.type_id = 2)) AND (`post_util_id` = 409436 OR `dest_util_id` = 409436) 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=409436 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 = 418378 AND W.type_id = 1) OR (W.util_id != 418378 AND W.type_id = 2)) AND (`post_util_id` = 418378 OR `dest_util_id` = 418378) 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=418378 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 = 419068 AND W.type_id = 1) OR (W.util_id != 419068 AND W.type_id = 2)) AND (`post_util_id` = 419068 OR `dest_util_id` = 419068) 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=419068 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 = 53103 AND W.type_id = 1) OR (W.util_id != 53103 AND W.type_id = 2)) AND (`post_util_id` = 53103 OR `dest_util_id` = 53103) 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=53103 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 = 427549 AND W.type_id = 1) OR (W.util_id != 427549 AND W.type_id = 2)) AND (`post_util_id` = 427549 OR `dest_util_id` = 427549) 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=427549 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 = 440369 AND W.type_id = 1) OR (W.util_id != 440369 AND W.type_id = 2)) AND (`post_util_id` = 440369 OR `dest_util_id` = 440369) 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=440369 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 = 452144 AND W.type_id = 1) OR (W.util_id != 452144 AND W.type_id = 2)) AND (`post_util_id` = 452144 OR `dest_util_id` = 452144) 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=452144 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 = 457111 AND W.type_id = 1) OR (W.util_id != 457111 AND W.type_id = 2)) AND (`post_util_id` = 457111 OR `dest_util_id` = 457111) 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=457111 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 = 460348 AND W.type_id = 1) OR (W.util_id != 460348 AND W.type_id = 2)) AND (`post_util_id` = 460348 OR `dest_util_id` = 460348) 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=460348 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 = 460364 AND W.type_id = 1) OR (W.util_id != 460364 AND W.type_id = 2)) AND (`post_util_id` = 460364 OR `dest_util_id` = 460364) 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=460364 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 = 76091 AND W.type_id = 1) OR (W.util_id != 76091 AND W.type_id = 2)) AND (`post_util_id` = 76091 OR `dest_util_id` = 76091) 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=76091 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 = 465598 AND W.type_id = 1) OR (W.util_id != 465598 AND W.type_id = 2)) AND (`post_util_id` = 465598 OR `dest_util_id` = 465598) 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=465598 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 = 248565 AND W.type_id = 1) OR (W.util_id != 248565 AND W.type_id = 2)) AND (`post_util_id` = 248565 OR `dest_util_id` = 248565) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

130. 0.0001

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

131. 0.0001

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

132. 0.0001

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

133. 0.0001

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

134. 0.0001

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

135. 0.0001

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

136. 0.0001

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

137. 0.0001

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

138. 0.0001

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

139. 0.0001

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

140. 0.0001

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

141. 0.0001

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

144. 0.0001

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

145. 0.0001

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

146. 0.0001

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

147. 0.0001

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

148. 0.0001

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

149. 0.0001

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

150. 0.0001

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

151. 0.0001

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

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

160. 0.0001

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

165. 0.0001

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

166. 0.0001

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

175. 0.0001

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

176. 0.0001

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

177. 0.0001

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

178. 0.0001

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

179. 0.0001

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

180. 0.0001

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

181. 0.0001

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

182. 0.0001

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

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

192. 0.0001

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

193. 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='864' LIMIT 0,1

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

195. 0.0001

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

196. 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='864' LIMIT 0,1

197. 0.0002

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

198. 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='864' LIMIT 0,1

199. 0.0001

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

200. 0

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

201. 0.0001

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

202. 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='985' LIMIT 0,1

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

204. 0.0001

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

205. 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='864' LIMIT 0,1

206. 0.0001

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

207. 0.0001

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

208. 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='864' LIMIT 0,1

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

210. 0.0002

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

211. 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='730' LIMIT 0,1

212. 0.0001

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

213. 0.0002

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

214. 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='864' LIMIT 0,1

215. 0.0001

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

216. 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='864' LIMIT 0,1

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

218. 0.0001

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

219. 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='864' LIMIT 0,1

220. 0.0001

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

221. 0.0002

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

222. 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='861' LIMIT 0,1

223. 0.0001

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

224. 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='861' LIMIT 0,1

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

226. 0.0001

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

227. 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='861' LIMIT 0,1

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

229. 0.0001

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

230. 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='864' LIMIT 0,1

231. 0.0001

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

232. 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='864' LIMIT 0,1

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

234. 0.0001

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

235. 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='864' LIMIT 0,1

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

237. 0.0001

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

238. 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='864' LIMIT 0,1

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

240. 0.0001

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

241. 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='864' LIMIT 0,1

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

243. 0.0001

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

244. 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='730' LIMIT 0,1

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

246. 0.0001

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

247. 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='864' LIMIT 0,1

248. 0.0001

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

249. 0.0002

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

250. 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='864' LIMIT 0,1

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

252. 0.0002

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

253. 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='864' LIMIT 0,1

254. 0.0001

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

255. 0.0001

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

256. 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='864' LIMIT 0,1

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

258. 0.0001

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

259. 0

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

260. 0.0001

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

261. 0.0001

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

262. 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='864' LIMIT 0,1

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

264. 0.0001

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

265. 0

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

266. 0.0001

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

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

268. 0.0001

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

269. 0

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

270. 0.0001

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

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

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

273. 0.0001

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

274. 0.0008

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

275. 0

     SELECT count(*) as nbwish FROM wish

276. 0.051

     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

276 requetes sql en 0.2468