Service bricoleur à 83 Var

1. 0.0001

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

2. 0

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

3. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='83'

4. 0.0002

   SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug, ssrubr_mail FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND c.cate_title_slug='bricolage' AND ss.fami_id=3 ORDER BY ssrubr_order

5. 0.0035

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='50' AND wish_visu IN (1,6,10) AND wish_cp like '83%'

6. 0

   SELECT * FROM texte WHERE cate_id=50

7. 0.0001

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

8. 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

9. 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 (50) ORDER BY ssrubr_order ASC

10. 0.0043

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='50' AND wish_visu IN (1,6,10) AND wish_cp like '83%'

11. 0.0363

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='50' AND wish_visu IN (1,6,10) AND wish_cp like '83%' AND type_id=1 GROUP BY wish_id ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,60

12. 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

13. 0.0001

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

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

15. 0.0002

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

16. 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

17. 0.0001

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

18. 0.0001

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

19. 0.0001

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

20. 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='590' LIMIT 0,1

21. 0.0001

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

22. 0.0001

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

23. 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='583' LIMIT 0,1

24. 0.0001

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

25. 0.0001

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

26. 0.0001

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

27. 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='964' LIMIT 0,1

28. 0.0001

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

29. 0.0001

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

30. 0.0002

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

31. 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='596' LIMIT 0,1

32. 0.0001

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

33. 0.0001

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

34. 0.0002

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

35. 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='583' LIMIT 0,1

36. 0.0001

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

37. 0.0001

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

38. 0.0002

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

39. 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='600' LIMIT 0,1

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

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

44. 0.0001

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

45. 0.0001

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

46. 0.0001

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

47. 0

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

48. 0.0001

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

49. 0.0001

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

50. 0.0001

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

51. 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

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

53. 0.0001

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

54. 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

55. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=486711 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 = 486711 AND W.type_id = 1) OR (W.util_id != 486711 AND W.type_id = 2)) AND (`post_util_id` = 486711 OR `dest_util_id` = 486711) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

57. 0.0001

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

58. 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='962' LIMIT 0,1

59. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=485171 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 = 485171 AND W.type_id = 1) OR (W.util_id != 485171 AND W.type_id = 2)) AND (`post_util_id` = 485171 OR `dest_util_id` = 485171) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

61. 0.0001

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

62. 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='964' LIMIT 0,1

63. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=484631 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 = 484631 AND W.type_id = 1) OR (W.util_id != 484631 AND W.type_id = 2)) AND (`post_util_id` = 484631 OR `dest_util_id` = 484631) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

65. 0.0001

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

66. 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='962' LIMIT 0,1

67. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=482120 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 = 482120 AND W.type_id = 1) OR (W.util_id != 482120 AND W.type_id = 2)) AND (`post_util_id` = 482120 OR `dest_util_id` = 482120) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

69. 0.0001

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

70. 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

71. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=481847 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 = 481847 AND W.type_id = 1) OR (W.util_id != 481847 AND W.type_id = 2)) AND (`post_util_id` = 481847 OR `dest_util_id` = 481847) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

73. 0.0001

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

74. 0

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

75. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=479579 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 = 479579 AND W.type_id = 1) OR (W.util_id != 479579 AND W.type_id = 2)) AND (`post_util_id` = 479579 OR `dest_util_id` = 479579) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

77. 0.0001

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

78. 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='600' LIMIT 0,1

79. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=477495 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 = 477495 AND W.type_id = 1) OR (W.util_id != 477495 AND W.type_id = 2)) AND (`post_util_id` = 477495 OR `dest_util_id` = 477495) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

81. 0.0001

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

82. 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='602' LIMIT 0,1

83. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=476184 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 = 476184 AND W.type_id = 1) OR (W.util_id != 476184 AND W.type_id = 2)) AND (`post_util_id` = 476184 OR `dest_util_id` = 476184) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

85. 0.0001

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

86. 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='592' LIMIT 0,1

87. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=476075 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 = 476075 AND W.type_id = 1) OR (W.util_id != 476075 AND W.type_id = 2)) AND (`post_util_id` = 476075 OR `dest_util_id` = 476075) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

89. 0.0001

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

90. 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='587' LIMIT 0,1

91. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=473305 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 = 473305 AND W.type_id = 1) OR (W.util_id != 473305 AND W.type_id = 2)) AND (`post_util_id` = 473305 OR `dest_util_id` = 473305) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

93. 0.0001

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

94. 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

95. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=468558 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 = 468558 AND W.type_id = 1) OR (W.util_id != 468558 AND W.type_id = 2)) AND (`post_util_id` = 468558 OR `dest_util_id` = 468558) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

97. 0.0001

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

98. 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='602' LIMIT 0,1

99. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=468375 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 = 468375 AND W.type_id = 1) OR (W.util_id != 468375 AND W.type_id = 2)) AND (`post_util_id` = 468375 OR `dest_util_id` = 468375) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

101. 0.0001

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

102. 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='583' LIMIT 0,1

103. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=465018 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 = 465018 AND W.type_id = 1) OR (W.util_id != 465018 AND W.type_id = 2)) AND (`post_util_id` = 465018 OR `dest_util_id` = 465018) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

105. 0.0001

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

106. 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='600' LIMIT 0,1

107. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=464292 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 = 464292 AND W.type_id = 1) OR (W.util_id != 464292 AND W.type_id = 2)) AND (`post_util_id` = 464292 OR `dest_util_id` = 464292) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

109. 0.0001

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

110. 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='584' LIMIT 0,1

111. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=462694 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 = 462694 AND W.type_id = 1) OR (W.util_id != 462694 AND W.type_id = 2)) AND (`post_util_id` = 462694 OR `dest_util_id` = 462694) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

113. 0.0001

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

114. 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

115. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=383753 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 = 383753 AND W.type_id = 1) OR (W.util_id != 383753 AND W.type_id = 2)) AND (`post_util_id` = 383753 OR `dest_util_id` = 383753) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

117. 0.0001

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

118. 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

119. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=461419 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 = 461419 AND W.type_id = 1) OR (W.util_id != 461419 AND W.type_id = 2)) AND (`post_util_id` = 461419 OR `dest_util_id` = 461419) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

121. 0.0001

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

122. 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='600' LIMIT 0,1

123. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=105653 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 = 105653 AND W.type_id = 1) OR (W.util_id != 105653 AND W.type_id = 2)) AND (`post_util_id` = 105653 OR `dest_util_id` = 105653) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

125. 0.0001

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

126. 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

127. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=447232 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 = 447232 AND W.type_id = 1) OR (W.util_id != 447232 AND W.type_id = 2)) AND (`post_util_id` = 447232 OR `dest_util_id` = 447232) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

129. 0.0001

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

130. 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='600' LIMIT 0,1

131. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=439202 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 = 439202 AND W.type_id = 1) OR (W.util_id != 439202 AND W.type_id = 2)) AND (`post_util_id` = 439202 OR `dest_util_id` = 439202) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

133. 0.0001

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

134. 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='601' LIMIT 0,1

135. 0.0001

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

136. 0.0001

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

137. 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='600' LIMIT 0,1

138. 0.0001

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

139. 0.0001

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

140. 0.0001

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

141. 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='600' LIMIT 0,1

142. 0.0001

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

143. 0.0001

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

144. 0.0001

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

145. 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='600' LIMIT 0,1

146. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=226912 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 = 226912 AND W.type_id = 1) OR (W.util_id != 226912 AND W.type_id = 2)) AND (`post_util_id` = 226912 OR `dest_util_id` = 226912) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

148. 0.0001

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

149. 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

150. 0.0001

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

151. 0.0001

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

152. 0.0001

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

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

154. 0.0001

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

155. 0.0001

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

156. 0.0001

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

157. 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='602' LIMIT 0,1

158. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=424144 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 = 424144 AND W.type_id = 1) OR (W.util_id != 424144 AND W.type_id = 2)) AND (`post_util_id` = 424144 OR `dest_util_id` = 424144) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

160. 0.0001

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

161. 0

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

162. 0.0001

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

163. 0.0001

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

164. 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='583' LIMIT 0,1

165. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=420970 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 = 420970 AND W.type_id = 1) OR (W.util_id != 420970 AND W.type_id = 2)) AND (`post_util_id` = 420970 OR `dest_util_id` = 420970) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

167. 0.0001

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

168. 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='600' LIMIT 0,1

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

172. 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='1081' LIMIT 0,1

173. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=415930 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 = 415930 AND W.type_id = 1) OR (W.util_id != 415930 AND W.type_id = 2)) AND (`post_util_id` = 415930 OR `dest_util_id` = 415930) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

175. 0.0001

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

176. 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='1157' LIMIT 0,1

177. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=357907 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 = 357907 AND W.type_id = 1) OR (W.util_id != 357907 AND W.type_id = 2)) AND (`post_util_id` = 357907 OR `dest_util_id` = 357907) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

179. 0.0001

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

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

181. 0.0001

     SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=401371 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 = 401371 AND W.type_id = 1) OR (W.util_id != 401371 AND W.type_id = 2)) AND (`post_util_id` = 401371 OR `dest_util_id` = 401371) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

183. 0.0001

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

184. 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='604' LIMIT 0,1

185. 0.0001

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

186. 0.0001

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

187. 0.0001

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

188. 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='599' LIMIT 0,1

189. 0.0001

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

190. 0.0001

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

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

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

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

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

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

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

208. 0.0001

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

209. 0.0001

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

210. 0.0001

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

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

212. 0.0001

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

213. 0.0001

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

214. 0.0001

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

215. 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='600' LIMIT 0,1

216. 0.0001

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

217. 0.0001

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

218. 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='604' LIMIT 0,1

219. 0.0001

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

220. 0.0001

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

221. 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='600' LIMIT 0,1

222. 0.0001

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

223. 0.0001

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

224. 0.0001

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

225. 0.0001

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

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

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

229. 0.0001

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

230. 0.0001

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

231. 0.0001

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

232. 0.0001

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

233. 0.0001

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

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

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

237. 0.0001

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

238. 0.0001

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

239. 0.0001

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

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

241. 0.0001

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

242. 0.0001

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

243. 0.0008

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

244. 0

     SELECT count(*) as nbwish FROM wish

245. 0.0568

     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

245 requetes sql en 0.1259