Service multi services à 77290 Mitry-mory

1. 0.0001

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

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='77'

4. 0.0002

   SELECT ville_nom FROM villes WHERE ville_cp='77290' AND ville_nom like '%mitry%mory%' 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 '%multi%services%' OR ssrubr_title like '%multi%services%' OR ssrubr_slug like '%multi%services%') AND cate_id='50' ORDER BY ssrubr_id LIMIT 0,1

6. 0.0001

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

7. 0.0025

   SELECT ville_cp, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.803435678816 AND ville_latitude_deg<49.163164321184 AND ville_longitude_deg>2.3426026854937 AND ville_longitude_deg<2.8907373145063 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='multi services'

9. 0.0004

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

10. 0.0001

    SELECT * FROM texte WHERE cate_id=50

11. 0.0003

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

12. 0.0001

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

13. 0.0002

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

14. 0.0013

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

15. 0.0001

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

16. 0.0001

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

17. 0.0025

    SELECT ville_cp, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.803435678816 AND ville_latitude_deg<49.163164321184 AND ville_longitude_deg>2.3426026854937 AND ville_longitude_deg<2.8907373145063 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0083

    SELECT ville_cp, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.533639197041 AND ville_latitude_deg<49.432960802959 AND ville_longitude_deg>1.9314958054235 AND ville_longitude_deg<3.3018441945765 HAVING distance <= 50 ORDER BY distance ASC

19. 0.1346

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='50' AND MATCH (wish_desc) AGAINST ('(+multi +services*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (77290,77290,77990,77290,77410,93290,77230,77270,77230,77990,77410,93420,77410,77230,93410,77410,95380,77181,77230,95700,77410,93470,77181,93600,77230,93270,77230,77230,93390,93190,95380,77230,77230,77230,95380,95500,93370,95470,95380,77410,77410,77230,77165,77410,95500,77500,77177,95190,77165,95470,77400,93340,93320,77230,77280,77400,77410,95500,77165,77165,60330,93220,77410,77360,60128,77230,77450,77400,93700,77410,93150,95380,93460,95500,77400,95470,60950,95720,77450,95670,77400,93250,95190,77400,93140,77165,95400,95140,60330,77186,77420,77400,93360,60128,77200,93440,93160,95190,77450,93000,77600,93130,77700,95720,77144,77450,93350,77600,77600,77600,93330,95470,93110,77144,77122,77124,95850,77178,77700,95850,77185,77600,95270,60330,77090,77183,94170,95200,95400,77178,77450,94350,93230,93260,95440,93240,95720,77450,94120,60520,60950,95270,95270,60560,94360,77124,95720,95350,77450,95270,93380,93500,77184,77165,77165,93300,93120,60950,77100,77124,60330,93100,60520,94420,95460,77100,77164,60520,77700,77600,94130,93310,77450,77124,95410,93170,77700,95360,93210,93200,77910,95350,94500,95270,60440,94300)

20. 0.0807

    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.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='50' AND MATCH (wish_desc) AGAINST ('(+multi +services*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (77290,77290,77990,77290,77410,93290,77230,77270,77230,77990,77410,93420,77410,77230,93410,77410,95380,77181,77230,95700,77410,93470,77181,93600,77230,93270,77230,77230,93390,93190,95380,77230,77230,77230,95380,95500,93370,95470,95380,77410,77410,77230,77165,77410,95500,77500,77177,95190,77165,95470,77400,93340,93320,77230,77280,77400,77410,95500,77165,77165,60330,93220,77410,77360,60128,77230,77450,77400,93700,77410,93150,95380,93460,95500,77400,95470,60950,95720,77450,95670,77400,93250,95190,77400,93140,77165,95400,95140,60330,77186,77420,77400,93360,60128,77200,93440,93160,95190,77450,93000,77600,93130,77700,95720,77144,77450,93350,77600,77600,77600,93330,95470,93110,77144,77122,77124,95850,77178,77700,95850,77185,77600,95270,60330,77090,77183,94170,95200,95400,77178,77450,94350,93230,93260,95440,93240,95720,77450,94120,60520,60950,95270,95270,60560,94360,77124,95720,95350,77450,95270,93380,93500,77184,77165,77165,93300,93120,60950,77100,77124,60330,93100,60520,94420,95460,77100,77164,60520,77700,77600,94130,93310,77450,77124,95410,93170,77700,95360,93210,93200,77910,95350,94500,95270,60440,94300) 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='77290'

22. 0.0041

    SELECT ville_cp, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.803435678816 AND ville_latitude_deg<49.163164321184 AND ville_longitude_deg>2.3426026854937 AND ville_longitude_deg<2.8907373145063 HAVING distance <= 20 ORDER BY distance ASC

23. 0.01

    SELECT ville_cp, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.533639197041 AND ville_latitude_deg<49.432960802959 AND ville_longitude_deg>1.9314958054235 AND ville_longitude_deg<3.3018441945765 HAVING distance <= 50 ORDER BY distance ASC

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

25. 0.0001

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

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

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

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

37. 0.0001

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

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

39. 0.0001

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

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

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

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

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

53. 0.0001

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

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

55. 0.0001

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

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

59. 0.0001

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

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

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

63. 0.0001

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

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

70. 0.0001

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

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

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

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

77. 0.0001

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

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

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

89. 0.0001

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

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

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

94. 0.0001

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

96. 0.0001

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

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

100. 0.0001

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

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

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

104. 0.0001

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

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

108. 0.0001

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

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

112. 0.0001

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

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

114. 0.0001

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

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

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

118. 0.0001

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

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

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

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

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

145. 0.0001

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

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

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

149. 0.0001

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

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

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

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

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

160. 0.0002

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

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

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

169. 0.0001

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

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

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

177. 0.0001

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

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

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

181. 0.0001

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

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

185. 0.0001

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

186. 0.0001

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

187. 0.0001

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

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

189. 0.0003

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

190. 0.0001

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

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

192. 0.0002

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

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

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

195. 0.0002

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

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

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

198. 0.0003

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

199. 0.0001

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

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

201. 0.0002

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

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

203. 0.0002

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

204. 0.0002

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

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

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

207. 0.0002

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

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

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

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

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

213. 0.0002

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

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

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

216. 0.0002

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

217. 0.0001

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

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

219. 0.0002

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

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

221. 0.0001

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

222. 0.0002

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

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

224. 0.0001

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

225. 0.0002

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

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

228. 0.0002

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

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

230. 0.0002

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

231. 0.0001

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

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

233. 0.0002

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

234. 0.0001

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

235. 0.0001

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

236. 0.0002

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

237. 0.0001

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

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

239. 0.0002

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

240. 0.0001

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

241. 0.0001

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

242. 0.0002

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

243. 0.0001

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

244. 0.0001

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

245. 0.0002

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

246. 0.0001

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

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

248. 0.0002

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

249. 0.0001

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

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

251. 0.0002

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

252. 0.0001

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

253. 0.0003

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

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

255. 0.0004

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

256. 0.0001

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

257. 0.0011

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

258. 0

     SELECT count(*) as nbwish FROM wish

259. 0.065

     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

259 requetes sql en 0.3449