Service aide aux seniors à 95410 Groslay

1. 0.0001

   SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL

2. 0.0001

   SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='services-divers'

3. 0

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

4. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('95' USING utf8mb4) COLLATE utf8mb4_general_ci

5. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='95410' AND ville_nom like '%groslay%' ORDER BY ville_population_2012 DESC LIMIT 0,1

6. 0.0004

   SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''

7. 0.0001

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

8. 0.0002

   SHOW TABLES LIKE 'pays'

9. 0.0002

   SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

10. 0.0003

    SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC

11. 0.0001

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

12. 0.0025

    SELECT ville_cp, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.35- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.803435678816 AND ville_latitude_deg<49.163164321184 AND ville_longitude_deg>2.0759326854937 AND ville_longitude_deg<2.6240673145063 HAVING distance <= 20 ORDER BY distance ASC

13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='aide personne'

14. 0.0003

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

15. 0.0001

    SELECT * FROM texte WHERE cate_id=229

16. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='aide personne' OR ssrubr_slug='aide-personne' OR (ssrubr_title like '%aide personne%')) AND cate_id='229' ORDER BY ssrubr_id LIMIT 0,1

17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='aide-personne' AND cate_id='229'

18. 0.0001

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

19. 0.003

    SELECT ville_cp, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.35- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.803435678816 AND ville_latitude_deg<49.163164321184 AND ville_longitude_deg>2.0759326854937 AND ville_longitude_deg<2.6240673145063 HAVING distance <= 20 ORDER BY distance ASC

20. 0.0191

    SELECT ville_cp, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.35- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.533639197041 AND ville_latitude_deg<49.432960802959 AND ville_longitude_deg>1.6648258054235 AND ville_longitude_deg<3.0351741945765 HAVING distance <= 50 ORDER BY distance ASC

21. 0.0108

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.35- 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='3' AND cate_id='229' AND ssrubr_id='1020' AND wish_visu IN (1,6,10) AND wish_cp IN (95410,95410,95170,95360,93380,95160,95350,93430,95880,95400,95200,95230,95350,95580,95580,93240,95440,93800,95400,95218,95140,95210,95600,93210,93200,92390,93450,95330,95460,95120,93440,95680,95500,92230,95390,95720,95500,95720,93350,95570,95570,95110,93120,93300,95100,95320,95720,95570,95130,95130,95500,93150,93700,95190,92600,93400,92270,95560,95560,95500,93500,92110,95720,95560,95190,95840,92700,92300,95240,95850,95570,95150,95550,95870,95270,95560,95250,93310,92250,93000,95190,92400,95270,95590,95370,95740,95380,95530,95700,95840,93140,93230,92200,93260,78500,93600,95270,78800,95850,95380,95220,93420,75116,75020,75019,75018,75017,75016,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75015,75014,75013,75012,75011,75010,93170,95480,93130,78420,93100,95540,92000,93270,95270,95270,78600,95590,95270,95380,93340,93320,95270,92150,92800,95430,95630,95670,95270,92500,93250,95380,94300,95270,95470,93110,95430,95380,78360,93190,93390,95270,95270,95270,93410,93290,95760,92170,95590,95290,78600,95260,94160,93220,95620,94120,95260,93360,77990,95660,92100,78700,95470,93370,78400,94170,92210,94270,94250,95310,93470,77181,77990,95610,94200,92120,94205,92240,94220,94130,95470,78110,77290,92130,95340,60260,95470,95300,92380,93330) AND type_id=1 GROUP BY wish_id

22. 0.0005

    SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (5765,6315,21070,28563,28745,25935,34766,47103,51395,56965,60939,61081,62942,64751,69289,70511,73786,75017,76523,80387,87590,87756,88692,90640,91934,92036,95521,99578,47515,87233,66583,102544,120378,121732,121735,122542,124186,124829,125456,128169,121059,136066,135558,48763,140711,137906,127981,152422,154233,155623,155811,164467,168062,184640,3345,186696,190200,195695,196645,198373,201421,202226,123630,203217,206491,207328,72487,212948,63843,215845,220486,224802,207660,226096,229307,229986,229733,241494,232503,246813,263251,166754,2756,228713,278801,27373,182254,303863,304496,309265,226,229568,330221,331331,152673,337240,345797,362275,373652,377168,378461,378861,379433,381296,374297,10510,178432,389549,392162,82597,396709,396745,132840,300465,398869,404825,429399,228747,442413,444354,452624,109912,270452,269695,282989,467651,353698,356620,472470,473090,358045,476718,65080,480970,27575,3964,522966,538438,545809)

23. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 5765 AND W.type_id = 1) OR (W.util_id <> 5765 AND W.type_id = 2)) AND (M.post_util_id = 5765 OR M.dest_util_id = 5765) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

24. 0.0001

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

25. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 6315 AND W.type_id = 1) OR (W.util_id <> 6315 AND W.type_id = 2)) AND (M.post_util_id = 6315 OR M.dest_util_id = 6315) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

26. 0.0001

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

27. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 21070 AND W.type_id = 1) OR (W.util_id <> 21070 AND W.type_id = 2)) AND (M.post_util_id = 21070 OR M.dest_util_id = 21070) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

28. 0.0001

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

29. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 28563 AND W.type_id = 1) OR (W.util_id <> 28563 AND W.type_id = 2)) AND (M.post_util_id = 28563 OR M.dest_util_id = 28563) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

30. 0.0001

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

31. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 28745 AND W.type_id = 1) OR (W.util_id <> 28745 AND W.type_id = 2)) AND (M.post_util_id = 28745 OR M.dest_util_id = 28745) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

32. 0.0001

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

33. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 25935 AND W.type_id = 1) OR (W.util_id <> 25935 AND W.type_id = 2)) AND (M.post_util_id = 25935 OR M.dest_util_id = 25935) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

34. 0.0001

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

35. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 34766 AND W.type_id = 1) OR (W.util_id <> 34766 AND W.type_id = 2)) AND (M.post_util_id = 34766 OR M.dest_util_id = 34766) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

36. 0.0001

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

37. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 47103 AND W.type_id = 1) OR (W.util_id <> 47103 AND W.type_id = 2)) AND (M.post_util_id = 47103 OR M.dest_util_id = 47103) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

38. 0.0001

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

39. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 51395 AND W.type_id = 1) OR (W.util_id <> 51395 AND W.type_id = 2)) AND (M.post_util_id = 51395 OR M.dest_util_id = 51395) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

40. 0.0001

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

41. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 56965 AND W.type_id = 1) OR (W.util_id <> 56965 AND W.type_id = 2)) AND (M.post_util_id = 56965 OR M.dest_util_id = 56965) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

42. 0.0001

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

43. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 60939 AND W.type_id = 1) OR (W.util_id <> 60939 AND W.type_id = 2)) AND (M.post_util_id = 60939 OR M.dest_util_id = 60939) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

44. 0.0001

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

45. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 61081 AND W.type_id = 1) OR (W.util_id <> 61081 AND W.type_id = 2)) AND (M.post_util_id = 61081 OR M.dest_util_id = 61081) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

46. 0.0001

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

47. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 62942 AND W.type_id = 1) OR (W.util_id <> 62942 AND W.type_id = 2)) AND (M.post_util_id = 62942 OR M.dest_util_id = 62942) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

48. 0.0001

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

49. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 64751 AND W.type_id = 1) OR (W.util_id <> 64751 AND W.type_id = 2)) AND (M.post_util_id = 64751 OR M.dest_util_id = 64751) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

50. 0.0001

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

51. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 69289 AND W.type_id = 1) OR (W.util_id <> 69289 AND W.type_id = 2)) AND (M.post_util_id = 69289 OR M.dest_util_id = 69289) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

52. 0.0001

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

53. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 70511 AND W.type_id = 1) OR (W.util_id <> 70511 AND W.type_id = 2)) AND (M.post_util_id = 70511 OR M.dest_util_id = 70511) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

54. 0.0001

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

55. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 73786 AND W.type_id = 1) OR (W.util_id <> 73786 AND W.type_id = 2)) AND (M.post_util_id = 73786 OR M.dest_util_id = 73786) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

56. 0.0001

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

57. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 75017 AND W.type_id = 1) OR (W.util_id <> 75017 AND W.type_id = 2)) AND (M.post_util_id = 75017 OR M.dest_util_id = 75017) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

58. 0.0001

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

59. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 76523 AND W.type_id = 1) OR (W.util_id <> 76523 AND W.type_id = 2)) AND (M.post_util_id = 76523 OR M.dest_util_id = 76523) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

60. 0.0001

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

61. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 80387 AND W.type_id = 1) OR (W.util_id <> 80387 AND W.type_id = 2)) AND (M.post_util_id = 80387 OR M.dest_util_id = 80387) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

62. 0.0001

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

63. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 87590 AND W.type_id = 1) OR (W.util_id <> 87590 AND W.type_id = 2)) AND (M.post_util_id = 87590 OR M.dest_util_id = 87590) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

64. 0.0001

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

65. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 87756 AND W.type_id = 1) OR (W.util_id <> 87756 AND W.type_id = 2)) AND (M.post_util_id = 87756 OR M.dest_util_id = 87756) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

66. 0.0001

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

67. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 88692 AND W.type_id = 1) OR (W.util_id <> 88692 AND W.type_id = 2)) AND (M.post_util_id = 88692 OR M.dest_util_id = 88692) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

68. 0.0001

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

69. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 90640 AND W.type_id = 1) OR (W.util_id <> 90640 AND W.type_id = 2)) AND (M.post_util_id = 90640 OR M.dest_util_id = 90640) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

70. 0.0001

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

71. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 91934 AND W.type_id = 1) OR (W.util_id <> 91934 AND W.type_id = 2)) AND (M.post_util_id = 91934 OR M.dest_util_id = 91934) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

72. 0.0001

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

73. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 92036 AND W.type_id = 1) OR (W.util_id <> 92036 AND W.type_id = 2)) AND (M.post_util_id = 92036 OR M.dest_util_id = 92036) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

74. 0.0001

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

75. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 95521 AND W.type_id = 1) OR (W.util_id <> 95521 AND W.type_id = 2)) AND (M.post_util_id = 95521 OR M.dest_util_id = 95521) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

76. 0.0001

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

77. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 99578 AND W.type_id = 1) OR (W.util_id <> 99578 AND W.type_id = 2)) AND (M.post_util_id = 99578 OR M.dest_util_id = 99578) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

78. 0.0001

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

79. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 47515 AND W.type_id = 1) OR (W.util_id <> 47515 AND W.type_id = 2)) AND (M.post_util_id = 47515 OR M.dest_util_id = 47515) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

80. 0.0001

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

81. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 87233 AND W.type_id = 1) OR (W.util_id <> 87233 AND W.type_id = 2)) AND (M.post_util_id = 87233 OR M.dest_util_id = 87233) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

82. 0.0001

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

83. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 66583 AND W.type_id = 1) OR (W.util_id <> 66583 AND W.type_id = 2)) AND (M.post_util_id = 66583 OR M.dest_util_id = 66583) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

84. 0.0001

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

85. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 102544 AND W.type_id = 1) OR (W.util_id <> 102544 AND W.type_id = 2)) AND (M.post_util_id = 102544 OR M.dest_util_id = 102544) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

86. 0.0001

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

87. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 120378 AND W.type_id = 1) OR (W.util_id <> 120378 AND W.type_id = 2)) AND (M.post_util_id = 120378 OR M.dest_util_id = 120378) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

88. 0.0001

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

89. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 121732 AND W.type_id = 1) OR (W.util_id <> 121732 AND W.type_id = 2)) AND (M.post_util_id = 121732 OR M.dest_util_id = 121732) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

90. 0.0001

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

91. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 121735 AND W.type_id = 1) OR (W.util_id <> 121735 AND W.type_id = 2)) AND (M.post_util_id = 121735 OR M.dest_util_id = 121735) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

92. 0.0001

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

93. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 122542 AND W.type_id = 1) OR (W.util_id <> 122542 AND W.type_id = 2)) AND (M.post_util_id = 122542 OR M.dest_util_id = 122542) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

94. 0.0001

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

95. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 124186 AND W.type_id = 1) OR (W.util_id <> 124186 AND W.type_id = 2)) AND (M.post_util_id = 124186 OR M.dest_util_id = 124186) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

96. 0.0001

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

97. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 124829 AND W.type_id = 1) OR (W.util_id <> 124829 AND W.type_id = 2)) AND (M.post_util_id = 124829 OR M.dest_util_id = 124829) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

98. 0.0001

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

99. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 125456 AND W.type_id = 1) OR (W.util_id <> 125456 AND W.type_id = 2)) AND (M.post_util_id = 125456 OR M.dest_util_id = 125456) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

100. 0.0001

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

101. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 128169 AND W.type_id = 1) OR (W.util_id <> 128169 AND W.type_id = 2)) AND (M.post_util_id = 128169 OR M.dest_util_id = 128169) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

102. 0.0001

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

103. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 121059 AND W.type_id = 1) OR (W.util_id <> 121059 AND W.type_id = 2)) AND (M.post_util_id = 121059 OR M.dest_util_id = 121059) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

104. 0.0001

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

105. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 136066 AND W.type_id = 1) OR (W.util_id <> 136066 AND W.type_id = 2)) AND (M.post_util_id = 136066 OR M.dest_util_id = 136066) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

106. 0.0001

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

107. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 135558 AND W.type_id = 1) OR (W.util_id <> 135558 AND W.type_id = 2)) AND (M.post_util_id = 135558 OR M.dest_util_id = 135558) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

108. 0.0001

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

109. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 48763 AND W.type_id = 1) OR (W.util_id <> 48763 AND W.type_id = 2)) AND (M.post_util_id = 48763 OR M.dest_util_id = 48763) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

110. 0.0001

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

111. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 140711 AND W.type_id = 1) OR (W.util_id <> 140711 AND W.type_id = 2)) AND (M.post_util_id = 140711 OR M.dest_util_id = 140711) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

112. 0.0001

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

113. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137906 AND W.type_id = 1) OR (W.util_id <> 137906 AND W.type_id = 2)) AND (M.post_util_id = 137906 OR M.dest_util_id = 137906) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

114. 0.0001

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

115. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 127981 AND W.type_id = 1) OR (W.util_id <> 127981 AND W.type_id = 2)) AND (M.post_util_id = 127981 OR M.dest_util_id = 127981) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

116. 0.0001

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

117. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 152422 AND W.type_id = 1) OR (W.util_id <> 152422 AND W.type_id = 2)) AND (M.post_util_id = 152422 OR M.dest_util_id = 152422) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

118. 0.0001

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

119. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 154233 AND W.type_id = 1) OR (W.util_id <> 154233 AND W.type_id = 2)) AND (M.post_util_id = 154233 OR M.dest_util_id = 154233) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

120. 0.0001

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

121. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 155623 AND W.type_id = 1) OR (W.util_id <> 155623 AND W.type_id = 2)) AND (M.post_util_id = 155623 OR M.dest_util_id = 155623) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

122. 0.0001

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

123. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 155811 AND W.type_id = 1) OR (W.util_id <> 155811 AND W.type_id = 2)) AND (M.post_util_id = 155811 OR M.dest_util_id = 155811) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

124. 0.0001

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

125. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 164467 AND W.type_id = 1) OR (W.util_id <> 164467 AND W.type_id = 2)) AND (M.post_util_id = 164467 OR M.dest_util_id = 164467) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

126. 0.0001

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

127. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 168062 AND W.type_id = 1) OR (W.util_id <> 168062 AND W.type_id = 2)) AND (M.post_util_id = 168062 OR M.dest_util_id = 168062) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

128. 0.0001

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

129. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 184640 AND W.type_id = 1) OR (W.util_id <> 184640 AND W.type_id = 2)) AND (M.post_util_id = 184640 OR M.dest_util_id = 184640) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

130. 0.0001

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

131. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 3345 AND W.type_id = 1) OR (W.util_id <> 3345 AND W.type_id = 2)) AND (M.post_util_id = 3345 OR M.dest_util_id = 3345) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

132. 0.0001

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

133. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 186696 AND W.type_id = 1) OR (W.util_id <> 186696 AND W.type_id = 2)) AND (M.post_util_id = 186696 OR M.dest_util_id = 186696) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

134. 0.0001

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

135. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 190200 AND W.type_id = 1) OR (W.util_id <> 190200 AND W.type_id = 2)) AND (M.post_util_id = 190200 OR M.dest_util_id = 190200) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

136. 0.0001

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

137. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 195695 AND W.type_id = 1) OR (W.util_id <> 195695 AND W.type_id = 2)) AND (M.post_util_id = 195695 OR M.dest_util_id = 195695) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

138. 0.0001

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

139. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 196645 AND W.type_id = 1) OR (W.util_id <> 196645 AND W.type_id = 2)) AND (M.post_util_id = 196645 OR M.dest_util_id = 196645) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

140. 0.0001

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

141. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 198373 AND W.type_id = 1) OR (W.util_id <> 198373 AND W.type_id = 2)) AND (M.post_util_id = 198373 OR M.dest_util_id = 198373) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

142. 0.0001

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

143. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 201421 AND W.type_id = 1) OR (W.util_id <> 201421 AND W.type_id = 2)) AND (M.post_util_id = 201421 OR M.dest_util_id = 201421) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

144. 0.0001

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

145. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 202226 AND W.type_id = 1) OR (W.util_id <> 202226 AND W.type_id = 2)) AND (M.post_util_id = 202226 OR M.dest_util_id = 202226) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

146. 0.0001

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

147. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 123630 AND W.type_id = 1) OR (W.util_id <> 123630 AND W.type_id = 2)) AND (M.post_util_id = 123630 OR M.dest_util_id = 123630) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

148. 0.0001

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

149. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 203217 AND W.type_id = 1) OR (W.util_id <> 203217 AND W.type_id = 2)) AND (M.post_util_id = 203217 OR M.dest_util_id = 203217) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

150. 0.0001

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

151. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 206491 AND W.type_id = 1) OR (W.util_id <> 206491 AND W.type_id = 2)) AND (M.post_util_id = 206491 OR M.dest_util_id = 206491) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

152. 0.0001

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

153. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 207328 AND W.type_id = 1) OR (W.util_id <> 207328 AND W.type_id = 2)) AND (M.post_util_id = 207328 OR M.dest_util_id = 207328) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

154. 0.0001

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

155. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 72487 AND W.type_id = 1) OR (W.util_id <> 72487 AND W.type_id = 2)) AND (M.post_util_id = 72487 OR M.dest_util_id = 72487) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

156. 0.0001

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

157. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 212948 AND W.type_id = 1) OR (W.util_id <> 212948 AND W.type_id = 2)) AND (M.post_util_id = 212948 OR M.dest_util_id = 212948) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

158. 0.0001

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

159. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 63843 AND W.type_id = 1) OR (W.util_id <> 63843 AND W.type_id = 2)) AND (M.post_util_id = 63843 OR M.dest_util_id = 63843) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

160. 0.0001

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

161. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 215845 AND W.type_id = 1) OR (W.util_id <> 215845 AND W.type_id = 2)) AND (M.post_util_id = 215845 OR M.dest_util_id = 215845) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

162. 0.0001

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

163. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 220486 AND W.type_id = 1) OR (W.util_id <> 220486 AND W.type_id = 2)) AND (M.post_util_id = 220486 OR M.dest_util_id = 220486) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

164. 0.0001

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

165. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 224802 AND W.type_id = 1) OR (W.util_id <> 224802 AND W.type_id = 2)) AND (M.post_util_id = 224802 OR M.dest_util_id = 224802) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

166. 0.0001

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

167. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 207660 AND W.type_id = 1) OR (W.util_id <> 207660 AND W.type_id = 2)) AND (M.post_util_id = 207660 OR M.dest_util_id = 207660) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

168. 0.0001

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

169. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 226096 AND W.type_id = 1) OR (W.util_id <> 226096 AND W.type_id = 2)) AND (M.post_util_id = 226096 OR M.dest_util_id = 226096) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

170. 0.0001

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

171. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 229307 AND W.type_id = 1) OR (W.util_id <> 229307 AND W.type_id = 2)) AND (M.post_util_id = 229307 OR M.dest_util_id = 229307) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

172. 0.0001

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

173. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 229986 AND W.type_id = 1) OR (W.util_id <> 229986 AND W.type_id = 2)) AND (M.post_util_id = 229986 OR M.dest_util_id = 229986) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

174. 0.0001

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

175. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 229733 AND W.type_id = 1) OR (W.util_id <> 229733 AND W.type_id = 2)) AND (M.post_util_id = 229733 OR M.dest_util_id = 229733) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

176. 0.0001

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

177. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 241494 AND W.type_id = 1) OR (W.util_id <> 241494 AND W.type_id = 2)) AND (M.post_util_id = 241494 OR M.dest_util_id = 241494) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

178. 0.0001

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

179. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 232503 AND W.type_id = 1) OR (W.util_id <> 232503 AND W.type_id = 2)) AND (M.post_util_id = 232503 OR M.dest_util_id = 232503) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

180. 0.0001

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

181. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 246813 AND W.type_id = 1) OR (W.util_id <> 246813 AND W.type_id = 2)) AND (M.post_util_id = 246813 OR M.dest_util_id = 246813) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

182. 0.0001

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

183. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 263251 AND W.type_id = 1) OR (W.util_id <> 263251 AND W.type_id = 2)) AND (M.post_util_id = 263251 OR M.dest_util_id = 263251) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

184. 0.0001

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

185. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 166754 AND W.type_id = 1) OR (W.util_id <> 166754 AND W.type_id = 2)) AND (M.post_util_id = 166754 OR M.dest_util_id = 166754) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

186. 0.0001

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

187. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 2756 AND W.type_id = 1) OR (W.util_id <> 2756 AND W.type_id = 2)) AND (M.post_util_id = 2756 OR M.dest_util_id = 2756) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

188. 0.0001

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

189. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 228713 AND W.type_id = 1) OR (W.util_id <> 228713 AND W.type_id = 2)) AND (M.post_util_id = 228713 OR M.dest_util_id = 228713) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

190. 0.0001

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

191. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 278801 AND W.type_id = 1) OR (W.util_id <> 278801 AND W.type_id = 2)) AND (M.post_util_id = 278801 OR M.dest_util_id = 278801) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

192. 0.0001

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

193. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 27373 AND W.type_id = 1) OR (W.util_id <> 27373 AND W.type_id = 2)) AND (M.post_util_id = 27373 OR M.dest_util_id = 27373) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

194. 0.0001

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

195. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 182254 AND W.type_id = 1) OR (W.util_id <> 182254 AND W.type_id = 2)) AND (M.post_util_id = 182254 OR M.dest_util_id = 182254) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

196. 0.0001

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

197. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 303863 AND W.type_id = 1) OR (W.util_id <> 303863 AND W.type_id = 2)) AND (M.post_util_id = 303863 OR M.dest_util_id = 303863) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

198. 0.0001

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

199. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 304496 AND W.type_id = 1) OR (W.util_id <> 304496 AND W.type_id = 2)) AND (M.post_util_id = 304496 OR M.dest_util_id = 304496) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

200. 0.0001

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

201. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 309265 AND W.type_id = 1) OR (W.util_id <> 309265 AND W.type_id = 2)) AND (M.post_util_id = 309265 OR M.dest_util_id = 309265) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

202. 0.0001

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

203. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 226 AND W.type_id = 1) OR (W.util_id <> 226 AND W.type_id = 2)) AND (M.post_util_id = 226 OR M.dest_util_id = 226) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

204. 0.0001

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

205. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 229568 AND W.type_id = 1) OR (W.util_id <> 229568 AND W.type_id = 2)) AND (M.post_util_id = 229568 OR M.dest_util_id = 229568) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

206. 0.0001

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

207. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 330221 AND W.type_id = 1) OR (W.util_id <> 330221 AND W.type_id = 2)) AND (M.post_util_id = 330221 OR M.dest_util_id = 330221) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

208. 0.0001

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

209. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 331331 AND W.type_id = 1) OR (W.util_id <> 331331 AND W.type_id = 2)) AND (M.post_util_id = 331331 OR M.dest_util_id = 331331) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

210. 0.0001

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

211. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 152673 AND W.type_id = 1) OR (W.util_id <> 152673 AND W.type_id = 2)) AND (M.post_util_id = 152673 OR M.dest_util_id = 152673) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

212. 0.0001

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

213. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 337240 AND W.type_id = 1) OR (W.util_id <> 337240 AND W.type_id = 2)) AND (M.post_util_id = 337240 OR M.dest_util_id = 337240) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

214. 0.0001

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

215. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 345797 AND W.type_id = 1) OR (W.util_id <> 345797 AND W.type_id = 2)) AND (M.post_util_id = 345797 OR M.dest_util_id = 345797) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

216. 0.0001

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

217. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 362275 AND W.type_id = 1) OR (W.util_id <> 362275 AND W.type_id = 2)) AND (M.post_util_id = 362275 OR M.dest_util_id = 362275) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

218. 0.0001

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

219. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 373652 AND W.type_id = 1) OR (W.util_id <> 373652 AND W.type_id = 2)) AND (M.post_util_id = 373652 OR M.dest_util_id = 373652) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

220. 0.0001

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

221. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 377168 AND W.type_id = 1) OR (W.util_id <> 377168 AND W.type_id = 2)) AND (M.post_util_id = 377168 OR M.dest_util_id = 377168) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

222. 0.0001

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

223. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 378461 AND W.type_id = 1) OR (W.util_id <> 378461 AND W.type_id = 2)) AND (M.post_util_id = 378461 OR M.dest_util_id = 378461) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

224. 0.0001

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

225. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 378861 AND W.type_id = 1) OR (W.util_id <> 378861 AND W.type_id = 2)) AND (M.post_util_id = 378861 OR M.dest_util_id = 378861) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

226. 0.0001

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

227. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 379433 AND W.type_id = 1) OR (W.util_id <> 379433 AND W.type_id = 2)) AND (M.post_util_id = 379433 OR M.dest_util_id = 379433) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

228. 0.0001

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

229. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 381296 AND W.type_id = 1) OR (W.util_id <> 381296 AND W.type_id = 2)) AND (M.post_util_id = 381296 OR M.dest_util_id = 381296) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

230. 0.0001

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

231. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 374297 AND W.type_id = 1) OR (W.util_id <> 374297 AND W.type_id = 2)) AND (M.post_util_id = 374297 OR M.dest_util_id = 374297) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

232. 0.0001

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

233. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 10510 AND W.type_id = 1) OR (W.util_id <> 10510 AND W.type_id = 2)) AND (M.post_util_id = 10510 OR M.dest_util_id = 10510) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

234. 0.0001

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

235. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 178432 AND W.type_id = 1) OR (W.util_id <> 178432 AND W.type_id = 2)) AND (M.post_util_id = 178432 OR M.dest_util_id = 178432) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

236. 0.0001

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

237. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 389549 AND W.type_id = 1) OR (W.util_id <> 389549 AND W.type_id = 2)) AND (M.post_util_id = 389549 OR M.dest_util_id = 389549) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

238. 0.0001

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

239. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 392162 AND W.type_id = 1) OR (W.util_id <> 392162 AND W.type_id = 2)) AND (M.post_util_id = 392162 OR M.dest_util_id = 392162) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

240. 0.0001

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

241. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 82597 AND W.type_id = 1) OR (W.util_id <> 82597 AND W.type_id = 2)) AND (M.post_util_id = 82597 OR M.dest_util_id = 82597) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

242. 0.0001

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

243. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 396709 AND W.type_id = 1) OR (W.util_id <> 396709 AND W.type_id = 2)) AND (M.post_util_id = 396709 OR M.dest_util_id = 396709) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

244. 0.0001

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

245. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 396745 AND W.type_id = 1) OR (W.util_id <> 396745 AND W.type_id = 2)) AND (M.post_util_id = 396745 OR M.dest_util_id = 396745) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

246. 0.0001

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

247. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 132840 AND W.type_id = 1) OR (W.util_id <> 132840 AND W.type_id = 2)) AND (M.post_util_id = 132840 OR M.dest_util_id = 132840) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

248. 0.0001

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

249. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 300465 AND W.type_id = 1) OR (W.util_id <> 300465 AND W.type_id = 2)) AND (M.post_util_id = 300465 OR M.dest_util_id = 300465) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

250. 0.0001

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

251. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 398869 AND W.type_id = 1) OR (W.util_id <> 398869 AND W.type_id = 2)) AND (M.post_util_id = 398869 OR M.dest_util_id = 398869) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

252. 0.0001

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

253. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 404825 AND W.type_id = 1) OR (W.util_id <> 404825 AND W.type_id = 2)) AND (M.post_util_id = 404825 OR M.dest_util_id = 404825) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

254. 0.0001

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

255. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 429399 AND W.type_id = 1) OR (W.util_id <> 429399 AND W.type_id = 2)) AND (M.post_util_id = 429399 OR M.dest_util_id = 429399) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

256. 0.0001

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

257. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 228747 AND W.type_id = 1) OR (W.util_id <> 228747 AND W.type_id = 2)) AND (M.post_util_id = 228747 OR M.dest_util_id = 228747) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

258. 0.0001

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

259. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 442413 AND W.type_id = 1) OR (W.util_id <> 442413 AND W.type_id = 2)) AND (M.post_util_id = 442413 OR M.dest_util_id = 442413) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

260. 0.0001

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

261. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 444354 AND W.type_id = 1) OR (W.util_id <> 444354 AND W.type_id = 2)) AND (M.post_util_id = 444354 OR M.dest_util_id = 444354) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

262. 0.0001

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

263. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 452624 AND W.type_id = 1) OR (W.util_id <> 452624 AND W.type_id = 2)) AND (M.post_util_id = 452624 OR M.dest_util_id = 452624) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

264. 0.0001

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

265. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 109912 AND W.type_id = 1) OR (W.util_id <> 109912 AND W.type_id = 2)) AND (M.post_util_id = 109912 OR M.dest_util_id = 109912) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

266. 0.0001

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

267. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 270452 AND W.type_id = 1) OR (W.util_id <> 270452 AND W.type_id = 2)) AND (M.post_util_id = 270452 OR M.dest_util_id = 270452) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

268. 0.0001

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

269. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 269695 AND W.type_id = 1) OR (W.util_id <> 269695 AND W.type_id = 2)) AND (M.post_util_id = 269695 OR M.dest_util_id = 269695) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

270. 0.0001

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

271. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 282989 AND W.type_id = 1) OR (W.util_id <> 282989 AND W.type_id = 2)) AND (M.post_util_id = 282989 OR M.dest_util_id = 282989) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

272. 0.0001

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

273. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 467651 AND W.type_id = 1) OR (W.util_id <> 467651 AND W.type_id = 2)) AND (M.post_util_id = 467651 OR M.dest_util_id = 467651) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

274. 0.0001

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

275. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 353698 AND W.type_id = 1) OR (W.util_id <> 353698 AND W.type_id = 2)) AND (M.post_util_id = 353698 OR M.dest_util_id = 353698) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

276. 0.0001

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

277. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 356620 AND W.type_id = 1) OR (W.util_id <> 356620 AND W.type_id = 2)) AND (M.post_util_id = 356620 OR M.dest_util_id = 356620) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

278. 0.0001

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

279. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 472470 AND W.type_id = 1) OR (W.util_id <> 472470 AND W.type_id = 2)) AND (M.post_util_id = 472470 OR M.dest_util_id = 472470) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

280. 0.0001

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

281. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 473090 AND W.type_id = 1) OR (W.util_id <> 473090 AND W.type_id = 2)) AND (M.post_util_id = 473090 OR M.dest_util_id = 473090) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

282. 0.0001

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

283. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 358045 AND W.type_id = 1) OR (W.util_id <> 358045 AND W.type_id = 2)) AND (M.post_util_id = 358045 OR M.dest_util_id = 358045) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

284. 0.0001

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

285. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476718 AND W.type_id = 1) OR (W.util_id <> 476718 AND W.type_id = 2)) AND (M.post_util_id = 476718 OR M.dest_util_id = 476718) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

286. 0.0001

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

287. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 65080 AND W.type_id = 1) OR (W.util_id <> 65080 AND W.type_id = 2)) AND (M.post_util_id = 65080 OR M.dest_util_id = 65080) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

288. 0.0001

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

289. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 480970 AND W.type_id = 1) OR (W.util_id <> 480970 AND W.type_id = 2)) AND (M.post_util_id = 480970 OR M.dest_util_id = 480970) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

290. 0.0001

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

291. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 27575 AND W.type_id = 1) OR (W.util_id <> 27575 AND W.type_id = 2)) AND (M.post_util_id = 27575 OR M.dest_util_id = 27575) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

292. 0.0001

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

293. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 3964 AND W.type_id = 1) OR (W.util_id <> 3964 AND W.type_id = 2)) AND (M.post_util_id = 3964 OR M.dest_util_id = 3964) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

294. 0.0001

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

295. 0.0002

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 522966 AND W.type_id = 1) OR (W.util_id <> 522966 AND W.type_id = 2)) AND (M.post_util_id = 522966 OR M.dest_util_id = 522966) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

296. 0.0001

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

297. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 538438 AND W.type_id = 1) OR (W.util_id <> 538438 AND W.type_id = 2)) AND (M.post_util_id = 538438 OR M.dest_util_id = 538438) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

298. 0.0001

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

299. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 545809 AND W.type_id = 1) OR (W.util_id <> 545809 AND W.type_id = 2)) AND (M.post_util_id = 545809 OR M.dest_util_id = 545809) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

300. 0.0001

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

301. 0.0001

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

302. 0.0029

     SELECT ville_cp, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.35- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.803435678816 AND ville_latitude_deg<49.163164321184 AND ville_longitude_deg>2.0759326854937 AND ville_longitude_deg<2.6240673145063 HAVING distance <= 20 ORDER BY distance ASC

303. 0.0148

     SELECT ville_cp, ROUND((((acos(sin((48.9833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.35- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.533639197041 AND ville_latitude_deg<49.432960802959 AND ville_longitude_deg>1.6648258054235 AND ville_longitude_deg<3.0351741945765 HAVING distance <= 50 ORDER BY distance ASC

304. 0.0001

     SELECT ssr.ssrubr_id, ssr.ssrubr_slug, ssr.ssrubr_mail, ssr.ssrubr_mail_bis, ssr.ssrubr_keywords, ssr.ssrubr_bt2, ssr.ssrubr_photo, c.cate_title_slug, f.fami_url 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 IN (1020)

305. 0.0002

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (442413,309265,127981,122542,27575,178432,102544,202226,396709,337240,304496,64751,480970,90640,2756,28745,224802,3345,87756,378861,269695,241494,10510,66583,212948,182254,229986,47515,47103)

306. 0.0002

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (442413,309265,127981,122542,27575,178432,102544,202226,396709,337240,304496,64751,480970,90640,2756,28745,224802,3345,87756,378861,269695,241494,10510,66583,212948,182254,229986,47515,47103)

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

308. 0.0001

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

309. 0.0001

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

310. 0.0002

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

311. 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 (229) ORDER BY ssrubr_order ASC

312. 0.0009

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

313. 0.025

     SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'

314. 0.0183

     SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

314 requetes sql en 0.1372