Service service à la personne à 77400 Saint-thibault-des-vignes

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='services-divers'

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='77'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='77400' AND ville_nom like '%saint%thibault%des%vignes%' ORDER BY ville_population_2012 DESC LIMIT 0,1

5. 0.0001

   SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%service%a%personne%' OR ssrubr_title like '%service%a%personne%' OR ssrubr_slug like '%service%a%personne%') AND cate_id='229' 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='77400'

7. 0.0023

   SELECT ville_cp, ROUND((((acos(sin((48.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.71667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.703435678816 AND ville_latitude_deg<49.063164321184 AND ville_longitude_deg>2.4431511089253 AND ville_longitude_deg<2.9901888910747 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='service personne; service a personne'

9. 0.0012

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='229'AND MATCH (wish_title,wish_desc) AGAINST ('+service personne; service a personne*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '77400%'

10. 0.0001

    SELECT * FROM texte WHERE cate_id=229

11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='service personne; service a personne' OR ssrubr_slug='service-personne;-service-a-personne' OR (ssrubr_title like '%service personne; service a personne%')) AND cate_id='229' 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.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 (229) ORDER BY ssrubr_order ASC

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='service-a-personne' AND cate_id='229'

16. 0.0001

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

17. 0.0021

    SELECT ville_cp, ROUND((((acos(sin((48.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.71667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.703435678816 AND ville_latitude_deg<49.063164321184 AND ville_longitude_deg>2.4431511089253 AND ville_longitude_deg<2.9901888910747 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0059

    SELECT ville_cp, ROUND((((acos(sin((48.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.71667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.433639197041 AND ville_latitude_deg<49.332960802959 AND ville_longitude_deg>2.0328668758251 AND ville_longitude_deg<3.4004731241749 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0659

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='229' AND MATCH (wish_desc) AGAINST ('(+service +personne; +service +a +personne*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (77400,77400,77400,77400,77400,77400,77400,77144,77400,77600,77600,77700,77144,77410,77600,77600,77600,77360,77450,77450,77410,77600,77177,77200,77700,77410,77700,77183,77090,77164,77186,77410,77410,77700,77450,77181,77500,77450,77450,77410,77450,77270,77185,77700,77450,77420,77135,77410,77174,77450,77860,77580,77410,77410,77184,93470,77181,77680,77860,93460,93370,77410,77174,93160,77410,77100,93410,77860,77340,93190,93390,77230,93290,77100,77124,94420,77290,94350,93220,77330,77290,77165,77580,77580,77124,77220,77165,77165,93330,77580,77100,93270,77580,93320,93340,93360,94510,77230,77230,77165,77230,77610,77124,94360,77163,93250,77580,77230,94170,77470,93420,93600,94500,77124,94880,94490,94880,77220,77230,77220,77122,77990,93110,77580,94430,94120,77163,77580,77230,77165,77150,77470,94130,77150,93130,77470,94340,94100,94210,93140,77163,77610,77470,77470,77910,94380,94370,77220,77230,77610,77173,77230,77230,77910,77990,95700,93000,77515,77580,94340,77470,77230,77610)

20. 0.0647

    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.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.71667- 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='229' AND MATCH (wish_desc) AGAINST ('(+service +personne; +service +a +personne*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (77400,77400,77400,77400,77400,77400,77400,77144,77400,77600,77600,77700,77144,77410,77600,77600,77600,77360,77450,77450,77410,77600,77177,77200,77700,77410,77700,77183,77090,77164,77186,77410,77410,77700,77450,77181,77500,77450,77450,77410,77450,77270,77185,77700,77450,77420,77135,77410,77174,77450,77860,77580,77410,77410,77184,93470,77181,77680,77860,93460,93370,77410,77174,93160,77410,77100,93410,77860,77340,93190,93390,77230,93290,77100,77124,94420,77290,94350,93220,77330,77290,77165,77580,77580,77124,77220,77165,77165,93330,77580,77100,93270,77580,93320,93340,93360,94510,77230,77230,77165,77230,77610,77124,94360,77163,93250,77580,77230,94170,77470,93420,93600,94500,77124,94880,94490,94880,77220,77230,77220,77122,77990,93110,77580,94430,94120,77163,77580,77230,77165,77150,77470,94130,77150,93130,77470,94340,94100,94210,93140,77163,77610,77470,77470,77910,94380,94370,77220,77230,77610,77173,77230,77230,77910,77990,95700,93000,77515,77580,94340,77470,77230,77610) 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='77400'

22. 0.0015

    SELECT ville_cp, ROUND((((acos(sin((48.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.71667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.703435678816 AND ville_latitude_deg<49.063164321184 AND ville_longitude_deg>2.4431511089253 AND ville_longitude_deg<2.9901888910747 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0054

    SELECT ville_cp, ROUND((((acos(sin((48.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.71667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.433639197041 AND ville_latitude_deg<49.332960802959 AND ville_longitude_deg>2.0328668758251 AND ville_longitude_deg<3.4004731241749 HAVING distance <= 50 ORDER BY distance ASC

24. 0.0001

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

26. 0.0001

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

28. 0.0001

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

30. 0.0001

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

42. 0.0001

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

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

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

48. 0.0001

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

50. 0.0001

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

54. 0.0001

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

56. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 90819 AND W.type_id = 1) OR (W.util_id != 90819 AND W.type_id = 2)) AND (`post_util_id` = 90819 OR `dest_util_id` = 90819) 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=90819 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 = 127408 AND W.type_id = 1) OR (W.util_id != 127408 AND W.type_id = 2)) AND (`post_util_id` = 127408 OR `dest_util_id` = 127408) 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=127408 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 = 29520 AND W.type_id = 1) OR (W.util_id != 29520 AND W.type_id = 2)) AND (`post_util_id` = 29520 OR `dest_util_id` = 29520) 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=29520 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 = 139909 AND W.type_id = 1) OR (W.util_id != 139909 AND W.type_id = 2)) AND (`post_util_id` = 139909 OR `dest_util_id` = 139909) 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=139909 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 = 92887 AND W.type_id = 1) OR (W.util_id != 92887 AND W.type_id = 2)) AND (`post_util_id` = 92887 OR `dest_util_id` = 92887) 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=92887 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 = 143366 AND W.type_id = 1) OR (W.util_id != 143366 AND W.type_id = 2)) AND (`post_util_id` = 143366 OR `dest_util_id` = 143366) 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=143366 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 = 18482 AND W.type_id = 1) OR (W.util_id != 18482 AND W.type_id = 2)) AND (`post_util_id` = 18482 OR `dest_util_id` = 18482) 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=18482 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 = 149555 AND W.type_id = 1) OR (W.util_id != 149555 AND W.type_id = 2)) AND (`post_util_id` = 149555 OR `dest_util_id` = 149555) 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=149555 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 = 149703 AND W.type_id = 1) OR (W.util_id != 149703 AND W.type_id = 2)) AND (`post_util_id` = 149703 OR `dest_util_id` = 149703) 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=149703 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 = 127981 AND W.type_id = 1) OR (W.util_id != 127981 AND W.type_id = 2)) AND (`post_util_id` = 127981 OR `dest_util_id` = 127981) 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=127981 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 = 10531 AND W.type_id = 1) OR (W.util_id != 10531 AND W.type_id = 2)) AND (`post_util_id` = 10531 OR `dest_util_id` = 10531) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

77. 0.0001

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

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

90. 0.0001

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

100. 0.0001

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

112. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

120. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

128. 0.0001

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

131. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=11855 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 = 367606 AND W.type_id = 1) OR (W.util_id != 367606 AND W.type_id = 2)) AND (`post_util_id` = 367606 OR `dest_util_id` = 367606) 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=367606 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 = 398294 AND W.type_id = 1) OR (W.util_id != 398294 AND W.type_id = 2)) AND (`post_util_id` = 398294 OR `dest_util_id` = 398294) 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=398294 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 = 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

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

138. 0.0001

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

140. 0.0001

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

145. 0.0001

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

146. 0.0001

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

147. 0.0001

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

148. 0.0001

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

149. 0.0001

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

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

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

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

157. 0.0001

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

158. 0.0001

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

159. 0.0001

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

160. 0.0001

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

161. 0.0001

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

162. 0.0001

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

163. 0.0001

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

164. 0.0001

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

165. 0.0001

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

166. 0.0001

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

167. 0.0001

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

168. 0.0001

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

169. 0.0001

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

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

180. 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='1020' LIMIT 0,1

181. 0.0001

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

182. 0.0002

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

183. 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='1092' LIMIT 0,1

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

185. 0.0001

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

186. 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='1092' LIMIT 0,1

187. 0.0001

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

188. 0.0001

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

189. 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='1092' LIMIT 0,1

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

191. 0.0001

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

192. 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='1092' LIMIT 0,1

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

194. 0.0001

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

195. 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='1092' LIMIT 0,1

196. 0.0001

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

197. 0.0001

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

198. 0.0001

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

199. 0.0001

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

200. 0.0001

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

201. 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='1064' LIMIT 0,1

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

203. 0.0001

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

204. 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='1092' LIMIT 0,1

205. 0.0001

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

206. 0.0001

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

207. 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='1092' LIMIT 0,1

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

209. 0.0001

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

210. 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='1092' LIMIT 0,1

211. 0.0001

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

212. 0.0001

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

213. 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='1020' LIMIT 0,1

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

215. 0.0001

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

216. 0.0001

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

217. 0.0001

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

218. 0.0001

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

219. 0.0001

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

220. 0.0001

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

221. 0.0001

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

222. 0.0001

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

223. 0.0001

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

224. 0.0001

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

225. 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='1064' LIMIT 0,1

226. 0.0001

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

227. 0.0001

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

228. 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='1092' LIMIT 0,1

229. 0.0001

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

230. 0.0001

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

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

232. 0.0001

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

233. 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='1092' LIMIT 0,1

234. 0.0001

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

235. 0.0001

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

236. 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='1092' LIMIT 0,1

237. 0.0001

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

238. 0.0001

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

239. 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='1092' LIMIT 0,1

240. 0.0001

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

241. 0.0001

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

242. 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='1092' LIMIT 0,1

243. 0.0001

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

244. 0.0001

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

245. 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='1092' LIMIT 0,1

246. 0.0001

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

247. 0.0001

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

248. 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='958' LIMIT 0,1

249. 0.0001

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

250. 0.0001

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

251. 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='1092' LIMIT 0,1

252. 0.0001

     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

253. 0.0001

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

254. 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='1092' LIMIT 0,1

255. 0.0001

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

256. 0.0001

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

257. 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='1092' LIMIT 0,1

258. 0.0001

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

259. 0.0001

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

260. 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='1092' LIMIT 0,1

261. 0.0001

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

262. 0.0001

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

263. 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='1092' LIMIT 0,1

264. 0.0001

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

265. 0.0001

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

266. 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='1092' LIMIT 0,1

267. 0.0001

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

268. 0.0001

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

269. 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='1092' LIMIT 0,1

270. 0.0001

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

271. 0.0001

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

272. 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='1092' LIMIT 0,1

273. 0.0001

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

274. 0.0001

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

275. 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='1020' LIMIT 0,1

276. 0.0001

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

277. 0.0001

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

278. 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='1092' LIMIT 0,1

279. 0.0001

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

280. 0.0001

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

281. 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='1092' LIMIT 0,1

282. 0.0001

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

283. 0.0001

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

284. 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='1092' LIMIT 0,1

285. 0.0001

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

286. 0.0001

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

287. 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='1092' LIMIT 0,1

288. 0.0001

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

289. 0.0001

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

290. 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='1092' LIMIT 0,1

291. 0.0001

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

292. 0.0001

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

293. 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='1092' LIMIT 0,1

294. 0.0001

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

295. 0.0001

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

296. 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='1092' LIMIT 0,1

297. 0.0001

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

298. 0.0002

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

299. 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='1020' LIMIT 0,1

300. 0.0001

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

301. 0.0002

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

302. 0.0001

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

303. 0.0001

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

304. 0.0002

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

305. 0.0001

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

306. 0.0001

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

307. 0.0002

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

308. 0.0001

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

309. 0.0001

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

310. 0.0002

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

311. 0.0001

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

312. 0.0002

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

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

314. 0.0001

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

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

317. 0.0001

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

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

320. 0.0001

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

321. 0.0002

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

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

323. 0.0001

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

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

326. 0.0001

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

327. 0.0002

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

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

330. 0.0002

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

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

332. 0.0001

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

333. 0.0002

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

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

335. 0.0001

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

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

338. 0.0001

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

339. 0.0002

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

340. 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='1092' LIMIT 0,1

341. 0.0001

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

342. 0.0002

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

343. 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='1092' LIMIT 0,1

344. 0.0001

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

345. 0.0002

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

346. 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='1092' LIMIT 0,1

347. 0.0001

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

348. 0.0002

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

349. 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='1064' LIMIT 0,1

350. 0.0001

     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

351. 0.0002

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

352. 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='1092' LIMIT 0,1

353. 0.0001

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

354. 0.0002

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

355. 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='1092' LIMIT 0,1

356. 0.0001

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

357. 0.0002

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

358. 0.0002

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

359. 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='service personne; service a personne' OR ssrubr_slug like '%service personne; service a personne%' OR MATCH (ssrubr_slug) AGAINST ('(+service +personne; +service +a +personne)')) AND sk.ssrubr_id='1092' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

360. 0.0001

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

361. 0.0012

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

362. 0.0001

     SELECT count(*) as nbwish FROM wish

363. 0.0504

     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

363 requetes sql en 0.2386