Location visseuse à 78600 Maisons-laffitte

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='materiel-bricolage'

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='78600' AND ville_nom like '%maisons%laffitte%' ORDER BY ville_population_2012 DESC LIMIT 0,1

5. 0.0002

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

6. 0.0001

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

7. 0.0021

   SELECT ville_cp, ROUND((((acos(sin((48.9367*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9367*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.12667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.756835678816 AND ville_latitude_deg<49.116564321184 AND ville_longitude_deg>1.8528586279748 AND ville_longitude_deg<2.4004813720252 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='visseuse'

9. 0.0004

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='87'AND MATCH (wish_title,wish_desc) AGAINST ('+visseuse*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '78600%'

10. 0.0001

    SELECT * FROM texte WHERE cate_id=87

11. 0.0004

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='visseuse' OR ssrubr_slug='visseuse' OR (ssrubr_title like '%visseuse%')) AND cate_id='87' ORDER BY ssrubr_id LIMIT 0,1

12. 0.0001

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

13. 0.0002

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

14. 0.0003

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

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='visseuse' AND cate_id='87'

16. 0.0001

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

17. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.9367*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9367*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.12667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.756835678816 AND ville_latitude_deg<49.116564321184 AND ville_longitude_deg>1.8528586279748 AND ville_longitude_deg<2.4004813720252 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0061

    SELECT ville_cp, ROUND((((acos(sin((48.9367*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9367*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.12667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.487039197041 AND ville_latitude_deg<49.386360802959 AND ville_longitude_deg>1.4421356671438 AND ville_longitude_deg<2.8112043328562 HAVING distance <= 50 ORDER BY distance ASC

19. 0.1209

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='87' AND MATCH (wish_desc) AGAINST ('(+visseuse*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (78600,78600,78600,78360,78110,78500,78230,78420,78100,95530,78260,78700,78300,78800,78560,78400,95870,95370,78750,92000,78570,78955,78112,95240,95220,78290,78380,78430,78240,92500,78780,78160,78570,78620,78240,95610,95100,92700,95130,95480,78670,78670,95110,78170,92250,95000,78870,92400,95250,92270,95130,78590,78510,78630,78540,92150,92800,95280,92380,95120,78150,95000,78480,92200,95218,95210,92600,92420,92430,92300,78150,92210,78860,95150,95550,95310,95320,92230,95490,95300,78590,95000,92410,92110,93800,95600,95390,95230,95180,78450,78810,78630,95800,95740,78450,95880,92310,78330,95580,95580,95680,78130,95300,92100,78740,95430,95650,93450,92390,95520,78000,78121,78920,95540,95840,78220,78580,93400,78740,78140,78210,93430,95170,95650,92370,78810,95560,95840,92360,92190,95360,95160,95450,92130,78130,78410,95650,93210,93200,78340,95410,92170,95430,95630,78390,78250,93380,95570,78250,95450,75019,75006,75018,75017,75016,75015,75014,75013,75012,75011,75010,75020,75116,75001,75000,75002,75007,75003,75009,75004,75005,75008,78850,95300,78580,95300,92140,92240,95330,78370,95350,95650,95650,78250,93240,93300,93120,95350,78530,78350,95760,78580,92320,78350,95560,92120,78410,78250,95450,78280,78190,78124,95570,78250,92220,92350,95590,78124)

20. 0.1003

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9367*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9367*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.12667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='87' AND MATCH (wish_desc) AGAINST ('(+visseuse*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (78600,78600,78600,78360,78110,78500,78230,78420,78100,95530,78260,78700,78300,78800,78560,78400,95870,95370,78750,92000,78570,78955,78112,95240,95220,78290,78380,78430,78240,92500,78780,78160,78570,78620,78240,95610,95100,92700,95130,95480,78670,78670,95110,78170,92250,95000,78870,92400,95250,92270,95130,78590,78510,78630,78540,92150,92800,95280,92380,95120,78150,95000,78480,92200,95218,95210,92600,92420,92430,92300,78150,92210,78860,95150,95550,95310,95320,92230,95490,95300,78590,95000,92410,92110,93800,95600,95390,95230,95180,78450,78810,78630,95800,95740,78450,95880,92310,78330,95580,95580,95680,78130,95300,92100,78740,95430,95650,93450,92390,95520,78000,78121,78920,95540,95840,78220,78580,93400,78740,78140,78210,93430,95170,95650,92370,78810,95560,95840,92360,92190,95360,95160,95450,92130,78130,78410,95650,93210,93200,78340,95410,92170,95430,95630,78390,78250,93380,95570,78250,95450,75019,75006,75018,75017,75016,75015,75014,75013,75012,75011,75010,75020,75116,75001,75000,75002,75007,75003,75009,75004,75005,75008,78850,95300,78580,95300,92140,92240,95330,78370,95350,95650,95650,78250,93240,93300,93120,95350,78530,78350,95760,78580,92320,78350,95560,92120,78410,78250,95450,78280,78190,78124,95570,78250,92220,92350,95590,78124) AND type_id=1 GROUP BY wish_id

21. 0.0001

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

22. 0.0019

    SELECT ville_cp, ROUND((((acos(sin((48.9367*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9367*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.12667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.756835678816 AND ville_latitude_deg<49.116564321184 AND ville_longitude_deg>1.8528586279748 AND ville_longitude_deg<2.4004813720252 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0058

    SELECT ville_cp, ROUND((((acos(sin((48.9367*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9367*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.12667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.487039197041 AND ville_latitude_deg<49.386360802959 AND ville_longitude_deg>1.4421356671438 AND ville_longitude_deg<2.8112043328562 HAVING distance <= 50 ORDER BY distance ASC

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

25. 0.0001

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

26. 0.0001

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

27. 0.0001

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

28. 0.0001

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

29. 0.0001

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

30. 0.0001

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

31. 0.0001

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

32. 0.0001

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

33. 0.0001

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

34. 0.0001

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

35. 0.0001

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

36. 0.0007

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

37. 0.0001

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

38. 0.0001

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

39. 0.0001

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

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

43. 0.0001

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

44. 0.0002

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

45. 0.0001

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

46. 0.0001

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

47. 0.0001

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

48. 0.0001

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

49. 0.0001

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

50. 0.0001

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

51. 0.0001

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

52. 0.0001

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

53. 0.0001

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

54. 0.0001

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

55. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

65. 0.0001

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

66. 0.0001

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

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

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

81. 0.0001

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

87. 0.0003

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

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

101. 0.0001

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

102. 0.0001

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

103. 0.0001

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

105. 0.0001

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

106. 0.0001

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

107. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

129. 0.0001

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

130. 0.0001

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

131. 0.0006

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

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

138. 0.0001

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

139. 0.0001

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

140. 0.0001

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

141. 0.0001

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

142. 0.0001

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

143. 0.0001

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

144. 0.0001

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

145. 0.0001

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

146. 0.0001

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

148. 0.0001

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

149. 0.0001

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

150. 0.0001

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

152. 0.0001

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

153. 0.0001

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

154. 0.0001

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

156. 0.0001

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

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

158. 0.0001

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

160. 0.0001

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

161. 0.0001

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

162. 0.0001

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

163. 0.0001

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

164. 0.0001

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

165. 0.0001

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

166. 0.0001

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

167. 0.0001

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

168. 0.0001

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

169. 0.0001

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

170. 0.0001

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

171. 0.0001

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

172. 0.0001

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

173. 0.0003

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

174. 0.0001

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

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

176. 0.0001

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

177. 0.0001

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

178. 0.0001

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

179. 0.0001

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

180. 0.0001

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

181. 0.0001

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

182. 0.0001

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

183. 0.0001

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

184. 0.0001

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

185. 0.0001

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

186. 0.0001

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

187. 0.0001

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

188. 0.0001

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

189. 0.0001

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

190. 0.0001

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

191. 0.0001

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

192. 0.0001

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

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

194. 0.0001

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

195. 0.0001

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

196. 0.0001

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

197. 0.0001

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

198. 0.0001

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

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

200. 0.0001

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

201. 0.0004

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

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

203. 0.0001

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

204. 0.0016

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

205. 0

     SELECT count(*) as nbwish FROM wish

206. 0.0513

     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

206 requetes sql en 0.3148