Location matelas de voyage

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='equipement-voyage'

2. 0

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

3. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

4. 0.0001

   SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%matelas%de%voyage%' OR ssrubr_title like '%matelas%de%voyage%' OR ssrubr_slug like '%matelas%de%voyage%') AND cate_id='93' ORDER BY ssrubr_id LIMIT 0,1

5. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='matelas; matelas de voyage'

6. 0.0105

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='93'AND MATCH (wish_title,wish_desc) AGAINST ('+matelas; matelas de voyage*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10)

7. 0.0001

   SELECT * FROM texte WHERE cate_id=93

8. 0.0001

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

9. 0.0001

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

10. 0.0001

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

11. 0.0001

    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 (93) ORDER BY ssrubr_order ASC

12. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='matelas-de-voyage' AND cate_id='93'

13. 0.0094

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='93' AND MATCH (wish_desc) AGAINST ('(+matelas; +matelas +de +voyage*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10)

14. 0.0164

    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='5' AND cate_id='93' AND MATCH (wish_desc) AGAINST ('(+matelas; +matelas +de +voyage*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND type_id=1 GROUP BY wish_id

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

16. 0.0001

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

17. 0.0001

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

18. 0.0001

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

19. 0.0001

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

20. 0.0001

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

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

22. 0.0001

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

23. 0.0001

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

24. 0.0001

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

26. 0.0001

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

27. 0.0001

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

28. 0.0001

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

30. 0.0001

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

31. 0.0001

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

32. 0.0001

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

34. 0.0001

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

35. 0.0001

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

36. 0.0001

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

38. 0.0001

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

39. 0.0001

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

40. 0.0001

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

42. 0.0001

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

43. 0.0001

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

44. 0.0001

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

46. 0.0001

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

47. 0.0001

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

48. 0.0001

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

50. 0.0001

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

51. 0.0001

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

52. 0.0001

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

53. 0.0001

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

54. 0.0001

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

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

65. 0.0001

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

66. 0.0001

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

67. 0.0001

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

68. 0.0001

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

69. 0.0001

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

70. 0.0001

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

71. 0.0001

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

72. 0.0001

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

73. 0.0001

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

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

82. 0.0001

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

89. 0.0001

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

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

100. 0.0001

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

101. 0.0001

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

102. 0.0001

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

103. 0.0001

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

104. 0.0001

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

105. 0.0002

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

106. 0.0001

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

120. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

128. 0.0001

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

129. 0.0001

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

130. 0.0001

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

131. 0.0001

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

132. 0.0001

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

133. 0.0001

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

134. 0.0001

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

135. 0.0001

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

136. 0.0001

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

137. 0.0001

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

138. 0.0001

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

140. 0.0001

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

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

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

143. 0.0002

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

144. 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='916' LIMIT 0,1

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

146. 0.0001

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

147. 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='916' LIMIT 0,1

148. 0.0001

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

149. 0.0001

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

150. 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='916' LIMIT 0,1

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

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

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

155. 0.0001

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

156. 0.0008

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

157. 0

     SELECT count(*) as nbwish FROM wish

158. 0.0484

     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

158 requetes sql en 0.1011