Service plat maison à 92150 Suresnes

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='repas-fait-maison'

3. 0

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

4. 0

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

5. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='92150' AND ville_nom like '%suresnes%' 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 '%plat%seul%' OR ssrubr_title like '%plat%seul%' OR ssrubr_slug like '%plat%seul%') AND cate_id='80' ORDER BY ssrubr_id LIMIT 0,1

8. 0.0001

   SHOW TABLES LIKE 'pays'

9. 0.0002

   SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

10. 0.0002

    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='92150'

12. 0.0025

    SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.686835678816 AND ville_latitude_deg<49.046564321184 AND ville_longitude_deg>1.9599018543365 AND ville_longitude_deg<2.5067581456635 HAVING distance <= 20 ORDER BY distance ASC

13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='plat'

14. 0.0004

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

15. 0.0001

    SELECT * FROM texte WHERE cate_id=80

16. 0.0002

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

17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='plat-seul' AND cate_id='80'

18. 0.0001

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

19. 0.0025

    SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.686835678816 AND ville_latitude_deg<49.046564321184 AND ville_longitude_deg>1.9599018543365 AND ville_longitude_deg<2.5067581456635 HAVING distance <= 20 ORDER BY distance ASC

20. 0.007

    SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.417039197041 AND ville_latitude_deg<49.316360802959 AND ville_longitude_deg>1.5497537413096 AND ville_longitude_deg<2.9169062586904 HAVING distance <= 50 ORDER BY distance ASC

21. 0.0228

    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.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- 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='80' AND MATCH (wish_desc) AGAINST ('(+plat*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (92150,92800,92150,92210,92500,92200,92400,92250,92100,92000,92380,92300,92410,92430,92420,92700,78800,92310,92270,92130,92110,92170,92600,78170,78400,92190,92360,78420,78290,78380,92240,95870,92370,92140,75020,75000,75019,75116,75018,75001,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75002,93400,92120,78360,78140,92320,78430,78560,92230,92220,78220,78150,94250,78110,78150,95100,92350,78500,92330,92260,93450,92390,78000,94110,78230,93800,78160,78600,78600,78750,78870,95110,94270,92290,78100,95218,95530,95210,93200,93210,94234,94240,94230,94232,94231,94233,94237,94239,94236,94235,94238,92340,78350,78620,94800,93300,93120,94200,94205,78112,78590,93310,95880,93500,93430,95130,91570,95120,95240,91370,78530,78350,93170,95370,95230,92160,94160,78590,95360,94550,78210,94260,93240,78330,94220,93100,93260,93230,94300,93380,95130,95170,91430,91430,78240,95600,91300,93350,78300,94400,94140,95410,94150,78117,95580,95580,95220,91400,94320,78860,78700,78240,93000,78450,93440,94700,78260,78280,95160,91320,91120,95320,95250,95390,95680,93130,78955,95480,94410,95140,94600,93140,93150,93700,78390,95350,78117,78570,94390,94310,94340,91190,93110,95500,78450,94120,78180,95200,95400,95550,95150,91140,95400,94130,78960,91160,95350,91190,91400,78630,78340,91440,91380,91160,78780,78114,95610,91550,78670,78670,94000,78190,78810,78570,93250,94170,95330,91420,95440) AND type_id=1 GROUP BY wish_id

22. 0.0007

    SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (423,738,4390,4693,6324,7336,6208,8780,9848,10675,11004,12264,12347,15461,9023,17618,17620,19234,19240,21149,20926,22769,21070,24428,25767,27037,27597,30445,31402,31367,33300,39336,43971,47958,49407,50806,51963,55793,56197,58873,58954,14790,59171,59586,60484,60636,62190,53771,62331,62693,63192,63444,63825,63948,64480,65190,65706,65853,66392,66833,69187,69361,70302,70648,71509,69855,72573,73123,6557,74369,74482,74567,51050,77937,78686,77908,80248,81477,82121,82155,82765,75269,61938,85928,86197,86375,81736,88170,89393,89441,89704,88322,90086,90903,91059,92193,93253,93993,94876,94905,96475,97683,98325,100625,101004,102566,85830,104449,96406,104671,105312,96777,106218,106363,107284,48449,107982,107998,109573,32095,110716,116277,116868,115860,116235,118093,118212,118444,118784,119103,120158,120716,120728,120890,121255,121832,122598,122605,122813,122837,122847,122948,123028,124240,124496,124829,125043,125617,126047,126638,126974,126788,128254,128625,129505,56923,130333,131132,131416,131417,131961,132000,132561,115138,133776,50951,134213,97395,134970,135096,135260,135936,136066,136304,137289,137355,137697,138503,62983,141357,142766,143790,143998,144124,145282,10805,148271,148497,116726,143946,151653,140026,151806,151608,141886,147863,155998,157308,27462,157708,158443,159685,159757,131937,165188,165682,170694,167005,174261,175336,177027,178221,180393,48167,186696,188175,189469,191054,192225,194790,195132,197080,197919,198629,192186,199871,199058,200511,200615,201102,201264,203224,204567,205009,206062,206491,206592,207579,208542,106026,209038,7740,187046,211324,202235,212063,3368,214806,215021,215461,215810,215862,216274,216356,217796,218169,189788,220475,221953,227999,228918,232597,232614,233118,216278,43634,236436,217969,238231,239067,29145,239309,239859,106342,231298,249361,162484,381092,423504)

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 = 423 AND W.type_id = 1) OR (W.util_id <> 423 AND W.type_id = 2)) AND (M.post_util_id = 423 OR M.dest_util_id = 423) 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=423 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 = 738 AND W.type_id = 1) OR (W.util_id <> 738 AND W.type_id = 2)) AND (M.post_util_id = 738 OR M.dest_util_id = 738) 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=738 AND note_visu IN (1,3,4)

27. 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 = 4390 AND W.type_id = 1) OR (W.util_id <> 4390 AND W.type_id = 2)) AND (M.post_util_id = 4390 OR M.dest_util_id = 4390) 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=4390 AND note_visu IN (1,3,4)

29. 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 = 4693 AND W.type_id = 1) OR (W.util_id <> 4693 AND W.type_id = 2)) AND (M.post_util_id = 4693 OR M.dest_util_id = 4693) 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=4693 AND note_visu IN (1,3,4)

31. 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 = 6324 AND W.type_id = 1) OR (W.util_id <> 6324 AND W.type_id = 2)) AND (M.post_util_id = 6324 OR M.dest_util_id = 6324) 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=6324 AND note_visu IN (1,3,4)

33. 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 = 7336 AND W.type_id = 1) OR (W.util_id <> 7336 AND W.type_id = 2)) AND (M.post_util_id = 7336 OR M.dest_util_id = 7336) 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=7336 AND note_visu IN (1,3,4)

35. 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 = 6208 AND W.type_id = 1) OR (W.util_id <> 6208 AND W.type_id = 2)) AND (M.post_util_id = 6208 OR M.dest_util_id = 6208) 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=6208 AND note_visu IN (1,3,4)

37. 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 = 8780 AND W.type_id = 1) OR (W.util_id <> 8780 AND W.type_id = 2)) AND (M.post_util_id = 8780 OR M.dest_util_id = 8780) 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=8780 AND note_visu IN (1,3,4)

39. 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 = 9848 AND W.type_id = 1) OR (W.util_id <> 9848 AND W.type_id = 2)) AND (M.post_util_id = 9848 OR M.dest_util_id = 9848) 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=9848 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 = 10675 AND W.type_id = 1) OR (W.util_id <> 10675 AND W.type_id = 2)) AND (M.post_util_id = 10675 OR M.dest_util_id = 10675) 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=10675 AND note_visu IN (1,3,4)

43. 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 = 11004 AND W.type_id = 1) OR (W.util_id <> 11004 AND W.type_id = 2)) AND (M.post_util_id = 11004 OR M.dest_util_id = 11004) 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=11004 AND note_visu IN (1,3,4)

45. 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 = 12264 AND W.type_id = 1) OR (W.util_id <> 12264 AND W.type_id = 2)) AND (M.post_util_id = 12264 OR M.dest_util_id = 12264) 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=12264 AND note_visu IN (1,3,4)

47. 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 = 12347 AND W.type_id = 1) OR (W.util_id <> 12347 AND W.type_id = 2)) AND (M.post_util_id = 12347 OR M.dest_util_id = 12347) 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=12347 AND note_visu IN (1,3,4)

49. 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 = 15461 AND W.type_id = 1) OR (W.util_id <> 15461 AND W.type_id = 2)) AND (M.post_util_id = 15461 OR M.dest_util_id = 15461) 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=15461 AND note_visu IN (1,3,4)

51. 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 = 9023 AND W.type_id = 1) OR (W.util_id <> 9023 AND W.type_id = 2)) AND (M.post_util_id = 9023 OR M.dest_util_id = 9023) 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=9023 AND note_visu IN (1,3,4)

53. 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 = 17618 AND W.type_id = 1) OR (W.util_id <> 17618 AND W.type_id = 2)) AND (M.post_util_id = 17618 OR M.dest_util_id = 17618) 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=17618 AND note_visu IN (1,3,4)

55. 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 = 17620 AND W.type_id = 1) OR (W.util_id <> 17620 AND W.type_id = 2)) AND (M.post_util_id = 17620 OR M.dest_util_id = 17620) 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=17620 AND note_visu IN (1,3,4)

57. 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 = 19234 AND W.type_id = 1) OR (W.util_id <> 19234 AND W.type_id = 2)) AND (M.post_util_id = 19234 OR M.dest_util_id = 19234) 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=19234 AND note_visu IN (1,3,4)

59. 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 = 19240 AND W.type_id = 1) OR (W.util_id <> 19240 AND W.type_id = 2)) AND (M.post_util_id = 19240 OR M.dest_util_id = 19240) 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=19240 AND note_visu IN (1,3,4)

61. 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 = 21149 AND W.type_id = 1) OR (W.util_id <> 21149 AND W.type_id = 2)) AND (M.post_util_id = 21149 OR M.dest_util_id = 21149) 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=21149 AND note_visu IN (1,3,4)

63. 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 = 20926 AND W.type_id = 1) OR (W.util_id <> 20926 AND W.type_id = 2)) AND (M.post_util_id = 20926 OR M.dest_util_id = 20926) 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=20926 AND note_visu IN (1,3,4)

65. 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 = 22769 AND W.type_id = 1) OR (W.util_id <> 22769 AND W.type_id = 2)) AND (M.post_util_id = 22769 OR M.dest_util_id = 22769) 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=22769 AND note_visu IN (1,3,4)

67. 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 = 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 <> ''

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

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 = 24428 AND W.type_id = 1) OR (W.util_id <> 24428 AND W.type_id = 2)) AND (M.post_util_id = 24428 OR M.dest_util_id = 24428) 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=24428 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 = 25767 AND W.type_id = 1) OR (W.util_id <> 25767 AND W.type_id = 2)) AND (M.post_util_id = 25767 OR M.dest_util_id = 25767) 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=25767 AND note_visu IN (1,3,4)

73. 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 = 27037 AND W.type_id = 1) OR (W.util_id <> 27037 AND W.type_id = 2)) AND (M.post_util_id = 27037 OR M.dest_util_id = 27037) 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=27037 AND note_visu IN (1,3,4)

75. 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 = 27597 AND W.type_id = 1) OR (W.util_id <> 27597 AND W.type_id = 2)) AND (M.post_util_id = 27597 OR M.dest_util_id = 27597) 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=27597 AND note_visu IN (1,3,4)

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

79. 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 = 31402 AND W.type_id = 1) OR (W.util_id <> 31402 AND W.type_id = 2)) AND (M.post_util_id = 31402 OR M.dest_util_id = 31402) 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=31402 AND note_visu IN (1,3,4)

81. 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 = 31367 AND W.type_id = 1) OR (W.util_id <> 31367 AND W.type_id = 2)) AND (M.post_util_id = 31367 OR M.dest_util_id = 31367) 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=31367 AND note_visu IN (1,3,4)

83. 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 = 33300 AND W.type_id = 1) OR (W.util_id <> 33300 AND W.type_id = 2)) AND (M.post_util_id = 33300 OR M.dest_util_id = 33300) 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=33300 AND note_visu IN (1,3,4)

85. 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 = 39336 AND W.type_id = 1) OR (W.util_id <> 39336 AND W.type_id = 2)) AND (M.post_util_id = 39336 OR M.dest_util_id = 39336) 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=39336 AND note_visu IN (1,3,4)

87. 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 = 43971 AND W.type_id = 1) OR (W.util_id <> 43971 AND W.type_id = 2)) AND (M.post_util_id = 43971 OR M.dest_util_id = 43971) 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=43971 AND note_visu IN (1,3,4)

89. 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 = 47958 AND W.type_id = 1) OR (W.util_id <> 47958 AND W.type_id = 2)) AND (M.post_util_id = 47958 OR M.dest_util_id = 47958) 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=47958 AND note_visu IN (1,3,4)

91. 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 = 49407 AND W.type_id = 1) OR (W.util_id <> 49407 AND W.type_id = 2)) AND (M.post_util_id = 49407 OR M.dest_util_id = 49407) 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=49407 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 = 50806 AND W.type_id = 1) OR (W.util_id <> 50806 AND W.type_id = 2)) AND (M.post_util_id = 50806 OR M.dest_util_id = 50806) 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=50806 AND note_visu IN (1,3,4)

95. 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 = 51963 AND W.type_id = 1) OR (W.util_id <> 51963 AND W.type_id = 2)) AND (M.post_util_id = 51963 OR M.dest_util_id = 51963) 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=51963 AND note_visu IN (1,3,4)

97. 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 = 55793 AND W.type_id = 1) OR (W.util_id <> 55793 AND W.type_id = 2)) AND (M.post_util_id = 55793 OR M.dest_util_id = 55793) 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=55793 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 = 56197 AND W.type_id = 1) OR (W.util_id <> 56197 AND W.type_id = 2)) AND (M.post_util_id = 56197 OR M.dest_util_id = 56197) 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=56197 AND note_visu IN (1,3,4)

101. 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 = 58873 AND W.type_id = 1) OR (W.util_id <> 58873 AND W.type_id = 2)) AND (M.post_util_id = 58873 OR M.dest_util_id = 58873) 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=58873 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 = 58954 AND W.type_id = 1) OR (W.util_id <> 58954 AND W.type_id = 2)) AND (M.post_util_id = 58954 OR M.dest_util_id = 58954) 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=58954 AND note_visu IN (1,3,4)

105. 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 = 14790 AND W.type_id = 1) OR (W.util_id <> 14790 AND W.type_id = 2)) AND (M.post_util_id = 14790 OR M.dest_util_id = 14790) 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=14790 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 = 59171 AND W.type_id = 1) OR (W.util_id <> 59171 AND W.type_id = 2)) AND (M.post_util_id = 59171 OR M.dest_util_id = 59171) 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=59171 AND note_visu IN (1,3,4)

109. 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 = 59586 AND W.type_id = 1) OR (W.util_id <> 59586 AND W.type_id = 2)) AND (M.post_util_id = 59586 OR M.dest_util_id = 59586) 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=59586 AND note_visu IN (1,3,4)

111. 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 = 60484 AND W.type_id = 1) OR (W.util_id <> 60484 AND W.type_id = 2)) AND (M.post_util_id = 60484 OR M.dest_util_id = 60484) 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=60484 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 = 60636 AND W.type_id = 1) OR (W.util_id <> 60636 AND W.type_id = 2)) AND (M.post_util_id = 60636 OR M.dest_util_id = 60636) 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=60636 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 = 62190 AND W.type_id = 1) OR (W.util_id <> 62190 AND W.type_id = 2)) AND (M.post_util_id = 62190 OR M.dest_util_id = 62190) 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=62190 AND note_visu IN (1,3,4)

117. 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 = 53771 AND W.type_id = 1) OR (W.util_id <> 53771 AND W.type_id = 2)) AND (M.post_util_id = 53771 OR M.dest_util_id = 53771) 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=53771 AND note_visu IN (1,3,4)

119. 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 = 62331 AND W.type_id = 1) OR (W.util_id <> 62331 AND W.type_id = 2)) AND (M.post_util_id = 62331 OR M.dest_util_id = 62331) 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=62331 AND note_visu IN (1,3,4)

121. 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 = 62693 AND W.type_id = 1) OR (W.util_id <> 62693 AND W.type_id = 2)) AND (M.post_util_id = 62693 OR M.dest_util_id = 62693) 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=62693 AND note_visu IN (1,3,4)

123. 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 = 63192 AND W.type_id = 1) OR (W.util_id <> 63192 AND W.type_id = 2)) AND (M.post_util_id = 63192 OR M.dest_util_id = 63192) 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=63192 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 = 63444 AND W.type_id = 1) OR (W.util_id <> 63444 AND W.type_id = 2)) AND (M.post_util_id = 63444 OR M.dest_util_id = 63444) 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=63444 AND note_visu IN (1,3,4)

127. 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 = 63825 AND W.type_id = 1) OR (W.util_id <> 63825 AND W.type_id = 2)) AND (M.post_util_id = 63825 OR M.dest_util_id = 63825) 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=63825 AND note_visu IN (1,3,4)

129. 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 = 63948 AND W.type_id = 1) OR (W.util_id <> 63948 AND W.type_id = 2)) AND (M.post_util_id = 63948 OR M.dest_util_id = 63948) 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=63948 AND note_visu IN (1,3,4)

131. 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 = 64480 AND W.type_id = 1) OR (W.util_id <> 64480 AND W.type_id = 2)) AND (M.post_util_id = 64480 OR M.dest_util_id = 64480) 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=64480 AND note_visu IN (1,3,4)

133. 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 = 65190 AND W.type_id = 1) OR (W.util_id <> 65190 AND W.type_id = 2)) AND (M.post_util_id = 65190 OR M.dest_util_id = 65190) 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=65190 AND note_visu IN (1,3,4)

135. 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 = 65706 AND W.type_id = 1) OR (W.util_id <> 65706 AND W.type_id = 2)) AND (M.post_util_id = 65706 OR M.dest_util_id = 65706) 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=65706 AND note_visu IN (1,3,4)

137. 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 = 65853 AND W.type_id = 1) OR (W.util_id <> 65853 AND W.type_id = 2)) AND (M.post_util_id = 65853 OR M.dest_util_id = 65853) 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=65853 AND note_visu IN (1,3,4)

139. 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 = 66392 AND W.type_id = 1) OR (W.util_id <> 66392 AND W.type_id = 2)) AND (M.post_util_id = 66392 OR M.dest_util_id = 66392) 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=66392 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 = 66833 AND W.type_id = 1) OR (W.util_id <> 66833 AND W.type_id = 2)) AND (M.post_util_id = 66833 OR M.dest_util_id = 66833) 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=66833 AND note_visu IN (1,3,4)

143. 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 = 69187 AND W.type_id = 1) OR (W.util_id <> 69187 AND W.type_id = 2)) AND (M.post_util_id = 69187 OR M.dest_util_id = 69187) 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=69187 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 = 69361 AND W.type_id = 1) OR (W.util_id <> 69361 AND W.type_id = 2)) AND (M.post_util_id = 69361 OR M.dest_util_id = 69361) 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=69361 AND note_visu IN (1,3,4)

147. 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 = 70302 AND W.type_id = 1) OR (W.util_id <> 70302 AND W.type_id = 2)) AND (M.post_util_id = 70302 OR M.dest_util_id = 70302) 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=70302 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 = 70648 AND W.type_id = 1) OR (W.util_id <> 70648 AND W.type_id = 2)) AND (M.post_util_id = 70648 OR M.dest_util_id = 70648) 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=70648 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 = 71509 AND W.type_id = 1) OR (W.util_id <> 71509 AND W.type_id = 2)) AND (M.post_util_id = 71509 OR M.dest_util_id = 71509) 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=71509 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 = 69855 AND W.type_id = 1) OR (W.util_id <> 69855 AND W.type_id = 2)) AND (M.post_util_id = 69855 OR M.dest_util_id = 69855) 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=69855 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 = 72573 AND W.type_id = 1) OR (W.util_id <> 72573 AND W.type_id = 2)) AND (M.post_util_id = 72573 OR M.dest_util_id = 72573) 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=72573 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 = 73123 AND W.type_id = 1) OR (W.util_id <> 73123 AND W.type_id = 2)) AND (M.post_util_id = 73123 OR M.dest_util_id = 73123) 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=73123 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 = 6557 AND W.type_id = 1) OR (W.util_id <> 6557 AND W.type_id = 2)) AND (M.post_util_id = 6557 OR M.dest_util_id = 6557) 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=6557 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 = 74369 AND W.type_id = 1) OR (W.util_id <> 74369 AND W.type_id = 2)) AND (M.post_util_id = 74369 OR M.dest_util_id = 74369) 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=74369 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 = 74482 AND W.type_id = 1) OR (W.util_id <> 74482 AND W.type_id = 2)) AND (M.post_util_id = 74482 OR M.dest_util_id = 74482) 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=74482 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 = 74567 AND W.type_id = 1) OR (W.util_id <> 74567 AND W.type_id = 2)) AND (M.post_util_id = 74567 OR M.dest_util_id = 74567) 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=74567 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 = 51050 AND W.type_id = 1) OR (W.util_id <> 51050 AND W.type_id = 2)) AND (M.post_util_id = 51050 OR M.dest_util_id = 51050) 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=51050 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 = 77937 AND W.type_id = 1) OR (W.util_id <> 77937 AND W.type_id = 2)) AND (M.post_util_id = 77937 OR M.dest_util_id = 77937) 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=77937 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 = 78686 AND W.type_id = 1) OR (W.util_id <> 78686 AND W.type_id = 2)) AND (M.post_util_id = 78686 OR M.dest_util_id = 78686) 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=78686 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 = 77908 AND W.type_id = 1) OR (W.util_id <> 77908 AND W.type_id = 2)) AND (M.post_util_id = 77908 OR M.dest_util_id = 77908) 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=77908 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 = 80248 AND W.type_id = 1) OR (W.util_id <> 80248 AND W.type_id = 2)) AND (M.post_util_id = 80248 OR M.dest_util_id = 80248) 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=80248 AND note_visu IN (1,3,4)

177. 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 = 81477 AND W.type_id = 1) OR (W.util_id <> 81477 AND W.type_id = 2)) AND (M.post_util_id = 81477 OR M.dest_util_id = 81477) 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=81477 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 = 82121 AND W.type_id = 1) OR (W.util_id <> 82121 AND W.type_id = 2)) AND (M.post_util_id = 82121 OR M.dest_util_id = 82121) 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=82121 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 = 82155 AND W.type_id = 1) OR (W.util_id <> 82155 AND W.type_id = 2)) AND (M.post_util_id = 82155 OR M.dest_util_id = 82155) 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=82155 AND note_visu IN (1,3,4)

183. 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 = 82765 AND W.type_id = 1) OR (W.util_id <> 82765 AND W.type_id = 2)) AND (M.post_util_id = 82765 OR M.dest_util_id = 82765) 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=82765 AND note_visu IN (1,3,4)

185. 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 = 75269 AND W.type_id = 1) OR (W.util_id <> 75269 AND W.type_id = 2)) AND (M.post_util_id = 75269 OR M.dest_util_id = 75269) 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=75269 AND note_visu IN (1,3,4)

187. 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 = 61938 AND W.type_id = 1) OR (W.util_id <> 61938 AND W.type_id = 2)) AND (M.post_util_id = 61938 OR M.dest_util_id = 61938) 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=61938 AND note_visu IN (1,3,4)

189. 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 = 85928 AND W.type_id = 1) OR (W.util_id <> 85928 AND W.type_id = 2)) AND (M.post_util_id = 85928 OR M.dest_util_id = 85928) 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=85928 AND note_visu IN (1,3,4)

191. 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 = 86197 AND W.type_id = 1) OR (W.util_id <> 86197 AND W.type_id = 2)) AND (M.post_util_id = 86197 OR M.dest_util_id = 86197) 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=86197 AND note_visu IN (1,3,4)

193. 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 = 86375 AND W.type_id = 1) OR (W.util_id <> 86375 AND W.type_id = 2)) AND (M.post_util_id = 86375 OR M.dest_util_id = 86375) 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=86375 AND note_visu IN (1,3,4)

195. 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 = 81736 AND W.type_id = 1) OR (W.util_id <> 81736 AND W.type_id = 2)) AND (M.post_util_id = 81736 OR M.dest_util_id = 81736) 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=81736 AND note_visu IN (1,3,4)

197. 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 = 88170 AND W.type_id = 1) OR (W.util_id <> 88170 AND W.type_id = 2)) AND (M.post_util_id = 88170 OR M.dest_util_id = 88170) 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=88170 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 = 89393 AND W.type_id = 1) OR (W.util_id <> 89393 AND W.type_id = 2)) AND (M.post_util_id = 89393 OR M.dest_util_id = 89393) 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=89393 AND note_visu IN (1,3,4)

201. 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 = 89441 AND W.type_id = 1) OR (W.util_id <> 89441 AND W.type_id = 2)) AND (M.post_util_id = 89441 OR M.dest_util_id = 89441) 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=89441 AND note_visu IN (1,3,4)

203. 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 = 89704 AND W.type_id = 1) OR (W.util_id <> 89704 AND W.type_id = 2)) AND (M.post_util_id = 89704 OR M.dest_util_id = 89704) 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=89704 AND note_visu IN (1,3,4)

205. 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 = 88322 AND W.type_id = 1) OR (W.util_id <> 88322 AND W.type_id = 2)) AND (M.post_util_id = 88322 OR M.dest_util_id = 88322) 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=88322 AND note_visu IN (1,3,4)

207. 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 = 90086 AND W.type_id = 1) OR (W.util_id <> 90086 AND W.type_id = 2)) AND (M.post_util_id = 90086 OR M.dest_util_id = 90086) 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=90086 AND note_visu IN (1,3,4)

209. 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 = 90903 AND W.type_id = 1) OR (W.util_id <> 90903 AND W.type_id = 2)) AND (M.post_util_id = 90903 OR M.dest_util_id = 90903) 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=90903 AND note_visu IN (1,3,4)

211. 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 = 91059 AND W.type_id = 1) OR (W.util_id <> 91059 AND W.type_id = 2)) AND (M.post_util_id = 91059 OR M.dest_util_id = 91059) 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=91059 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 = 92193 AND W.type_id = 1) OR (W.util_id <> 92193 AND W.type_id = 2)) AND (M.post_util_id = 92193 OR M.dest_util_id = 92193) 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=92193 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 = 93253 AND W.type_id = 1) OR (W.util_id <> 93253 AND W.type_id = 2)) AND (M.post_util_id = 93253 OR M.dest_util_id = 93253) 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=93253 AND note_visu IN (1,3,4)

217. 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 = 93993 AND W.type_id = 1) OR (W.util_id <> 93993 AND W.type_id = 2)) AND (M.post_util_id = 93993 OR M.dest_util_id = 93993) 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=93993 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 = 94876 AND W.type_id = 1) OR (W.util_id <> 94876 AND W.type_id = 2)) AND (M.post_util_id = 94876 OR M.dest_util_id = 94876) 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=94876 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 = 94905 AND W.type_id = 1) OR (W.util_id <> 94905 AND W.type_id = 2)) AND (M.post_util_id = 94905 OR M.dest_util_id = 94905) 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=94905 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 = 96475 AND W.type_id = 1) OR (W.util_id <> 96475 AND W.type_id = 2)) AND (M.post_util_id = 96475 OR M.dest_util_id = 96475) 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=96475 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 = 97683 AND W.type_id = 1) OR (W.util_id <> 97683 AND W.type_id = 2)) AND (M.post_util_id = 97683 OR M.dest_util_id = 97683) 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=97683 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 = 98325 AND W.type_id = 1) OR (W.util_id <> 98325 AND W.type_id = 2)) AND (M.post_util_id = 98325 OR M.dest_util_id = 98325) 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=98325 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 = 100625 AND W.type_id = 1) OR (W.util_id <> 100625 AND W.type_id = 2)) AND (M.post_util_id = 100625 OR M.dest_util_id = 100625) 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=100625 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 = 101004 AND W.type_id = 1) OR (W.util_id <> 101004 AND W.type_id = 2)) AND (M.post_util_id = 101004 OR M.dest_util_id = 101004) 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=101004 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 = 102566 AND W.type_id = 1) OR (W.util_id <> 102566 AND W.type_id = 2)) AND (M.post_util_id = 102566 OR M.dest_util_id = 102566) 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=102566 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 = 85830 AND W.type_id = 1) OR (W.util_id <> 85830 AND W.type_id = 2)) AND (M.post_util_id = 85830 OR M.dest_util_id = 85830) 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=85830 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 = 104449 AND W.type_id = 1) OR (W.util_id <> 104449 AND W.type_id = 2)) AND (M.post_util_id = 104449 OR M.dest_util_id = 104449) 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=104449 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 = 96406 AND W.type_id = 1) OR (W.util_id <> 96406 AND W.type_id = 2)) AND (M.post_util_id = 96406 OR M.dest_util_id = 96406) 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=96406 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 = 104671 AND W.type_id = 1) OR (W.util_id <> 104671 AND W.type_id = 2)) AND (M.post_util_id = 104671 OR M.dest_util_id = 104671) 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=104671 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 = 105312 AND W.type_id = 1) OR (W.util_id <> 105312 AND W.type_id = 2)) AND (M.post_util_id = 105312 OR M.dest_util_id = 105312) 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=105312 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 = 96777 AND W.type_id = 1) OR (W.util_id <> 96777 AND W.type_id = 2)) AND (M.post_util_id = 96777 OR M.dest_util_id = 96777) 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=96777 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 = 106218 AND W.type_id = 1) OR (W.util_id <> 106218 AND W.type_id = 2)) AND (M.post_util_id = 106218 OR M.dest_util_id = 106218) 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=106218 AND note_visu IN (1,3,4)

249. 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 = 106363 AND W.type_id = 1) OR (W.util_id <> 106363 AND W.type_id = 2)) AND (M.post_util_id = 106363 OR M.dest_util_id = 106363) 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=106363 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 = 107284 AND W.type_id = 1) OR (W.util_id <> 107284 AND W.type_id = 2)) AND (M.post_util_id = 107284 OR M.dest_util_id = 107284) 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=107284 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 = 48449 AND W.type_id = 1) OR (W.util_id <> 48449 AND W.type_id = 2)) AND (M.post_util_id = 48449 OR M.dest_util_id = 48449) 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=48449 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 = 107982 AND W.type_id = 1) OR (W.util_id <> 107982 AND W.type_id = 2)) AND (M.post_util_id = 107982 OR M.dest_util_id = 107982) 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=107982 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 = 107998 AND W.type_id = 1) OR (W.util_id <> 107998 AND W.type_id = 2)) AND (M.post_util_id = 107998 OR M.dest_util_id = 107998) 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=107998 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 = 109573 AND W.type_id = 1) OR (W.util_id <> 109573 AND W.type_id = 2)) AND (M.post_util_id = 109573 OR M.dest_util_id = 109573) 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=109573 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 = 32095 AND W.type_id = 1) OR (W.util_id <> 32095 AND W.type_id = 2)) AND (M.post_util_id = 32095 OR M.dest_util_id = 32095) 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=32095 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 = 110716 AND W.type_id = 1) OR (W.util_id <> 110716 AND W.type_id = 2)) AND (M.post_util_id = 110716 OR M.dest_util_id = 110716) 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=110716 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 = 116277 AND W.type_id = 1) OR (W.util_id <> 116277 AND W.type_id = 2)) AND (M.post_util_id = 116277 OR M.dest_util_id = 116277) 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=116277 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 = 116868 AND W.type_id = 1) OR (W.util_id <> 116868 AND W.type_id = 2)) AND (M.post_util_id = 116868 OR M.dest_util_id = 116868) 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=116868 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 = 115860 AND W.type_id = 1) OR (W.util_id <> 115860 AND W.type_id = 2)) AND (M.post_util_id = 115860 OR M.dest_util_id = 115860) 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=115860 AND note_visu IN (1,3,4)

271. 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 = 116235 AND W.type_id = 1) OR (W.util_id <> 116235 AND W.type_id = 2)) AND (M.post_util_id = 116235 OR M.dest_util_id = 116235) 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=116235 AND note_visu IN (1,3,4)

273. 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 = 118093 AND W.type_id = 1) OR (W.util_id <> 118093 AND W.type_id = 2)) AND (M.post_util_id = 118093 OR M.dest_util_id = 118093) 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=118093 AND note_visu IN (1,3,4)

275. 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 = 118212 AND W.type_id = 1) OR (W.util_id <> 118212 AND W.type_id = 2)) AND (M.post_util_id = 118212 OR M.dest_util_id = 118212) 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=118212 AND note_visu IN (1,3,4)

277. 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 = 118444 AND W.type_id = 1) OR (W.util_id <> 118444 AND W.type_id = 2)) AND (M.post_util_id = 118444 OR M.dest_util_id = 118444) 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=118444 AND note_visu IN (1,3,4)

279. 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 = 118784 AND W.type_id = 1) OR (W.util_id <> 118784 AND W.type_id = 2)) AND (M.post_util_id = 118784 OR M.dest_util_id = 118784) 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=118784 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 = 119103 AND W.type_id = 1) OR (W.util_id <> 119103 AND W.type_id = 2)) AND (M.post_util_id = 119103 OR M.dest_util_id = 119103) 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=119103 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 = 120158 AND W.type_id = 1) OR (W.util_id <> 120158 AND W.type_id = 2)) AND (M.post_util_id = 120158 OR M.dest_util_id = 120158) 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=120158 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 = 120716 AND W.type_id = 1) OR (W.util_id <> 120716 AND W.type_id = 2)) AND (M.post_util_id = 120716 OR M.dest_util_id = 120716) 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=120716 AND note_visu IN (1,3,4)

287. 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 = 120728 AND W.type_id = 1) OR (W.util_id <> 120728 AND W.type_id = 2)) AND (M.post_util_id = 120728 OR M.dest_util_id = 120728) 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=120728 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 = 120890 AND W.type_id = 1) OR (W.util_id <> 120890 AND W.type_id = 2)) AND (M.post_util_id = 120890 OR M.dest_util_id = 120890) 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=120890 AND note_visu IN (1,3,4)

291. 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 = 121255 AND W.type_id = 1) OR (W.util_id <> 121255 AND W.type_id = 2)) AND (M.post_util_id = 121255 OR M.dest_util_id = 121255) 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=121255 AND note_visu IN (1,3,4)

293. 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 = 121832 AND W.type_id = 1) OR (W.util_id <> 121832 AND W.type_id = 2)) AND (M.post_util_id = 121832 OR M.dest_util_id = 121832) 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=121832 AND note_visu IN (1,3,4)

295. 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 = 122598 AND W.type_id = 1) OR (W.util_id <> 122598 AND W.type_id = 2)) AND (M.post_util_id = 122598 OR M.dest_util_id = 122598) 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=122598 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 = 122605 AND W.type_id = 1) OR (W.util_id <> 122605 AND W.type_id = 2)) AND (M.post_util_id = 122605 OR M.dest_util_id = 122605) 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=122605 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 = 122813 AND W.type_id = 1) OR (W.util_id <> 122813 AND W.type_id = 2)) AND (M.post_util_id = 122813 OR M.dest_util_id = 122813) 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=122813 AND note_visu IN (1,3,4)

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

302. 0.0001

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

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

304. 0.0001

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

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

306. 0.0001

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

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

308. 0.0001

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

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

310. 0.0001

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

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

312. 0.0001

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

313. 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 = 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 <> ''

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

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

316. 0.0001

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

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

318. 0.0001

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

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

320. 0.0001

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

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

322. 0.0001

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

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

324. 0.0001

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

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

326. 0.0001

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

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

328. 0.0001

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

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

330. 0.0001

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

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

332. 0.0001

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

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

334. 0.0001

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

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

336. 0.0001

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

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

338. 0.0001

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

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

340. 0.0001

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

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

342. 0.0001

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

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

344. 0.0001

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

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

346. 0.0001

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

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

348. 0.0001

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

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

350. 0.0001

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

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

352. 0.0001

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

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

354. 0.0001

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

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

356. 0.0001

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

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

358. 0.0001

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

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

360. 0.0001

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

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

362. 0.0001

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

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

364. 0.0001

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

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

366. 0.0001

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

367. 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 = 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 <> ''

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

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

370. 0.0001

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

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

372. 0.0001

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

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

374. 0.0001

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

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

376. 0.0001

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

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

378. 0.0001

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

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

380. 0.0001

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

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

382. 0.0001

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

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

384. 0.0001

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

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

386. 0.0001

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

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

388. 0.0001

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

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

390. 0.0001

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

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

392. 0.0001

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

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

394. 0.0001

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

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

396. 0.0001

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

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

398. 0.0001

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

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

400. 0.0001

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

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

402. 0.0001

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

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

404. 0.0001

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

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

406. 0.0001

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

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

408. 0.0001

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

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

410. 0.0001

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

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

412. 0.0001

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

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

414. 0.0001

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

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

416. 0.0001

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

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

418. 0.0001

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

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

420. 0.0001

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

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

422. 0.0001

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

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

424. 0.0001

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

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

426. 0.0001

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

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

428. 0.0001

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

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

430. 0.0001

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

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

432. 0.0001

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

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

434. 0.0001

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

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

436. 0.0001

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

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

438. 0.0001

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

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

440. 0.0001

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

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

442. 0.0001

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

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

444. 0.0001

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

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

446. 0.0001

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

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

448. 0.0001

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

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

450. 0.0001

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

451. 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 = 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 <> ''

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

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

454. 0.0001

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

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

456. 0.0001

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

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

458. 0.0001

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

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

460. 0.0001

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

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

462. 0.0001

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

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

464. 0.0001

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

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

466. 0.0001

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

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

468. 0.0001

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

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

470. 0.0001

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

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

472. 0.0001

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

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

474. 0.0001

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

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

476. 0.0001

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

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

478. 0.0001

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

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

480. 0.0001

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

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

482. 0.0001

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

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

484. 0.0001

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

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

486. 0.0001

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

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

488. 0.0001

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

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

490. 0.0001

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

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

492. 0.0001

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

493. 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 <> ''

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

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

496. 0.0001

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

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

498. 0.0001

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

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

500. 0.0001

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

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

502. 0.0001

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

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

504. 0.0001

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

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

506. 0.0001

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

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

508. 0.0001

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

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

510. 0.0001

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

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

512. 0.0001

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

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

514. 0.0001

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

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

516. 0.0001

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

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

518. 0.0001

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

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

520. 0.0001

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

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

522. 0.0001

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

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

524. 0.0001

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

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

526. 0.0001

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

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

528. 0.0001

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

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

530. 0.0001

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

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

532. 0.0001

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

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

534. 0.0001

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

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

536. 0.0001

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

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

538. 0.0001

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

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

540. 0.0001

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

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

542. 0.0001

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

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

544. 0.0001

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

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

546. 0.0001

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

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

548. 0.0001

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

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

550. 0.0001

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

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

552. 0.0001

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

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

554. 0.0001

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

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

556. 0.0001

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

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

558. 0.0001

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

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

560. 0.0001

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

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

562. 0.0001

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

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

564. 0.0001

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

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

566. 0.0001

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

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

568. 0.0001

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

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

570. 0.0001

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

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

572. 0.0001

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

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

574. 0.0001

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

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

576. 0.0001

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

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

578. 0.0001

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

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

580. 0.0001

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

581. 0.0001

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

582. 0.002

     SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.686835678816 AND ville_latitude_deg<49.046564321184 AND ville_longitude_deg>1.9599018543365 AND ville_longitude_deg<2.5067581456635 HAVING distance <= 20 ORDER BY distance ASC

583. 0.0063

     SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.417039197041 AND ville_latitude_deg<49.316360802959 AND ville_longitude_deg>1.5497537413096 AND ville_longitude_deg<2.9169062586904 HAVING distance <= 50 ORDER BY distance ASC

584. 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 (1104,984,1099,546,1027,1103,945,907,537)

585. 0.0002

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (63825,233118,122837,61938,82155,175336,31367,82121,70648,63948,8780,6324,381092,228918,4390,138503,131416,135260,159685,96777,98325,124829,206491,88322,136066,188175,423504,48167,148271,58954,118444,122813,116277,56923,105312,94905,29145,65706,109573,64480,89393,162484,69361,9848,141357,59586,9023,62190,216356,27462,106363,104449)

586. 0.0002

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (63825,233118,122837,61938,82155,175336,31367,82121,70648,63948,8780,6324,381092,228918,4390,138503,131416,135260,159685,96777,98325,124829,206491,88322,136066,188175,423504,48167,148271,58954,118444,122813,116277,56923,105312,94905,29145,65706,109573,64480,89393,162484,69361,9848,141357,59586,9023,62190,216356,27462,106363,104449)

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

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

589. 0.0001

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

590. 0.0001

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

591. 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

592. 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 (50) ORDER BY ssrubr_order ASC

593. 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 (38) ORDER BY ssrubr_order ASC

594. 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 (45) ORDER BY ssrubr_order ASC

595. 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 (231) ORDER BY ssrubr_order ASC

596. 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 (47) ORDER BY ssrubr_order ASC

597. 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 (42) ORDER BY ssrubr_order ASC

598. 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 (37) ORDER BY ssrubr_order ASC

599. 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 (43) ORDER BY ssrubr_order ASC

600. 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 (39) ORDER BY ssrubr_order ASC

601. 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

602. 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 (230) ORDER BY ssrubr_order ASC

603. 0.001

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

604. 0.0232

     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'

605. 0.0164

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

605 requetes sql en 0.146