Location place de parking à 92000 Nanterre

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='box-stockage'

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='92'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='92000' AND ville_nom like '%nanterre%' ORDER BY ville_population_2012 DESC LIMIT 0,1

5. 0.0002

   SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%place%de%parking%' OR ssrubr_title like '%place%de%parking%' OR ssrubr_slug like '%place%de%parking%') AND cate_id='79' 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='92000'

7. 0.0027

   SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>1.9263897328734 AND ville_longitude_deg<2.4736102671266 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='place parking; place de parking'

9. 0.001

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='79'AND MATCH (wish_title,wish_desc) AGAINST ('+place parking; place de parking*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '92000%'

10. 0.0029

    SELECT * FROM texte WHERE cate_id=79

11. 0.0003

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='place parking; place de parking' OR ssrubr_slug='place-parking;-place-de-parking' OR (ssrubr_title like '%place parking; place de parking%')) AND cate_id='79' ORDER BY ssrubr_id LIMIT 0,1

12. 0.0001

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

13. 0.0002

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

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='place-de-parking' AND cate_id='79'

16. 0.0001

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

17. 0.0028

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>1.9263897328734 AND ville_longitude_deg<2.4736102671266 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0109

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.450339197041 AND ville_latitude_deg<49.349660802959 AND ville_longitude_deg>1.5159684337256 AND ville_longitude_deg<2.8840315662744 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0582

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='79' AND MATCH (wish_desc) AGAINST ('(+place +parking; +place +de +parking*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (92000,92000,92500,78800,78420,92250,92400,95870,92700,78400,78360,92150,92800,92270,92200,78500,78110,92300,78380,78290,78560,92600,92380,92210,95100,78600,78170,78600,78430,92110,78230,95530,92420,92430,92230,95110,92100,92410,78100,78750,92310,95240,78160,95370,95130,95218,95210,78150,93800,93400,78112,78150,78870,92170,93450,92390,78620,95120,92130,92190,92360,92370,78140,78590,95880,78220,95220,95130,75006,75116,75005,75020,75013,75012,75014,75011,75015,75009,75016,75017,75008,75018,75019,75004,75003,75002,75007,75010,75001,75000,78300,95230,78700,92240,78000,92140,93210,93200,78240,93430,78260,92120,95600,92320,95250,95480,95360,78590,95580,95580,92220,78955,78240,78570,95170,94250,95320,93120,93300,92350,95390,93380,95680,92330,92260,95410,78330,93240,78860,93500,93310,78780,95160,78210,94110,95150,95550,95610,78350,78570,94270,78450,78530,92290,78350,78670,78670,78630,95000,94237,94236,94235,94233,94231,94230,94240,94238,94234,94239,94232,93350,93170,94205,94200,92340,95350,94800,91570,95740,93440,78450,95350,95840,93230,93260,78510,95560,91370,95400,95200,78390,78810,93100,95140,78540,94160,95330,95000,78280,95310,78117,95280,94300,95570,95300,92160,93000,95400,78480,94220,78340,94550,91430,95540,91430,95500,93700,93150,95440,95840,95430,91400,94260,95490,95460,78180,95570,94140,93140,91300,95000,94400,78190,78121,93130,78630,78810,95560,95300,78117,95570,94150,78960,94320)

20. 0.046

    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.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- 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='79' AND MATCH (wish_desc) AGAINST ('(+place +parking; +place +de +parking*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (92000,92000,92500,78800,78420,92250,92400,95870,92700,78400,78360,92150,92800,92270,92200,78500,78110,92300,78380,78290,78560,92600,92380,92210,95100,78600,78170,78600,78430,92110,78230,95530,92420,92430,92230,95110,92100,92410,78100,78750,92310,95240,78160,95370,95130,95218,95210,78150,93800,93400,78112,78150,78870,92170,93450,92390,78620,95120,92130,92190,92360,92370,78140,78590,95880,78220,95220,95130,75006,75116,75005,75020,75013,75012,75014,75011,75015,75009,75016,75017,75008,75018,75019,75004,75003,75002,75007,75010,75001,75000,78300,95230,78700,92240,78000,92140,93210,93200,78240,93430,78260,92120,95600,92320,95250,95480,95360,78590,95580,95580,92220,78955,78240,78570,95170,94250,95320,93120,93300,92350,95390,93380,95680,92330,92260,95410,78330,93240,78860,93500,93310,78780,95160,78210,94110,95150,95550,95610,78350,78570,94270,78450,78530,92290,78350,78670,78670,78630,95000,94237,94236,94235,94233,94231,94230,94240,94238,94234,94239,94232,93350,93170,94205,94200,92340,95350,94800,91570,95740,93440,78450,95350,95840,93230,93260,78510,95560,91370,95400,95200,78390,78810,93100,95140,78540,94160,95330,95000,78280,95310,78117,95280,94300,95570,95300,92160,93000,95400,78480,94220,78340,94550,91430,95540,91430,95500,93700,93150,95440,95840,95430,91400,94260,95490,95460,78180,95570,94140,93140,91300,95000,94400,78190,78121,93130,78630,78810,95560,95300,78117,95570,94150,78960,94320) 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='92000'

22. 0.0026

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>1.9263897328734 AND ville_longitude_deg<2.4736102671266 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0082

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.450339197041 AND ville_latitude_deg<49.349660802959 AND ville_longitude_deg>1.5159684337256 AND ville_longitude_deg<2.8840315662744 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 = 4737 AND W.type_id = 1) OR (W.util_id != 4737 AND W.type_id = 2)) AND (`post_util_id` = 4737 OR `dest_util_id` = 4737) 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=4737 AND note_visu IN (1,3,4)

26. 0.0002

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

28. 0.0002

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

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

37. 0.0002

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=16300 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 = 16375 AND W.type_id = 1) OR (W.util_id != 16375 AND W.type_id = 2)) AND (`post_util_id` = 16375 OR `dest_util_id` = 16375) 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=16375 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 = 19164 AND W.type_id = 1) OR (W.util_id != 19164 AND W.type_id = 2)) AND (`post_util_id` = 19164 OR `dest_util_id` = 19164) 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=19164 AND note_visu IN (1,3,4)

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

47. 0.0001

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

48. 0.0004

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

49. 0.0001

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

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

51. 0.0001

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

52. 0.0001

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

53. 0.0001

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

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

55. 0.0001

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

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

65. 0.0001

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

66. 0.0001

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

67. 0.0001

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

68. 0.0001

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

69. 0.0001

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

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

71. 0.0001

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

72. 0.0001

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

73. 0.0001

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

81. 0.0001

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

82. 0.0001

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

89. 0.0001

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

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

91. 0.0001

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

92. 0.0001

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

93. 0.0001

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

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

95. 0.0001

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

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

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

101. 0.0001

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

102. 0.0001

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

103. 0.0001

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

104. 0.0001

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

105. 0.0001

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

106. 0.0001

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

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

113. 0.0001

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

114. 0.0001

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

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

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

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

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

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

131. 0.0002

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=59742 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 = 171859 AND W.type_id = 1) OR (W.util_id != 171859 AND W.type_id = 2)) AND (`post_util_id` = 171859 OR `dest_util_id` = 171859) 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=171859 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 = 176742 AND W.type_id = 1) OR (W.util_id != 176742 AND W.type_id = 2)) AND (`post_util_id` = 176742 OR `dest_util_id` = 176742) 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=176742 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 = 31127 AND W.type_id = 1) OR (W.util_id != 31127 AND W.type_id = 2)) AND (`post_util_id` = 31127 OR `dest_util_id` = 31127) 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=31127 AND note_visu IN (1,3,4)

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

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

141. 0.0001

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

142. 0.0001

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

143. 0.0001

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

144. 0.0001

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

145. 0.0002

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=194734 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 = 199994 AND W.type_id = 1) OR (W.util_id != 199994 AND W.type_id = 2)) AND (`post_util_id` = 199994 OR `dest_util_id` = 199994) 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=199994 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 = 203233 AND W.type_id = 1) OR (W.util_id != 203233 AND W.type_id = 2)) AND (`post_util_id` = 203233 OR `dest_util_id` = 203233) 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=203233 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 = 205377 AND W.type_id = 1) OR (W.util_id != 205377 AND W.type_id = 2)) AND (`post_util_id` = 205377 OR `dest_util_id` = 205377) 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=205377 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 = 220268 AND W.type_id = 1) OR (W.util_id != 220268 AND W.type_id = 2)) AND (`post_util_id` = 220268 OR `dest_util_id` = 220268) 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=220268 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 = 258487 AND W.type_id = 1) OR (W.util_id != 258487 AND W.type_id = 2)) AND (`post_util_id` = 258487 OR `dest_util_id` = 258487) 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=258487 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 = 260135 AND W.type_id = 1) OR (W.util_id != 260135 AND W.type_id = 2)) AND (`post_util_id` = 260135 OR `dest_util_id` = 260135) 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=260135 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 = 63039 AND W.type_id = 1) OR (W.util_id != 63039 AND W.type_id = 2)) AND (`post_util_id` = 63039 OR `dest_util_id` = 63039) 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=63039 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 = 6738 AND W.type_id = 1) OR (W.util_id != 6738 AND W.type_id = 2)) AND (`post_util_id` = 6738 OR `dest_util_id` = 6738) 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=6738 AND note_visu IN (1,3,4)

162. 0.0003

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 285587 AND W.type_id = 1) OR (W.util_id != 285587 AND W.type_id = 2)) AND (`post_util_id` = 285587 OR `dest_util_id` = 285587) 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=285587 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 = 287930 AND W.type_id = 1) OR (W.util_id != 287930 AND W.type_id = 2)) AND (`post_util_id` = 287930 OR `dest_util_id` = 287930) 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=287930 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 = 142153 AND W.type_id = 1) OR (W.util_id != 142153 AND W.type_id = 2)) AND (`post_util_id` = 142153 OR `dest_util_id` = 142153) 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=142153 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 = 309026 AND W.type_id = 1) OR (W.util_id != 309026 AND W.type_id = 2)) AND (`post_util_id` = 309026 OR `dest_util_id` = 309026) 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=309026 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 = 43061 AND W.type_id = 1) OR (W.util_id != 43061 AND W.type_id = 2)) AND (`post_util_id` = 43061 OR `dest_util_id` = 43061) 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=43061 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 = 179057 AND W.type_id = 1) OR (W.util_id != 179057 AND W.type_id = 2)) AND (`post_util_id` = 179057 OR `dest_util_id` = 179057) 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=179057 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 = 196639 AND W.type_id = 1) OR (W.util_id != 196639 AND W.type_id = 2)) AND (`post_util_id` = 196639 OR `dest_util_id` = 196639) 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=196639 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 = 206436 AND W.type_id = 1) OR (W.util_id != 206436 AND W.type_id = 2)) AND (`post_util_id` = 206436 OR `dest_util_id` = 206436) 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=206436 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 = 350396 AND W.type_id = 1) OR (W.util_id != 350396 AND W.type_id = 2)) AND (`post_util_id` = 350396 OR `dest_util_id` = 350396) 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=350396 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 = 333996 AND W.type_id = 1) OR (W.util_id != 333996 AND W.type_id = 2)) AND (`post_util_id` = 333996 OR `dest_util_id` = 333996) 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=333996 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 = 356024 AND W.type_id = 1) OR (W.util_id != 356024 AND W.type_id = 2)) AND (`post_util_id` = 356024 OR `dest_util_id` = 356024) 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=356024 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 = 378017 AND W.type_id = 1) OR (W.util_id != 378017 AND W.type_id = 2)) AND (`post_util_id` = 378017 OR `dest_util_id` = 378017) 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=378017 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 = 379120 AND W.type_id = 1) OR (W.util_id != 379120 AND W.type_id = 2)) AND (`post_util_id` = 379120 OR `dest_util_id` = 379120) 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=379120 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 = 28031 AND W.type_id = 1) OR (W.util_id != 28031 AND W.type_id = 2)) AND (`post_util_id` = 28031 OR `dest_util_id` = 28031) 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=28031 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 = 28031 AND W.type_id = 1) OR (W.util_id != 28031 AND W.type_id = 2)) AND (`post_util_id` = 28031 OR `dest_util_id` = 28031) 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 = 374423 AND W.type_id = 1) OR (W.util_id != 374423 AND W.type_id = 2)) AND (`post_util_id` = 374423 OR `dest_util_id` = 374423) 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=374423 AND note_visu IN (1,3,4)

193. 0.0001

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

194. 0.0001

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

195. 0.0001

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

198. 0.0001

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

199. 0.0001

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

200. 0.0001

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

201. 0.0001

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

202. 0.0001

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

203. 0.0001

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

204. 0.0001

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

205. 0.0001

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

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

207. 0.0001

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

208. 0.0001

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

209. 0.0001

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

210. 0.0001

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

211. 0.0001

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

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

213. 0.0001

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

214. 0.0001

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

215. 0.0001

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

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

217. 0.0001

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

218. 0.0001

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

219. 0.0001

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

220. 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='518' LIMIT 0,1

221. 0.0004

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

222. 0.0003

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

223. 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='520' LIMIT 0,1

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

225. 0.0003

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

226. 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='521' LIMIT 0,1

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

228. 0.0003

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

229. 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='523' LIMIT 0,1

230. 0.0002

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

231. 0.0003

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

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

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

234. 0.0003

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

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

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

237. 0.0003

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

238. 0.0002

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

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

240. 0.0003

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

241. 0.0002

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

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

243. 0.0003

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

244. 0.0002

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

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

246. 0.0003

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

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

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

249. 0.0003

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

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

252. 0.0003

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

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

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

255. 0.0002

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

256. 0.0002

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

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

258. 0.0003

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

259. 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='523' LIMIT 0,1

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

261. 0.0002

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

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

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

264. 0.0002

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

265. 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='520' LIMIT 0,1

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

267. 0.0002

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

268. 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='516' LIMIT 0,1

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

270. 0.0003

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

271. 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='523' LIMIT 0,1

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

273. 0.0018

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

274. 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='523' LIMIT 0,1

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

276. 0.0002

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

277. 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='523' LIMIT 0,1

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

279. 0.0003

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

280. 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='523' LIMIT 0,1

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

282. 0.0003

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

283. 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='1028' LIMIT 0,1

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

285. 0.0003

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

286. 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='521' LIMIT 0,1

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

288. 0.0003

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

289. 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='1028' LIMIT 0,1

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

291. 0.0002

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

292. 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='523' LIMIT 0,1

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

294. 0.0003

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

295. 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='517' LIMIT 0,1

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

297. 0.0003

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

298. 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='523' LIMIT 0,1

299. 0.0003

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

300. 0.0003

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

301. 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='1028' LIMIT 0,1

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

303. 0.0003

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

304. 0.0001

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

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

306. 0.0003

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

307. 0.0001

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

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

309. 0.0003

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

310. 0.0001

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

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

312. 0.0003

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

313. 0.0001

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

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

315. 0.0002

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

316. 0.0001

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

317. 0.0002

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

318. 0.0002

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

319. 0.0001

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

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

321. 0.0003

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

322. 0.0001

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

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

324. 0.0002

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

325. 0.0001

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

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

327. 0.0004

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

328. 0.0001

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

329. 0.0001

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

330. 0.0003

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

331. 0.0001

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

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

333. 0.0003

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

334. 0.0001

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

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

336. 0.0002

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

337. 0.0001

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

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

339. 0.0003

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

340. 0.0003

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

341. 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='place parking; place de parking' OR ssrubr_slug like '%place parking; place de parking%' OR MATCH (ssrubr_slug) AGAINST ('(+place +parking; +place +de +parking)')) AND sk.ssrubr_id='1028' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

342. 0.0001

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

343. 0.0019

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

344. 0

     SELECT count(*) as nbwish FROM wish

345. 0.0667

     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

345 requetes sql en 0.254