Location karcher à 93600 Aulnay-sous-bois

1. 0.0001

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

2. 0

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

3. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='93'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='93600' AND ville_nom like '%aulnay%sous%bois%' ORDER BY ville_population_2012 DESC LIMIT 0,1

5. 0.0001

   SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%nettoyeur%haute%pression%' OR ssrubr_title like '%nettoyeur%haute%pression%' OR ssrubr_slug like '%nettoyeur%haute%pression%') AND cate_id='110' 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='93600'

7. 0.002

   SELECT ville_cp, ROUND((((acos(sin((48.95*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.95*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.770135678816 AND ville_latitude_deg<49.129864321184 AND ville_longitude_deg>2.2427856472466 AND ville_longitude_deg<2.7905543527534 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='nettoyeur haute pression'

9. 0.001

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

10. 0.0001

    SELECT * FROM texte WHERE cate_id=110

11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='nettoyeur haute pression' OR ssrubr_slug='nettoyeur-haute-pression' OR (ssrubr_title like '%nettoyeur haute pression%')) AND cate_id='110' 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.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

14. 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 (110) ORDER BY ssrubr_order ASC

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='nettoyeur-haute-pression' AND cate_id='110'

16. 0

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

17. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.95*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.95*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.770135678816 AND ville_latitude_deg<49.129864321184 AND ville_longitude_deg>2.2427856472466 AND ville_longitude_deg<2.7905543527534 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0055

    SELECT ville_cp, ROUND((((acos(sin((48.95*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.95*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.500339197041 AND ville_latitude_deg<49.399660802959 AND ville_longitude_deg>1.8319532137498 AND ville_longitude_deg<3.2013867862502 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0602

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='110' AND MATCH (wish_desc) AGAINST ('(+nettoyeur +haute +pression*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (93600,93600,93270,93420,93410,93290,93190,93390,93700,93150,93340,93320,95700,95500,95500,77181,93470,95500,95500,93140,93370,93440,93000,93250,93220,95140,93350,77270,95400,77290,77181,95190,93130,93360,95380,93110,95380,95720,77990,77500,93230,93260,93240,93460,93500,93120,93300,77410,77990,93100,93380,77410,94170,95380,93330,95200,95400,93310,77177,94120,95380,93160,93210,93200,95720,93170,95190,95440,95350,77290,95360,77230,94300,77420,95410,93430,94360,94130,95380,94350,77230,77230,77410,77360,95470,77410,93450,92390,95190,95170,77410,95720,77186,95350,77400,95850,77230,95460,95160,77230,93400,95880,77200,94500,95670,77185,94160,77410,93800,95470,94420,94340,77400,94410,95720,77230,95850,77400,92230,77410,75009,75008,75007,75010,75006,75005,75004,75003,75002,75000,75001,75011,75012,75020,75018,75017,75116,75019,75015,75014,75016,75013,95230,95330,77230,77400,77230,77400,95570,77230,77600,95270,77184,94220,94430,94340,94100,94210,95580,95580,92110,95470,95470,77090,77183,95270,95210,95218,77400,95270,95270,60128,95570,77600,77600,92600,77230,77400,95270,94205,94200,94700,95600,92300,77340,77600,94140,77410,95570,94270,95680,95120,77450,92270,94490,94880,94880,94000,77165,77230,77280,94510,95570,77680,77600,77144,77410,95100,95270,60128,95560,77230,77410,95110,95390,77165,77144,77700,92200,77410,92700,77164,95270,60330,94800,94250)

20. 0.0527

    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.95*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.95*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- 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='110' AND MATCH (wish_desc) AGAINST ('(+nettoyeur +haute +pression*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (93600,93600,93270,93420,93410,93290,93190,93390,93700,93150,93340,93320,95700,95500,95500,77181,93470,95500,95500,93140,93370,93440,93000,93250,93220,95140,93350,77270,95400,77290,77181,95190,93130,93360,95380,93110,95380,95720,77990,77500,93230,93260,93240,93460,93500,93120,93300,77410,77990,93100,93380,77410,94170,95380,93330,95200,95400,93310,77177,94120,95380,93160,93210,93200,95720,93170,95190,95440,95350,77290,95360,77230,94300,77420,95410,93430,94360,94130,95380,94350,77230,77230,77410,77360,95470,77410,93450,92390,95190,95170,77410,95720,77186,95350,77400,95850,77230,95460,95160,77230,93400,95880,77200,94500,95670,77185,94160,77410,93800,95470,94420,94340,77400,94410,95720,77230,95850,77400,92230,77410,75009,75008,75007,75010,75006,75005,75004,75003,75002,75000,75001,75011,75012,75020,75018,75017,75116,75019,75015,75014,75016,75013,95230,95330,77230,77400,77230,77400,95570,77230,77600,95270,77184,94220,94430,94340,94100,94210,95580,95580,92110,95470,95470,77090,77183,95270,95210,95218,77400,95270,95270,60128,95570,77600,77600,92600,77230,77400,95270,94205,94200,94700,95600,92300,77340,77600,94140,77410,95570,94270,95680,95120,77450,92270,94490,94880,94880,94000,77165,77230,77280,94510,95570,77680,77600,77144,77410,95100,95270,60128,95560,77230,77410,95110,95390,77165,77144,77700,92200,77410,92700,77164,95270,60330,94800,94250) 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='93600'

22. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.95*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.95*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.770135678816 AND ville_latitude_deg<49.129864321184 AND ville_longitude_deg>2.2427856472466 AND ville_longitude_deg<2.7905543527534 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0054

    SELECT ville_cp, ROUND((((acos(sin((48.95*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.95*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.500339197041 AND ville_latitude_deg<49.399660802959 AND ville_longitude_deg>1.8319532137498 AND ville_longitude_deg<3.2013867862502 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 = 15153 AND W.type_id = 1) OR (W.util_id != 15153 AND W.type_id = 2)) AND (`post_util_id` = 15153 OR `dest_util_id` = 15153) 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=15153 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 = 18763 AND W.type_id = 1) OR (W.util_id != 18763 AND W.type_id = 2)) AND (`post_util_id` = 18763 OR `dest_util_id` = 18763) 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=18763 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 = 36167 AND W.type_id = 1) OR (W.util_id != 36167 AND W.type_id = 2)) AND (`post_util_id` = 36167 OR `dest_util_id` = 36167) 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=36167 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 = 61115 AND W.type_id = 1) OR (W.util_id != 61115 AND W.type_id = 2)) AND (`post_util_id` = 61115 OR `dest_util_id` = 61115) 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=61115 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 = 81490 AND W.type_id = 1) OR (W.util_id != 81490 AND W.type_id = 2)) AND (`post_util_id` = 81490 OR `dest_util_id` = 81490) 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=81490 AND note_visu IN (1,3,4)

36. 0.0001

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

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

44. 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 = 11298 AND W.type_id = 1) OR (W.util_id != 11298 AND W.type_id = 2)) AND (`post_util_id` = 11298 OR `dest_util_id` = 11298) 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=11298 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 = 116845 AND W.type_id = 1) OR (W.util_id != 116845 AND W.type_id = 2)) AND (`post_util_id` = 116845 OR `dest_util_id` = 116845) 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=116845 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 = 120047 AND W.type_id = 1) OR (W.util_id != 120047 AND W.type_id = 2)) AND (`post_util_id` = 120047 OR `dest_util_id` = 120047) 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=120047 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 = 121245 AND W.type_id = 1) OR (W.util_id != 121245 AND W.type_id = 2)) AND (`post_util_id` = 121245 OR `dest_util_id` = 121245) 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=121245 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 = 129820 AND W.type_id = 1) OR (W.util_id != 129820 AND W.type_id = 2)) AND (`post_util_id` = 129820 OR `dest_util_id` = 129820) 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=129820 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 = 130323 AND W.type_id = 1) OR (W.util_id != 130323 AND W.type_id = 2)) AND (`post_util_id` = 130323 OR `dest_util_id` = 130323) 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=130323 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 = 131911 AND W.type_id = 1) OR (W.util_id != 131911 AND W.type_id = 2)) AND (`post_util_id` = 131911 OR `dest_util_id` = 131911) 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=131911 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 = 140743 AND W.type_id = 1) OR (W.util_id != 140743 AND W.type_id = 2)) AND (`post_util_id` = 140743 OR `dest_util_id` = 140743) 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=140743 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 = 151262 AND W.type_id = 1) OR (W.util_id != 151262 AND W.type_id = 2)) AND (`post_util_id` = 151262 OR `dest_util_id` = 151262) 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=151262 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 = 159329 AND W.type_id = 1) OR (W.util_id != 159329 AND W.type_id = 2)) AND (`post_util_id` = 159329 OR `dest_util_id` = 159329) 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=159329 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 = 24966 AND W.type_id = 1) OR (W.util_id != 24966 AND W.type_id = 2)) AND (`post_util_id` = 24966 OR `dest_util_id` = 24966) 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=24966 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 = 175989 AND W.type_id = 1) OR (W.util_id != 175989 AND W.type_id = 2)) AND (`post_util_id` = 175989 OR `dest_util_id` = 175989) 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=175989 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 = 179121 AND W.type_id = 1) OR (W.util_id != 179121 AND W.type_id = 2)) AND (`post_util_id` = 179121 OR `dest_util_id` = 179121) 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=179121 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 = 181291 AND W.type_id = 1) OR (W.util_id != 181291 AND W.type_id = 2)) AND (`post_util_id` = 181291 OR `dest_util_id` = 181291) 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=181291 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 = 179121 AND W.type_id = 1) OR (W.util_id != 179121 AND W.type_id = 2)) AND (`post_util_id` = 179121 OR `dest_util_id` = 179121) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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 = 182836 AND W.type_id = 1) OR (W.util_id != 182836 AND W.type_id = 2)) AND (`post_util_id` = 182836 OR `dest_util_id` = 182836) 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=182836 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 = 184864 AND W.type_id = 1) OR (W.util_id != 184864 AND W.type_id = 2)) AND (`post_util_id` = 184864 OR `dest_util_id` = 184864) 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=184864 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 = 197534 AND W.type_id = 1) OR (W.util_id != 197534 AND W.type_id = 2)) AND (`post_util_id` = 197534 OR `dest_util_id` = 197534) 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=197534 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 = 173579 AND W.type_id = 1) OR (W.util_id != 173579 AND W.type_id = 2)) AND (`post_util_id` = 173579 OR `dest_util_id` = 173579) 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=173579 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 = 223659 AND W.type_id = 1) OR (W.util_id != 223659 AND W.type_id = 2)) AND (`post_util_id` = 223659 OR `dest_util_id` = 223659) 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=223659 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 = 224593 AND W.type_id = 1) OR (W.util_id != 224593 AND W.type_id = 2)) AND (`post_util_id` = 224593 OR `dest_util_id` = 224593) 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=224593 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 = 233572 AND W.type_id = 1) OR (W.util_id != 233572 AND W.type_id = 2)) AND (`post_util_id` = 233572 OR `dest_util_id` = 233572) 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=233572 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 = 237073 AND W.type_id = 1) OR (W.util_id != 237073 AND W.type_id = 2)) AND (`post_util_id` = 237073 OR `dest_util_id` = 237073) 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=237073 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 = 255159 AND W.type_id = 1) OR (W.util_id != 255159 AND W.type_id = 2)) AND (`post_util_id` = 255159 OR `dest_util_id` = 255159) 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=255159 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 = 120490 AND W.type_id = 1) OR (W.util_id != 120490 AND W.type_id = 2)) AND (`post_util_id` = 120490 OR `dest_util_id` = 120490) 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=120490 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 = 237045 AND W.type_id = 1) OR (W.util_id != 237045 AND W.type_id = 2)) AND (`post_util_id` = 237045 OR `dest_util_id` = 237045) 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=237045 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 = 275175 AND W.type_id = 1) OR (W.util_id != 275175 AND W.type_id = 2)) AND (`post_util_id` = 275175 OR `dest_util_id` = 275175) 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=275175 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 = 283184 AND W.type_id = 1) OR (W.util_id != 283184 AND W.type_id = 2)) AND (`post_util_id` = 283184 OR `dest_util_id` = 283184) 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=283184 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 = 302422 AND W.type_id = 1) OR (W.util_id != 302422 AND W.type_id = 2)) AND (`post_util_id` = 302422 OR `dest_util_id` = 302422) 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=302422 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 = 258442 AND W.type_id = 1) OR (W.util_id != 258442 AND W.type_id = 2)) AND (`post_util_id` = 258442 OR `dest_util_id` = 258442) 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=258442 AND note_visu IN (1,3,4)

103. 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 = 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

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

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 = 363321 AND W.type_id = 1) OR (W.util_id != 363321 AND W.type_id = 2)) AND (`post_util_id` = 363321 OR `dest_util_id` = 363321) 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=363321 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 = 366933 AND W.type_id = 1) OR (W.util_id != 366933 AND W.type_id = 2)) AND (`post_util_id` = 366933 OR `dest_util_id` = 366933) 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=366933 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 = 369521 AND W.type_id = 1) OR (W.util_id != 369521 AND W.type_id = 2)) AND (`post_util_id` = 369521 OR `dest_util_id` = 369521) 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=369521 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 = 370757 AND W.type_id = 1) OR (W.util_id != 370757 AND W.type_id = 2)) AND (`post_util_id` = 370757 OR `dest_util_id` = 370757) 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=370757 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 = 379128 AND W.type_id = 1) OR (W.util_id != 379128 AND W.type_id = 2)) AND (`post_util_id` = 379128 OR `dest_util_id` = 379128) 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=379128 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 = 231625 AND W.type_id = 1) OR (W.util_id != 231625 AND W.type_id = 2)) AND (`post_util_id` = 231625 OR `dest_util_id` = 231625) 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=231625 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 = 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

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

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 = 390978 AND W.type_id = 1) OR (W.util_id != 390978 AND W.type_id = 2)) AND (`post_util_id` = 390978 OR `dest_util_id` = 390978) 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=390978 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 = 396503 AND W.type_id = 1) OR (W.util_id != 396503 AND W.type_id = 2)) AND (`post_util_id` = 396503 OR `dest_util_id` = 396503) 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=396503 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 = 400291 AND W.type_id = 1) OR (W.util_id != 400291 AND W.type_id = 2)) AND (`post_util_id` = 400291 OR `dest_util_id` = 400291) 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=400291 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 = 409875 AND W.type_id = 1) OR (W.util_id != 409875 AND W.type_id = 2)) AND (`post_util_id` = 409875 OR `dest_util_id` = 409875) 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=409875 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 = 408132 AND W.type_id = 1) OR (W.util_id != 408132 AND W.type_id = 2)) AND (`post_util_id` = 408132 OR `dest_util_id` = 408132) 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=408132 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 = 423681 AND W.type_id = 1) OR (W.util_id != 423681 AND W.type_id = 2)) AND (`post_util_id` = 423681 OR `dest_util_id` = 423681) 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=423681 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 = 402379 AND W.type_id = 1) OR (W.util_id != 402379 AND W.type_id = 2)) AND (`post_util_id` = 402379 OR `dest_util_id` = 402379) 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=402379 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 = 119424 AND W.type_id = 1) OR (W.util_id != 119424 AND W.type_id = 2)) AND (`post_util_id` = 119424 OR `dest_util_id` = 119424) 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=119424 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 = 28429 AND W.type_id = 1) OR (W.util_id != 28429 AND W.type_id = 2)) AND (`post_util_id` = 28429 OR `dest_util_id` = 28429) 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=28429 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 = 438517 AND W.type_id = 1) OR (W.util_id != 438517 AND W.type_id = 2)) AND (`post_util_id` = 438517 OR `dest_util_id` = 438517) 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=438517 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 = 440726 AND W.type_id = 1) OR (W.util_id != 440726 AND W.type_id = 2)) AND (`post_util_id` = 440726 OR `dest_util_id` = 440726) 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=440726 AND note_visu IN (1,3,4)

141. 0.0001

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

142. 0.0001

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

143. 0.0001

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

144. 0.0001

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

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

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

149. 0.0001

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

150. 0.0001

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

151. 0.0001

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

152. 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='745' LIMIT 0,1

153. 0.0001

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

154. 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='745' LIMIT 0,1

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

156. 0.0001

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

157. 0.0001

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

158. 0.0001

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

159. 0

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

160. 0.0001

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

161. 0

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

162. 0.0001

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

163. 0.0001

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

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

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

166. 0.0001

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

167. 0.0008

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

168. 0

     SELECT count(*) as nbwish FROM wish

169. 0.044

     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

169 requetes sql en 0.1915