Location monospace

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='voiture'

2. 0

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

3. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

4. 0.0018

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

5. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='monospace'

6. 0.1067

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

7. 0.0001

   SELECT * FROM texte WHERE cate_id=81

8. 0.0002

   SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='monospace' OR ssrubr_slug='monospace' OR (ssrubr_title like '%monospace%')) AND cate_id='81' 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.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 (81) ORDER BY ssrubr_order ASC

12. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='monospace' AND cate_id='81'

13. 0.0979

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

14. 0.0518

    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='81' AND MATCH (wish_desc) AGAINST ('(+monospace*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND type_id=1 GROUP BY wish_id

15. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 5420 AND W.type_id = 1) OR (W.util_id != 5420 AND W.type_id = 2)) AND (`post_util_id` = 5420 OR `dest_util_id` = 5420) 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=5420 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 = 11861 AND W.type_id = 1) OR (W.util_id != 11861 AND W.type_id = 2)) AND (`post_util_id` = 11861 OR `dest_util_id` = 11861) 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=11861 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 = 36383 AND W.type_id = 1) OR (W.util_id != 36383 AND W.type_id = 2)) AND (`post_util_id` = 36383 OR `dest_util_id` = 36383) 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=36383 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 = 67368 AND W.type_id = 1) OR (W.util_id != 67368 AND W.type_id = 2)) AND (`post_util_id` = 67368 OR `dest_util_id` = 67368) 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=67368 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 = 87325 AND W.type_id = 1) OR (W.util_id != 87325 AND W.type_id = 2)) AND (`post_util_id` = 87325 OR `dest_util_id` = 87325) 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=87325 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 = 96168 AND W.type_id = 1) OR (W.util_id != 96168 AND W.type_id = 2)) AND (`post_util_id` = 96168 OR `dest_util_id` = 96168) 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=96168 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 = 97143 AND W.type_id = 1) OR (W.util_id != 97143 AND W.type_id = 2)) AND (`post_util_id` = 97143 OR `dest_util_id` = 97143) 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=97143 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 = 101073 AND W.type_id = 1) OR (W.util_id != 101073 AND W.type_id = 2)) AND (`post_util_id` = 101073 OR `dest_util_id` = 101073) 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=101073 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 = 51616 AND W.type_id = 1) OR (W.util_id != 51616 AND W.type_id = 2)) AND (`post_util_id` = 51616 OR `dest_util_id` = 51616) 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=51616 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 = 116020 AND W.type_id = 1) OR (W.util_id != 116020 AND W.type_id = 2)) AND (`post_util_id` = 116020 OR `dest_util_id` = 116020) 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=116020 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 = 102940 AND W.type_id = 1) OR (W.util_id != 102940 AND W.type_id = 2)) AND (`post_util_id` = 102940 OR `dest_util_id` = 102940) 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=102940 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 = 93459 AND W.type_id = 1) OR (W.util_id != 93459 AND W.type_id = 2)) AND (`post_util_id` = 93459 OR `dest_util_id` = 93459) 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=93459 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 = 161432 AND W.type_id = 1) OR (W.util_id != 161432 AND W.type_id = 2)) AND (`post_util_id` = 161432 OR `dest_util_id` = 161432) 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=161432 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 = 173173 AND W.type_id = 1) OR (W.util_id != 173173 AND W.type_id = 2)) AND (`post_util_id` = 173173 OR `dest_util_id` = 173173) 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=173173 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 = 82492 AND W.type_id = 1) OR (W.util_id != 82492 AND W.type_id = 2)) AND (`post_util_id` = 82492 OR `dest_util_id` = 82492) 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=82492 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 = 199097 AND W.type_id = 1) OR (W.util_id != 199097 AND W.type_id = 2)) AND (`post_util_id` = 199097 OR `dest_util_id` = 199097) 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=199097 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 = 207495 AND W.type_id = 1) OR (W.util_id != 207495 AND W.type_id = 2)) AND (`post_util_id` = 207495 OR `dest_util_id` = 207495) 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=207495 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 = 209066 AND W.type_id = 1) OR (W.util_id != 209066 AND W.type_id = 2)) AND (`post_util_id` = 209066 OR `dest_util_id` = 209066) 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=209066 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 = 50195 AND W.type_id = 1) OR (W.util_id != 50195 AND W.type_id = 2)) AND (`post_util_id` = 50195 OR `dest_util_id` = 50195) 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=50195 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 = 98311 AND W.type_id = 1) OR (W.util_id != 98311 AND W.type_id = 2)) AND (`post_util_id` = 98311 OR `dest_util_id` = 98311) 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=98311 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 = 234917 AND W.type_id = 1) OR (W.util_id != 234917 AND W.type_id = 2)) AND (`post_util_id` = 234917 OR `dest_util_id` = 234917) 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=234917 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 = 247275 AND W.type_id = 1) OR (W.util_id != 247275 AND W.type_id = 2)) AND (`post_util_id` = 247275 OR `dest_util_id` = 247275) 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=247275 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 = 258002 AND W.type_id = 1) OR (W.util_id != 258002 AND W.type_id = 2)) AND (`post_util_id` = 258002 OR `dest_util_id` = 258002) 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=258002 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 = 269958 AND W.type_id = 1) OR (W.util_id != 269958 AND W.type_id = 2)) AND (`post_util_id` = 269958 OR `dest_util_id` = 269958) 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=269958 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 = 274547 AND W.type_id = 1) OR (W.util_id != 274547 AND W.type_id = 2)) AND (`post_util_id` = 274547 OR `dest_util_id` = 274547) 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=274547 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 = 274547 AND W.type_id = 1) OR (W.util_id != 274547 AND W.type_id = 2)) AND (`post_util_id` = 274547 OR `dest_util_id` = 274547) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

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

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

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

90. 0.0001

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

91. 0.0001

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

92. 0.0001

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

93. 0.0001

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

94. 0.0001

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

95. 0.0001

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

96. 0.0001

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

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

105. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 190919 AND W.type_id = 1) OR (W.util_id != 190919 AND W.type_id = 2)) AND (`post_util_id` = 190919 OR `dest_util_id` = 190919) 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=190919 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 = 443598 AND W.type_id = 1) OR (W.util_id != 443598 AND W.type_id = 2)) AND (`post_util_id` = 443598 OR `dest_util_id` = 443598) 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=443598 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 = 418346 AND W.type_id = 1) OR (W.util_id != 418346 AND W.type_id = 2)) AND (`post_util_id` = 418346 OR `dest_util_id` = 418346) 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=418346 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 = 450377 AND W.type_id = 1) OR (W.util_id != 450377 AND W.type_id = 2)) AND (`post_util_id` = 450377 OR `dest_util_id` = 450377) 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=450377 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 = 454156 AND W.type_id = 1) OR (W.util_id != 454156 AND W.type_id = 2)) AND (`post_util_id` = 454156 OR `dest_util_id` = 454156) 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=454156 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 = 454800 AND W.type_id = 1) OR (W.util_id != 454800 AND W.type_id = 2)) AND (`post_util_id` = 454800 OR `dest_util_id` = 454800) 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=454800 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 = 457611 AND W.type_id = 1) OR (W.util_id != 457611 AND W.type_id = 2)) AND (`post_util_id` = 457611 OR `dest_util_id` = 457611) 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=457611 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 = 303159 AND W.type_id = 1) OR (W.util_id != 303159 AND W.type_id = 2)) AND (`post_util_id` = 303159 OR `dest_util_id` = 303159) 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=303159 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 = 39836 AND W.type_id = 1) OR (W.util_id != 39836 AND W.type_id = 2)) AND (`post_util_id` = 39836 OR `dest_util_id` = 39836) 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=39836 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 = 477364 AND W.type_id = 1) OR (W.util_id != 477364 AND W.type_id = 2)) AND (`post_util_id` = 477364 OR `dest_util_id` = 477364) 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=477364 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 = 482807 AND W.type_id = 1) OR (W.util_id != 482807 AND W.type_id = 2)) AND (`post_util_id` = 482807 OR `dest_util_id` = 482807) 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=482807 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 = 483227 AND W.type_id = 1) OR (W.util_id != 483227 AND W.type_id = 2)) AND (`post_util_id` = 483227 OR `dest_util_id` = 483227) 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=483227 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 = 500629 AND W.type_id = 1) OR (W.util_id != 500629 AND W.type_id = 2)) AND (`post_util_id` = 500629 OR `dest_util_id` = 500629) 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=500629 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 = 403571 AND W.type_id = 1) OR (W.util_id != 403571 AND W.type_id = 2)) AND (`post_util_id` = 403571 OR `dest_util_id` = 403571) 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=403571 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 = 517176 AND W.type_id = 1) OR (W.util_id != 517176 AND W.type_id = 2)) AND (`post_util_id` = 517176 OR `dest_util_id` = 517176) 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=517176 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 = 520627 AND W.type_id = 1) OR (W.util_id != 520627 AND W.type_id = 2)) AND (`post_util_id` = 520627 OR `dest_util_id` = 520627) 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=520627 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 = 521193 AND W.type_id = 1) OR (W.util_id != 521193 AND W.type_id = 2)) AND (`post_util_id` = 521193 OR `dest_util_id` = 521193) 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=521193 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 = 543038 AND W.type_id = 1) OR (W.util_id != 543038 AND W.type_id = 2)) AND (`post_util_id` = 543038 OR `dest_util_id` = 543038) 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=543038 AND note_visu IN (1,3,4)

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

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

143. 0.0001

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

144. 0.0008

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

145. 0

     SELECT count(*) as nbwish FROM wish

146. 0.0488

     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

146 requetes sql en 0.3218