Service peintre à 78290 Croissy-sur-seine

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

3. 0.0001

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

4. 0

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'

5. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='78290' AND ville_nom like '%croissy%sur%seine%' ORDER BY ville_population_2012 DESC LIMIT 0,1

6. 0.0005

   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 '%peintre%' OR ssrubr_title like '%peintre%' OR ssrubr_slug like '%peintre%') AND cate_id='50' 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='78290'

12. 0.0029

    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.13333- 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.8599018543365 AND ville_longitude_deg<2.4067581456635 HAVING distance <= 20 ORDER BY distance ASC

13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='peintre'

14. 0.0003

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

15. 0.0001

    SELECT * FROM texte WHERE cate_id=50

16. 0.0002

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

17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='peintre' AND cate_id='50'

18. 0.0001

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

19. 0.0028

    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.13333- 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.8599018543365 AND ville_longitude_deg<2.4067581456635 HAVING distance <= 20 ORDER BY distance ASC

20. 0.0088

    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.13333- 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.4497537413096 AND ville_longitude_deg<2.8169062586904 HAVING distance <= 50 ORDER BY distance ASC

21. 0.0732

    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.13333- 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='50' AND MATCH (wish_desc) AGAINST ('(+peintre*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (78290,78290,78380,78430,78560,78400,78170,78160,78110,78150,78750,78870,78230,92380,78150,92430,92420,78620,78100,78112,92500,78590,78360,92000,92410,78420,92210,78590,92800,92150,78800,92310,78000,78600,78220,78240,78330,78140,78860,78210,92370,92250,78240,92100,78450,92400,78600,95870,78300,92200,78500,92700,92360,92190,78350,78530,78450,92270,92130,78390,78350,92300,95530,78955,78280,78260,92600,78810,92140,78630,78340,95100,92110,92170,78117,78700,92320,78180,92240,78670,78670,78190,92350,95370,78570,95240,95110,92230,92220,78960,91570,92330,92260,92120,78370,78810,78121,92290,78570,95130,95220,91400,78117,93400,75004,75003,75002,75000,75006,75001,75016,75005,75013,75014,75015,75017,75018,75019,75020,75116,75012,75008,75007,75011,75009,75010,78780,78540,95210,95218,78114,91430,94250,93800,78850,91430,78470,95120,78510,91370,78990,93450,92390,78630,94110,95130,91190,91190,78580,95480,92340,95610,78480,78470,94237,94240,94230,94233,94231,94232,94238,94234,94235,94236,94239,95250,95000,95880,78640,95230,92160,78640,94270,93210,93200,95280,93430,78920,78130,95600,91300,94800,78580,94260,78320,91440,95320,91120,78470,91400,93120,93300,94205,78640,94200,95000,95580,95580,78320,95000,95390,95360,94550,78310,78760,95550,95150,78460,95170,78124,93310,78650,78124,93500,95490,95680,95180) AND type_id=1 GROUP BY wish_id

22. 0.0004

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

23. 0.0001

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

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

25. 0.0001

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

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

27. 0.0001

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

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

29. 0.0001

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

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

31. 0.0001

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

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

33. 0.0001

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

34. 0.0001

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

35. 0.0001

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

36. 0.0001

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

37. 0.0001

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

38. 0.0001

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

39. 0.0001

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

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

43. 0.0001

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

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

45. 0.0001

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

46. 0.0001

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

47. 0.0001

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

48. 0.0001

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

49. 0.0001

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

50. 0.0001

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

51. 0.0001

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

52. 0.0001

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

53. 0.0001

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

54. 0.0001

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

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

65. 0.0001

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

66. 0.0001

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

67. 0.0001

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

68. 0.0001

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

69. 0.0001

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

70. 0.0001

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

71. 0.0001

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

72. 0.0001

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

73. 0.0001

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

81. 0.0001

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

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

89. 0.0001

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

90. 0.0001

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

91. 0.0001

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

92. 0.0001

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

93. 0.0001

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

94. 0.0001

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

95. 0.0001

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

96. 0.0001

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

100. 0.0001

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

101. 0.0001

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

102. 0.0001

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

103. 0.0001

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

104. 0.0001

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

105. 0.0001

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

106. 0.0001

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

128. 0.0001

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

129. 0.0001

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

130. 0.0001

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

131. 0.0001

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

132. 0.0001

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

133. 0.0001

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

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

135. 0.0001

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

136. 0.0001

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

137. 0.0001

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

138. 0.0001

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

139. 0.0001

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

140. 0.0001

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

141. 0.0001

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

142. 0.0001

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

143. 0.0001

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

144. 0.0001

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

145. 0.0001

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

146. 0.0001

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

147. 0.0001

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

148. 0.0001

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

149. 0.0001

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

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

151. 0.0001

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

152. 0.0001

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

153. 0.0001

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

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

155. 0.0001

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

156. 0.0001

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

157. 0.0001

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

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

159. 0.0001

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

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

161. 0.0001

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

162. 0.0001

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

163. 0.0001

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

164. 0.0001

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

165. 0.0001

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

166. 0.0001

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

167. 0.0001

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

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

169. 0.0001

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

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

171. 0.0001

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

172. 0.0001

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

173. 0.0001

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

174. 0.0001

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

175. 0.0001

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

176. 0.0001

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

177. 0.0001

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

178. 0.0001

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

179. 0.0001

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

180. 0.0001

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

181. 0.0001

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

182. 0.0001

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

183. 0.0001

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

184. 0.0001

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

185. 0.0001

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

186. 0.0001

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

187. 0.0001

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

188. 0.0001

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

189. 0.0001

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

190. 0.0001

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

191. 0.0001

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

192. 0.0001

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

193. 0.0001

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

194. 0.0001

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

195. 0.0001

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

196. 0.0001

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

197. 0.0001

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

198. 0.0001

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

199. 0.0001

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

200. 0.0001

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

201. 0.0001

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

202. 0.0001

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

203. 0.0001

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

204. 0.0001

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

205. 0.0001

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

206. 0.0001

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

207. 0.0001

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

208. 0.0001

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

209. 0.0001

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

210. 0.0001

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

211. 0.0001

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

212. 0.0001

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

213. 0.0001

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

214. 0.0001

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

215. 0.0001

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

216. 0.0001

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

217. 0.0001

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

218. 0.0001

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

219. 0.0001

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

220. 0.0001

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

221. 0.0001

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

222. 0.0001

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

223. 0.0001

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

224. 0.0001

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

225. 0.0001

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

226. 0.0001

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

227. 0.0001

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

228. 0.0001

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

229. 0.0001

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

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

231. 0.0001

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

232. 0.0001

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

233. 0.0001

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

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

235. 0.0001

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

236. 0.0001

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

237. 0.0001

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

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

239. 0.0001

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

240. 0.0001

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

241. 0.0001

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

242. 0.0001

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

243. 0.0001

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

244. 0.0001

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

245. 0.0001

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

246. 0.0001

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

247. 0.0001

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

248. 0.0001

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

249. 0.0001

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

250. 0.0001

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

251. 0.0001

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

252. 0.0001

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

253. 0.0001

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

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

255. 0.0001

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

256. 0.0001

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

257. 0.0001

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

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

259. 0.0001

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

260. 0.0001

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

261. 0.0001

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

262. 0.0001

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

263. 0.0001

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

264. 0.0001

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

265. 0.0001

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

266. 0.0001

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

267. 0.0001

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

268. 0.0001

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

269. 0.0001

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

270. 0.0001

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

271. 0.0001

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

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

273. 0.0001

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

274. 0.0001

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

275. 0.0001

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

276. 0.0001

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

277. 0.0001

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

278. 0.0001

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

279. 0.0001

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

280. 0.001

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

281. 0.0001

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

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

283. 0.0001

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

284. 0.0001

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

285. 0.0001

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

286. 0.0001

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

287. 0.0001

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

288. 0.0001

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

289. 0.0001

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

290. 0.0001

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

291. 0.0001

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

292. 0.0001

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

293. 0.0001

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

294. 0.0003

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

295. 0.0001

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

296. 0.0001

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

297. 0.0001

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

298. 0.0001

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

299. 0.0001

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

300. 0.0001

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

301. 0.0001

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

302. 0.0001

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

303. 0.0001

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

304. 0.0001

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

305. 0.0001

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

306. 0.0001

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

307. 0.0001

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

308. 0.0001

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

309. 0.0001

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

310. 0.0001

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

311. 0.0001

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

312. 0.0001

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

313. 0.0001

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

314. 0.0001

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

315. 0.0001

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

316. 0.0001

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

317. 0.0001

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

318. 0.0001

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

319. 0.0001

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

320. 0.0001

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

321. 0.0001

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

322. 0.0001

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

323. 0.0001

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

324. 0.0001

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

325. 0.0001

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

326. 0.0001

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

327. 0.0001

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

328. 0.0001

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

329. 0.0001

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

330. 0.0001

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

331. 0.0001

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

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

333. 0.0001

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

334. 0.0001

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

335. 0.0001

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

336. 0.0001

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

337. 0.0001

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

338. 0.0001

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

339. 0.0001

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

340. 0.0001

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

341. 0.0001

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

342. 0.0001

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

343. 0.0001

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

344. 0.0001

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

345. 0.0001

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

346. 0.0001

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

347. 0.0001

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

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

349. 0.0001

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

350. 0.0001

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

351. 0.0001

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

352. 0.0001

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

353. 0.0001

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

354. 0.0001

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

355. 0.0001

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

356. 0.0001

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

357. 0.0001

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

358. 0.0001

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

359. 0.0001

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

360. 0.0001

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

361. 0.0001

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

362. 0.0001

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

363. 0.0001

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

364. 0.0001

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

365. 0.0001

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

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

367. 0.0001

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

368. 0.0001

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

369. 0.0001

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

370. 0.0001

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

371. 0.0001

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

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

373. 0.0001

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

374. 0.0001

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

375. 0.0001

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

376. 0.0001

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

377. 0.0001

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

378. 0.0001

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

379. 0.0001

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

380. 0.0001

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

381. 0.0001

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

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

383. 0.0001

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

384. 0.0001

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

385. 0.0029

     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.13333- 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.8599018543365 AND ville_longitude_deg<2.4067581456635 HAVING distance <= 20 ORDER BY distance ASC

386. 0.0075

     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.13333- 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.4497537413096 AND ville_longitude_deg<2.8169062586904 HAVING distance <= 50 ORDER BY distance ASC

387. 0.0002

     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 (587,595,600,1081,599,592)

388. 0.0003

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (212878,307997,78827,549857,515999,482757,173785,113093,101859,311908,347269,367360,88343,212138,116678,133608,399018,526649,397896,540100,463329,406433,61110,28432,153748,134760,128459,72524,69135,469112,343240,524831,413523,315801,134974,95961,106493,108313,50153,245867,238270,62335,228755,224418,208742,52315,190611,153405)

389. 0.0002

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (212878,307997,78827,549857,515999,482757,173785,113093,101859,311908,347269,367360,88343,212138,116678,133608,399018,526649,397896,540100,463329,406433,61110,28432,153748,134760,128459,72524,69135,469112,343240,524831,413523,315801,134974,95961,106493,108313,50153,245867,238270,62335,228755,224418,208742,52315,190611,153405)

390. 0.0003

     SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=50 AND ss.fami_id=3 ORDER BY ssrubr_order LIMIT 6,100

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

392. 0.0001

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

393. 0.0001

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

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

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

396. 0.0009

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

397. 0.0245

     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'

398. 0.0171

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

398 requetes sql en 0.1853